internal static void PrintSpecificNextOfKin(NextOfKin nextOfKin) { Console.WriteLine($"***Next of kin***"); Console.WriteLine($"Firstname: {nextOfKin.FirstName}"); Console.WriteLine($"Lastname: {nextOfKin.LastName}"); Console.WriteLine($"Phone number: {nextOfKin.PhoneNumber}"); Console.WriteLine($"SSN: {nextOfKin.SocialSecurtyNumber}"); using (var db = new CampSleepAwayContext()) { try { var nextOfKinPresent = db.NextOfKinCheckInCheckOuts.Where(Nx => Nx.NextOfKinID == nextOfKin.NextOfKinID).FirstOrDefault <NextOfKinCheckInCheckOut>(); if (nextOfKinPresent != null) { Console.WriteLine($"Is present in camp: {(nextOfKinPresent.IsPresent ? "Yes" : "No")}"); } else { Console.WriteLine("Is present in camp: The person has never checked in on Camp SleepOver"); } } catch { Console.WriteLine("Is present in camp: The person has never checked in on Camp SleepOver"); } } }
internal static CounselorHistory GetACounselorHistory(Counselor counselor) { var counselorHistory = new CounselorHistory() { FirstName = counselor.FirstName, LastName = counselor.LastNAme, PhoneNumber = counselor.PhoneNumber, SocialSecurityNumber = counselor.SocialSecurityNumber, CounselorID = counselor.CounselorID, TimeStamp = DateTime.UtcNow }; try { using (var db = new CampSleepAwayContext()) { counselorHistory.CabinID = counselor.Cabin.CabinID; } } catch { } return(counselorHistory); }
internal static void PrintAllCounselors() { using (var db = new CampSleepAwayContext()) { try { var allCounselorsQuery = db.Counselors.ToList(); foreach (var counselor in allCounselorsQuery) { Console.WriteLine("-----------"); Console.WriteLine($"{counselor.FirstName}"); Console.WriteLine($"{counselor.LastNAme}"); try { Console.WriteLine($"Cabin number: {counselor.Cabin.CabinNumber}"); } catch { Console.WriteLine("Cabin number: (No cabin assigned)"); } } } catch { Console.WriteLine("Error when saving to database. Please contact support if the problem persists."); } } }