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);
}
