public static string voteTag(long premalinkId, long TagId, string vote) { try { HttpCookie _cookie; _cookie = HttpContext.Current.Request.Cookies["Tagged"]; long result; if (_cookie != null && Int64.TryParse(UtilityClass.DecryptStringAES(_cookie["d"]), out result)) { if (result > 0) { var blltag = new BllTag(); var news = new DtoNewsFeed(); news.TagId = TagId; news.UserId = Convert.ToInt64(UtilityClass.DecryptStringAES(_cookie["d"])); news.Title = vote; news.PremalinkId = premalinkId; blltag.VoteContent(news); return("1"); } return(null); } return(null); } catch (Exception ex) { ex.ToExceptionless().Submit(); } return(null); }
public long VoteContent(DtoNewsFeed news) { long TagId = 0; try { _command = new SqlCommand(StoredProcedure.Names.spVoteContent.ToString(), _connection); _command.CommandType = CommandType.StoredProcedure; _command.Parameters.Add("@UserID", SqlDbType.BigInt); _command.Parameters.Add("@ContentID", SqlDbType.BigInt); _command.Parameters.Add("@TagID", SqlDbType.BigInt); _command.Parameters.Add("@VoteType", SqlDbType.VarChar); _command.Parameters[0].Value = news.UserId; _command.Parameters[1].Value = news.PremalinkId; _command.Parameters[2].Value = news.TagId; _command.Parameters[3].Value = news.Title; _connection.Open(); TagId = Convert.ToInt64(_command.ExecuteScalar()); } catch (Exception error) { throw error; } finally { _connection.Close(); } return(TagId); }
public List <DtoNewsFeed> GetUserTagFeed(long userId, string tagId, string emoId, long pageNumber, long rowsPerPage) { List <DtoNewsFeed> lstnewsfeed; try { _command = new SqlCommand(StoredProcedure.Names.spGetUserTagFeed.ToString(), _connection); _command.CommandType = CommandType.StoredProcedure; _command.Parameters.Add("@UserID", SqlDbType.BigInt); _command.Parameters.Add("@TagId", SqlDbType.VarChar); _command.Parameters.Add("@EmoId", SqlDbType.VarChar); _command.Parameters.Add("@PageNumber", SqlDbType.BigInt); _command.Parameters.Add("@RowsPerPage", SqlDbType.BigInt); _command.Parameters[0].Value = userId; _command.Parameters[1].Value = tagId; _command.Parameters[2].Value = emoId; _command.Parameters[3].Value = pageNumber; _command.Parameters[4].Value = rowsPerPage; lstnewsfeed = new List <DtoNewsFeed>(); _connection.Open(); _datareader = _command.ExecuteReader(); if (!_datareader.HasRows) { return(null); } while (_datareader.Read()) { _dtonewsfeed = new DtoNewsFeed { EmotionString = _datareader["EmoString"].ToString(), Tagstring = _datareader["TagString"].ToString(), PremalinkId = Convert.ToInt64(_datareader["PremalinkId"].ToString()), Link = _datareader["Link"].ToString(), Title = _datareader["Title"].ToString(), Description = _datareader["Description"].ToString(), Image = _datareader["Image"].ToString(), CreatedOn = Convert.ToDateTime(_datareader["CreatedOn"].ToString()), WebsiteId = Convert.ToInt64(_datareader["WebsiteId"]), WebsiteName = _datareader["WebsiteName"].ToString(), WebSiteURL = _datareader["WebsiteUrl"].ToString(), WebsiteImage = _datareader["WebsiteImage"].ToString() }; lstnewsfeed.Add(_dtonewsfeed); } return(lstnewsfeed); } catch (Exception error) { throw; } finally { _connection.Close(); } }
public List <DtoNewsFeed> GetWebsiteFeed(long userId, long websiteId, string tagId, string emoId, long pageNumber, long rowsPerPage) { var lstnewsfeed = new List <DtoNewsFeed>(); try { sqlparameter = new SqlParameter[6]; sqlparameter[0] = new SqlParameter("@WebsiteID", websiteId); sqlparameter[1] = new SqlParameter("@TagId", tagId); sqlparameter[2] = new SqlParameter("@EmoId", emoId); sqlparameter[3] = new SqlParameter("@PageNumber", pageNumber); sqlparameter[4] = new SqlParameter("@RowsPerPage", rowsPerPage); sqlparameter[5] = new SqlParameter("@UserID", userId); _dtonewsfeed = new DtoNewsFeed(); OpenConnection(); datareader = ExecuteReader(StoredProcedure.Names.spGetWebsiteFeed.ToString()); if (!datareader.HasRows) { return(null); } while (datareader.Read()) { _dtonewsfeed = new DtoNewsFeed { EmotionString = datareader["EmoString"].ToString(), Tagstring = datareader["TagString"].ToString(), PremalinkId = Convert.ToInt64(datareader["PremalinkId"].ToString()), Link = datareader["Link"].ToString(), Title = datareader["Title"].ToString(), Description = datareader["Description"].ToString(), Image = datareader["Image"].ToString(), CreatedOn = Convert.ToDateTime(datareader["CreatedOn"].ToString()), WebsiteName = datareader["WebsiteName"].ToString(), WebSiteURL = datareader["WebsiteUrl"].ToString(), WebsiteImage = datareader["WebsiteImage"].ToString(), WebsiteId = websiteId }; lstnewsfeed.Add(_dtonewsfeed); } } catch (Exception error) { throw error; } finally { CloseConnection(); } return(lstnewsfeed); }
public long VoteContent(DtoNewsFeed news) { try { _daltag = new DalTag(); return(_daltag.VoteContent(news)); } catch (Exception ex) { ex.ToExceptionless().Submit(); } return(0); }
public static void voteTag(long premalinkId, long TagId, string vote, int UserID) { try { var blltag = new BllTag(); var news = new DtoNewsFeed { TagId = TagId, UserId = Convert.ToInt32(UserID), Title = vote, PremalinkId = premalinkId }; news.UserId = UserID; blltag.VoteContent(news); } catch (Exception ex) { ex.ToExceptionless().Submit(); } }
public List <DtoNewsFeed> GetEmoNewsFeed(long UserID, int emoid, long PageNumber, long RowsPerPage) { var lstnewsfeed = new List <DtoNewsFeed>(); var dtonewsfeed = new DtoNewsFeed(); try { _command = new SqlCommand(StoredProcedure.Names.spGetEmoNewsFeed.ToString(), _connection); _command.CommandType = CommandType.StoredProcedure; _command.Parameters.Add("@EmoId", SqlDbType.BigInt); _command.Parameters.Add("@UserId", SqlDbType.BigInt); _command.Parameters.Add("@PageNumber", SqlDbType.BigInt); _command.Parameters.Add("@RowsPerPage", SqlDbType.BigInt); _command.Parameters[0].Value = emoid; _command.Parameters[1].Value = UserID; _command.Parameters[2].Value = PageNumber; _command.Parameters[3].Value = RowsPerPage; _connection.Open(); _datareader = _command.ExecuteReader(); if (!_datareader.HasRows) { return(null); } while (_datareader.Read()) { dtonewsfeed = new DtoNewsFeed(); dtonewsfeed.TagId = Convert.ToInt64(_datareader["Tag_Id"]); dtonewsfeed.WebsiteId = Convert.ToInt64(_datareader["Website_Id"].ToString()); dtonewsfeed.WebsiteName = _datareader["WebsiteName"].ToString(); dtonewsfeed.PremalinkId = Convert.ToInt64(_datareader["PremalinkId"].ToString()); dtonewsfeed.TagName = _datareader["TagName"].ToString(); dtonewsfeed.UpVote = Convert.ToInt32(_datareader["UpVote"].ToString()); dtonewsfeed.DownVote = Convert.ToInt32(_datareader["DownVote"].ToString()); dtonewsfeed.TaggedByUser = Convert.ToBoolean(_datareader["TaggedByUser"].ToString()); dtonewsfeed.Link = _datareader["Link"].ToString(); dtonewsfeed.Title = _datareader["Title"].ToString(); dtonewsfeed.Description = _datareader["Description"].ToString(); dtonewsfeed.Image = _datareader["Image"].ToString(); dtonewsfeed.TotalVote = Convert.ToInt64(_datareader["TotalVote"].ToString()); dtonewsfeed.CreatedOn = Convert.ToDateTime(_datareader["CreatedOn"].ToString()); dtonewsfeed.EmotionId = Convert.ToInt32(_datareader["EmotionId"]); dtonewsfeed.EmotionName = _datareader["EmotionName"].ToString(); dtonewsfeed.TotalCount = Convert.ToInt64(_datareader["TotalCount"].ToString()); if (_datareader["UserEmotion"] != DBNull.Value) { dtonewsfeed.IsActive = (Convert.ToInt32(_datareader["UserEmotion"]) == 0) ? false : true; } lstnewsfeed.Add(dtonewsfeed); } return(lstnewsfeed); } catch (Exception error) { throw error; } finally { _connection.Close(); } }
public List <DtoNewsFeed> GetTagNewsFeed(long UserId, long tagId, long PageNumber, long RowsPerPage) { try { var dalemotion = new DalEmotions(); var newlstdtonewsfeed = new List <DtoNewsFeed>(); var lstemotion = new List <DtoEmotions>(); _daltag = new DalTag(); List <DtoNewsFeed> lstdtonewsfeed = _daltag.GetTagNewsFeed(UserId, tagId, PageNumber, RowsPerPage); if (lstdtonewsfeed != null) { IEnumerable <long> query = (from ca in lstdtonewsfeed select ca.PremalinkId).Distinct(); if (query != null) { foreach (long item in query) { IEnumerable <long> uniquetagid = (from ca in lstdtonewsfeed where ca.PremalinkId == item && ca.TagId != 0 select ca.TagId).Distinct(); IEnumerable <long> uniqueemoid = (from ca in lstdtonewsfeed where ca.PremalinkId == item && ca.EmotionId != 0 select ca.EmotionId).Distinct(); string tagstr = ""; int index = 0; foreach (int str in uniquetagid) { DtoNewsFeed dto = (from ca in lstdtonewsfeed where ca.PremalinkId == item && ca.TagId == str select ca).FirstOrDefault(); tagstr += "|" + dto.TagId + "," + dto.TagName + "," + dto.TotalVote + "," + dto.UpVote + "," + dto.DownVote + "," + dto.TaggedByUser + ","; index += 1; if (index == uniquetagid.Count()) { newlstdtonewsfeed.Add(new DtoNewsFeed { PremalinkId = dto.PremalinkId, Title = dto.Title, Description = dto.Description, Image = dto.Image, CreatedOn = dto.CreatedOn, Tagstring = tagstr, Link = dto.Link, WebsiteName = dto.WebsiteName, WebsiteId = dto.WebsiteId, WebsiteImage = dto.WebsiteImage }); } } string emostr = ""; index = 0; foreach (long str in uniqueemoid) { DtoNewsFeed dto = (from ca in lstdtonewsfeed where ca.PremalinkId == item && ca.EmotionId == str select ca).FirstOrDefault(); index += 1; emostr += "|" + dto.EmotionId + "," + dto.EmotionName + "," + dto.TotalCount + "," + dto.IsActive; if (index == uniqueemoid.Count()) { DtoNewsFeed q = (from c in newlstdtonewsfeed where c.PremalinkId == dto.PremalinkId select c).FirstOrDefault(); q.EmotionString = emostr; emostr = ""; } } } } } return(newlstdtonewsfeed); } catch (Exception ex) { ex.ToExceptionless().Submit(); } return(null); }
public List <DtoNewsFeed> GetExploreNewsFeed(long userId, long tagid, long pageNumber, long rowsPerPage) { var lstnewsfeed = new List <DtoNewsFeed>(); try { _command = new SqlCommand(StoredProcedure.Names.spGetExploreNewsFeed.ToString(), _connection) { CommandType = CommandType.StoredProcedure }; _command.Parameters.Add("@TagId", SqlDbType.BigInt); _command.Parameters.Add("@UserId", SqlDbType.BigInt); _command.Parameters.Add("@PageNumber", SqlDbType.BigInt); _command.Parameters.Add("@RowsPerPage", SqlDbType.BigInt); _command.Parameters[0].Value = tagid; _command.Parameters[1].Value = userId; _command.Parameters[2].Value = pageNumber; _command.Parameters[3].Value = rowsPerPage; _dtonewsfeed = new DtoNewsFeed(); _connection.Open(); _datareader = _command.ExecuteReader(); if (!_datareader.HasRows) { return(null); } while (_datareader.Read()) { _dtonewsfeed = new DtoNewsFeed { TagId = Convert.ToInt64(_datareader["Tag_Id"]), WebsiteId = Convert.ToInt64(_datareader["Website_Id"].ToString()), PremalinkId = Convert.ToInt64(_datareader["PremalinkId"].ToString()), TagName = _datareader["TagName"].ToString(), UpVote = Convert.ToInt32(_datareader["UpVote"].ToString()), DownVote = Convert.ToInt32(_datareader["DownVote"].ToString()), TaggedByUser = Convert.ToBoolean(_datareader["TaggedByUser"].ToString()), Link = _datareader["Link"].ToString(), Title = _datareader["Title"].ToString(), Description = _datareader["Description"].ToString(), Image = _datareader["Image"].ToString(), TotalVote = Convert.ToInt64(_datareader["TotalVote"].ToString()), CreatedOn = Convert.ToDateTime(_datareader["CreatedOn"].ToString()) }; lstnewsfeed.Add(_dtonewsfeed); } return(lstnewsfeed); } catch (Exception error) { throw; } finally { _connection.Close(); } }
public List <DtoNewsFeed> GetUserNewsFeed(long userId, long pageNumber, long rowsPerPage) { // System.Diagnostics.Debugger.Launch(); var lstnewsfeed = new List <DtoNewsFeed>(); try { _command = new SqlCommand(StoredProcedure.Names.spGetUserNewsFeed.ToString(), _connection); _command.CommandType = CommandType.StoredProcedure; _command.Parameters.Add("@UserID", SqlDbType.BigInt); _command.Parameters.Add("@PageNumber", SqlDbType.BigInt); _command.Parameters.Add("@RowsPerPage", SqlDbType.BigInt); _command.Parameters[0].Value = userId; _command.Parameters[1].Value = pageNumber; _command.Parameters[2].Value = rowsPerPage; _dtonewsfeed = new DtoNewsFeed(); _connection.Open(); _datareader = _command.ExecuteReader(); if (!_datareader.HasRows) { return(null); } while (_datareader.Read()) { _dtonewsfeed = new DtoNewsFeed(); _dtonewsfeed.TagId = Convert.ToInt64(_datareader["Tag_Id"]); _dtonewsfeed.WebsiteId = Convert.ToInt64(_datareader["Website_Id"].ToString()); _dtonewsfeed.PremalinkId = Convert.ToInt64(_datareader["PremalinkId"].ToString()); _dtonewsfeed.TagName = _datareader["TagName"].ToString(); _dtonewsfeed.UpVote = Convert.ToInt32(_datareader["UpVote"].ToString()); _dtonewsfeed.DownVote = Convert.ToInt32(_datareader["DownVote"].ToString()); if (_datareader["TaggedByUser"] != null) { _dtonewsfeed.TaggedByUser = Convert.ToBoolean(_datareader["TaggedByUser"].ToString()); } _dtonewsfeed.Link = _datareader["Link"].ToString(); _dtonewsfeed.Title = _datareader["Title"].ToString(); _dtonewsfeed.Description = _datareader["Description"].ToString(); _dtonewsfeed.Image = _datareader["Image"].ToString(); _dtonewsfeed.TotalVote = Convert.ToInt64(_datareader["TotalVote"].ToString()); _dtonewsfeed.CreatedOn = Convert.ToDateTime(_datareader["CreatedOn"].ToString()); _dtonewsfeed.WebsiteId = Convert.ToInt64(_datareader["WebsiteId"]); _dtonewsfeed.WebsiteName = _datareader["WebsiteName"].ToString(); _dtonewsfeed.WebSiteURL = _datareader["WebsiteUrl"].ToString(); _dtonewsfeed.WebsiteImage = _datareader["WebsiteImage"].ToString(); lstnewsfeed.Add(_dtonewsfeed); } return(lstnewsfeed); } catch (Exception error) { throw; } finally { _connection.Close(); } }