public JsonResult PostEdit_Contract(Contract item) { int Surety1 = 0; int Surety2 = 0; int parner = 0; try { if (Session["iuser"] == null) { throw new Exception(" Session หมดอายุ , กรุณาเข้าสู่ระบบใหม่อีกครั้ง !! "); } item.ContractInsertBy = (Int32)Session["iuser"]; ContractData CD = new ContractData(); CD.Edit_NewContract(item); if (item.CustomerPartnerData != null) { //check insert Partner if (item.CustomerPartner == 0) { parner = CD.Add_Partner(item.CustomerPartnerData); item.CustomerPartner = parner; } else { parner = CD.Update_Partner(item.CustomerPartnerData); } } //check insert Surety1 if (item.CustomerSuretyData1 != null) { if (item.CustomerSurety1 == 0 & item.CustomerSuretyData1 != null) { Surety1 = CD.Add_Surety(item.CustomerSuretyData1); item.CustomerSurety1 = Surety1; } else { Surety1 = CD.Update_Surety(item.CustomerSuretyData1); } } //check insert Surety1 if (item.CustomerSuretyData2 != null) { if (item.CustomerSurety2 == 0 & item.CustomerSuretyData2 != null) { Surety2 = CD.Add_Surety(item.CustomerSuretyData2); item.CustomerSurety2 = Surety2; } else { Surety2 = CD.Update_Surety(item.CustomerSuretyData2); } } //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, item.ContractID); double ContractPayment = 0; List <ProductSelect> listProductsSelect1 = new List <ProductSelect>(); listProductsSelect1 = dataPro.ProductContractSummary(ref ContractPayment, listProductsSelect); item.ContractPayment = Convert.ToDecimal(Math.Round(ContractPayment, 2)); // update จำนวนเงินสินค้าทั้งหมด CD.UpdateContractPayment(item.ContractID, item.ContractCustomerID, ContractPayment); // Update Contract Surety CD.UpdateSurety_In_Contract(item); // คำนวณ ค่างวด / วันสิ้นสุดสัญญา CD.UpdateContractAmount_ContractExpDate(item.ContractCustomerID, item.ContractID); return(Json(new { data = "บันทึกการแก้ไขสัญญาสำเร็จ", success = true }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { data = ex.Message, success = false }, JsonRequestBehavior.AllowGet)); } }
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)); } }