public void CheckGetCustomerReturnsProperValues(int testID)
{
using var context = new StoreApplicationContext(options);
BusinessLogic.Objects.Customer testCustomer = new BusinessLogic.Objects.Customer();
testCustomer = DBRHandler.GetCustomerDataFromID(testID, context);
Assert.True(testCustomer.CheckCustomerNotNull());
}
/// <summary>
/// returns a Customer entity from the data given by a Business Logic version of the customer
/// </summary>
/// <param name="BLCustomer"></param>
/// <returns></returns>
public Entities.Customer LogicCustomerToContextCustomer(BusinessLogic.Objects.Customer BLCustomer)
{
Entities.Customer CTXCustomer = new Entities.Customer();
CTXCustomer.FirstName = BLCustomer.firstName;
CTXCustomer.LastName = BLCustomer.lastName;
CTXCustomer.Street = BLCustomer.customerAddress.street;
CTXCustomer.City = BLCustomer.customerAddress.city;
CTXCustomer.State = BLCustomer.customerAddress.state;
CTXCustomer.Zip = BLCustomer.customerAddress.zip;
return(CTXCustomer);
}
public async Task AddCustomerAsync(BusinessLogic.Objects.Customer BLCustomer)
{
var entity = new Customer
{
FirstName = BLCustomer.firstName,
LastName = BLCustomer.lastName,
Street = BLCustomer.CustomerAddress.street,
City = BLCustomer.CustomerAddress.city,
State = BLCustomer.CustomerAddress.state,
Zip = BLCustomer.CustomerAddress.zip
};
_context.Add(entity);
await _context.SaveChangesAsync();
}
/// <summary>
/// Converts a Entity/Context Customer into a Business Logic Customer
/// </summary>
/// <param name="CTXCustomer"></param>
/// <returns></returns>
public StoreApp.BusinessLogic.Objects.Customer ContextCustomerToLogicCustomer(StoreApp.DataLibrary.Entities.Customer CTXCustomer)
{
StoreApp.BusinessLogic.Objects.Customer BLCustomer = new BusinessLogic.Objects.Customer();
BLCustomer.customerAddress.street = CTXCustomer.Street;
BLCustomer.customerAddress.city = CTXCustomer.City;
BLCustomer.customerAddress.state = CTXCustomer.State;
BLCustomer.customerAddress.zip = CTXCustomer.Zip;
BLCustomer.customerID = CTXCustomer.CustomerId;
BLCustomer.firstName = CTXCustomer.FirstName;
BLCustomer.lastName = CTXCustomer.LastName;
return(BLCustomer);
}
public async Task <ActionResult> Create(CreateCustomerViewModel VMCustomer)
{
try
{
if (!ModelState.IsValid)
{
return(View(VMCustomer));
}
var customer = new BusinessLogic.Objects.Customer
{
firstName = VMCustomer.FirstName,
lastName = VMCustomer.LastName,
CustomerAddress = new Address
{
street = VMCustomer.Street,
city = VMCustomer.City,
state = VMCustomer.State,
zip = VMCustomer.Zip
}
};
await _repository.AddCustomerAsync(customer);
try
{
BusinessLogic.Objects.Customer newCustomer = _repository.GetLastCustomerWithFirstLast(VMCustomer.FirstName, VMCustomer.LastName);
TempData["LoggedCustomer"] = newCustomer.customerID;
return(RedirectToAction(nameof(Profile)));
}
catch (InvalidOperationException e)
{
ModelState.AddModelError("Failed to get the new added customer's ID", e.Message);
return(View(VMCustomer));
}
}
catch
{
return(View(VMCustomer));
}
}
// GET: Customer/Profile : Displays stuff from the given ID
public async Task <ActionResult> Profile(int CustomerID)
{
bool hasValue;
try
{
if (TempData["LoggedCustomer"] == null && CustomerID == 0)
{
hasValue = false;
}
else
{
hasValue = true;
}
if (hasValue == false)
{
if (CustomerID == 0)
{
return(RedirectToAction(nameof(InvalidCustomer)));
}
else if (TempData["LoggedManager"] == null)
{
throw new Exception("No temp data for the customer. Please ensure the temp data was kept between controllers");
}
else
{
throw new Exception("Something else went wrong with validating data in ProfileAsync in the CustomerController class");
}
}
else
{
if (CustomerID == 0)
{
CustomerID = int.Parse(TempData["LoggedCustomer"].ToString());
}
else
{
TempData["LoggedCustomer"] = CustomerID;
}
BusinessLogic.Objects.Customer customer = await _repository.GetCustomerByID(int.Parse(TempData["LoggedCustomer"].ToString()));
List <BusinessLogic.Objects.Order> orders = await _repository.GetListAllOrdersFromCustomer(customer.customerID);
if (!ModelState.IsValid)
{
return(View(nameof(Login)));
}
if (customer.customerID == 0)
{
return(RedirectToAction(nameof(InvalidCustomer)));
}
var viewModel = new CustomerProfileViewModel
{
CustomerID = customer.customerID,
FirstName = customer.firstName,
LastName = customer.lastName,
Street = customer.CustomerAddress.street,
City = customer.CustomerAddress.city,
State = customer.CustomerAddress.state,
Zip = customer.CustomerAddress.zip,
CustomerOrderIDs = orders.Select(oID => oID.orderID).ToList(),
CustomerProduct = orders.SelectMany(op => op.CustomerProductList).ToList(),
OrderStore = orders.Select(os => os.StoreLocation.storeNumber).ToList(),
CustomerOrders = orders
};
TempData.Keep("LoggedCustomer");
return(View(viewModel));
}
}
catch (InvalidOperationException)
{
return(RedirectToAction(nameof(InvalidCustomer)));
}
}
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;
}
}
}