public static void Add(OccasionDTO occasion) { using (Entities db = new Entities()) { DAL.Occasion occasionDb = _CastDTO.DTOToOccasion(occasion); db.Occasions.Add(occasionDb); var teachers = db.Teachers.Where(t => occasion.Teachers.Contains(t.Num)); foreach (DAL.Teacher teacher in teachers) { occasionDb.Teachers.Add(teacher); } if (occasion.Classes.Count != 0) { //occasion.Classes = Class.GetByLayers(occasion.Classes.ToList()).Select(cls => cls.Num).ToList(); List <DAL.Class> classes = db.Classes.Where(c => occasion.Classes.Contains(c.Num)).ToList();//מיפוי כיתות //Id=>Class foreach (DAL.Class cls in classes) { occasionDb.Classes.Add(cls); } } var rooms = db.Rooms.Where(r => occasion.Rooms.Contains(r.Id)); foreach (DAL.Room room in rooms) { occasionDb.Rooms.Add(room); } db.SaveChanges(); } }
public static void Add(OccasionDTO occasion) { using (Entities db = new Entities()) { DAL.Occasion occasionDb = _CastDTO.DTOToOccasion(occasion); db.Occasions.Add(occasionDb); var teachers = db.Teachers.Where(t => occasion.Teachers.Contains(t.Id)); foreach (DAL.Teacher teacher in teachers) { occasionDb.Teachers.Add(teacher); } var classes = db.Classes.Where(c => occasion.Classes.Contains(c.Id)); foreach (DAL.Class cls in classes) { occasionDb.Classes.Add(cls); } var rooms = db.Rooms.Where(r => occasion.Rooms.Contains(r.Id)); foreach (DAL.Room room in rooms) { occasionDb.Rooms.Add(room); } db.SaveChanges(); } }