try to make use of optional parameter in your function like this
public Cust trial_test(string username, string password, int group = 0)
{
if (group == 0)
{
var query = from s in db.Subscriptions
join u in db.UserDetails on s.sUID equals u.uID
where s.ExpiryDate >= DateTime.Now &&
s.sPID.Value == 163 &&
s.All.Value != true &&
u.uUsername == username &&
u.uPassword == password
select u;
return query.FirstOrDefault();
}
else
{
var query = from s in db.Subscriptions
join u in db.UserDetails on s.sUID equals u.uID
where s.ExpiryDate >= DateTime.Now &&
s.sPID.Value == 163 &&
s.All.Value == true &&
u.uUsername == username &&
u.uPassword == password
select u;
return query.FirstOrDefault();
}
}
Cust user = repository.trial_test(credentials[0], credentials[1],group:1);
//pass the value 1 to the group to execute the second query else it will call the first one.