public static void MyClassInitialize(TestContext testContext)
{
//Add test data (order specific)
testDatabase = new TestDatabaseHelper();
restaurant1 = testDatabase.AddRestaurant();
table1 = testDatabase.AddTable(restaurant1);
}
public static void MyClassInitialize(TestContext testContext)
{
//Add test data (order specific)
testDatabase = new TestDatabaseHelper();
restaurant1 = testDatabase.AddRestaurant();
table1 = testDatabase.AddTable(restaurant1);
user1 = testDatabase.AddUser("*****@*****.**", table1, (int)SiteRoles.Admin);
}
public static void MyClassInitialize(TestContext testContext)
{
//Add test data (order specific)
testDatabase = new TestDatabaseHelper();
restaurant1 = testDatabase.AddRestaurant();
table1 = testDatabase.AddTable(restaurant1);
user1 = testDatabase.AddUser("*****@*****.**", table1, (int)SiteRoles.Admin);
//Session
db = new touch_for_foodEntities();
target = new HomeController();
Session session = new Session(db, target);
session.simulateLogin(user1.username, user1.password);
}
public static void MyClassInitialize(TestContext testContext)
{
testDatabase = new TestDatabaseHelper();
//Add test data (order specific)
restaurant1 = testDatabase.AddRestaurant();
table1 = testDatabase.AddTable(restaurant1);
order1 = testDatabase.AddOrder(table1);
item1 = testDatabase.AddItem();
category1 = testDatabase.AddCategory();
menu1 = testDatabase.AddMenu(restaurant1);
menuCategory1 = testDatabase.AddMenuCategory(category1, menu1);
menuItem1 = testDatabase.AddMenuItem(item1, menuCategory1);
}
public static void MyClassInitialize(TestContext testContext)
{
//Add test data (order specific)
testDatabase = new TestDatabaseHelper();
restaurant1 = testDatabase.AddRestaurant();
table1 = testDatabase.AddTable(restaurant1);
user1 = testDatabase.AddUser("*****@*****.**", table1, (int)SiteRoles.Admin);
order1 = testDatabase.AddOrder(table1);
item1 = testDatabase.AddItem();
category1 = testDatabase.AddCategory();
menu1 = testDatabase.AddMenu(restaurant1);
menuCategory1 = testDatabase.AddMenuCategory(category1, menu1);
menuItem1 = testDatabase.AddMenuItem(item1, menuCategory1);
//Session
db = new touch_for_foodEntities();
BillController target = new BillController();
Session session = new Session(db, target);
session.simulateLogin(user1.username, user1.password);
}
public ActionResult Create(table table)
{
if (ModelState.IsValid)
{
try
{
if (table.restaurant_id != null)
{
if (om.Create(table))
{
return RedirectToAction("Index");
}
}
}
catch (Exception) { }
}
ViewBag.Error = Global.TableCreateError;
ViewBag.restaurant_id = new SelectList(CreateRestaurantList(), "id", "name");
// ViewBag.restaurant_id = new SelectList(db.restaurants, "id", "name", table.restaurant_id);
return View(table);
}
public void MyTestInitialize()
{
//Add test data (order specific)
restaurant1 = testDatabase.AddRestaurant();
table1 = testDatabase.AddTable(restaurant1);
user1 = testDatabase.AddUser("*****@*****.**", table1, (int)SiteRoles.Admin);
user3 = testDatabase.AddUser("*****@*****.**", table1, (int)SiteRoles.Customer);
friendship1 = testDatabase.AddFriendship(user1, user3);
restaurantUser1 = testDatabase.AddRestaurantUser(user1, restaurant1);
order1 = testDatabase.AddOrder(table1);
// Create a valid user object with test values
user2 = new user();
user2.username = "******";
user2.password = "******";
user2.ConfirmPassword = "******";
user2.first_name = "*****@*****.**";
user2.last_name = "*****@*****.**";
user2.email = "*****@*****.**";
user2.image_url = null;
user2.current_table_id = table1.id;
}
/// <summary>
/// Writes a table object to the database
/// </summary>
/// <param name="table">The table object to write</param>
/// <param name="assignDefaultName">If true, assigns a default name to the table using restaurant_id and name, otherwise leaves the name unchanged</param>
/// <returns>True if successful, false otherwise</returns>
public bool Create(table table)
{
db.tables.Add(table);
return (db.SaveChanges() == 1);
}
public void MyTestInitialize()
{
//Add test data (order specific)
restaurant1 = testDatabase.AddRestaurant();
table1 = testDatabase.AddTable(restaurant1);
order1 = testDatabase.AddOrder(table1);
serviceRequest1 = testDatabase.AddServiceRequest(table1);
}
public void MyTestInitialize()
{
//Add test data (order specific)
category1 = testDatabase.AddCategory();
restaurant1 = testDatabase.AddRestaurant();
menu1 = testDatabase.AddMenu(restaurant1);
menuCategory1 = testDatabase.AddMenuCategory(category1, menu1);
table1 = testDatabase.AddTable(restaurant1);
order1 = testDatabase.AddOrder(table1);
item1 = testDatabase.AddItem(category1);
menuItem1 = testDatabase.AddMenuItem(item1, menuCategory1);
orderItem1 = testDatabase.AddOrderItem(order1, menuItem1);
}
public PartialViewResult FilterOrder(table table)
{
var pendingOrders = table.orders.Where(p => p.order_status == (int)OrderStatusHelper.OrderStatusEnum.PLACED ||
p.order_status == (int)OrderStatusHelper.OrderStatusEnum.EDITING ||
p.order_status == (int)OrderStatusHelper.OrderStatusEnum.PROCESSING).
ToList();
pendingOrders = pendingOrders.OrderBy(o => o.timestamp).ToList();
return PartialView("_OrderList", pendingOrders);
}
public void MyTestInitialize()
{
//Add test data (order specific)
restaurant1 = testDatabase.AddRestaurant();
restaurant2 = new restaurant();
table1 = testDatabase.AddTable(restaurant1);
user1 = testDatabase.AddUser("*****@*****.**", table1, (int)SiteRoles.Admin);
restaurantUser1 = testDatabase.AddRestaurantUser(user1, restaurant1);
menu1 = testDatabase.AddMenu(restaurant1);
order1 = testDatabase.AddOrder(table1);
review1 = testDatabase.AddReview(restaurant1, order1, user1);
//Session
db = new touch_for_foodEntities();
target = new RestaurantController();
Session session = new Session(db, target);
session.simulateLogin(user1.username, user1.password);
}
/// <summary>
/// Creates an entry of type service request in the database.
/// </summary>
/// <param name="tableEntity">the table the service request is associated to.</param>
/// <returns>The created service request entity.</returns>
public service_request AddServiceRequest(table tableEntity)
{
//Initialise
db = new touch_for_foodEntities();
service_request testServiceRequest = new service_request();
//Set Attributes
testServiceRequest = new service_request();
testServiceRequest.note = "UnitTest";
testServiceRequest.created = DateTime.Now;
testServiceRequest.status = (int)ServiceRequestUtil.ServiceRequestStatus.OPEN;
testServiceRequest.version = 0;
testServiceRequest.table_id = tableEntity.id;
//Save
db.service_request.Add(testServiceRequest);
db.SaveChanges();
db.Dispose();
return testServiceRequest;
}
/// <summary>
/// Creates an entry of type order in the database.
/// </summary>
/// <param name="orderTable">The table where orders are made from.</param>
/// <param name="orderWaiter">The waiter in charge of order.</param>
/// <returns>The created order entry.</returns>
public order AddOrder(table orderTable, waiter orderWaiter)
{
//Initialise
db = new touch_for_foodEntities();
order testOrder = new order();
//Set Attributes
testOrder.timestamp = DateTime.Now;
testOrder.table_id = orderTable.id;
testOrder.waiter_id = orderWaiter.id;
testOrder.version = 1;
//Save
db.orders.Add(testOrder);
db.SaveChanges();
db.Dispose();
return testOrder;
}
public ActionResult Edit(table table)
{
if (ModelState.IsValid)
{
db.Entry(table).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.Error = Global.ServerError;
try
{
ViewBag.restaurant_id = new SelectList(db.restaurants, "id", "name", table.restaurant_id);
}
catch (Exception)
{
}
return View(table);
}
public void MyTestInitialize()
{
//Add test data (order specific)
restaurant1 = testDatabase.AddRestaurant();
table1 = testDatabase.AddTable(restaurant1);
table2 = new table();
user1 = testDatabase.AddUser("*****@*****.**", table1, (int)SiteRoles.Restaurant);
order1 = testDatabase.AddOrder(table1);
request1 = testDatabase.AddServiceRequest(table1);
restaurantUser1 = testDatabase.AddRestaurantUser(user1, restaurant1);
//Session
db = new touch_for_foodEntities();
target = new TableController();
Session session = new Session(db, target);
session.simulateLogin(user1.username, user1.password);
}
/// <summary>
/// Creates an entry of type table in the database.
/// </summary>
/// <param name="restaurantEntity">The restaurant where the table is located.</param>
/// <returns>The created table entity.</returns>
public table AddTable(restaurant restaurantEntity)
{
//Initialise
db = new touch_for_foodEntities();
table testTable = new table();
//Set Attributes
testTable.name = "Unit Test";
testTable.restaurant_id = restaurantEntity.id;
//Save
db.tables.Add(testTable);
db.SaveChanges();
db.Dispose();
return testTable;
}
/// <summary>
/// Removes a table item from the database.
/// </summary>
/// <param name="tableEntity">The table to be removed.</param>
public void RemoveTable(table tableEntity)
{
db = new touch_for_foodEntities();
if (db.tables.Find(tableEntity.id) != null)
{
db.tables.Remove(db.tables.Find(tableEntity.id));
db.SaveChanges();
}
db.Dispose();
}
/// <summary>
/// Creates an entry of type user in the database.
/// </summary>
/// <param name="username">A unique string to represent the user.</param>
/// <param name="currentTable">A table in the restaurant.</param>
/// <param name="userRole">The role of the user (ex: Administrator, Client)</param>
/// <returns>The created user entity.</returns>
public user AddUser(string email, table currentTable, int userRole)
{
//Initialise
db = new touch_for_foodEntities();
user testUser = new user();
//Set attributes
testUser.username = email;
// Make sure the password is encrypted
AES aes = new AES();
testUser.password = aes.EncryptToString(email);
testUser.ConfirmPassword = aes.EncryptToString(email);
testUser.first_name = email;
testUser.last_name = email;
testUser.email = email;
testUser.image_url = email;
testUser.current_table_id = currentTable.id;
testUser.version = 1;
testUser.user_role = userRole;
//Save
db.users.Add(testUser);
db.SaveChanges();
db.Dispose();
return testUser;
}
public static void MyClassInitialize(TestContext testContext)
{
testDatabase = new TestDatabaseHelper();
//Add test data (order specific)
item1 = testDatabase.AddItem();
category1 = testDatabase.AddCategory();
restaurant1 = testDatabase.AddRestaurant();
menu1 = testDatabase.AddMenu(restaurant1);
menuCategory1 = testDatabase.AddMenuCategory(category1, menu1);
table1 = testDatabase.AddTable(restaurant1);
order1 = testDatabase.AddOrder(table1);
user1 = testDatabase.AddUser("*****@*****.**", table1, (int)SiteRoles.Admin);
review1 = testDatabase.AddReview(restaurant1, order1, user1);
}
public void MyTestInitialize()
{
//Add test data (order specific)
restaurant1 = testDatabase.AddRestaurant();
table1 = testDatabase.AddTable(restaurant1);
waiter1 = testDatabase.AddWaiter(restaurant1);
order1 = testDatabase.AddOrder(table1, waiter1);
}
