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