public DaoResponse<Venue> Insert(Venue entity) { using (var connection = _dbCommProvider.CreateDbConnection()) using (var command = _dbCommProvider.CreateDbCommand(connection, SqlQueries.InsertVenue, CreateVenueParameter(entity))) { _dbCommProvider.ExecuteNonQuery(command); } return DaoResponse.QuerySuccessful(entity); }
public abstract List<Performance> GetPerformancesPerVenue(Venue venue);
private Dictionary<string, QueryParameter> CreateVenueParameter(Venue venue) { return new Dictionary<string, QueryParameter> { {"?VenueId", new QueryParameter {ParameterValue = venue.VenueId}}, {"?Name", new QueryParameter {ParameterValue = venue.Name}}, {"?LocationId", new QueryParameter {ParameterValue = venue.Location.LocationId}} }; }
public List<Performance> GetPerformancesPerVenue(Venue venue) => ViewAccessDelegate.GetPerformancesPerVenue(venue);
private Venue CreateVenueObject(IDataReader dataReader) { var venue = new Venue { VenueId = _dbCommProvider.CastDbObject<string>(dataReader, "VenueId"), Name = _dbCommProvider.CastDbObject<string>(dataReader, "VenueName"), Location = new Location { LocationId = _dbCommProvider.CastDbObject<int>(dataReader, "LocationId"), Name = _dbCommProvider.CastDbObject<string>(dataReader, "LocationName"), Latitude = _dbCommProvider.CastDbObject<decimal>(dataReader, "Latitude"), Longitude = _dbCommProvider.CastDbObject<decimal>(dataReader, "Longitude") } }; return venue; }
public bool ModifyVenue(SessionToken token, Venue venue) => AdminAccessDelegate.ModifyVenue(token, venue);
public bool RemoveVenue(SessionToken token, Venue venue) => AdminAccessDelegate.RemoveVenue(token, venue);
public override bool ModifyVenue(SessionToken token, Venue venue) { if (!IsUserAuthenticated(token) || !IsVenueValid(venue)) return false; var result = VenueDao.SelectById(venue.VenueId); result = result.ResponseStatus == DaoStatus.Successful ? VenueDao.Update(venue) : VenueDao.Insert(venue); return result.ResponseStatus == DaoStatus.Successful; }
public override bool RemoveVenue(SessionToken token, Venue venue) { if (!IsUserAuthenticated(token) || !IsVenueValid(venue)) return false; var result = VenueDao.SelectById(venue.VenueId); if (result.ResponseStatus == DaoStatus.Successful) result = VenueDao.Delete(venue); return result.ResponseStatus == DaoStatus.Successful; }
private Performance CreatePerformanceObject(IDataReader dataReader) { var performance = new Performance { DateTime = (DateTime)dataReader["Date"] }; var artist = new Artist { ArtistId = _dbCommProvider.CastDbObject<int>(dataReader, "ArtistId"), Name = _dbCommProvider.CastDbObject<string>(dataReader, "ArtistName"), EMail = _dbCommProvider.CastDbObject<string>(dataReader, "EMail"), PromoVideo = _dbCommProvider.CastDbObject<string>(dataReader, "PromoVideo"), Picture = new BlobData { Path = _dbCommProvider.CastDbObject<string>(dataReader, "Picture") }, Country = new Country { Code = _dbCommProvider.CastDbObject<string>(dataReader, "CountryCode"), Name = _dbCommProvider.CastDbObject<string>(dataReader, "CountryName") } }; if (!_dbCommProvider.IsDbNull(dataReader, "CategoryId")) { artist.Category = new Category { CategoryId = _dbCommProvider.CastDbObject<string>(dataReader, "CategoryId"), Name = _dbCommProvider.CastDbObject<string>(dataReader, "CategoryName"), Color = _dbCommProvider.CastDbObject<string>(dataReader, "CategoryColor") }; } performance.Artist = artist; if (!_dbCommProvider.IsDbNull(dataReader, "VenueId")) { var venue = new Venue { VenueId = _dbCommProvider.CastDbObject<string>(dataReader, "VenueId"), Name = _dbCommProvider.CastDbObject<string>(dataReader, "VenueName"), Location = new Location { LocationId = _dbCommProvider.CastDbObject<int>(dataReader, "LocationId"), Name = _dbCommProvider.CastDbObject<string>(dataReader, "LocationName"), Latitude = _dbCommProvider.CastDbObject<decimal>(dataReader, "Latitude"), Longitude = _dbCommProvider.CastDbObject<decimal>(dataReader, "Longitude") } }; performance.Venue = venue; } return performance; }
public void TestInsertVenueDbAccess() { var venueDao = FactoryProvider.GetFactory<IDaoProviderFactory>( TestDbDaoAssemblyName, TestDbDaoNameSpace, TestDbDaoClassName).CreateVenueDao(); using (var scope = new TransactionScope()) { var venue = new Venue { VenueId = "A7", Name = "Tiki Tiki", Location = new Location { LocationId = 3} }; venueDao.Insert(venue) .OnFailure(response => Assert.Fail($"Insert does not work! {response.Exception}")); // do not commit changes; only for testing //scope.Complete(); } }
public override List<Performance> GetPerformancesPerVenue(Venue venue) { return venue != null ? PerformanceDao.SelectByVenueId(venue.VenueId).ResultObject : null; }
public static async Task<bool> ModifyVenueAsync(this IAdminAccessBll accessBll, SessionToken token, Venue venue) { var venueWs = venue.ToWebSeriveObject<WS.Venue>(); var tokenWs = token.ToWebSeriveObject<WS.SessionToken>(); return await AdminAccessWs.ModifyVenueAsync(tokenWs, venueWs); }
public DaoResponse<Venue> Update(Venue entity) { throw new System.NotImplementedException(); }