コード例 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["loggedIn"] == null)
            {
                Response.Redirect(ResolveUrl("~/Login.aspx"));
            }

            int user_type = Convert.ToInt32(Session["type"]);

            if (user_type == 2) //normal user dont allow
            {
                Response.Redirect(ResolveUrl("~/Main.aspx"));
            }

            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT *, User_Main.Fname, User_Main.Lname FROM Moderation" +
                                                         " INNER JOIN User_Main ON User_Main.ID_Num = Moderation.ID_Num");

            while (reader.Read())
            {
                Report report = new Report();
                report.id        = Guid.Parse(reader["Id"].ToString());
                report.post_id   = Guid.Parse(reader["PostId"].ToString());
                report.post_type = Convert.ToInt32(reader["Type"]);
                switch (report.post_type)
                {
                case 0:
                    report.post_type_str = "Gallery";
                    report.link          = "~/Gallery/Main.aspx";
                    break;

                case 1:
                    report.post_type_str = "Board";
                    report.link          = "~/Board/View/" + report.post_id;
                    break;

                case 2:
                    report.post_type_str = "Blog";
                    report.link          = "~/Blog/View/" + report.post_id;
                    break;

                case 3:
                    report.post_type_str = "Intern";
                    report.link          = "~/Intern/Main.aspx";
                    break;

                case 4:
                    report.post_type_str = "Connect";
                    report.link          = "~/Connect/Main.aspx";
                    break;
                }
                report.reporter_id   = Guid.Parse(reader["ID_Num"].ToString());
                report.reporter_name = reader["Fname"] + " " + reader["Lname"];
                report.date          = DateTime.Parse(reader["Date"].ToString());
                report.comment       = reader["Comment"].ToString();
                report.status        = Convert.ToInt32(reader["Mod_Status"].ToString());
                reports.Add(report);
            }

            reader.Close();
        }
コード例 #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["loggedIn"] == null)
            {
                Response.Redirect("Login.aspx");
            }

            if (!IsPostBack)
            {
                List <SqlParameter> parameters = new List <SqlParameter>();
                parameters.Add(new SqlParameter("uid", Session["uid"]));
                SqlDataReader reader = SqlUtil.ExecuteReader("SELECT * FROM User_Main WHERE ID_Num = @uid", parameters);
                if (!reader.Read()) //this should never happen
                {
                    Response.Redirect("Main.aspx");
                    reader.Close();
                    return;
                }

                Uid.Text       = reader["ID_Num"].ToString();
                FirstName.Text = reader["Fname"].ToString();
                LastName.Text  = reader["Lname"].ToString();
                Major.Text     = reader["Major"].ToString();
                Classification.SelectedValue = reader["Classification"].ToString();
                Phone.Text          = reader["Phone"].ToString();
                OrgAffiliation.Text = reader["Org_Affiliation"].ToString();
                reader.Close();

                Password.Text     = "";
                NewPassword.Text  = "";
                NewPassword2.Text = "";
            }
        }
コード例 #3
0
        protected void SecuritySubmit_Click(object sender, EventArgs e)
        {
            List <SqlParameter> parameters = new List <SqlParameter>();

            parameters.Add(new SqlParameter("uid", Session["uid"]));
            parameters.Add(new SqlParameter("password", Password.Text));

            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT * FROM User_Main WHERE Password = @password AND ID_NUM = @uid", parameters);

            if (!reader.Read())
            {
                Error.Text = "Incorrect password.";
                reader.Close();
                return;
            }

            reader.Close();

            parameters.Clear();
            parameters.Add(new SqlParameter("password", NewPassword.Text));
            parameters.Add(new SqlParameter("uid", Session["uid"]));
            SqlUtil.ExecuteNonQuery("UPDATE User_Main SET Password = @password WHERE ID_Num = @uid", parameters);

            Password.Text     = "";
            NewPassword.Text  = "";
            NewPassword2.Text = "";
        }
