//собственно алгоритм public void Create() { Building.PreBuild(); Building.Build(); for (int i = 0; i < Building.Classes.Count; i++) { for (int j = 0; j < Building.Orders.Count; j++) { Shedule sh = new Shedule(); sh.Couple_ID = Building.Classes[i].Couple; sh.DayOfWeek = Building.Classes[i].Day_Of_Week; sh.NumDem = Building.Classes[i].NumDel; sh.Order_ID = Building.Orders[j].ID_Order; sh.Room_ID = Building.Classes[i].Room; using (db_schedule db = new db_schedule()) { Shedule shedule = db.Shedule .Where(s => s.DayOfWeek == sh.DayOfWeek && s.Couple_ID == sh.Couple_ID && s.NumDem == sh.NumDem && s.Room_ID == sh.Room_ID) .FirstOrDefault(); if (shedule == null) { AddShedule(sh); } else { UpdateShedule(sh); } db.SaveChanges(); } //AddShedule(sh); } } }
public Shedule AddShedule(Shedule shedule) { using (db_schedule db = new db_schedule()) { db.Shedule.Add(shedule); db.SaveChanges(); return(shedule); } }
public Shedule FindByIDShedule(int id) { using (db_schedule db = new db_schedule()) { Shedule shedule = db.Shedule .Where(s => s.ID_Shedule == id) .FirstOrDefault(); db.SaveChanges(); return(shedule); } }
public void DeleteShedule(int id) { using (db_schedule db = new db_schedule()) { Shedule shedule = db.Shedule .Where(s => s.ID_Shedule == id) .FirstOrDefault(); db.Shedule.Remove(shedule); db.SaveChanges(); } }
public void UpdateShedule(Shedule shedule) { using (db_schedule db = new db_schedule()) { Shedule sh = db.Shedule .Where(s => s.ID_Shedule == shedule.ID_Shedule) .FirstOrDefault(); sh.Order_ID = shedule.Order_ID; db.SaveChanges(); } }