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