コード例 #4
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT TOP 50 *, User_Main.Fname, User_Main.Lname FROM Blog_Post" +
                                                         " INNER JOIN User_Main ON User_Main.ID_Num = Blog_Post.ID_Num");

            while (reader.Read())
            {
                BlogPost post = new BlogPost();
                post.blogID      = Guid.Parse(reader["BlogID"].ToString());
                post.author_uid  = Guid.Parse(reader["ID_Num"].ToString());
                post.author_name = reader["Fname"] + " " + reader["Lname"];
                post.title       = reader["Title"].ToString();
                post.body        = reader["Body"].ToString();
                posts.Add(post);
            }

            reader.Close();

            /*
             * if (Session["loggedIn"] != null)
             * {
             *  SqlDataReader r = SqlUtil.ExecuteReader("SELECT * FROM Blog_Post");
             *  while (r.Read())
             *  {
             *      BlogPost post = new BlogPost();
             *      post.blogID = Guid.Parse(reader["BlogID"].ToString());
             *      post.author_uid = Guid.Parse(reader["ID_Num"].ToString());
             *      post.title = reader["Title"].ToString();
             *      post.body = reader["Body"].ToString();
             *      follow_posts.Add(post);
             *  }
             *  r.Close();
             * }
             */
        }
コード例 #5
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        void build_data()
        {
            string          query    = "select * from [Board_Post]";
            SqlDataReader   reader   = SqlUtil.ExecuteReader(query);
            List <data_row> all_rows = new List <data_row>();
            string          board    = "";

            while (reader.Read())
            {
                if (reader.GetByte(4) == 0)
                {
                    board = "gives_board";
                }
                else
                if (reader.GetByte(4) == 1)
                {
                    board = "project_board";
                }
                else
                if (reader.GetByte(4) == 2)
                {
                    board = "poll_board";
                }



                all_rows.Add(new data_row(board, reader.GetString(2), reader.GetDateTime(5), (Guid)reader["BpostID"]));
            }

            reader.Close();
            convert_rows_to_string_and_publish(ref all_rows);
        }
コード例 #6
0
        protected Boolean has_voted()
        {
            List <SqlParameter> p = new List <SqlParameter>();

            p.Add(new SqlParameter("@post_id", post_id));
            p.Add(new SqlParameter("uid", (Guid)Session["uid"]));
            SqlDataReader reader = SqlUtil.ExecuteReader("select * from [poll_options] inner join [votes] on [poll_options].Option_ID=[Votes].Option_ID where [poll_options].BpostID=@post_id and [votes].ID_Num=@uid", p);

            while (reader.Read())
            {
                Boolean report;
                if (reader.GetValue(0) != null)
                {
                    report = true;
                    reader.Close();
                }
                else
                {
                    report = false;
                    reader.Close();
                }

                return(report);
            }

            reader.Close();
            return(false);
        }
コード例 #7
0
ファイル: Login.aspx.cs プロジェクト: endoffile78/J-Team
        protected void submit_Click(object sender, EventArgs e)
        {
            Error.Text = "";
            List <SqlParameter> parameters = new List <SqlParameter>();

            parameters.Add(new SqlParameter("@email", email.Text));
            parameters.Add(new SqlParameter("@password", password.Text)); //TODO: hash the password
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT ID_Num, User_Type FROM User_Main WHERE Email = @email AND Password = @password", parameters);

            if (reader.Read())
            {
                Guid uid  = (Guid)reader["ID_Num"];
                int  type = reader.GetByte(1);
                Session.Add("uid", uid);
                Session.Add("type", type);
                Session.Add("loggedIn", true);
                reader.Close();
                Response.Redirect("Main.aspx");
            }
            else
            {
                Error.Text = "A user with that email and password combination does not exist.";
            }
            reader.Close();
        }
コード例 #8
0
ファイル: Register.aspx.cs プロジェクト: endoffile78/J-Team
        protected void submit_Click(object sender, EventArgs e)
        {
            Error.Text = "";
            List <SqlParameter> check_parameters = new List <SqlParameter>();

            check_parameters.Add(new SqlParameter("@email", email.Text));
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT * FROM User_Main WHERE Email = @email", check_parameters);

            if (reader.Read())
            {
                Error.Text = "A user with that email alreader exists.";
                reader.Close();
                return;
            }

            reader.Close();

            List <SqlParameter> parameters = new List <SqlParameter>();

            parameters.Add(new SqlParameter("@email", email.Text));
            parameters.Add(new SqlParameter("@fname", fname.Text));
            parameters.Add(new SqlParameter("@lname", lname.Text));
            parameters.Add(new SqlParameter("@password", password.Text));
            int rows = SqlUtil.ExecuteNonQuery("INSERT INTO User_Main (Email, User_Type, Fname, Lname, Last_Login, Password) VALUES (@email, 2, @fname, @lname, GETDATE(), @password)", parameters);

            if (rows == 1)
            {
                Response.Redirect("Main.aspx");
            }
        }
