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 ModelLibrary.Order GetOrderById(int orderId)
{
var ctrl = new OrderCtrl();
var order = ctrl.GetOrderById(orderId);
return(order);
}
public void DeleteItem(int itemId)
{
var orderC = new OrderCtrl();
orderC.DeleteOrderLineItem(itemId);
itemDb.DeleteItem(itemId);
}
public void Convert_OrderLineItem_To_Db_Test()
{
//Setup
var ordC = new OrderCtrl();
var oli = new List <OrderLineItem>();
var item = new ModelLibrary.Item();
item.Id = 1000000;
oli.Add(new OrderLineItem(item, 2));
var mOrder = new Order
{
OrderId = "1000002",
CustomerId = "1000000",
RestaurantId = "1000000",
DateTime = "2018-11-08 12:22:33",
ReservationDateTime = "2018-11-08 18:00:00",
ItemsList = oli,
NoSeats = "2",
Payment = "200.00",
Accepted = false
};
//Act
var dbOrd = ordC.ConvertOrderLineItemsToDb(mOrder);
//Assert
Assert.IsTrue(dbOrd[0].itemId == 1000000 &&
dbOrd[0].orderId == 1000002);
}
public void Get_Last_Identity_Test()
{
//Setup
var ordC = new OrderCtrl();
//Assert
Assert.IsTrue(ordC.GetLastOrderIdentity() == 1000005);
}
private void TableControl_OnSelectionChanged(object sender, SelectionChangedEventArgs e)
{
List <TableInfo> item = e.AddedItems.Cast <TableInfo>().ToList();
OrderCtrl.setCurrentTableInfo(item[0]);
OrderCtrl.Visibility = Visibility.Visible;
TableCtrl.Visibility = Visibility.Collapsed;
StatCtrl.Visibility = Visibility.Collapsed;
}
public void Add_Item_To_Order_Increment_Quantity_Test()
{
//Setup
var ordC = new OrderCtrl();
//Act
ordC.AddItemToOrder(1000000, 1000000);
//Assert
Assert.IsTrue(ordC.GetOrderById(1000000).ItemsList[0].Quantity == 2);
}
public void Get_Order_By_ID_Test()
{
//Setup
var ordC = new OrderCtrl();
//Act
var dbO = ordC.GetOrderById(1000000);
//Assert
Assert.IsTrue(dbO.OrderId == "1000000");
}
public void Add_New_Item_To_Order_Test()
{
//Setup
var ordC = new OrderCtrl();
//Act
ordC.AddItemToOrder(1000001, 1000001);
var list = ordC.GetOrderById(1000001).ItemsList;
//Assert
Assert.IsTrue(list.Count == 2);
}
public static void LaunchFinishMenu(string userDocument)
{
Random random = new Random();
Order newOrder = new Order(random.Next(10000, 99999), userDocument);
Alert.ShowAlert(newOrder.ToString(), ConsoleColor.DarkBlue);
Console.WriteLine("\n");
ShopCtrl.ShowShoppingCart();
//OrderCtrl.CreateOrder(newOrder);
OrderCtrl.ReadAllOrders();
}
public List <DatabaseAccessLibrary.Order> GetOrderHistoryByCustomerId(int id)
{
var db = new JustFeastDbDataContext();
var ordC = new OrderCtrl();
var query = from orders in db.Orders
join orderHistoryTable in db.OrderHistories on orders.id equals orderHistoryTable.orderId
where orderHistoryTable.customerId == id
select new DatabaseAccessLibrary.Order
{
id = orders.id,
restaurantId = orders.restaurantId, dateTime = orders.dateTime,
reservation = orders.reservation, noSeats = orders.noSeats,
accepted = orders.accepted
};
query.ToList().ForEach(x => x.OrderLineItems.AddRange(ordC.GetOrderLineItemsById(x.id)));
return(query.ToList());
}
public void Convert_To_Database_Test()
{
//Setup
var oli = new List <OrderLineItem>();
var ordCtrl = new OrderCtrl();
var ordDb = new Order();
var order = new Order
{
OrderId = "1000002",
CustomerId = "1000000",
RestaurantId = "1000000",
DateTime = "2018-11-08 12:22:33",
ReservationDateTime = "2018-11-08 18:00:00",
ItemsList = oli,
NoSeats = "2",
Payment = "200.00",
Accepted = false
};
var dt = new DateTime(2018, 11, 08, 12, 22, 33);
var resDt = new DateTime(2018, 11, 08, 18, 00, 00);
var dbOrder = new DatabaseAccessLibrary.Order
{
id = 1000002,
restaurantId = 1000000,
dateTime = dt,
reservation = resDt,
noSeats = 2
};
//Act
var resOrder = ordCtrl.ConvertOrder(order);
//Assert
Assert.IsTrue(resOrder.id == dbOrder.id &&
resOrder.restaurantId == dbOrder.restaurantId &&
resOrder.dateTime == dbOrder.dateTime &&
resOrder.reservation == dbOrder.reservation &&
resOrder.noSeats == dbOrder.noSeats);
}
public void Add_Order_To_Database_Test()
{
//Setup
var ordCtrl = new OrderCtrl();
var ordDb = new OrderDb();
var dt = new DateTime(2018, 11, 08, 12, 22, 33);
var resDt = new DateTime(2018, 11, 08, 18, 00, 00);
var oli = new List <OrderLineItem>();
var item = new ModelLibrary.Item();
item.Id = 1000000;
oli.Add(new OrderLineItem(item, 2));
var order = new Order
{
OrderId = (ordCtrl.GetLastOrderIdentity() + 1).ToString(),
CustomerId = "1000000",
RestaurantId = "1000000",
DateTime = "2018-11-08 12:22:33",
ReservationDateTime = "2018-11-08 18:00:00",
ItemsList = oli,
NoSeats = "2",
Payment = "200.00",
Accepted = false
};
//Act
var oliList = ordCtrl.ConvertOrderLineItemsToDb(order);
var dbOrder = ordCtrl.ConvertOrder(order);
for (var i = 0; i < dbOrder.OrderLineItems.Count - 1; i++)
{
dbOrder.OrderLineItems.Add(oliList[i]);
}
ordDb.AddOrder(dbOrder);
//Assert
Assert.IsTrue(ordCtrl.GetLastOrderIdentity() == Convert.ToInt32(order.OrderId));
}
public void Update_Order_Test()
{
//Setup
var ordC = new OrderCtrl(); var ordDb = new Order();
var dt = new DateTime(2018, 11, 08, 12, 22, 33);
var newResDt = new DateTime(2018, 11, 08, 19, 00, 00);
var dbOrder = new DatabaseAccessLibrary.Order
{
id = 1000000,
restaurantId = 1000000,
dateTime = dt,
reservation = newResDt,
noSeats = 2,
accepted = false
};
//Act
ordC.UpdateOrder(dbOrder);
//Assert
Assert.IsTrue(ordC.GetOrderById(1000000).ReservationDateTime == newResDt.ToString());
}
public IEnumerable <ModelLibrary.Order> GetAllOrdersByRestaurant(int restaurantId)
{
OrderCtrl orderCtrl = new OrderCtrl();
return(orderCtrl.GetAllOrdersByRestaurant(restaurantId));
}
public void DeleteItemById(int orderId, int itemId)
{
var ctrl = new OrderCtrl();
ctrl.DeleteItemById(orderId, itemId);
}
public void DeleteOrder(int orderId)
{
var ctrl = new OrderCtrl();
//ctrl.DeleteOrder(orderId);
}
