public static List <UserContent> HomepagePost(string username) { if (connect.State == ConnectionState.Open) { connect.Close(); } connect.Open(); SqlCommand cmd = new SqlCommand("homepage", connect); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@userID", SqlDbType.VarChar, 30).Value = username; SqlDataReader reader = cmd.ExecuteReader(); List <UserContent> postList = new List <UserContent>(); while (reader.Read()) { UserContent post = new UserContent(); post.contentID = Convert.ToInt32(reader["contentID"]); post.username = reader["username"].ToString(); post.privacy = reader["privacy"].ToString(); post.DateCreation = Convert.ToDateTime(reader["DateCreation"]); post.FileType = reader["FileType"].ToString(); post.RawData = reader["RawData"].ToString(); post.likes = Convert.ToInt32(reader["likes"]); post.filePath = reader["filePath"].ToString(); postList.Add(post); } connect.Close(); reader.Close(); return(postList); }
public static UserContent GetUserPost(int id) { if (connect.State == ConnectionState.Open) { connect.Close(); } connect.Open(); SqlCommand cmd = new SqlCommand("", connect); cmd.CommandText = "select * from UserContent where contentID=@contentID"; cmd.Parameters.AddWithValue("@contentID", id); SqlDataReader reader = cmd.ExecuteReader(); UserContent post = new UserContent(); if (reader.Read()) { post.contentID = Convert.ToInt32(reader["contentID"]); post.username = reader["username"].ToString(); post.privacy = reader["privacy"].ToString(); post.DateCreation = Convert.ToDateTime(reader["DateCreation"]); post.FileType = reader["FileType"].ToString(); post.RawData = reader["RawData"].ToString(); post.likes = Convert.ToInt32(reader["likes"]); post.filePath = reader["filePath"].ToString(); } connect.Close(); reader.Close(); return(post); }
public static List <UserContent> AllPostsOfAUser(string username) { if (connect.State == ConnectionState.Open) { connect.Close(); } connect.Open(); SqlCommand cmd = new SqlCommand("", connect); cmd.CommandText = "select * from UserContent where username=@username order by DateCreation DESC"; cmd.Parameters.AddWithValue("@username", username); SqlDataReader reader = cmd.ExecuteReader(); List <UserContent> postList = new List <UserContent>(); while (reader.Read()) { UserContent post = new UserContent(); post.contentID = Convert.ToInt32(reader["contentID"]); post.username = reader["username"].ToString(); post.privacy = reader["privacy"].ToString(); post.DateCreation = Convert.ToDateTime(reader["DateCreation"]); post.FileType = reader["FileType"].ToString(); post.RawData = reader["RawData"].ToString(); post.likes = Convert.ToInt32(reader["likes"]); post.filePath = reader["filePath"].ToString(); postList.Add(post); } connect.Close(); reader.Close(); return(postList); }
public static List <UserContent> getNonSessionUserPosts(string username, string sessionUser) { int sessionUserIsFollower = 0; if (connect.State == ConnectionState.Open) { connect.Close(); } connect.Open(); SqlCommand cmd = new SqlCommand("getNonSessionUserPosts", connect); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add("@username", SqlDbType.VarChar, 30).Value = username; if (IsFollowing(sessionUser, username)) { sessionUserIsFollower = 1; } cmd.Parameters.Add("@sessionUserIsFollowing", SqlDbType.Int).Value = sessionUserIsFollower; if (connect.State == ConnectionState.Open) { connect.Close(); } connect.Open(); SqlDataReader r = cmd.ExecuteReader(); List <UserContent> posts = new List <UserContent>(); while (r.Read()) { UserContent post = new UserContent(); post.contentID = Convert.ToInt32(r["contentID"]); post.username = r["username"].ToString(); post.likes = Convert.ToInt32(r["likes"]); post.DateCreation = Convert.ToDateTime(r["DateCreation"]); post.privacy = r["privacy"].ToString(); post.RawData = r["RawData"].ToString(); post.filePath = r["filePath"].ToString(); posts.Add(post); } r.Close(); connect.Close(); return(posts); }