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();
}
