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