public static void Main(string[] args)
{
logger.Info("Program started");
try
{
string choice;
do
{
//Sorry Mark, I prefer the switch over an if/else statement, hope you don't mind I changed it up.
Console.Clear();
//For a "C" Grade
Console.WriteLine("1) Add a Product");
Console.WriteLine("2) Display all Products");
Console.WriteLine("3) Edit a Product");
Console.WriteLine("4) Display Active Products");
Console.WriteLine("5) Display Discontinued Products");
Console.WriteLine("6) Search Products");
//For a "B" Grade
Console.WriteLine("7) Add a Category");
Console.WriteLine("8) Edit a Category");
Console.WriteLine("9) Display all Categories");
Console.WriteLine("10) Display all non-discontinued items by a Category");
Console.WriteLine("11) Display all non-discontinued items by a specific Category");
//For an "A" Grade
Console.WriteLine("12) Delete a Category");
Console.WriteLine("13) Delete a Product");
Console.WriteLine("\"q\" to quit");
choice = Console.ReadLine();
switch (choice)
{
//add product
case "1":
{
Product.addProducts(logger);
break;
}
//display products
case "2":
{
Product.displayAllProducts(logger);
break;
}
//edit product
case "3":
{
var db = new NorthwindContext();
Console.WriteLine("Choose Product ID to edit: ");
var product = Product.getProduct(db, logger);
if (product != null)
{
Product UpdatedProduct = Product.EditProduct(db, logger);
if (UpdatedProduct != null)
{
UpdatedProduct.ProductID = product.ProductID;
db.EditProducts(UpdatedProduct);
logger.Info($"Product ID: {UpdatedProduct.ProductID}, {UpdatedProduct.ProductName} updated");
}
}
Console.WriteLine();
Console.WriteLine("Press any key to return to the Menu", Color.Red);
Console.ReadLine();
break;
}
//display active products
case "4":
{
Product.displayActiveProducts(logger);
break;
}
//display discountinued products
case "5":
{
Product.displayDiscontinuedProducts(logger);
break;
}
//search products
case "6":
{
Product.searchProducts(logger);
break;
}
//add category
case "7":
{
Category.addCategories(logger);
break;
}
//edit category
case "8":
{
var db = new NorthwindContext();
Console.WriteLine("Choose category ID to edit: ");
var category = Category.GetCategory(db, logger);
if (category != null)
{
Category UpdatedCategory = Category.InputCategory(db, logger);
if (UpdatedCategory != null)
{
UpdatedCategory.CategoryId = category.CategoryId;
db.EditCategory(UpdatedCategory);
logger.Info($"Category Id: {UpdatedCategory.CategoryId} updated");
}
}
Console.WriteLine();
Console.WriteLine("Press any key to return to the Menu", Color.Red);
Console.ReadLine();
break;
}
//display all categories
case "9":
{
Category.displayAllCategories(logger);
break;
}
//display all non-discontinued items by Category
case "10":
{
Category.displayAllCategoriesProductsNotDiscontinued(logger);
break;
}
//display all non-discontinued items by specific Category
case "11":
{
Category.displaySpecificCategoryProducts(logger);
break;
}
//delete a category
case "12":
{
var db = new NorthwindContext();
Console.WriteLine("Select category ID to delete:");
var categoryToDelete = Category.GetCategory(db, logger);
try
{
db.deleteCategory(categoryToDelete);
logger.Info($"{categoryToDelete.CategoryName} deleted");
}
catch (Exception)
{
logger.Error("Cannot Delete a record that affects other tables");
}
Console.WriteLine();
Console.WriteLine("Press any key to return to the Menu", Color.Red);
Console.ReadLine();
break;
}
//delete a product
case "13":
{
var db = new NorthwindContext();
Console.WriteLine("Select product ID to delete:");
var productToDelete = Product.getProduct(db, logger);
try
{
db.deleteProduct(productToDelete);
logger.Info($"{productToDelete.ProductName} deleted");
}
catch (Exception)
{
logger.Error("Cannot Delete a record that will affect other tables");
}
Console.WriteLine();
Console.WriteLine("Press any key to return to the Menu", Color.Red);
Console.ReadLine();
break;
}
}
} while (choice.ToLower() != "q");
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
logger.Info("Program ended");
}
public static void Main(string[] args)
{
logger.Info("Program started");
try
{
string choice;
do
{
Console.Clear();
Console.WriteLine("1) Add Product");
Console.WriteLine("2) Display all Products");
Console.WriteLine("3) Display Active Products");
Console.WriteLine("4) Display Discontinued Products");
Console.WriteLine("5) Search Products");
Console.WriteLine("6) Add Category");
Console.WriteLine("7) Edit Category");
Console.WriteLine("8) Display all Categories");
Console.WriteLine("9) Display all non-discontinued items by Category");
Console.WriteLine("10) Display all non-discontinued items by speciic Category");
Console.WriteLine("11) Delete Category");
Console.WriteLine("12) Delete Product");
Console.WriteLine("\"q\" to quit");
choice = Console.ReadLine();
switch (choice)
{
case "1":
Product.addProducts(logger);
break;
case "2":
Product.displayAllProducts(logger);
break;
case "3":
Product.displayActiveProducts(logger);
break;
case "4":
Product.displayDiscontinuedProducts(logger);
break;
case "5":
Product.searchProducts(logger);
break;
case "6":
Category.addCategories(logger);
break;
case "7":
var db = new NorthwindContext();
Console.WriteLine("Choose category ID to edit: ");
var category = Category.GetCategory(db, logger);
if (category != null)
{
Category UpdatedCategory = Category.InputCategory(db, logger);
if (UpdatedCategory != null)
{
UpdatedCategory.CategoryId = category.CategoryId;
db.EditCategory(UpdatedCategory);
logger.Info($"Category Id: {UpdatedCategory.CategoryId} updated");
}
}
Console.WriteLine();
Console.WriteLine("Press any key to return to menu");
Console.ReadLine();
break;
case "8":
Category.displayAllCategories(logger);
break;
case "9":
Category.displayAllCategoriesAndProductsNotDiscontinued(logger);
break;
case "10":
Category.displaySpecificCategoryAndProducts(logger);
break;
case "11":
db = new NorthwindContext();
Console.WriteLine("Select category ID to delete:");
var categoryToDelete = Category.GetCategory(db, logger);
try
{
db.deleteCategory(categoryToDelete);
logger.Info($"{categoryToDelete.CategoryName} deleted");
}
catch (Exception)
{
logger.Error("Cannot Delete a record that affects other tables");
}
Console.WriteLine();
Console.WriteLine("Press any key to return to menu");
Console.ReadLine();
break;
case "12":
db = new NorthwindContext();
Console.WriteLine("Select product ID to delete:");
var productToDelete = Product.GetProduct(db, logger);
try
{
db.deleteProduct(productToDelete);
logger.Info($"{productToDelete.ProductName} deleted");
}
catch (Exception)
{
logger.Error("Cannot Delete a record that affects other tables");
}
Console.WriteLine();
Console.WriteLine("Press any key to return to menu");
Console.ReadLine();
break;
default:
logger.Info("No option chosen");
break;
}
} while (choice.ToLower() != "q");
}
catch (Exception ex)
{
logger.Error(ex.Message);
}
logger.Info("Program ended");
}