public void RemoveFromCart(string menuItemName)
{
var context = new truYumContext();
var query = context.Carts.Include("MenuItem").Where(iter => iter.UserId == 1).ToList();
if (query == null)
{
Console.WriteLine("No item in cart for the user");
}
else
{
bool datacorrectness = true;
int f = 0;
while (datacorrectness)
{
foreach (var cart in query)
{
if (cart.menuItem.Name == menuItemName)
{
context.Carts.Remove(cart);
Console.WriteLine("Menu Item removed from cart successfully");
datacorrectness = false;
f = 1;
}
}
if (f == 0)
{
Console.WriteLine("Incorrect menu item name Please reenter");
}
}
}
context.SaveChanges();
}
public void AddToCart(string menuItemName)
{
var context = new truYumContext();
var query = from menu in context.MenuItems where menu.Name == menuItemName select menu;
bool datacorrectness = true;
while (datacorrectness)
{
if (query == null)
{
Console.WriteLine("Incorrect menu item name.Please reenter");
datacorrectness = false;
}
else
{
int userId = 1;
Cart c = new Cart();
c.UserId = userId;
c.MenuItemId = query.First().Id;
context.Carts.Add(c);
context.SaveChanges();
Console.WriteLine("Menu item added to cart successfully");
Console.WriteLine("Do you want to continue adding to cart[Y|N]");
char ch = char.Parse(Console.ReadLine());
if (ch == 'N')
{
datacorrectness = false;
break;
}
Console.WriteLine("Enter the name of the item to add into cart");
AddToCart(Console.ReadLine());
}
}
}
public void ViewMenuItemAdmin()
{
var context = new truYumContext();
var q = context.MenuItems.Include("Category").ToList();
foreach (var menu in q)
{
Console.WriteLine(menu.Name);
Console.WriteLine(menu.Price);
Console.WriteLine(menu.DateOflaunch.ToShortDateString());
Console.WriteLine(menu.Active);
Console.WriteLine(menu.FreeDelivery);
Console.WriteLine("********-------------------------------------*********************");
}
}
public void EditMenuItem(string menuItemName)
{
var context = new truYumContext();
var query = from menu in context.MenuItems where menu.Name == menuItemName select menu;
if (query == null)
{
Console.WriteLine("Incorrect menu item.please check\n");
}
else
{
bool datacorrectness = true;
while (datacorrectness)
{
if (query == null || query.First().Name == " ")
{
Console.WriteLine("Incorrect name.Please provide valid name");
menuItemName = Console.ReadLine();
datacorrectness = false;
break;
}
else
{
var cat = from category in context.Categories where category.Name == query.First().category.Name select category;
if (cat == null)
{
Console.WriteLine("Incorrect category.Please reenter data");
datacorrectness = false;
}
else
{
Console.WriteLine("All data is correct");
Console.WriteLine("Enter price to edit");
query.First().Price = double.Parse(Console.ReadLine());
datacorrectness = false;
context.MenuItems.AddOrUpdate();
context.SaveChanges();
Console.WriteLine("Data is saved,Here is the updated data");
ViewMenuItemListAdmin viewdata = new ViewMenuItemListAdmin();
viewdata.ViewMenuItemAdmin();
}
}
}
}
}
public void ViewMenuItemsCustomer()
{
var context = new truYumContext();
var query = context.MenuItems.Where(iter => iter.Active == true && System.Data.Entity.DbFunctions.DiffDays(DateTime.Now, iter.DateOflaunch) < 0).ToList();
foreach (var menu in query)
{
Console.WriteLine("Id " + menu.Id);
Console.WriteLine("Name " + menu.Name);
Console.WriteLine("Price " + menu.Price);
Console.WriteLine("FreeDelivery " + menu.FreeDelivery);
Console.WriteLine("DateOflaunch " + menu.DateOflaunch);
Console.WriteLine("Active " + menu.Active);
Console.WriteLine("****--------------------------------*****");
}
}
public void ViewCartItems()
{
var context = new truYumContext();
var query = context.Carts.Include("MenuItem").Where(iter => iter.UserId == 1).ToList();
if (query.Count == 0)
{
Console.WriteLine("\nCart Empty");
}
else
{
Console.WriteLine("\nItems in Cart");
foreach (var cart in query)
{
Console.WriteLine(cart.menuItem.Name);
Console.WriteLine(cart.menuItem.Price);
Console.WriteLine("------------------------");
}
}
}
public void AddMenuItem(string name, string category, double price, Boolean isActive, DateTime dateOfLaunch, Boolean freeDelivery)
{
var context = new truYumContext();
int categoryId = context.Categories.Where(iter => iter.Name.Equals(category, StringComparison.OrdinalIgnoreCase)).Select(iter => iter.Id).FirstOrDefault();
MenuItem menuItem = new MenuItem();
menuItem.Name = name;
menuItem.Price = price;
menuItem.Active = isActive;
menuItem.DateOflaunch = dateOfLaunch;
menuItem.FreeDelivery = freeDelivery;
if (!Convert.ToBoolean(categoryId))
{
Console.WriteLine("\nCategory does not exist");
}
else
{
menuItem.CategoryId = categoryId;
context.MenuItems.Add(menuItem);
Console.WriteLine("\nAdded Successfully");
context.SaveChanges();
}
}
