public List<ContentModuleArticle> GetAllByHomePageID(int HomePageID)
{
ContentModuleArticleDAC _contentModuleArticleComponent = new ContentModuleArticleDAC();
IDataReader reader = _contentModuleArticleComponent.GetAllContentModuleArticle("HomePageID = " + HomePageID).CreateDataReader();
List<ContentModuleArticle> _contentModuleArticleList = new List<ContentModuleArticle>();
while (reader.Read())
{
if (_contentModuleArticleList == null)
_contentModuleArticleList = new List<ContentModuleArticle>();
ContentModuleArticle _contentModuleArticle = new ContentModuleArticle();
if (reader["ContentModuleArticleID"] != DBNull.Value)
_contentModuleArticle.ContentModuleArticleID = Convert.ToInt32(reader["ContentModuleArticleID"]);
if (reader["HomePageID"] != DBNull.Value)
_contentModuleArticle.HomePageID = Convert.ToInt32(reader["HomePageID"]);
if (reader["ArticleID"] != DBNull.Value)
_contentModuleArticle.ArticleID = Convert.ToInt32(reader["ArticleID"]);
if (reader["ArticleOrder"] != DBNull.Value)
_contentModuleArticle.ArticleOrder = Convert.ToInt32(reader["ArticleOrder"]);
if (reader["ArticleName"] != DBNull.Value)
_contentModuleArticle.ArticleName = Convert.ToString(reader["ArticleName"]);
_contentModuleArticle.NewRecord = false;
_contentModuleArticleList.Add(_contentModuleArticle);
} reader.Close();
return _contentModuleArticleList;
}
public bool Insert(ContentModuleArticle contentmodulearticle)
{
int autonumber = 0;
ContentModuleArticleDAC contentmodulearticleComponent = new ContentModuleArticleDAC();
bool endedSuccessfuly = contentmodulearticleComponent.InsertNewContentModuleArticle( ref autonumber, contentmodulearticle.HomePageID, contentmodulearticle.ArticleID, contentmodulearticle.ArticleOrder);
if(endedSuccessfuly)
{
contentmodulearticle.ContentModuleArticleID = autonumber;
}
return endedSuccessfuly;
}
public bool Update(ContentModuleArticle contentmodulearticle ,int old_contentModuleArticleID)
{
ContentModuleArticleDAC contentmodulearticleComponent = new ContentModuleArticleDAC();
return contentmodulearticleComponent.UpdateContentModuleArticle( contentmodulearticle.HomePageID, contentmodulearticle.ArticleID, contentmodulearticle.ArticleOrder, old_contentModuleArticleID);
}
public ContentModuleArticle GetByID(int _contentModuleArticleID)
{
ContentModuleArticleDAC _contentModuleArticleComponent = new ContentModuleArticleDAC();
IDataReader reader = _contentModuleArticleComponent.GetByIDContentModuleArticle(_contentModuleArticleID);
ContentModuleArticle _contentModuleArticle = null;
while(reader.Read())
{
_contentModuleArticle = new ContentModuleArticle();
if(reader["ContentModuleArticleID"] != DBNull.Value)
_contentModuleArticle.ContentModuleArticleID = Convert.ToInt32(reader["ContentModuleArticleID"]);
if(reader["HomePageID"] != DBNull.Value)
_contentModuleArticle.HomePageID = Convert.ToInt32(reader["HomePageID"]);
if(reader["ArticleID"] != DBNull.Value)
_contentModuleArticle.ArticleID = Convert.ToInt32(reader["ArticleID"]);
if(reader["ArticleOrder"] != DBNull.Value)
_contentModuleArticle.ArticleOrder = Convert.ToInt32(reader["ArticleOrder"]);
_contentModuleArticle.NewRecord = false; } reader.Close();
return _contentModuleArticle;
}