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