public ActionResult Quotation(HttpPostedFileBase file1) { try { if (file1 == null) { throw new Exception("No file was uploaded"); } //convert excel to list List <StationerySupplier> list = StationerySupplierQuote.ConvertToList(file1.InputStream); //validate data StationerySupplierQuote.ValidateData(list); //upload data _stationerySupplierRepo.UpdateAll(list); ViewBag.Success = "Successfully uploaded"; return(View()); } catch (Exception e) { ViewBag.Error = e.Message; return(View()); } }
//GET: Suppliers/QuotationTemplate (will download Excel file directly) public ActionResult QuotationTemplate() { //get data to put into excel List <StationerySupplierQuote> slist = _stationerySupplierRepo.GetAll().Select(x => new StationerySupplierQuote { ItemCode = x.ItemNum, ItemName = x.Stationery.Description, SupplierCode = x.SupplierId, SupplierName = x.Supplier.SupplierName, Rank = x.Rank, UnitPrice = x.Price }).ToList(); byte[] filecontent = StationerySupplierQuote.ConvertListToByte(slist); return(File(filecontent, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "quotations.xlsx")); }