public void UpdateInstallment(DateTime date, int id, int number) { // Update installement in database const string q = @"UPDATE Installments SET expected_date = @expectedDate WHERE contract_id = @contractId AND number = @number"; using (var conn = GetConnection()) using (var c = new OpenCbsCommand(q, conn)) { //primary key = contractId + number c.AddParam("@contractId", id); c.AddParam("@number", number); c.AddParam("@expectedDate", date); c.ExecuteNonQuery(); c.ResetParams(); c.CommandText = @"UPDATE dbo.Installments SET start_date = @start_date WHERE contract_id = @contractId AND number = @number"; c.AddParam("@contractId", id); c.AddParam("@number", number + 1); c.AddParam("@start_date", date); c.ExecuteNonQuery(); } }
public void AddInstallments(List <Installment> pInstallments, int pLoanId, SqlTransaction pSqlTransac) { const string q = @"INSERT INTO Installments( expected_date, interest_repayment, capital_repayment, contract_id, number, paid_interest, paid_capital, fees_unpaid, paid_date, paid_fees, comment, pending, start_date, olb, commission, paid_commission, last_interest_accrual_date, extra_amount_1, extra_amount_2) VALUES ( @expectedDate, @interestsRepayment, @capitalRepayment, @contractId, @number, @paidInterests, @paidCapital, @feesUnpaid, @paidDate, @paid_fees, @comment, @pending, @start_date, @olb, @commission, @paidCommission, @lastInterestAccrualDate, @extra_amount_1, @extra_amount_2)"; using (var c = new OpenCbsCommand(q, pSqlTransac.Connection, pSqlTransac)) { foreach (var installment in pInstallments) { SetInstallment(installment, pLoanId, c); c.ExecuteNonQuery(); c.ResetParams(); } } }
public void AddInstallments(List<Installment> pInstallments, int pLoanId, SqlTransaction pSqlTransac) { const string q = @"INSERT INTO Installments( expected_date, interest_repayment, capital_repayment, contract_id, number, paid_interest, paid_capital, fees_unpaid, paid_date, paid_fees, comment, pending, start_date, olb) VALUES ( @expectedDate, @interestsRepayment, @capitalRepayment, @contractId, @number, @paidInterests, @paidCapital, @feesUnpaid, @paidDate, @paid_fees, @comment, @pending, @start_date, @olb)"; using(OpenCbsCommand c = new OpenCbsCommand(q, pSqlTransac.Connection, pSqlTransac)) { foreach(Installment installment in pInstallments) { SetInstallment(installment,pLoanId, c); c.ExecuteNonQuery(); c.ResetParams(); } } }
public void UpdateInstallment(DateTime date, int id, int number) { // Update installement in database const string q = @"UPDATE Installments SET expected_date = @expectedDate WHERE contract_id = @contractId AND number = @number"; using (SqlConnection conn = GetConnection()) using (OpenCbsCommand c = new OpenCbsCommand(q, conn)) { //primary key = contractId + number c.AddParam("@contractId", id); c.AddParam("@number", number); c.AddParam("@expectedDate", date); c.ExecuteNonQuery(); c.ResetParams(); c.CommandText = @"UPDATE dbo.Installments SET start_date = @start_date WHERE contract_id = @contractId AND number = @number"; c.AddParam("@contractId", id); c.AddParam("@number", number + 1); c.AddParam("@start_date", date); c.ExecuteNonQuery(); } }