public AutoManufacturerViewModel SaveAutoManufacturer(AutoManufacturer autoManufacturer)
        {
            var alreadyExist = AutoManufacturerAlreadyExist(autoManufacturer);

            if (!alreadyExist)
            {
                var result = repository.Add(autoManufacturer);
                unitOfWork.SaveChanges();
                return(autoMapper.Map <AutoManufacturerViewModel>(result));
            }
            else
            {
                return(null);
            }
        }
        private bool AutoManufacturerAlreadyExist(AutoManufacturer autoManufacturer)
        {
            //var c =  unitOfWork.GetAutoSolutionContext().Database.GetDbConnection();
            //var command =  c.CreateCommand();
            // c.Open();
            // command.CommandText = "[spName] @P3, @P2, @P1";
            //add parameter values
            //execute reader


            var result = (from item in unitOfWork.GetAutoSolutionContext().AutoManufacturers
                          where (item.AutoManufacturerName == autoManufacturer.AutoManufacturerName)
                          select item).FirstOrDefault();

            return(result != null ? true : false);
        }
        public bool UpdateAutoManufacturer(AutoManufacturer autoManufacturer)
        {
            var checkAlreadyExist = repository.GetById(autoManufacturer.Id);

            if (checkAlreadyExist != null)
            {
                unitOfWork.GetAutoSolutionContext().Entry(checkAlreadyExist).State = EntityState.Detached;
                checkAlreadyExist = autoMapper.Map <AutoManufacturer>(autoManufacturer);
                repository.Update(checkAlreadyExist);
                autoMapper.Map <AutoManufacturerViewModel>(checkAlreadyExist);
                var resultbool = unitOfWork.SaveChanges();
                return(resultbool == true ? true : false);
            }
            else
            {
                return(false);
            }
        }
 public bool UpdateAutoManufacturer(AutoManufacturerViewModel autoManufacturerViewModel)
 {
     autoManufacturer = autoMapper.Map <AutoManufacturer>(autoManufacturerViewModel);
     return(autoManufacturerRepository.UpdateAutoManufacturer(autoManufacturer));
 }
 public AutoManufacturerViewModel AutoManufacturerSave(AutoManufacturerViewModel autoManufacturerViewModel)
 {
     autoManufacturer = autoMapper.Map <AutoManufacturer>(autoManufacturerViewModel);
     return(autoManufacturerRepository.SaveAutoManufacturer(autoManufacturer));
 }
 public AutoManufacturerService(IAutoManufacturerRepository autoManufacturerRepository, IMapper autoMapper, AutoManufacturer autoManufacturer)
 {
     this.autoManufacturerRepository = autoManufacturerRepository;
     this.autoMapper       = autoMapper;
     this.autoManufacturer = autoManufacturer;
 }