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