public IActionResult AddCategory(CategoryNameDTO category)
        {
            var apiJsonResponse = new ApiJsonResponse();

            try

            {
                if (category != null)
                {
                    if (category.CategoryName != string.Empty && category.LanguageCode != string.Empty)
                    {
                        using (FoodInfoServiceContext context = new FoodInfoServiceContext())
                        {
                            if (!context.ProductCategories.Any(x => x.CategoryName == category.CategoryName && x.IsDeleted == false && x.LanguageCode == category.LanguageCode))
                            {
                                if (context.Languages.Any(x => x.LanguageCode == category.LanguageCode && x.IsDeleted == false))
                                {
                                    if (category.CreatedUserId == null)
                                    {
                                        return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.ProvideACreatedUserId));
                                    }
                                    context.ProductCategories.Add(Mapper.Map <ProductCategory>(category));
                                    context.SaveChanges();
                                    var lastItem = context.ProductCategories.Last();
                                    category.ID = lastItem.ID;
                                    category.Id = lastItem.ID;
                                    return(apiJsonResponse.ApiOkContentResult(category));
                                }
                                else
                                {
                                    return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.ProvideLanguageCode));
                                }
                            }
                            else
                            {
                                return(apiJsonResponse.ApiBadRequestWithMessageAndObject(category, PublicConstants.AlreadyACategoryDefinedWithThisName));
                            }
                        }
                    }


                    else
                    {
                        return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.ProvideCategoryName));
                    }
                }
                else
                {
                    return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.SysErrorMessage));
                }
            }

            catch
            {
                return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.SysErrorMessage));
            }
        }
        public IActionResult DeleteCategoryByLanguageCode(CategoryNameDTO categoryNameDTO)
        {
            var apiJsonResponse = new ApiJsonResponse();

            try
            {
                using (FoodInfoServiceContext context = new FoodInfoServiceContext())
                {
                    if (categoryNameDTO != null)
                    {
                        var result = context.ProductCategories.FirstOrDefault(x => x.CategoryName == categoryNameDTO.CategoryName && x.LanguageCode == categoryNameDTO.LanguageCode);
                        if (result != null)
                        {
                            if (result.IsDeleted == false)
                            {
                                result.ModifiedDate = DateTime.Now;
                                if (categoryNameDTO.ModifiedUserId == null)
                                {
                                    return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.ProivdeModifiedUserId));
                                }
                                result.ModifiedUserId = categoryNameDTO.ModifiedUserId;
                                result.IsDeleted      = true;
                                context.SaveChanges();
                                return(apiJsonResponse.ApiOkContentResult(categoryNameDTO));
                            }
                            else
                            {
                                return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.NoCategoryFound));
                            }
                        }
                        else
                        {
                            return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.NoCategoryFound));
                        }
                    }
                    else
                    {
                        return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.SysErrorMessage));
                    }
                }
            }
            catch (Exception ex)
            {
                return(apiJsonResponse.ApiBadRequestWithMessage(PublicConstants.SysErrorMessage));
            }
        }