public int getLatestMiNumber()
{
_q = new QueryExecutor();
return(Convert.ToInt32(_q.Aggregate
("select max(mi_number) from material_inword")));
}
public bool check(string CardNumber)
{
_q = new QueryExecutor();
return(Convert.ToBoolean(_q.Aggregate(
string.Format("select count(*) from cardregistration where cardnumber='{0}'", CardNumber))));
}
public int getCount(string PolicyNumber)
{
_q = new QueryExecutor();
return(Convert.ToInt32(_q.Aggregate(
string.Format("select count(*) from cardregistration where policynumber='{0}'", PolicyNumber))));
}
public bool ShopAuth()
{
_qe = new QueryExecutor();
return(Convert.ToBoolean(_qe
.Aggregate(string
.Format("select count(*) from shopdetails where (email='{0}' or mobilenumber='{0}') and password='******'",
this.UserName, this.Password))));
}
public int GetLastId(string comapny)
{
_q = new QueryExecutor();
return(Convert
.ToInt32(_q
.Aggregate(string
.Format("select count(*) from policies where company='{0}'", comapny))));
}
internal bool UserAuth()
{
_qe = new QueryExecutor();
return(Convert.ToBoolean(_qe
.Aggregate(string
.Format("select count(*) from cardregistration where cardnumber='{0}' and pin='{1}' and " +
" isactive='true' and isblocked='false'",
this.UserName, this.Password))));
}
