public void AddPayment() { var tblInstallment = new tblInstallment { Id = DId, Installment_PaymentType_Id = DPaymentTypeId, InstallmentAmount = DAmount, InstallmentReceiptNumber = DReceiptNumber, InstallmentTotalPaid = DTotalPaid, InstallmentRemaining = DRemaining, InstallmentPaymentDate = DPaymentDate, InstallmentDelayDay = DDelayDay, InstallmentDescription = DDescription }; using (var dbLoanEntities = new dbLoanEntities()) { dbLoanEntities.tblInstallment.Attach(tblInstallment); dbLoanEntities.Entry(tblInstallment).Property(x => x.Installment_PaymentType_Id).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentAmount).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentReceiptNumber).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentTotalPaid).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentRemaining).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentPaymentDate).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentDelayDay).IsModified = true; dbLoanEntities.Entry(tblInstallment).Property(x => x.InstallmentDescription).IsModified = true; dbLoanEntities.SaveChanges(); } }
public void Add() { tblInstallment tblInstallment = new tblInstallment { Installment_Loan_Id = DLoanId, Installment_PaymentType_Id = DPaymentTypeId, InstallmentDueAmount = DDueAmount, InstallmentAmount = DAmount, InstallmentReceiptNumber = DReceiptNumber, InstallmentTotalPaid = DTotalPaid, InstallmentRemaining = DRemaining, InstallmentPaymentDate = DPaymentDate, InstallmentDueDate = DDueDate, InstallmentDelayDay = DDelayDay, InstallmentDescription = DDescription }; _dbLoanEntities.tblInstallment.Add(tblInstallment); _dbLoanEntities.SaveChanges(); }