public int getCompanyId(string companyName) { query = "select company_id from company_info where company_name ='" + companyName.Trim() + "'"; dataTable = dbReadWrite.selectQuery(query); return(Convert.ToInt32(dataTable.Rows[0]["company_id"])); }
public bool getUser(string userName, string passWord) { query = "select * from user_info where user_name ='" + userName.Trim() + "' and pass='******'"; dataTable = dbReadWrite.selectQuery(query); if (dataTable.Rows.Count == 1) { return(true); } return(false); }
public DataTable RetriveInboxMailQuery(string id) { query = "SELECT * from mail_box where receiver_id='" + id.Trim() + "' and receiver_isdeleted=0"; return(dbReadWrite.selectQuery(query)); }
public DataTable getUserInstance(int id) { query = "select * from user_info where user_id=" + id; dataTable = dbReadWrite.selectQuery(query); return(dataTable); }