public ActionResult TargerEditbyDb(List <TargetDetailsVm> targetDetailsVm) { var firstOrDefault = targetDetailsVm.FirstOrDefault(); if (firstOrDefault != null) { int targetid = firstOrDefault.TargetId; int dbId = firstOrDefault.DbId; Db.tbld_Target_Details.RemoveRange( Db.tbld_Target_Details.Where(x => x.target_id == targetid && x.db_id == dbId)); Db.SaveChanges(); foreach (var targetDetailsVmitem in targetDetailsVm) { int total = (int)((targetDetailsVmitem.QtyinCs * targetDetailsVmitem.PackSize) + targetDetailsVmitem.QtyinPs); if (total > 0) { tbld_Target_Details tbldTargetDetails = new tbld_Target_Details { target_id = targetDetailsVmitem.TargetId, db_id = targetDetailsVmitem.DbId, sku_id = targetDetailsVmitem.SkuId, Pack_size = targetDetailsVmitem.PackSize, qtyinCS = targetDetailsVmitem.QtyinCs, qtyinPS = targetDetailsVmitem.QtyinPs, total_Qty = total }; Db.tbld_Target_Details.Add(tbldTargetDetails); Db.SaveChanges(); } } Db.tbld_Target_PSR_Details.RemoveRange(Db.tbld_Target_PSR_Details.Where(x => x.target_id == targetid && x.db_id == dbId)); Db.SaveChanges(); return(RedirectToAction("Edit", "Target", new { id = targetid })); } return(null); }
public ActionResult UploadTargetbyDb(HttpPostedFileBase fileUpload) { int targetid = 0; List <tbld_Target_Details> tbldTargetDetails = new List <tbld_Target_Details>(); if (fileUpload == null) { return(View("UploadTarget")); } if (fileUpload.ContentType == "application/vnd.ms-excel" || fileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { string filename = fileUpload.FileName; if (filename.EndsWith(".xlsx")) { string targetpath = Server.MapPath("~/Upload/"); fileUpload.SaveAs(targetpath + filename); var pathToExcelFile = targetpath + filename; var excelFile = new ExcelQueryFactory(pathToExcelFile); var worksheetNames = excelFile.GetWorksheetNames(); string sheetName = worksheetNames.First(); var tgtList = from a in excelFile.Worksheet <TargetDetailsVm>(sheetName) select a; foreach (var tgtListitem in tgtList) { tbld_Target_Details targetitem = new tbld_Target_Details() { target_id = tgtListitem.TargetId, db_id = tgtListitem.DbId, sku_id = tgtListitem.SkuId, Pack_size = tgtListitem.PackSize, qtyinCS = tgtListitem.QtyinCs, qtyinPS = tgtListitem.QtyinPs, total_Qty = (tgtListitem.QtyinCs * tgtListitem.PackSize) + tgtListitem.QtyinPs }; targetid = tgtListitem.TargetId; tbldTargetDetails.Add(targetitem); Db.tbld_Target_Details.Add(targetitem); } int tergetCount = Db.tbld_Target_Details.Count(x => x.target_id == targetid); if (tergetCount <= 0) { if (tgtList.Count() == tbldTargetDetails.Count()) { Db.SaveChanges(); TempData["alertbox"] = "success"; TempData["alertboxMsg"] = " Target Upload Successfully"; return(RedirectToAction("Index")); } } else { TempData["alertbox"] = "error"; TempData["alertboxMsg"] = " Target Already uploaded"; return(RedirectToAction("Index")); } } } return(RedirectToAction("Index")); }