private void Create(ParentalFacility entity) { var insert = $"INSERT INTO {TableName} " + $"({nameof(ParentalFacility.Id)}, {nameof(ParentalFacility.Name)}, {nameof(ParentalFacility.Description)}, {nameof(ParentalFacility.Rating)}, {nameof(ParentalFacility.Latitude)}, {nameof(ParentalFacility.Longitude)}, {nameof(ParentalFacility.LastCleanedAt)}, " + $"{nameof(ParentalFacility.Microwave)}, {nameof(ParentalFacility.ChangeTable)}, {nameof(ParentalFacility.RubbishBin)}, {nameof(ParentalFacility.Toilet)}, {nameof(ParentalFacility.Shower)}, {nameof(ParentalFacility.MusicPlayer)}, {nameof(ParentalFacility.HighChair)}, {nameof(ParentalFacility.SittingChair)}) " + $"VALUES (${nameof(ParentalFacility.Id)}, ${nameof(ParentalFacility.Name)}, ${nameof(ParentalFacility.Description)}, ${nameof(ParentalFacility.Rating)}, ${nameof(ParentalFacility.Latitude)} , ${nameof(ParentalFacility.Longitude)}, ${nameof(ParentalFacility.LastCleanedAt)}, " + $"${nameof(ParentalFacility.Microwave)}, ${nameof(ParentalFacility.ChangeTable)}, ${nameof(ParentalFacility.RubbishBin)}, ${nameof(ParentalFacility.Toilet)}, ${nameof(ParentalFacility.Shower)}, ${nameof(ParentalFacility.MusicPlayer)}, ${nameof(ParentalFacility.HighChair)}, ${nameof(ParentalFacility.SittingChair)})"; var cmd = new SqliteCommand(insert, _connection); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.Id)}", entity.Id); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.Name)}", entity.Name); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.Description)}", entity.Description); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.Rating)}", entity.Rating); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.Latitude)}", entity.Latitude); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.Longitude)}", entity.Longitude); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.LastCleanedAt)}", entity.LastCleanedAt.ToString()); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.Microwave)}", entity.Microwave); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.ChangeTable)}", entity.ChangeTable); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.RubbishBin)}", entity.RubbishBin); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.Toilet)}", entity.Toilet); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.Shower)}", entity.Shower); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.MusicPlayer)}", entity.MusicPlayer); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.HighChair)}", entity.HighChair); cmd.Parameters.AddWithValue($"${nameof(ParentalFacility.SittingChair)}", entity.SittingChair); cmd.ExecuteScalar(); }
public ParentalFacilityDto Map(ParentalFacility input) { return(_mapper.Map <ParentalFacilityDto>(input)); }