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();
}
}
private void SetEconomicActivity(Loan pLoan, SqlTransaction sqlTransaction)
{
// Write EconomicActivityLoanHistory object
EconomicActivityLoanHistory activityLoanHistory;
if (pLoan.Project.Client is Person)
{
if (
!_econimcActivityServices.EconomicActivityLoanHistoryExists(pLoan.Id, pLoan.Project.Client.Id,
sqlTransaction))
{
activityLoanHistory = new EconomicActivityLoanHistory
{
Contract = pLoan,
Deleted = false,
Group = null,
Person = pLoan.Project.Client,
EconomicActivity = ((Person) pLoan.Project.Client).Activity
};
_econimcActivityServices.AddEconomicActivityLoanHistory(activityLoanHistory, sqlTransaction);
}
else
{
if (_econimcActivityServices.EconomicActivityLoanHistoryDeleted(pLoan.Id,
pLoan.Project.Client.Id,
sqlTransaction))
_econimcActivityServices.UpdateDeletedEconomicActivityLoanHistory(pLoan.Id,
pLoan.Project.Client.Id,
((Person)
pLoan.Project.Client).
Activity.Id,
sqlTransaction, false);
}
}
else if (pLoan.Project.Client is Group)
{
foreach (Member member in ((Group) pLoan.Project.Client).Members)
{
if (
!_econimcActivityServices.EconomicActivityLoanHistoryExists(pLoan.Id, member.Tiers.Id,
sqlTransaction))
{
activityLoanHistory = new EconomicActivityLoanHistory
{
Contract = pLoan,
Deleted = false,
Group = (Group) pLoan.Project.Client,
Person = member.Tiers,
EconomicActivity = ((Person) member.Tiers).Activity
};
_econimcActivityServices.AddEconomicActivityLoanHistory(activityLoanHistory, sqlTransaction);
}
else
{
if (_econimcActivityServices.EconomicActivityLoanHistoryDeleted(pLoan.Id, member.Tiers.Id,
sqlTransaction))
_econimcActivityServices.UpdateDeletedEconomicActivityLoanHistory(pLoan.Id,
member.Tiers.Id,
((Person) member.Tiers)
.Activity.Id,
sqlTransaction, false);
}
}
}
else if (pLoan.Project.Client is Corporate)
{
if (((Corporate) pLoan.Project.Client).Activity == null)
throw new OpenCbsTiersSaveException(OpenCbsTiersSaveExceptionEnum.EconomicActivityIsNull);
if (
!_econimcActivityServices.EconomicActivityLoanHistoryExists(pLoan.Id,
pLoan.Project.Client.Id,
sqlTransaction))
{
activityLoanHistory = new EconomicActivityLoanHistory
{
Contract = pLoan,
Deleted = false,
Group = null,
Person = pLoan.Project.Client,
EconomicActivity = ((Corporate) pLoan.Project.Client).Activity
};
_econimcActivityServices.AddEconomicActivityLoanHistory(activityLoanHistory, sqlTransaction);
}
else
{
if (_econimcActivityServices.EconomicActivityLoanHistoryDeleted(pLoan.Id,
pLoan.Project.Client.Id,
sqlTransaction))
_econimcActivityServices.UpdateDeletedEconomicActivityLoanHistory(pLoan.Id,
pLoan.Project.Client.
Id,
((Corporate)
pLoan.Project.Client)
.Activity.Id,
sqlTransaction, false);
}
}
}
public void AddEconomicActivityLoanHistory(EconomicActivityLoanHistory activityLoanHistory, SqlTransaction sqlTransaction)
{
_doam.AddEconomicActivityLoanHistory(activityLoanHistory, sqlTransaction);
}