Example #1
0
    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());
 }
Example #3
0
    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()));
    }
Example #4
0
    //**************************************************************************************
    // 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);
    }
Example #5
0
    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>&nbsp;.&nbsp;");
        str.Append("<a href=\"#\" title=\"Like this post\" class=\"" + this.ActionLinkCssClass + " actlike\">Like</a>&nbsp;.&nbsp;");
        str.Append("<a href=\"#\" title=\"Dislike this post\" class=\"" + this.ActionLinkCssClass + " actdislike\">Dislike</a>");
        if (Config.isFeature_Date() && this.ShowDate)
        {
            str.Append("&nbsp;.&nbsp;");
            str.Append("<span class=\"" + this.LightCssClass + "\">" + UtilityBLL.Generate_Date(ph.Added_Date, this.DateFormat) + "</span>");
        }
        // statistics
        str.Append("&nbsp.&nbsp;<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>&nbsp;<span><i class=\"icon-thumbs-down\"></i> <span id=\"actdlk_" + ph.ActivityID + "\">" + ph.Disliked + "</span></span>&nbsp;<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>&nbsp;.&nbsp;");
     str.Append("<a href=\"#\" title=\"Like this post\" class=\"" + this.ActionLinkCssClass + " actlike\">Like</a>&nbsp;.&nbsp;");
     str.Append("<a href=\"#\" title=\"Dislike this post\" class=\"" + this.ActionLinkCssClass + " actdislike\">Dislike</a>");
     if (Config.isFeature_Date() && this.ShowDate)
     {
         str.Append("&nbsp;.&nbsp;");
         str.Append("<span class=\"" + this.LightCssClass + "\">" + UtilityBLL.Generate_Date(ph.Added_Date, this.DateFormat) + "</span>");
     }
     // statistics
     str.Append("&nbsp.&nbsp;<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>&nbsp;<span><i class=\"icon-thumbs-down\"></i> <span id=\"actdlk_" + ph.ActivityID + "\">" + ph.Disliked + "</span></span>&nbsp;<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=\"#\">&times;</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();
    }
Example #9
0
    // 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);
    }
Example #10
0
    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=\"#\">&times;</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;
    }