public static bool RegisterUser(ModelLibrary.Customer mCus, string passwordHashed) { var customer = ConvertCustomerToDatabase(mCus); if (customer == null) { return(false); } var db = new JustFeastDbDataContext(); if (db.Customers.Any(x => x.email.Equals(customer.email))) { return(false); } db.Customers.InsertOnSubmit(customer); db.SubmitChanges(); db.Users.InsertOnSubmit(new DatabaseAccessLibrary.User { customerId = db.Customers.FirstOrDefault(x => x.email == customer.email).id, password = passwordHashed }); db.SubmitChanges(); return(true); }
public void CreateRestaurantCategory(RestaurantCategory res) { JustFeastDbDataContext db = new JustFeastDbDataContext(); db.ResCats.InsertOnSubmit(RestaurantCtrl.ConvertRestaurantCategoryToDatabase(res)); db.SubmitChanges(); }
public void DeleteRestaurantCategory(int id) { JustFeastDbDataContext db = new JustFeastDbDataContext(); db.ResCats.DeleteOnSubmit(db.ResCats.First(x => x.id == id)); db.SubmitChanges(); }
public void DeleteOrder(int id) { var db = new JustFeastDbDataContext(); db.Orders.DeleteOnSubmit(db.Orders.FirstOrDefault(x => x.id == id)); db.SubmitChanges(); }
public void AddItemCat(ItemCat itemCat) { JustFeastDbDataContext db = new JustFeastDbDataContext(); db.ItemCats.InsertOnSubmit(itemCat); db.SubmitChanges(); }
public void AddPrice(Price price) { JustFeastDbDataContext db = new JustFeastDbDataContext(); db.Prices.InsertOnSubmit(price); db.SubmitChanges(); }
public void CreateOrder(Order order) { var db = new JustFeastDbDataContext(); db.Orders.InsertOnSubmit(order); db.SubmitChanges(); }
public void DeleteRestaurant(ModelLibrary.Restaurant restaurant) { var db = new JustFeastDbDataContext(); db.Restaurants.DeleteOnSubmit(RestaurantCtrl.ConvertRestaurantToDatabase(restaurant)); db.SubmitChanges(); }
public void AddItemToOrder(int orderId, int itemId, int resId) { var ordC = new OrderCtrl(); var db = new JustFeastDbDataContext(); var item = db.Items.SingleOrDefault(i => i.id == itemId); if (orderId == 0) { orderId = ordC.GetLastOrderIdentity() + 1; var order = new DatabaseAccessLibrary.Order { id = orderId, restaurantId = resId }; db.Orders.InsertOnSubmit(order); } var exists = db.OrderLineItems.SingleOrDefault(i => i.itemId == itemId && i.orderId == orderId); if (exists != null) { exists.quantity++; } else if (item != null) { var oli = new DatabaseAccessLibrary.OrderLineItem { orderId = orderId, itemId = item.id, quantity = 1 }; db.OrderLineItems.InsertOnSubmit(oli); } db.SubmitChanges(); }
public void CreateOrder(ModelLibrary.Order order) { var db = new JustFeastDbDataContext(); db.Orders.InsertOnSubmit(new OrderCtrl().ConvertOrder(order)); db.SubmitChanges(); }
public void DeleteOrderLineItem(int itemId) { var db = new JustFeastDbDataContext(); var oli = db.OrderLineItems.Where(x => x.itemId == itemId); db.OrderLineItems.DeleteAllOnSubmit(oli); db.SubmitChanges(); }
public void UpdateRestaurantCategory(RestaurantCategory res) { JustFeastDbDataContext db = new JustFeastDbDataContext(); var nres = db.ResCats.First(x => x.id == res.Id); nres.name = res.Name; db.SubmitChanges(); }
public void UpdateOrder(ModelLibrary.Order order) { var db = new JustFeastDbDataContext(); var dbOrder = db.Orders.FirstOrDefault(x => x.id == Convert.ToInt32(order.OrderId)); dbOrder.accepted = order.Accepted; db.SubmitChanges(); }
public void AddItem(Item item) { JustFeastDbDataContext db = new JustFeastDbDataContext(); db.Items.InsertOnSubmit(item); db.SubmitChanges(); int id = item.id; }
public void UpdatePrice(Price price) { var db = new JustFeastDbDataContext(); var pric = db.Prices.FirstOrDefault(x => x.itemId == price.itemId); pric.price1 = price.price1; db.SubmitChanges(); }
public void UpdateMenu(Menu beforeMenu, Menu afterMenu) { var db = new JustFeastDbDataContext(); var dbMenu = db.Menus.SingleOrDefault(t => t.id == beforeMenu.id && t.id == afterMenu.id); dbMenu.restaurantId = afterMenu.restaurantId; dbMenu.name = afterMenu.name; dbMenu.active = afterMenu.active; db.SubmitChanges(); }
public void ReserveSingleTable(int tableId, int orderId) { var db = new JustFeastDbDataContext(); db.ReservedTables.InsertOnSubmit(new ReservedTable { orderId = orderId, tableId = tableId }); db.SubmitChanges(); }
public int AddOrder(Order order) { var db = new JustFeastDbDataContext(); db.Orders.InsertOnSubmit(order); db.OrderLineItems.InsertAllOnSubmit(order.OrderLineItems); db.SubmitChanges(); return(order.id); }
public void AddTable(ResTable resTable) { var db = new JustFeastDbDataContext(); if (db.ResTables.FirstOrDefault(t => (t.restaurantId == resTable.restaurantId)) != null) { db.ResTables.InsertOnSubmit(resTable); db.SubmitChanges(); } }
public void AddMenu(Menu menu) { JustFeastDbDataContext db = new JustFeastDbDataContext(); if (db.Menus.Any(t => !(t.restaurantId == menu.restaurantId && t.active == menu.active && t.active == true))) { db.Menus.InsertOnSubmit(menu); } db.SubmitChanges(); }
public void UpdateItemCat(ItemCat beforeItemCat, ItemCat afterItemCat) { var db = new JustFeastDbDataContext(); var dbItemCat = db.ItemCats.SingleOrDefault(t => t.id == beforeItemCat.id && beforeItemCat.id == afterItemCat.id); dbItemCat.id = afterItemCat.id; dbItemCat.name = afterItemCat.name; db.SubmitChanges(); }
public void DeleteMenu(int menuId) { var db = new JustFeastDbDataContext(); DatabaseAccessLibrary.Menu dbMenu = db.Menus.First(t => t.id == menuId); if (dbMenu != null) { db.Menus.DeleteOnSubmit(db.Menus.First(t => t.id == menuId)); db.SubmitChanges(); } }
public void DeletePricesByItemId(int itemId) { var db = new JustFeastDbDataContext(); var dbPrice = db.Prices.Where(t => t.itemId == itemId); if (dbPrice != null) { db.Prices.DeleteAllOnSubmit(dbPrice); db.SubmitChanges(); } }
public void DeleteItem(int itemId) { var db = new JustFeastDbDataContext(); DatabaseAccessLibrary.Item dbItem = db.Items.First(t => t.id == itemId); if (dbItem != null) { db.Items.DeleteOnSubmit(dbItem); db.SubmitChanges(); } }
public void DeleteItemCat(int itemCatId) { var db = new JustFeastDbDataContext(); var check = db.ItemCats.SingleOrDefault(t => t.id == itemCatId); if (check != null) { db.ItemCats.DeleteOnSubmit(db.ItemCats.First(t => t.id == itemCatId)); db.SubmitChanges(); } }
public void ReserveTables(IEnumerable <ResTable> reserveTables, int orderId) { foreach (var table in reserveTables) { var reservedTable = new ReservedTable(); reservedTable.orderId = orderId; reservedTable.tableId = table.id; db.ReservedTables.InsertOnSubmit(reservedTable); } db.SubmitChanges(); }
public void UpdateItem(Item updatedItem) { var db = new JustFeastDbDataContext(); var dbItem = db.Items.First(t => t.id == updatedItem.id); dbItem.menuId = updatedItem.menuId; dbItem.name = updatedItem.name; dbItem.description = updatedItem.description; dbItem.itemCatId = updatedItem.itemCatId; db.SubmitChanges(); }
public void CreateRestaurant(ModelLibrary.Restaurant restaurant) { JustFeastDbDataContext db = new JustFeastDbDataContext(); var res = RestaurantCtrl.ConvertRestaurantToDatabase(restaurant); if (restaurant.Category != null) { res.ResCat = db.ResCats.FirstOrDefault(x => x.id == restaurant.Category.Id); } db.Restaurants.InsertOnSubmit(res); db.SubmitChanges(); }
public void DeleteItemById(int orderId, int itemId) { var db = new JustFeastDbDataContext(); var lineitem = db.OrderLineItems.FirstOrDefault(x => x.orderId == orderId && x.itemId == itemId); if (lineitem.quantity > 1) { lineitem.quantity--; } else { db.OrderLineItems.DeleteOnSubmit(lineitem); } db.SubmitChanges(); }
public void UpdateOrder(Order order) { var db = new JustFeastDbDataContext(); var ord = db.Orders.SingleOrDefault(o => o.id == order.id); if (ord != null) { ord.OrderLineItems = order.OrderLineItems; ord.restaurantId = order.restaurantId; ord.accepted = order.accepted; ord.dateTime = order.dateTime; ord.reservation = order.reservation; ord.noSeats = order.noSeats; db.SubmitChanges(); } }