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