public static void MyClassCleanup() { touch_for_foodEntities db = new touch_for_foodEntities(); review r = db.reviews.Find(m_review.id); db.reviews.Remove(r); db.SaveChanges(); db.Dispose(); }
public static void MyClassInitialize(TestContext testContext) { touch_for_foodEntities db = new touch_for_foodEntities(); m_review = new review(); m_review.restaurant_id = db.restaurants.First().id; m_review.rating = 1; m_review.is_anonymous = true; db.reviews.Add(m_review); db.SaveChanges(); db.Dispose(); }
/// <summary> /// Creates a friendship entity /// </summary> /// <param name="user1">The first user in the friendship</param> /// <param name="user2">The second user in the friendship</param> /// <returns>the created friendship entity</returns> public friendship AddFriendship(user user1, user user2) { //Initialise db = new touch_for_foodEntities(); friendship testFriendship = new friendship(); //Set Attributes testFriendship.first_user = user1.id; testFriendship.second_user = user2.id; //Save db.friendships.Add(testFriendship); db.SaveChanges(); db.Dispose(); return testFriendship; }
public void DeleteItemActiveExceptionTest() { //Arrange db = new touch_for_foodEntities(); MenuItemOM target = new MenuItemOM(db); menuItem1.is_active = true; db.Entry(menuItem1).State = EntityState.Modified; db.SaveChanges(); //Act int actual = target.delete(menuItem1.id); //Assert db = new touch_for_foodEntities(); Assert.IsFalse(db.menu_item.Find(menuItem1.id).is_deleted); Assert.IsNotNull(db.order_item.Find(orderItem1.id)); }
/// <summary> /// Adds a category entry to the database /// </summary> /// <returns>The created category entity.</returns> public category AddCategory() { //Initialise db = new touch_for_foodEntities(); category testCategory = new category(); //Set attributes testCategory.name = "UnitTest"; testCategory.version = 0; //Save db.categories.Add(testCategory); db.SaveChanges(); db.Dispose(); return testCategory; }
public void DeleteItemActiveExceptionTest() { //Arrange db = new touch_for_foodEntities(); OrderOM target = new OrderOM(db); orderItem1.order_item_status = (int)OrderStatusHelper.OrderItemStatusEnum.PROCESSING; db.Entry(orderItem1).State = EntityState.Modified; db.SaveChanges(); //Act int actual = target.delete(order1.id); //Assert db = new touch_for_foodEntities(); Assert.IsFalse(db.orders.Find(order1.id).order_status == (int)OrderStatusHelper.OrderStatusEnum.DELETED); Assert.IsFalse(db.order_item.Find(orderItem1.id).order_item_status == (int)OrderStatusHelper.OrderItemStatusEnum.DELETED); }
public void DeleteConfirmedActiveExceptionTest() { //Arrange db = new touch_for_foodEntities(); item item1 = testDatabase.AddItem(); menu_item menuItem1 = testDatabase.AddMenuItem(item1, menuCategory1); //make menu active menu1.is_active = true; db.Entry(menu1).State = EntityState.Modified; db.SaveChanges(); //Act ActionResult actual = (ActionResult)target.DeleteConfirmed(menu1.id); //Assert db = new touch_for_foodEntities(); Assert.IsFalse(db.menus.Find(menu1.id).is_deleted); Assert.IsFalse(db.menu_category.Find(menuCategory1.id).is_deleted); Assert.IsFalse(db.menu_item.Find(menuItem1.id).is_deleted); //Clean-up (order specific) testDatabase.RemoveMenuItem(menuItem1); testDatabase.RemoveItem(item1); }
/// <summary> /// Creates an entry of type item in the database. /// </summary> /// <param name="catagoryEntity">Category that item is related to.</param> /// <returns>The created item entry.</returns> public item AddItem(category catagoryEntity) { //Initialise db = new touch_for_foodEntities(); item testItem = new item(); //Set Attributes testItem.name = "UnitTest"; testItem.category_id = catagoryEntity.id; //Save db.items.Add(testItem); db.SaveChanges(); db.Dispose(); return testItem; }
public void DeleteActiveMenuWarningTest() { //Arrange db = new touch_for_foodEntities(); testDatabase.RemoveMenuCategory(menuCategory1); menu1.is_active= true; db.Entry(menu1).State = EntityState.Modified; db.SaveChanges(); //Act ViewResult actual = (ViewResult)target.Delete(menu1.id); //Assert string actualWarning = actual.ViewBag.Warning; Assert.IsFalse(String.IsNullOrWhiteSpace(actualWarning)); menu actualMenu = (menu)actual.ViewData.Model; Assert.AreEqual(actualMenu.id, menu1.id); }
/// <summary> /// Removes a waiter item from the database. /// </summary> /// <param name="waiterEntity">The waiter to be removed</param> public void RemoveWaiter(waiter waiterEntity) { db = new touch_for_foodEntities(); if (db.waiters.Find(waiterEntity.id) != null) { db.waiters.Remove(db.waiters.Find(waiterEntity.id)); db.SaveChanges(); } db.Dispose(); }
/// <summary> /// Adds a bill entry to the database /// </summary> /// <param name="orderEntity">The associated order</param> /// <returns>The created bill entity.</returns> internal bill AddBill(order orderEntity) { //Initialise db = new touch_for_foodEntities(); bill testBill = new bill(); //Set attributes testBill.order_id = orderEntity.id; testBill.is_deleted = false; //Save db.bills.Add(testBill); db.SaveChanges(); db.Dispose(); return testBill; }
/// <summary> /// Remove menu item from database. /// </summary> /// <param name="menuCategoryEntity">Menu Category item to be removed.</param> public void RemoveMenuCategory(menu_category menuCategoryEntity) { db = new touch_for_foodEntities(); if (db.menu_category.Find(menuCategoryEntity.id) != null) { db.menu_category.Remove(db.menu_category.Find(menuCategoryEntity.id)); db.SaveChanges(); } db.Dispose(); }
/// <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(); }
public void DeleteConfirmedTest() { //Setup db = new touch_for_foodEntities(); user1.current_table_id = null; db.Entry(user1).State = EntityState.Modified; db.SaveChanges(); //CheckSetup Assert.IsFalse(db.restaurants.Find(restaurant1.id).is_deleted); Assert.IsNotNull(db.tables.Find(table1.id)); Assert.IsNotNull(db.restaurant_user.Find(restaurantUser1.id).restaurant_id); Assert.IsFalse(db.menus.Find(menu1.id).is_deleted); Assert.IsNotNull(db.reviews.Find(review1.id)); //Act var actual = target.DeleteConfirmed(restaurant1.id); //Assert db = new touch_for_foodEntities(); Assert.IsTrue(db.restaurants.Find(restaurant1.id).is_deleted); Assert.IsNull(db.tables.Find(table1.id)); Assert.IsNull(db.restaurant_user.Find(restaurantUser1.id).restaurant_id); Assert.IsTrue(db.menus.Find(menu1.id).is_deleted); Assert.IsNull(db.reviews.Find(review1.id)); }
///<summary> /// Removes a bill from the database. /// </summary> /// <param name="billEntity">Bill to be removed.</param> public void RemoveCategory(category categoryEntity) { db = new touch_for_foodEntities(); if (db.categories.Find(categoryEntity.id) != null) { db.categories.Remove(db.categories.Find(categoryEntity.id)); db.SaveChanges(); } db.Dispose(); }
/// <summary> /// Removes a restaurant_user item from the database. /// </summary> /// <param name="restaurantEntity">restaurant_user item to be removed.</param> public void RemoveRestaurantUser(restaurant_user restaurantUserEntity) { db = new touch_for_foodEntities(); if (db.restaurant_user.Find(restaurantUserEntity.id) != null) { db.restaurant_user.Remove(db.restaurant_user.Find(restaurantUserEntity.id)); db.SaveChanges(); } db.Dispose(); }
/// <summary> /// Removes a review item from the database. /// </summary> /// <param name="userEntity">The review to be removed.</param> public void RemoveReview(review reviewEntity) { db = new touch_for_foodEntities(); if (db.reviews.Find(reviewEntity.id) != null) { db.reviews.Remove(db.reviews.Find(reviewEntity.id)); db.SaveChanges(); } db.Dispose(); }
/// <summary> /// Removes an order item from the database. /// </summary> /// <param name="orderEntity">Order item to be removed.</param> public void RemoveOrderItem(order_item orderItem) { db = new touch_for_foodEntities(); if(db.order_item.Find(orderItem.id) != null) { db.order_item.Remove(db.order_item.Find(orderItem.id)); db.SaveChanges(); } db.Dispose(); }
/// <summary> /// Removes an order from the database. /// </summary> /// <param name="orderEntity">Order to be removed.</param> public void RemoveOrder(order orderEntity) { db = new touch_for_foodEntities(); if (orderEntity != null) { db.orders.Remove(db.orders.Find(orderEntity.id)); db.SaveChanges(); } db.Dispose(); }
/// <summary> /// Remove menu item item from database. /// </summary> /// <param name="menuEntity">Menu item item to be removed.</param> public void RemoveMenuItem(menu_item menuItemEntity) { db = new touch_for_foodEntities(); if (db.menu_item.Find(menuItemEntity.id) != null) { db.menu_item.Remove(db.menu_item.Find(menuItemEntity.id)); db.SaveChanges(); } db.Dispose(); }
public void RemoveMenuCategoryExceptionTest() { //Arrange db = new touch_for_foodEntities(); //populat db (order specific) item item1 = testDatabase.AddItem(); menu_item menuItem1 = testDatabase.AddMenuItem(item1, menuCategory1); //0 rows should have been affected int expected = 0; //make menu category active menuCategory1.is_active = true; db.Entry(menuCategory1).State = EntityState.Modified; db.SaveChanges(); //Act int actual = target.RemoveMenuCategory(menuCategory1.id); //Assert db = new touch_for_foodEntities(); Assert.AreEqual(expected, actual); Assert.IsFalse(db.menu_category.Find(menuCategory1.id).is_deleted); Assert.IsFalse(db.menu_item.Find(menuItem1.id).is_deleted); //Clean-up (order specific) testDatabase.RemoveMenuItem(menuItem1); testDatabase.RemoveItem(item1); }
/// <summary> /// Remove item item from database. /// </summary> /// <param name="menuEntity">Item item to be removed.</param> public void RemoveItem(item itemEntity) { db = new touch_for_foodEntities(); if (db.items.Find(itemEntity.id) != null) { db.items.Remove(db.items.Find(itemEntity.id)); db.SaveChanges(); } db.Dispose(); }
public void DeleteConfirmedTest() { //Setup db = new touch_for_foodEntities(); user1.current_table_id = null; db.Entry(user1).State = EntityState.Modified; db.SaveChanges(); //CheckSetup Assert.IsNotNull(db.tables.Find(table1.id)); Assert.IsNotNull(db.orders.Find(order1.id).table_id); Assert.IsNotNull(db.service_request.Find(request1.id).table_id); //Act var actual = target.DeleteConfirmed(table1.id); //Assert db = new touch_for_foodEntities(); Assert.IsNull(db.tables.Find(table1.id)); Assert.IsNull(db.service_request.Find(request1.id).table_id); Assert.AreEqual((request1.version + 1), db.service_request.Find(request1.id).version); Assert.IsNull(db.orders.Find(order1.id).table_id); Assert.AreEqual((order1.version + 1), db.orders.Find(order1.id).version); }
/// <summary> /// Remove menu item from database. /// </summary> /// <param name="menuEntity">Menu item to be removed.</param> public void RemoveMenu(menu menuEntity) { db = new touch_for_foodEntities(); if (menuEntity != null) { db.menus.Remove(db.menus.Find(menuEntity.id)); db.SaveChanges(); } db.Dispose(); }
public void RemoveReviewOrderItem(review_order_item reviewEntityOI) { db = new touch_for_foodEntities(); if (db.review_order_item.Find(reviewEntityOI.id) != null) { db.review_order_item.Remove(db.review_order_item.Find(reviewEntityOI.id)); db.SaveChanges(); } db.Dispose(); }
/// <summary> /// Remove friendship item from database. /// </summary> /// <param name="menuEntity">Friendships item to be removed.</param> public void RemoveFriendship(friendship friendshipEntity) { db = new touch_for_foodEntities(); if (db.friendships.Find(friendshipEntity.id) != null) { db.friendships.Remove(db.friendships.Find(friendshipEntity.id)); db.SaveChanges(); } db.Dispose(); }
public void DeleteActiveWarningTest() { //Arrange db = new touch_for_foodEntities(); Menu_CategoryController target = new Menu_CategoryController(db); menuCategory1.is_active = true; db.Entry(menuCategory1).State = EntityState.Modified; db.SaveChanges(); menu_category expected = menuCategory1; //Act ViewResult actual = (ViewResult)target.Delete(menuCategory1.id); //Assert Assert.AreEqual(expected.id, ((menu_category)actual.ViewData.Model).id); Assert.IsNotNull(actual.ViewBag.Warning); }
/// <summary> /// Removes a service request item from the database. /// </summary> /// <param name="serviceRequest">The service request to be removed.</param> public void RemoveServiceRequest(service_request serviceRequest) { db = new touch_for_foodEntities(); if (db.service_request.Find(serviceRequest.id) != null) { db.service_request.Remove(db.service_request.Find(serviceRequest.id)); db.SaveChanges(); } db.Dispose(); }
public void DeleteConfirmedTestItemActiveException() { // Arrange db = new touch_for_foodEntities(); Menu_ItemController target = new Menu_ItemController(); int expectedMenuItems = db.menu_item.ToList<menu_item>().Count(); menuItem1 = db.menu_item.Find(menuItem1.id); menuItem1.is_active = true; db.Entry(menuItem1).State = EntityState.Modified; db.SaveChanges(); // Act var actualResult = target.DeleteConfirmed(menuItem1.id) as RedirectToRouteResult; // Assertions db = new touch_for_foodEntities(); var actualResultURI = actualResult.RouteValues["action"]; int actualMenuItems = db.menu_item.ToList<menu_item>().Count(); Assert.AreEqual(expectedMenuItems, actualMenuItems); Assert.IsFalse(db.menu_item.Find(menuItem1.id).is_deleted); Assert.AreEqual("Index", actualResultURI); }
/// <summary> /// Removes a side item from the database. /// </summary> /// <param name="testSide">The side to be removed.</param> public void RemoveSide(side testSide) { db = new touch_for_foodEntities(); if (db.sides.Find(testSide.id) != null) { db.sides.Remove(db.sides.Find(testSide.id)); db.SaveChanges(); } db.Dispose(); }