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