public JsonResult PostAdd_NewContract(Contract item) { ContractData CD = new ContractData(); int Surety1 = 0; int Surety2 = 0; int ContractID = 0; int parner = 0; try { if (Session["iuser"] == null) { throw new Exception(" Session หมดอายุ , กรุณาเข้าสู่ระบบใหม่อีกครั้ง !! "); } item.ContractInsertBy = (Int32)Session["iuser"]; ContractID = CD.Add_NewContract(item); if (item.CustomerSuretyData1 != null) { Surety1 = CD.Add_Surety(item.CustomerSuretyData1); } if (item.CustomerSuretyData2 != null) { Surety2 = CD.Add_Surety(item.CustomerSuretyData2); } if (item.CustomerPartnerData != null) { parner = CD.Add_Partner(item.CustomerPartnerData); } item.ContractID = ContractID; item.CustomerSurety1 = Surety1; item.CustomerSurety2 = Surety2; item.CustomerPartner = parner; //Update Product this Contract CD.Update_Product_customer(item); // getProduct By Contract ProductData dataPro = new ProductData(); IList <ProductSelect> listProductsSelect = new List <ProductSelect>(); listProductsSelect = dataPro.GetProductCustomer(item.ContractCustomerID, ContractID); item.ContractPayment = Convert.ToDecimal(listProductsSelect.Sum(c => c.ProductPrice)); // Update Contract Surety CD.UpdateSurety_In_Contract(item); return(Json(new { ContractID = ContractID, data = "บันทึกการทำสัญญาสำเร็จ", success = true }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { ContractID = 0, data = ex.Message, success = false }, JsonRequestBehavior.AllowGet)); } }