public void UpdateLoanScaleTableInstance()
{
using (SqlConnection conn = _loanScaleManager.GetConnection())
using (SqlTransaction sqlTransac = conn.BeginTransaction())
{
LoanScaleTable lT = LoanScaleTable.GetInstance(_user);
try
{
_loanScaleManager.Delete(sqlTransac);
int i = 1;
foreach (LoanScaleRate lR in lT.LoanScaleRates)
{
lR.Number = i;
_loanScaleManager.InsertLoanScale(lR, sqlTransac);
i++;
}
sqlTransac.Commit();
}
catch (Exception ex)
{
sqlTransac.Rollback();
throw ex;
}
}
}
