public bool Insert(string Name, string Description, string Location, int Star, string URL, string Phone, string Fax, string Email) { VenuesDAC venuesComponent = new VenuesDAC(); int ID = 0; return(venuesComponent.InsertNewVenues(ref ID, Name, Description, Location, Star, URL, Phone, Fax, Email)); }
public List <Venues> GetAll() { VenuesDAC _venuesComponent = new VenuesDAC(); IDataReader reader = _venuesComponent.GetAllVenues().CreateDataReader(); List <Venues> _venuesList = new List <Venues>(); while (reader.Read()) { if (_venuesList == null) { _venuesList = new List <Venues>(); } Venues _venues = new Venues(); if (reader["ID"] != DBNull.Value) { _venues.ID = Convert.ToInt32(reader["ID"]); } if (reader["Name"] != DBNull.Value) { _venues.Name = Convert.ToString(reader["Name"]); } if (reader["Description"] != DBNull.Value) { _venues.Description = Convert.ToString(reader["Description"]); } if (reader["Location"] != DBNull.Value) { _venues.Location = Convert.ToString(reader["Location"]); } if (reader["Star"] != DBNull.Value) { _venues.Star = Convert.ToInt32(reader["Star"]); } if (reader["URL"] != DBNull.Value) { _venues.URL = Convert.ToString(reader["URL"]); } if (reader["Phone"] != DBNull.Value) { _venues.Phone = Convert.ToString(reader["Phone"]); } if (reader["Fax"] != DBNull.Value) { _venues.Fax = Convert.ToString(reader["Fax"]); } if (reader["Email"] != DBNull.Value) { _venues.Email = Convert.ToString(reader["Email"]); } _venues.NewRecord = false; _venuesList.Add(_venues); } reader.Close(); return(_venuesList); }
public bool Insert(Venues venues) { int autonumber = 0; VenuesDAC venuesComponent = new VenuesDAC(); bool endedSuccessfuly = venuesComponent.InsertNewVenues(ref autonumber, venues.Name, venues.Description, venues.Location, venues.Star, venues.URL, venues.Phone, venues.Fax, venues.Email); if (endedSuccessfuly) { venues.ID = autonumber; } return(endedSuccessfuly); }
public Venues GetByID(int _iD) { VenuesDAC _venuesComponent = new VenuesDAC(); IDataReader reader = _venuesComponent.GetByIDVenues(_iD); Venues _venues = null; while (reader.Read()) { _venues = new Venues(); if (reader["ID"] != DBNull.Value) { _venues.ID = Convert.ToInt32(reader["ID"]); } if (reader["Name"] != DBNull.Value) { _venues.Name = Convert.ToString(reader["Name"]); } if (reader["Description"] != DBNull.Value) { _venues.Description = Convert.ToString(reader["Description"]); } if (reader["Location"] != DBNull.Value) { _venues.Location = Convert.ToString(reader["Location"]); } if (reader["Star"] != DBNull.Value) { _venues.Star = Convert.ToInt32(reader["Star"]); } if (reader["URL"] != DBNull.Value) { _venues.URL = Convert.ToString(reader["URL"]); } if (reader["Phone"] != DBNull.Value) { _venues.Phone = Convert.ToString(reader["Phone"]); } if (reader["Fax"] != DBNull.Value) { _venues.Fax = Convert.ToString(reader["Fax"]); } if (reader["Email"] != DBNull.Value) { _venues.Email = Convert.ToString(reader["Email"]); } _venues.NewRecord = false; } reader.Close(); return(_venues); }
public int UpdateDataset(System.Data.DataSet dataset) { VenuesDAC venuescomponent = new VenuesDAC(); return(venuescomponent.UpdateDataset(dataset)); }
public void Delete(int Original_ID) { VenuesDAC venuesComponent = new VenuesDAC(); venuesComponent.DeleteVenues(Original_ID); }
public bool Update(string Name, string Description, string Location, int Star, string URL, string Phone, string Fax, string Email, int Original_ID) { VenuesDAC venuesComponent = new VenuesDAC(); return(venuesComponent.UpdateVenues(Name, Description, Location, Star, URL, Phone, Fax, Email, Original_ID)); }
public bool Update(Venues venues, int old_iD) { VenuesDAC venuesComponent = new VenuesDAC(); return(venuesComponent.UpdateVenues(venues.Name, venues.Description, venues.Location, venues.Star, venues.URL, venues.Phone, venues.Fax, venues.Email, old_iD)); }