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;
}
}
}
public void SelectLoanScale()
{
LoanScaleTable loanscaleTable = LoanScaleTable.GetInstance(_user);
string sqlText = "Select id, ScaleMin, ScaleMax FROM LoanScale";
SqlCommand select = new SqlCommand(sqlText, CurrentConnection);
using (SqlDataReader reader = select.ExecuteReader())
{
while (reader.Read())
{
LoanScaleRate lR = new LoanScaleRate();
lR.Number = DatabaseHelper.GetInt32("id", reader);
lR.ScaleMin = DatabaseHelper.GetInt32("ScaleMin", reader);
lR.ScaleMax = DatabaseHelper.GetInt32("ScaleMax", reader);
loanscaleTable.AddLoanScaleRate(lR);
}
}
}
public void SelectLoanScales()
{
LoanScaleTable loanscaleTable = LoanScaleTable.GetInstance(_user);
const string sqlText = @"SELECT id, ScaleMin, ScaleMax
FROM LoanScale";
using (SqlConnection conn = GetConnection())
{
using (OpenCbsCommand select = new OpenCbsCommand(sqlText, conn))
{
using (OpenCbsReader reader = select.ExecuteReader())
{
if (reader.Empty)
{
return;
}
while (reader.Read())
{
loanscaleTable.AddLoanScaleRate(GetLoanScale(reader));
}
}
}
}
}
