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