private ActionResult MTD(DateTime startDate, DateTime endDate, int dealerID, string saleType) //PRoof of concept { MTDViewModel viewModel = new MTDViewModel(User.Identity.GetUserId <int>(), startDate, endDate, dealerID, saleType); var mtdData = DORHelper.ToDataTable(viewModel.MTDReport.ToList()); //ClosedXmlProofOfConcept(mtdData); var mtdRecords = new List <dynamic>(mtdData.Rows.Count); //var test = _dorService.GetMonthToDateObjects(startDate, endDate, dealerID, saleType).ToList(); //test.Where(t => t.deal_frnt_end != null).ForEach(t => t.deal_frnt_end = (decimal)Math.Round((double)t.deal_frnt_end, 4)); //TODO: Push this to a Function (Common class?) later foreach (DataRow row in mtdData.Rows) { var obj = (IDictionary <string, object>) new ExpandoObject(); foreach (DataColumn col in mtdData.Columns) { obj.Add(col.ColumnName, row[col]); } mtdRecords.Add(obj); } viewModel.MTDRecords = mtdRecords; return(View(viewModel)); }
public ActionResult Excel(FormCollection col) { DateTime sDate = col["StartDate"] == null ? DateTime.Now : Convert.ToDateTime(col["StartDate"].ToString()); DateTime eDate = col["EndDate"] == null ? DateTime.Now : Convert.ToDateTime(col["EndDate"].ToString()); List <MTDFilterObj> filters = new List <MTDFilterObj>(); //ID Fields foreach (MTDFilterField filter in _mtdFilterFields) { string val = col[filter.FieldName]; if (val != null && val != "0") //If filter exists and if Filter is not set to "All" { filters.Add(filter.GetFilterObject(Convert.ToInt32(val))); //AddFilter to list of Filters to Use } } int dealerID = col["Dealership.DealerID"] == null ? 1 : Convert.ToInt32(col["Dealership.DealerID"].ToString()); //string saleType = col["VehicleType.VehicleTypeId"] == null ? "0" : col["VehicleType.VehicleTypeId"].ToString(); //return MTD(sDate, eDate, dealerID, saleType); var mtdData = DORHelper.ToDataTable(new MTDViewModel(User.Identity.GetUserId <int>(), sDate, eDate, dealerID, filters).MTDReport.ToList()); ClosedXmlProofOfConcept(mtdData); TempData["StartDate"] = sDate.ToShortDateString(); TempData["EndDate"] = eDate.ToShortDateString(); return(RedirectToAction("Index", "MTD", new { dealerID = dealerID })); }
public ActionResult SalesRecap(string startDate = null, string endDate = null) { startDate = (startDate == null) ? defaultStartDate : startDate; endDate = (endDate == null) ? defaultEndDate : endDate; SalesRecapViewModel viewModel = new SalesRecapViewModel(User.Identity.GetUserId <int>(), Convert.ToDateTime(startDate), Convert.ToDateTime(endDate)); var recapData = DORHelper.ToDataTable(viewModel.SalesRecapReport.ToList()); //var recapData = DORHelper.ToDataTable(_dorService.GetDOR1234RecapReport(startDate, endDate).ToList()); recapData = DORHelper.TransposeTable(recapData); var recapRecords = new List <dynamic>(recapData.Rows.Count); //TODO: Push this to a Function (Common class?) later foreach (DataRow row in recapData.Rows) { var obj = (IDictionary <string, object>) new ExpandoObject(); foreach (DataColumn col in recapData.Columns) { obj.Add(col.ColumnName, row[col]); } recapRecords.Add(obj); } viewModel.RecapRecords = recapRecords; //viewModel.FinanceRecapObjects = _dorService.GetFinanceRecapReport(startDate, endDate); return(View(viewModel)); }