public JsonResult CreateDetailsJson(List <CuttingSheetDetail> Details) { string errors11 = ""; int test = 0; CuttingSheetDetail Detail = new CuttingSheetDetail(); foreach (CuttingSheetDetail d in Details) { try { Detail = new CuttingSheetDetail(); Detail.CuttingSheetId = int.Parse(d.CuttingSheetId.ToString()); Detail.MaterialId = int.Parse(d.MaterialId.ToString()); Detail.qty = float.Parse(d.qty.ToString()); //get material Material material = materialRepository.GetById(Detail.MaterialId); //check availability of item in warehouse float AvailableQty = materialRepository.AvailableQty(material); if (AvailableQty > Detail.qty) { Detail.status = statusList.InStock; } else { Detail.status = statusList.Purchase; } Detail.IssueQty = 0; db.CuttingSheetDetails.Add(Detail); db.SaveChanges(); //reserve qty in warehouse materialRepository.ReserveQty(material, Detail.qty); db.SaveChanges(); } catch (Exception ex) { DeleteConfirmed(Detail.CuttingSheetId); test = 1; errors11 = errors11 + ex.Message; if (ex.InnerException != null) { if (ex.InnerException.InnerException != null) { errors11 = errors11 + ex.InnerException.InnerException.Message; } } return(Json(errors11)); } } if (test == 1) { return(Json(errors11)); } return(Json("Cutting Sheet Saved Successfully")); }
public JsonResult CreateDetailsJson(List <CuttingSheetDetail> Details) { string errors11 = ""; int aaa = 0; int test = 0; int eid = 0; CuttingSheetDetail EP = new CuttingSheetDetail(); foreach (var d in Details) { CuttingSheetDetail csd = db.CuttingSheetDetails.Find(d.CuttingSheetDetailId); csd.qtyApproved = d.qtyApproved; csd.Remark = d.Remark; csd.Approval = false; db.SaveChanges(); } return(Json("Cutting Sheet Saved Successfully")); }
public JsonResult EditDetailsJson(List <CuttingSheetDetail> Details, int id) { string errors11 = ""; int aaa = 0; int test = 0; int eid = 0; //delete exist var cs = db.CuttingSheets.Find(id); List <CuttingSheetDetail> OldDetails = cs.CuttingSheetDetails.ToList(); foreach (CuttingSheetDetail d in OldDetails) { db.CuttingSheetDetails.Remove(d); } db.SaveChanges(); CuttingSheetDetail EP = new CuttingSheetDetail(); foreach (CuttingSheetDetail d in Details) { try { EP = new CuttingSheetDetail(); EP.CuttingSheetId = int.Parse(d.CuttingSheetId.ToString()); eid = int.Parse(d.CuttingSheetId.ToString()); EP.MaterialId = int.Parse(d.MaterialId.ToString()); Material mm = db.Materials.Find(EP.MaterialId); EP.qty = float.Parse(d.qty.ToString()); float?AvailableQty = mm.qty - mm.Resevedqty - mm.MinReOrder; if (AvailableQty > EP.qty) { EP.status = statusList.InStock; } else { EP.status = statusList.Purchase; } db.CuttingSheetDetails.Add(EP); db.SaveChanges(); var StockIssue = db.StockIssues.Find(eid); mm.Resevedqty = mm.Resevedqty + EP.qty; db.SaveChanges(); } catch (Exception ex) { DeleteConfirmed(eid); test = 1; errors11 = errors11 + ex.Message; if (ex.InnerException != null) { if (ex.InnerException.InnerException != null) { errors11 = errors11 + ex.InnerException.InnerException.Message; } } return(Json(errors11)); } } if (test == 1) { return(Json(errors11)); } return(Json("Cutting Sheet Saved Successfully")); }
public JsonResult EditDetailsJson(List <CuttingSheetDetail> Details, int id) { string errors11 = ""; int test = 0; //delete exist var cs = db.CuttingSheets.Find(id); List <CuttingSheetDetail> OldDetails = cs.CuttingSheetDetails.ToList(); foreach (CuttingSheetDetail d in OldDetails) { db.CuttingSheetDetails.Remove(d); Material material = materialRepository.GetById(d.MaterialId); materialRepository.ReleaseReserveQty(material, d.qty); } db.SaveChanges(); CuttingSheetDetail detail = new CuttingSheetDetail(); foreach (CuttingSheetDetail d in Details) { try { detail = new CuttingSheetDetail(); detail.CuttingSheetId = int.Parse(d.CuttingSheetId.ToString()); detail.MaterialId = int.Parse(d.MaterialId.ToString()); detail.qty = float.Parse(d.qty.ToString()); Material mm = db.Materials.Find(detail.MaterialId); //EP.qty = float.Parse(d.qty.ToString()); Material material = materialRepository.GetById(detail.MaterialId); float? AvailableQty = materialRepository.AvailableQty(material); if (AvailableQty > detail.qty) { detail.status = statusList.InStock; } else { detail.status = statusList.Purchase; } db.CuttingSheetDetails.Add(detail); db.SaveChanges(); materialRepository.ReserveQty(material, detail.qty); materialRepository.Save(); } catch (Exception ex) { DeleteConfirmed(detail.CuttingSheetId); test = 1; errors11 = errors11 + ex.Message; if (ex.InnerException != null) { if (ex.InnerException.InnerException != null) { errors11 = errors11 + ex.InnerException.InnerException.Message; } } return(Json(errors11)); } } if (test == 1) { return(Json(errors11)); } return(Json("Cutting Sheet Saved Successfully")); }