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); }