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