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 InsertLoanScale(LoanScaleRate pLoanScaleRate, SqlTransaction pSqlTransaction)
{
const string sqlText = @"INSERT INTO LoanScale(id,ScaleMin, ScaleMax) VALUES(@number,@Min, @Max)";
using (OpenCbsCommand insert = new OpenCbsCommand(sqlText, pSqlTransaction.Connection, pSqlTransaction))
{
SetLoanScale(insert, pLoanScaleRate);
insert.ExecuteNonQuery();
}
}
public void InsertLoanScaleValue(LoanScaleRate lR, SqlTransaction sqlTransac)
{
string sqlText = "INSERT INTO LoanScale(id,ScaleMin, ScaleMax) " +
"VALUES(@number,@Min, @Max)";
SqlCommand insert = new SqlCommand(sqlText, CurrentConnection, sqlTransac);
DatabaseHelper.InsertInt32Param("@number", insert, lR.Number);
DatabaseHelper.InsertInt32Param("@Min", insert, lR.ScaleMin);
DatabaseHelper.InsertInt32Param("@Max", insert, lR.ScaleMax);
insert.ExecuteNonQuery();
}
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 DeleteLoanScaleRate(LoanScaleRate lt)
{
_loanscaleRates.Remove(lt);
int number = 1;
foreach (LoanScaleRate lsr in _loanscaleRates)
{
lsr.Number = number;
number++;
}
}
public void AddLoanScaleRate(LoanScaleRate lt)
{
_loanscaleRates.Add(lt);
}
public void DeleteLoanScale(LoanScaleRate ls)
{
LoanScaleTable lt = LoanScaleTable.GetInstance(_user);
lt.DeleteLoanScaleRate(ls);
}
private static void SetLoanScale(OpenCbsCommand octCmd, LoanScaleRate pLoanScaleRate)
{
octCmd.AddParam("@number", pLoanScaleRate.Number);
octCmd.AddParam("@Min", pLoanScaleRate.ScaleMin);
octCmd.AddParam("@Max", pLoanScaleRate.ScaleMax);
}