Example #1
0
        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();
            }
        }
Example #2
0
        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();
        }