public ActionResult MonthlyReport()
{
var viewmodel = new MonthlyReportGenerateViewModel();
ViewBag.DisplayResults = false;
return(View(viewmodel));
}
public ActionResult MonthlyReport(MonthlyReportGenerateViewModel viewmodel)
{
if (ModelState.IsValid) // validate file exist
{
if (viewmodel.ExcelFile != null && viewmodel.ExcelFile.ContentLength > 0)
{
SaveUploadedFile(viewmodel.ExcelFile, Server.MapPath("~/Uploads/MonthlyReport/"));
// convert the uploaded file into datatable, then add/update db entities.
var dtBarsHours = ImportUtils.ImportXlsxToDataTable(viewmodel.ExcelFile.InputStream, true, 1);
var excelData = dtBarsHours.AsEnumerable().Select(row =>
{
string account = row["Account"].ToString();
if (account.StartsWith("-"))
{
account = account.Remove(0, 1);
}
return(new MonthlyReportDataViewModel()
{
AccountNumber = account,
Date = DateTime.Parse(row["Date"].ToString()),
Amount = decimal.Parse(row["Amount"].ToString()),
Description = row["Description"].ToString(),
Category = row["Category"].ToString(),
});
}).ToList();
viewmodel.Data = excelData;
ViewBag.DisplayResults = true;
}
}
else
{
ViewBag.DisplayResults = false;
}
return(View(viewmodel));
}
