public List <Venues> GetVenues()
{
List <Venues> retVal = new List <Venues>();
try
{
VenuesBL venueBL = new VenuesBL(_connString);
tblVenues = venueBL.GetVenues();
if (tblVenues != null && tblVenues.Rows.Count > 0)
{
foreach (DataRow row in tblVenues.Rows)
{
Venues venue = new Venues(_connString, Utils.DBNullToGuid(row["Venue_ID"]));
retVal.Add(venue);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retVal);
}
public List<Venues> GetVenuesByAddress_ID(Guid address_ID)
{
List<Venues> venueList = new List<Venues>();
VenuesBL venues = new VenuesBL();
tblVenues = venues.GetVenueByAddress_ID(address_ID);
if (tblVenues != null && tblVenues.Count > 0)
{
foreach (sss.tblVenuesRow row in tblVenues)
{
Venues venue = new Venues(row.Venue_ID);
venueList.Add(venue);
}
}
return venueList;
}
public List<Venues> GetVenuesLikeVenue_Name(string venue_Name)
{
List<Venues> venueList = new List<Venues>();
VenuesBL venues = new VenuesBL();
tblVenues = venues.GetVenuesLikeVenue_Name(venue_Name);
if (tblVenues != null && tblVenues.Count > 0)
{
foreach (sss.tblVenuesRow row in tblVenues)
{
Venues venue = new Venues(row.Venue_ID);
venueList.Add(venue);
}
}
return venueList;
}
