public void AddLesson() { Lesson lesson = new Lesson(); TakenLessons taken = new TakenLessons(); Console.WriteLine("Enter lesson theme:"); lesson.Name = Console.ReadLine(); db.GetTable <Lesson>().InsertOnSubmit(lesson); db.SubmitChanges(); // UpdateTakenLessons(); }
public void SetLessonToStudent() { GetStudents(); GetLessons(); Console.WriteLine("Enter ID of student"); if (!int.TryParse(Console.ReadLine(), out int stID)) { Console.WriteLine("Uncorrect value"); return; } if (db.GetTable <Student>().SingleOrDefault(x => x.ID == stID) == null) { Console.WriteLine("There is no such student"); return; } Console.WriteLine("Enter ID of lesson"); if (!int.TryParse(Console.ReadLine(), out int lsID)) { Console.WriteLine("Uncorrect value"); return; } if (db.GetTable <Lesson>().SingleOrDefault(x => x.ID == lsID) == null) { Console.WriteLine("There is no such lesson"); return; } TakenLessons taken = new TakenLessons(); taken.LessonID = lsID; taken.StudentID = stID; if (db.GetTable <TakenLessons>().Contains(taken)) { Console.WriteLine("Such entry already exists"); } else { db.GetTable <TakenLessons>().InsertOnSubmit(taken); db.SubmitChanges(); } }