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