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