//Delete Person private static void DeletePerson() { GetPeople(); int PersonID; GetIntegerInput(" Enter ID: ", out PersonID); using (var context = new SuccinctlyExamplesEntities()) { Person P = context.People.FirstOrDefault(p => p.ID == PersonID); if (P != null) { context.People.Remove(P); if (context.SaveChanges() > 0) { Console.WriteLine("Delete Success"); } else { DisplayError("Error!"); } } else { DisplayError("Person does not exist."); } } }
//Update Person Information private static void UpdatePersonInfo() { GetPeople(); int PersonID; GetIntegerInput(" Enter ID: ", out PersonID); using (var context = new SuccinctlyExamplesEntities()) { Console.Clear(); Console.WriteLine("Enter new data for this person below."); Person P = context.People.FirstOrDefault(p => p.ID == PersonID); if (P != null) { DisplayPersonTable(null, P); P.ID = PersonID; PromptInputMessage("Enter Last Name: "); P.LastName = GetStringInput(); do { PromptInputMessage("Enter First Name: "); P.FirstName = GetStringInput(); if (string.IsNullOrWhiteSpace(P.FirstName)) { DisplayError("First Name cannot be empty."); } } while (string.IsNullOrWhiteSpace(P.FirstName)); PromptInputMessage("Enter Middle Name: "); P.MiddleName = GetStringInput(); PromptInputMessage("Enter Date of Birth: "); DateTime DOB; bool isValidDOB = DateTime.TryParse(Console.ReadLine(), out DOB); if (isValidDOB) { P.DateOfBirth = DOB; } else { DisplayError("Invalid Date. It will be set to null."); P.DateOfBirth = null; } PromptInputMessage("Enter Gender (0 = Unknown, 1 = Male, 2 = Female): "); int GenderID; bool isValidGender = int.TryParse(Console.ReadLine(), out GenderID); if (isValidGender) { isValidGender = GenderID >= 0 && GenderID < 3 ? true : false; } if (isValidGender) { P.GenderID = GenderID; } else { DisplayError("Invalid Gender. It will be set to null."); P.GenderID = null; } if (context.SaveChanges() > 0) { Console.WriteLine("Update Success"); } else { DisplayError("Error!"); } } else { DisplayError("Person does not exist."); } } }
//Insert Person private static void InsertPerson() { using (var context = new SuccinctlyExamplesEntities()) { Console.Clear(); Console.WriteLine("Enter data for this person below."); Person P = new Person(); PromptInputMessage("Enter Last Name: "); P.LastName = GetStringInput(); do { PromptInputMessage("Enter First Name: "); P.FirstName = GetStringInput(); if (string.IsNullOrWhiteSpace(P.FirstName)) { DisplayError("First Name cannot be empty."); } } while (string.IsNullOrWhiteSpace(P.FirstName)); PromptInputMessage("Enter Middle Name: "); P.MiddleName = GetStringInput(); PromptInputMessage("Enter Date of Birth: "); DateTime DOB; bool isValidDOB = DateTime.TryParse(Console.ReadLine(), out DOB); if (isValidDOB) { P.DateOfBirth = DOB; } else { DisplayError("Invalid Date. It will be set to null."); P.DateOfBirth = null; } PromptInputMessage("Enter Gender (0 = Unknown, 1 = Male, 2 = Female): "); int GenderID; bool isValidGender = int.TryParse(Console.ReadLine(), out GenderID); if (isValidGender) { isValidGender = GenderID >= 0 && GenderID < 3 ? true : false; } if (isValidGender) { P.GenderID = GenderID; } else { DisplayError("Invalid Gender. It will be set to null."); P.GenderID = null; } context.People.Add(P); if (context.SaveChanges() > 0) { Console.WriteLine("Insert Success"); } else { DisplayError("Error!"); } } }