public void GetAllOrdersbyCustomer()
{
while (true)
{
Console.Clear();
Console.WriteLine("Cup Cake Shop\n");
Console.WriteLine("Enter Customer Name: First and Last");
Console.WriteLine("(or 1 to Return to Menu)");
string customerName = Console.ReadLine();
string[] fullName = customerName.Split(' ');
if (fullName[0].ToLower() == "1")
{
break;
}
else if (string.IsNullOrEmpty(customerName) || fullName.Length != 2)
{
Console.WriteLine("Invalid Name\n");
Console.WriteLine("Press a key to continue.");
Console.ReadKey();
}
else
{
string firstName = fullName[0];
string lastName = fullName[1];
var getCustomerId = new CustomerIdDB();
int customerId = getCustomerId.GetCustomerIdDB(firstName, lastName);
if (customerId != 0)
{
Console.Clear();
Console.WriteLine("Cup Cake Shop\n");
Console.WriteLine($"Order History for {firstName} {lastName}\n");
var orderHistory = new OrdersByCustomerDB();
orderHistory.GetOrdersByCustomerDB(customerId);
Console.WriteLine("\nPress a key to continue");
Console.ReadKey();
break;
}
Console.WriteLine("\nPress a key");
Console.ReadKey();
}
}
}
public void GetAllOrdersbyCustomer()
{
while (true)
{
Console.Clear();
Console.WriteLine("Top Ten Video Store\n");
Console.WriteLine("Enter Customer Name: First and Last");
Console.WriteLine("(or Exit to Return to Menu)");
string customerName = Console.ReadLine();
string[] fullName = customerName.Split(' ');
if (fullName[0].ToLower() == "exit")
{
break;
}
else if (string.IsNullOrEmpty(customerName) || fullName.Length != 2)
{
Console.WriteLine("Invalid Name\n");
Console.WriteLine("Hit any Key to Continue.");
Console.ReadKey();
}
else
{
string firstName = fullName[0];
string lastName = fullName[1];
var getCustomerId = new CustomerIdDB();
int customerId = getCustomerId.GetCustomerIdDB(firstName, lastName);
if (customerId != 0)
{
Console.Clear();
Console.WriteLine("Top Ten Video Store\n");
Console.WriteLine($"Order History for {firstName} {lastName}\n");
var orderHistory = new OrdersByCustomerDB();
orderHistory.GetOrdersByCustomerDB(customerId);
Console.WriteLine("\nHit any Key to Continue");
Console.ReadKey();
break;
}
Console.WriteLine("\nHit any Key to Return to Menu");
Console.ReadKey();
}
}
//var getCustomerId = new CustomerIdDB();
//int customerId = getCustomerId.GetCustomerIdDB(firstName, lastName);
//if (customerId == 0)
//{
// Console.WriteLine("\nHit any Key to Return to Menu");
// Console.ReadKey();
// var mainMenu = new MainMenu();
// mainMenu.OpenMainMenu();
//}
//Console.Clear();
//Console.WriteLine("Top Ten Video Store\n");
//Console.WriteLine($"Order History for {firstName} {lastName}\n");
//var orderHistory = new OrdersByCustomerDB();
//orderHistory.GetOrdersByCustomerDB(customerId);
//Console.WriteLine("\nHit any Key to Continue");
//Console.ReadKey();
}
public void PlaceNewOrder()
{
Console.Clear();
Console.WriteLine("Cup Cake Shop\n");
Console.WriteLine("Enter Customer Name: First and Last");
string customerName = Console.ReadLine();
string[] fullName = customerName.Split(' ');
if (string.IsNullOrEmpty(customerName) || fullName.Length != 2)
{
Console.WriteLine("\nInvalid Entry");
Console.WriteLine("Press a key");
Console.ReadKey();
return;
}
string firstName = fullName[0];
string lastName = fullName[1];
var getCustomerId = new CustomerIdDB();
int customerId = getCustomerId.GetCustomerIdDB(firstName, lastName);
if (customerId == 0)
{
Console.WriteLine("\nPress a key");
Console.ReadKey();
var mainMenu = new MainMenu();
mainMenu.OpenMainMenu();
}
else
{
Console.WriteLine($"\nYour CustomerId is: {customerId}");
Console.WriteLine("\nPress a key to continue Order");
Console.ReadKey();
}
Console.Clear();
var allProducts = new AllProducts();
allProducts.GetAllProducts();
Console.WriteLine("\nEnter ProductId to Purchase: ");
int cupId = Int32.Parse(Console.ReadLine());
Console.Clear();
var allLocations = new AllLocations();
allLocations.GetAllLocations();
Console.WriteLine("\nEnter Location (Id) for Order: ");
int cupLocationId = Int32.Parse(Console.ReadLine());
//verify location inventory is not zero
Console.WriteLine("\nEnter Quantity you Wish to Purchase: ");
int cupQuantity = Int32.Parse(Console.ReadLine());
//verify inventory available
decimal orderTotal = (decimal)7.99 * cupQuantity;
//call to NewOrderDB
var newOrder = new NewOrderDB();
newOrder.PlaceNewOrderDB(customerId, cupId, cupLocationId, cupQuantity, orderTotal);
Console.Clear();
Console.WriteLine("Cup Cake Shop\n");
Console.WriteLine("Order Placed. Your total bill for " + cupQuantity + " item(s) is : " + orderTotal + " $");
Console.WriteLine("\nPress a key to continue");
Console.ReadKey();
}
public void PlaceNewOrder()
{
Console.Clear();
Console.WriteLine("Top Ten Video Store\n");
Console.WriteLine("Enter Customer Name: First and Last");
string customerName = Console.ReadLine();
string[] fullName = customerName.Split(' ');
if (string.IsNullOrEmpty(customerName) || fullName.Length != 2)
{
Console.WriteLine("\nInvalid Entry");
Console.WriteLine("Hit any Key to Return to Menu");
Console.ReadKey();
return;
}
string firstName = fullName[0];
string lastName = fullName[1];
var getCustomerId = new CustomerIdDB();
int customerId = getCustomerId.GetCustomerIdDB(firstName, lastName);
if (customerId == 0)
{
Console.WriteLine("\nHit any Key to Return to Menu");
Console.ReadKey();
var mainMenu = new MainMenu();
mainMenu.OpenMainMenu();
}
else
{
Console.WriteLine($"\n[CustomerId] {customerId}");
Console.WriteLine("\nHit any Key to Continue Order");
Console.ReadKey();
}
Console.Clear();
Console.WriteLine("Top Ten Video Store\n");
Console.WriteLine("Available Now: \n");
var allProducts = new AllProducts();
allProducts.GetAllProducts();
Console.WriteLine("\nEnter ProductId to Purchase: ");
int filmProductId = Int32.Parse(Console.ReadLine());
Console.Clear();
Console.WriteLine("Top Ten Video Store\n");
var allLocations = new AllLocations();
allLocations.GetAllLocations();
Console.WriteLine("\nEnter Location (Id) for Order: ");
int filmLocationId = Int32.Parse(Console.ReadLine());
//verify location inventory is not zero
Console.WriteLine("\nEnter Quantity you Wish to Purchase: ");
int filmQuantity = Int32.Parse(Console.ReadLine());
//verify inventory available
decimal orderTotal = (decimal)10.99 * filmQuantity;
//call to NewOrderDB
var newOrder = new NewOrderDB();
newOrder.PlaceNewOrderDB(customerId, filmProductId, filmLocationId, filmQuantity, orderTotal);
Console.Clear();
Console.WriteLine("Top Ten Video Store\n");
Console.WriteLine("Order Placed.");
Console.WriteLine("\nHit any Key to Continue");
Console.ReadKey();
}
