/// <summary>
/// Fills a context version of an OrderProduct context entry with what it can from a Business Logic Product input and an orderID
/// </summary>
/// <param name="BLOrder"></param>
/// <param name="orderID"></param>
/// <param name="BLProd"></param>
/// <returns></returns>
public OrderProduct LogicProductToContextOrderProduct(BusinessLogic.Objects.Order BLOrder, int orderID, BusinessLogic.Objects.Product BLProd)
{
Entities.OrderProduct CTXOrdProd = new OrderProduct();
CTXOrdProd.ProductTypeId = BLProd.productTypeID;
CTXOrdProd.ProductAmount = BLProd.amount;
CTXOrdProd.StoreNumber = BLOrder.storeLocation.storeNumber;
CTXOrdProd.OrderId = orderID;
return(CTXOrdProd);
}
/// <summary>
/// Inputs the order products into the OrderProduct table under an order ID given a Business Logic Order, an order ID, and a database context
/// </summary>
/// <param name="BLOrder"></param>
/// <param name="orderID"></param>
/// <param name="context"></param>
public void InputOrderProduct(BusinessLogic.Objects.Order BLOrder, int orderID, StoreApplicationContext context)
{
try
{
foreach (BusinessLogic.Objects.Product BLProd in BLOrder.customerProductList)
{
context.OrderProduct.Add(ParseHandler.LogicProductToContextOrderProduct(BLOrder, orderID, BLProd));
}
context.SaveChanges();
}
catch (Exception e)
{
Console.WriteLine("Something went wrong inputting the OrderProduct for the Order: " + e.Message);
return;
}
}
public async Task AddPlacedOrderToCustomerAsync(int customerID, BusinessLogic.Objects.Order BLOrd)
{
try
{
_context.Orders.Add(ParseHandler.LogicOrderToContextOrder(BLOrd));
_context.SaveChanges();
Order BLNewOrder = ParseHandler.ContextOrderToLogicOrder(_context.Orders.OrderByDescending(s => s.OrderId).First(o => o.CustomerId == customerID));
int newOrderID = BLNewOrder.orderID;
//BLNewOrder.storeLocation = await GetStoreInformation(BLNewOrder.storeLocation.storeNumber);
foreach (BusinessLogic.Objects.Product BLProd in BLOrd.CustomerProductList)
{
_context.OrderProduct.Add(ParseHandler.LogicProductToContextOrderProduct(newOrderID, BLProd));
}
//In the future, put the update inventory function before the savechanges for inventory validation purposes
_context.SaveChanges();
//await UpdateInventoryFromPlacedOrder(BLNewOrder);
}
catch
{
throw new Exception("Unable to commit the order to the database");
}
}
static void Main(string[] args)
{
Console.WriteLine("Hello! Welcome to the Revature Resturaunt!");
string inputOne = "0";
int n;
bool isNumeric;
int menuSwitch = 1;
// Menu switch guide
//1 - start menu
//2 - manager menu
//3 - customer menu
//4 - return customer menu
//5 - new customer menu
//6 - customer options menu
//7 - manager store view menu
//8 - order menu
//9 - Select store ID
bool whileInMenu = true;
bool whileInSecondaryMenu = true;
BusinessLogic.Objects.Customer retrievedCustomer = new BusinessLogic.Objects.Customer();
BusinessLogic.Objects.Store retrievedStore = new BusinessLogic.Objects.Store();
BusinessLogic.Objects.Order inputOrder = new BusinessLogic.Objects.Order();
List <BusinessLogic.Objects.Order> orderList = new List <BusinessLogic.Objects.Order>();
StoreApp.BusinessLogic.Objects.Manager retrievedManager = new BusinessLogic.Objects.Manager();
//DB initialization
DbContextOptions <StoreApplicationContext> options = new DbContextOptionsBuilder <StoreApplicationContext>()
.UseSqlServer(StoreApp.DataLibrary.ConnectionData.Secret.connectionString)
.Options;
using var context = new StoreApplicationContext(options);
DBRHandler = new RetrieveDatabaseHandler(context);
while (whileInMenu)
{
string managerIDInput;
int managerID;
int customerID;
int storeNum;
switch (menuSwitch)
{
case 1: //Start menu
while (whileInSecondaryMenu)
{
Console.WriteLine("Are you using this console as a manager or a customer?\n[1] Manager\n[2] Customer\n");
inputOne = CheckAndReturnCustomerOptionChosen(Console.ReadLine(), 2);
if (inputOne == "1") //Manager
{
//code for manager
//Can display current stocks and things for locations and other things stored
//Managment can stock their stores and check and edit customer data
whileInSecondaryMenu = false;
menuSwitch = 2;
}
else if (inputOne == "2") //Customer
{
//code for customer
//Will run code to make new customer, retrieve old customer data, and place orders
menuSwitch = 3;
whileInSecondaryMenu = false;
}
else //Invalid input
{
Console.WriteLine("Invalid input, please type one of the following options");
}
}
whileInSecondaryMenu = true; //resets menu true to go into next menu
break;
case 2: // manager menu
//Some code to compare manager ID to the table and welcome manager options
while (whileInSecondaryMenu)
{
Console.WriteLine("What is your manager ID?");
managerIDInput = Console.ReadLine();
isNumeric = int.TryParse(managerIDInput, out n);
if (isNumeric == false)
{
Console.WriteLine("Invalid characters. Please try again with a numerical value");
break;
}
else //if the input only has numbers in it
{
managerID = Int32.Parse(managerIDInput);
try
{
retrievedManager = DBRHandler.GetManagerDataFromID(managerID);
retrievedStore = DBRHandler.GetStoreFromStoreNumber(retrievedManager.storeNumberManaged);
Console.WriteLine("Welcome back, " + retrievedManager.firstName + " " + retrievedManager.lastName + "!\nManager of Store Number: " + retrievedManager.storeNumberManaged + "\n");
menuSwitch = 7;
whileInSecondaryMenu = false;
//set case to go to the manager options menu on 7
}
catch (NullReferenceException e)
{
Console.WriteLine("Unable to perform the operation due to null value returned with Customer ID " + managerID + ": " + e.Message + "\n");
}
catch (Exception e)
{
Console.WriteLine("Unknown exeption " + e);
}
}
}
whileInSecondaryMenu = true; //resets menu true to go into next menu
break;
case 3: //general customer menu
while (whileInSecondaryMenu)
{
Console.WriteLine("Are you a new customer or a return customer?\n[1] New Customer\n[2] Return Customer\n");
inputOne = CheckAndReturnCustomerOptionChosen(Console.ReadLine(), 2);
if (inputOne == "1")
{
whileInSecondaryMenu = false;
menuSwitch = 5;
}
else if (inputOne == "2")
{
whileInSecondaryMenu = false;
menuSwitch = 4;
}
else
{
Console.WriteLine("Invalid input, please type one of the following options");
}
}
whileInSecondaryMenu = true;
break;
case 4: //return customer
while (whileInSecondaryMenu)
{
Console.WriteLine("Welcome back! What is your customer ID?");
inputOne = Console.ReadLine();
isNumeric = int.TryParse(inputOne, out n);
if (isNumeric == false)
{
Console.WriteLine("Invalid characters. Please try again with a numerical value");
break;
}
else //if the input only has numbers in it
{
customerID = Int32.Parse(inputOne);
try
{
retrievedCustomer = DBRHandler.GetCustomerDataFromID(customerID);
Console.WriteLine("Welcome back, " + retrievedCustomer.firstName + " " + retrievedCustomer.lastName + "! What can we do for you today?");
menuSwitch = 6;
whileInSecondaryMenu = false;
}
catch (NullReferenceException e)
{
Console.WriteLine("Unable to perform the operation due to null value returned with Customer ID " + customerID + ": " + e.Message + "\n");
}
catch (Exception e)
{
Console.WriteLine("Unknown exeption " + e);
}
}
}
whileInSecondaryMenu = true; //resets menu true to go into next menu
break;
case 5: //new customer menu
StoreApp.BusinessLogic.Objects.Customer newCust = new StoreApp.BusinessLogic.Objects.Customer();
while (whileInSecondaryMenu)
{
if (newCust.CheckCustomerNotNull() == false)
{
if (newCust.firstName == null)
{
Console.WriteLine("What is your first name?");
newCust.firstName = Console.ReadLine();
}
else if (newCust.lastName == null)
{
Console.WriteLine("What is your last name?");
newCust.lastName = Console.ReadLine();
}
else if (newCust.customerAddress.CheckAddressNotNull() == false)
{
Console.WriteLine("Please enter an address. What is your street?");
newCust.customerAddress.street = Console.ReadLine();
Console.WriteLine("Please enter a city");
newCust.customerAddress.city = Console.ReadLine();
Console.WriteLine("Please enter a state");
newCust.customerAddress.state = Console.ReadLine();
Console.WriteLine("Please enter a zip");
newCust.customerAddress.zip = Console.ReadLine();
}
}
else
{
try
{
Console.WriteLine("Adding profile to database. . .\n");
DBIHandler.AddNewCustomerData(newCust, context);
Console.WriteLine("Customer profile successfully created! Welcome, " + newCust.firstName + "!\n");
int newID = DBRHandler.GetNewCustomerID(); //Note, not safe for multiple connections to the DB inputting at once.
Console.WriteLine("Your new customer ID is: " + newID);
retrievedCustomer = DBRHandler.GetCustomerDataFromID(newID);
whileInSecondaryMenu = false;
menuSwitch = 6;
}
catch (Exception e)
{
Console.WriteLine("Unknown exception thrown: " + e);
}
}
}
whileInSecondaryMenu = true; //resets menu true to go into next menu
break;
case 6: //customer options menu
while (whileInSecondaryMenu)
{
Console.WriteLine("Customer Options\n[1] Place order\n[2] View profile information\n[3] View order history\n[4] Exit to start menu");
inputOne = CheckAndReturnCustomerOptionChosen(Console.ReadLine(), 4);
if (inputOne == "1")
{
whileInSecondaryMenu = false;
menuSwitch = 9;
}
else if (inputOne == "2")
{
Console.WriteLine("\n------------------------------------------");
Console.WriteLine("Name: " + retrievedCustomer.firstName + " " + retrievedCustomer.lastName);
Console.WriteLine("ID: " + retrievedCustomer.customerID);
Console.WriteLine("\nAddress: \n" + retrievedCustomer.customerAddress.street + "\n" + retrievedCustomer.customerAddress.city + "\n" + retrievedCustomer.customerAddress.state + "\n" + retrievedCustomer.customerAddress.zip);
Console.WriteLine("------------------------------------------\n");
}
else if (inputOne == "3")
{
orderList = DBRHandler.GetListOfOrdersByCustomerID(retrievedCustomer.customerID);
foreach (BusinessLogic.Objects.Order BLOrder in orderList)
{
BLOrder.customerProductList = DBRHandler.GetListOrderProductByOrderID(BLOrder);
BLOrder.storeLocation = DBRHandler.GetStoreInformationFromOrderNumber(BLOrder.orderID);
}
if (orderList == null || orderList.Count == 0)
{
Console.WriteLine("No orders to display under " + retrievedCustomer.firstName + " " + retrievedCustomer.lastName);
}
else
{
foreach (BusinessLogic.Objects.Order order in orderList)
{
Console.WriteLine("-------------------------------");
Console.WriteLine("Store Number: " + order.storeLocation.storeNumber);
Console.WriteLine("Order Number: " + order.orderID);
foreach (BusinessLogic.Objects.Product product in order.customerProductList)
{
Console.WriteLine(product.name + ": " + product.amount);
}
}
Console.WriteLine("-------------------------------\n");
}
}
else if (inputOne == "4")
{
whileInSecondaryMenu = false;
retrievedCustomer = new BusinessLogic.Objects.Customer(); //resets the customer data that was retrieved by this point in the menu
menuSwitch = 1;
}
else
{
Console.WriteLine("Invalid input, please type one of the following options");
}
}
whileInSecondaryMenu = true; //resets menu true to go into next menu
break;
case 7: //manager store view menu
while (whileInSecondaryMenu)
{
Console.WriteLine("Options\n[1] View Store Information\n[2] View Store Inventory\n[3] View all customer order history\n[4] Exit to start menu");
inputOne = CheckAndReturnCustomerOptionChosen(Console.ReadLine(), 4);
if (inputOne == "1") //View store info
{
Console.WriteLine("------------ Information for Store Number " + retrievedStore.storeNumber + " ------------");
Console.WriteLine("Address: \nStreet: " + retrievedStore.address.street + "\nCity: " + retrievedStore.address.city + "\nState: " + retrievedStore.address.state
+ "\nZip: " + retrievedStore.address.zip + "\n");
}
else if (inputOne == "2") //View store inventory
{
retrievedStore.storeInventory = DBRHandler.GetStoreInventoryByStoreNumber(retrievedStore.storeNumber);
Console.WriteLine("------------ Store inventory ------------");
foreach (BusinessLogic.Objects.Product BLProd in retrievedStore.storeInventory.productData)
{
Console.WriteLine(BLProd.name + ": " + BLProd.amount);
}
Console.WriteLine("\n");
}
else if (inputOne == "3")
{
orderList = new List <BusinessLogic.Objects.Order>();
orderList = DBRHandler.GetListOfOrdersFromStoreNumber(retrievedStore.storeNumber);
foreach (BusinessLogic.Objects.Order BLOrder in orderList)
{
BLOrder.customerProductList = DBRHandler.GetListOrderProductByOrderID(BLOrder);
BLOrder.storeLocation = DBRHandler.GetStoreInformationFromOrderNumber(BLOrder.orderID);
}
if (orderList == null || orderList.Count == 0)
{
Console.WriteLine("No orders to display under " + retrievedCustomer.firstName + " " + retrievedCustomer.lastName);
}
else
{
foreach (BusinessLogic.Objects.Order order in orderList)
{
if (order.storeLocation.storeNumber == retrievedStore.storeNumber)
{
Console.WriteLine("-------------------------------");
Console.WriteLine("Store Number: " + order.storeLocation.storeNumber);
Console.WriteLine("Order Number: " + order.orderID);
Console.WriteLine("Customer ID: " + order.customer.customerID);
foreach (BusinessLogic.Objects.Product product in order.customerProductList)
{
Console.WriteLine(product.name + ": " + product.amount);
}
}
}
Console.WriteLine("-------------------------------\n");
}
}
else if (inputOne == "4")
{
retrievedManager = new BusinessLogic.Objects.Manager();
retrievedStore = new BusinessLogic.Objects.Store();
menuSwitch = 1;
whileInSecondaryMenu = false;
}
}
whileInSecondaryMenu = true;
break;
case 8: //Order menu
bool decided = false;
string temp;
while (whileInSecondaryMenu)
{
while (decided == false)
{
try
{
inputOrder = new BusinessLogic.Objects.Order();
BusinessLogic.Objects.Product inputProd = new BusinessLogic.Objects.Product();
retrievedStore.storeInventory = DBRHandler.GetStoreInventoryByStoreNumber(retrievedStore.storeNumber);
foreach (BusinessLogic.Objects.Product prod in retrievedStore.storeInventory.productData)
{
inputProd = prod;
inputProd.amount = 0;
Console.WriteLine("How many " + prod.name + " would you like to order?\n");
temp = Console.ReadLine();
inputProd.amount = Int32.Parse(temp);
inputOrder.customerProductList.Add(inputProd);
}
Console.WriteLine("---------------------------");
Console.WriteLine("Your order consists of: \n");
foreach (BusinessLogic.Objects.Product prod in inputOrder.customerProductList)
{
Console.WriteLine(prod.name + ": " + prod.amount + "\n");
}
Console.WriteLine("Is this alright?" + "\n[1] Yes\n[2] No");
inputOne = CheckAndReturnCustomerOptionChosen(Console.ReadLine(), 2);
if (inputOne == "1")
{
decided = true;
Console.WriteLine("Please wait while your order is created. . .\n");
//uses input handler to input order into DB
inputOrder.customer = retrievedCustomer;
inputOrder.storeLocation = retrievedStore;
bool goodOrder = inputOrder.CheckOrderIsValid();
//goodOrder = retrievedStore.storeInventory.CheckOrderAgainstInventory(inputOrder.customerProductList);
if (goodOrder == true)
{
try
{
InputWholeOrderAndUpdateInventory(inputOrder, retrievedStore, context);
menuSwitch = 6;
whileInSecondaryMenu = false;
Console.WriteLine("Order successfully created! Thank you for your business!\nReturning back to customer menu. . . \n");
}
catch (Exception e)
{
Console.WriteLine("Unable to perform the operation: \n" + e.Message);
}
}
else
{
Console.WriteLine("Order was invalid! Please try again with acceptable values!");
inputOrder = new Order();
decided = false;
}
}
else if (inputOne == "2")
{
Console.WriteLine("Please type in your order once more with the desired values.");
}
else
{
Console.WriteLine("Invalid input, please type one of the following options.");
}
}
catch (Exception e)
{
Console.WriteLine(e.Message + "\nPlease enter correct numerical values for your order.");
}
}
}
whileInSecondaryMenu = true;
break;
case 9: //Select order store menu
while (whileInSecondaryMenu)
{
Console.WriteLine("What store number are you ordering from?");
inputOne = Console.ReadLine();
isNumeric = int.TryParse(inputOne, out n);
if (isNumeric == false)
{
Console.WriteLine("Invalid characters. Please try again with a numerical value");
break;
}
else //if the input only has numbers in it
{
storeNum = Int32.Parse(inputOne);
try
{
retrievedStore = DBRHandler.GetStoreFromStoreNumber(storeNum);
menuSwitch = 8;
whileInSecondaryMenu = false;
}
catch (Exception e)
{
Console.WriteLine("Error finding store with input ID: " + e.Message + "\n");
}
}
}
whileInSecondaryMenu = true;
break;
default:
Console.WriteLine("Default case");
break;
}
}
}
