public IActionResult Edit(int id, [Bind("Id,ItemId,ItemPrice,Quantity,OrderRId")] Orderdetails orderdetails)
{
if (id != orderdetails.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(orderdetails);
_context.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!OrderdetailsExists(orderdetails.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
ViewData["OrderRId"] = new SelectList(_context.OrderR, "Id", "Id", orderdetails.OrderRId);
return(View(orderdetails));
}
public IActionResult Create([Bind("Id,ItemId,ItemPrice,Quantity,OrderRId")] Orderdetails orderdetails)
{
if (ModelState.IsValid)
{
_context.Add(orderdetails);
_context.SaveChanges();
return(RedirectToAction(nameof(Index)));
}
ViewData["OrderRId"] = new SelectList(_context.OrderR, "Id", "Id", orderdetails.OrderRId);
return(View(orderdetails));
}
// GET: Orders
public ActionResult Index()
{
Orderdetails _objOrdermodel = new Orderdetails();
List <Orders> _objOrders = new List <Orders>();
_objOrders = GetOrders();
_objOrdermodel.Ordermodel = _objOrders;
return(View(_objOrdermodel));
}
public int PlaceOrder(OrderFinalDetails details)
{
Ordertable order = new Ordertable();
order.TotalAmount = details.TotalAmount;
order.CustomerId = details.Cid;
order.OrderDate = DateTime.Now;
order.CategoryId = details.Products[0].CategoryId;
context.Ordertable.Add(order);
context.SaveChanges();
//~~~~~~~~~~~~~~~~~~OrderDetails table~~~~~~~~~~~~~~~~~~~~~~
Orderdetails[] products = new Orderdetails[details.Products.Length];
for (var i = 0; i < details.Products.Length; i++)
{
products[i] = new Orderdetails()
{
OrderId = order.OrderId,
Price = details.Products[i].Price,
Quantity = details.Products[i].Quantity,
ProductId = details.Products[i].ProductId
};
// context.Orderdetails.Add(products[i]);
}
context.Orderdetails.AddRange(products);
//~~~~~~~~~~~~~~~~~~~~~payment table~~~~~~~~~~~~~~~~~~~~~
Payment payment = new Payment();
payment = new Payment()
{
OrderId = order.OrderId,
Amount = (decimal)order.TotalAmount.Value,
PaymentDate = DateTime.Now,
Mode = details.PaymentMode
};
context.Payment.Add(payment);
Product p;
for (int i = 0; i < details.Products.Length; i++)
{
p = context.Product.SingleOrDefault(c => c.ProductId == details.Products[i].ProductId);
p.Quantity -= details.Products[i].Quantity;
}
context.SaveChanges();
return(payment.InvoiceId);
}
public void SearchByProductTest()
{
OrderService orderService = new OrderService();
Order o = new Order();
o.Customer = "111";
o.OrderID = "001";
Orderdetails a = new Orderdetails();
a.ProductName = "可乐";
o.orderdetailsList.Add(a);
orderService.orderList.Add(o);
orderService.SearchByProduct("可乐");
try
{
orderService.SearchByProduct("雪碧");
}
catch (Exception e)
{
StringAssert.Equals(e.Message, "错误！找不到存在该商品的订单");
}
}
public ActionResult <Order> AddOrderDetail(long id, Orderdetails detail)
{
Console.WriteLine(id);
var res = OrderDB.MyOrders.Include("User").Where(m => m.Id == id).FirstOrDefault();
if (res == null)
{
return(NotFound());
}
else
{
if (res.OrderDetails.Where(d => d.OrderdetailsId == detail.OrderdetailsId).FirstOrDefault() != null)
{
return(BadRequest("detailsId repeated!"));
}
//终于解决了，一对多对应关系，只在数据库‘多’表中添加，不直接在‘一’表添加
//res.OrderDetails.Add(detail);
//OrderDB.Entry(res).State = EntityState.Modified;
OrderDB.MyDetails.Add(detail);
OrderDB.SaveChanges();
return(res);
}
}
public IActionResult Varukorg(int ID, string Empty, int RemoveID, int ProductID, string Apply)
{
ViewProducts vp = new ViewProducts();
var varukorg = Request.Cookies.SingleOrDefault(c => c.Key == "Varukorg");
if (RemoveID == 0)
{
using (ApplicationDbContext ctx = new ApplicationDbContext())
{
string cookieString;
var recipeProductsIds = from e in ctx.RecipeDetails
where e.RecipeId == ID
select e.ProductId;
if (Apply == "Add" || Apply == "Remove")
{
cookieString = varukorg.Value;
}
else if (varukorg.Value != "" && varukorg.Value != null && ID != 0)
{
cookieString = varukorg.Value + "," + string.Join(",", recipeProductsIds);
}
else
{
cookieString = varukorg.Value + string.Join(",", recipeProductsIds);
}
if (cookieString == "")
{
RemoveFromOrderdetails();
}
var productIds = cookieString.Split(",").Select(c => int.Parse(c));
var Check = from e in ctx.Orderdetails
select e;
if (Check.Count() == 0)
{
var products = from e in ctx.Products
where productIds.Contains(e.Id)
select e;
if (!cookieString.Equals(""))
{
foreach (var item in products)
{
Orderdetails od = new Orderdetails();
od.ProductId = item.Id;
od.Amount = 1;
using (ApplicationDbContext c = new ApplicationDbContext())
{
if (!c.Orderdetails.Any(A => A.ProductId == item.Id))
{
c.Orderdetails.Add(od);
c.SaveChanges();
}
}
ShowIngrediens si = new ShowIngrediens();
si.ProductID = item.Id;
si.ProductName = item.ProductName;
si.Quantity = item.Quantity;
si.Price = item.Price;
si.Amount = 1;
vp.TotalSum += (decimal.ToDouble(si.Price) * si.Amount);
vp.UserID = User.FindFirstValue(ClaimTypes.NameIdentifier);
vp.Productslist.Add(si);
}
}
}
else
{
using (ApplicationDbContext c = new ApplicationDbContext())
{
var modify = from m in c.Orderdetails
where m.ProductId == ProductID
select m;
if (Apply == "Add")
{
foreach (var items in modify)
{
items.Amount++;
}
}
else if (Apply == "Remove")
{
foreach (var items in modify)
{
items.Amount--;
if (items.Amount == 0)
{
RemoveItem(ProductID, vp);
vp.StatusMessage = "Produkten har tagits bort";
return(View(vp));
}
}
}
c.SaveChanges();
foreach (var additem in productIds)
{
Orderdetails od = new Orderdetails()
{
ProductId = additem, Amount = 1
};
if (!c.Orderdetails.Any(A => A.ProductId == additem))
{
c.Orderdetails.Add(od);
c.SaveChanges();
}
}
}
AddListValue(vp);
}
Response.Cookies.Append("Varukorg", cookieString, new Microsoft.AspNetCore.Http.CookieOptions {
Expires = DateTime.Now.AddMinutes(60.0)
});
ctx.SaveChanges();
}
}
if (Empty == "Empty")
{
using (ApplicationDbContext ctx = new ApplicationDbContext())
{
foreach (var item in ctx.Orderdetails)
{
ctx.Orderdetails.Remove(item);
}
ctx.SaveChanges();
Response.Cookies.Delete("Varukorg");
vp.Productslist.Clear();
vp.TotalSum = 0;
return(View(vp));
}
}
else if (RemoveID != 0)
{
RemoveItem(RemoveID, vp);
}
return(View(vp));
}
static void Main(string[] args)
{
var optionsBuilder = new DbContextOptionsBuilder <PPDA.PizzaDBContext>();
optionsBuilder.UseSqlServer(SecretConfiguration.Connectionstring);
var options = optionsBuilder.Options;
var dbContext = new PPDA.PizzaDBContext(options);
IPizzaRepository PizzaRepository = new PPDA.PizzaRepository(dbContext);
Console.WriteLine("Customer(C or c) or Employee(E or e)?:");
var core = Console.ReadLine();
if (core == "C" || core == "c")
{
Console.WriteLine("What is your username?:");
var custname = Console.ReadLine();
var custuser = new Customer();
var custlist = PizzaRepository.Getcustomers().ToList(); //grabs customers
for (var i = 0; i < custlist.Count(); i++)
{
//throw excpetion
if (custname == custlist[i].Username)
{
custuser = custlist[i];
}
else
{
//throw exception
}
}
custuser.Deflocation = PizzaRepository.Grablocation(custuser.Deflocationid);
Console.WriteLine("Would you like to place an order(O or o):");
Console.WriteLine("Would you like to display your history(S or s):");
var custinput = Console.ReadLine();
if (custinput == "O" || custinput == "o")
{
var neworder = new Orderdetails(); //new order
var local2 = new Location();
neworder.Customerid = custuser.Userid; //custid for order
Console.WriteLine("Use default location(D or d):");
Console.WriteLine("New location?(N or n):");
var localinput = Console.ReadLine();
if (localinput == "D" || localinput == "d")
{
neworder.Locationid = custuser.Deflocationid; // localid for order
local2 = PizzaRepository.Grablocation(neworder.Locationid);
}
else
{
var newlocal = new Location();
Console.WriteLine("Enter street:");
var newstreet = Console.ReadLine();
Console.WriteLine("Enter City");
var newcity = Console.ReadLine();
Console.WriteLine("Enter State");
var newstate = Console.ReadLine();
newlocal.Street = newstreet;
newlocal.State = newstate;
newlocal.City = newcity;
PizzaRepository.Addlocation(newlocal);
PizzaRepository.Save(); //new local
local2 = PizzaRepository.Getlocations().Last();
neworder.Locationid = local2.Locationid; //localid fro order
}
Console.WriteLine("Which Store?");
Console.WriteLine("Pizza Palace North(N or n):");
Console.WriteLine("Pizza Palace Central(C or c):");
var storeinput = Console.ReadLine();
var storelist = PizzaRepository.Getpizzastores().ToList();
var pizzastore = new Pizzastore();
var ppinput = "";
if (storeinput == "N" || storeinput == "n")
{
ppinput = "Pizza Palace North";
for (var i = 0; i < storelist.Count(); i++)
{
if (ppinput == storelist[i].Name)
{
pizzastore = storelist[i];
}
}
}
else
{
ppinput = "Pizza Palace Central";
for (var i = 0; i < storelist.Count(); i++)
{
if (ppinput == storelist[i].Name)
{
pizzastore = storelist[i];
}
}
}
neworder.Storeid = pizzastore.Storeid; //store id for order
Console.WriteLine("How many pizzas would you like Pizzas($6.75 each)(less than 12):");
int pizzacount = Int32.Parse(Console.ReadLine());
while (pizzacount > 12 || pizzacount < 1)
{
Console.WriteLine("Quit messing, how many would you really like:");
pizzacount = Int32.Parse(Console.ReadLine());
}
var orderedpizzas = new Orderedpizzas();
orderedpizzas.Pizzascost = pizzacount * 6.75;
neworder.Totalcost = orderedpizzas.Pizzascost;
Console.WriteLine("How many Meatlovers would you like:");
int mlscount = Int32.Parse(Console.ReadLine());
while (mlscount > pizzacount)
{
Console.WriteLine("Too many! Try again.");
mlscount = Int32.Parse(Console.ReadLine());
}
if (mlscount > 0)
{
orderedpizzas.Meatlover = "meatlover";
orderedpizzas.Meatloverqty = mlscount;
}
pizzacount = pizzacount - mlscount;
if (pizzacount > 0)
{
Console.WriteLine("How many Supreme would you like:");
int supcount = Int32.Parse(Console.ReadLine());
while (supcount > pizzacount)
{
Console.WriteLine("Too many! Try again.");
supcount = Int32.Parse(Console.ReadLine());
}
if (supcount > 0)
{
orderedpizzas.Supreme = "supreme";
orderedpizzas.Supremeqty = supcount;
}
pizzacount = pizzacount - supcount;
if (pizzacount > 0)
{
Console.WriteLine("How many Hawaiian would you like:");
int hawcount = Int32.Parse(Console.ReadLine());
while (hawcount > pizzacount)
{
Console.WriteLine("Too many! Try again.");
hawcount = Int32.Parse(Console.ReadLine());
}
if (hawcount > 0)
{
orderedpizzas.Hawaiian = "hawaiian";
orderedpizzas.Hawaiianqty = hawcount;
}
pizzacount = pizzacount - hawcount;
}
if (pizzacount > 0)
{
Console.WriteLine("How many Margherita would you like:");
int marcount = Int32.Parse(Console.ReadLine());
while (marcount > pizzacount)
{
Console.WriteLine("Too many! Try again.");
marcount = Int32.Parse(Console.ReadLine());
}
if (marcount > 0)
{
orderedpizzas.Margherita = "margherita";
orderedpizzas.Margheritaqty = marcount;
}
pizzacount = pizzacount - marcount;
}
}
neworder.Dateplaced = DateTime.Now;
PizzaRepository.Addpizzaorder(orderedpizzas);
PizzaRepository.Save();
orderedpizzas = PizzaRepository.Getopids().Last();
neworder.Opid = orderedpizzas.Orderedpizzasid;
PizzaRepository.Addorder(neworder);
PizzaRepository.Save();
neworder = PizzaRepository.Getorders().Last();
// neworder.Opid = orderedpizzas.Orderedpizzasid;
var newhistory = new History();
newhistory.Userid = custuser.Userid;
newhistory.Storeid = pizzastore.Storeid; ////////////////////////////////////
newhistory.Orderid = neworder.Orderid;
PizzaRepository.Addtohistory(newhistory);
PizzaRepository.Save();
/////display order
Console.WriteLine("\nYour Receipt:\n");
Console.WriteLine($"{custuser.Username}\n");
Console.WriteLine($"{local2.Street}, {local2.City}, {local2.State}\n");
Console.WriteLine($"Courtesy of {pizzastore.Name}\n");
Console.WriteLine($"You ordered: {orderedpizzas.Meatloverqty} Meatlovers," +
$" {orderedpizzas.Hawaiianqty} Hawaiian, {orderedpizzas.Supremeqty} Supreme, " +
$"{orderedpizzas.Margheritaqty}, Margherita\n");
Console.WriteLine($"Total: {neworder.Totalcost}\n");
Console.WriteLine($"Date Placed: {neworder.Dateplaced}");
/////display order
}
else
{
var historylist = PizzaRepository.Gethistory().ToList();
var userhistory = new List <History>();
for (var i = 0; i < historylist.Count(); i++)
{
if (custuser.Userid == historylist[i].Userid)
{
userhistory.Add(historylist[i]);
}
}
Console.WriteLine("\nYour history:\n");
for (var i = 0; i < userhistory.Count(); i++)
{
var userstore = PizzaRepository.Grabstore(userhistory[i].Storeid);
Console.WriteLine($"Ordered from: {userstore.Name}\n");
var userorder = PizzaRepository.Graborder(userhistory[i].Orderid);
var userlocation = PizzaRepository.Grablocation(userorder.Locationid);
Console.WriteLine($"Ordered to {userlocation.Street}, {userlocation.City}, {userlocation.State}\n");
double pizzasnum = userorder.Totalcost / 6.75;
Console.WriteLine($"Placed {pizzasnum} # of Pizzas at a cost of {userorder.Totalcost}\n\n");
}
}
}
else // if your an employee
{
Console.WriteLine("Which location?:");
Console.WriteLine("Pizza Palace North (N or n) or Pizza Palace Central(C or c):");
var empinput = Console.ReadLine();
var newstore = new Pizzastore();
string storename;
if (empinput == "N" || empinput == "n")
{
storename = "Pizza Palace North";
var storelist = PizzaRepository.Getpizzastores().ToList();
for (var i = 0; i < storelist.Count(); i++)
{
if (storename == storelist[i].Name)
{
newstore = storelist[i];
}
}
Console.WriteLine("\nWould you like to search users(U or u):");
Console.WriteLine("Would you like to search history(H or h):");
Console.WriteLine("Would you like to check inventory(I or i):\n");
empinput = Console.ReadLine();
if (empinput == "U" || empinput == "u")
{
var user = new Customer();
Console.WriteLine("what is their username?:");
var username = Console.ReadLine();
user = PizzaRepository.Grabcustomer(username);
var deflocation = PizzaRepository.Grablocation(user.Deflocationid);
Console.WriteLine("\nTheir default location: ");
Console.WriteLine($"{deflocation.Street}, {deflocation.City}, {deflocation.State}\n");
var allhistory = PizzaRepository.Gethistory().ToList();
var userhistory = new List <History>();
for (var i = 0; i < allhistory.Count(); i++)
{
if (user.Userid == allhistory[i].Userid && newstore.Storeid == allhistory[i].Storeid)
{
userhistory.Add(allhistory[i]);
}
}
Console.WriteLine($"And they've ordered from {storename}: {userhistory.Count()} times");
}
else if (empinput == "H" || empinput == "h")
{
var allhistory = PizzaRepository.Gethistory().ToList();
var locationhistory = new List <History>();
for (var i = 0; i < allhistory.Count(); i++)
{
if (newstore.Storeid == allhistory[i].Storeid)
{
locationhistory.Add(allhistory[i]);
}
}
Console.WriteLine("How would you like to display history?");
Console.WriteLine("By earliest(E or e), by latest(L or l)");
Console.WriteLine("by cheapest(C or c), or by most expensive(M or m)");
var dispinput = Console.ReadLine();
var locationdelivery = new Location();
var storeuser = new Customer();
var storeorder = new Orderdetails();
if (dispinput == "E" || dispinput == "e")
{
Console.WriteLine($"\n{storename} history by Earliest:\n");
for (var i = 0; i < locationhistory.Count(); i++)
{
storeuser = PizzaRepository.Grabcustomerbyid(locationhistory[i].Userid);
storeorder = PizzaRepository.Graborder(locationhistory[i].Orderid);
locationdelivery = PizzaRepository.Grablocation(storeorder.Locationid);
Console.WriteLine($"Delivered to: {locationdelivery.Street}, " +
$"{locationdelivery.City}, {locationdelivery.State}\n");
double count = storeorder.Totalcost / 6.75;
Console.WriteLine($"{storeuser.Username} ordered {count} pizzas at a cost " +
$"of {storeorder.Totalcost} on {storeorder.Dateplaced}\n");
}
}
else if (dispinput == "L" || dispinput == "l")
{
Console.WriteLine($"\n{storename} history by Latest:\n");
for (var i = locationhistory.Count() - 1; i >= 0; i--)
{
storeuser = PizzaRepository.Grabcustomerbyid(locationhistory[i].Userid);
storeorder = PizzaRepository.Graborder(locationhistory[i].Orderid);
locationdelivery = PizzaRepository.Grablocation(storeorder.Locationid);
Console.WriteLine($"Delivered to: {locationdelivery.Street}, " +
$"{locationdelivery.City}, {locationdelivery.State}\n");
double count = storeorder.Totalcost / 6.75;
Console.WriteLine($"{storeuser.Username} ordered {count} pizzas at a cost " +
$"of {storeorder.Totalcost} on {storeorder.Dateplaced}\n");
}
}
else if (dispinput == "C" || dispinput == "c")
{
//have location history
var orderlist = new List <Orderdetails>();
//var historybycheap = new List<>
for (var i = 0; i < locationhistory.Count(); i++)
{
orderlist.Add(PizzaRepository.Graborder(locationhistory[i].Orderid));
// Console.WriteLine("\n added order to order list\n");
}
var neworderlist = new List <Orderdetails>();
for (var i = 0; i < orderlist.Count(); i++)
{
// Console.WriteLine("loop of orderlist");
if (neworderlist.Count() == 0)
{
neworderlist.Add(orderlist[i]);
}
else
{
var k = neworderlist.Count() - 1;
for (var j = 0; j < neworderlist.Count(); j++)
{
// Console.WriteLine("loop of neworderlist");
if (orderlist[i].Totalcost < neworderlist[j].Totalcost)
{
neworderlist.Insert(j, orderlist[i]);
// Console.WriteLine("\n inserted order to neworderlist\n");
}
else if (j == k)
{
neworderlist.Add(orderlist[i]);
// Console.WriteLine("\n added order to neworderlist\n");
}
}
}
}
Console.WriteLine($"\n{storename} history by Cheapest:\n");
for (var i = 0; i < neworderlist.Count(); i++)
{
storeuser = PizzaRepository.Grabcustomerbyid(neworderlist[i].Customerid);
// storeorder = PizzaRepository.Graborder(neworderlist[i].);
locationdelivery = PizzaRepository.Grablocation(neworderlist[i].Locationid);
Console.WriteLine($"Delivered to: {locationdelivery.Street}, " +
$"{locationdelivery.City}, {locationdelivery.State}\n");
double count = neworderlist[i].Totalcost / 6.75;
Console.WriteLine($"{storeuser.Username} ordered {count} pizzas at a cost " +
$"of {neworderlist[i].Totalcost} on {neworderlist[i].Dateplaced}\n");
}
}
else if (dispinput == "M" || dispinput == "m")
{
//have location history
var orderlist = new List <Orderdetails>();
//var historybycheap = new List<>
for (var i = 0; i < locationhistory.Count(); i++)
{
orderlist.Add(PizzaRepository.Graborder(locationhistory[i].Orderid));
}
var neworderlist = new List <Orderdetails>();
for (var i = 0; i < orderlist.Count(); i++)
{
if (neworderlist.Count() == 0)
{
neworderlist.Add(orderlist[i]);
}
else
{
for (var j = 0; j < neworderlist.Count(); j++)
{
if (orderlist[i].Totalcost > neworderlist[j].Totalcost)
{
neworderlist.Insert(j, orderlist[i]);
}
else if (j == (neworderlist.Count() - 1))
{
neworderlist.Add(orderlist[i]);
}
}
}
}
Console.WriteLine($"\n{storename} history by Most Expensive:\n");
for (var i = 0; i < neworderlist.Count(); i++)
{
storeuser = PizzaRepository.Grabcustomerbyid(neworderlist[i].Customerid);
// storeorder = PizzaRepository.Graborder(neworderlist[i].);
locationdelivery = PizzaRepository.Grablocation(neworderlist[i].Locationid);
Console.WriteLine($"Delivered to: {locationdelivery.Street}, " +
$"{locationdelivery.City}, {locationdelivery.State}\n");
double count = neworderlist[i].Totalcost / 6.75;
Console.WriteLine($"{storeuser.Username} ordered {count} pizzas at a cost " +
$"of {neworderlist[i].Totalcost} on {neworderlist[i].Dateplaced}\n");
}
}
}
else if (empinput == "I" || empinput == "i")
{
Console.WriteLine("Function not availabe (coming soon)");
}
}
else if (empinput == "C" || empinput == "c")
{
storename = "Pizza Palace Central";
var storelist = PizzaRepository.Getpizzastores().ToList();
for (var i = 0; i < storelist.Count(); i++)
{
if (storename == storelist[i].Name)
{
newstore = storelist[i];
}
}
Console.WriteLine("\nWould you like to search users(U or u):");
Console.WriteLine("Would you like to search history(H or h):");
Console.WriteLine("Would you like to check inventory(I or i):\n");
empinput = Console.ReadLine();
if (empinput == "U" || empinput == "u")
{
var user = new Customer();
Console.WriteLine("what is their username?:");
var username = Console.ReadLine();
user = PizzaRepository.Grabcustomer(username);
var deflocation = PizzaRepository.Grablocation(user.Deflocationid);
Console.WriteLine("\nTheir default location: ");
Console.WriteLine($"{deflocation.Street}, {deflocation.City}, {deflocation.State}\n");
var allhistory = PizzaRepository.Gethistory().ToList();
var userhistory = new List <History>();
for (var i = 0; i < allhistory.Count(); i++)
{
if (user.Userid == allhistory[i].Userid && newstore.Storeid == allhistory[i].Storeid)
{
userhistory.Add(allhistory[i]);
}
}
Console.WriteLine($"And they've ordered from {storename}: {userhistory.Count()} times");
}
else if (empinput == "H" || empinput == "h")
{
var allhistory = PizzaRepository.Gethistory().ToList();
var locationhistory = new List <History>();
for (var i = 0; i < allhistory.Count(); i++)
{
if (newstore.Storeid == allhistory[i].Storeid)
{
locationhistory.Add(allhistory[i]);
}
}
Console.WriteLine("How would you like to display history?");
Console.WriteLine("By earliest(E or e), by latest(L or l)");
Console.WriteLine("by cheapest(C or c), or by most expensive(M or m)");
var dispinput = Console.ReadLine();
var locationdelivery = new Location();
var storeuser = new Customer();
var storeorder = new Orderdetails();
if (dispinput == "E" || dispinput == "e")
{
Console.WriteLine($"\n{storename} history by Earliest:\n");
for (var i = 0; i < locationhistory.Count(); i++)
{
storeuser = PizzaRepository.Grabcustomerbyid(locationhistory[i].Userid);
storeorder = PizzaRepository.Graborder(locationhistory[i].Orderid);
locationdelivery = PizzaRepository.Grablocation(storeorder.Locationid);
Console.WriteLine($"Delivered to: {locationdelivery.Street}, " +
$"{locationdelivery.City}, {locationdelivery.State}\n");
double count = storeorder.Totalcost / 6.75;
Console.WriteLine($"{storeuser.Username} ordered {count} pizzas at a cost " +
$"of {storeorder.Totalcost} on {storeorder.Dateplaced}\n");
}
}
else if (dispinput == "L" || dispinput == "l")
{
Console.WriteLine($"\n{storename} history by Latest:\n");
for (var i = locationhistory.Count() - 1; i >= 0; i--)
{
storeuser = PizzaRepository.Grabcustomerbyid(locationhistory[i].Userid);
storeorder = PizzaRepository.Graborder(locationhistory[i].Orderid);
locationdelivery = PizzaRepository.Grablocation(storeorder.Locationid);
Console.WriteLine($"Delivered to: {locationdelivery.Street}, " +
$"{locationdelivery.City}, {locationdelivery.State}\n");
double count = storeorder.Totalcost / 6.75;
Console.WriteLine($"{storeuser.Username} ordered {count} pizzas at a cost " +
$"of {storeorder.Totalcost} on {storeorder.Dateplaced}\n");
}
}
else if (dispinput == "C" || dispinput == "c")
{
//have location history
var orderlist = new List <Orderdetails>();
//var historybycheap = new List<>
for (var i = 0; i < locationhistory.Count(); i++)
{
orderlist.Add(PizzaRepository.Graborder(locationhistory[i].Orderid));
Console.WriteLine("\n added order to order list\n");
}
var neworderlist = new List <Orderdetails>();
for (var i = 0; i < orderlist.Count(); i++)
{
Console.WriteLine("loop of orderlist");
if (neworderlist.Count() == 0)
{
neworderlist.Add(orderlist[i]);
}
else
{
var k = neworderlist.Count() - 1;
for (var j = 0; j < neworderlist.Count(); j++)
{
Console.WriteLine("loop of neworderlist");
if (orderlist[i].Totalcost < neworderlist[j].Totalcost)
{
neworderlist.Insert(j, orderlist[i]);
Console.WriteLine("\n inserted order to neworderlist\n");
}
else if (j == k)
{
neworderlist.Add(orderlist[i]);
Console.WriteLine("\n added order to neworderlist\n");
}
}
}
}
Console.WriteLine($"\n{storename} history by Cheapest:\n");
for (var i = 0; i < neworderlist.Count(); i++)
{
storeuser = PizzaRepository.Grabcustomerbyid(neworderlist[i].Customerid);
// storeorder = PizzaRepository.Graborder(neworderlist[i].);
locationdelivery = PizzaRepository.Grablocation(neworderlist[i].Locationid);
Console.WriteLine($"Delivered to: {locationdelivery.Street}, " +
$"{locationdelivery.City}, {locationdelivery.State}\n");
double count = neworderlist[i].Totalcost / 6.75;
Console.WriteLine($"{storeuser.Username} ordered {count} pizzas at a cost " +
$"of {neworderlist[i].Totalcost} on {neworderlist[i].Dateplaced}\n");
}
}
else if (dispinput == "M" || dispinput == "m")
{
//have location history
var orderlist = new List <Orderdetails>();
//var historybycheap = new List<>
for (var i = 0; i < locationhistory.Count(); i++)
{
orderlist.Add(PizzaRepository.Graborder(locationhistory[i].Orderid));
}
var neworderlist = new List <Orderdetails>();
for (var i = 0; i < orderlist.Count(); i++)
{
if (neworderlist.Count() == 0)
{
neworderlist.Add(orderlist[i]);
}
else
{
for (var j = 0; j < neworderlist.Count(); j++)
{
if (orderlist[i].Totalcost > neworderlist[j].Totalcost)
{
neworderlist.Insert(j, orderlist[i]);
}
else if (j == (neworderlist.Count() - 1))
{
neworderlist.Add(orderlist[i]);
}
}
}
}
Console.WriteLine($"\n{storename} history by Most Expensive:\n");
for (var i = 0; i < neworderlist.Count(); i++)
{
storeuser = PizzaRepository.Grabcustomerbyid(neworderlist[i].Customerid);
// storeorder = PizzaRepository.Graborder(neworderlist[i].);
locationdelivery = PizzaRepository.Grablocation(neworderlist[i].Locationid);
Console.WriteLine($"Delivered to: {locationdelivery.Street}, " +
$"{locationdelivery.City}, {locationdelivery.State}\n");
double count = neworderlist[i].Totalcost / 6.75;
Console.WriteLine($"{storeuser.Username} ordered {count} pizzas at a cost " +
$"of {neworderlist[i].Totalcost} on {neworderlist[i].Dateplaced}\n");
}
}
}
else if (empinput == "I" || empinput == "i")
{
Console.WriteLine("Function not availabe (coming soon)");
}
}
}
}
