public int GetIDFromEmail(string Email) { string StrProc = CustStoredProc.GetIDFromMail; Dictionary <string, object> Parameters = new Dictionary <string, object>(); Parameters.Add("@Email", Email); return(Convert.ToInt32(dbMan.ExecuteScalar(StrProc, Parameters))); }
public int Getcountofrequests() { string query = "select Count(*) from Requests_History "; return((int)dbMan.ExecuteScalar(query)); }
public int GetcountofUsers() { string query = "select Count(*) from Login_Info "; return((int)dbMan.ExecuteScalar(query)); }
public int CountBooks() { string query = "select Count(*) from Books "; return((int)dbMan.ExecuteScalar(query)); }