internal void LoadAll(Entities.TourCostRuleCollection rules) { using (SqlConnection cnn = new SqlConnection(sqlConnectionString)) { using (SqlCommand cmd = new SqlCommand("TourCostRulesGetAll", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cnn.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader != null && reader.HasRows) { while (reader.Read()) { Entities.TourCostRule rule = new Entities.TourCostRule(); rule.Id = Utils.GetSafeInt32(reader, "RuleId"); rule.Name = Utils.GetSafeString(reader, "RuleName"); rule.Formula.Currency = DomainModel.Currencies.GetById(Utils.GetSafeInt32(reader, "CurrencyId")); rule.Formula.PriceOperation = (Entities.TourCostFormula.PriceOperations)Utils.GetSafeInt32(reader, "PriceOperationId"); rule.Formula.Value = Utils.GetSafeDecimal(reader, "RuleValue"); rule.Formula.ValueOperation = (Entities.TourCostFormula.ValueOperations)Utils.GetSafeInt32(reader, "ValueOperationId"); rule.IsDirty = false; rules.Add(rule); } } } } } }
internal bool Insert(Entities.TourCostRule rule) { bool res = false; using (SqlConnection cnn = new SqlConnection(sqlConnectionString)) { using (SqlCommand cmd = new SqlCommand("TourCostRuleAdd", cnn)) { cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add(new SqlParameter("@RuleId", rule.Id)); cmd.Parameters.Add(new SqlParameter("@RuleName", rule.Name)); cmd.Parameters.Add(new SqlParameter("@RuleValue", rule.Formula.Value)); cmd.Parameters.Add(new SqlParameter("@PriceOperationId", (Int32)rule.Formula.PriceOperation)); cmd.Parameters.Add(new SqlParameter("@ValueOperationId", (Int32)rule.Formula.ValueOperation)); cmd.Parameters.Add(new SqlParameter("@CurrencyId", rule.Formula.Currency == null ? -1 : rule.Formula.Currency.Id)); cnn.Open(); object id = cmd.ExecuteScalar(); if (id != null) { rule.Id = Convert.ToInt32(id); res = true; } } } return(res); }
internal bool Update(Entities.TourCostRule rule, Entities.TourCostRuleConstraint constraint) { bool res = false; try { this.query.Parameters.Clear(); this.query.Parameters.Add(new SqlParameter("@RuleId", rule.Id)); this.query.Parameters.Add(new SqlParameter("@ConstraintName", constraint.Name)); this.query.Parameters.Add(new SqlParameter("@ConstraintTypeId", constraint.ConstraintType.Id)); this.query.Parameters.Add(new SqlParameter("@ConstraintId", constraint.Id)); int affected; res = this.query.ExecuteUpdateProc("TourCostRuleConstraintUpdateById", out affected); } catch (Exception ex) { try { DomainModel.Application.Status.Update( StatusController.Abstract.StatusTypes.Error, "", ex.Message); } catch { } } return(res); }
public bool LoadByRule(Entities.TourCostRule rule) { bool res = false; try { this.query.Parameters.Clear(); this.query.Parameters.Add(new SqlParameter("@RuleId", rule.Id)); res = this.query.ExecuteReader("TourCostRuleConstraintGetByRuleId", MapConstraintToObject, rule); } catch (Exception ex) { try { DomainModel.Application.Status.Update( StatusController.Abstract.StatusTypes.Error, "", ex.Message); } catch { } } return(res); }
public FrmRuleConstraintEditor(Entities.TourCostRule rule, Entities.TourCostRuleConstraint constraintToEdit) : this(rule) { this.editConstraint = constraintToEdit; this.editConstraint.CopyTo(this.constraint); PrepareForEdit(); }
private void btnRemoveRule_Click(object sender, System.EventArgs e) { Entities.TourCostRule rule = (Entities.TourCostRule)dgvRules.SelectedItem; if (rule != null) { Presentation.Controllers.TourFinance.DeleteRule(rule); } }
public FrmRuleEditor(Entities.TourCostRule editRule) : this() { this.editRule = editRule; this.editRule.CopyTo(this.rule); SelectPriceOperation(this.rule.Formula.PriceOperation); SelectValueOperation(this.rule.Formula.ValueOperation, this.rule.Formula.Currency); this.tbxValue.Text = Convert.ToString(this.rule.Formula.Value); }
protected void MapConstraintToObject(SqlDataReader reader, object userData) { Entities.TourCostRuleConstraint con = new Entities.TourCostRuleConstraint(); con.Id = Utils.GetSafeInt32(reader, "ConstraintId"); con.Name = Utils.GetSafeString(reader, "ConstraintName"); con.ConstraintType = DomainModel.TourCostConstraintTypes.GetById( Utils.GetSafeInt32(reader, "ConstraintTypeId")); con.IsDirty = false; Entities.TourCostRule rule = (Entities.TourCostRule)userData; rule.Constraints.Add(con); }
public FrmRuleEditor() { this.rule = new Entities.TourCostRule(); InitializeComponent(); CreateControls(); SetupControls(); BindControlsData(); SelectValueOperation(this.rule.Formula.ValueOperation, this.rule.Formula.Currency); SelectPriceOperation(this.rule.Formula.PriceOperation); this.tbxValue.Text = Convert.ToString(this.rule.Formula.Value); }
internal bool Delete(Entities.TourCostRule rule) { bool res = false; using (SqlConnection cnn = new SqlConnection(sqlConnectionString)) { using (SqlCommand cmd = new SqlCommand("TourCostRuleDeleteById", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@RuleId", rule.Id)); cnn.Open(); int affected = cmd.ExecuteNonQuery(); res = (affected > 0); } } return(res); }
internal bool Update(Entities.TourCostRule rule) { bool res = false; using (SqlConnection cnn = new SqlConnection(sqlConnectionString)) { using (SqlCommand cmd = new SqlCommand("TourCostRuleUpdateById", cnn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@RuleId", rule.Id)); cmd.Parameters.Add(new SqlParameter("@RuleName", rule.Name)); cmd.Parameters.Add(new SqlParameter("@RuleValue", rule.Formula.Value)); cmd.Parameters.Add(new SqlParameter("@PriceOperationId", (Int32)rule.Formula.PriceOperation)); cmd.Parameters.Add(new SqlParameter("@ValueOperationId", (Int32)rule.Formula.ValueOperation)); cmd.Parameters.Add(new SqlParameter("@CurrencyId", rule.Formula.Currency == null? -1 : rule.Formula.Currency.Id)); cnn.Open(); int affected = cmd.ExecuteNonQuery(); res = (affected > 0); } } return(res); }
internal bool Save(Entities.TourCostRule rule) { throw new NotImplementedException(); }
public FrmRuleConstraintEditor(Entities.TourCostRule rule) : this() { this.rule = rule; }