//SEARCH Venues
public Paged <VenuesV2> SearchV2(int pageIndex, int pageSize, string query)
{
Paged <VenuesV2> pagedVenues = null;
List <VenuesV2> venueList = null;
int totalCount = 0;
string procName = "[dbo].[Venues_SearchV2]";
_data.ExecuteCmd(procName, delegate(SqlParameterCollection paginationParams)
{
paginationParams.AddWithValue("@pageIndex", pageIndex);
paginationParams.AddWithValue("@pageSize", pageSize);
paginationParams.AddWithValue("@query", query);
}, delegate(IDataReader reader, short set)
{
VenuesV2 aVenue = MapVenueV2(reader, out int index);
if (totalCount == 0)
{
totalCount = reader.GetSafeInt32(index);
}
if (venueList == null)
{
venueList = new List <VenuesV2>();
}
venueList.Add(aVenue);
});
{
pagedVenues = new Paged <VenuesV2>(venueList, pageIndex, pageSize, totalCount);
}
return(pagedVenues);
}
private static VenuesV2 MapVenueV2(IDataReader reader, out int startingIndex)
{
VenuesV2 aVenue = new VenuesV2();
startingIndex = 0;
aVenue.Id = reader.GetSafeInt32(startingIndex++);
aVenue.Name = reader.GetSafeString(startingIndex++);
aVenue.Description = reader.GetSafeString(startingIndex++);
Location location = new Location();
location.Id = reader.GetSafeInt32(startingIndex++);
location.LocationType = new Models.Domain.LookUp.TwoColumn();
location.LocationType.Id = reader.GetSafeInt32(startingIndex++);
location.LocationType.Name = reader.GetSafeString(startingIndex++);
location.LineOne = reader.GetSafeString(startingIndex++);
location.LineTwo = reader.GetSafeString(startingIndex++);
location.City = reader.GetSafeString(startingIndex++);
location.Zip = reader.GetSafeString(startingIndex++);
location.State = new Models.Domain.LookUp.TwoColumn();
location.State.Id = reader.GetSafeInt32(startingIndex++);
location.State.Name = reader.GetSafeString(startingIndex++);
location.Latitude = reader.GetSafeDouble(startingIndex++);
location.Longitude = reader.GetSafeDouble(startingIndex++);
location.DateModified = reader.GetSafeDateTime(startingIndex++);
location.DateAdded = reader.GetSafeDateTime(startingIndex++);
location.CreatedBy = new UserProfile();
location.CreatedBy.UserId = reader.GetSafeInt32(startingIndex++);
aVenue.Location = location;
aVenue.Url = reader.GetSafeString(startingIndex++);
aVenue.CreatedBy = reader.GetSafeInt32(startingIndex++);
aVenue.ModifiedBy = reader.GetSafeInt32(startingIndex++);
aVenue.DateCreated = reader.GetSafeUtcDateTime(startingIndex++);
aVenue.DateModified = reader.GetSafeUtcDateTime(startingIndex++);
return(aVenue);
}
