public static void UpdateArticleStatus(int ArticleID, ArticleStatus status) { ForumArticle mArticle = new ForumArticle(); mArticle.Load(ArticleID); mArticle.ArticleStatus = (int)status; mArticle.Save(); }
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 ArticleStatus GetArticleStatus(int ArticleID) { ForumArticle mArticle = new ForumArticle(); if (mArticle.Load(ArticleID)) { return((ArticleStatus)mArticle.ArticleStatus); } return(ArticleStatus.Active); }
public static void UpdateArticleItem(int ArticleItemID, int ArticleID, string Subject, string Reply, ArticleItemStatus status) { SqlConnection conn = CARETTA.DBI.DBHelper.getConnection(); conn.Open(); SqlTransaction Tran = conn.BeginTransaction(IsolationLevel.Serializable); try { ForumArticleItems mArticleItem = new ForumArticleItems(); mArticleItem.Load(ArticleItemID); bool StatusChanged = false; if (mArticleItem.Status != (int)status) { StatusChanged = true; } mArticleItem.Reply = Reply; mArticleItem.Status = (int)status; mArticleItem.Subject = Subject; mArticleItem.Save(); ForumArticle mArticle = new ForumArticle(); mArticle.Load(ArticleID); mArticle.ArticleMessage = Reply; mArticle.ArticleSubject = Subject; mArticle.Save(); if (StatusChanged) { ForumArticle.ArrangeArticle(mArticleItem.ArticleID); } Tran.Commit(); } catch (Exception ex) { Tran.Rollback(); throw; } finally { conn.Close(); } }
public static void UpdateArticle(int ArticleID, string Subject, string Message, ArticleStatus status, int CategoryID) { SqlConnection conn = CARETTA.DBI.DBHelper.getConnection(); conn.Open(); SqlTransaction Tran = conn.BeginTransaction(IsolationLevel.Serializable); try { ForumArticle mArticle = new ForumArticle(); if (mArticle.Load(ArticleID)) { bool CategoryChanged = false; int OldCategoryID = 0; if (mArticle.CategoryID != CategoryID) { CategoryChanged = true; OldCategoryID = mArticle.CategoryID; } bool StatusChanged = false; if (mArticle.ArticleStatus != (int)status) { StatusChanged = true; } bool SyncNeeded = false; if (mArticle.ArticleSubject != Subject || mArticle.ArticleMessage != Message) { SyncNeeded = true; } mArticle.ArticleSubject = Subject; mArticle.ArticleMessage = Message; mArticle.ArticleStatus = (int)status; mArticle.CategoryID = CategoryID; mArticle.Save(); if (CategoryChanged) { ForumArticle.CategoryChange(OldCategoryID, CategoryID); } if (SyncNeeded) { ForumArticle.SyncMainItem(ArticleID, Subject, Message); } if (StatusChanged && (!CategoryChanged)) { ForumCategory.ArrangeCategory(CategoryID); } Tran.Commit(); } } catch (Exception ex) { Tran.Rollback(); throw; } finally { conn.Close(); } }