void Comment_Approved(object sender, EventArgs e) { BSComment bsComment = (BSComment)sender; if (bsComment.Approve) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("PostID", bsComment.PostID); dp.AddParameter("NotifyMe", true); dp.AddParameter("Approve", true); dp.ExecuteReader("SELECT DISTINCT Email FROM Comments WHERE PostID=@PostID AND NotifyMe=@NotifyMe AND Approve=@Approve"); if (dp.Return.Status == DataProcessState.Success) { BSPost bsPost = BSPost.GetPost(bsComment.PostID); using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { string strEmail = (string)dr["Email"]; System.Threading.ThreadPool.QueueUserWorkItem(delegate { BSHelper.SendMail(Language.Get["NewCommentNotice"], Blogsa.Settings["smtp_email"].ToString(), Blogsa.Settings["smtp_name"].ToString() , strEmail, "", Language.Get["NewCommentNoticeDescription"] + "<br><br><a href=\"" + bsPost.Link + "\">" + bsPost.Title + "</a>", true); }); } } } } } }
public static List <BSComment> GetCommentsByUserID(int iUserID, CommentStates state) { List <BSComment> comments = new List <BSComment>(); using (DataProcess dp = new DataProcess()) { if (state == CommentStates.All) { dp.AddParameter("UserID", iUserID); dp.ExecuteReader("SELECT * FROM Comments WHERE [UserID]=@UserID ORDER By CreateDate DESC"); } else { dp.AddParameter("UserID", iUserID); dp.AddParameter("Approve", state == CommentStates.Approved); dp.ExecuteReader("SELECT * FROM Comments WHERE [UserID]=@UserID AND [Approve]=@Approve ORDER By CreateDate DESC"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSComment bsComment = new BSComment(); FillComment(dr, bsComment); comments.Add(bsComment); } } } } return(comments); }
public static List <BSPost> GetPostsByTitle(string title, int iUserId) { List <BSPost> posts = new List <BSPost>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Title", title); if (iUserId == 0) { dp.ExecuteReader("SELECT * FROM [Posts] WHERE [Title] LIKE '%' + @Title + '%' ORDER By [CreateDate] DESC,[Title]"); } else { dp.AddParameter("UserID", iUserId); dp.ExecuteReader("SELECT * FROM [Posts] WHERE [Title] LIKE '%' + @Title + '%' AND [UserID]=@UserID ORDER By [CreateDate] DESC,[Title]"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSPost bsPost = new BSPost(); FillPost(dr, bsPost); posts.Add(bsPost); } } } } return(posts); }
public static List <BSTerm> GetTermsByObjectID(int objectId, TermTypes termType) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("ObjectID", objectId); if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] IN (SELECT TermID FROM TermsTo WHERE [ObjectID]=@ObjectID AND [Type]=@Type) ORDER BY Name"); } else { dp.ExecuteReader("SELECT * FROM Terms WHERE [TermID] IN (SELECT TermID FROM TermsTo WHERE [ObjectID]=@ObjectID) ORDER BY Name"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
public static List <BSTerm> GetTermsBySubID(TermTypes termType, int iSubID) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [Type]=@Type AND [SubID]=@SubID ORDER BY [Name] ASC"); } else { dp.AddParameter("SubID", iSubID); dp.ExecuteReader("SELECT * FROM Terms WHERE [SubID]=@SubID ORDER BY [Name] ASC"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
public static List <BSWidget> GetWidgetsByPlaceHolder(string placeHolder, bool visible) { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("PlaceHolder", placeHolder); dp.AddParameter("Visible", visible); dp.ExecuteReader("SELECT * FROM [Widgets] WHERE [PlaceHolder]=@PlaceHolder AND [Visible]=@Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
void Comment_Approved(object sender, EventArgs e) { BSComment bsComment = (BSComment)sender; if (bsComment.Approve) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("PostID", bsComment.PostID); dp.AddParameter("NotifyMe", true); dp.AddParameter("Approve", true); dp.ExecuteReader("SELECT DISTINCT Email FROM Comments WHERE PostID=@PostID AND NotifyMe=@NotifyMe AND Approve=@Approve"); if (dp.Return.Status == DataProcessState.Success) { BSPost bsPost = BSPost.GetPost(bsComment.PostID); using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { string strEmail = (string)dr["Email"]; System.Threading.ThreadPool.QueueUserWorkItem(delegate { BSHelper.SendMail(Language.Get["NewCommentNotice"], Blogsa.Settings["smtp_email"].ToString(), Blogsa.Settings["smtp_name"].ToString() , strEmail, "", Language.Get["NewCommentNoticeDescription"] + "<br><br><a href=\"" + bsPost.Link + "\">" + bsPost.Title + "</a>", true); }); } } } } } }
public static List <BSPost> GetPosts(PostTypes postType, PostVisibleTypes postVisibleType, FileTypes fileType, int postCount) { List <BSPost> posts = new List <BSPost>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Type", (short)postType); if (postVisibleType != PostVisibleTypes.All) { if (fileType != FileTypes.All) { dp.AddParameter("State", (short)postVisibleType); dp.AddParameter("Show", (short)fileType); dp.ExecuteReader(String.Format("SELECT {0} * FROM Posts WHERE [Type]=@Type AND [State]=@State AND [Show]=@Show ORDER By [CreateDate] DESC,[Title]" , postCount == 0 ? String.Empty : "TOP " + postCount)); } else { dp.AddParameter("State", (short)postVisibleType); dp.ExecuteReader(String.Format("SELECT {0} * FROM Posts WHERE [Type]=@Type AND [State]=@State ORDER By [CreateDate] DESC,[Title]" , postCount == 0 ? String.Empty : "TOP " + postCount)); } } else { if (fileType != FileTypes.All) { dp.AddParameter("Show", (short)fileType); dp.ExecuteReader(String.Format("SELECT {0} * FROM Posts WHERE [Type]=@Type AND [Show]=@Show ORDER By [CreateDate] DESC,[Title]" , postCount == 0 ? String.Empty : "TOP " + postCount)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM Posts WHERE [Type]=@Type ORDER By [CreateDate] DESC,[Title]" , postCount == 0 ? String.Empty : "TOP " + postCount)); } } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSPost bsPost = new BSPost(); FillPost(dr, bsPost); posts.Add(bsPost); } } } } return(posts); }
public bool Save() { DataProcess dp = new DataProcess(); string sql = String.Empty; if (SettingID == 0) { sql = "INSERT INTO Settings([SiteID],[Name],[Value],[Title],[Description],[Main],[Sort],[Visible]) " + "VALUES(@SiteID,@Name,@Value,@Title,@Description,@Main,@Sort,@Visible);"; } else { sql = "UPDATE Settings SET [SiteID]=@SiteID,[Name]=@Name,[Value]=@Value,[Title]=@Title,[Description]=@Description,[Main]=@Main,[Sort]=@Sort,[Visible]=@Visible WHERE [SettingID] = @SettingID;"; } dp.AddParameter("SiteID", this.SiteID); dp.AddParameter("Name", this.Name); dp.AddParameter("Value", this.Value); dp.AddParameter("Title", this.Title); dp.AddParameter("Description", this.Description); dp.AddParameter("Main", this.Main); dp.AddParameter("Sort", this.Sort); dp.AddParameter("Visible", this.Visible); if (SettingID != 0) { dp.AddParameter("SettingID", this.SettingID); } dp.ExecuteNonQuery(sql); return(dp.Return.Status == DataProcessState.Success); }
private void AddObjects() { using (DataProcess dp = new DataProcess()) { string type = Type.ToString().ToLowerInvariant(); foreach (int objectID in Objects) { dp.AddParameter("ObjectID", objectID); dp.AddParameter("TermID", TermID); dp.AddParameter("Type", type); dp.ExecuteNonQuery("INSERT INTO TermsTo([ObjectID],[TermID],[Type]) VALUES(@ObjectID,@TermID,@Type)"); } } }
public static List <BSPost> GetPostsByColumnValue(string column, object value, int postCount, string orderBy, PostTypes postType, PostStates postState) { List <BSPost> posts = new List <BSPost>(); using (DataProcess dp = new DataProcess()) { string top = postCount > 0 ? "TOP " + postCount : String.Empty; if (!String.IsNullOrEmpty(column) && value != null) { dp.AddParameter("Type", (short)postType); dp.AddParameter(column, value); if (postState == PostStates.All) { dp.ExecuteReader(String.Format("SELECT {1} * FROM Posts WHERE [Type]=@Type AND [{0}]=@{0} {2}", column, top, orderBy)); } else { dp.AddParameter("State", (short)postState); dp.ExecuteReader(String.Format("SELECT {1} * FROM Posts WHERE [Type]=@Type AND [{0}]=@{0} AND [State]=@State {2}", column, top, orderBy)); } } else { dp.AddParameter("Type", (short)postType); if (postState == PostStates.All) { dp.ExecuteReader(String.Format("SELECT {0} * FROM Posts WHERE [Type]=@Type {1}", top, orderBy)); } else { dp.AddParameter("State", (short)postState); dp.ExecuteReader(String.Format("SELECT {0} * FROM Posts WHERE [Type]=@Type AND [State]=@State {1}", top, orderBy)); } } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSPost bsPost = new BSPost(); FillPost(dr, bsPost); posts.Add(bsPost); } } } } return(posts); }
public static List <BSComment> GetComments(CommentStates state, int iCommentCount) { List <BSComment> comments = new List <BSComment>(); using (DataProcess dp = new DataProcess()) { string top = iCommentCount == 0 ? String.Empty : "TOP " + iCommentCount; if (state == CommentStates.All) { dp.ExecuteReader(String.Format("SELECT {0} * FROM Comments ORDER By CreateDate DESC", top)); } else { dp.AddParameter("Approve", state == CommentStates.Approved); dp.ExecuteReader(String.Format("SELECT {0} * FROM Comments WHERE [Approve]=@Approve ORDER By CreateDate DESC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSComment bsComment = new BSComment(); FillComment(dr, bsComment); comments.Add(bsComment); } } } } return(comments); }
private static void FillTerm(IDataReader dr, BSTerm bsTerm) { bsTerm.SubID = (int)dr["SubID"]; bsTerm.Name = (string)dr["Name"]; bsTerm.Code = (string)dr["Code"]; bsTerm.Description = dr["Description"].ToString(); string termType = (string)dr["Type"]; bsTerm.Type = GetTermType(termType); bsTerm.TermID = (int)dr["TermID"]; bsTerm.Objects = new List <int>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("TermID", bsTerm.TermID); dp.ExecuteReader("SELECT * FROM TermsTo WHERE [TermID]=@TermID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader drObjects = (IDataReader)dp.Return.Value) while (drObjects.Read()) { bsTerm.Objects.Add((int)drObjects["ObjectID"]); } } } }
public static List <BSTerm> GetTerms(TermTypes termType, int iTermCount) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { string top = iTermCount == 0 ? String.Empty : "TOP " + iTermCount; if (termType != TermTypes.All) { dp.AddParameter("Type", termType.ToString().ToLowerInvariant()); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Type]=@Type ORDER BY [Name] ASC", top)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms ORDER BY [Name] ASC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
public static List <BSWidget> GetWidgetsByColumnValue(string column, object value, int widgetCount, string orderBy) { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { string top = widgetCount > 0 ? "TOP " + widgetCount : String.Empty; if (!String.IsNullOrEmpty(column) && value != null) { dp.AddParameter(column, value); dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] WHERE [{1}]=@{1} {2}", top, column, orderBy)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] {1}", top, orderBy)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
public static List <BSWidget> GetWidgetsBySorted() { List <BSWidget> widgets = new List <BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Visible", true); dp.ExecuteReader("SELECT * FROM Widgets WHERE [Visible] = @Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return(widgets); }
public static int GetReadCounts(int iPostID) { using (DataProcess dp = new DataProcess()) { if (iPostID > 0) { dp.AddParameter("PostID", iPostID); dp.ExecuteScalar("SELECT SUM([ReadCount]) FROM Posts WHERE [PostID] = @PostID"); } else { dp.ExecuteScalar("SELECT SUM([ReadCount]) FROM Posts"); } if (dp.Return.Status == DataProcessState.Success) { if (dp.Return.Value != DBNull.Value) { return(Convert.ToInt32(dp.Return.Value)); } else { return(0); } } } return(0); }
public static BSSetting GetSetting(int iSettingID) { BSSetting bsSetting = new BSSetting(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("SettingID", iSettingID); dp.ExecuteReader("SELECT * FROM Settings WHERE SettingID = @SettingID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr.Read()) { FillValue(dr, bsSetting); return(bsSetting); } } } } return(null); }
public static List <BSSetting> GetThemeSettings(string themeName) { List <BSSetting> _Settings = new List <BSSetting>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Name", themeName); dp.ExecuteReader("SELECT * FROM Settings WHERE Name LIKE @Name + '_%'"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSSetting bsSetting = new BSSetting(); FillValue(dr, bsSetting); _Settings.Add(bsSetting); } } } } return(_Settings); }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { if (this.Default) { dp.AddParameter("Default", false); dp.ExecuteNonQuery("UPDATE [MenuGroups] SET [Default]=@Default"); } dp.AddParameter("SiteID", this.SiteID); dp.AddParameter("Code", this.Code); dp.AddParameter("Description", this.Description); dp.AddParameter("Title", this.Title); dp.AddParameter("Default", this.Default); dp.AddParameter("LanguageCode", this.LanguageCode); if (MenuGroupID != 0) { dp.AddParameter("MenuGroupID", this.MenuGroupID); dp.ExecuteNonQuery("UPDATE [MenuGroups] SET [SiteID]=@SiteID,[Code]=@Code,[Description]=@Description,[Title]=@Title,[Default]=@Default,[LanguageCode]=@LanguageCode WHERE [MenuGroupID] = @MenuGroupID"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { foreach (BSMenu bsMenu in Menu) { bsMenu.Save(); } } } else { dp.ExecuteNonQuery("INSERT INTO [MenuGroups]([SiteID],[Code],[Description],[Title],[Default],[LanguageCode]) VALUES(@SiteID,@Code,@Description,@Title,@Default,@LanguageCode)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { foreach (BSMenu bsMenu in Menu) { bsMenu.Save(); } dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { MenuGroupID = Convert.ToInt32(dp.Return.Value); } } } } return(bReturnValue); }
public bool Save() { using (DataProcess dp = new DataProcess()) { dp.AddParameter("SiteID", SiteID); dp.AddParameter("Name", Name); dp.AddParameter("Description", Description); dp.AddParameter("Target", Target); dp.AddParameter("Url", Url); dp.AddParameter("LanguageCode", LanguageCode); if (LinkID != 0) { dp.AddParameter("LinkID", LinkID); dp.ExecuteNonQuery( "UPDATE Links SET [SiteID]=@SiteID,[Name]=@Name,[Description]=@Description,[Target]=@Target,[Url]=@Url,[LanguageCode]=@LanguageCode WHERE [LinkID]=@LinkID"); return(dp.Return.Status == DataProcessState.Success); } else { dp.ExecuteNonQuery("INSERT INTO Links([SiteID],[Name],[Description],[Target],[Url],[LanguageCode]) VALUES(@SiteID,@Name,@Description,@Target,@Url,@LanguageCode)"); if (dp.Return.Status == DataProcessState.Success) { dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { LinkID = Convert.ToInt32(dp.Return.Value); } return(true); } } } return(false); }
public static bool ValidateUser(string userName, string password) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("UserName", userName); dp.AddParameter("Password", password); dp.ExecuteReader("SELECT * FROM Users WHERE [UserName]=@UserName AND [Password]=@Password"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { return(dr != null && dr.Read()); } } } return(false); }
public static List <BSPost> GetPostsByTerm(int termId, string code, TermTypes termType, PostTypes postType, PostStates postState) { List <BSPost> posts = new List <BSPost>(); using (DataProcess dp = new DataProcess()) { BSTerm bsTerm = null; bsTerm = termId != 0 ? BSTerm.GetTerm(termId) : BSTerm.GetTerm(code, termType); if (bsTerm != null) { dp.AddParameter("TermID", bsTerm.TermID); if (postState != PostStates.All) { dp.AddParameter("State", (short)postState); dp.ExecuteReader("SELECT * FROM Posts WHERE [PostID] IN (SELECT [ObjectID] FROM TermsTo WHERE [TermID]=@TermID) AND [State]=@State ORDER By [CreateDate] DESC"); } else { dp.ExecuteReader("SELECT * FROM Posts WHERE [PostID] IN (SELECT [ObjectID] FROM TermsTo WHERE [TermID]=@TermID) AND [Type]=@Type ORDER By [CreateDate] DESC"); } } else { return(posts); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSPost bsPost = new BSPost(); FillPost(dr, bsPost); posts.Add(bsPost); } } } } return(posts); }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { dp.AddParameter("SiteID", this.SiteID); dp.AddParameter("Description", this.Description); dp.AddParameter("FolderName", this.FolderName); dp.AddParameter("PlaceHolder", this.PlaceHolder); dp.AddParameter("Sort", this.Sort); dp.AddParameter("Title", this.Title); dp.AddParameter("Visible", this.Visible); dp.AddParameter("Type", this.Type); dp.AddParameter("LanguageCode", this.LanguageCode); if (WidgetID != 0) { dp.AddParameter("WidgetID", WidgetID); dp.ExecuteNonQuery("UPDATE Widgets SET [SiteID]=@SiteID,[Description]=@Description,[FolderName]=@FolderName,[PlaceHolder]=@PlaceHolder,[Sort]=@Sort," + "[Title]=@Title,[Visible]=@Visible,[Type]=@Type,[LanguageCode]=@LanguageCode WHERE [WidgetID] = @WidgetID"); bReturnValue = dp.Return.Status == DataProcessState.Success; } else { dp.ExecuteNonQuery("INSERT INTO Widgets([SiteID],[Description],[FolderName],[PlaceHolder],[Sort],[Title],[Visible],[Type],[LanguageCode]) " + "VALUES(@SiteID,@Description,@FolderName,@PlaceHolder,@Sort,@Title,@Visible,@Type,@LanguageCode)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { WidgetID = Convert.ToInt32(dp.Return.Value); } } } } return(bReturnValue); }
protected void Page_Load(object sender, EventArgs e) { try { List <BSPost> posts = new List <BSPost>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("PostID", BSPost.CurrentPost.PostID); dp.AddParameter("Title", BSPost.CurrentPost.Title); dp.ExecuteReader("SELECT TOP 5 * FROM Posts WHERE [PostID]<>@PostID AND [Type]=0 AND [State]=1 AND ([Title] Like '%'+@Title+'%' OR Content Like '%'+@Title+'%') ORDER BY [CreateDate] DESC"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSPost bsPost = new BSPost(); BSPost.FillPost(dr, bsPost); posts.Add(bsPost); } } } } if (posts.Count > 0) { rpRelatedPosts.DataSource = posts; rpRelatedPosts.DataBind(); } else { this.Visible = false; } } catch (System.Exception ex) { } }
public bool Remove() { using (DataProcess dp = new DataProcess()) { CancelEventArgs cancelEvent = new CancelEventArgs(); OnDeleting(this, cancelEvent); if (!cancelEvent.Cancel) { dp.AddParameter("TermID", TermID); dp.ExecuteNonQuery("DELETE FROM Terms WHERE [TermID] = @TermID"); dp.AddParameter("TermID", TermID); dp.ExecuteNonQuery("DELETE FROM TermsTo WHERE [TermID] = @TermID"); if (dp.Return.Status == DataProcessState.Success) { OnDeleted(this, null); return(true); } } } return(false); }
public static BSUser GetUser(string userName, string password) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("UserName", userName); dp.AddParameter("Password", password); dp.ExecuteReader("SELECT * FROM Users WHERE [UserName]=@UserName AND [Password]=@Password"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSUser user = new BSUser(); FillUser(dr, user); return(user); } } } } return(null); }
public static string GetWidgetState(string FolderName) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("FolderName", FolderName); dp.ExecuteScalar("SELECT WidgetID FROM Widgets WHERE FolderName = @FolderName"); if (dp.Return.Status == DataProcessState.Success) return (string)dp.Return.Value; else return string.Empty; } }
public static List <BSTerm> GetTermsByContainsName(string name, TermTypes termType, int iTermCount) { List <BSTerm> terms = new List <BSTerm>(); using (DataProcess dp = new DataProcess()) { string top = iTermCount == 0 ? String.Empty : "TOP " + iTermCount; if (termType != TermTypes.All) { string type = termType == TermTypes.Category ? "category" : "tag"; dp.AddParameter("Type", type); dp.AddParameter("Name", name); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Type]=@Type AND [Name] LIKE '%' + @Name + '%' ORDER BY [Name] ASC", top)); } else { dp.AddParameter("Name", name); dp.ExecuteReader(String.Format("SELECT {0} * FROM Terms WHERE [Name] LIKE '%' + @Name + '%' ORDER BY [Name] ASC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSTerm bsTerm = new BSTerm(); FillTerm(dr, bsTerm); terms.Add(bsTerm); } } } } return(terms); }
protected void Page_Load(object sender, EventArgs e) { try { List<BSPost> posts = new List<BSPost>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("PostID", BSPost.CurrentPost.PostID); dp.AddParameter("Title", BSPost.CurrentPost.Title); dp.ExecuteReader("SELECT TOP 5 * FROM Posts WHERE [PostID]<>@PostID AND [Type]=0 AND [State]=1 AND ([Title] Like '%'+@Title+'%' OR Content Like '%'+@Title+'%') ORDER BY [CreateDate] DESC"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSPost bsPost = new BSPost(); BSPost.FillPost(dr, bsPost); posts.Add(bsPost); } } } } if (posts.Count > 0) { rpRelatedPosts.DataSource = posts; rpRelatedPosts.DataBind(); } else this.Visible = false; } catch (System.Exception ex) { } }
public static bool RemoveTo(TermTypes termType, int iObjectID) { using (DataProcess dp = new DataProcess()) { if (termType == TermTypes.All) { dp.AddParameter("ObjectID", iObjectID); dp.ExecuteNonQuery("DELETE FROM TermsTo WHERE [ObjectID]=@ObjectID"); } else { dp.AddParameter("Type", termType == TermTypes.Category ? "category" : "tag"); dp.AddParameter("ObjectID", iObjectID); dp.ExecuteNonQuery("DELETE FROM TermsTo WHERE [Type]=@Type AND [ObjectID]=@ObjectID"); } if (dp.Return.Status == DataProcessState.Success) { return(true); } } return(false); }
public bool DoApprove(bool bApprove) { CancelEventArgs eventArgs = new CancelEventArgs(); BSComment bsComment = GetComment(CommentID); OnApproving(bsComment, eventArgs); if (!eventArgs.Cancel) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("Approve", bApprove); dp.AddParameter("CommentID", CommentID); dp.ExecuteNonQuery("UPDATE Comments SET [Approve]=@Approve WHERE [CommentID]=@CommentID"); if (dp.Return.Status == DataProcessState.Success) { bsComment.Approve = bApprove; OnApproved(bsComment, null); return(true); } } } return(false); }
protected void Page_Load(object sender, EventArgs e) { if (String.IsNullOrEmpty(SearchText)) { Response.Redirect("~/"); } using (DataProcess dp = new DataProcess()) { try { dp.AddParameter("Content", SearchText); dp.ExecuteReader("SELECT * FROM Posts WHERE Type = 0 AND State = 1 AND (Content LIKE @Content + ' %' OR Content LIKE '% ' + @Content OR Content LIKE '% ' + @Content + ' %')"); int p = 0; int.TryParse(Request["p"], out p); p = p == 0 ? 1 : p; IDataReader dr = dp.Return.Value as IDataReader; List <BSPost> posts = new List <BSPost>(); while (dr.Read()) { BSPost post = new BSPost(); BSPost.FillPost(dr, post); posts.Add(post); } if (posts.Count > 0) { ltResult.Text = String.Format(Language.Get["SearchFoundedItemCount"], String.Format("<b>{0}</b>", posts.Count)); } else { ltResult.Text = Language.Get["SearchNotFound"]; } ltPaging.Visible = posts.Count > 0; rpSearch.DataSource = Data.Paging(posts, p, ltPaging); rpSearch.DataBind(); } catch (Exception) { } } }
protected void Page_Load(object sender, EventArgs e) { if (String.IsNullOrEmpty(SearchText)) Response.Redirect("~/"); using (DataProcess dp = new DataProcess()) { try { dp.AddParameter("Content", SearchText); dp.ExecuteReader("SELECT * FROM Posts WHERE Type = 0 AND State = 1 AND (Content LIKE @Content + ' %' OR Content LIKE '% ' + @Content OR Content LIKE '% ' + @Content + ' %')"); int p = 0; int.TryParse(Request["p"], out p); p = p == 0 ? 1 : p; IDataReader dr = dp.Return.Value as IDataReader; List<BSPost> posts = new List<BSPost>(); while (dr.Read()) { BSPost post = new BSPost(); BSPost.FillPost(dr, post); posts.Add(post); } if (posts.Count > 0) { ltResult.Text = String.Format(Language.Get["SearchFoundedItemCount"], String.Format("<b>{0}</b>", posts.Count)); } else ltResult.Text = Language.Get["SearchNotFound"]; ltPaging.Visible = posts.Count > 0; rpSearch.DataSource = Data.Paging(posts, p, ltPaging); rpSearch.DataBind(); } catch (Exception) { } } }
public static List<BSWidget> GetWidgetsByColumnValue(string column, object value, int widgetCount, string orderBy) { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { string top = widgetCount > 0 ? "TOP " + widgetCount : String.Empty; if (!String.IsNullOrEmpty(column) && value != null) { dp.AddParameter(column, value); dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] WHERE [{1}]=@{1} {2}", top, column, orderBy)); } else { dp.ExecuteReader(String.Format("SELECT {0} * FROM [Widgets] {1}", top, orderBy)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public static List<BSWidget> GetWidgetsBySorted() { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Visible", true); dp.ExecuteReader("SELECT * FROM Widgets WHERE [Visible] = @Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public static List<BSWidget> GetWidgetsByPlaceHolder(string placeHolder, bool visible) { List<BSWidget> widgets = new List<BSWidget>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("PlaceHolder", placeHolder); dp.AddParameter("Visible", visible); dp.ExecuteReader("SELECT * FROM [Widgets] WHERE [PlaceHolder]=@PlaceHolder AND [Visible]=@Visible ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); widgets.Add(bsWidget); } } } } return widgets; }
public static BSMenuGroup GetMenuGroup(string menuCode) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("Code", menuCode); dp.ExecuteReader("SELECT * FROM [MenuGroups] WHERE [Code]=@Code"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSMenuGroup menuGroup = new BSMenuGroup(); FillMenuGroup(dr, menuGroup); return menuGroup; } } } } return null; }
public bool Remove() { using (DataProcess dp = new DataProcess()) { CancelEventArgs cancelEvent = new CancelEventArgs(); OnDeleting(this, cancelEvent); if (!cancelEvent.Cancel) { dp.AddParameter("CommentID", CommentID); dp.ExecuteNonQuery("DELETE FROM Comments WHERE [CommentID] = @CommentID"); if (dp.Return.Status == DataProcessState.Success) { OnDeleted(this, null); return true; } } } return false; }
public bool Save() { using (DataProcess dp = new DataProcess()) { dp.AddParameter("SiteID", SiteID); dp.AddParameter("Name", Name); dp.AddParameter("Description", Description); dp.AddParameter("Target", Target); dp.AddParameter("Url", Url); dp.AddParameter("LanguageCode", LanguageCode); if (LinkID != 0) { dp.AddParameter("LinkID", LinkID); dp.ExecuteNonQuery( "UPDATE Links SET [SiteID]=@SiteID,[Name]=@Name,[Description]=@Description,[Target]=@Target,[Url]=@Url,[LanguageCode]=@LanguageCode WHERE [LinkID]=@LinkID"); return dp.Return.Status == DataProcessState.Success; } else { dp.ExecuteNonQuery("INSERT INTO Links([SiteID],[Name],[Description],[Target],[Url],[LanguageCode]) VALUES(@SiteID,@Name,@Description,@Target,@Url,@LanguageCode)"); if (dp.Return.Status == DataProcessState.Success) { dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { LinkID = Convert.ToInt32(dp.Return.Value); } return true; } } } return false; }
public static List<BSLink> GetLinks(int iTermID) { List<BSLink> links = new List<BSLink>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("TermID", iTermID); dp.ExecuteReader("SELECT * FROM [Links] WHERE [LinkID] IN (SELECT [ObjectID] FROM [TermsTo] WHERE [TermID]=@TermID)"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSLink link = new BSLink(); FillLink(dr, link); links.Add(link); } } } } return links; }
public static List<BSComment> GetComments(CommentStates state, int iCommentCount) { List<BSComment> comments = new List<BSComment>(); using (DataProcess dp = new DataProcess()) { string top = iCommentCount == 0 ? String.Empty : "TOP " + iCommentCount; if (state == CommentStates.All) { dp.ExecuteReader(String.Format("SELECT {0} * FROM Comments ORDER By CreateDate DESC", top)); } else { dp.AddParameter("Approve", state == CommentStates.Approved); dp.ExecuteReader(String.Format("SELECT {0} * FROM Comments WHERE [Approve]=@Approve ORDER By CreateDate DESC", top)); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSComment bsComment = new BSComment(); FillComment(dr, bsComment); comments.Add(bsComment); } } } } return comments; }
public static BSComment GetComment(int iCommentID) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("CommentID", iCommentID); dp.ExecuteReader("SELECT * FROM Comments WHERE [CommentID]=@CommentID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSComment bsComment = new BSComment(); FillComment(dr, bsComment); return bsComment; } } } } return null; }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { dp.AddParameter("Description", this.Description); dp.AddParameter("MenuGroupID", this.MenuGroupID); dp.AddParameter("MenuType", (short)this.MenuType); dp.AddParameter("ObjectID", this.ObjectID); dp.AddParameter("ObjectType", (short)this.ObjectType); dp.AddParameter("ParentID", this.ParentID); dp.AddParameter("Sort", this.Sort); dp.AddParameter("Target", this.Target); dp.AddParameter("Title", this.Title); dp.AddParameter("Url", this.Url); if (MenuID != 0) { dp.AddParameter("MenuID", MenuID); dp.ExecuteNonQuery("UPDATE [Menus] SET [Description]=@Description,[MenuGroupID]=@MenuGroupID,[MenuType]=@MenuType," + "[ObjectID]=@ObjectID,[ObjectType]=@ObjectType,[ParentID]=@ParentID,[Sort]=@Sort,[Target]=@Target,[Title]=@Title,[Url]=@Url WHERE [MenuID] = @MenuID"); bReturnValue = dp.Return.Status == DataProcessState.Success; } else { dp.ExecuteNonQuery("INSERT INTO [Menus]([Description],[MenuGroupID],[MenuType],[ObjectID],[ObjectType],[ParentID],[Sort],[Target],[Title],[Url]) " + "VALUES(@Description,@MenuGroupID,@MenuType,@ObjectID,@ObjectType,@ParentID,@Sort,@Target,@Title,@Url)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { MenuID = Convert.ToInt32(dp.Return.Value); } } } } return bReturnValue; }
public static List<BSComment> GetCommentsByUserID(int iUserID, CommentStates state) { List<BSComment> comments = new List<BSComment>(); using (DataProcess dp = new DataProcess()) { if (state == CommentStates.All) { dp.AddParameter("UserID", iUserID); dp.ExecuteReader("SELECT * FROM Comments WHERE [UserID]=@UserID ORDER By CreateDate DESC"); } else { dp.AddParameter("UserID", iUserID); dp.AddParameter("Approve", state == CommentStates.Approved); dp.ExecuteReader("SELECT * FROM Comments WHERE [UserID]=@UserID AND [Approve]=@Approve ORDER By CreateDate DESC"); } if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSComment bsComment = new BSComment(); FillComment(dr, bsComment); comments.Add(bsComment); } } } } return comments; }
public static List<BSMenu> GetMenus(int menuGroupID) { List<BSMenu> menus = new List<BSMenu>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("MenuGroupID", menuGroupID); dp.ExecuteReader("SELECT * FROM [Menus] WHERE [MenuGroupID]=@MenuGroupID ORDER BY [Sort]"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { while (dr != null && dr.Read()) { BSMenu menu = new BSMenu(); FillMenu(dr, menu); menus.Add(menu); } } } } return menus; }
public static BSMenu GetMenu(int menuID) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("MenuID", menuID); dp.ExecuteReader("SELECT * FROM [Menus] WHERE [MenuID]=@MenuID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSMenu menu = new BSMenu(); FillMenu(dr, menu); return menu; } } } } return null; }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { dp.AddParameter("UserID", UserID); dp.AddParameter("PostID", PostID); dp.AddParameter("Name", UserName); dp.AddParameter("Comment", Content); dp.AddParameter("Email", Email); dp.AddParameter("WebPage", WebPage); dp.AddParameter("Ip", IP); dp.AddParameter("CreateDate", Date); dp.AddParameter("Approve", Approve); dp.AddParameter("NotifyMe", NotifyMe); if (CommentID != 0) { dp.AddParameter("CommentID", CommentID); dp.ExecuteNonQuery("UPDATE Comments SET [UserID]=@UserID,[PostID]=@PostID,[Name]=@Name,[Comment]=@Comment," + "[Email]=@Email,[WebPage]=@WebPage,[Ip]=@Ip,[CreateDate]=@CreateDate,[Approve]=@Approve,[NotifyMe]=@NotifyMe WHERE [CommentID] = @CommentID"); bReturnValue = dp.Return.Status == DataProcessState.Success; } else { dp.ExecuteNonQuery("INSERT INTO Comments([UserID],[PostID],[Name],[Comment],[Email],[WebPage],[Ip],[CreateDate],[Approve],[NotifyMe]) " + "VALUES(@UserID,@PostID,@Name,@Comment,@Email,@WebPage,@Ip,@CreateDate,@Approve,@NotifyMe)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { CommentID = Convert.ToInt32(dp.Return.Value); } } } } return bReturnValue; }
public static BSWidget GetWidget(string folderName) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("FolderName", folderName); dp.ExecuteReader("SELECT * FROM Widgets WHERE [FolderName]=@FolderName"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSWidget bsWidget = new BSWidget(); FillWidget(dr, bsWidget); return bsWidget; } } } } return null; }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { if (this.Default) { dp.AddParameter("Default", false); dp.ExecuteNonQuery("UPDATE [MenuGroups] SET [Default]=@Default"); } dp.AddParameter("SiteID", this.SiteID); dp.AddParameter("Code", this.Code); dp.AddParameter("Description", this.Description); dp.AddParameter("Title", this.Title); dp.AddParameter("Default", this.Default); dp.AddParameter("LanguageCode", this.LanguageCode); if (MenuGroupID != 0) { dp.AddParameter("MenuGroupID", this.MenuGroupID); dp.ExecuteNonQuery("UPDATE [MenuGroups] SET [SiteID]=@SiteID,[Code]=@Code,[Description]=@Description,[Title]=@Title,[Default]=@Default,[LanguageCode]=@LanguageCode WHERE [MenuGroupID] = @MenuGroupID"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { foreach (BSMenu bsMenu in Menu) { bsMenu.Save(); } } } else { dp.ExecuteNonQuery("INSERT INTO [MenuGroups]([SiteID],[Code],[Description],[Title],[Default],[LanguageCode]) VALUES(@SiteID,@Code,@Description,@Title,@Default,@LanguageCode)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { foreach (BSMenu bsMenu in Menu) { bsMenu.Save(); } dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { MenuGroupID = Convert.ToInt32(dp.Return.Value); } } } } return bReturnValue; }
public bool Save() { using (DataProcess dp = new DataProcess()) { dp.AddParameter("ParentID", this.ParentID); dp.AddParameter("UserID", this.UserID); dp.AddParameter("Code", this.Code); dp.AddParameter("State", this.State); string sql = "INSERT INTO Sites([ParentID],[UserID],[Code],[State]) " + "VALUES(@ParentID,@UserID,@Code,@State);"; if (SiteID != 0) { sql = "UPDATE Settings SET [ParentID]=@ParentID,[UserID]=@UserID,[Code]=@Code,[State]=@State WHERE [SiteID] = @SiteID;"; dp.AddParameter("SiteID", this.SiteID); } dp.ExecuteNonQuery(sql); return dp.Return.Status == DataProcessState.Success; } }
public bool Save() { bool bReturnValue = false; using (DataProcess dp = new DataProcess()) { dp.AddParameter("SiteID", this.SiteID); dp.AddParameter("Description", this.Description); dp.AddParameter("FolderName", this.FolderName); dp.AddParameter("PlaceHolder", this.PlaceHolder); dp.AddParameter("Sort", this.Sort); dp.AddParameter("Title", this.Title); dp.AddParameter("Visible", this.Visible); dp.AddParameter("Type", this.Type); dp.AddParameter("LanguageCode", this.LanguageCode); if (WidgetID != 0) { dp.AddParameter("WidgetID", WidgetID); dp.ExecuteNonQuery("UPDATE Widgets SET [SiteID]=@SiteID,[Description]=@Description,[FolderName]=@FolderName,[PlaceHolder]=@PlaceHolder,[Sort]=@Sort," + "[Title]=@Title,[Visible]=@Visible,[Type]=@Type,[LanguageCode]=@LanguageCode WHERE [WidgetID] = @WidgetID"); bReturnValue = dp.Return.Status == DataProcessState.Success; } else { dp.ExecuteNonQuery("INSERT INTO Widgets([SiteID],[Description],[FolderName],[PlaceHolder],[Sort],[Title],[Visible],[Type],[LanguageCode]) " + "VALUES(@SiteID,@Description,@FolderName,@PlaceHolder,@Sort,@Title,@Visible,@Type,@LanguageCode)"); bReturnValue = dp.Return.Status == DataProcessState.Success; if (bReturnValue) { dp.ExecuteScalar("SELECT @@IDENTITY"); if (dp.Return.Status == DataProcessState.Success) { WidgetID = Convert.ToInt32(dp.Return.Value); } } } } return bReturnValue; }
public bool Remove() { using (DataProcess dp = new DataProcess()) { CancelEventArgs cancelEvent = new CancelEventArgs(); OnDeleting(this, cancelEvent); if (!cancelEvent.Cancel) { dp.AddParameter("LinkID", LinkID); dp.ExecuteNonQuery("DELETE FROM [Links] WHERE [LinkID] = @LinkID"); dp.AddParameter("ObjectID", LinkID); dp.ExecuteNonQuery("DELETE FROM [TermsTo] WHERE [ObjectID] = @ObjectID"); if (dp.Return.Status == DataProcessState.Success) { OnDeleted(this, null); return true; } } } return false; }
public bool Save() { DataProcess dp = new DataProcess(); string sql = String.Empty; if (SettingID == 0) sql = "INSERT INTO Settings([SiteID],[Name],[Value],[Title],[Description],[Main],[Sort],[Visible]) " + "VALUES(@SiteID,@Name,@Value,@Title,@Description,@Main,@Sort,@Visible);"; else sql = "UPDATE Settings SET [SiteID]=@SiteID,[Name]=@Name,[Value]=@Value,[Title]=@Title,[Description]=@Description,[Main]=@Main,[Sort]=@Sort,[Visible]=@Visible WHERE [SettingID] = @SettingID;"; dp.AddParameter("SiteID", this.SiteID); dp.AddParameter("Name", this.Name); dp.AddParameter("Value", this.Value); dp.AddParameter("Title", this.Title); dp.AddParameter("Description", this.Description); dp.AddParameter("Main", this.Main); dp.AddParameter("Sort", this.Sort); dp.AddParameter("Visible", this.Visible); if (SettingID != 0) dp.AddParameter("SettingID", this.SettingID); dp.ExecuteNonQuery(sql); return dp.Return.Status == DataProcessState.Success; }
public static BSLink GetLink(int iLinkID) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("LinkID", iLinkID); dp.ExecuteReader("SELECT * FROM Links WHERE [LinkID]=@LinkID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSLink link = new BSLink(); FillLink(dr, link); return link; } } } } return null; }
public static BSSetting GetSetting(int iSettingID) { BSSetting bsSetting = new BSSetting(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("SettingID", iSettingID); dp.ExecuteReader("SELECT * FROM Settings WHERE SettingID = @SettingID"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr.Read()) { FillValue(dr, bsSetting); return bsSetting; } } } } return null; }
public bool Remove() { using (DataProcess dp = new DataProcess()) { //CancelEventArgs cancelEvent = new CancelEventArgs(); //OnDeleting(this, cancelEvent); //if (!cancelEvent.Cancel) //{ dp.AddParameter("MenuGroupID", MenuGroupID); dp.ExecuteNonQuery("DELETE FROM [MenuGroups] WHERE [MenuGroupID] = @MenuGroupID"); if (dp.Return.Status == DataProcessState.Success) { //OnDeleted(this, null); return true; } //} } return false; }
public bool DoApprove(bool bApprove) { CancelEventArgs eventArgs = new CancelEventArgs(); BSComment bsComment = GetComment(CommentID); OnApproving(bsComment, eventArgs); if (!eventArgs.Cancel) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("Approve", bApprove); dp.AddParameter("CommentID", CommentID); dp.ExecuteNonQuery("UPDATE Comments SET [Approve]=@Approve WHERE [CommentID]=@CommentID"); if (dp.Return.Status == DataProcessState.Success) { bsComment.Approve = bApprove; OnApproved(bsComment, null); return true; } } } return false; }
public static BSMenuGroup GetDefault() { using (DataProcess dp = new DataProcess()) { dp.AddParameter("Default", true); dp.ExecuteReader("SELECT * FROM [MenuGroups] WHERE [Default]=@Default"); if (dp.Return.Status == DataProcessState.Success) { using (IDataReader dr = dp.Return.Value as IDataReader) { if (dr != null && dr.Read()) { BSMenuGroup menuGroup = new BSMenuGroup(); FillMenuGroup(dr, menuGroup); return menuGroup; } } } } BSMenuGroup defaultMenuGroup = new BSMenuGroup(); return defaultMenuGroup; }
public static void Delete(int iCommentID) { CancelEventArgs eventArgs = new CancelEventArgs(); BSComment bsComment = GetComment(iCommentID); BSComment.OnDeleting(bsComment, eventArgs); if (!eventArgs.Cancel) { using (DataProcess dp = new DataProcess()) { dp.AddParameter("CommentID", iCommentID); dp.ExecuteReader("DELETE FROM Comments WHERE [CommentID]=@CommentID"); if (dp.Return.Status == DataProcessState.Success) { BSComment.OnDeleted(bsComment, EventArgs.Empty); } } } }