public void editActivity(SingleActivity acti, int id) { string te = activities[id].teacher; string sl = activities[id].slot.ToString(); //string te = "Zbyszek"; //string sl = "13"; using (var context = new LibraryContext()) { var teach = context.Teacher; var subs = context.Subject; var groupss = context.Classgroup; var roomss = context.Room; var slotss = context.Slot; var activitiess = context.ActivityBis.Include(p => p.Slot).Include(t => t.Teacher).Include(r => r.Room) .Include(c => c.Classgroup).Include(s => s.Subject); var ActivitiesBis = from a in activitiess where (a.Teacher.name == te && a.Slot.name == sl) select a; var activityTer = ActivitiesBis.Single(); foreach (var s in subs) { if (s.name == acti.subject) { activityTer.Subject = s; } } foreach (var t in teach) { if (t.name == acti.teacher) { activityTer.Teacher = t; } } foreach (var g in groupss) { if (g.name == acti.group) { activityTer.Classgroup = g; } } foreach (var r in roomss) { if (r.name == acti.room) { activityTer.Room = r; } } activityTer.TimeStamp = DateTime.Now; context.SaveChanges(); } }
public void ReadActivities() { activities = new List <SingleActivity>(); using (var context = new LibraryContext()) { var activitiess = context.ActivityBis.Include(s => s.Slot).Include(r => r.Room).Include(t => t.Teacher) .Include(x => x.Subject).Include(c => c.Classgroup); foreach (var t in activitiess) { SingleActivity acti = new SingleActivity(); acti.slot = Int32.Parse(t.Slot.name); acti.subject = t.Subject.name; acti.teacher = t.Teacher.name; acti.room = t.Room.name; acti.group = t.Classgroup.name; activities.Add(acti); } } }
public void InsertActivity(SingleActivity act) { using (var context = new LibraryContext()) { // Creates the database if not exists context.Database.EnsureCreated(); int checkBis = 0; var teach = context.Teacher; var subs = context.Subject; var groupss = context.Classgroup; var roomss = context.Room; var slotss = context.Slot; var activitiess = context.ActivityBis.Include(p => p.Slot); ActivityBis activityBis = new ActivityBis(); foreach (var s in subs) { if (s.name == act.subject) { activityBis.Subject = s; } } foreach (var t in teach) { if (t.name == act.teacher) { activityBis.Teacher = t; } } foreach (var g in groupss) { if (g.name == act.group) { activityBis.Classgroup = g; } } foreach (var r in roomss) { if (r.name == act.room) { activityBis.Room = r; } } foreach (var s in slotss) { if (s.name == act.slot.ToString()) { activityBis.Slot = s; checkBis = 1; } } if (checkBis == 0) { Slot slot = new Slot(); slot.name = act.slot.ToString(); slot.comment = " "; context.Slot.Add(slot); activityBis.Slot = slot; } activityBis.TimeStamp = DateTime.Now; context.ActivityBis.Add(activityBis); context.SaveChanges(); } }