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