static void CreateDb() { using (var context = new ClassroomDbContext()) { Student st = new Student() { Name = "Sean", Food = "Pizza", Hometown = "Plymouth" }; Student st1 = new Student() { Name = "Justin", Food = "Sushi", Hometown = "Wyoming" }; Student st2 = new Student() { Name = "Alice", Food = "Sushi", Hometown = "Detroit" }; Student st3 = new Student() { Name = "Kalai", Food = "Baja Blast", Hometown = "Troy" }; Student st4 = new Student() { Name = "Jason", Food = "Mac and Cheese", Hometown = "Courtright" }; Student st5 = new Student() { Name = "Kristen", Food = "Mac & Cheese", Hometown = "Orange Park" }; Student st6 = new Student() { Name = "Kamesha", Food = "Tacos", Hometown = "Detroit" }; context.Students.Add(st); context.Students.Add(st1); context.Students.Add(st2); context.Students.Add(st3); context.Students.Add(st4); context.SaveChanges(); } }
static void DisplayAllDB() { using (var context = new ClassroomDbContext()) { var sts = context.Students.Where(s => s.Name == s.Name).ToList(); foreach (Student studs in sts) { Console.WriteLine($"Id: { studs.StudentId } \tName: { studs.Name }"); } } }
public static int IntIsValidated() { using (var context = new ClassroomDbContext()) { int num; int StudsCount = context.Students.Count() + 1; string message = $"Choose a number between 1 and { StudsCount }"; while (true) { try { num = int.Parse(Console.ReadLine()); if (num < 1) { throw new Exception($"Value entered is less than 1. \n{ message }."); } else if (num > StudsCount) { throw new Exception($"That student does not exist. \n{ message }."); } else { break; } } catch (FormatException) { Console.WriteLine("Invalid entry. \nPlease try again: "); } catch (Exception error) { Console.WriteLine(error.Message); } } return(num); } }
static void DisplayStudentDB() { using (var context = new ClassroomDbContext()) { int StudsCount = context.Students.Count(); if (StudsCount == 0) { Console.WriteLine("Database is empty. Choose 'y' to load data"); string userChoise = InputValidation.YesNoChoice(); if (userChoise == "y") { CreateDb(); } } InputValidation.WriteAt($"Welcome to our C# class. Which student would you like to learn more about? (enter a number 1 - {StudsCount + 1})", 0, 10); int idProvided = InputValidation.IntIsValidated(); //Storing the values here string studentName = ""; string hometown = ""; string faveFood = ""; //Getting student name by id var sts = context.Students.Where(s => s.StudentId == idProvided).ToList(); foreach (var data in sts) { studentName = data.Name; hometown = data.Hometown; faveFood = data.Food; } string choose = @"(Enter “Hometown” or “Favorite food”)"; Console.WriteLine($"Student { idProvided } is { studentName }. What would you like to know about { studentName }. \n{choose}"); while (true) { string learnMore = Console.ReadLine().Trim().ToLower(); if (learnMore == "hometown") { Console.WriteLine($"{ studentName } is from { hometown }."); Console.WriteLine($"Do you want to know more about { studentName }. (y/n)"); learnMore = InputValidation.YesNoChoice(); if (learnMore == "y") { Console.WriteLine($"{ studentName }'s favorite food is { faveFood }"); break; } break; } else if (learnMore == "food" || learnMore == "Favorite food") { Console.WriteLine($"{ studentName }'s favorite food is { faveFood }"); Console.ReadLine(); Console.WriteLine($"Do you want to know more about { studentName }. (y/n)"); learnMore = InputValidation.YesNoChoice(); if (learnMore == "y") { Console.WriteLine($"{ studentName } is from { hometown }."); break; } break; } } } }