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)))); }