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