Beispiel #1
0
        public int SaveCar(CarMapping car)
        {
            Connection cnn = new Connection();

            try
            {
                SqlCommand cmd = new SqlCommand();
                cmd.Connection  = cnn.connectionStr;
                cmd.CommandType = CommandType.Text;
                cmd.CommandText = @"INSERT INTO [dbo].[Veiculo]
                                    VALUES
                                    (@valorVeiculo,@marcaModelo);
                                    SELECT SCOPE_IDENTITY();";
                cmd.Parameters.AddWithValue("@valorVeiculo", car.carValue);
                cmd.Parameters.AddWithValue("@marcaModelo", car.Brand);

                cnn.ConnOpen();
                int Id = Convert.ToInt32(cmd.ExecuteScalar());
                return(Id);
            }
            catch (Exception)
            {
                return(0);
            }
            finally
            {
                cnn.ConnClose();
            }
        }
Beispiel #2
0
 public async Task <int> InsertAsync(CarMapping entity)
 {
     if (entity == null)
     {
         throw new ArgumentNullException("CarMapping");
     }
     return(await _CarMappingRepository.InsertAsync(entity));
 }
Beispiel #3
0
 public static CarMapping ToEntity(this CarMappingDTO dto, CarMapping entity)
 {
     return(Mapper.Map(dto, entity));
 }
Beispiel #4
0
 public static CarMappingDTO ToModel(this CarMapping entity)
 {
     return(Mapper.Map <CarMapping, CarMappingDTO>(entity));
 }