public Travel GetByID(int _iD) { TravelDAC _travelComponent = new TravelDAC(); IDataReader reader = _travelComponent.GetByIDTravel(_iD); Travel _travel = null; while (reader.Read()) { _travel = new Travel(); if (reader["ID"] != DBNull.Value) { _travel.ID = Convert.ToInt32(reader["ID"]); } if (reader["Name"] != DBNull.Value) { _travel.Name = Convert.ToString(reader["Name"]); } if (reader["TransportationTypeID"] != DBNull.Value) { _travel.TransportationTypeID = Convert.ToInt32(reader["TransportationTypeID"]); } if (reader["Description"] != DBNull.Value) { _travel.Description = Convert.ToString(reader["Description"]); } if (reader["ConferenceID"] != DBNull.Value) { _travel.ConferenceID = Convert.ToInt32(reader["ConferenceID"]); } _travel.NewRecord = false; } reader.Close(); return(_travel); }
public bool Insert(string Name, int TransportationTypeID, string Description, int ConferenceID) { TravelDAC travelComponent = new TravelDAC(); int ID = 0; return(travelComponent.InsertNewTravel(ref ID, Name, TransportationTypeID, Description, ConferenceID)); }
public bool Insert(Travel travel) { int autonumber = 0; TravelDAC travelComponent = new TravelDAC(); bool endedSuccessfuly = travelComponent.InsertNewTravel(ref autonumber, travel.Name, travel.TransportationTypeID, travel.Description, travel.ConferenceID); if (endedSuccessfuly) { travel.ID = autonumber; } return(endedSuccessfuly); }
public List <Travel> GetAllByConferenceID(int ConferenceID) { TravelDAC _travelComponent = new TravelDAC(); IDataReader reader = _travelComponent.GetAllTravel("ConferenceID = " + ConferenceID).CreateDataReader(); List <Travel> _travelList = new List <Travel>(); while (reader.Read()) { if (_travelList == null) { _travelList = new List <Travel>(); } Travel _travel = new Travel(); if (reader["ID"] != DBNull.Value) { _travel.ID = Convert.ToInt32(reader["ID"]); } if (reader["Name"] != DBNull.Value) { _travel.Name = Convert.ToString(reader["Name"]); } if (reader["TransportationTypeID"] != DBNull.Value) { _travel.TransportationTypeID = Convert.ToInt32(reader["TransportationTypeID"]); } if (reader["Description"] != DBNull.Value) { _travel.Description = Convert.ToString(reader["Description"]); } if (reader["ConferenceID"] != DBNull.Value) { _travel.ConferenceID = Convert.ToInt32(reader["ConferenceID"]); } _travel.NewRecord = false; _travelList.Add(_travel); } reader.Close(); return(_travelList); }
public int UpdateDataset(System.Data.DataSet dataset) { TravelDAC travelcomponent = new TravelDAC(); return(travelcomponent.UpdateDataset(dataset)); }
public void Delete(int Original_ID) { TravelDAC travelComponent = new TravelDAC(); travelComponent.DeleteTravel(Original_ID); }
public bool Update(string Name, int TransportationTypeID, string Description, int ConferenceID, int Original_ID) { TravelDAC travelComponent = new TravelDAC(); return(travelComponent.UpdateTravel(Name, TransportationTypeID, Description, ConferenceID, Original_ID)); }
public bool Update(Travel travel, int old_iD) { TravelDAC travelComponent = new TravelDAC(); return(travelComponent.UpdateTravel(travel.Name, travel.TransportationTypeID, travel.Description, travel.ConferenceID, old_iD)); }