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