///<summary>Save the article, checks if we are creating new, or updating an existing
///</summary>
///<param name="a"></param>
///<param name="tabId"></param>
///<returns></returns>
public static int SaveArticle(Article a, int tabId)
{
if (a.ArticleId < 1)
{
a.ArticleId = DataProvider.Instance().AddArticle(a);
var cntTaxonomy = new Taxonomy.Content();
var objContentItem = cntTaxonomy.CreateContentItem(a, tabId);
a.ContentItemId = objContentItem.ContentItemId;
SaveArticle(a, tabId);
}
else
{
DataProvider.Instance().UpdateArticle(a);
var cntTaxonomy = new Taxonomy.Content();
cntTaxonomy.UpdateContentItem(a, tabId);
}
return a.ArticleId;
}
/// -----------------------------------------------------------------------------
/// <summary>
/// ImportModule implements the IPortable ImportModule Interface
/// </summary>
/// <param name="moduleId">The Id of the module to be imported</param>
/// <param name="content">The content to be imported</param>
/// <param name="version">The version of the module to be imported</param>
/// <param name="userId">The Id of the user performing the import</param>
/// -----------------------------------------------------------------------------
public void ImportModule(int moduleId, string content, string version, int userId)
{
var mc = new ModuleController();
var mi = mc.GetModule(moduleId);
XmlNode xmldnnsimplearticles = Common.Globals.GetContent(content, "articles");
if (xmldnnsimplearticles != null)
// ReSharper disable PossibleNullReferenceException
foreach (XmlNode xmldnnsimplearticle in xmldnnsimplearticles.SelectNodes("article"))
// ReSharper restore PossibleNullReferenceException
{
var objdnnsimplearticle = new Article
{
ModuleId = moduleId,
Title = xmldnnsimplearticle.SelectSingleNode("title").InnerText,
Description =
xmldnnsimplearticle.SelectSingleNode("description").InnerText,
Body = xmldnnsimplearticle.SelectSingleNode("body").InnerText,
CreatedByUserId = userId,
CreatedOnDate = DateTime.Now,
LastModifiedByUserId = userId,
LastModifiedOnDate = DateTime.Now
};
objdnnsimplearticle.Save(mi.TabID);
}
}
public override void UpdateArticle(Article a)
{
SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, NamePrefix + "spUpdateArticle"
, new SqlParameter("@ArticleId", a.ArticleId)
, new SqlParameter("@ModuleId", a.ModuleId)
, new SqlParameter("@Title", a.Title)
, new SqlParameter("@Description", a.Description)
, new SqlParameter("@Body", a.Body)
, new SqlParameter("@LastModifiedOnDate", a.LastModifiedOnDate)
, new SqlParameter("@LastModifiedByUserId", a.LastModifiedByUserId)
, new SqlParameter("@ContentItemId", a.ContentItemId)
);
}
public override int AddArticle(Article a)
{
return Convert.ToInt32(SqlHelper.ExecuteScalar(ConnectionString, CommandType.StoredProcedure, NamePrefix + "spAddArticle"
, new SqlParameter("@ModuleId", a.ModuleId)
, new SqlParameter("@Title", a.Title)
, new SqlParameter("@Description", a.Description)
, new SqlParameter("@Body", a.Body)
, new SqlParameter("@CreatedOnDate", a.CreatedOnDate)
, new SqlParameter("@CreatedByUserId", a.CreatedByUserId)
, new SqlParameter("@LastModifiedOnDate", a.LastModifiedOnDate)
, new SqlParameter("@LastModifiedByUserId", a.LastModifiedByUserId)
));
}
///<summary> /// The add article astract ///</summary> ///<param name="a"></param> ///<returns></returns> public abstract int AddArticle(Article a);
///<summary> /// Updating an article ///</summary> ///<param name="a"></param> public abstract void UpdateArticle(Article a);