コード例 #9
0
ファイル: View.aspx.cs プロジェクト: endoffile78/J-Team
        protected void Page_Load(object sender, EventArgs e)
        {
            IList <string> segments = Request.GetFriendlyUrlSegments();

            if (!Guid.TryParse(segments[0], out blogID))
            {
                Response.Redirect(ResolveUrl("PostNotFound.aspx"));
            }

            List <SqlParameter> parameters = new List <SqlParameter>();

            parameters.Add(new SqlParameter("blogid", blogID));

            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT Blog_Post.*, User_Main.Fname, User_Main.Lname FROM Blog_Post" +
                                                         " INNER JOIN User_Main ON Blog_Post.ID_Num = User_Main.ID_Num" +
                                                         " WHERE BlogID = @blogid", parameters);

            if (!reader.Read())
            {
                reader.Close();
                Response.Redirect("PostNotFound.aspx");
                return;
            }

            title       = reader["Title"].ToString();
            body        = reader["Body"].ToString();
            author_name = reader["Fname"] + " " + reader["Lname"];
            author_uid  = Guid.Parse(reader["ID_Num"].ToString());
            date        = DateTime.Parse(reader["Date"].ToString());

            if (Session["uid"] != null)
            {
                if (Session["uid"].ToString() == reader["ID_Num"].ToString())
                {
                    author = true;
                }
            }

            reader.Close();

            parameters.Clear();
            parameters.Add(new SqlParameter("blogid", blogID));

            SqlDataReader r = SqlUtil.ExecuteReader("SELECT * FROM Post_Comment WHERE BlogID = @blogid", parameters);

            while (r.Read())
            {
                Comment comment = new Comment();
                comment.name    = r["Name"].ToString();
                comment.comment = r["Comment"].ToString();
                comments.Add(comment);
            }

            r.Close();
        }
コード例 #10
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void majorCDrop_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT DISTINCT Major FROM Job_Posting");

            while (reader.Read())
            {
                string major = reader["Major"].ToString();
                majorCDrop.Items.Add(new ListItem(major, major));
            }
            reader.Close();
        }
コード例 #11
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void cityCDrop_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT DISTINCT City FROM Job_Posting");

            while (reader.Read())
            {
                string city = reader["City"].ToString();
                cityCDrop.Items.Add(new ListItem(city, city));
            }
            reader.Close();
        }
コード例 #12
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void termDrop_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT DISTINCT Term FROM Intern_Posting");

            while (reader.Read())
            {
                string term = reader["Term"].ToString();
                termDrop.Items.Add(new ListItem(term, term));
            }
            reader.Close();
        }
コード例 #13
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void companyDrop_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT DISTINCT Company FROM Intern_Posting");

            while (reader.Read())
            {
                string company = reader["Company"].ToString();
                companyDrop.Items.Add(new ListItem(company, company));
            }
            reader.Close();
        }
コード例 #14
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void collegeCDrop_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT DISTINCT College FROM Job_Posting");

            while (reader.Read())
            {
                string college = reader["College"].ToString();
                collegeCDrop.Items.Add(new ListItem(college, college));
            }
            reader.Close();
        }
コード例 #15
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void positionCDrop_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT DISTINCT Position FROM Job_Posting");

            while (reader.Read())
            {
                string position = reader["Position"].ToString();
                positionCDrop.Items.Add(new ListItem(position, position));
            }
            reader.Close();
        }
コード例 #16
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void stateCDrop_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT DISTINCT State FROM Job_Posting");

            while (reader.Read())
            {
                string state = reader["State"].ToString();
                stateCDrop.Items.Add(new ListItem(state, state));
            }
            reader.Close();
        }
コード例 #17
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void classificationDrop_Load(object sender, EventArgs e)
        {
            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT DISTINCT Classification FROM Intern_Posting");

            while (reader.Read())
            {
                string classification = reader["Classification"].ToString();
                classificationDrop.Items.Add(new ListItem(classification, classification));
            }
            reader.Close();
        }
