//private List<SIMREG_NEWFORMViewModel> GetNEWFORMDataList(string msisdnTitle, string requestById, string requestTypeId, string deliverById, string fromDate, string toDate)
private List<SIMREG_NEWFORMViewModel> GetNEWFORMDataList(string sidx, string sord, int page, int rows, string msisdnTitle, string requestById, string requestTypeId, string deliverById, string requestFromDate, string requestToDate, string deliverFromDate, string deliverToDate)
{
_boSIMREG_NEWFORM = new BOSIMREG_NEWFORM();
_boSIMREG_REQUESTEDBY = new BOSIMREG_REQUESTEDBY();
_boSIMREG_REQUESTEDTYPE = new BOSIMREG_REQUESTEDTYPE();
_boSIMREG_DELIVEREDBY = new BOSIMREG_DELIVEREDBY();
if (!String.IsNullOrEmpty(requestFromDate))
{
requestFromDate = Convert.ToDateTime(requestFromDate).ToString("dd-MMM-yyyy");
}
if (!String.IsNullOrEmpty(requestToDate))
{
requestToDate = Convert.ToDateTime(requestToDate).ToString("dd-MMM-yyyy");
}
if (!String.IsNullOrEmpty(deliverFromDate))
{
deliverFromDate = Convert.ToDateTime(deliverFromDate).ToString("dd-MMM-yyyy");
}
if (!String.IsNullOrEmpty(deliverToDate))
{
deliverToDate = Convert.ToDateTime(deliverToDate).ToString("dd-MMM-yyyy");
}
List<SIMREG_NEWFORMViewModel> modellist = new List<SIMREG_NEWFORMViewModel>();
var sIMREG_NEWFORMList = _boSIMREG_NEWFORM.GetSIMREG_NEWFORMs(sidx, sord, page, rows, msisdnTitle, requestById, requestTypeId, deliverById, requestFromDate, requestToDate, deliverFromDate, deliverToDate).ToList();
modellist = sIMREG_NEWFORMList.Select(x => new SIMREG_NEWFORMViewModel
{
ID = x.ID,
MSISDNID = x.MSISDNID,
//MSISDNTITLE = _boSIMREG_MSISDN.GetSIMREG_MSISDN(x.MSISDNID).TITLE,
MSISDNTITLE = x.MSISDNTITLE,
REQUESTEDDATE = x.REQUESTEDDATE,
REQUESTEDBYID = x.REQUESTEDBYID,
REQUESTEDBYTITLE = _boSIMREG_REQUESTEDBY.GetSIMREG_REQUESTEDBY(x.REQUESTEDBYID).TITLE,
REQUESTEDTYPEID = x.REQUESTEDTYPEID,
REQUESTEDTYPETITLE = _boSIMREG_REQUESTEDTYPE.GetSIMREG_REQUESTEDTYPE(x.REQUESTEDTYPEID).TITLE,
DELIVEREDBYDATE = x.DELIVEREDBYDATE,
DELIVEREDBYID = x.DELIVEREDBYID,
DELIVEREDBYTITLE = _boSIMREG_DELIVEREDBY.GetSIMREG_DELIVEREDBY(x.DELIVEREDBYID).TITLE,
IDATE = x.IDATE,
IUSER = x.IUSER,
EDATE = x.EDATE,
EUSER = x.EUSER
}).ToList();
return modellist;
}
public void ExportToExcel(SIMREG_NEWFORMSearchViewModel model)
{
//BOUser boUser = new BOUser();
BOSIMREG_NEWFORM boSim = new BOSIMREG_NEWFORM();
ExcelManager ex = new ExcelManager("SimRegisterReport.csv", false);
System.Data.DataSet ds = new System.Data.DataSet();
//boSim.GetSIMREG_NEWFORMs(ds);
boSim.GetSIMREG_NEWFORMs(model.MSISDNTITLE, model.REQUESTEDBYID, model.REQUESTEDBYID, model.DELIVEREDBYID,
model.REQUESTEDDATE.ToString(), model.DELIVEREDBYDATE.ToString(), ds);
ex.ExportData(ds.Tables[0], Response);
}
