public ComicStoreController(FrameworkRepo comicDB)
{
ComicDB = comicDB;
}
#pragma warning restore CS0618 // Type or member is obsolete
static void Main(string[] args)
{
var Repo = new FrameworkRepo();
string curr_name = "";
string curr_email;
int curr_cart;
DateTime newt = DateTime.Now;
var optionsBuilder = new DbContextOptionsBuilder <Project0Context>();
optionsBuilder.UseSqlServer(Secret.ConnectionString);
//optionsBuilder.UseLoggerFactory(AppLoggerFactory); This works but spams the console with data.
var options = optionsBuilder.Options;
Console.WriteLine("Welcome to Comic League United the 7th largest comic supply store in the tri-state area.");
Console.WriteLine("Please login in order make a new customer. ");
Console.WriteLine("Please enter Customer name now. ");
curr_name = Console.ReadLine();
Console.WriteLine("Please enter Customer email now. ");
curr_email = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
var store = dbContext.Customer.FirstOrDefault(x => x.Name == curr_name || x.Email == curr_email);
if (store == null)
{
Console.WriteLine("Please enter your store location now. ");
string temp = Console.ReadLine();
Repo.AddCustomer(dbContext, curr_name, curr_email, temp);
dbContext.SaveChanges();
Console.WriteLine("Welcome New Customer. ");
}
else
{
Console.WriteLine("Welcome Back " + curr_name);
}
var cart = new Orders();
cart.CustomerId = store.CustomerId;
cart.OrderTime = newt;
dbContext.Add(cart);
dbContext.SaveChanges();
curr_cart = cart.OrdersId;
Console.ReadKey();
}
while (true)
{
Repo.MainMenu();
string choice = "11";
string temp = "";
try
{
choice = Console.ReadLine();
Console.Clear();
if (choice == "0")
{
break;
}
else if (choice == "1")
{
choice = "11";
Console.WriteLine("1: Add a Store");
Console.WriteLine("2: Delete a Store");
Console.WriteLine("3: Update a Store");
choice = Console.ReadLine();
Console.Clear();
if (choice == "1")
{
Console.WriteLine("Please enter a Store Name to add");
temp = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
Repo.AddStore(dbContext, temp);
}
}
else if (choice == "2")
{
Console.WriteLine("Please enter a Store Name to delete");
temp = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
Repo.DeleteStore(dbContext, temp);
}
}
else if (choice == "3")
{
Console.WriteLine("Please enter a Store Name to update");
temp = Console.ReadLine();
Console.WriteLine("Please enter the new name. ");
string temp2 = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
Repo.UpdateStore(dbContext, temp, temp2);
}
}
else
{
throw new ArgumentException("Please pick a valid option. ");
}
}
else if (choice == "2")
{
choice = "11";
Console.WriteLine("1: Show All Stores. ");
Console.WriteLine("2: Show One Store. ");
choice = Console.ReadLine();
Console.Clear();
if (choice == "1")
{
using (var dbContext = new Project0Context(options))
{
Repo.ShowStores(dbContext);
Console.ReadKey();
}
}
else if (choice == "2")
{
Console.WriteLine("Please enter the store name. ");
temp = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
Repo.ShowStores(dbContext, temp);
Console.ReadKey();
}
}
else
{
throw new ArgumentException("Please pick a valid option. ");
}
}
else if (choice == "3")
{
choice = "11";
Console.WriteLine("1: Add a Product");
Console.WriteLine("2: Delete a Product");
Console.WriteLine("3: Update a Product");
choice = Console.ReadLine();
Console.Clear();
if (choice == "1")
{
string placeholder;
int inv = 1;
decimal price = 5.00m;
int id;
Console.WriteLine("Please enter a Product Name.");
placeholder = Console.ReadLine();
Console.WriteLine("Please enter the number of products in inventory.");
temp = Console.ReadLine();
int.TryParse(temp, out inv);
Console.WriteLine("Please enter the price of the product.");
temp = Console.ReadLine();
decimal.TryParse(temp, out price);
Console.WriteLine("Please enter a Store ID to add the Product.");
temp = Console.ReadLine();
int.TryParse(temp, out id);
if (id == 2)
{
id = 6;
}
if (id == 3)
{
id = 11;
}
using (var dbContext = new Project0Context(options))
{
Repo.AddProduct(dbContext, placeholder, price, inv, id);
}
}
else if (choice == "2")
{
Console.WriteLine("Please enter a product Name to delete");
temp = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
Repo.DeleteProduct(dbContext, temp);
}
}
else if (choice == "3")
{
string placeholder;
string old;
int inv = 1;
decimal price = 5.00m;
int id;
Console.WriteLine("Please enter the old Product Name.");
old = Console.ReadLine();
Console.WriteLine("Please enter the new Product Name.");
placeholder = Console.ReadLine();
Console.WriteLine("Please enter the number of products in inventory.");
temp = Console.ReadLine();
int.TryParse(temp, out inv);
Console.WriteLine("Please enter the price of the product.");
temp = Console.ReadLine();
decimal.TryParse(temp, out price);
Console.WriteLine("Please enter a Store ID to add the Product.");
temp = Console.ReadLine();
int.TryParse(temp, out id);
using (var dbContext = new Project0Context(options))
{
Repo.UpdateProduct(dbContext, placeholder, price, inv, id, old);
}
}
else
{
throw new ArgumentException("Please pick a valid option. ");
}
}
else if (choice == "4")
{
choice = "11";
Console.WriteLine("1: Show All Products");
Console.WriteLine("2: Show A Product");
choice = Console.ReadLine();
Console.Clear();
if (choice == "1")
{
using (var dbContext = new Project0Context(options))
{
Repo.ShowProducts(dbContext);
Console.ReadKey();
}
}
else if (choice == "2")
{
Console.WriteLine("Please enter the product name. ");
temp = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
Repo.ShowProducts(dbContext, temp);
Console.ReadKey();
}
}
else
{
throw new ArgumentException("Please pick a valid option. ");
}
}
else if (choice == "5")
{
choice = "11";
Console.WriteLine("1: Add a Customer");
Console.WriteLine("2: Delete a Customer");
Console.WriteLine("3: Update a Customer");
choice = Console.ReadLine();
Console.Clear();
if (choice == "1")
{
string email;
string id;
Console.WriteLine("Please enter the name of the customer. ");
temp = Console.ReadLine();
Console.WriteLine("Please enter the customers email. ");
email = Console.ReadLine();
Console.WriteLine("Please enter the customers store name. ");
id = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
Repo.AddCustomer(dbContext, temp, email, id);
}
}
else if (choice == "2")
{
string email;
Console.WriteLine("Please enter the name of the customer. ");
temp = Console.ReadLine();
Console.WriteLine("Please enter the customers email. ");
email = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
Repo.DeleteCustomer(dbContext, temp, email);
}
}
else if (choice == "3")
{
string email, oldn, olde;
Console.WriteLine("Please enter the name of the customer to edit. ");
oldn = Console.ReadLine();
Console.WriteLine("Please enter the old customers email. ");
olde = Console.ReadLine();
Console.WriteLine("Please enter the new name of the customer. ");
temp = Console.ReadLine();
Console.WriteLine("Please enter the new customers email. ");
email = Console.ReadLine();
using (var dbContext = new Project0Context(options))
{
Repo.UpdateCustomer(dbContext, temp, email, oldn, olde);
}
}
else
{
throw new ArgumentException("Please pick a valid option. ");
}
}
else if (choice == "6")
{
Console.Clear();
using (var dbContext = new Project0Context(options))
{
Repo.ShowCustomers(dbContext);
Console.ReadKey();
}
}
else if (choice == "7")
{
choice = "11";
Console.WriteLine("1: Add a product to your cart");
Console.WriteLine("2: Delete a product from your cart");
Console.WriteLine("3: Checkout");
choice = Console.ReadLine();
Console.Clear();
if (choice == "1")
{
int inv = 1;
string name;
Console.WriteLine("Please enter the name of the product you'd like to add. ");
name = Console.ReadLine();
Console.WriteLine("How many would you like to add. ");
temp = Console.ReadLine();
int.TryParse(temp, out inv);
using (var dbContext = new Project0Context(options))
{
if (name.Substring(name.Length - 4, 3) == "Set")
{
Repo.AddSet(dbContext, name, inv, curr_cart);
}
else
{
Repo.AddCart(dbContext, name, inv, curr_cart);
}
}
}
else if (choice == "2")
{
int inv = 1;
Console.WriteLine("Please enter the name of the product you'd like to remove. ");
temp = Console.ReadLine();
Console.WriteLine("How many would you like to remove. ");
string temper = Console.ReadLine();
int.TryParse(temper, out inv);
using (var dbContext = new Project0Context(options))
{
Repo.DeleteCart(dbContext, temp, inv, curr_cart);
}
}
else if (choice == "3")
{
Console.Clear();
decimal total = 0;
using (var dbContext = new Project0Context(options))
{
if (Repo.CheckCartTime(dbContext, curr_name, curr_cart, newt))
{
var ordertotal = dbContext.Orders.First(x => x.OrdersId == curr_cart);
Repo.CheckOut(dbContext, curr_name, curr_cart, out total);
Console.WriteLine("Total: " + total);
Console.WriteLine("Thank you for shopping with us come back soon. ");
ordertotal.Total = total;
Console.ReadKey();
break;
}
else
{
Console.WriteLine("Cannot checkout at this time.");
Console.ReadKey();
}
}
}
else
{
throw new ArgumentException("Please pick a valid option. ");
}
}
else if (choice == "8")
{
Console.Clear();
using (var dbContext = new Project0Context(options))
{
Repo.ShowCart(dbContext, curr_name, curr_cart);
Console.WriteLine("Please press any key to return. ");
Console.ReadKey();
}
}
else if (choice == "9")
{
choice = "11";
Console.WriteLine("1: Sort by earliest");
Console.WriteLine("2: Sort by latest");
Console.WriteLine("3: Sort by cheapest");
Console.WriteLine("4: Sort by most expensive");
Console.WriteLine("5: Show Order Statistics.");
choice = Console.ReadLine();
Console.Clear();
using (var dbContext = new Project0Context(options))
{
if (choice == "1" || choice == "2" || choice == "3" || choice == "4")
{
Repo.ShowHistory(dbContext, curr_name, choice);
Console.ReadKey();
}
else if (choice == "5")
{
Repo.ShowStatistics(dbContext);
Console.ReadKey();
}
else
{
Console.WriteLine("Please only enter a valid option ");
}
}
}
else
{
throw new ArgumentException("Please pick a valid option. ");
}
}
catch (ArgumentException e)
{
Console.Clear();
Console.WriteLine(e);
Console.ReadKey();
}
choice = "11";
}
}
public HistoryController(FrameworkRepo comicDB)
{
ComicDB = comicDB;
}
public CustomerController(FrameworkRepo comicDB)
{
ComicDB = comicDB;
}
public StoreProductsController(FrameworkRepo comicDB)
{
ComicDB = comicDB;
}
public CartController(FrameworkRepo comicDB)
{
ComicDB = comicDB;
}