コード例 #18
0
ファイル: Main.aspx.cs プロジェクト: Jrjohnsonhowland/J-Team
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                List <SqlParameter> parameters = new List <SqlParameter>();
                SqlDataReader       reader     = SqlUtil.ExecuteReader("SELECT College FROM Intern_Posting", parameters);

                collegedrop.Items.Insert(0, new ListItem("Pick a college", "0"));
                collegedrop.SelectedIndex = 0;

                while (reader.Read())
                {
                    string college = reader["College"].ToString();
                    collegedrop.Items.Add(new ListItem(college, college));
                }

                reader.Close();
            }
        }
コード例 #19
0
ファイル: Main.aspx.cs プロジェクト: Jrjohnsonhowland/J-Team
        string build_data()
        { // built for testing purposes. Soon will be rewritten for to read the database and build a data structure from it.
            string test_string = "";
            string query       = "select schema_name(t.schema_id) as schema_name, t.name as table_name, t.create_date, t.modify_date from sys.tables t order by schema_name, table_name; ";

            SqlDataReader reader = SqlUtil.ExecuteReader(query);

            int i = 0;

            while (reader.Read())
            {
                test_string += reader.GetString(0);
                i++;
            }

            reader.Close();

            return(test_string);
            //placeholder for reading database
        }
コード例 #20
0
        protected void Page_Load(object sender, EventArgs e)
        {
            IList <string> segments = Request.GetFriendlyUrlSegments();

            id = segments[0];

            if (!IsPostBack)
            {
                List <SqlParameter> parameters = new List <SqlParameter>();
                parameters.Add(new SqlParameter("id", id));
                SqlDataReader reader = SqlUtil.ExecuteReader("SELECT * FROM Moderation WHERE Id = @id", parameters);
                if (!reader.Read())
                {
                    Response.Redirect("Main.aspx");
                }

                ModStatus.SelectedIndex = Convert.ToInt32(reader["Mod_Status"]);
                PostId.Text             = reader["Id"].ToString();

                reader.Close();
            }
        }
コード例 #21
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["loggedIn"] == null)
            {
                Response.Redirect(ResolveUrl("~/Login.aspx"));
            }

            IList <string> segments = Request.GetFriendlyUrlSegments();

            blogID = segments[0];

            if (!IsPostBack)
            {
                Guid id;
                if (!Guid.TryParse(blogID, out id))
                {
                    Response.Redirect(ResolveUrl("PostNotFound.aspx"));
                }

                List <SqlParameter> parameters = new List <SqlParameter>();
                parameters.Add(new SqlParameter("blogid", blogID));
                SqlDataReader reader = SqlUtil.ExecuteReader("SELECT * FROM Blog_Post WHERE BlogID = @blogid", parameters);
                if (!reader.Read())
                {
                    Response.Redirect(ResolveUrl("PostNotFound.aspx"));
                }

                if (Session["uid"].ToString() != reader["ID_Num"].ToString())
                {
                    reader.Close();
                    Response.Redirect("Main.aspx");
                }

                title.Text = reader["Title"].ToString();
                Body.Text  = reader["Body"].ToString();

                reader.Close();
            }
        }
コード例 #22
0
        protected void Page_Load(object sender, EventArgs e)
        {
            require_login();

            IList <string> seg = Request.GetFriendlyUrlSegments();

            if (!Guid.TryParse(seg[0], out post_id))
            {
                Response.Redirect("/Board/404.aspx");
            }


            List <SqlParameter> p = new List <SqlParameter>();

            p.Add(new SqlParameter("@post_id", post_id));
            SqlDataReader reader = SqlUtil.ExecuteReader("select * from board_post where BpostID=@post_id", p);

            if (!reader.Read())
            {
                reader.Close();
                Response.Redirect("404.aspx");
                return;
            }

            Byte[] bytes = (Byte[])reader["Attachments"];


            view_title.Text       = (string)reader["Title"];
            board                 = (byte)reader["Board"];
            view_description.Text = (string)reader["Description"];

            if (bytes.Length > 0)
            {
                string str = Convert.ToBase64String(bytes, 0, bytes.Length);
                view_image.ImageUrl      = "data:image/png;base64," + str;
                view_image.Visible       = true;
                view_image_label.Visible = true;
            }
            reader.Close();

            if (board == 2)
            {
                p.Clear();
                p.Add(new SqlParameter("@post_id", post_id));
                SqlDataReader reader2 = SqlUtil.ExecuteReader("select * from poll_options where BpostID=@post_id", p);
                option_list = new List <string>();
                id_list     = new List <Guid>();
                int i = 0;
                while (reader2.Read())
                {
                    option_list.Add(reader2.GetString(2));
                    id_list.Add(reader2.GetGuid(0));

                    i++;
                }
                while (i < 10)
                {
                    option_list.Add("");
                    i++;//good fix for bad code
                }
                reader2.Close();


                build_poll_radios();
            }
        }
