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); }
public List<InvitedGuestsLanguage> GetAll(int ParentID) { InvitedGuestsLanguageDAC _invitedGuestsLanguageComponent = new InvitedGuestsLanguageDAC(); IDataReader reader = _invitedGuestsLanguageComponent.GetAllInvitedGuestsLanguage("ParentID="+ParentID).CreateDataReader(); List<InvitedGuestsLanguage> _invitedGuestsLanguageList = new List<InvitedGuestsLanguage>(); while (reader.Read()) { if (_invitedGuestsLanguageList == null) _invitedGuestsLanguageList = new List<InvitedGuestsLanguage>(); InvitedGuestsLanguage _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; _invitedGuestsLanguageList.Add(_invitedGuestsLanguage); } reader.Close(); return _invitedGuestsLanguageList; }
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; }