Пример #1
0
 private static void setData()
 {
     using (var db = new NTR20Z.MyContext())
     {
         if (db.teachers.Any())
         {
             return;
         }
         string           jsonString = File.ReadAllText("data.json");
         lab1.Models.Data data       = JsonSerializer.Deserialize <lab1.Models.Data>(jsonString);
         int i = 1;
         foreach (var teacher in data.teachers)
         {
             db.teachers.Add(new NTR20Z.Teacher()
             {
                 name = teacher, TeacherID = i++
             });
         }
         i = 1;
         foreach (var room in data.rooms)
         {
             db.rooms.Add(new NTR20Z.Room()
             {
                 name = room, RoomID = i++
             });
         }
         i = 1;
         foreach (var group in data.groups)
         {
             db.groups.Add(new NTR20Z.Group()
             {
                 name = group, GroupID = i++
             });
         }
         i = 1;
         foreach (var subject in data.classes)
         {
             db.subjects.Add(new NTR20Z.Subject()
             {
                 name = subject, SubjectID = i++
             });
         }
         db.SaveChanges();
     }
 }
Пример #2
0
 private static void setActivitiesAndAssignments()
 {
     using (var db = new NTR20Z.MyContext())
     {
         if (db.activities.Any())
         {
             return;
         }
         string           jsonString = File.ReadAllText("data.json");
         lab1.Models.Data data       = JsonSerializer.Deserialize <lab1.Models.Data>(jsonString);
         foreach (var activity in data.activities)
         {
             if (activity.slot == 0)
             {
                 continue;
             }
             NTR20Z.Teacher teach = db.teachers.Single(entity => entity.name == activity.teacher);
             NTR20Z.Subject subj  = db.subjects.Single(entity => entity.name == activity.@class);
             NTR20Z.Group   gr    = db.groups.Single(entity => entity.name == activity.group);
             NTR20Z.Room    rm    = db.rooms.Single(entity => entity.name == activity.room);
             NTR20Z.Slot    sl    = db.slots.Find(activity.slot);
             if (!db.assignments.Local.Any(assignment => assignment.GroupID == gr.GroupID && assignment.TeacherID == teach.TeacherID))
             {
                 db.assignments.Add(new NTR20Z.Assignment()
                 {
                     TeacherID = teach.TeacherID, SubjectID = subj.SubjectID, GroupID = gr.GroupID
                 });
             }
             db.activities.Add(new NTR20Z.Activity()
             {
                 SubjectID = subj.SubjectID, GroupID = gr.GroupID, RoomID = rm.RoomID, SlotID = sl.SlotID
             });
         }
         db.SaveChanges();
     }
 }