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)); } } } } }