コード例 #1
0
ファイル: FetchDBData.cs プロジェクト: maskJern/dbTest
 //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);
     }
 }
コード例 #2
0
ファイル: AddData.cs プロジェクト: maskJern/dbTest
        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();
            }
        }
コード例 #3
0
ファイル: ShowDBData.cs プロジェクト: maskJern/dbTest
 //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));
         }
     }
 }
コード例 #4
0
ファイル: AddData.cs プロジェクト: maskJern/dbTest
        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();
            }
        }