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 Venues(Guid venue_ID) { VenuesBL venues = new VenuesBL(); tblVenues = venues.GetVenueByVenue_ID(venue_ID); Venue_ID = venue_ID; Venue_Name = tblVenues[0].Venue_Name; Address_ID = tblVenues[0].Address_ID; if (!tblVenues[0].IsVenue_ContactNull()) Venue_Contact = tblVenues[0].Venue_Contact; }
public bool Update_Venue(Guid venue_ID, Guid user_ID) { bool retVal = false; try { VenuesBL venues = new VenuesBL(_connString); retVal = venues.Update_Venues(venue_ID, _venue_Name, _address_ID, _venue_Contact, _deleteVenue, user_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public Guid?Insert_Venue(Guid user_ID) { Guid?retVal = null; try { VenuesBL venues = new VenuesBL(_connString); retVal = venues.Insert_Venues(_venue_Name, _address_ID, _venue_Contact, user_ID); } catch (Exception ex) { throw ex; } return(retVal); }
public List<Venues> GetVenues() { List<Venues> venueList = new List<Venues>(); VenuesBL venues = new VenuesBL(); tblVenues = venues.GetVenues(); 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 Venues(string connString, Guid venue_ID) { _connString = connString; try { VenuesBL venueBL = new VenuesBL(_connString); tblVenues = venueBL.GetVenueByVenue_ID(venue_ID); DataRow row = tblVenues.Rows[0]; Venue_ID = venue_ID; Venue_Name = Utils.DBNullToString(row["Venue_Name"]); Address_ID = Utils.DBNullToGuid(row["Address_ID"]); Venue_Contact = Utils.DBNullToGuid(row["Venue_Contact"]); } catch (Exception ex) { throw ex; } }
public bool Update_Venue(Guid venue_ID, Guid user_ID) { bool success = false; VenuesBL venues = new VenuesBL(); success = venues.Update_Venues(venue_ID, Venue_Name, Address_ID, Venue_Contact, DeleteVenue, user_ID); return success; }
public Guid? Insert_Venue(Guid user_ID) { VenuesBL venues = new VenuesBL(); Guid? newID = venues.Insert_Venues(Venue_Name, Address_ID, Venue_Contact, user_ID); return newID; }