public bool Insert(InvitedGuestsLanguage invitedguestslanguage) { int autonumber = 0; InvitedGuestsLanguageDAC invitedguestslanguageComponent = new InvitedGuestsLanguageDAC(); bool endedSuccessfuly = invitedguestslanguageComponent.InsertNewInvitedGuestsLanguage(ref autonumber, invitedguestslanguage.PersonId, invitedguestslanguage.ConferenceId, invitedguestslanguage.DateRegistered, invitedguestslanguage.SpeakerImage, invitedguestslanguage.SpeakerPosition, invitedguestslanguage.SpeakerBio, invitedguestslanguage.FlightfromCountry, invitedguestslanguage.FlightFromCity, invitedguestslanguage.FlightToCountry, invitedguestslanguage.FlightToCity, invitedguestslanguage.FlightNO, invitedguestslanguage.ArrivalDate, invitedguestslanguage.ArrivalTime, invitedguestslanguage.DepratureDate, invitedguestslanguage.DepratureTime, invitedguestslanguage.AirllineID, invitedguestslanguage.HotelID, invitedguestslanguage.ResponsiblePersonID, invitedguestslanguage.ArrivalTimeAMorPM, invitedguestslanguage.DepratureTimeAMorPM, invitedguestslanguage.LanguageID, invitedguestslanguage.parentID); if (endedSuccessfuly) { invitedguestslanguage.ID = autonumber; } return(endedSuccessfuly); }
public InvitedGuestsLanguage GetByID(int _iD) { InvitedGuestsLanguageDAC _invitedGuestsLanguageComponent = new InvitedGuestsLanguageDAC(); IDataReader reader = _invitedGuestsLanguageComponent.GetByIDInvitedGuestsLanguage(_iD); InvitedGuestsLanguage _invitedGuestsLanguage = null; while (reader.Read()) { _invitedGuestsLanguage = new InvitedGuestsLanguage(); if (reader["ID"] != DBNull.Value) { _invitedGuestsLanguage.ID = Convert.ToInt32(reader["ID"]); } if (reader["PersonId"] != DBNull.Value) { _invitedGuestsLanguage.PersonId = Convert.ToInt32(reader["PersonId"]); } if (reader["ConferenceId"] != DBNull.Value) { _invitedGuestsLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); } if (reader["DateRegistered"] != DBNull.Value) { _invitedGuestsLanguage.DateRegistered = Convert.ToDateTime(reader["DateRegistered"]); } if (reader["SpeakerImage"] != DBNull.Value) { _invitedGuestsLanguage.SpeakerImage = Convert.ToString(reader["SpeakerImage"]); } if (reader["SpeakerPosition"] != DBNull.Value) { _invitedGuestsLanguage.SpeakerPosition = Convert.ToString(reader["SpeakerPosition"]); } if (reader["SpeakerBio"] != DBNull.Value) { _invitedGuestsLanguage.SpeakerBio = Convert.ToString(reader["SpeakerBio"]); } if (reader["FlightfromCountry"] != DBNull.Value) { _invitedGuestsLanguage.FlightfromCountry = Convert.ToString(reader["FlightfromCountry"]); } if (reader["FlightFromCity"] != DBNull.Value) { _invitedGuestsLanguage.FlightFromCity = Convert.ToString(reader["FlightFromCity"]); } if (reader["FlightToCountry"] != DBNull.Value) { _invitedGuestsLanguage.FlightToCountry = Convert.ToString(reader["FlightToCountry"]); } if (reader["FlightToCity"] != DBNull.Value) { _invitedGuestsLanguage.FlightToCity = Convert.ToString(reader["FlightToCity"]); } if (reader["FlightNO"] != DBNull.Value) { _invitedGuestsLanguage.FlightNO = Convert.ToString(reader["FlightNO"]); } if (reader["ArrivalDate"] != DBNull.Value) { _invitedGuestsLanguage.ArrivalDate = Convert.ToDateTime(reader["ArrivalDate"]); } if (reader["ArrivalTime"] != DBNull.Value) { _invitedGuestsLanguage.ArrivalTime = Convert.ToString(reader["ArrivalTime"]); } if (reader["DepratureDate"] != DBNull.Value) { _invitedGuestsLanguage.DepratureDate = Convert.ToDateTime(reader["DepratureDate"]); } if (reader["DepratureTime"] != DBNull.Value) { _invitedGuestsLanguage.DepratureTime = Convert.ToString(reader["DepratureTime"]); } if (reader["AirllineID"] != DBNull.Value) { _invitedGuestsLanguage.AirllineID = Convert.ToInt32(reader["AirllineID"]); } if (reader["HotelID"] != DBNull.Value) { _invitedGuestsLanguage.HotelID = Convert.ToInt32(reader["HotelID"]); } if (reader["ResponsiblePersonID"] != DBNull.Value) { _invitedGuestsLanguage.ResponsiblePersonID = Convert.ToInt32(reader["ResponsiblePersonID"]); } if (reader["ArrivalTimeAMorPM"] != DBNull.Value) { _invitedGuestsLanguage.ArrivalTimeAMorPM = Convert.ToString(reader["ArrivalTimeAMorPM"]); } if (reader["DepratureTimeAMorPM"] != DBNull.Value) { _invitedGuestsLanguage.DepratureTimeAMorPM = Convert.ToString(reader["DepratureTimeAMorPM"]); } if (reader["LanguageID"] != DBNull.Value) { _invitedGuestsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); } if (reader["parentID"] != DBNull.Value) { _invitedGuestsLanguage.parentID = Convert.ToInt32(reader["parentID"]); } _invitedGuestsLanguage.NewRecord = false; } reader.Close(); return(_invitedGuestsLanguage); }
public bool Update(InvitedGuestsLanguage invitedguestslanguage, int old_iD) { InvitedGuestsLanguageDAC invitedguestslanguageComponent = new InvitedGuestsLanguageDAC(); return(invitedguestslanguageComponent.UpdateInvitedGuestsLanguage(invitedguestslanguage.PersonId, invitedguestslanguage.ConferenceId, invitedguestslanguage.DateRegistered, invitedguestslanguage.SpeakerImage, invitedguestslanguage.SpeakerPosition, invitedguestslanguage.SpeakerBio, invitedguestslanguage.FlightfromCountry, invitedguestslanguage.FlightFromCity, invitedguestslanguage.FlightToCountry, invitedguestslanguage.FlightToCity, invitedguestslanguage.FlightNO, invitedguestslanguage.ArrivalDate, invitedguestslanguage.ArrivalTime, invitedguestslanguage.DepratureDate, invitedguestslanguage.DepratureTime, invitedguestslanguage.AirllineID, invitedguestslanguage.HotelID, invitedguestslanguage.ResponsiblePersonID, invitedguestslanguage.ArrivalTimeAMorPM, invitedguestslanguage.DepratureTimeAMorPM, invitedguestslanguage.LanguageID, invitedguestslanguage.parentID, old_iD)); }