コード例 #23
0
        protected void build_poll_radios()
        {
            List <SqlParameter> p     = new List <SqlParameter>();
            List <double>       votes = new List <double>();
            int i = 0;

            foreach (Guid op in id_list)
            {
                if (option_list[i] != "")
                {
                    p.Clear();
                    p.Add(new SqlParameter("@option_id", op));
                    SqlDataReader reader = SqlUtil.ExecuteReader("select * from Votes where Option_ID=@option_id", p);
                    DataTable     dt     = new DataTable();
                    dt.Load(reader);
                    reader.Close();
                    votes.Add(dt.Rows.Count);
                }
                i++;
            }


            if (!has_voted())
            {
                if (option_list[0] != "")
                {
                    option1.Text = option_list[0]; option1.Visible = true;
                }
                if (option_list[1] != "")
                {
                    option2.Text = option_list[1]; option2.Visible = true;
                }
                if (option_list[2] != "")
                {
                    option3.Text = option_list[2]; option3.Visible = true;
                }
                if (option_list[3] != "")
                {
                    option4.Text = option_list[3]; option4.Visible = true;
                }
                if (option_list[4] != "")
                {
                    option5.Text = option_list[4]; option5.Visible = true;
                }
                if (option_list[5] != "")
                {
                    option6.Text = option_list[5]; option6.Visible = true;
                }
                if (option_list[6] != "")
                {
                    option7.Text = option_list[6]; option7.Visible = true;
                }
                if (option_list[7] != "")
                {
                    option8.Text = option_list[7]; option8.Visible = true;
                }
                if (option_list[8] != "")
                {
                    option9.Text = option_list[8]; option9.Visible = true;
                }
                if (option_list[9] != "")
                {
                    option10.Text = option_list[9]; option10.Visible = true;
                }
                submit_vote.Visible = true;
            }
            else
            {
                double total = 0;
                foreach (double vo in votes)
                {
                    total += vo;
                }
                int j = 0;
                if (option_list[j] != "")
                {
                    poll_option_desc1.Visible    = true;
                    poll_option_desc1.Text       = "  " + option_list[j];
                    poll_option_percent1.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent1.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent1.Text = "0%";
                    }
                    poll_option_votes1.Visible = true;
                    poll_option_votes1.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar1.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar1.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar1.Style.Add("width", "0%");
                    }
                    j++;
                }
                if (option_list[j] != "")
                {
                    poll_option_desc2.Visible    = true;
                    poll_option_desc2.Text       = "  " + option_list[j];
                    poll_option_percent2.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent2.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent2.Text = "0%";
                    }
                    poll_option_votes2.Visible = true;
                    poll_option_votes2.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar2.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar2.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar2.Style.Add("width", "0%");
                    }
                    j++;
                }
                if (option_list[j] != "")
                {
                    poll_option_desc3.Visible    = true;
                    poll_option_desc3.Text       = "  " + option_list[j];
                    poll_option_percent3.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent3.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent3.Text = "0%";
                    }
                    poll_option_votes3.Visible = true;
                    poll_option_votes3.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar3.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar3.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar3.Style.Add("width", "0%");
                    }
                    j++;
                }
                if (option_list[j] != "")
                {
                    poll_option_desc4.Visible    = true;
                    poll_option_desc4.Text       = "  " + option_list[j];
                    poll_option_percent4.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent4.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent4.Text = "0%";
                    }
                    poll_option_votes4.Visible = true;
                    poll_option_votes4.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar4.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar4.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar4.Style.Add("width", "0%");
                    }
                    j++;
                }
                if (option_list[j] != "")
                {
                    poll_option_desc5.Visible    = true;
                    poll_option_desc5.Text       = "  " + option_list[j];
                    poll_option_percent5.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent5.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent5.Text = "0%";
                    }
                    poll_option_votes5.Visible = true;
                    poll_option_votes5.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar5.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar5.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar5.Style.Add("width", "0%");
                    }
                    j++;
                }
                if (option_list[j] != "")
                {
                    poll_option_desc6.Visible    = true;
                    poll_option_desc6.Text       = "  " + option_list[j];
                    poll_option_percent6.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent6.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent6.Text = "0%";
                    }
                    poll_option_votes6.Visible = true;
                    poll_option_votes6.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar6.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar6.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar6.Style.Add("width", "0%");
                    }
                    j++;
                }
                if (option_list[j] != "")
                {
                    poll_option_desc7.Visible    = true;
                    poll_option_desc7.Text       = "  " + option_list[j];
                    poll_option_percent7.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent7.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent7.Text = "0%";
                    }
                    poll_option_votes7.Visible = true;
                    poll_option_votes7.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar7.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar7.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar7.Style.Add("width", "0%");
                    }
                    j++;
                }
                if (option_list[j] != "")
                {
                    poll_option_desc8.Visible    = true;
                    poll_option_desc8.Text       = "  " + option_list[j];
                    poll_option_percent8.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent8.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent8.Text = "0%";
                    }
                    poll_option_votes8.Visible = true;
                    poll_option_votes8.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar8.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar8.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar8.Style.Add("width", "0%");
                    }
                    j++;
                }
                if (option_list[j] != "")
                {
                    poll_option_desc9.Visible    = true;
                    poll_option_desc9.Text       = "  " + option_list[j];
                    poll_option_percent9.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent9.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent9.Text = "0%";
                    }
                    poll_option_votes9.Visible = true;
                    poll_option_votes9.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar9.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar9.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar9.Style.Add("width", "0%");
                    }
                    j++;
                }
                if (option_list[j] != "")
                {
                    poll_option_desc10.Visible    = true;
                    poll_option_desc10.Text       = "  " + option_list[j];
                    poll_option_percent10.Visible = true;
                    if (total > 0)
                    {
                        poll_option_percent10.Text = "  " + Math.Round(((votes[j] / total)) * 100).ToString() + "%";
                    }
                    else
                    {
                        poll_option_percent10.Text = "0%";
                    }
                    poll_option_votes10.Visible = true;
                    poll_option_votes10.Text    = votes[j].ToString() + "  Votes";
                    poll_option_bar10.Visible   = true;
                    if (total > 0)
                    {
                        poll_option_bar10.Style.Add("width", (((votes[j] / total) * 100).ToString() + "%"));
                    }
                    else
                    {
                        poll_option_bar10.Style.Add("width", "0%");
                    }
                    j++;
                }
            }
        }
