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 GetTime(string companyID, string caseID)
{
return(DataHelper.ExecuteScalar(string.Format("select max(createon) from notetable where companyid={0} and caseid={1}", companyID, caseID)).ToString());
}
public static string GetAlertCommentCount(string sql)
{
return(DataHelper.ExecuteScalar(sql).ToString());
}