//
// GET: /NEWFORM/
public ActionResult Index()
{
_boSIMREG_REQUESTEDBY = new BOSIMREG_REQUESTEDBY();
var sIMREG_REQUESTEDBYList = SelectListItemExtension.PopulateDropdownList(_boSIMREG_REQUESTEDBY.GetSIMREG_REQUESTEDBYs().ToList<BESIMREG_REQUESTEDBY>(), "REQUESTEDBYID", "TITLE").ToList();
var sIMREG_NEWFORMSearchViewModel = new SIMREG_NEWFORMSearchViewModel();
sIMREG_NEWFORMSearchViewModel.ddlREQUESTEDBYS = sIMREG_REQUESTEDBYList;
//return View();
return View(sIMREG_NEWFORMSearchViewModel);
}
public ActionResult Search()
{
try
{
_boSIMREG_REQUESTEDBY = new BOSIMREG_REQUESTEDBY();
_boSIMREG_REQUESTEDTYPE = new BOSIMREG_REQUESTEDTYPE();
_boSIMREG_DELIVEREDBY = new BOSIMREG_DELIVEREDBY();
var sIMREG_NEWFORMSearchViewModel = new SIMREG_NEWFORMSearchViewModel();
var sIMREG_REQUESTEDBYList = SelectListItemExtension.PopulateDropdownList(_boSIMREG_REQUESTEDBY.GetSIMREG_REQUESTEDBYs().ToList<BESIMREG_REQUESTEDBY>(), "REQUESTEDBYID", "TITLE").ToList();
var sIMREG_REQUESTEDTYPEList = SelectListItemExtension.PopulateDropdownList(_boSIMREG_REQUESTEDTYPE.GetSIMREG_REQUESTEDTYPEs().ToList<BESIMREG_REQUESTEDTYPE>(), "REQUESTEDTYPEID", "TITLE").ToList();
var sIMREG_DELIVEREDBYList = SelectListItemExtension.PopulateDropdownList(_boSIMREG_DELIVEREDBY.GetSIMREG_DELIVEREDBYs().ToList<BESIMREG_DELIVEREDBY>(), "DELIVEREDBYID", "TITLE").ToList();
sIMREG_NEWFORMSearchViewModel.ddlREQUESTEDBYS = sIMREG_REQUESTEDBYList;
sIMREG_NEWFORMSearchViewModel.ddlREQUESTEDTYPES = sIMREG_REQUESTEDTYPEList;
sIMREG_NEWFORMSearchViewModel.ddlDELIVEREDBYS = sIMREG_DELIVEREDBYList;
return View(sIMREG_NEWFORMSearchViewModel);
}
catch (Exception ex)
{
ExceptionHelper.ExceptionMessageFormat(ex);
return View("Error", ex);
}
}
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);
}
