public List <SelectListItem> GetAllTagsByUserID() { List <SelectListItem> ListOfTags = new(); string UserID = _sessionHelper.GetDecodedSession().UserID; try { using (SqlConnection sqlConnection = Utils.Utils.GetConnection(_configuration)) { using (SqlCommand cmd = new SqlCommand("PR_GET_Tag_By_UserPost_Id", sqlConnection)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", UserID); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { SelectListItem Tags = new(); if (!reader["TagName"].Equals(DBNull.Value)) { Tags.Text = Convert.ToString(reader["TagName"]); Tags.Value = Convert.ToString(reader["TagName"]); } ListOfTags.Add(Tags); } } } } } catch (Exception ex) { throw; } return(ListOfTags); }
public ResultBase <List <PostViewModel> > GetAllUserPosts() { var result = new ResultBase <List <PostViewModel> > { IsSuccess = false }; List <PostViewModel> PostList = new(); try { string UserGUIDString = _sessionHelper.GetDecodedSession().UserID; using (SqlConnection sqlConnection = Utils.Utils.GetConnection(_configuration)) { //Change SP Name using (SqlCommand cmd = new SqlCommand("PR_GET_PublicPost", sqlConnection)) { cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", UserGUIDString); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { int CategoryID = 0; PostViewModel postViewModel = new(); if (!reader["PostID"].Equals(DBNull.Value)) { postViewModel.PostID = Convert.ToInt32(reader["PostID"]); } if (!reader["ImageName"].Equals(DBNull.Value)) { postViewModel.ImageName = Convert.ToString(reader["ImageName"]); } if (!reader["QuoteText"].Equals(DBNull.Value)) { postViewModel.QuoteText = Convert.ToString(reader["QuoteText"]); } if (!reader["PostedDateTime"].Equals(DBNull.Value)) { postViewModel.PostedDateTime = Convert.ToDateTime(reader["PostedDateTime"]); } if (!reader["UserName"].Equals(DBNull.Value)) { postViewModel.UserName = Convert.ToString(reader["UserName"]); } if (!reader["CategoryID"].Equals(DBNull.Value)) { CategoryID = Convert.ToInt32(reader["CategoryID"]); } postViewModel.PostCategory = _categoryBll.GetAllCategories().Where(x => x.CategoryID == CategoryID).FirstOrDefault().PostCategoryName; postViewModel.Tags = _tagsBll.GetAllTagsByPostID(postViewModel.PostID).Select(x => x.TagName).ToList(); PostList.Add(postViewModel); } } } } } catch (Exception ex) { result.Message = "Something went wrong please try again letter" + ex.Message; } result.Result = PostList; return(result); }