public static DataSet GetReadCompanys(string userid) { return(DataHelper.GetList("select c.Id,C.companyName from companyUser u inner join companyTable c on u.companyID=c.ID where u.UserID=" + userid)); }
public static DataSet GetledGroups(string userid) { return(DataHelper.GetList("Select ID,GroupName from GroupTable where LeadID=" + userid)); }
public static DataSet GetledCompanys(string userid) { return(DataHelper.GetList("Select ID,CompanyName from CompanyTable where Owner=" + userid)); }
public static void UpdateCaseTypeData(ArrayList sqls) { DataHelper.ExecuteQuerysArray(sqls); }
public static string GetNewEmailCount(string userName) { string sql = "select count(*) from MessageReceivedList where status ='0' and Owner= '{0}'"; return(DataHelper.ExecuteScalar(string.Format(sql, userName)).ToString()); }
public static string GetAlertCommentCount(string sql) { return(DataHelper.ExecuteScalar(sql).ToString()); }