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;
}