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; }