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