public DataTable GetTobeTrigger()
{
string sql1 = "Select TimerID,WhereC0ndition,MailSubject,BoadyHeader,MailCategory,SearchValue from tblservicetimer where TriggerStatus=0";
DataTable tb = Mycommon.GetDataTable(sql1, "Get To be trigger");
return(tb);
}
public List <EmailInforType.EssencialDecissionType> GetEmailDecissionList()
{
List <EmailInforType.EssencialDecissionType> _EmailList = new List <EmailInforType.EssencialDecissionType>();
string sql1 = "Select SysID from ecoessencialdecission where status=1";
DataTable tb = new DataTable();
tb = Mycommon.GetDataTable(sql1, "Get Email List");
if (tb != null)
{
foreach (DataRow r in tb.Rows)
{
EmailInforType.EssencialDecissionType onemail = new EmailInforType.EssencialDecissionType();
string respond = GetExistEssencialDecission(int.Parse(r["Sysid"].ToString()), out onemail);
if (respond == "True")
{
_EmailList.Add(onemail);
}
}
}
return(_EmailList);
}