public ActionResult DeleteConfirmed(int id) { ImportInWard importInWard = db.ImportInWards.Find(id); db.ImportInWards.Remove(importInWard); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ImportInWardId,InWardNo,InWardDate,InvoiceNo,InvoiceDate,PartyName,TotalQty,TotalMRPValue,TotalCost,ImportDate")] ImportInWard importInWard) { if (ModelState.IsValid) { db.Entry(importInWard).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(importInWard)); }
public ActionResult Create([Bind(Include = "ImportInWardId,InWardNo,InWardDate,InvoiceNo,InvoiceDate,PartyName,TotalQty,TotalMRPValue,TotalCost,ImportDate")] ImportInWard importInWard) { if (ModelState.IsValid) { db.ImportInWards.Add(importInWard); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(importInWard)); }
public async Task <IActionResult> Create([Bind("ImportInWardId,InWardNo,InWardDate,InvoiceNo,InvoiceDate,PartyName,TotalQty,TotalMRPValue,TotalCost,ImportDate")] ImportInWard importInWard) { if (ModelState.IsValid) { _context.Add(importInWard); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(importInWard)); }
// GET: ImportInWards/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ImportInWard importInWard = db.ImportInWards.Find(id); if (importInWard == null) { return(HttpNotFound()); } return(View(importInWard)); }
public UploadReturns UploadExcel(UploadTypes UploadType, HttpPostedFileBase FileUpload, string targetpath, bool IsVat, bool IsLocal) { using (VoyagerContext db = new VoyagerContext()) { //UploadType = "InWard"; List <string> data = new List <string>(); if (FileUpload != null) { // tdata.ExecuteCommand("truncate table OtherCompanyAssets"); if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { string filename = FileUpload.FileName; //TODO: pass from calling function of http post // string targetpath = Server.MapPath("~/Doc/"); FileUpload.SaveAs(targetpath + filename); string pathToExcelFile = targetpath + filename; var connectionString = ""; if (filename.EndsWith(".xls")) { connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile); } else if (filename.EndsWith(".xlsx")) { connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile); } var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString); var ds = new DataSet(); adapter.Fill(ds, "ExcelTable"); DataTable dtable = ds.Tables["ExcelTable"]; string sheetName = "Sheet1"; var excelFile = new ExcelQueryFactory(pathToExcelFile); if (UploadType == UploadTypes.Purchase) { var currentImports = from a in excelFile.Worksheet <ImportPurchase>(sheetName) select a; foreach (var a in currentImports) { try { a.ImportTime = DateTime.Now; //Vat & Local a.IsLocal = IsLocal; a.IsVatBill = IsVat; db.ImportPurchases.Add(a); db.SaveChanges(); } catch (DbEntityValidationException) { //TODO: need to handel this return(UploadReturns.Error); } } } else if (UploadType == UploadTypes.SaleItemWise) { var currentImports = from a in excelFile.Worksheet <ImportSaleItemWiseVM>(sheetName) select a; foreach (var a in currentImports) { try { a.ImportTime = DateTime.Now; a.IsDataConsumed = false; db.ImportSaleItemWises.Add(ImportSaleItemWiseVM.ToTable(a)); db.SaveChanges(); } catch (DbEntityValidationException) { //TODO: need to handel this return(UploadReturns.Error); } } } else if (UploadType == UploadTypes.SaleRegister) { var currentImports = from a in excelFile.Worksheet <ImportSaleRegister>(sheetName) select a; foreach (var a in currentImports) { try { a.ImportTime = DateTime.Now; a.IsConsumed = false; db.ImportSaleRegisters.Add(a); db.SaveChanges(); } catch (DbEntityValidationException) { //TODO: need to handel this return(UploadReturns.Error); } } } else if (UploadType == UploadTypes.InWard) { var currentImports = from a in excelFile.Worksheet <ImportInWard>(sheetName) select a; foreach (var a in currentImports) { try { // Inward No Inward Date Invoice No Invoice Date Party Name Total Qty Total MRP Value Total Cost ImportInWard inw = new ImportInWard { ImportDate = DateTime.Today, InvoiceDate = a.InvoiceDate, InvoiceNo = a.InvoiceNo, InWardDate = a.InWardDate, InWardNo = a.InWardNo, PartyName = a.PartyName, TotalCost = a.TotalCost, TotalMRPValue = a.TotalMRPValue, TotalQty = a.TotalQty }; db.ImportInWards.Add(inw); db.SaveChanges(); } catch (DbEntityValidationException) { //TODO: need to handel this return(UploadReturns.Error); } } } else { return(UploadReturns.ImportNotSupported); } //deleting excel file from folder if ((System.IO.File.Exists(pathToExcelFile))) { System.IO.File.Delete(pathToExcelFile); } return(UploadReturns.Success); }//end of if contexttype else { return(UploadReturns.NotExcelType); } }//end of if fileupload else { return(UploadReturns.FileNotFound); } } }//end of function
[Authorize(Roles = "Admin,PowerUser")] public async Task <IActionResult> Edit(int id, [Bind("ImportInWardId,InWardNo,InWardDate,InvoiceNo,InvoiceDate,PartyName,TotalQty,TotalMRPValue,TotalCost,ImportDate")] ImportInWard importInWard) { if (id != importInWard.ImportInWardId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(importInWard); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ImportInWardExists(importInWard.ImportInWardId)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(importInWard)); }
public JsonResult UploadExcel(/*string UploadType,*/ UploadTypes UploadType, HttpPostedFileBase FileUpload) { //UploadType = "InWard"; List<string> data = new List<string>(); if (FileUpload != null) { // tdata.ExecuteCommand("truncate table OtherCompanyAssets"); if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { string filename = FileUpload.FileName; string targetpath = Server.MapPath("~/Doc/"); FileUpload.SaveAs(targetpath + filename); string pathToExcelFile = targetpath + filename; var connectionString = ""; if (filename.EndsWith(".xls")) { connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile); } else if (filename.EndsWith(".xlsx")) { connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile); } var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString); var ds = new DataSet(); adapter.Fill(ds, "ExcelTable"); DataTable dtable = ds.Tables["ExcelTable"]; string sheetName = "Sheet1"; var excelFile = new ExcelQueryFactory(pathToExcelFile); //if (OfTypes != null && OfTypes == UploadTypes.SaleItemWise) //{ // //alert message for invalid file format // data.Add("<ul>"); // data.Add("<li>SaleItemWise of UploadType Was Selected</li>"); // data.Add("</ul>"); // data.ToArray(); // return Json(data, JsonRequestBehavior.AllowGet); //} //else if (UploadType == UploadTypes.Purchase) { var currentImports = from a in excelFile.Worksheet<ImportPurchase>(sheetName) select a; foreach (var a in currentImports) { try { a.ImportTime = DateTime.Now; db.ImportPurchases.Add(a); db.SaveChanges(); } catch (DbEntityValidationException) { //TODO: need to handel this throw; } } } else if (UploadType == UploadTypes.SaleItemWise) { var currentImports = from a in excelFile.Worksheet<ImportSaleItemWiseVM>(sheetName) select a; foreach (var a in currentImports) { try { a.ImportTime = DateTime.Now; a.IsDataConsumed = false; db.ImportSaleItemWises.Add(ImportSaleItemWiseVM.ToTable(a)); db.SaveChanges(); } catch (DbEntityValidationException) { //TODO: need to handel this throw; } } } else if (UploadType == UploadTypes.SaleRegister) { var currentImports = from a in excelFile.Worksheet<ImportSaleRegister>(sheetName) select a; foreach (var a in currentImports) { try { a.ImportTime = DateTime.Now; a.IsConsumed = false; db.ImportSaleRegisters.Add(a); db.SaveChanges(); } catch (DbEntityValidationException) { //TODO: need to handel this throw; } } } else if (UploadType == UploadTypes.InWard) { var currentImports = from a in excelFile.Worksheet<ImportInWard>(sheetName) select a; foreach (var a in currentImports) { try { // Inward No Inward Date Invoice No Invoice Date Party Name Total Qty Total MRP Value Total Cost ImportInWard inw = new ImportInWard { ImportDate = DateTime.Today, InvoiceDate = a.InvoiceDate, InvoiceNo = a.InvoiceNo, InWardDate = a.InWardDate, InWardNo = a.InWardNo, PartyName = a.PartyName, TotalCost = a.TotalCost, TotalMRPValue = a.TotalMRPValue, TotalQty = a.TotalQty }; db.ImportInWards.Add(inw); db.SaveChanges(); } catch (DbEntityValidationException) { //TODO: need to handel this throw; } } } else { //alert message for invalid file format data.Add("<ul>"); data.Add("<li>Upload Type select is not supported</li>"); data.Add("</ul>"); data.ToArray(); return Json(data, JsonRequestBehavior.AllowGet); } //deleting excel file from folder if ((System.IO.File.Exists(pathToExcelFile))) { System.IO.File.Delete(pathToExcelFile); } return Json("success", JsonRequestBehavior.AllowGet); }//end of if contexttype else { //alert message for invalid file format data.Add("<ul>"); data.Add("<li>Only Excel file format is allowed</li>"); data.Add("</ul>"); data.ToArray(); return Json(data, JsonRequestBehavior.AllowGet); } }//end of if fileupload else { data.Add("<ul>"); if (FileUpload == null) data.Add("<li>Please choose Excel file</li>"); data.Add("</ul>"); data.ToArray(); return Json(data, JsonRequestBehavior.AllowGet); } }//end of function