public TRPTComputationBankRatingScoringHandler(TRPTComputationBankRatingScoringObject scoring)
{
this._computationSscoring = scoring;
_resultTable = new DataTable();
_databaseOperations = new DatabaseOps();
_util = new Utility();
}
protected void btnSaveChanges_ServerClick(object sender, EventArgs e)
{
int rowsAffected = 0;
try
{
//Validate business data
ValidateBusinessData();
//contiue to save all changes
for (int x = 0; x < this.gridviewRatingSetup.Rows.Count; x++)
{
var selectedRow = this.gridviewRatingSetup.SelectedRow;
_scoreobject = new TRPTComputationBankRatingScoringObject();
_scoreobject.bank_rating_code = this.gridviewRatingSetup.Rows[x].Cells[1].Text;
_scoreobject.ri_type_id = Convert.ToInt32(this.cmbRiType.SelectedValue);
_scoreobject.ri_id = Convert.ToInt32(this.cmbReportingInstitution.SelectedValue);
_scoreobject.rating_date = Convert.ToDateTime(this.txtWorkcollectionDate.Text.Trim());
_scoreobject.rating_score = this.gridviewRatingSetup.Rows[x].Cells[5].Text;
_scoreobject.last_modified = DateTime.Now;
_scoreobject.modified_by = currentUser;
//Check bank rating code exists
bool codeExists = _scorehandler.CheckDataExists(this.gridviewRatingSetup.Rows[x].Cells[1].Text);
divAlert.Visible = true;
divAlert.Attributes.Add("class", "alert alert-success alert-dismissible");
if (codeExists == true)
{
rowsAffected = _scorehandler.UpdateComputationBankRatingScore(_scoreobject);
lblError.Text = "Management component on bank rating score updated successfully";
}
else
{
rowsAffected = _scorehandler.SaveComputationBankRatingScore(_scoreobject);
lblError.Text = "Management component on bank rating score saved successfully";
}
}
//if (rowsAffected > 0)
//{
//}
//else
// lblError.Text = "An error occured while saving changes";
}
catch (Exception ex)
{
if (ex.ToString().Contains("PRIMARY KEY"))
{
divAlert.Visible = true;
divAlert.Attributes.Add("class", "alert alert-warning alert-dismissible");
lblError.Text = "Bank rating code already exists";
}
LogUtitlity.LogToText(ex.ToString());
}
}
public int SaveComputationBankRatingScore(TRPTComputationBankRatingScoringObject scoring)
{
if (scoring == null)
{
throw new ArgumentNullException("Computation bank rating scoring can't be null");
}
var sqlText = "INSERT INTO t_rpt_computation_bank_rating_scoring(bank_rating_code, ri_type_id, ri_id, rating_date, rating_score, last_modified, modified_by) VALUES(@bank_rating_code, @ri_type_id, @ri_id, @rating_date, @rating_score, @last_modified, @modified_by)";
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
using (SqlCommand cmd = new SqlCommand(sqlText, DatabaseOps.OpenSqlConnection()))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@bank_rating_code", scoring.bank_rating_code);
cmd.Parameters.AddWithValue("@ri_type_id", scoring.ri_type_id);
cmd.Parameters.AddWithValue("@ri_id", scoring.ri_id);
cmd.Parameters.AddWithValue("@rating_date", scoring.rating_date);
if (string.IsNullOrWhiteSpace(scoring.rating_score))
{
cmd.Parameters.AddWithValue("@rating_score", SharedConst.CONST_MONEY_INT_VALUE);
}
else
{
cmd.Parameters.AddWithValue("@rating_score", scoring.rating_score);
}
if (scoring.last_modified == null || scoring.last_modified == DateTime.MinValue)
{
cmd.Parameters.AddWithValue("@last_modified", DateTime.Now);
}
else
{
cmd.Parameters.AddWithValue("@last_modified", scoring.last_modified);
}
if (string.IsNullOrWhiteSpace(scoring.modified_by))
{
cmd.Parameters.AddWithValue("@modified_by", DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@modified_by", scoring.modified_by);
}
_rowsAffected = cmd.ExecuteNonQuery();
}
scope.Complete();
}
return(_rowsAffected);
}
public int UpdateComputationBankRatingScore(TRPTComputationBankRatingScoringObject scoring)
{
if (scoring == null)
{
throw new ArgumentNullException("Computation bank rating scoring can't be null");
}
var sqlText = "UPDATE t_rpt_computation_bank_rating_scoring SET rating_score = @rating_score WHERE bank_rating_code = @bank_rating_code";
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
using (SqlCommand cmd = new SqlCommand(sqlText, DatabaseOps.OpenSqlConnection()))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@rating_score", scoring.rating_score);
cmd.Parameters.AddWithValue("@bank_rating_code", scoring.bank_rating_code);
_rowsAffected = cmd.ExecuteNonQuery();
}
scope.Complete();
}
return(_rowsAffected);
}
