public ActionResult Create([Bind(Include = "CategoryId,Name")] Category category)
{
if (ModelState.IsValid)
{
db.Categories.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(category));
}
public ActionResult Create([Bind(Include = "BookId,CategoryId,ImageLink,Name,Author,Description,Price")] Book book)
{
if (ModelState.IsValid)
{
db.Books.Add(book);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CategoryId = new SelectList(db.Categories, "CategoryId", "Name", book.CategoryId);
return(View(book));
}
public ActionResult Create([Bind(Include = "OrderId,User,First,LastName,Country,Phone,Email,Total")] Order order)
{
if (ModelState.IsValid)
{
db.Orders.Add(order);
db.SaveChanges();
var items = db.Cart.ToList();
db.Cart.RemoveRange(items);
db.SaveChanges();
return(RedirectToAction("Index2"));
}
return(View(order));
}
private static void Run()
{
Console.WriteLine("Please enter your user id, or if you are a new user, enter your desired user id");
string Name = Console.ReadLine();
Customer Customer = _customerSingleton.FindCustomer(Name);
Console.WriteLine("Enter 1 to place order, 2 to view order history");
string response = Console.ReadLine();
if (response == "1")
{
myDBContext context = new myDBContext();
var order = new Order();
Console.WriteLine("Welcome to PizzaBox");
DisplayStoreMenu();
order.Customer = new Customer();
int num = 0;
SelectStore(ref num);
order.Store = _storeSingleton.Stores[num].Name;
order.Pizzas = SelectPizza();
Console.WriteLine($"Your total is ${order.GetPrice()}");
Console.WriteLine($"{order.ToString()}");
_storeSingleton.Stores[num].orders.Add(order);
_storeSingleton.finish();
_customerSingleton.AddOrder(order, Name);
_customerSingleton.finish();
var OH = new OrderHistory()
{
StoreName = _storeSingleton.Stores[num].Name,
CustomerName = Name,
TotalPrice = (int)order.GetPrice(),
};
OH.SetPriceZero();
context.Add(OH);
context.SaveChanges();
}
else
{
Console.WriteLine(Customer.ToString());
}
}
static void Main(string[] args)
{
using (var context = new myDBContext())
{
while (true)
{
Console.WriteLine("|----------------------------------------------------------------------------------------------------|");
System.Console.WriteLine("Type command");
System.Console.WriteLine("Usage");
System.Console.WriteLine("Create:\t s(Student), t(Teacher), c(Course), e(Exercise HelpRequest), a(Assignment HelpRequest)");
System.Console.WriteLine("Lists:\t ls(Students), lt(Teachers), lc(Courses)");
System.Console.WriteLine("Find:\t sfr(helpRequests by student), tcfr(help request by teacher/course)");
System.Console.WriteLine("print:\t pa (print all help requests)");
System.Console.WriteLine("Exit:\t x");
Console.WriteLine("|----------------------------------------------------------------------------------------------------|\n");
string line = Console.ReadLine();
switch (line)
{
case "s":
Student student = CreateStudent(context);
context.Students.Add(student);
context.SaveChanges();
break;
case "c":
Course course = CreateCourse(context);
context.Courses.Add(course);
context.SaveChanges();
break;
case "t":
Teacher teacher = CreateTeacher(context);
context.Teachers.Add(teacher);
context.SaveChanges();
break;
case "e":
Exercise exercise = CreateExeciseHelpRequest(context);
context.Exercises.Add(exercise);
context.SaveChanges();
break;
case "a":
Assignment assignment = CreateAssignmentHelpRequest(context);
context.Assignments.Add(assignment);
context.SaveChanges();
break;
case "ls":
ListAllStudents(context);
break;
case "lt":
ListAllTeachers(context);
break;
case "lc":
ListAllCourses(context);
break;
case "tcfr":
View_Teacher_Course_HelpRequests(context);
break;
case "sfr":
View_Students_HelpRequest(context);
break;
case "pa":
View_Print_all_helprequest(context);
break;
case "x":
System.Console.WriteLine("Exiting....");
return;
default:
System.Console.WriteLine("Unknown command");
break;
}
}
}
}
static void Run()
{
bool CanOrder = true;
//login + save the store visit
var context = new myDBContext();
Console.WriteLine("Enter your user ID");
string CustomerName = Console.ReadLine();
string StoreName = "";
Console.WriteLine("Enter 1 for Domino's, 2 for Pizza Hut");
string Selection = Console.ReadLine();
switch (Selection)
{
case "1":
StoreName = "Dominoes";
break;
case "2":
StoreName = "PizzaHut";
break;
}
var CurrentDt = DateTime.Now;
var Store = context.Stores.Single(a => a.Name == StoreName);
var Customer = context.Customers.SingleOrDefault(a => a.Name == CustomerName);
if (Customer == null)
{
Customer = new Customer()
{
Name = CustomerName,
LastTimeOrdered = CurrentDt,
LastStoreVisited = Store.Id,
LastStoreVisitTime = CurrentDt,
};
context.Add(Customer);
context.SaveChanges();
}
else
{
if (Store.Id != Customer.LastStoreVisited && CurrentDt < Customer.LastStoreVisitTime.AddHours(24))
{
Console.WriteLine($"You are still locked into {context.Stores.Single(a => a.Id == Customer.LastStoreVisited).Name}");
CanOrder = false;
}
else if (CurrentDt < Customer.LastTimeOrdered.AddHours(2))
{
Console.WriteLine("You can only order once every 2 hours");
CanOrder = false;
}
else
{
Customer.LastTimeOrdered = CurrentDt;
Customer.LastStoreVisited = Store.Id;
Customer.LastStoreVisitTime = CurrentDt;
}
}
//finished login
if (CanOrder)
{
var Order = new Order()
{
CustomerId = Customer.Id,
StoreId = Store.Id,
DateAndTime = CurrentDt,
};
//this loops and allows the customer to add or complete their order
Console.WriteLine("Enter 1 to order, 0 if you don't want to order or if you want to finalize your order");
int OrderOrNot = int.Parse(Console.ReadLine());
decimal OrderTotalPrice = 0;
int OrderSizeLimit = 50;
decimal PriceLimit = 250;
while (OrderOrNot != 0 && --OrderSizeLimit > -1)
{
//SHOULD BE IN a while loop that repeatedly asks if user wants to add another pizza to order
//selecting a pizza preset
if (OrderOrNot == 1)
{
Console.WriteLine("Enter 1 for preset Pizza, 2 for custom");
int CustomOrPreset = int.Parse(Console.ReadLine());
if (CustomOrPreset == 1)
{
Console.WriteLine("Enter 2 for MeatPizza, 3 for Veggie");
int PizzaChoice = int.Parse(Console.ReadLine());
var Pizza = context.Pizzas.FirstOrDefault(p => p.Id == PizzaChoice);
if (OrderTotalPrice + Pizza.Price > PriceLimit)
{
OrderOrNot = 0;
Console.WriteLine("You've exceed the order price limit, discarding the last selected pizza");
}
else
{
var OrderPizza = new OrderPizza()
{
Order = Order,
Pizza = Pizza,
Price = Pizza.Price,
};
context.Add(OrderPizza);
OrderTotalPrice += Pizza.Price;
}
}
//custom pizza setup
else
{
Console.WriteLine("Pick a crust type");
foreach (Crust Crust in context.Crusts)
{
Console.WriteLine($"{Crust.Id}-{Crust.Type}: {Crust.Price}");
}
int CrustChoice = int.Parse(Console.ReadLine());
var ChosenCrust = context.Crusts.SingleOrDefault(a => a.Id == CrustChoice);
Console.WriteLine("Pick a size type");
foreach (Size Size in context.Sizes)
{
Console.WriteLine($"{Size.Id}-{Size.Type}: {Size.Price}");
}
int SizeChoice = int.Parse(Console.ReadLine());
var ChosenSize = context.Sizes.SingleOrDefault(a => a.Id == SizeChoice);
//Has to be modified to allow picking an array of toppings
decimal PizzaPrice = 0;
List <Topping> ChosenToppings = new List <Topping>();
ChosenToppings.Add(context.Toppings.Single(a => a.Id == 1));
ChosenToppings.Add(context.Toppings.Single(a => a.Id == 2));
PizzaPrice += 4;
for (int i = 0; i < 3; i++)
{
Console.WriteLine("Pick a Topping type, -1 to exit");
foreach (Topping Topping in context.Toppings)
{
Console.WriteLine($"{Topping.Id}-{Topping.Type}: {Topping.Price}");
}
int ToppingChoice = int.Parse(Console.ReadLine());
if (ToppingChoice != -1)
{
var ChosenTopping = context.Toppings.Single(a => a.Id == ToppingChoice);
ChosenToppings.Add(ChosenTopping);
PizzaPrice += ChosenTopping.Price;
}
else
{
i = 24;
}
}
PizzaPrice += ChosenCrust.Price;
PizzaPrice += ChosenSize.Price;
//var Pizza = context.Pizzas.SingleOrDefault(a => a.Crust == ChosenCrust && a.Size == ChosenSize && a.PizzaToppings == { ChosenTopping} );
if (OrderTotalPrice + PizzaPrice > PriceLimit)
{
OrderOrNot = 0;
Console.WriteLine("You've exceed the order price limit, discarding the last selected pizza");
}
else
{
var OrderPizza = new OrderPizza()
{
Order = Order,
Price = PizzaPrice,
};
context.Add(OrderPizza);
OrderTotalPrice += PizzaPrice;
}
}
if (OrderOrNot == 1)
{
Console.WriteLine("Enter 1 to keep ordering, 0 if you want to finalize your order");
OrderOrNot = int.Parse(Console.ReadLine());
}
}
}
Order.Price = OrderTotalPrice;
context.Add(Order);
context.SaveChanges();
//At this point we have the order and the OrderPizzas in the database,
//Price is below 250 and # items is < 50
//let user remove items if they choose
Console.WriteLine("Enter 1 to modify your order, or 0 to see final price");
int ModifyChoice = int.Parse(Console.ReadLine());
while (ModifyChoice == 1)
{
var Items = context.OrderPizzas
.Where(a => a.OrderId == Order.Id)
.ToList();
if (Items.Count > 0)
{
Console.WriteLine("Enter number corresponding to the order item you want removed");
foreach (var Item in Items)
{
Console.WriteLine($"{Item.Id}: Pizza that costs {Item.Price} dollars");
}
int ItemSelection = int.Parse(Console.ReadLine());
var ItemToRemove = context.OrderPizzas.Single(a => a.OrderId == Order.Id && a.Id == ItemSelection);
context.OrderPizzas.Remove(ItemToRemove);
Order.Price -= ItemToRemove.Price;
context.SaveChanges();
}
else
{
Console.WriteLine("No items left to remove");
}
Console.WriteLine("Enter 1 to keep modifying your order, or 0 to see final price");
ModifyChoice = int.Parse(Console.ReadLine());
}
Console.WriteLine($"Final Price: {Order.Price}");
}
}