public static void AddHeadMaster() { Console.Write("Please insert the Fisrt Name of the Head Master: "); string firstname = Console.ReadLine(); Console.Write("Please insert the surname of the Head Master: "); string surname = Console.ReadLine(); Console.Write("Please insert the password of the Head Master's account: "); string password = Console.ReadLine(); double password_hashed = Hashing.HashingMethod(password); using (MyContext db = new MyContext()) { HeadMaster H = new HeadMaster(); H.FirstName = firstname; H.LastName = surname; H.Password = password_hashed; db.HeadMasters.Add(H); db.SaveChanges(); } Console.WriteLine("Head Master successfully registered"); }
public static void DeleteHeadMaster() { using (MyContext db = new MyContext()) { Console.WriteLine($"{"ID",-3} {"First Name",-12} {"Last Name",-12}"); foreach (var x in db.HeadMasters) { Console.WriteLine($"{x.HeadMasterID,-3} {x.FirstName,-12} {x.LastName,-12}"); } Console.Write("Please select the id of the Head Master you want to remove: "); int id = Convert.ToInt32(Console.ReadLine()); HeadMaster H = db.HeadMasters.Find(id); db.HeadMasters.Remove(H); db.SaveChanges(); } Console.WriteLine("Head Master successfully deleted"); }
public static void AddRandomData() { using (MyContext db = new MyContext()) { Student S = new Student(); S.FirstName = "Petros"; S.LastName = "Petrou"; S.DateOfBirth = new DateTime(1985, 3, 4); S.TuitionFees = 767; S.Password = Hashing.HashingMethod("petpet"); if (!db.Students.Any(x => x.Password == S.Password)) { db.Students.Add(S); db.SaveChanges(); } Student S1 = new Student(); S1.FirstName = "Vasilis"; S1.LastName = "Georgilas"; S1.DateOfBirth = new DateTime(1985, 7, 9); S1.TuitionFees = 2200; S1.Password = Hashing.HashingMethod("vasgeo"); if (!db.Students.Any(x => x.Password == S1.Password)) { db.Students.Add(S1); db.SaveChanges(); } Student S2 = new Student(); S2.FirstName = "Giannis"; S2.LastName = "Daskalakis"; S2.DateOfBirth = new DateTime(1989, 9, 24); S2.TuitionFees = 2200; S2.Password = Hashing.HashingMethod("giadas"); if (!db.Students.Any(x => x.Password == S2.Password)) { db.Students.Add(S2); db.SaveChanges(); } Student S3 = new Student(); S3.FirstName = "Vaggelis"; S3.LastName = "Roditis"; S3.DateOfBirth = new DateTime(1978, 7, 9); S3.TuitionFees = 4300; S3.Password = Hashing.HashingMethod("vagrod"); if (!db.Students.Any(x => x.Password == S3.Password)) { db.Students.Add(S3); db.SaveChanges(); } Student S4 = new Student(); S4.FirstName = "Makis"; S4.LastName = "Vasilakis"; S4.DateOfBirth = new DateTime(1969, 3, 12); S4.TuitionFees = 2200; S4.Password = Hashing.HashingMethod("makvas"); if (!db.Students.Any(x => x.Password == S4.Password)) { db.Students.Add(S4); db.SaveChanges(); } //TRAINERS Trainer T = new Trainer(); T.FirstName = "Vyron"; T.LastName = "Vasileiadis"; T.Subject = "Exercises"; T.Password = Hashing.HashingMethod("vyrvas"); if (!db.Trainers.Any(x => x.Password == T.Password)) { db.Trainers.Add(T); db.SaveChanges(); } Trainer T1 = new Trainer(); T1.FirstName = "Michalis"; T1.LastName = "Nikolaidis"; T1.Subject = "Theory"; T1.Password = Hashing.HashingMethod("micnik"); if (!db.Trainers.Any(x => x.Password == T1.Password)) { db.Trainers.Add(T1); db.SaveChanges(); } Trainer T2 = new Trainer(); T2.FirstName = "Giannis"; T2.LastName = "Panagopoulos"; T2.Subject = "Adv.Theory"; T2.Password = Hashing.HashingMethod("gianpan"); if (!db.Trainers.Any(x => x.Password == T2.Password)) { db.Trainers.Add(T2); db.SaveChanges(); } //COURSES Course C = new Course(); C.Title = "C# Basics"; C.Stream = false; C.Type = true; C.StartTime = new DateTime(2019, 6, 1); C.EndTime = new DateTime(2019, 7, 1); if (!db.Courses.Any(x => x.Title == C.Title)) { db.Courses.Add(C); db.SaveChanges(); } Course C1 = new Course(); C1.Title = "C# Adv."; C1.Stream = false; C1.Type = true; C1.StartTime = new DateTime(2019, 7, 1); C1.EndTime = new DateTime(2019, 8, 1); if (!db.Courses.Any(x => x.Title == C1.Title)) { db.Courses.Add(C1); db.SaveChanges(); } Course C2 = new Course(); C2.Title = "MySQL"; C2.Stream = false; C2.Type = true; C2.StartTime = new DateTime(2019, 6, 1); C2.EndTime = new DateTime(2019, 7, 1); if (!db.Courses.Any(x => x.Title == C2.Title)) { db.Courses.Add(C2); db.SaveChanges(); } Course C3 = new Course(); C3.Title = "Java Basics"; C3.Stream = true; C3.Type = true; C3.StartTime = new DateTime(2019, 6, 1); C3.EndTime = new DateTime(2019, 7, 1); if (!db.Courses.Any(x => x.Title == C3.Title)) { db.Courses.Add(C3); db.SaveChanges(); } //ASSIGNMENTS Assignment A = new Assignment(); A.Title = "Assignment 1"; A.Description = "School Project"; A.SubmissionDateAndTime = new DateTime(2019, 6, 15); if (!db.Assignments.Any(x => x.Title == A.Title)) { db.Assignments.Add(A); db.SaveChanges(); } Assignment A1 = new Assignment(); A1.Title = "Assignment 2"; A1.Description = "Build a website"; A1.SubmissionDateAndTime = new DateTime(2019, 6, 28); if (!db.Assignments.Any(x => x.Title == A1.Title)) { db.Assignments.Add(A1); db.SaveChanges(); } Assignment A2 = new Assignment(); A2.Title = "Assignment 3"; A2.Description = "Final Project"; A2.SubmissionDateAndTime = new DateTime(2019, 8, 12); if (!db.Assignments.Any(x => x.Title == A2.Title)) { db.Assignments.Add(A2); db.SaveChanges(); } //HEAD MASTER HeadMaster H_D = new HeadMaster(); H_D.FirstName = "Giorgos"; H_D.LastName = "Pasparakis"; H_D.Password = Hashing.HashingMethod("giopas"); if (!db.HeadMasters.Any(x => x.Password == H_D.Password)) { db.HeadMasters.Add(H_D); db.SaveChanges(); } } }