Beispiel #1
0
        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());
        }
Beispiel #3
0
        /// <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));
     }
 }
Beispiel #6
0
 /// <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);
     }
 }
Beispiel #7
0
 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();
     }
 }
Beispiel #8
0
        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"));
        }