private void btnShowRules_Click(object sender, RoutedEventArgs e)
{
lstRules.Items.Clear();
List <string> listProp = new List <string>();
using (var db = new RulesModelContainer())
{
var query = from rule in db.RulesSet
orderby rule.Id
select rule;
foreach (var item in query)
{
listProp.Clear();
var query2 = from r in db.RulesDefSet
orderby r.Id
where r.RulesId == item.Id
select r;
foreach (var item2 in query2)
{
listProp.Add(ConvertToString(item2.Prop));
}
lstRules.Items.Add(RebuiltRule(listProp, ConvertToString(item.Result), 'y'));
}
}
}
private void btnBigDelete_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show("Esta a punto de ELIMINAR todas las reglas de la base de datos, ¿Desea Continuar?", "Eliminar Todo", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
using (var db = new RulesModelContainer())
{
var query = from myvar in db.RulesSet
orderby myvar.Id
select myvar;
foreach (var item in query)
{
db.RulesSet.Remove(item);
}
var query2 = from m in db.RulesDefSet
orderby m.Id
select m;
foreach (var item2 in query2)
{
db.RulesDefSet.Remove(item2);
}
db.SaveChanges();
}
}
}
private void btnCreateRule_Click(object sender, RoutedEventArgs e)
{
if (lstProp3.Items.Count > 0 && txtResult.Text != "")
{
using (var db = new RulesModelContainer())
{
if (ConvertToNumber(ReturnToPropAtm(txtResult.Text), NegValue(txtResult.Text)) != 0)
{
Rules rule = new Rules();
rule.Result = ConvertToNumber(ReturnToPropAtm(txtResult.Text), NegValue(txtResult.Text));
db.RulesSet.Add(rule);
foreach (var item in lstProp3.Items)
{
RulesDef r = new RulesDef();
r.Prop = ConvertToNumber(ReturnToPropAtm(item.ToString()), NegValue(item.ToString()));
db.RulesDefSet.Add(r);
}
db.SaveChanges();
}
else
{
MessageBox.Show("La conclusion no es valida");
}
}
}
else
{
MessageBox.Show("La regla es invalida");
}
}
public void ContentLoad()
{
using (var db = new RulesModelContainer())
{
var query = from myvar in db.DictionarySet
orderby myvar.Id
select myvar;
//PropAtm = new ObservableCollection<Dictionary>(query.ToList());
}
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
using (var db = new RulesModelContainer())
{
foreach (var item in lstProp.Items)
{
db.DictionarySet.Add(new Dictionary()
{
PropAtm = item.ToString()
});
}
db.SaveChanges();
}
}
private void btnShowActuals_Click(object sender, RoutedEventArgs e)
{
using (var db = new RulesModelContainer())
{
var query = from myvar in db.DictionarySet
orderby myvar.Id
select myvar;
lstProp2.Items.Clear();
foreach (var item in query)
{
lstProp2.Items.Add(item.PropAtm);
}
}
}
private void setRules(RulesClass rule)
{
List <string> listProp = new List <string>();
int cont = 0;
using (var db = new RulesModelContainer())
{
var query = from ru in db.RulesSet
orderby ru.Id
select ru;
foreach (var item in query)
{
cont++;
if (cont == rule.id)
{
listProp.Clear();
var query2 = from r in db.RulesDefSet
orderby r.Id
where r.RulesId == item.Id
select r;
foreach (var item2 in query2)
{
listProp.Add(ConvertToString(item2.Prop));
}
lstExplanation.Items.Add(RebuiltRule(listProp, ConvertToString(item.Result), 'y'));
if (item.Result != rule.list[0])
{
for (int i = 0; i < listProp.Count; i++)
{
if (listProp[i] == ConvertToString(rule.list[0]) || listProp[i] == ConvertToString(rule.list[0] * -1))
{
listProp.RemoveAt(i);
listProp.Add(ConvertToString(item.Result * -1));
}
}
lstExplanation.Items.Add(RebuiltRule(listProp, ConvertToString(rule.list[0]), 'y'));
}
}
}
}
}
private int ConvertToInt(string s)
{
using (var db = new RulesModelContainer())
{
var query = from myvar in db.DictionarySet
orderby myvar.Id
where myvar.PropAtm == s
select myvar;
foreach (var item in query)
{
return(item.Id);
}
return(0);
}
}
private string ConvertToString(int p)
{
using (var db = new RulesModelContainer())
{
var query = from myvar in db.DictionarySet
orderby myvar.Id
where myvar.Id == Math.Abs(p)
select myvar;
foreach (var item in query)
{
return((p < 0)? "NO " + item.PropAtm : item.PropAtm);
}
return("");
}
}
//private void Window_Loaded(object sender, RoutedEventArgs e)
//{
// AutoFill();
//}
private void AutoFill()
{
cmbPropList.Items.Clear();
cmbResult.Items.Clear();
cmbIPropAtm.Items.Clear();
using (var db = new RulesModelContainer())
{
var query = from myvar in db.DictionarySet
orderby myvar.Id
select myvar;
foreach (var item in query)
{
cmbPropList.Items.Add(item.PropAtm);
cmbResult.Items.Add(item.PropAtm);
cmbIPropAtm.Items.Add(item.PropAtm);
}
}
}
public void fillRules()
{
using (var db = new RulesModelContainer())
{
var query = from myvar in db.RulesSet
orderby myvar.Id
select myvar;
foreach (var item in query)
{
List <int> list = new List <int>();
list.Clear();
foreach (var item2 in item.RulesDef)
{
item2.Prop = item2.Prop * -1;
list.Add(item2.Prop);
}
list.Add(item.Result);
listall.Add(new RulesClass(list, ++ID));
}
}
}
private int ConvertToNumber(string s, bool n)
{
using (var db = new RulesModelContainer())
{
var query = from myvar in db.DictionarySet
orderby myvar.Id
where myvar.PropAtm == s
select myvar;
foreach (var item in query)
{
if (n == true)
{
return(item.Id * (-1));
}
else
{
return(item.Id);
}
}
return(0);
}
}
