public void AddLoanScale(LoanScaleRate lR)
{
LoanScaleTable lT = LoanScaleTable.GetInstance(_user);
if (lR.ScaleMin == 0)
{
throw new OpenCbsAccountException(OpenCbsAccountExceptionsEnum.LoanScaleTableMin);
}
if (lR.ScaleMax == 0)
{
throw new OpenCbsAccountException(OpenCbsAccountExceptionsEnum.LoanScaleTableMax);
}
lR.Number = lT.LoanScaleRates.Count + 1;
lT.AddLoanScaleRate(lR);
using (SqlConnection conn = _loanScaleManager.GetConnection())
using (SqlTransaction sqlTransac = conn.BeginTransaction())
{
try
{
_loanScaleManager.InsertLoanScale(lR, sqlTransac);
sqlTransac.Commit();
}
catch (Exception ex)
{
sqlTransac.Rollback();
throw ex;
}
}
}
