internal MassMailSendInfo GetMailAndUserToSendMail(string SecheduleDate) { const string sp = "[dbo].[Admin_MassMail_GetMailForSend]"; List <KeyValuePair <string, object> > Param = new List <KeyValuePair <string, object> >(); Param.Add(new KeyValuePair <string, object>("@ScheduleDate", SecheduleDate)); SQLHandler objHandler = new SQLHandler(); try { DataSet ds = objHandler.ExecuteAsDataSet(sp, Param); if (ds != null && ds.Tables.Count > 0) { MassMailSendInfo objMail = DataSourceHelper.FillObject <MassMailSendInfo>(ds.Tables[0].CreateDataReader()); List <UserInfo> lstUsers = new List <UserInfo>(); lstUsers = DataSourceHelper.FillCollection <UserInfo>(ds.Tables[1]); objMail.MailToUsers = lstUsers; return(objMail); } else { return(null); } } catch (Exception ex) { throw ex; } }
public MassMailSendInfo GetMailAndUserToSendMail(string SecheduleDate) { MassMailProvider objProvider = new MassMailProvider(); MassMailSendInfo objInfo = objProvider.GetMailAndUserToSendMail(SecheduleDate); SageFrameConfig pagebase = new SageFrameConfig(); objInfo.MailFrom = pagebase.GetSettingValueByIndividualKey(SageFrameSettingKeys.SuperUserEmail); objInfo.MessageBody = objInfo.MessageBody.Replace("##HostUrl##", GetCurrnetHostURL); return(objInfo); }