コード例 #24
0
        public static bool Prefix(ref RunAggregateDatas __result,
                                  ref string database,
                                  ref string userId,
                                  ref string altUserId,
                                  ref int page,
                                  ref int numPerPage,
                                  ref HadesNetworkCaller.SortFieldName sortFieldName,
                                  ref HadesNetworkCaller.SortDirection sortDirection)
        {
            // Get the filter manager. I don't think there's a way to pass this as an argument, so we'll have to
            // set it manually.
            FilterManager manager = AdvancedRunHistory.filterManager;

            // This is just vanilla code.
            altUserId = altUserId ?? string.Empty;
            int           environment = (int)AppManager.EnvironmentConfig.Environment;
            string        commandText = string.Format("SELECT {0} FROM '{1}' WHERE ({2} = '{3}' OR {4} = '{5}') AND {6} = {7} ORDER BY {8} {9}", "runId", "runHistoryTable", "userId", userId, "userId", altUserId, "env", environment, sortFieldName, sortDirection);
            List <string> runIds      = new List <string>();

            if (!SqlUtil.ExecuteReader(database, commandText, ErrorFile.RunMinDbEntry, 3, delegate(SqliteDataReader reader)
            {
                while (reader.Read())
                {
                    runIds.Add(reader.GetString(0));
                }
                return(true);
            }, exactlyOneRead: false))
            {
                __result = null;
                return(false);
            }
            // The actual patch; start by assuming we don't want to filter.
            List <string> filteredRunIds = runIds;

            // Only filter runs if the manager is active-
            if (manager.Active)
            {
                // Make a new list of runIds.
                filteredRunIds = new List <String>();
                // Go through all runIds in the original list.
                foreach (string runId in runIds)
                {
                    // Try to read the run from the DB.
                    RunMinDbEntry runMinDbEntry = RunMinDbEntry.ReadFromDb(database, runId);
                    if (runMinDbEntry != null)
                    {
                        // Create a RunAggregateData. Assume it's eglibile.
                        RunAggregateData runAggregateData = runMinDbEntry.minimalRunData.CreateRunAggregateData();
                        bool             isEgligible      = true;
                        // Go through all filters and make the run uneglibile if it doesn't pass.
                        foreach (IRunDataFilter filter in manager.Filters)
                        {
                            if (!filter.IsEgligible(runAggregateData))
                            {
                                isEgligible = false;
                                break;
                            }
                        }
                        // The run has passed all filters, add it to the filtered list.
                        if (isEgligible)
                        {
                            filteredRunIds.Add(runId);
                        }
                    }
                }
            }
            // Back to vanilla code, but changing runIds --> filteredRunIds.
            List <string>           list  = new List <string>();
            List <RunAggregateData> list2 = new List <RunAggregateData>();

            for (int i = (page - 1) * numPerPage; i < filteredRunIds.Count; i++)
            {
                if (list2.Count >= numPerPage)
                {
                    break;
                }
                RunMinDbEntry runMinDbEntry = RunMinDbEntry.ReadFromDb(database, filteredRunIds[i]);
                if (runMinDbEntry != null)
                {
                    RunAggregateData runAggregateData = runMinDbEntry.minimalRunData.CreateRunAggregateData();
                    string           item             = JsonUtility.ToJson(runAggregateData);
                    list.Add(item);
                    list2.Add(runAggregateData);
                }
            }
            int pageCount = filteredRunIds.Count / numPerPage + Math.Min(filteredRunIds.Count % numPerPage, 1);
            RunAggregateDatas runAggregateDatas = new RunAggregateDatas(list.ToArray(), pageCount, page);

            runAggregateDatas.SetRuns(list2.ToArray());
            __result = runAggregateDatas;
            return(false);
        }
