public void delete(long Designation_id)
        {
            try
            {
                using (TransactionScope tx = new TransactionScope(TransactionScopeOption.Required))
                {
                    var DesignationCategory = _DesignationRepository.getById(Designation_id);

                    if (DesignationCategory == null)
                    {
                        throw new ItemNotFoundException($"Designation category with id {Designation_id} doesnot exist.");
                    }

                    _DesignationRepository.delete(DesignationCategory);
                    tx.Complete();
                }
            }
            catch (Exception)
            {
                throw;
            }
        }