public Addsa7abiVewModel(process process)
{
List <p_sa7ab> ps = new List <p_sa7ab>();
// this.date = Ico.getValue<Date>().GetPevDate().year1.Year + "/12/31";
Ico.getValue <db>().GetUnivdb().card_dafa3.RemoveRange(get_data(process));
IEnumerable <card_dafa3> get_data(process p)
{
var cs = Ico.getValue <db>().GetUnivdb().card_dafa3.ToList().Where(c => c.part.Id_Pro == p.Id && c.tswiya == null).ToList();
foreach (var c in cs)
{
Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == c.id_part).First().nowcost -= c.Cost;
}
Ico.getValue <db>().GetUnivdb().card_dafa3.RemoveRange(cs);
return(cs);
}
foreach (var p in Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id_Pro == pr.Id_Pro).ToList())
{
foreach (var m in p.card_mo7sabi.ToList().Where(c => c.visa == null).ToList())
{
Ico.getValue <db>().GetUnivdb().processes.ToList().Where(pr => pr.Id == process.Id).ToList().First().NewCost += m.cost;
Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == m.id_part).First().mcost -= m.cost;
Ico.getValue <db>().GetUnivdb().card_mo7sabi.Remove(Ico.getValue <db>().GetUnivdb().card_mo7sabi.
ToList().Where(c => c.Id == m.Id).ToList().SingleOrDefault());
Ico.getValue <db>().GetUnivdb().cards.Remove(Ico.getValue <db>().GetUnivdb().cards.
ToList().Where(c => c.Id == m.id_card).ToList().SingleOrDefault());
}
/// this.sa7abCost+= Ico.getValue<db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == p.Id).First().mcost-= Ico.getValue<db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == p.Id).First().nowcost;
}
var dn = 0.0;
foreach (var p in Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id_Pro == pr.Id_Pro).ToList())
{
var d = p.mcost - p.nowcost;
if (d != 0)
{
ps.Add(new p_sa7ab()
{
id_part = p.Id,
cost = d,
});
dn += d;
}
}
Ico.getValue <db>().savedb();
this.sa7abCost = dn;
this.namepro = process.Name;
this.Cost = Ico.getValue <db>().GetUnivdb().processes.ToList().Where(pr => pr.Id == process.Id).ToList().First().NewCost;
savecommand = new Command(() =>
{
if (sa7abCost != 0)
{
var car = new card()
{
date = DateTime.Now,
id_prosess = process.Id,
num = 1,
year = Ico.getValue <db>().GetUnivdb().years.ToList().LastOrDefault().Id,
location = ""
};
var card_sa7ab = new card_sa7ab()
{
cost = sa7abCost,
card = car,
visa = null,
old_cost = Cost
};
Ico.getValue <db>().GetUnivdb().cards.Add(car);
Ico.getValue <db>().GetUnivdb().card_sa7ab.Add(card_sa7ab);
Ico.getValue <db>().GetUnivdb().processes.ToList().Where(pr => pr.Id == process.Id).ToList().First().NewCost += sa7abCost;
foreach (var p in Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id_Pro == pr.Id_Pro).ToList())
{
Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == p.Id).First().mcost = p.nowcost;
}
Ico.getValue <db>().savedb();
var i = Ico.getValue <db>().GetUnivdb().card_sa7ab.ToList().Where(c => c.card.year == Ico.getValue <Date>().GetNowDate().Id).FirstOrDefault().id;
foreach (p_sa7ab p in ps)
{
p.id_sa7ab = i;
}
Ico.getValue <db>().GetUnivdb().p_sa7ab.AddRange(ps);
Ico.getValue <db>().savedb();
}
else
{
MessageBox.Show("لا تستطيع إستخراج بطاقة سحب لأن المبلغ = 0 دج");
}
con();
});
Cancelcommand = new Command(() => {
con();
});
}
public Addsa7abiVewModel(process process)
{
this.namepro = process.Name;
this.Cost = process.NewCost;
this.date = Ico.getValue<Date>().GetPevDate().year1.Year + "/12/31";
foreach (var p in Ico.getValue<db>().GetUnivdb().parts.ToList().Where(pr => pr.Id_Pro == pr.Id_Pro).ToList())
{
double ps = 0d;
foreach (var m in p.card_mo7sabi.ToList().Where(c => c.visa != null).ToList())
{
ps += m.cost;
}
sa7abCost += ps;
}
Ico.getValue<db>().savedb();
savecommand = new Command( () =>
{
Ico.getValue<db>().GetUnivdb().card_dafa3.RemoveRange(get_data(process));
IEnumerable<card_dafa3> get_data(process p)
{
var cs = Ico.getValue<db>().GetUnivdb().card_dafa3.ToList().Where(c => c.part.Id_Pro == p.Id && c.tswiya == null).ToList();
foreach (var c in cs)
{
Ico.getValue<db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == c.id_part).First().nowcost -= c.Cost;
}
Ico.getValue<db>().GetUnivdb().card_dafa3.RemoveRange(cs);
return cs;
}
foreach (var p in Ico.getValue<db>().GetUnivdb().parts.ToList().Where(pr => pr.Id_Pro == pr.Id_Pro).ToList())
{
double ps = 0d;
foreach (var m in p.card_mo7sabi.ToList().Where(c => c.visa != null).ToList())
{
ps += m.cost;
Ico.getValue<db>().GetUnivdb().card_mo7sabi.Remove(m);
}
ps -= p.nowcost;
sa7abCost += ps;
foreach (var m in p.card_mo7sabi.ToList().Where(c => c.visa == null).ToList())
{
Ico.getValue<db>().GetUnivdb().processes.ToList().Where(pr => pr.Id == process.Id).ToList().First().NewCost += m.cost;
Ico.getValue<db>().GetUnivdb().card_mo7sabi.Remove(m);
}
}
Ico.getValue<db>().savedb();
/*
var d = 0d;
foreach (var c in part.card_mo7sabi.ToList())
{
d += c.cost;
}
if ((part.Cost - d) >= Cost)
{
acc();
var card = Ico.getValue<db>().GetUnivdb().cards.ToList().Where(c => c.id_prosess == card_kanoni.part.Id_Pro).OrderByDescending(c => c.num).ToList().FirstOrDefault();
var num = 1;
if (card != null)
{
num = card.num + 1;
}
*/
var car = new card()
{
date = DateTime.Now,
id_prosess = process.Id,
num = 1,
year = Ico.getValue<db>().GetUnivdb().years.ToList().LastOrDefault().Id,
location = ""
};
var card_sa7ab = new card_sa7ab()
{
cost = sa7abCost,
card = car,
visa = null,
old_cost= Cost
};
Ico.getValue<db>().GetUnivdb().processes.ToList().Where(p => p.Id == process.Id).ToList().First().NewCost += sa7abCost;
Ico.getValue<db>().GetUnivdb().cards.Add(car);
Ico.getValue<db>().GetUnivdb().card_sa7ab.Add(card_sa7ab);
Ico.getValue<db>().savedb();
con();
}
public Addsa7abiVewModel(process process)
{
// this.date = Ico.getValue<Date>().GetPevDate().year1.Year + "/12/31";
Ico.getValue <db>().GetUnivdb().card_dafa3.RemoveRange(get_data(process));
IEnumerable <card_dafa3> get_data(process p)
{
var cs = Ico.getValue <db>().GetUnivdb().card_dafa3.ToList().Where(c => c.part.Id_Pro == p.Id && c.tswiya == null).ToList();
foreach (var c in cs)
{
Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == c.id_part).First().nowcost -= c.Cost;
}
Ico.getValue <db>().GetUnivdb().card_dafa3.RemoveRange(cs);
return(cs);
}
foreach (var p in Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id_Pro == pr.Id_Pro).ToList())
{
foreach (var m in p.card_mo7sabi.ToList().Where(c => c.visa == null).ToList())
{
Ico.getValue <db>().GetUnivdb().processes.ToList().Where(pr => pr.Id == process.Id).ToList().First().NewCost += m.cost;
Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == m.id_part).First().mcost -= m.cost;
Ico.getValue <db>().GetUnivdb().card_mo7sabi.Remove(Ico.getValue <db>().GetUnivdb().card_mo7sabi.
ToList().Where(c => c.Id == m.Id).ToList().SingleOrDefault());
Ico.getValue <db>().GetUnivdb().cards.Remove(Ico.getValue <db>().GetUnivdb().cards.
ToList().Where(c => c.Id == m.id_card).ToList().SingleOrDefault());
}
/// this.sa7abCost+= Ico.getValue<db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == p.Id).First().mcost-= Ico.getValue<db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == p.Id).First().nowcost;
}
var dn = 0.0;
Ico.getValue <db>().savedb();
foreach (var p in Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id_Pro == pr.Id_Pro).ToList())
{
MessageBox.Show(p.Name + " " + p.mcost);
dn += p.mcost - p.mcost;
}
this.sa7abCost = dn;
this.namepro = process.Name;
this.Cost = Ico.getValue <db>().GetUnivdb().processes.ToList().Where(pr => pr.Id == process.Id).ToList().First().NewCost;
savecommand = new Command(() =>
{
var car = new card()
{
date = DateTime.Now,
id_prosess = process.Id,
num = 1,
year = Ico.getValue <db>().GetUnivdb().years.ToList().LastOrDefault().Id,
location = ""
};
var card_sa7ab = new card_sa7ab()
{
cost = sa7abCost,
card = car,
visa = null,
old_cost = Cost
};
Ico.getValue <db>().GetUnivdb().cards.Add(car);
Ico.getValue <db>().GetUnivdb().card_sa7ab.Add(card_sa7ab);
Ico.getValue <db>().GetUnivdb().processes.ToList().Where(pr => pr.Id == process.Id).ToList().First().NewCost += sa7abCost;
foreach (var p in Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id_Pro == pr.Id_Pro).ToList())
{
Ico.getValue <db>().GetUnivdb().parts.ToList().Where(pr => pr.Id == p.Id).First().mcost = p.nowcost;
}
Ico.getValue <db>().savedb();
con();
});
Cancelcommand = new Command(() => {
con();
});
}
public Card_sa7abExecl(card_sa7ab card_sa7ab)
{
this.card_sa7ab = card_sa7ab;
}
