public void AddEconomicActivityLoanHistory(EconomicActivityLoanHistory activityLoanHistory, SqlTransaction sqlTransaction) { const string sqlText = @"INSERT INTO EconomicActivityLoanHistory ([contract_id],[person_id],[group_id],[economic_activity_id],[deleted]) VALUES (@contract_id, @person_id, @group_id, @economic_activity_id, @deleted)"; using (OpenCbsCommand insert = new OpenCbsCommand(sqlText, sqlTransaction.Connection, sqlTransaction)) { insert.AddParam("@contract_id", activityLoanHistory.Contract.Id); insert.AddParam("@person_id", activityLoanHistory.Person.Id); if (activityLoanHistory.Group != null) { insert.AddParam("@group_id", activityLoanHistory.Group.Id); } else { insert.AddParam("@group_id", null); } insert.AddParam("@economic_activity_id", activityLoanHistory.EconomicActivity.Id); insert.AddParam("@deleted", activityLoanHistory.Deleted); insert.ExecuteNonQuery(); RefreshCache(); } }
public void AddEconomicActivityLoanHistory(EconomicActivityLoanHistory activityLoanHistory, SqlTransaction sqlTransaction) { _doam.AddEconomicActivityLoanHistory(activityLoanHistory, sqlTransaction); }