public bool Update(ConferenceSpeakersLanguage conferencespeakerslanguage ,int old_conferenceSpeakerId) { ConferenceSpeakersLanguageDAC conferencespeakerslanguageComponent = new ConferenceSpeakersLanguageDAC(); return conferencespeakerslanguageComponent.UpdateConferenceSpeakersLanguage( conferencespeakerslanguage.PersonId, conferencespeakerslanguage.ConferenceId, conferencespeakerslanguage.DateRegistered, conferencespeakerslanguage.SpeakerImage, conferencespeakerslanguage.SpeakerPosition, conferencespeakerslanguage.SpeakerBio, conferencespeakerslanguage.FlightfromCountry, conferencespeakerslanguage.FlightFromCity, conferencespeakerslanguage.FlightToCountry, conferencespeakerslanguage.FlightToCity, conferencespeakerslanguage.FlightNO, conferencespeakerslanguage.ArrivalDate, conferencespeakerslanguage.ArrivalTime, conferencespeakerslanguage.DepratureDate, conferencespeakerslanguage.DepratureTime, conferencespeakerslanguage.AirllineID, conferencespeakerslanguage.HotelID, conferencespeakerslanguage.ResponsiblePersonID, conferencespeakerslanguage.ArrivalTimeAMorPM, conferencespeakerslanguage.DepratureTimeAMorPM, conferencespeakerslanguage.LanguageID, conferencespeakerslanguage.ConferenceSpeakerParentId, old_conferenceSpeakerId); }
public List<ConferenceSpeakersLanguage> GetAll(int ParentID) { ConferenceSpeakersLanguageDAC _conferenceSpeakersLanguageComponent = new ConferenceSpeakersLanguageDAC(); IDataReader reader = _conferenceSpeakersLanguageComponent.GetAllConferenceSpeakersLanguage("ConferenceSpeakerParentId="+ParentID).CreateDataReader(); List<ConferenceSpeakersLanguage> _conferenceSpeakersLanguageList = new List<ConferenceSpeakersLanguage>(); while (reader.Read()) { if (_conferenceSpeakersLanguageList == null) _conferenceSpeakersLanguageList = new List<ConferenceSpeakersLanguage>(); ConferenceSpeakersLanguage _conferenceSpeakersLanguage = new ConferenceSpeakersLanguage(); if (reader["ConferenceSpeakerId"] != DBNull.Value) _conferenceSpeakersLanguage.ConferenceSpeakerId = Convert.ToInt32(reader["ConferenceSpeakerId"]); if (reader["PersonId"] != DBNull.Value) _conferenceSpeakersLanguage.PersonId = Convert.ToInt32(reader["PersonId"]); if (reader["ConferenceId"] != DBNull.Value) _conferenceSpeakersLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); if (reader["DateRegistered"] != DBNull.Value) _conferenceSpeakersLanguage.DateRegistered = Convert.ToDateTime(reader["DateRegistered"]); if (reader["SpeakerImage"] != DBNull.Value) _conferenceSpeakersLanguage.SpeakerImage = Convert.ToString(reader["SpeakerImage"]); if (reader["SpeakerPosition"] != DBNull.Value) _conferenceSpeakersLanguage.SpeakerPosition = Convert.ToString(reader["SpeakerPosition"]); if (reader["SpeakerBio"] != DBNull.Value) _conferenceSpeakersLanguage.SpeakerBio = Convert.ToString(reader["SpeakerBio"]); if (reader["FlightfromCountry"] != DBNull.Value) _conferenceSpeakersLanguage.FlightfromCountry = Convert.ToString(reader["FlightfromCountry"]); if (reader["FlightFromCity"] != DBNull.Value) _conferenceSpeakersLanguage.FlightFromCity = Convert.ToString(reader["FlightFromCity"]); if (reader["FlightToCountry"] != DBNull.Value) _conferenceSpeakersLanguage.FlightToCountry = Convert.ToString(reader["FlightToCountry"]); if (reader["FlightToCity"] != DBNull.Value) _conferenceSpeakersLanguage.FlightToCity = Convert.ToString(reader["FlightToCity"]); if (reader["FlightNO"] != DBNull.Value) _conferenceSpeakersLanguage.FlightNO = Convert.ToString(reader["FlightNO"]); if (reader["ArrivalDate"] != DBNull.Value) _conferenceSpeakersLanguage.ArrivalDate = Convert.ToDateTime(reader["ArrivalDate"]); if (reader["ArrivalTime"] != DBNull.Value) _conferenceSpeakersLanguage.ArrivalTime = Convert.ToString(reader["ArrivalTime"]); if (reader["DepratureDate"] != DBNull.Value) _conferenceSpeakersLanguage.DepratureDate = Convert.ToDateTime(reader["DepratureDate"]); if (reader["DepratureTime"] != DBNull.Value) _conferenceSpeakersLanguage.DepratureTime = Convert.ToString(reader["DepratureTime"]); if (reader["AirllineID"] != DBNull.Value) _conferenceSpeakersLanguage.AirllineID = Convert.ToInt32(reader["AirllineID"]); if (reader["HotelID"] != DBNull.Value) _conferenceSpeakersLanguage.HotelID = Convert.ToInt32(reader["HotelID"]); if (reader["ResponsiblePersonID"] != DBNull.Value) _conferenceSpeakersLanguage.ResponsiblePersonID = Convert.ToInt32(reader["ResponsiblePersonID"]); if (reader["ArrivalTimeAMorPM"] != DBNull.Value) _conferenceSpeakersLanguage.ArrivalTimeAMorPM = Convert.ToString(reader["ArrivalTimeAMorPM"]); if (reader["DepratureTimeAMorPM"] != DBNull.Value) _conferenceSpeakersLanguage.DepratureTimeAMorPM = Convert.ToString(reader["DepratureTimeAMorPM"]); if (reader["LanguageID"] != DBNull.Value) _conferenceSpeakersLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); if (reader["ConferenceSpeakerParentId"] != DBNull.Value) _conferenceSpeakersLanguage.ConferenceSpeakerParentId = Convert.ToInt32(reader["ConferenceSpeakerParentId"]); _conferenceSpeakersLanguage.NewRecord = false; _conferenceSpeakersLanguageList.Add(_conferenceSpeakersLanguage); } reader.Close(); return _conferenceSpeakersLanguageList; }
public bool Insert(ConferenceSpeakersLanguage conferencespeakerslanguage) { int autonumber = 0; ConferenceSpeakersLanguageDAC conferencespeakerslanguageComponent = new ConferenceSpeakersLanguageDAC(); bool endedSuccessfuly = conferencespeakerslanguageComponent.InsertNewConferenceSpeakersLanguage( ref autonumber, conferencespeakerslanguage.PersonId, conferencespeakerslanguage.ConferenceId, conferencespeakerslanguage.DateRegistered, conferencespeakerslanguage.SpeakerImage, conferencespeakerslanguage.SpeakerPosition, conferencespeakerslanguage.SpeakerBio, conferencespeakerslanguage.FlightfromCountry, conferencespeakerslanguage.FlightFromCity, conferencespeakerslanguage.FlightToCountry, conferencespeakerslanguage.FlightToCity, conferencespeakerslanguage.FlightNO, conferencespeakerslanguage.ArrivalDate, conferencespeakerslanguage.ArrivalTime, conferencespeakerslanguage.DepratureDate, conferencespeakerslanguage.DepratureTime, conferencespeakerslanguage.AirllineID, conferencespeakerslanguage.HotelID, conferencespeakerslanguage.ResponsiblePersonID, conferencespeakerslanguage.ArrivalTimeAMorPM, conferencespeakerslanguage.DepratureTimeAMorPM, conferencespeakerslanguage.LanguageID, conferencespeakerslanguage.ConferenceSpeakerParentId); if(endedSuccessfuly) { conferencespeakerslanguage.ConferenceSpeakerId = autonumber; } return endedSuccessfuly; }