public bool Insert(ConferencesLanguage conferenceslanguage) { int autonumber = 0; ConferencesLanguageDAC conferenceslanguageComponent = new ConferencesLanguageDAC(); bool endedSuccessfuly = conferenceslanguageComponent.InsertNewConferencesLanguage(ref autonumber, conferenceslanguage.SiteId, conferenceslanguage.ConferenceName, conferenceslanguage.ConferenceLogo, conferenceslanguage.StartDate, conferenceslanguage.EndDate, conferenceslanguage.IsActive, conferenceslanguage.Location, conferenceslanguage.LocationName, conferenceslanguage.LocationLogo, conferenceslanguage.LocationLongitude, conferenceslanguage.LocationLatitude, conferenceslanguage.ConferenceDomain, conferenceslanguage.ConferenceParentId, conferenceslanguage.LanguageID); if (endedSuccessfuly) { conferenceslanguage.ConferenceId = autonumber; } return(endedSuccessfuly); }
public ConferencesLanguage GetByID(int _conferenceId) { ConferencesLanguageDAC _conferencesLanguageComponent = new ConferencesLanguageDAC(); IDataReader reader = _conferencesLanguageComponent.GetByIDConferencesLanguage(_conferenceId); ConferencesLanguage _conferencesLanguage = null; while (reader.Read()) { _conferencesLanguage = new ConferencesLanguage(); if (reader["ConferenceId"] != DBNull.Value) { _conferencesLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); } if (reader["SiteId"] != DBNull.Value) { _conferencesLanguage.SiteId = Convert.ToInt32(reader["SiteId"]); } if (reader["ConferenceName"] != DBNull.Value) { _conferencesLanguage.ConferenceName = Convert.ToString(reader["ConferenceName"]); } if (reader["ConferenceLogo"] != DBNull.Value) { _conferencesLanguage.ConferenceLogo = Convert.ToString(reader["ConferenceLogo"]); } if (reader["StartDate"] != DBNull.Value) { _conferencesLanguage.StartDate = Convert.ToDateTime(reader["StartDate"]); } if (reader["EndDate"] != DBNull.Value) { _conferencesLanguage.EndDate = Convert.ToDateTime(reader["EndDate"]); } if (reader["IsActive"] != DBNull.Value) { _conferencesLanguage.IsActive = Convert.ToBoolean(reader["IsActive"]); } if (reader["Location"] != DBNull.Value) { _conferencesLanguage.Location = Convert.ToString(reader["Location"]); } if (reader["LocationName"] != DBNull.Value) { _conferencesLanguage.LocationName = Convert.ToString(reader["LocationName"]); } if (reader["LocationLogo"] != DBNull.Value) { _conferencesLanguage.LocationLogo = Convert.ToString(reader["LocationLogo"]); } if (reader["LocationLongitude"] != DBNull.Value) { _conferencesLanguage.LocationLongitude = Convert.ToDecimal(reader["LocationLongitude"]); } if (reader["LocationLatitude"] != DBNull.Value) { _conferencesLanguage.LocationLatitude = Convert.ToDecimal(reader["LocationLatitude"]); } if (reader["ConferenceDomain"] != DBNull.Value) { _conferencesLanguage.ConferenceDomain = Convert.ToString(reader["ConferenceDomain"]); } if (reader["ConferenceParentId"] != DBNull.Value) { _conferencesLanguage.ConferenceParentId = Convert.ToInt32(reader["ConferenceParentId"]); } if (reader["LanguageID"] != DBNull.Value) { _conferencesLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); } _conferencesLanguage.NewRecord = false; } reader.Close(); return(_conferencesLanguage); }
public bool Update(ConferencesLanguage conferenceslanguage, int old_conferenceId) { ConferencesLanguageDAC conferenceslanguageComponent = new ConferencesLanguageDAC(); return(conferenceslanguageComponent.UpdateConferencesLanguage(conferenceslanguage.SiteId, conferenceslanguage.ConferenceName, conferenceslanguage.ConferenceLogo, conferenceslanguage.StartDate, conferenceslanguage.EndDate, conferenceslanguage.IsActive, conferenceslanguage.Location, conferenceslanguage.LocationName, conferenceslanguage.LocationLogo, conferenceslanguage.LocationLongitude, conferenceslanguage.LocationLatitude, conferenceslanguage.ConferenceDomain, conferenceslanguage.ConferenceParentId, conferenceslanguage.LanguageID, old_conferenceId)); }
public List <ConferencesLanguage> GetAll() { ConferencesLanguageDAC _conferencesLanguageComponent = new ConferencesLanguageDAC(); IDataReader reader = _conferencesLanguageComponent.GetAllConferencesLanguage().CreateDataReader(); List <ConferencesLanguage> _conferencesLanguageList = new List <ConferencesLanguage>(); while (reader.Read()) { if (_conferencesLanguageList == null) { _conferencesLanguageList = new List <ConferencesLanguage>(); } ConferencesLanguage _conferencesLanguage = new ConferencesLanguage(); if (reader["ConferenceId"] != DBNull.Value) { _conferencesLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); } if (reader["SiteId"] != DBNull.Value) { _conferencesLanguage.SiteId = Convert.ToInt32(reader["SiteId"]); } if (reader["ConferenceName"] != DBNull.Value) { _conferencesLanguage.ConferenceName = Convert.ToString(reader["ConferenceName"]); } if (reader["ConferenceLogo"] != DBNull.Value) { _conferencesLanguage.ConferenceLogo = Convert.ToString(reader["ConferenceLogo"]); } if (reader["StartDate"] != DBNull.Value) { _conferencesLanguage.StartDate = Convert.ToDateTime(reader["StartDate"]); } if (reader["EndDate"] != DBNull.Value) { _conferencesLanguage.EndDate = Convert.ToDateTime(reader["EndDate"]); } if (reader["IsActive"] != DBNull.Value) { _conferencesLanguage.IsActive = Convert.ToBoolean(reader["IsActive"]); } if (reader["Location"] != DBNull.Value) { _conferencesLanguage.Location = Convert.ToString(reader["Location"]); } if (reader["LocationName"] != DBNull.Value) { _conferencesLanguage.LocationName = Convert.ToString(reader["LocationName"]); } if (reader["LocationLogo"] != DBNull.Value) { _conferencesLanguage.LocationLogo = Convert.ToString(reader["LocationLogo"]); } if (reader["LocationLongitude"] != DBNull.Value) { _conferencesLanguage.LocationLongitude = Convert.ToDecimal(reader["LocationLongitude"]); } if (reader["LocationLatitude"] != DBNull.Value) { _conferencesLanguage.LocationLatitude = Convert.ToDecimal(reader["LocationLatitude"]); } if (reader["ConferenceDomain"] != DBNull.Value) { _conferencesLanguage.ConferenceDomain = Convert.ToString(reader["ConferenceDomain"]); } if (reader["ConferenceParentId"] != DBNull.Value) { _conferencesLanguage.ConferenceParentId = Convert.ToInt32(reader["ConferenceParentId"]); } if (reader["LanguageID"] != DBNull.Value) { _conferencesLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); } _conferencesLanguage.NewRecord = false; _conferencesLanguageList.Add(_conferencesLanguage); } reader.Close(); return(_conferencesLanguageList); }