public ActionResult Upload(HttpPostedFileBase file) { if (file != null && file.ContentLength > 0) { var fileName = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/App_Data/uploads"), fileName); var extension = Path.GetExtension(file.FileName); if (extension != ".xlsx" && extension != ".csv") { var model = new FileUploadModel(); model.Error = "Wrong extension. Please select either excel or csv file"; return View("Index", model); } file.SaveAs(path); var taxCalculationBll = new TaxCalculationBll(); var summary = taxCalculationBll.Upload(path, extension); return View("Summary", summary); } return View("Index"); }
public void ParseExcel_Valid() { var path = @"D:\\dotnet-projects\\TaxtCalculator_test_data\\tax_calculator_test_data_ex.xlsx"; var taxCalculationBll = new TaxCalculationBll(); var result = taxCalculationBll.Upload(path, ".xlsx"); OutputValid("Valid taxes", result.ValidTaxes); OutputInvalid("Invalid taxes", result.InvalidTaxes); }