public List<ConferenceMainImages> GetAllByConferenceIdandLanguageId(int ConferenceId,int LanguageId) { ConferenceMainImagesDAC _conferenceMainImagesComponent = new ConferenceMainImagesDAC(); IDataReader reader = _conferenceMainImagesComponent.GetAllConferenceMainImages(String.Format("ConferenceId = {0} AND LanguageId = {1}", ConferenceId, LanguageId)).CreateDataReader(); List<ConferenceMainImages> _conferenceMainImagesList = new List<ConferenceMainImages>(); while (reader.Read()) { if (_conferenceMainImagesList == null) _conferenceMainImagesList = new List<ConferenceMainImages>(); ConferenceMainImages _conferenceMainImages = new ConferenceMainImages(); if (reader["ConferenceMainImageId"] != DBNull.Value) _conferenceMainImages.ConferenceMainImageId = Convert.ToInt32(reader["ConferenceMainImageId"]); if (reader["PhotoPath"] != DBNull.Value) _conferenceMainImages.PhotoPath = Convert.ToString(reader["PhotoPath"]); if (reader["ConferenceId"] != DBNull.Value) _conferenceMainImages.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); if (reader["LanguageId"] != DBNull.Value) _conferenceMainImages.LanguageId = Convert.ToInt32(reader["LanguageId"]); if (reader["PhotoLink"] != DBNull.Value) _conferenceMainImages.PhotoLink = Convert.ToString(reader["PhotoLink"]); if (reader["PhotoTitle"] != DBNull.Value) _conferenceMainImages.PhotoTitle = Convert.ToString(reader["PhotoTitle"]); if (reader["PhotoDescription"] != DBNull.Value) _conferenceMainImages.PhotoDescription = Convert.ToString(reader["PhotoDescription"]); _conferenceMainImages.NewRecord = false; _conferenceMainImagesList.Add(_conferenceMainImages); } reader.Close(); return _conferenceMainImagesList; }
public ConferenceMainImages GetByID(int _conferenceMainImageId) { ConferenceMainImagesDAC _conferenceMainImagesComponent = new ConferenceMainImagesDAC(); IDataReader reader = _conferenceMainImagesComponent.GetByIDConferenceMainImages(_conferenceMainImageId); ConferenceMainImages _conferenceMainImages = null; while(reader.Read()) { _conferenceMainImages = new ConferenceMainImages(); if(reader["ConferenceMainImageId"] != DBNull.Value) _conferenceMainImages.ConferenceMainImageId = Convert.ToInt32(reader["ConferenceMainImageId"]); if(reader["PhotoPath"] != DBNull.Value) _conferenceMainImages.PhotoPath = Convert.ToString(reader["PhotoPath"]); if(reader["ConferenceId"] != DBNull.Value) _conferenceMainImages.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); if(reader["LanguageId"] != DBNull.Value) _conferenceMainImages.LanguageId = Convert.ToInt32(reader["LanguageId"]); if(reader["PhotoLink"] != DBNull.Value) _conferenceMainImages.PhotoLink = Convert.ToString(reader["PhotoLink"]); if(reader["PhotoTitle"] != DBNull.Value) _conferenceMainImages.PhotoTitle = Convert.ToString(reader["PhotoTitle"]); if(reader["PhotoDescription"] != DBNull.Value) _conferenceMainImages.PhotoDescription = Convert.ToString(reader["PhotoDescription"]); _conferenceMainImages.NewRecord = false; } reader.Close(); return _conferenceMainImages; }
public bool Update(ConferenceMainImages conferencemainimages ,int old_conferenceMainImageId) { ConferenceMainImagesDAC conferencemainimagesComponent = new ConferenceMainImagesDAC(); return conferencemainimagesComponent.UpdateConferenceMainImages( conferencemainimages.PhotoPath, conferencemainimages.ConferenceId, conferencemainimages.LanguageId, conferencemainimages.PhotoLink, conferencemainimages.PhotoTitle, conferencemainimages.PhotoDescription, old_conferenceMainImageId); }
public bool Insert(ConferenceMainImages conferencemainimages) { int autonumber = 0; ConferenceMainImagesDAC conferencemainimagesComponent = new ConferenceMainImagesDAC(); bool endedSuccessfuly = conferencemainimagesComponent.InsertNewConferenceMainImages( ref autonumber, conferencemainimages.PhotoPath, conferencemainimages.ConferenceId, conferencemainimages.LanguageId, conferencemainimages.PhotoLink, conferencemainimages.PhotoTitle, conferencemainimages.PhotoDescription); if(endedSuccessfuly) { conferencemainimages.ConferenceMainImageId = autonumber; } return endedSuccessfuly; }