public void InsertData(string ticketId, string new_ticketId, string username, DateTime createdDate) { try { var prodInfo = slmdb.kkslm_tr_productinfo.Where(p => p.slm_TicketId == ticketId).FirstOrDefault(); if (prodInfo != null) { kkslm_tr_productinfo new_prodInfo = new kkslm_tr_productinfo() { slm_TicketId = new_ticketId, slm_InterestedProd = prodInfo.slm_InterestedProd, slm_LicenseNo = prodInfo.slm_LicenseNo, slm_YearOfCar = prodInfo.slm_YearOfCar, slm_YearOfCarRegis = prodInfo.slm_YearOfCarRegis, slm_ProvinceRegis = prodInfo.slm_ProvinceRegis, slm_Brand = prodInfo.slm_Brand, slm_Model = prodInfo.slm_Model, slm_Submodel = prodInfo.slm_Submodel, slm_DownPayment = prodInfo.slm_DownPayment, slm_DownPercent = prodInfo.slm_DownPercent, slm_CarPrice = prodInfo.slm_CarPrice, slm_FinanceAmt = prodInfo.slm_FinanceAmt, slm_PaymentTerm = prodInfo.slm_PaymentTerm, slm_PaymentType = prodInfo.slm_PaymentType, slm_BalloonAmt = prodInfo.slm_BalloonAmt, slm_BalloonPercent = prodInfo.slm_BalloonPercent, slm_PlanType = prodInfo.slm_PlanType, slm_CoverageDate = prodInfo.slm_CoverageDate, slm_AccType = prodInfo.slm_AccType, slm_AccPromotion = prodInfo.slm_AccPromotion, slm_AccTerm = prodInfo.slm_AccTerm, slm_Interest = prodInfo.slm_Interest, slm_Invest = prodInfo.slm_Invest, slm_LoanOd = prodInfo.slm_LoanOd, slm_LoanOdTerm = prodInfo.slm_LoanOdTerm, slm_Ebank = prodInfo.slm_Ebank, slm_Atm = prodInfo.slm_Atm, slm_OtherDetail_1 = prodInfo.slm_OtherDetail_1, slm_OtherDetail_2 = prodInfo.slm_OtherDetail_2, slm_OtherDetail_3 = prodInfo.slm_OtherDetail_3, slm_OtherDetail_4 = prodInfo.slm_OtherDetail_4, slm_CarType = prodInfo.slm_CarType }; slmdb.kkslm_tr_productinfo.AddObject(new_prodInfo); } else { throw new Exception("ไม่พบ Ticket Id " + ticketId + " ใน Table kkslm_tr_productinfo"); } } catch (Exception ex) { throw ex; } }
public void InsertData(LeadData leadData, string UserId) { try { kkslm_tr_productinfo prodInfo = new kkslm_tr_productinfo(); prodInfo.slm_TicketId = leadData.TicketId; prodInfo.slm_InterestedProd = leadData.InterestedProd; prodInfo.slm_LicenseNo = leadData.LicenseNo; prodInfo.slm_YearOfCar = leadData.YearOfCar; prodInfo.slm_YearOfCarRegis = leadData.YearOfCarRegis; prodInfo.slm_ProvinceRegis = leadData.ProvinceRegis; prodInfo.slm_Brand = leadData.Brand; prodInfo.slm_Model = leadData.Model; prodInfo.slm_Submodel = leadData.Submodel; prodInfo.slm_DownPayment = leadData.DownPayment; prodInfo.slm_DownPercent = leadData.DownPercent; prodInfo.slm_CarPrice = leadData.CarPrice; prodInfo.slm_FinanceAmt = leadData.FinanceAmt; prodInfo.slm_PaymentTerm = leadData.PaymentTerm; prodInfo.slm_PaymentType = leadData.PaymentType; prodInfo.slm_BalloonAmt = leadData.BalloonAmt; prodInfo.slm_BalloonPercent = leadData.BalloonPercent; prodInfo.slm_PlanType = leadData.PlanType; prodInfo.slm_CoverageDate = leadData.CoverageDate; prodInfo.slm_AccType = leadData.AccType; prodInfo.slm_AccPromotion = leadData.AccPromotion; prodInfo.slm_AccTerm = leadData.AccTerm; prodInfo.slm_Interest = leadData.Interest; prodInfo.slm_Invest = leadData.Invest; prodInfo.slm_LoanOd = leadData.LoanOd; prodInfo.slm_LoanOdTerm = leadData.LoanOdTerm; prodInfo.slm_Ebank = leadData.Ebank; prodInfo.slm_Atm = leadData.Atm; prodInfo.slm_OtherDetail_1 = leadData.OtherDetail_1; prodInfo.slm_OtherDetail_2 = leadData.OtherDetail_2; prodInfo.slm_OtherDetail_3 = leadData.OtherDetail_3; prodInfo.slm_OtherDetail_4 = leadData.OtherDetail_4; prodInfo.slm_CarType = leadData.CarType; slmdb.kkslm_tr_productinfo.AddObject(prodInfo); slmdb.SaveChanges(); } catch (Exception ex) { throw ex; } }