コード例 #25
0
ファイル: User.aspx.cs プロジェクト: endoffile78/J-Team
        protected void Page_Load(object sender, EventArgs e)
        {
            IList <string> segments = Request.GetFriendlyUrlSegments();

            uid = segments[0];

            Guid id;

            if (!Guid.TryParse(uid, out id))
            {
                Response.Redirect(ResolveUrl("UserNotFound.aspx"));
            }

            List <SqlParameter> parameters = new List <SqlParameter>();

            parameters.Add(new SqlParameter("uid", uid));

            SqlDataReader reader = SqlUtil.ExecuteReader("SELECT Fname, Lname FROM User_Main WHERE ID_Num = @uid", parameters);

            if (!reader.Read())
            {
                reader.Close();
                Response.Redirect(ResolveUrl("UserNotFound.aspx"));
            }

            name = reader["Fname"] + " " + reader["Lname"];

            reader.Close();

            parameters.Clear();
            parameters.Add(new SqlParameter("uid", uid));

            SqlDataReader r = SqlUtil.ExecuteReader("SELECT * FROM Blog_Post WHERE ID_Num = @uid", parameters);

            while (r.Read())
            {
                BlogPost post = new BlogPost();
                post.blogID = Guid.Parse(r["BlogID"].ToString());
                post.title  = r["Title"].ToString();
                post.body   = r["Body"].ToString();
                posts.Add(post);
            }

            r.Close();

            parameters.Clear();
            parameters.Add(new SqlParameter("@uid", uid));
            r = SqlUtil.ExecuteReader("SELECT *, User_Main.Fname, User_Main.Lname, User_Main.ID_Num FROM BlogFollowers" +
                                      " INNER JOIN User_Main ON BlogFollowers.Follower = User_Main.ID_Num" +
                                      " WHERE Following = @uid", parameters);

            while (r.Read())
            {
                UserProfile user = new UserProfile();
                user.name = r["Fname"] + " " + r["Lname"];
                user.uid  = Guid.Parse(r["ID_Num"].ToString());
                following.Add(user);
            }

            r.Close();

            parameters.Clear();
            parameters.Add(new SqlParameter("@uid", uid));
            r = SqlUtil.ExecuteReader("SELECT *, User_Main.Fname, User_Main.Lname, User_Main.ID_Num FROM BlogFollowers" +
                                      " INNER JOIN User_Main ON BlogFollowers.Following = User_Main.ID_Num" +
                                      " WHERE Follower = @uid", parameters);

            while (r.Read())
            {
                UserProfile user = new UserProfile();
                user.name = r["Fname"] + " " + r["Lname"];
                user.uid  = Guid.Parse(r["ID_Num"].ToString());
                followers.Add(user);
            }

            r.Close();

            if (Session["loggedIn"] != null)
            {
                parameters.Clear();
                parameters.Add(new SqlParameter("profile_uid", uid));
                parameters.Add(new SqlParameter("uid", Session["uid"]));

                r = SqlUtil.ExecuteReader("SELECT * FROM BlogFollowers WHERE Following = @profile_uid AND Follower = @uid", parameters);
                if (r.Read())
                {
                    followingUser = true;
                }

                r.Close();
            }
        }
