public List <ConferenceMediaReference> GetAll(int ConferenceId, int LanguageId)
{
ConferenceMediaReferenceDAC _conferenceMediaReferenceComponent = new ConferenceMediaReferenceDAC();
IDataReader reader = _conferenceMediaReferenceComponent.GetAllConferenceMediaReference(string.Format("ConferenceId = {0} and LanguageId = {1}", ConferenceId, LanguageId)).CreateDataReader();
List <ConferenceMediaReference> _conferenceMediaReferenceList = new List <ConferenceMediaReference>();
while (reader.Read())
{
if (_conferenceMediaReferenceList == null)
{
_conferenceMediaReferenceList = new List <ConferenceMediaReference>();
}
ConferenceMediaReference _conferenceMediaReference = new ConferenceMediaReference();
if (reader["ConferenceMediaReferenceId"] != DBNull.Value)
{
_conferenceMediaReference.ConferenceMediaReferenceId = Convert.ToInt32(reader["ConferenceMediaReferenceId"]);
}
if (reader["ConferenceId"] != DBNull.Value)
{
_conferenceMediaReference.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
}
if (reader["LanguageId"] != DBNull.Value)
{
_conferenceMediaReference.LanguageId = Convert.ToInt32(reader["LanguageId"]);
}
if (reader["ReferenceOrder"] != DBNull.Value)
{
_conferenceMediaReference.ReferenceOrder = Convert.ToInt32(reader["ReferenceOrder"]);
}
if (reader["Title"] != DBNull.Value)
{
_conferenceMediaReference.Title = Convert.ToString(reader["Title"]);
}
if (reader["ReferenceUrl"] != DBNull.Value)
{
_conferenceMediaReference.ReferenceUrl = Convert.ToString(reader["ReferenceUrl"]);
}
if (reader["ReferenceName"] != DBNull.Value)
{
_conferenceMediaReference.ReferenceName = Convert.ToString(reader["ReferenceName"]);
}
if (reader["ReferenceLogo"] != DBNull.Value)
{
_conferenceMediaReference.ReferenceLogo = Convert.ToString(reader["ReferenceLogo"]);
}
if (reader["PublishingDate"] != DBNull.Value)
{
_conferenceMediaReference.PublishingDate = Convert.ToDateTime(reader["PublishingDate"]);
}
_conferenceMediaReference.NewRecord = false;
_conferenceMediaReferenceList.Add(_conferenceMediaReference);
}
reader.Close();
return(_conferenceMediaReferenceList);
}
public bool Insert(ConferenceMediaReference conferencemediareference)
{
int autonumber = 0;
ConferenceMediaReferenceDAC conferencemediareferenceComponent = new ConferenceMediaReferenceDAC();
bool endedSuccessfuly = conferencemediareferenceComponent.InsertNewConferenceMediaReference(ref autonumber, conferencemediareference.ConferenceId, conferencemediareference.LanguageId, conferencemediareference.ReferenceOrder, conferencemediareference.Title, conferencemediareference.ReferenceUrl, conferencemediareference.ReferenceName, conferencemediareference.ReferenceLogo, conferencemediareference.PublishingDate);
if (endedSuccessfuly)
{
conferencemediareference.ConferenceMediaReferenceId = autonumber;
}
return(endedSuccessfuly);
}
public ConferenceMediaReference GetByID(int _conferenceMediaReferenceId)
{
ConferenceMediaReferenceDAC _conferenceMediaReferenceComponent = new ConferenceMediaReferenceDAC();
IDataReader reader = _conferenceMediaReferenceComponent.GetByIDConferenceMediaReference(_conferenceMediaReferenceId);
ConferenceMediaReference _conferenceMediaReference = null;
while (reader.Read())
{
_conferenceMediaReference = new ConferenceMediaReference();
if (reader["ConferenceMediaReferenceId"] != DBNull.Value)
{
_conferenceMediaReference.ConferenceMediaReferenceId = Convert.ToInt32(reader["ConferenceMediaReferenceId"]);
}
if (reader["ConferenceId"] != DBNull.Value)
{
_conferenceMediaReference.ConferenceId = Convert.ToInt32(reader["ConferenceId"]);
}
if (reader["LanguageId"] != DBNull.Value)
{
_conferenceMediaReference.LanguageId = Convert.ToInt32(reader["LanguageId"]);
}
if (reader["ReferenceOrder"] != DBNull.Value)
{
_conferenceMediaReference.ReferenceOrder = Convert.ToInt32(reader["ReferenceOrder"]);
}
if (reader["Title"] != DBNull.Value)
{
_conferenceMediaReference.Title = Convert.ToString(reader["Title"]);
}
if (reader["ReferenceUrl"] != DBNull.Value)
{
_conferenceMediaReference.ReferenceUrl = Convert.ToString(reader["ReferenceUrl"]);
}
if (reader["ReferenceName"] != DBNull.Value)
{
_conferenceMediaReference.ReferenceName = Convert.ToString(reader["ReferenceName"]);
}
if (reader["ReferenceLogo"] != DBNull.Value)
{
_conferenceMediaReference.ReferenceLogo = Convert.ToString(reader["ReferenceLogo"]);
}
if (reader["PublishingDate"] != DBNull.Value)
{
_conferenceMediaReference.PublishingDate = Convert.ToDateTime(reader["PublishingDate"]);
}
_conferenceMediaReference.NewRecord = false;
}
reader.Close();
return(_conferenceMediaReference);
}
public bool Update(ConferenceMediaReference conferencemediareference, int old_conferenceMediaReferenceId)
{
ConferenceMediaReferenceDAC conferencemediareferenceComponent = new ConferenceMediaReferenceDAC();
return(conferencemediareferenceComponent.UpdateConferenceMediaReference(conferencemediareference.ConferenceId, conferencemediareference.LanguageId, conferencemediareference.ReferenceOrder, conferencemediareference.Title, conferencemediareference.ReferenceUrl, conferencemediareference.ReferenceName, conferencemediareference.ReferenceLogo, conferencemediareference.PublishingDate, old_conferenceMediaReferenceId));
}