/// <summary>
        ///
        /// </summary>
        /// <param name="CategoryName"></param>
        /// <param name="pasword"></param>
        /// <returns></returns>
        public Repositories.Category GetCategory(Repositories.Category Category)
        {
            var result = _db.Categories.AsNoTracking();

            if (Category.CategoryId > 0)
            {
                return(result.FirstOrDefault(a => a.CategoryId == Category.CategoryId));
            }

            return(result.FirstOrDefault(a => a.CategoryName == Category.CategoryName));
        }
        public HamrazmResult AddCategory(Repositories.Category Category)
        {
            var result = new HamrazmResult();

            if (IsAnyCategory(Category.CategoryName))
            {
                result.IsChange = false;
                result.Message  = "رکورد تکراری می باشد";
                return(result);
            }

            _db.Entry(Category).State = EntityState.Added;
            result.Message            = "رکورد با موفقیت ثبت شد";
            return(result);
        }
        public HamrazmResult DeleteCategory(Repositories.Category Category)
        {
            var result = new HamrazmResult();

            try
            {
                _db.Entry(Category).State = EntityState.Deleted;

                result.IsChange = true;
                result.Message  = "شهر با موفقیت حذف شد";
                return(result);
            }
            catch (Exception e)
            {
                result.IsChange = false;
                result.Message  = e.Message;

                return(result);
            }
        }
        public HamrazmResult UpdateCategory(Repositories.Category Category)
        {
            var result = new HamrazmResult();

            if (IsAnyCategory(Category))
            {
                result.IsChange = false;
                result.Message  = "رکورد تکراری می باشد";
                return(result);
            }
            var searchCategory = GetCategory(Category);

            if (searchCategory == null)
            {
                result.IsChange = false;
                result.Message  = "شهر یافت نشد";
            }
            _db.Entry(Category).State = EntityState.Modified;
            result.Message            = "کاربر تعریف شدرمز عبور با موفقیت تغییر  یافت";
            return(result);
        }
 private bool IsAnyCategory(Repositories.Category Category)
 {
     return(_db.Categories.Any(a => a.CategoryId != Category.CategoryId && a.CategoryName == Category.CategoryName));
 }