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