public static int InsertArticleItem(int CategoryID, int ArticleID, string Subject, string Reply, ArticleItemStatus status, int UserID, string NickName)
{
SqlConnection conn = CARETTA.DBI.DBHelper.getConnection();
conn.Open();
SqlTransaction Tran = conn.BeginTransaction(IsolationLevel.Serializable);
int ArticleItemID;
try
{
DateTime CreateDate = DateTime.Now;
string LastPost = LastPostTemplate.Replace("||MemberID||", UserID.ToString()).Replace("||NickName||", NickName).Replace("||Date||", CreateDate.ToShortDateString() + " " + CreateDate.ToShortTimeString());
ForumArticleItems mArticleItem = new ForumArticleItems();
mArticleItem.ArticleID = ArticleID;
mArticleItem.CreateDate = CreateDate;
mArticleItem.CreatedBy = UserID;
mArticleItem.Reply = Reply;
mArticleItem.Score = 0;
mArticleItem.ScoreCount = 0;
mArticleItem.Status = (int)status;
mArticleItem.Subject = Subject;
mArticleItem.Save();
ArticleItemID = mArticleItem.ArticleItemID;
ForumArticle mArticle = new ForumArticle();
mArticle.Load(ArticleID);
mArticle.LastPost = LastPost;
mArticle.LastPostDate = CreateDate;
mArticle.Replies += 1;
mArticle.Save();
ForumCategory mCategory = new ForumCategory();
mCategory.Load(CategoryID);
mCategory.LastPost = LastPost;
mCategory.LastPostDate = CreateDate;
mCategory.Save();
Tran.Commit();
}
catch (Exception ex)
{
Tran.Rollback();
throw;
}
finally
{
conn.Close();
}
return(ArticleItemID);
}
public static void UpdateCategory(int CategoryID, string CategoryName, string CategoryDesc, CategoryStatus status)
{
ForumCategory mCategory = new ForumCategory();
mCategory.Load(CategoryID);
mCategory.CategoryName = CategoryName;
mCategory.CategoryDesc = CategoryDesc;
mCategory.CategoryStatus = (int)status;
mCategory.Save();
}
public static int InsertCategory(string CategoryName, string CategoryDesc, CategoryStatus status, int UserID)
{
ForumCategory mCategory = new ForumCategory();
mCategory.CategoryName = CategoryName;
mCategory.CategoryDesc = CategoryDesc;
mCategory.CategoryStatus = (int)status;
mCategory.CreateDate = DateTime.Now;
mCategory.LastPost = "Yazý yok ...";
mCategory.CreatedBy = UserID;
mCategory.ArticlesCount = 0;
mCategory.Save();
return(mCategory.CategoryID);
}
