public static JToken GetTopics() { using (SqlConnection conn = DbConnectionFactory.CreateSqlConnection()) using (SqlCommand command = new SqlCommand("SubForum_Select", conn)) { command.CommandType = CommandType.StoredProcedure; using (SqlDataReader reader = command.ExecuteReader()) { return(JsonUtils.CreateJsonArrayFromSqlReader(reader)); } } }
public static JToken GetThreads(int topicId) { using (SqlConnection conn = DbConnectionFactory.CreateSqlConnection()) using (SqlCommand command = new SqlCommand("Thread_Select", conn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@SubForumID", topicId); using (SqlDataReader reader = command.ExecuteReader()) { return(JsonUtils.CreateJsonArrayFromSqlReader(reader)); } } }
public static JToken GameInfo(string username) { using (SqlConnection conn = DbConnectionFactory.CreateSqlConnection()) using (SqlCommand command = new SqlCommand("GameInfo", conn)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@Username", username); using (SqlDataReader reader = command.ExecuteReader()) { return(JsonUtils.CreateJsonArrayFromSqlReader(reader)); } } }
public static JToken GetUsers(int userId) { using (SqlConnection conn = DbConnectionFactory.CreateSqlConnection()) using (SqlCommand command = new SqlCommand("Users_Select", conn)) { command.CommandType = CommandType.StoredProcedure; //if (!string.IsNullOrEmpty(clientIdentifier)) command.Parameters.AddWithValue("@UserID", userId); using (SqlDataReader reader = command.ExecuteReader()) { return(JsonUtils.CreateJsonArrayFromSqlReader(reader)); } } }