public List<MediaSource> GetAll()
{
MediaSourceDAC _mediaSourceComponent = new MediaSourceDAC();
IDataReader reader = _mediaSourceComponent.GetAllMediaSource().CreateDataReader();
List<MediaSource> _mediaSourceList = new List<MediaSource>();
while(reader.Read())
{
if(_mediaSourceList == null)
_mediaSourceList = new List<MediaSource>();
MediaSource _mediaSource = new MediaSource();
if(reader["MediaSourceID"] != DBNull.Value)
_mediaSource.MediaSourceID = Convert.ToInt32(reader["MediaSourceID"]);
if(reader["Name"] != DBNull.Value)
_mediaSource.Name = Convert.ToString(reader["Name"]);
if(reader["Site"] != DBNull.Value)
_mediaSource.Site = Convert.ToString(reader["Site"]);
if(reader["Rss"] != DBNull.Value)
_mediaSource.Rss = Convert.ToString(reader["Rss"]);
if(reader["PrivateUrl"] != DBNull.Value)
_mediaSource.PrivateUrl = Convert.ToString(reader["PrivateUrl"]);
_mediaSource.NewRecord = false;
_mediaSourceList.Add(_mediaSource);
} reader.Close();
return _mediaSourceList;
}
public bool Insert(MediaSource mediasource)
{
int autonumber = 0;
MediaSourceDAC mediasourceComponent = new MediaSourceDAC();
bool endedSuccessfuly = mediasourceComponent.InsertNewMediaSource( ref autonumber, mediasource.Name, mediasource.Site, mediasource.Rss, mediasource.PrivateUrl);
if(endedSuccessfuly)
{
mediasource.MediaSourceID = autonumber;
}
return endedSuccessfuly;
}
public MediaSource GetByID(int _mediaSourceID)
{
MediaSourceDAC _mediaSourceComponent = new MediaSourceDAC();
IDataReader reader = _mediaSourceComponent.GetByIDMediaSource(_mediaSourceID);
MediaSource _mediaSource = null;
while(reader.Read())
{
_mediaSource = new MediaSource();
if(reader["MediaSourceID"] != DBNull.Value)
_mediaSource.MediaSourceID = Convert.ToInt32(reader["MediaSourceID"]);
if(reader["Name"] != DBNull.Value)
_mediaSource.Name = Convert.ToString(reader["Name"]);
if(reader["Site"] != DBNull.Value)
_mediaSource.Site = Convert.ToString(reader["Site"]);
if(reader["Rss"] != DBNull.Value)
_mediaSource.Rss = Convert.ToString(reader["Rss"]);
if(reader["PrivateUrl"] != DBNull.Value)
_mediaSource.PrivateUrl = Convert.ToString(reader["PrivateUrl"]);
_mediaSource.NewRecord = false; } reader.Close();
return _mediaSource;
}
public bool Update(MediaSource mediasource ,int old_mediaSourceID)
{
MediaSourceDAC mediasourceComponent = new MediaSourceDAC();
return mediasourceComponent.UpdateMediaSource( mediasource.Name, mediasource.Site, mediasource.Rss, mediasource.PrivateUrl, old_mediaSourceID);
}
