public static int Add(Article article)
{
if (article.ParentObjectID > 0)
{
Article article2 = GetArticle(article.ParentObjectID, article.LanguageID);
if (article2 != null)
throw new Exception("Article is exists in the same language, please choose another language");
}
return ArticleDataMapper.Add(article);
}
internal static void FillFromReader(Article article, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_ARTICLE_CATEGORY_ID);
if (!reader.IsDBNull(colIndex))
article.CategoryID = reader.GetInt32(colIndex);
int days = 0, seconds = 0;
colIndex = reader.GetOrdinal(CN_ARTICLE_CREATION_DAY);
if (!reader.IsDBNull(colIndex))
days = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_CREATION_SEC);
if (!reader.IsDBNull(colIndex))
seconds = reader.GetInt32(colIndex);
article.CreationDate = CMSCoreHelper.GetDateTime(days, seconds);
colIndex = reader.GetOrdinal(CN_ARTICLE_DESCRIPTION);
if (!reader.IsDBNull(colIndex))
article.Description = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_DETAILS);
if (!reader.IsDBNull(colIndex))
article.Details = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_ID);
if (!reader.IsDBNull(colIndex))
article.ID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_IMAGE);
if (!reader.IsDBNull(colIndex))
article.Image = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_IS_DELETED);
if (!reader.IsDBNull(colIndex))
article.IsDeleted = reader.GetBoolean(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_KEYWORDS);
if (!reader.IsDBNull(colIndex))
article.KeyWords = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_LANGUAGE_ID);
if (!reader.IsDBNull(colIndex))
article.LanguageID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_NAME);
if (!reader.IsDBNull(colIndex))
article.Name = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_SUMMARY);
if (!reader.IsDBNull(colIndex))
article.Summary = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_PORTAL_ID);
if (!reader.IsDBNull(colIndex))
article.PortalID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_SEO_NAME);
if (!reader.IsDBNull(colIndex))
article.SEOName = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_URL);
if (!reader.IsDBNull(colIndex))
article.URL = reader.GetString(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_TYPE);
if (!reader.IsDBNull(colIndex))
article.ArticleType = (CMSEnums.ArticleType)reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_ORDER);
if (!reader.IsDBNull(colIndex))
article.Order = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_CREATED_BY);
if (!reader.IsDBNull(colIndex))
article.CreatedBy = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_PARENT_OBJ_ID);
if (!reader.IsDBNull(colIndex))
article.ParentObjectID = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(CN_ARTICLE_VIEW_COUNT);
if (!reader.IsDBNull(colIndex))
article.ViewCount = reader.GetInt32(colIndex);
colIndex = reader.GetOrdinal(PublishDataMapper.CN_PUBLISH_TYPE_ID);
if (!reader.IsDBNull(colIndex))
article.IsPublished = reader.GetInt32(colIndex) == (int)CMSEnums.PublishType.PublishNow;
}
internal static Article GetArticle(List<Article> articles, SqlDataReader reader)
{
int colIndex = 0;
colIndex = reader.GetOrdinal(CN_ARTICLE_ID);
int value = reader.GetInt32(colIndex);
Article article = articles.Where(c => c.ID == value).FirstOrDefault();
if (article == null)
{
article = new Article();
articles.Add(article);
}
return article;
}
internal static Article GetArticle(int articleParentObjID, int languageID)
{
Article article = null;
using (SqlConnection sqlConnection = new SqlConnection(CMSCoreBase.CMSCoreConnectionString))
{
SqlCommand sqlCommand = new SqlCommand(SN_ARTICLE_GET_BY_PARENT_OBJ_ID, sqlConnection);
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter sqlParameter = null;
sqlParameter = new SqlParameter(PN_ARTICLE_PARENT_OBJ_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = articleParentObjID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PN_ARTICLE_LANGUAGE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = languageID;
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter(PublishDataMapper.PN_PUBLISH_MODULE_ID, System.Data.SqlDbType.Int);
sqlParameter.Direction = System.Data.ParameterDirection.Input;
sqlParameter.Value = (int)CMSEnums.Modules.Article;
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.Connection.Open();
using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection))
{
while (sqlDataReader.Read())
{
if (article == null)
article = new Article();
FillFromReader(article, sqlDataReader);
}
sqlDataReader.Close();
sqlCommand.Connection.Close();
}
}
return article;
}
public static void Update(Article article)
{
ArticleDataMapper.Update(article);
}