public static void DepartmentUpdate()
{
var repo = new DapperDepartmentRepository(conn);
Console.WriteLine($"Would you like to update a department? yes or no");
if (Console.ReadLine().ToUpper() == "YES")
{
Console.WriteLine($"What is the ID of the Department you would like to update?");
var id = Convert.ToInt32(Console.ReadLine());
Console.WriteLine($"What would you like to change the name of the department to?");
var newName = Console.ReadLine();
repo.UpdateDepartment(id, newName);
var depts = repo.GetAllDepartments();
foreach (var item in depts)
{
Console.WriteLine($"{item.DepartmentID} {item.Name}");
}
}
}
public static void ListDepartments()
{
var repo = new DapperDepartmentRepository(conn);
var departments = repo.GetAllDepartments();
foreach (var item in departments)
{
Console.WriteLine($"{item.DepartmentID} {item.Name}");
}
}
public static void DeleteDepartment()
{
//ProductRepository instance - so we can call our dapper methods
var repo = new DapperDepartmentRepository(conn);
//User interaction
Console.WriteLine($"Please enter the departmentID of the product you would like to delete:");
var productID = Convert.ToInt32(Console.ReadLine());
//Call the Dapper method
repo.DeleteDepartment(productID);
}