static void PrintUnassignedChores(ChoreRepository choreRepo) { List <Chore> unassedChores = choreRepo.GetUnassignedChores(); foreach (Chore c in unassedChores) { Console.WriteLine($"{c.Id} - {c.Name}"); } }
static void ShowUnassignedChores(ChoreRepository choreRepo) { List <Chore> chores = choreRepo.GetUnassignedChores(); foreach (Chore c in chores) { Console.WriteLine($"{c.Name}"); } ContinueMenu(); }
static void ShowUnassignedChores(ChoreRepository choreRepo) { List <Chore> unassignedChores = choreRepo.GetUnassignedChores(); foreach (Chore chore in unassignedChores) { Console.WriteLine($"{chore.Id} - {chore.Name}"); } Console.WriteLine("Press any key to continue"); Console.ReadKey(); }
static void Main(string[] args) { RoomRepository roomRepo = new RoomRepository(CONNECTION_STRING); ChoreRepository choreRepo = new ChoreRepository(CONNECTION_STRING); RoommateRepository roommateRepo = new RoommateRepository(CONNECTION_STRING); bool runProgram = true; while (runProgram) { string selection = GetMenuSelection(); switch (selection) { case ("Show all rooms"): List <Room> rooms = roomRepo.GetAllRooms(); foreach (Room r in rooms) { Console.WriteLine($"{r.Id} - {r.Name} Max Occupancy({r.MaxOccupancy})"); } Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Search for room"): Console.Write("Room Id: "); int id = int.Parse(Console.ReadLine()); Room room = roomRepo.GetById(id); Console.WriteLine($"{room.Id} - {room.Name} Max Occupancy({room.MaxOccupancy})"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Add a room"): Console.Write("Room name: "); string name = Console.ReadLine(); Console.Write("Max occupancy: "); int max = int.Parse(Console.ReadLine()); Room roomToAdd = new Room() { Name = name, MaxOccupancy = max }; roomRepo.Insert(roomToAdd); Console.WriteLine($"{roomToAdd.Name} has been added and assigned an Id of {roomToAdd.Id}"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Show all chores"): List <Chore> chores = choreRepo.GetAllChores(); foreach (Chore c in chores) { Console.WriteLine($"{c.Id} - {c.Name}"); } Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Search for chore"): Console.Write("Chore Id: "); int choreId = int.Parse(Console.ReadLine()); Chore chore = choreRepo.GetById(choreId); Console.WriteLine($"{chore.Id} - {chore.Name}"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Add a chore"): Console.Write("Chore Name"); string choreName = Console.ReadLine(); Chore choreToAdd = new Chore() { Name = choreName }; choreRepo.Insert(choreToAdd); Console.WriteLine($"{choreToAdd.Name} has been added and assigned an Id of {choreToAdd.Id}"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Show unassigned chores"): List <Chore> unassignedChores = choreRepo.GetUnassignedChores(); foreach (Chore c in unassignedChores) { Console.WriteLine($"{c.Id} - {c.Name}"); } Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Assign a chore"): Console.WriteLine(); List <Chore> choreToAssign = choreRepo.GetUnassignedChores(); Console.WriteLine(" - - - Currently unassigned chores - - - "); foreach (Chore c in choreToAssign) { Console.WriteLine($"{c.Id} - {c.Name}"); } Console.Write(" \n Which chore would you like to assign? "); int choreChosen = int.Parse(Console.ReadLine()); Console.WriteLine(); List <Roommate> roommateToAssign = roommateRepo.GetAllRoommates(); foreach (Roommate r in roommateToAssign) { Console.WriteLine($"{r.Id} - {r.FirstName}"); } Console.Write(" \n Which roommate would you like to assign the chore to? "); int roommateChosen = int.Parse(Console.ReadLine()); Console.WriteLine(); choreRepo.AssignChore(roommateChosen, choreChosen); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Show chore counts"): List <string> choreCounts = choreRepo.GetChoreCounts(); foreach (string c in choreCounts) { Console.WriteLine(c); } Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Update a room"): List <Room> roomOptions = roomRepo.GetAllRooms(); foreach (Room r in roomOptions) { Console.WriteLine($"{r.Id} - {r.Name} Max Occupancy({r.MaxOccupancy})"); } Console.Write("Which room would you like to update? "); int selectedRoomId = int.Parse(Console.ReadLine()); Room selectedRoom = roomOptions.FirstOrDefault(r => r.Id == selectedRoomId); Console.Write("New Name: "); selectedRoom.Name = Console.ReadLine(); Console.Write("New Max Occupancy: "); selectedRoom.MaxOccupancy = int.Parse(Console.ReadLine()); roomRepo.Update(selectedRoom); Console.WriteLine($"Room has been successfully updated"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Exit"): runProgram = false; break; } } }
static void Main(string[] args) { RoomRepository roomRepo = new RoomRepository(CONNECTION_STRING); ChoreRepository choreRepo = new ChoreRepository(CONNECTION_STRING); RoommateRepository roommateRepo = new RoommateRepository(CONNECTION_STRING); bool runProgram = true; while (runProgram) { string selection = GetMenuSelection(); switch (selection) { case ("Show all rooms"): List <Room> rooms = roomRepo.GetAll(); foreach (Room r in rooms) { Console.WriteLine($"{r.Id} | - {r.Name} | Max Occupancy({r.MaxOccupancy})"); } Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Search for room"): Console.Write("Room Id: "); int id = int.Parse(Console.ReadLine()); Room room = roomRepo.GetById(id); Console.WriteLine($"{room.Id} | - {room.Name} | Max Occupancy({room.MaxOccupancy})"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Add a room"): Console.Write("Room name: "); string name = Console.ReadLine(); Console.Write("Max occupancy: "); int max = int.Parse(Console.ReadLine()); Room roomToAdd = new Room() { Name = name, MaxOccupancy = max }; roomRepo.Insert(roomToAdd); Console.WriteLine($"{roomToAdd.Name} with Maximum Occupancy of {roomToAdd.MaxOccupancy} has been added and assigned an Id of {roomToAdd.Id}"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Update a room"): List <Room> roomOptions = roomRepo.GetAll(); foreach (Room r in roomOptions) { Console.WriteLine($"{r.Id} - {r.Name} Max Occupancy({r.MaxOccupancy})"); } Console.Write("Which room would you like to update? "); int selectedRoomId = int.Parse(Console.ReadLine()); Room selectedRoom = roomOptions.FirstOrDefault(r => r.Id == selectedRoomId); Console.Write("New Name: "); selectedRoom.Name = Console.ReadLine(); Console.Write("New Max Occupancy: "); selectedRoom.MaxOccupancy = int.Parse(Console.ReadLine()); roomRepo.Update(selectedRoom); Console.WriteLine($"Room has been successfully updated"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Delete a room"): List <Room> deleteRoomOptions = roomRepo.GetAll(); foreach (Room r in deleteRoomOptions) { Console.WriteLine($"{r.Id} - {r.Name} Max Occupancy({r.MaxOccupancy})"); } Console.Write("Which room would you like to delete? "); int selectedRoomIdToDelete = int.Parse(Console.ReadLine()); Room selectedRoomToDelete = deleteRoomOptions.FirstOrDefault(r => r.Id == selectedRoomIdToDelete); roomRepo.Delete(selectedRoomIdToDelete); Console.WriteLine($"Room has been successfully deleted"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Show all chores"): List <Chore> chores = choreRepo.GetAll(); foreach (Chore c in chores) { Console.WriteLine($"{c.Id} | - {c.Name}"); } Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Search for chore"): Console.Write("Chore Id: "); int choreId = int.Parse(Console.ReadLine()); Chore chore = choreRepo.GetById(choreId); Console.WriteLine($"{chore.Id} | - {chore.Name} |)"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Add a chore"): Console.Write("Chore name: "); string choreName = Console.ReadLine(); Chore choreToAdd = new Chore() { Name = choreName }; choreRepo.Insert(choreToAdd); Console.WriteLine($"{choreToAdd.Name} has been added to chore table and assigned an Id of {choreToAdd.Id}"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Show list of Unassigned Chores"): List <Chore> uChores = choreRepo.GetUnassignedChores(); foreach (Chore c in uChores) { Console.WriteLine($"{c.Id} | - {c.Name}"); } Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Search for roommate"): Console.Write("Roommate Id: "); int roommateId = int.Parse(Console.ReadLine()); Roommate roommate = roommateRepo.GetById(roommateId); Console.WriteLine($"{roommate.Id} | - {roommate.FirstName} | Rent Portion -{roommate.RentPortion}% | Room Name -{roommate.Room.Name})"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Exit"): runProgram = false; break; } } }
static void Main(string[] args) { RoomRepository roomRepo = new RoomRepository(CONNECTION_STRING); ChoreRepository choreRepo = new ChoreRepository(CONNECTION_STRING); RoommateRepository rmRepo = new RoommateRepository(CONNECTION_STRING); bool runProgram = true; while (runProgram) { string selection = GetMenuSelection(); switch (selection) { case ("Show all rooms"): ListAllRooms(); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Show all chores"): ListAllChores(); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Search for room"): Console.Write("Room Id: "); int id = int.Parse(Console.ReadLine()); Room room = roomRepo.GetById(id); Console.WriteLine($"{room.Id} - {room.Name} Max Occupancy({room.MaxOccupancy})"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Search for chore"): Console.WriteLine("Chore Id: "); int choreId = int.Parse(Console.ReadLine()); Chore chore = choreRepo.GetById(choreId); Console.WriteLine($"{chore.Id} - {chore.Name}"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Search for a roommate"): Console.WriteLine("Roommate Id: "); int roommateId = int.Parse(Console.ReadLine()); Roommate roommate = rmRepo.GetById(roommateId); Console.WriteLine($"{roommate.Id} - {roommate.FirstName} {roommate.LastName} - {roommate.Room.Name}"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Add a room"): Console.Write("Room name: "); string name = Console.ReadLine(); Console.Write("Max occupancy: "); int max = int.Parse(Console.ReadLine()); Room roomToAdd = new Room() { Name = name, MaxOccupancy = max }; roomRepo.Insert(roomToAdd); Console.WriteLine($"{roomToAdd.Name} has been added and assigned an Id of {roomToAdd.Id}"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Update a room"): List <Room> roomOptions = ListAllRooms("return"); Console.Write("Which room would you like to update? "); int selectedRoomId = int.Parse(Console.ReadLine()); Room selectedRoom = roomOptions.FirstOrDefault(r => r.Id == selectedRoomId); Console.Write("New Name: "); selectedRoom.Name = Console.ReadLine(); Console.Write("New Max Occupancy: "); selectedRoom.MaxOccupancy = int.Parse(Console.ReadLine()); roomRepo.Update(selectedRoom); Console.WriteLine($"Room has been successfully updated"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Delete a room"): ListAllRooms(); Console.Write("Which room would you like to delete? "); int deletedRoomId = int.Parse(Console.ReadLine()); roomRepo.Delete(deletedRoomId, "Room"); Console.WriteLine($"Room has been successfully deleted"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Add a chore"): Console.WriteLine("Chore Name: "); string choreName = Console.ReadLine(); Chore choreToAdd = new Chore() { Name = choreName }; choreRepo.Insert(choreToAdd); Console.WriteLine($"{choreToAdd.Name} has been added and assigned an Id of {choreToAdd.Id}"); Console.WriteLine("Press any key to continue"); Console.ReadKey(); break; case ("Update a chore"): List <Chore> choreOptions = ListAllChores("return"); Console.Write("Which chore would you like to update? "); int selectedChoreId = int.Parse(Console.ReadLine()); Chore selectedChore = choreOptions.FirstOrDefault(r => r.Id == selectedChoreId); Console.Write("New Name: "); selectedChore.Name = Console.ReadLine(); choreRepo.Update(selectedChore); Console.WriteLine($"Chore has been successfully updated"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Delete a chore"): ListAllChores(); Console.Write("Which chore would you like to delete? "); int deletedChoreId = int.Parse(Console.ReadLine()); choreRepo.Delete(deletedChoreId); Console.WriteLine($"Chore has been successfully deleted"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Show all unassigned chores"): List <Chore> unassignedChores = choreRepo.GetUnassignedChores(); foreach (Chore c in unassignedChores) { Console.WriteLine($"{c.Id} - {c.Name}"); } Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Assign chore to roommate"): ListAllChores(); Console.WriteLine("Select the id of the chore you want to assign."); int assignChoreId = int.Parse(Console.ReadLine()); List <Roommate> roommates = rmRepo.GetAll(); foreach (Roommate r in roommates) { Console.WriteLine($"{r.Id} - {r.FirstName} {r.LastName})"); } Console.WriteLine("Select the id of the roommate you want to assign the chore to."); int selectedRmId = int.Parse(Console.ReadLine()); choreRepo.AssignChore(selectedRmId, assignChoreId); Console.WriteLine("Chore assigned"); Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Check the chore assignment count"): List <ChoreCount> counts = choreRepo.GetChoreCounts(); foreach (ChoreCount count in counts) { Console.WriteLine($"{count.Name}: {count.Count} chores"); } Console.Write("Press any key to continue"); Console.ReadKey(); break; case ("Exit"): runProgram = false; break; } } }