public async Task <ActionResult> AddNewLevelAsync([FromBody] DepartmentDesignationDto departmentDesignationViewModel)
        {
            //var departmentDesignationList = await _levelService.GetDepartmentDesignationIdList(departmentDesignationViewModel.DepartmentId);
            var levelExists = await _levelService.CheckIfLevelAlreadyExistsInTheDepartment(departmentDesignationViewModel.DepartmentId, departmentDesignationViewModel.NewLevelName);

            if (levelExists)
            {
                return(BadRequest("Level with this name already exists in this department !"));
            }
            await _levelService.AddNewLevelAsync(departmentDesignationViewModel);

            return(Created("", ""));
        }
        /// <summary>
        /// this method is used to add new level in database and map it to designation department
        /// </summary>
        /// <param name="departmentDesignationViewModel">model that contains the mapping of department and designation to be mapped to new level</param>
        public async Task AddNewLevelAsync(DepartmentDesignationDto departmentDesignationViewModel)
        {
            if (departmentDesignationViewModel.DesignationId != null)
            {
                var designationDepartmentIdList = await _departmentDesignationRepository.GetDesignationDepartmentId(departmentDesignationViewModel.DesignationId, departmentDesignationViewModel.DepartmentId);

                var level = new Level
                {
                    IsDeleted = false,
                    Title     = departmentDesignationViewModel.NewLevelName
                };

                _levelRepository.AddLevel(level);
                await _levelRepository.SaveChangesAsync();

                var designationDepartmentLevelMapping = new List <DesignationLevel>();
                foreach (var id in designationDepartmentIdList)
                {
                    var designationLevel = new DesignationLevel
                    {
                        LevelId = level.Id,
                        DepartmentDesignationId = id,
                        IsDeleted = false
                    };
                    designationDepartmentLevelMapping.Add(designationLevel);
                }

                _departmentDesignationRepository.AddDesignationDepartmentLevelList(designationDepartmentLevelMapping);
                await _departmentDesignationRepository.SaveChangesAsync();
            }

            else
            {
                throw new Exception("Department can not be empty");
            }
        }