public void CategoryDataAccess_CrudCategory() { var categoryDataAccess = new CategoryDataAccess(); const string firstName = "category"; const string secondName = "new category"; var category = new Category { Name = firstName }; categoryDataAccess.Save(category); categoryDataAccess.LoadList(); var list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(firstName, list.First().Name); category.Name = secondName; categoryDataAccess.Save(category); list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(secondName, list.First().Name); categoryDataAccess.Delete(category); list = categoryDataAccess.LoadList(); Assert.IsFalse(list.Any()); }
public void CategoryDataAccess_CrudCategory() { var categoryDataAccess = new CategoryDataAccess(new DbHelper(new SQLitePlatformWinRT(), new TestDatabasePath())); const string firstName = "category"; const string secondName = "new category"; var category = new Category { Name = firstName }; categoryDataAccess.Save(category); categoryDataAccess.LoadList(); var list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(firstName, list.First().Name); category.Name = secondName; categoryDataAccess.Save(category); list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(secondName, list.First().Name); categoryDataAccess.Delete(category); list = categoryDataAccess.LoadList(); Assert.IsFalse(list.Any()); }
/// <summary> /// Function to delete a CategoryEntity from database. /// </summary> /// <param name="categoryEntity">CategoryEntity to delete</param> /// <param name="session">User's session identifier.</param> /// <returns>null if the CategoryEntity was deleted successfully, the same CategoryEntity otherwise</returns> /// <exception cref="ArgumentNullException"> /// if <paramref name="categoryEntity"/> is null. /// </exception> /// <exception cref="UtnEmallBusinessLogicException"> /// If an UtnEmallDataAccessException occurs in DataModel. /// </exception> public CategoryEntity Delete(CategoryEntity categoryEntity, string session) { bool permited = ValidationService.Instance.ValidatePermission(session, "delete", "Category"); if (!permited) { ExceptionDetail detail = new ExceptionDetail(new UtnEmall.Server.BusinessLogic.UtnEmallPermissionException("The user hasn't permissions to delete an entity")); throw new FaultException <ExceptionDetail>(detail); } if (categoryEntity == null) { throw new ArgumentException("The argument can not be null or be empty"); } try { // Delete categoryEntity using data access object categoryDataAccess.Delete(categoryEntity); // Delete related customers' preference PreferenceDataAccess preferenceDataAccess = new PreferenceDataAccess(); foreach (PreferenceEntity preferenceEntity in preferenceDataAccess.LoadWhere(PreferenceEntity.DBIdCategory, categoryEntity.Id, false, OperatorType.Equal)) { preferenceDataAccess.Delete(preferenceEntity); } return(null); } catch (UtnEmallDataAccessException utnEmallDataAccessException) { throw new UtnEmall.Server.BusinessLogic.UtnEmallBusinessLogicException(utnEmallDataAccessException.Message, utnEmallDataAccessException); } }
public void CategoryDataAccess_CrudCategory() { var categoryDataAccess = new CategoryDataAccess(); const string firstName = "category"; const string secondName = "new category"; var category = new Category { Name = firstName }; categoryDataAccess.Save(category); categoryDataAccess.LoadList(); var list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(firstName, list.First().Name); category.Name = secondName; categoryDataAccess.Save(category); list = categoryDataAccess.LoadList(); Assert.AreEqual(1, list.Count); Assert.AreEqual(secondName, list.First().Name); categoryDataAccess.Delete(category); list = categoryDataAccess.LoadList(); Assert.IsFalse(list.Any()); }
public ActionResult DeleteConfirm(int id) { if (CategoryDataAccess.Delete(id)) { return(Json(new { success = true, message = "Sukses" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = CategoryDataAccess.Message }, JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Función para eliminar un CategoryEntity de la base de datos. /// </summary> /// <param name="categoryEntity">CategoryEntity a eliminar</param> /// <param name="session">Identificador de sesión.</param> /// <returns>null si el CategoryEntity fue eliminado con éxito, el mismo CategoryEntity en otro caso</returns> /// <exception cref="ArgumentNullException"> /// Si <paramref name="categoryEntity"/> is null. /// </exception> /// <exception cref="UtnEmallBusinessLogicException"> /// Si una excepción UtnEmallDataAccessException ocurre en el data model. /// </exception> public CategoryEntity Delete(CategoryEntity categoryEntity) { if (categoryEntity == null) { throw new ArgumentException("The argument can't be null", "categoryEntity"); } try { // Elimina un categoryEntity usando un objeto data access categoryDataAccess.Delete(categoryEntity); return(null); } catch (UtnEmallDataAccessException utnEmallDataAccessException) { throw new UtnEmallBusinessLogicException(utnEmallDataAccessException.Message, utnEmallDataAccessException); } }
private void btnDeleteCategory_Click(object sender, EventArgs e) { if (mlvCategories.FocusedItem != null) { if (!cda.Delete(cda.GetList().First(c => c.CategoryID == Convert.ToInt32(txtUpdateCategoryCategoryID.Text)))) { lblManageCategoryAlertSuccessfull.Visible = false; lblManageCategoryAlertFail.Visible = true; lblManageCategoryAlertFail.BringToFront(); } else { lblManageCategoryAlertFail.Visible = false; lblManageCategoryAlertSuccessfull.Visible = true; lblManageCategoryAlertSuccessfull.BringToFront(); } UpdateCategoryList(); } }
public ActionResult DeleteCategory(int id) { CATEGORY category = categoryDA.GetById(id); try { if (ModelState.IsValid) { categoryDA.Delete(id); return(RedirectToAction("Categories", "Admin")); } else { ViewBag.Error = "Try Again."; return(View("CategoryDelete", category)); } } catch (Exception ex) { ViewBag.Error = "Try Again."; return(View("CategoryDelete", category)); } }
public IActionResult DeleteCategory(Guid id) { _category.Delete(id); return(RedirectToAction("Index", "Category")); }