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