public ActionResult reportProperties() { CReportPeriod crp = new CReportPeriod(); List <CReportPeriod> periodList = crp.getReportPeriods(); SelectList sl = new SelectList(periodList, "reportPeriodId", "reportPeriodDescr"); ViewBag.periodList = sl; return(View()); }
public ActionResult reportInterval() { pdsTidRedLiveEntities db = new pdsTidRedLiveEntities(); ViewBag.dFrom = DateTime.Today; ViewBag.dTo = DateTime.Today.AddDays(-30); List <customer> custList = db.customer.Where(x => x.active == true).OrderBy(x => x.custName).ToList(); ViewBag.custList = new SelectList(custList, "customerID", "custName"); List <userTbl> userList = db.userTbl.OrderBy(x => x.userName).ToList(); ViewBag.userList = new SelectList(userList, "userId", "userName"); CReportPeriod crp = new CReportPeriod(); List <CReportPeriod> periodList = crp.getReportPeriods(); SelectList sl = new SelectList(periodList, "reportPeriodId", "reportPeriodDescr"); ViewBag.periodList = sl; return(View()); }