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