//Method to get name of Care Giver through ID public string GetCareGiver(int id) { using (CareGivingDBEntities db = new CareGivingDBEntities()) { //Finds row matching the given id and returns first and last name from that row var rowData = db.CareGiver.Find(id); string careName = rowData.FirstName + " " + rowData.LastName; return(careName); } }
public void AddCareGiver() { using (CareGivingDBEntities db = new CareGivingDBEntities()) { Console.WriteLine("Please enter the last name of the new Care Giver below:"); try { lname = Console.ReadLine(); } catch (Exception) { Console.WriteLine("Something went wrong"); throw; } Console.WriteLine("Please enter the first name of the new Care Giver below:"); try { fname = Console.ReadLine(); } catch (Exception) { Console.WriteLine("Something went wrong"); throw; } Console.WriteLine("Please enter the role of the new Care Giver below (Orderly, Nurse etc.):"); try { role = Console.ReadLine(); } catch (Exception) { Console.WriteLine("Something went wrong"); throw; } Console.WriteLine("Please enter the unique ID of the workplace of the new Care Giver below:"); try { workplaceID = Convert.ToInt32(Console.ReadLine()); } catch (Exception) { Console.WriteLine("Something went wrong"); throw; } CareGiver newCareGiver = new CareGiver(); newCareGiver.FirstName = fname; newCareGiver.LastName = lname; newCareGiver.Role = role; newCareGiver.CareCenterId = workplaceID; db.CareGiver.Add(newCareGiver); db.SaveChanges(); } }
//Method to print all Care Takers public void ShowCareTaker() { using (CareGivingDBEntities db = new CareGivingDBEntities()) { //Creates a list of Care Takers from the database var careTakerList = db.CareTaker.ToList(); //Loops through the database tables and prints all relevant info foreach (var item in careTakerList) { Console.WriteLine("Last Name: " + item.LastName + " First Name: " + item.FirstName + "Liaison: " + fetchData.GetCareGiver(item.CareGiverId)); } } }
public void AddCareTaker() { using (CareGivingDBEntities db = new CareGivingDBEntities()) { Console.WriteLine("Please enter the last name of the new Care Taker below:"); try { lname = Console.ReadLine(); } catch (Exception) { Console.WriteLine("Something went wrong"); throw; } Console.WriteLine("Please enter the first name of the new Care Taker below:"); try { fname = Console.ReadLine(); } catch (Exception) { Console.WriteLine("Something went wrong"); throw; } Console.WriteLine("Please enter the unique ID of the liaison for the new Care Taker below:"); try { liaisonID = Convert.ToInt32(Console.ReadLine()); } catch (Exception) { Console.WriteLine("Something went wrong"); throw; } CareTaker newCareTaker = new CareTaker(); newCareTaker.FirstName = fname; newCareTaker.LastName = lname; newCareTaker.CareGiverId = liaisonID; db.CareTaker.Add(newCareTaker); db.SaveChanges(); } }