private string ProcessThumb(UserActivity_Struct ph) { StringBuilder str = new StringBuilder(); string _user = ph.PosterUserName; if (_user == "") { _user = ph.UserName; } string image_src = UrlConfig.Return_User_Profile_Photo(_user, ph.PictureName, 0, 0); str.Append("<a class=\"thumbnail\" style=\"width:" + this.Width + "px;\" href=\"" + UrlConfig.Prepare_User_Profile_Url(_user, this.isAdmin) + "\" title=\"" + _user + "\">"); // thumb link setup str.Append("<img src=\"" + image_src + "\" height=\"" + this.Height + "\" width=\"" + this.Width + "\">"); str.Append("</a>"); return(str.ToString()); }
public static long Add(UserActivity_Struct gal) { SqlConnection con = new SqlConnection(Config.ConnectionString); // generate sql query StringBuilder str = new StringBuilder(); str.Append("Insert Into useractivities(username,title,activity,added_date,poster_username)values(@username,@title,@activity,@added_date,@poster_username);Select SCOPE_IDENTITY();"); // execute sql query SqlCommand cmd = new SqlCommand(str.ToString(), con); cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@username", gal.UserName)); cmd.Parameters.Add(new SqlParameter("@title", gal.Title)); cmd.Parameters.Add(new SqlParameter("@activity", gal.Activity)); cmd.Parameters.Add(new SqlParameter("@added_date", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@poster_username", gal.PosterUserName)); if (con.State != ConnectionState.Open) con.Open(); return Convert.ToInt64(cmd.ExecuteScalar()); }
public static long Add(UserActivity_Struct gal) { SqlConnection con = new SqlConnection(Config.ConnectionString); // generate sql query StringBuilder str = new StringBuilder(); str.Append("Insert Into useractivities(username,title,activity,added_date,poster_username)values(@username,@title,@activity,@added_date,@poster_username);Select SCOPE_IDENTITY();"); // execute sql query SqlCommand cmd = new SqlCommand(str.ToString(), con); cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@username", gal.UserName)); cmd.Parameters.Add(new SqlParameter("@title", gal.Title)); cmd.Parameters.Add(new SqlParameter("@activity", gal.Activity)); cmd.Parameters.Add(new SqlParameter("@added_date", DateTime.Now)); cmd.Parameters.Add(new SqlParameter("@poster_username", gal.PosterUserName)); if (con.State != ConnectionState.Open) { con.Open(); } return(Convert.ToInt64(cmd.ExecuteScalar())); }
//************************************************************************************** // Close Core Engine for generating cached and non cached photo listings //************************************************************************************** #endregion // Fetch user activies public static List <UserActivity_Struct> Fetch_Activies(string UserName) { SqlConnection con = new SqlConnection(Config.ConnectionString); if (con.State != ConnectionState.Open) { con.Open(); } List <UserActivity_Struct> _items = new List <UserActivity_Struct>(); UserActivity_Struct _item; // generate sql query StringBuilder str = new StringBuilder(); // execute sql query SqlCommand cmd = new SqlCommand("SELECT p.activityid,p.username,p.poster_username,p.title,p.activity,p.added_date,p.liked,p.disliked,u.picturename FROM useractivities as p INNER JOIN users as u on u.username=p.poster_username WHERE p.username=@uname AND u.isenabled=1 Order By p.added_date desc, p.activityid desc", con); cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@uname", UserName)); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { _item = new UserActivity_Struct(); _item.ActivityID = (long)reader["activityid"]; _item.UserName = reader["username"].ToString(); _item.Activity = reader["activity"].ToString(); _item.Added_Date = (DateTime)reader["added_date"]; _item.Liked = Convert.ToInt32(reader["liked"]); _item.Disliked = Convert.ToInt32(reader["disliked"]); _item.PosterUserName = reader["poster_username"].ToString(); _items.Add(_item); } reader.Close(); con.Close(); con.Dispose(); return(_items); }
private string ProcessContent(UserActivity_Struct ph) { StringBuilder str = new StringBuilder(); // title or caption str.Append("<span id=\"actusr_" + ph.ActivityID + "\" style=\"display:none;\">" + ph.UserName + "</span>"); if (this.ShowTitle && ph.Title != "") { // user link str.Append("<div class=\"item\">\n"); str.Append("<a class=\"" + this.NormalLinkCssClass + "\" href=\"" + UrlConfig.Prepare_User_Profile_Url(ph.UserName, this.isAdmin) + "\" title=\"" + ph.UserName + "\">" + ph.UserName + "</a>"); str.Append(" " + ph.Title); str.Append("</div>\n"); } // activity str.Append(ph.Activity); // action section str.Append("<div id=\"" + ph.ActivityID + "\" class=\"item\">\n"); str.Append("<a id=\"ans_" + ph.ActivityID + "\" href=\"#\" title=\"Post Comment\" class=\"" + this.ActionLinkCssClass + " acmt\">Comment</a> . "); str.Append("<a href=\"#\" title=\"Like this post\" class=\"" + this.ActionLinkCssClass + " actlike\">Like</a> . "); str.Append("<a href=\"#\" title=\"Dislike this post\" class=\"" + this.ActionLinkCssClass + " actdislike\">Dislike</a>"); if (Config.isFeature_Date() && this.ShowDate) { str.Append(" . "); str.Append("<span class=\"" + this.LightCssClass + "\">" + UtilityBLL.Generate_Date(ph.Added_Date, this.DateFormat) + "</span>"); } // statistics str.Append(" . <span class=\"simplehover2 ui-corner-all mini-text ldcmt\"><span><i class=\"icon-thumbs-up\"></i> <span id=\"actlk_" + ph.ActivityID + "\">" + ph.Liked + "</span></span> <span><i class=\"icon-thumbs-down\"></i> <span id=\"actdlk_" + ph.ActivityID + "\">" + ph.Disliked + "</span></span> <span><i class=\"icon-comment\"></i> <span id=\"actcmts_" + ph.ActivityID + "\">" + ph.Comments + "</span></span></span>\n"); str.Append("</div>\n"); // Added return(str.ToString()); }
private string ProcessContent(UserActivity_Struct ph) { StringBuilder str = new StringBuilder(); // title or caption str.Append("<span id=\"actusr_" + ph.ActivityID + "\" style=\"display:none;\">" + ph.UserName + "</span>"); if (this.ShowTitle && ph.Title !="") { // user link str.Append("<div class=\"item\">\n"); str.Append("<a class=\"" + this.NormalLinkCssClass + "\" href=\"" + UrlConfig.Prepare_User_Profile_Url(ph.UserName, this.isAdmin) + "\" title=\"" + ph.UserName + "\">" + ph.UserName + "</a>"); str.Append(" " + ph.Title); str.Append("</div>\n"); } // activity str.Append(ph.Activity); // action section str.Append("<div id=\"" + ph.ActivityID + "\" class=\"item\">\n"); str.Append("<a id=\"ans_" + ph.ActivityID + "\" href=\"#\" title=\"Post Comment\" class=\"" + this.ActionLinkCssClass + " acmt\">Comment</a> . "); str.Append("<a href=\"#\" title=\"Like this post\" class=\"" + this.ActionLinkCssClass + " actlike\">Like</a> . "); str.Append("<a href=\"#\" title=\"Dislike this post\" class=\"" + this.ActionLinkCssClass + " actdislike\">Dislike</a>"); if (Config.isFeature_Date() && this.ShowDate) { str.Append(" . "); str.Append("<span class=\"" + this.LightCssClass + "\">" + UtilityBLL.Generate_Date(ph.Added_Date, this.DateFormat) + "</span>"); } // statistics str.Append(" . <span class=\"simplehover2 ui-corner-all mini-text ldcmt\"><span><i class=\"icon-thumbs-up\"></i> <span id=\"actlk_" + ph.ActivityID + "\">" + ph.Liked + "</span></span> <span><i class=\"icon-thumbs-down\"></i> <span id=\"actdlk_" + ph.ActivityID + "\">" + ph.Disliked + "</span></span> <span><i class=\"icon-comment\"></i> <span id=\"actcmts_" + ph.ActivityID + "\">" + ph.Comments + "</span></span></span>\n"); str.Append("</div>\n"); // Added return str.ToString(); }
private string ProcessThumb(UserActivity_Struct ph) { StringBuilder str = new StringBuilder(); string _user = ph.PosterUserName; if (_user == "") _user = ph.UserName; string image_src = UrlConfig.Return_User_Profile_Photo(_user, ph.PictureName, 0, 0); str.Append("<a class=\"thumbnail\" style=\"width:" + this.Width + "px;\" href=\"" + UrlConfig.Prepare_User_Profile_Url(_user, this.isAdmin) + "\" title=\"" + _user + "\">"); // thumb link setup str.Append("<img src=\"" + image_src + "\" height=\"" + this.Height + "\" width=\"" + this.Width + "\">"); str.Append("</a>"); return str.ToString(); }
public string CommentOrder = "c.level desc"; // c.clevel order must be used in case reply is on. "points desc, added_date desc"; #endregion public string Process(UserActivity_Struct ph) { StringBuilder str = new StringBuilder(); string _bxwidth = "100%"; if (this.BoxWidth > 0) _bxwidth = this.BoxWidth + "px;"; string _cntwidth = ""; if (this.BoxWidth == 0) _cntwidth = "99%"; else { int containerwidth = this.BoxWidth; _cntwidth = containerwidth + "px"; } str.Append("<div id=\"ansid_" + ph.ActivityID + "\" class=\"" + this.BoxCssClass + " anscmt\" style=\"float:left; width:" + _bxwidth + "\">\n"); if (this.LoggedInUserName != "") { // if currently logged in user is author of post or author of group if (this.LoggedInUserName == ph.UserName || this.LoggedInUserName == ph.PosterUserName) { // remove link str.Append("<div id=\"del_post_" + ph.ActivityID + "\" class=\"itm_cross\"\" style=\"display:none;\"><a id=\"rem_post_" + ph.ActivityID + "\" class=\"rempost " + this.BoldLinkCssClass + "\" title=\"remove post\" href=\"#\">×</a></div>\n"); } } string container = "class=\"item_pad_2\""; if (this.isHoverEffect) container = "class=\"" + this.HoverCssClass + "\""; str.Append("<div " + container + " style=\"width:" + _cntwidth + "\">\n"); str.Append("<div id=\"pmsg_" + ph.ActivityID + "\"></div>\n"); // for displaying messages if (this.ShowProfileThumb) { // Content on left side of thumb str.Append("<div style=\"float:left; width:" + this.LeftWidth + "%;\">\n"); str.Append(ProcessThumb(ph)); str.Append("</div>\n"); str.Append("<div style=\"float:right; width:" + this.RightWidth + "%;\">\n"); str.Append(ProcessContent(ph)); str.Append("</div>\n"); str.Append("<div class=\"clear\"></div>\n"); } else { str.Append(ProcessContent(ph)); } str.Append("</div>\n"); // close sub box // load and list comments // below hover post section //str.Append("<div id=\"cmtitm_" + ph.ActivityID + "\"></div>\n"); // div where activity comments will be loading. str.Append(ProcessAnswerComments(ph.ActivityID, ph.Comments, ph.UserName)); str.Append("</div>\n"); // close main box return str.ToString(); }
// The following function load specific number of records without any pagination. e.g Fetching top 8 recently added photos // Non Cache Version public static List <UserActivity_Struct> Fetch_Activities(string term, string UserName, int Month, int Year, string order, int records, int datefilter, int PageNumber) { SqlConnection con = new SqlConnection(Config.ConnectionString); if (con.State != ConnectionState.Open) { con.Open(); } List <UserActivity_Struct> _items = new List <UserActivity_Struct>(); UserActivity_Struct _item; // generate sql query string logic = ActivityBLL.Process_Activity_V3_Logic(term, UserName, Month, Year, datefilter); StringBuilder str = new StringBuilder(); StringBuilder query = new StringBuilder(); query.Append("u.picturename,p.activityid,p.username,p.poster_username,p.activity,p.title,p.added_date,p.liked,p.disliked,u.picturename,p.comments FROM useractivities as p Inner join users as u on u.username=p.poster_username " + logic); switch (Site_Settings.Pagination_Type) { case 0: // SQL SERVER 2005 or Later Supported Query str.Append(Pagination_Process.Prepare_SQLSERVER2005_Pagination(query.ToString(), order, PageNumber, records)); break; case 1: // MySQL Supported Query string mysql_query = "SELECT " + query.ToString() + " ORDER BY " + order; str.Append(Pagination_Process.Prepare_MySQL_Pagination(mysql_query, PageNumber, records)); break; case 2: // SQL SERVER 2000 Supported Query string normal_query = "SELECT " + query.ToString() + " ORDER BY " + order; str.Append(normal_query); break; } // execute sql query SqlCommand cmd = new SqlCommand(str.ToString(), con); cmd.Parameters.Add(new SqlParameter("@username", UserName)); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { _item = new UserActivity_Struct(); _item.ActivityID = (long)reader["activityid"]; _item.UserName = reader["username"].ToString(); _item.Title = reader["title"].ToString(); _item.Activity = reader["activity"].ToString(); _item.Added_Date = (DateTime)reader["added_date"]; _item.Liked = Convert.ToInt32(reader["liked"]); _item.Disliked = Convert.ToInt32(reader["disliked"]); _item.Comments = Convert.ToInt32(reader["comments"]); _item.PictureName = reader["picturename"].ToString(); _item.PosterUserName = reader["poster_username"].ToString(); _items.Add(_item); } reader.Close(); con.Close(); con.Dispose(); return(_items); }
public string CommentOrder = "c.level desc"; // c.clevel order must be used in case reply is on. "points desc, added_date desc"; #endregion public string Process(UserActivity_Struct ph) { StringBuilder str = new StringBuilder(); string _bxwidth = "100%"; if (this.BoxWidth > 0) { _bxwidth = this.BoxWidth + "px;"; } string _cntwidth = ""; if (this.BoxWidth == 0) { _cntwidth = "99%"; } else { int containerwidth = this.BoxWidth; _cntwidth = containerwidth + "px"; } str.Append("<div id=\"ansid_" + ph.ActivityID + "\" class=\"" + this.BoxCssClass + " anscmt\" style=\"float:left; width:" + _bxwidth + "\">\n"); if (this.LoggedInUserName != "") { // if currently logged in user is author of post or author of group if (this.LoggedInUserName == ph.UserName || this.LoggedInUserName == ph.PosterUserName) { // remove link str.Append("<div id=\"del_post_" + ph.ActivityID + "\" class=\"itm_cross\"\" style=\"display:none;\"><a id=\"rem_post_" + ph.ActivityID + "\" class=\"rempost " + this.BoldLinkCssClass + "\" title=\"remove post\" href=\"#\">×</a></div>\n"); } } string container = "class=\"item_pad_2\""; if (this.isHoverEffect) { container = "class=\"" + this.HoverCssClass + "\""; } str.Append("<div " + container + " style=\"width:" + _cntwidth + "\">\n"); str.Append("<div id=\"pmsg_" + ph.ActivityID + "\"></div>\n"); // for displaying messages if (this.ShowProfileThumb) { // Content on left side of thumb str.Append("<div style=\"float:left; width:" + this.LeftWidth + "%;\">\n"); str.Append(ProcessThumb(ph)); str.Append("</div>\n"); str.Append("<div style=\"float:right; width:" + this.RightWidth + "%;\">\n"); str.Append(ProcessContent(ph)); str.Append("</div>\n"); str.Append("<div class=\"clear\"></div>\n"); } else { str.Append(ProcessContent(ph)); } str.Append("</div>\n"); // close sub box // load and list comments // below hover post section //str.Append("<div id=\"cmtitm_" + ph.ActivityID + "\"></div>\n"); // div where activity comments will be loading. str.Append(ProcessAnswerComments(ph.ActivityID, ph.Comments, ph.UserName)); str.Append("</div>\n"); // close main box return(str.ToString()); }
// The following function load specific number of records without any pagination. e.g Fetching top 8 recently added photos // Non Cache Version public static List<UserActivity_Struct> Fetch_Activities(string term, string UserName, int Month, int Year, string order, int records, int datefilter, int PageNumber) { SqlConnection con = new SqlConnection(Config.ConnectionString); if (con.State != ConnectionState.Open) con.Open(); List<UserActivity_Struct> _items = new List<UserActivity_Struct>(); UserActivity_Struct _item; // generate sql query string logic = ActivityBLL.Process_Activity_V3_Logic(term, UserName, Month, Year, datefilter); StringBuilder str = new StringBuilder(); StringBuilder query = new StringBuilder(); query.Append("u.picturename,p.activityid,p.username,p.poster_username,p.activity,p.title,p.added_date,p.liked,p.disliked,u.picturename,p.comments FROM useractivities as p Inner join users as u on u.username=p.poster_username " + logic); switch (Site_Settings.Pagination_Type) { case 0: // SQL SERVER 2005 or Later Supported Query str.Append(Pagination_Process.Prepare_SQLSERVER2005_Pagination(query.ToString(), order, PageNumber, records)); break; case 1: // MySQL Supported Query string mysql_query = "SELECT " + query.ToString() + " ORDER BY " + order; str.Append(Pagination_Process.Prepare_MySQL_Pagination(mysql_query, PageNumber, records)); break; case 2: // SQL SERVER 2000 Supported Query string normal_query = "SELECT " + query.ToString() + " ORDER BY " + order; str.Append(normal_query); break; } // execute sql query SqlCommand cmd = new SqlCommand(str.ToString(), con); cmd.Parameters.Add(new SqlParameter("@username", UserName)); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { _item = new UserActivity_Struct(); _item.ActivityID = (long)reader["activityid"]; _item.UserName = reader["username"].ToString(); _item.Title = reader["title"].ToString(); _item.Activity = reader["activity"].ToString(); _item.Added_Date = (DateTime)reader["added_date"]; _item.Liked = Convert.ToInt32(reader["liked"]); _item.Disliked = Convert.ToInt32(reader["disliked"]); _item.Comments = Convert.ToInt32(reader["comments"]); _item.PictureName = reader["picturename"].ToString(); _item.PosterUserName = reader["poster_username"].ToString(); _items.Add(_item); } reader.Close(); con.Close(); con.Dispose(); return _items; }
//************************************************************************************** // Close Core Engine for generating cached and non cached photo listings //************************************************************************************** #endregion // Fetch user activies public static List<UserActivity_Struct> Fetch_Activies(string UserName) { SqlConnection con = new SqlConnection(Config.ConnectionString); if (con.State != ConnectionState.Open) con.Open(); List<UserActivity_Struct> _items = new List<UserActivity_Struct>(); UserActivity_Struct _item; // generate sql query StringBuilder str = new StringBuilder(); // execute sql query SqlCommand cmd = new SqlCommand("SELECT p.activityid,p.username,p.poster_username,p.title,p.activity,p.added_date,p.liked,p.disliked,u.picturename FROM useractivities as p INNER JOIN users as u on u.username=p.poster_username WHERE p.username=@uname AND u.isenabled=1 Order By p.added_date desc, p.activityid desc", con); cmd.CommandType = CommandType.Text; cmd.Parameters.Add(new SqlParameter("@uname", UserName)); SqlDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { _item = new UserActivity_Struct(); _item.ActivityID = (long)reader["activityid"]; _item.UserName = reader["username"].ToString(); _item.Activity = reader["activity"].ToString(); _item.Added_Date = (DateTime)reader["added_date"]; _item.Liked = Convert.ToInt32(reader["liked"]); _item.Disliked = Convert.ToInt32(reader["disliked"]); _item.PosterUserName = reader["poster_username"].ToString(); _items.Add(_item); } reader.Close(); con.Close(); con.Dispose(); return _items; }