public static void Main()
{
//get the configuration from file
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);
IConfigurationRoot configuration = builder.Build();
var optionsBuilder = new DbContextOptionsBuilder <Project1Context>();
optionsBuilder.UseSqlServer(configuration.GetConnectionString("Project1"));
var repo = new PizzaRepos(new Project1Context(optionsBuilder.Options));
repo.UpdateLocationInventory(Order.OrderLocation, Order.OrderSize, Order.OrderToppings, Order.OrderQuantity);
int custId = repo.CheckCustomerId(Customers.CustomerName);
int locationId = repo.LookupLocationId(Order.OrderLocation);
int pizzaId = repo.LookupPizzaId(Order.OrderSize, Order.OrderCrust);
repo.AddPizzaOrder(custId, locationId, pizzaId, Order.OrderQuantity, Order.OrderCost, Order.OrderTime);
repo.AddPizzaOrderToppings(Order.OrderToppings);
repo.SaveChanges();
}
public ActionResult SignIn(IFormCollection collection)
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);
IConfigurationRoot configuration = builder.Build();
var optionsBuilder = new DbContextOptionsBuilder <Project1Context>();
optionsBuilder.UseSqlServer(configuration.GetConnectionString("Project1"));
var repo = new PizzaRepos(new Project1Context(optionsBuilder.Options));
string name = collection["CustomerName"].ToString();
if (name.Length > 12)
{
TempData["Message"] = "Username cannot be longer than 12 characters.";
return(View("SignIn"));
}
if (collection["CustomerName"] == "Password123")
{
TempData["CurrentCustomerName"] = "Mr. President";
return(View("Manager"));
}
TempData["CurrentCustomerName"] = name;
if (repo.CheckCustomerName(collection["CustomerName"]))
{
return(RedirectToAction("PreviousOrder", "PizzaOrders"));
}
return(RedirectToAction("Create", "PizzaOrders"));
}
public static void LatestOrder2()
{
Console.WriteLine("Order History sorted by time from Latest to Earliest");
for (int i = 0; i < Location.OrderHistory2.Count; i++)
{
PizzaRepos.WritePizzaOrder(i);
}
}
public static void EarliestOrder2()
{
Console.WriteLine("Order History sorted by time from Earliest to Latest");
for (int i = 0; i < Location.OrderHistory2.Count; i++)
{
int marker = Location.OrderHistory2.Count - 1 - i;
PizzaRepos.WritePizzaOrder(marker);
}
}
public static void OrderHistoryRecall2()
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);
IConfigurationRoot configuration = builder.Build();
var optionsBuilder = new DbContextOptionsBuilder <Project1Context>();
optionsBuilder.UseSqlServer(configuration.GetConnectionString("Project1"));
var repo = new PizzaRepos(new Project1Context(optionsBuilder.Options));
List <PizzaOrder> pizzaOrders = repo.GetPizzaOrders();
OrderHistory2 = pizzaOrders;
}
public static void CustomerOrderHistory2()
{
Console.WriteLine("Which Customer would you like to see an Order History for?");
string input = Console.ReadLine();
int count = 0;
for (int i = 0; i < Location.OrderHistory2.Count; i++)
{
int marker = Location.OrderHistory2.Count - 1 - i;
if (Location.OrderHistory2[marker].Customer.CustomerName == input)
{
count++;
PizzaRepos.WritePizzaOrder(marker);
}
}
if (count == 0)
{
Console.WriteLine("Sorry, I couldn't find a Customer with that name.");
}
}
public static void LocationInventoryLevels2()
{
Console.WriteLine("Which Location would you like to see Inventory Levels for?");
string input = Console.ReadLine();
int count = 0;
for (int i = 0; i < LocationInventory2.Count; i++)
{
int marker = LocationInventory2.Count - 1 - i;
if (LocationInventory2[marker].LocationName == input)
{
count++;
PizzaRepos.WriteInventory(marker);
}
}
if (count == 0)
{
Console.WriteLine("Sorry, I couldn't find any order for that Location.");
}
}
public static void MostExpensiveOrder2()
{
List <int> used = new List <int> {
};
for (int a = 0; a < Location.OrderHistory2.Count; a++)
{
double highest = 0;
int marker = 0;
for (int i = 0; i < Location.OrderHistory2.Count; i++)
{
if (!used.Contains(i) || Location.OrderHistory2[i].OrderCost > highest)
{
marker = i;
highest = Location.OrderHistory2[i].OrderCost.Value;
}
}
used.Add(marker);
PizzaRepos.WritePizzaOrder(marker);
}
}
public static void CheapestOrder2()
{
List <int> used = new List <int> {
};
for (int a = 0; a < Location.OrderHistory2.Count; a++)
{
double lowest = 500;
int marker = 0;
for (int i = 0; i < Location.OrderHistory2.Count; i++)
{
if (!used.Contains(i) || Location.OrderHistory2[i].OrderCost < lowest)
{
marker = i;
lowest = Location.OrderHistory2[i].OrderCost.Value;
}
}
used.Add(marker);
PizzaRepos.WritePizzaOrder(marker);
}
}
public void TestPizzaLookup()
{
var builder = new ConfigurationBuilder()
.SetBasePath(Directory.GetCurrentDirectory())
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true);
IConfigurationRoot configuration = builder.Build();
//Console.WriteLine(configuration.GetConnectionString("Project1"));
var optionsBuilder = new DbContextOptionsBuilder <Project1Context>();
optionsBuilder.UseSqlServer(configuration.GetConnectionString("Project1"));
var repo = new PizzaRepos(new Project1Context(optionsBuilder.Options));
string size = "Small";
string crust = "Hand Tossed";
int low = 1;
int high = 9;
Assert.InRange(repo.LookupPizzaId(size, crust), low, high);
}
public PizzaOrdersController(PizzaRepos repos)
{
Repo = repos;
}
