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);
}
public ConferenceSpeakersLanguage GetByID(int _conferenceSpeakerId)
{
ConferenceSpeakersLanguageDAC _conferenceSpeakersLanguageComponent = new ConferenceSpeakersLanguageDAC();
IDataReader reader = _conferenceSpeakersLanguageComponent.GetByIDConferenceSpeakersLanguage(_conferenceSpeakerId);
ConferenceSpeakersLanguage _conferenceSpeakersLanguage = null;
while (reader.Read())
{
_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;
}
reader.Close();
return(_conferenceSpeakersLanguage);
}
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));
}
