private void Update() { if (Input.GetMouseButtonDown(1)) { int intOfCurrentState = (int)currentState; Debug.Log(countOfEnums); int nextState = (intOfCurrentState + 1) % countOfEnums; PostStates next = (PostStates)nextState; currentState = next; } }
private void SavePost(PostStates state) { BSPost bsPost = new BSPost(); bsPost.UserID = Blogsa.ActiveUser.UserID; bsPost.Title = txtPostTitle.Text; bsPost.Code = BSHelper.CreateCode(txtPostTitle.Text); bsPost.Content = txtPostContent.Text; bsPost.State = state; bsPost.Date = DateTime.Now; if (bsPost.Save()) { SaveTags(bsPost.PostID); Response.Redirect("Posts.aspx?PostID=" + bsPost.PostID + "&Message=1"); } }
public static List <BSPost> GetPosts(PostTypes postType, PostStates postState, int postCount) { List <BSPost> posts = new List <BSPost>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Type", (short)postType); if (postState != PostStates.All) { dp.AddParameter("State", (short)postState); 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 { 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 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 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<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 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<BSPost> GetPosts(PostTypes postType, PostStates postState, int postCount) { List<BSPost> posts = new List<BSPost>(); using (DataProcess dp = new DataProcess()) { dp.AddParameter("Type", (short)postType); if (postState != PostStates.All) { dp.AddParameter("State", (short)postState); 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 { 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; }