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 DeleteOrder(int id)
{
var db = new JustFeastDbDataContext();
db.Orders.DeleteOnSubmit(db.Orders.FirstOrDefault(x => x.id == id));
db.SubmitChanges();
}
public void CreateOrder(ModelLibrary.Order order)
{
var db = new JustFeastDbDataContext();
db.Orders.InsertOnSubmit(new OrderCtrl().ConvertOrder(order));
db.SubmitChanges();
}
public static Restaurant GetRestaurant(int restaurantId)
{
var db = new JustFeastDbDataContext();
var res = db.Restaurants.FirstOrDefault(x => x.id == restaurantId);
return(res);
}
public void DeleteRestaurantCategory(int id)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
db.ResCats.DeleteOnSubmit(db.ResCats.First(x => x.id == id));
db.SubmitChanges();
}
public void CreateRestaurantCategory(RestaurantCategory res)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
db.ResCats.InsertOnSubmit(RestaurantCtrl.ConvertRestaurantCategoryToDatabase(res));
db.SubmitChanges();
}
public void AddItemCat(ItemCat itemCat)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
db.ItemCats.InsertOnSubmit(itemCat);
db.SubmitChanges();
}
public ModelLibrary.Customer GetCustomerById(int id)
{
var db = new JustFeastDbDataContext();
var cus = db.Customers.FirstOrDefault(x => x.id == id);
return(CustomerCtrl.ConvertCustomerToModel(cus));
}
public List <DatabaseAccessLibrary.Order> GetOrderHistoryByCustomerId(int id)
{
var db = new JustFeastDbDataContext();
var orderList = new List <Order>();
var tempOrder = new Order();
var query = from orders in db.Orders
join orderHistoryTable in db.OrderHistories on orders.id equals orderHistoryTable.orderId
where orderHistoryTable.customerId == id
select new
{
orders.id,
orders.restaurantId,
orders.dateTime,
orders.reservation,
orders.noSeats,
orders.accepted
};
foreach (var order in query)
{
tempOrder.id = order.id;
tempOrder.restaurantId = order.restaurantId;
tempOrder.dateTime = order.dateTime;
tempOrder.reservation = order.reservation;
tempOrder.noSeats = order.noSeats;
tempOrder.accepted = order.accepted;
orderList.Add(tempOrder);
}
return(orderList);
}
public IEnumerable <OrderLineItem> GetOrderLineItemsById(int id)
{
var db = new JustFeastDbDataContext();
var items = db.OrderLineItems.Where(oi => oi.orderId == id).AsEnumerable();
return(items);
}
public void UpdateItemCat(ModelLibrary.ItemCat beforeItemCat, ModelLibrary.ItemCat afterItemCat)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
ItemCtrl itemCtrl = new ItemCtrl();
itemCtrl.UpdateItemCat(beforeItemCat, afterItemCat);
}
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 AddPrice(Price price)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
db.Prices.InsertOnSubmit(price);
db.SubmitChanges();
}
public void UpdateMenu(ModelLibrary.Menu beforeMenu, ModelLibrary.Menu afterMenu)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
MenuCtrl menuCtrl = new MenuCtrl();
menuCtrl.UpdateMenu(beforeMenu, afterMenu);
}
public void Edit_Item_With_Price()
{
ItemCtrl itemCtrl = new ItemCtrl();
ItemDb itemDb = new ItemDb();
//Setup
ItemService itemService = new ItemService();
PriceService priceService = new PriceService();
//Act
JustFeastDbDataContext db = new JustFeastDbDataContext();
var testItem = itemService.GetItem(1000000);
var testPrice = priceService.GetLatestPrice(1000000);
ModelLibrary.Item newItemUpdated = new ModelLibrary.Item
{
Id = 1000000,
Name = "testNameUpdated",
Description = "testDescrUpdated",
Price = testPrice
};
priceService.UpdatePrice(testPrice, 1000000);
itemService.UpdateItem(newItemUpdated, 1000000, 1000000);
priceService.UpdatePrice(testPrice, 1000000);
//Assert
Assert.IsFalse(testItem.Name == "testNameUpdated");
}
public void DeleteRestaurant(ModelLibrary.Restaurant restaurant)
{
var db = new JustFeastDbDataContext();
db.Restaurants.DeleteOnSubmit(RestaurantCtrl.ConvertRestaurantToDatabase(restaurant));
db.SubmitChanges();
}
public ModelLibrary.Customer GetCustomerByEmail(string email)
{
var db = new JustFeastDbDataContext();
var cus = db.Customers.FirstOrDefault(x => x.email.Equals(email));
return(CustomerCtrl.ConvertCustomerToModel(cus));
}
public void CreateOrder(Order order)
{
var db = new JustFeastDbDataContext();
db.Orders.InsertOnSubmit(order);
db.SubmitChanges();
}
public int GetActiveMenuId(int restaurantId)
{
var db = new JustFeastDbDataContext();
return(db.Menus.SingleOrDefault(t => t.restaurantId == restaurantId &&
t.active).id);
}
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 Price GetPriceByIdAndStartDate(int itemId, DateTime startDate)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
var pric = db.Prices.Single(t => t.itemId == itemId && t.startDate == startDate);
return(pric);
}
public IEnumerable <Item> GetItems()
{
var db = new JustFeastDbDataContext();
var items = db.Items.AsEnumerable();
return(items);
}
public IEnumerable <Menu> GetMenus()
{
var db = new JustFeastDbDataContext();
var menus = db.Menus.AsEnumerable();
return(menus);
}
public Menu GetActiveMenu(int restaurantId)
{
var db = new JustFeastDbDataContext();
var menu = db.Menus.FirstOrDefault(t => t.restaurantId == restaurantId &&
t.active == true);
return(menu);
}
public IEnumerable <ResTable> GetTables()
{
var db = new JustFeastDbDataContext();
var resTables = db.ResTables.AsEnumerable();
return(resTables);
}
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 ItemCat GetItemCatByItemCatId(int itemId)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
var item = db.Items.Where(t => t.id == itemId).SingleOrDefault();
var itemCat = db.ItemCats.Where(t => t.id == item.itemCatId).SingleOrDefault();
return(itemCat);
}
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 ItemCat GetItemCatById(int id)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
var item = db.ItemCats.Single(t => t.id == id);
return(item);
}
public ItemCat GetITemCatByName(string name)
{
JustFeastDbDataContext db = new JustFeastDbDataContext();
var item = db.ItemCats.First(t => t.name == name);
return(item);
}
