public List <SmsBase> SMSBase_GetAll(SmsBase.SmsBaseGet smsGet)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@CreateDateFrom", SqlDbType.DateTime, smsGet.CreateDateFrom);
parameters.AddInputParameter("@CreateDateTo", SqlDbType.DateTime, smsGet.CreateDateTo);
List <SmsBase> result = Execute_GetList(SmsMaterializer.Instance, "SMSBase_GetAll", parameters);
return(result);
}
public ActionResult GetSMSBaseReport(SMSBaseReportModel model)
{
SmsBase.SmsBaseGet get = new SmsBase.SmsBaseGet()
{
CreateDateFrom = model.SmsBaseDateFrom,
CreateDateTo = model.SmsBaseDateTo.AddDays(1)
};
List <SmsBase> listSmsBase = smsBusinessLogic.SMSBase_GetAll(get);
SMSBaseReport printedForm = new SMSBaseReport(listSmsBase, model.SmsBaseDateFrom, model.SmsBaseDateTo);
return(File(printedForm.GetExcel(),
System.Net.Mime.MediaTypeNames.Application.Octet, string.Format("Отчет по отправленным смс сообщениям.xls")));
}
public List <SmsBase> SMSBase_GetAll(SmsBase.SmsBaseGet smsGet)
{
return(SmsMessageDao.Instance.SMSBase_GetAll(smsGet));
}
