Example #1
0
        public async Task <string> DeleteProductCategory(int productId, int categoryId)
        {
            try
            {
                using var sqlCon = new SqlConnection(_options.connectionString);
                await sqlCon.OpenAsync();

                var dynamicParameters = new DynamicParameters();
                dynamicParameters.Add("@productId", productId);
                dynamicParameters.Add("@categoryId", categoryId);
                var res = new ProductCategoryResponse();
                await sqlCon.ExecuteAsync(
                    "spDeleteProductCategory",
                    dynamicParameters,
                    commandType : CommandType.StoredProcedure
                    );

                return(res.Messages = Enumhelper.GetEnumDescription(StatusHandlersEnum.StatusHandle.DeleteSuccess));
            }
            catch (Exception ex)
            {
                var res = new ProductCategoryResponse();
                return(res.Messages = ex.Message);
            }
        }
        public ProductCategoryResponse GetProductCategoryResponse(int?id)
        {
            ProductCategoryResponse prodCateResp = new ProductCategoryResponse();

            if (id != null)
            {
                prodCateResp.ProductCategory = prodCategoryRepository.Find((int)id);
            }
            prodCateResp.ProductCategories = prodCategoryRepository.GetAll();
            return(prodCateResp);
        }
        /// <summary>
        /// Validate request
        /// </summary>
        /// <param name="request"></param>
        /// <param name="response"></param>
        public void Validate(ProductCategoryRequest request, out ProductCategoryResponse response)
        {
            response = new ProductCategoryResponse();

            if (request.Action != null && request.Action.Equals(ClinicEnums.Action.DELETE.ToString()))
            {
                ValidateForDelete(request, out response);
            }
            else
            {
                bool isHavePrivilege = true;

                if (request.Data.Name == null || String.IsNullOrWhiteSpace(request.Data.Name))
                {
                    errorFields.Add("ProductCategory Name");
                }

                if (errorFields.Any())
                {
                    response.Status  = false;
                    response.Message = string.Format(Messages.ValidationErrorFields, String.Join(",", errorFields));
                }

                if (request.Data.Id == 0)
                {
                    isHavePrivilege = IsHaveAuthorization(ADD_PRIVILEGE_NAME, request.Data.Account.Privileges.PrivilegeIDs);
                }
                else
                {
                    isHavePrivilege = IsHaveAuthorization(EDIT_PRIVILEGE_NAME, request.Data.Account.Privileges.PrivilegeIDs);
                }

                if (!isHavePrivilege)
                {
                    response.Status  = false;
                    response.Message = Messages.UnauthorizedAccess;
                }

                if (response.Status)
                {
                    response = new ProductCategoryHandler(_unitOfWork).CreateOrEdit(request);
                }
            }
        }
        public async Task <IActionResult> GetProductCategory(Guid?ProductGameId)
        {
            var result = new ProductCategoryResponse();

            var productCategory = await _context.ProductCategory.Where(p => ProductGameId == null || p.Id == ProductGameId).Select(pc => new ProductCategory {
                ProductCategoryId = pc.Id, ProductCategoryName = pc.Name
            }).ToListAsync();

            if (productCategory.Count == 0)
            {
                result.Code    = -100;
                result.Message = "Can't get products with given parameters.";
                return(Ok(result));
            }
            result.Code            = 100;
            result.Message         = "Success";
            result.ProductCategory = productCategory;
            return(Ok(result));
        }
        /// <summary>
        /// Delete validation
        /// </summary>
        /// <param name="request"></param>
        /// <param name="response"></param>
        private void ValidateForDelete(ProductCategoryRequest request, out ProductCategoryResponse response)
        {
            response = new ProductCategoryResponse();

            if (request.Action == ClinicEnums.Action.DELETE.ToString())
            {
                bool isHavePrivilege = IsHaveAuthorization(DELETE_PRIVILEGE_NAME, request.Data.Account.Privileges.PrivilegeIDs);
                if (!isHavePrivilege)
                {
                    response.Status  = false;
                    response.Message = Messages.UnauthorizedAccess;
                }
            }

            if (response.Status)
            {
                response = new ProductCategoryHandler(_unitOfWork).RemoveData(request);
            }
        }