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);
}
