public int UpdateComputationBankRatingSetup(TRPComputationBankRatingSetupObject setup)
{
if (setup == null)
{
throw new ArgumentNullException("Computation bank rating scoring can't be null");
}
var sqlText = "UPDATE t_rpt_computation_bank_rating_setup SET ri_type_id = @ri_type_id, param = @param, description = @description, component_weight = @component_weight, start_validity_date = @start_validity_date, end_validity_date = @end_validity_date, last_modified = @last_modified, modified_by = @modified_by 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("@ri_type_id", setup.ri_type_id);
cmd.Parameters.AddWithValue("@param", setup.param);
cmd.Parameters.AddWithValue("@description", setup.description);
cmd.Parameters.AddWithValue("@component_weight", setup.component_weight);
cmd.Parameters.AddWithValue("@start_validity_date", setup.start_validity_date);
cmd.Parameters.AddWithValue("@end_validity_date", setup.end_validity_date);
if (setup.start_validity_date == null || setup.start_validity_date == DateTime.MinValue)
{
cmd.Parameters.Add("@start_validity_date", SqlDbType.DateTime).SqlValue = DateTime.MinValue;
}
else
{
cmd.Parameters.Add("@start_validity_date", SqlDbType.DateTime).SqlValue = setup.start_validity_date;
}
if (setup.end_validity_date == null || setup.end_validity_date == DateTime.MinValue)
{
cmd.Parameters.Add("@end_validity_date", SqlDbType.DateTime).SqlValue = DBNull.Value;
}
else
{
cmd.Parameters.Add("@end_validity_date", SqlDbType.DateTime).SqlValue = setup.end_validity_date;
}
cmd.Parameters.AddWithValue("@bank_rating_code", setup.bank_rating_code);
_rowsAffected = cmd.ExecuteNonQuery();
}
scope.Complete();
}
return(_rowsAffected);
}
protected void btnSave_Click(object sender, EventArgs e)
{
_bankRatingModel = new TRPComputationBankRatingSetupObject();
try
{
ValidateBusinessData();
_bankRatingModel.bank_rating_code = this.txtBankRatingCode.Value.Trim();
_bankRatingModel.ri_type_id = Convert.ToInt32(this.cmbRiType.SelectedValue.ToString());
_bankRatingModel.param = this.txtParam.Value.Trim();
_bankRatingModel.description = this.txtDescription.Value.Trim();
_bankRatingModel.component_weight = this.txtComponentWeight.Value.Trim();
_bankRatingModel.start_validity_date = Convert.ToDateTime(txtStartValidityDate.Text);
_bankRatingModel.end_validity_date = DateTime.MinValue;
_bankRatingModel.created_date = DateTime.Now;
_bankRatingModel.created_by = currentUser;
_bankRatinghandler = new TRPTComputationBankRatingSetupHandler();
var rowsAffected = _bankRatinghandler.SaveComputationBankRatingSetup(_bankRatingModel);
divAlert.Visible = true;
divAlert.Attributes.Add("class", "alert alert-success alert-dismissible");
if (rowsAffected > 0)
{
lblError.Text = "Management component on bank rating saved successfully";
}
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-success alert-dismissible");
//_bankRatingModel.last_modified = DateTime.Now;
//_bankRatingModel.modified_by = currentUser;
//_bankRatinghandler.UpdateComputationBankRatingSetup(_bankRatingModel);
}
LogUtitlity.LogToText(ex.ToString());
}
}
public int SaveComputationBankRatingSetup(TRPComputationBankRatingSetupObject setup)
{
if (setup == null)
{
throw new ArgumentNullException("Computation bank rating setup can't be null");
}
var sqlText = "INSERT INTO t_rpt_computation_bank_rating_setup(bank_rating_code, ri_type_id, param, description, component_weight, start_validity_date, end_validity_date, created_date, created_by) VALUES(@bank_rating_code, @ri_type_id, @param, @description, @component_weight, @start_validity_date, @end_validity_date, @created_date, @created_by)";
using (SqlCommand cmd = new SqlCommand(sqlText, DatabaseOps.OpenSqlConnection()))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@bank_rating_code", setup.bank_rating_code);
cmd.Parameters.AddWithValue("@ri_type_id", setup.ri_type_id);
cmd.Parameters.AddWithValue("@param", setup.param);
cmd.Parameters.AddWithValue("@description", setup.description);
cmd.Parameters.AddWithValue("@component_weight", setup.component_weight);
if (setup.start_validity_date == null || setup.start_validity_date == DateTime.MinValue)
{
cmd.Parameters.Add("@start_validity_date", SqlDbType.DateTime).SqlValue = DateTime.MinValue;
}
else
{
cmd.Parameters.Add("@start_validity_date", SqlDbType.DateTime).SqlValue = setup.start_validity_date;
}
if (setup.end_validity_date == null || setup.end_validity_date == DateTime.MinValue)
{
cmd.Parameters.Add("@end_validity_date", SqlDbType.DateTime).SqlValue = DBNull.Value;
}
else
{
cmd.Parameters.Add("@end_validity_date", SqlDbType.DateTime).SqlValue = setup.end_validity_date;
}
cmd.Parameters.AddWithValue("@created_date", setup.created_date);
cmd.Parameters.AddWithValue("@created_by", setup.created_by);
_rowsAffected = cmd.ExecuteNonQuery();
}
return(_rowsAffected);
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (base.Error.Count > 0)
{
this.frmBankRating.Visible = false;
return;
}
//Check if the request is an update request
string bankRatingCode = Request.QueryString[SharedConst.QUERY_STRING_BRC];
if (!string.IsNullOrWhiteSpace(bankRatingCode))
{
this.txtBankRatingCode.Value = bankRatingCode.Trim();
this.txtBankRatingCode.Disabled = true;
_bankRatingModel = _bankRatinghandler.GetBankRatingSetupDetails(bankRatingCode);
this.cmbRiType.SelectedValue = _bankRatingModel.ri_type_id.ToString();
this.txtParam.Value = _bankRatingModel.param;
this.txtDescription.Value = _bankRatingModel.description;
this.txtComponentWeight.Value = _bankRatingModel.component_weight;
this.txtStartValidityDate.Text = _bankRatingModel.start_validity_date.ToString();
}
if (!Page.IsPostBack)
{
riType.GetAllRiTypes(this.cmbRiType);
this.cmbRiType.Items.Insert(0, "-choose one-");
}
}
catch (Exception ex)
{
LogUtitlity.LogToText(ex.ToString());
LogUtitlity.LogToText(ex.ToString());
}
}
public TRPTComputationBankRatingSetupHandler()
{
_computationSetupObj = new TRPComputationBankRatingSetupObject();
}
public TRPTComputationBankRatingSetupHandler(TRPComputationBankRatingSetupObject setupobj)
{
this._computationSetupObj = setupobj;
_computationSetupObj = new TRPComputationBankRatingSetupObject();
}