コード例 #26
0
ファイル: Main.aspx.cs プロジェクト: endoffile78/J-Team
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["loggedIn"] == null) //TODO: tell the user they need to login
            {
                Response.Redirect("../Login.aspx");
            }
            else
            {
                if (!IsPostBack)
                {
                    collegeCDrop.Items.Insert(0, new ListItem("Pick a college", "0"));
                    collegeCDrop.SelectedIndex = 0;

                    countryCDrop.Items.Insert(0, new ListItem("Pick a country", "0"));
                    countryCDrop.SelectedIndex = 0;

                    stateCDrop.Items.Insert(0, new ListItem("Pick a state", "0"));
                    stateCDrop.SelectedIndex = 0;

                    cityCDrop.Items.Insert(0, new ListItem("Pick a city", "0"));
                    cityCDrop.SelectedIndex = 0;

                    companyCDrop.Items.Insert(0, new ListItem("Pick a company", "0"));
                    companyCDrop.SelectedIndex = 0;

                    majorCDrop.Items.Insert(0, new ListItem("Pick a major", "0"));
                    majorCDrop.SelectedIndex = 0;

                    graduationCDrop.Items.Insert(0, new ListItem("Pick a position", "0"));
                    graduationCDrop.SelectedIndex = 0;

                    positionCDrop.Items.Insert(0, new ListItem("Pick a classification", "0"));
                    positionCDrop.SelectedIndex = 0;


                    SqlDataReader reader = SqlUtil.ExecuteReader("SELECT *, User_Main.Fname AS MFname, User_Main.Lname AS MLname FROM Job_Posting " +
                                                                 "LEFT JOIN User_Main ON Job_Posting.ID_Num = User_Main.ID_Num");

                    while (reader.Read())
                    {
                        Connect view = new Connect();
                        view.major      = reader["Major"].ToString();
                        view.name       = reader["MFname"] + " " + reader["MLname"];
                        view.college    = reader["College"].ToString();
                        view.position   = reader["Position"].ToString();
                        view.graduation = reader["Graduation"].ToString();
                        view.company    = reader["Company"].ToString();
                        view.location   = reader["City"].ToString() + "," + reader["State"].ToString() + "," + reader["Country"].ToString();
                        view.long_desc  = reader["Long_Disc"].ToString();
                        view.resources  = reader["Resources_Used"].ToString();
                        view.lessons    = reader["Lessons_Learned"].ToString();
                        view.image      = reader["Image"].ToString();
                        view.facebook   = reader["Facebook"].ToString();
                        view.twitter    = reader["Twitter"].ToString();
                        view.email      = reader["Email"].ToString();
                        view.linkedIn   = reader["LinkedIn"].ToString();
                        view.instagram  = reader["Instagram"].ToString();
                        view.id         = reader["ID_Num"].ToString();
                        views.Add(view);
                    }
                    reader.Close();
                }
            }
        }