Пример #1
0
        protected void ShowPageInfo(HTTP_PAGEDB db)
        {
            //Our flag to know if the data can be shown or not
            bool valid = true;

            //Get the http_pageID from the query
            string http_pageID = Request.QueryString["http_pageID"];

            //if there is no id then user must have went to this page without a id
            if (String.IsNullOrEmpty(http_pageID))
            {
                valid = false;
            }

            //if there is a id on the page then
            if (valid)
            {
                //Get the HTTP_Page from the id we got
                HTTP_Page pageRecord = db.FindPage(Int32.Parse(http_pageID));
                //Show the data on the HTML
                pageID.InnerHtml            = pageRecord.GetID();
                pageTitle.Text              = pageRecord.GetTitle();
                pageContent.Text            = pageRecord.GetContent();
                pageDatePublished.InnerHtml = pageRecord.GetDate().ToString("MM/dd/yyyy");
            }

            //No id was found
            if (!valid)
            {
                http_page.InnerHtml = "There was an error finding that page.";
            }
        }
Пример #2
0
        //This code is referenced from SCHOOLDB.cs in our examples
        public void UpdatePage(int http_pageID, HTTP_Page newHTTPPage)
        {
            //Our query string
            string query = "update http_pages set HTTPPAGETITLE='{0}', HTTPPAGECONTENT='{1}' where HTTPPAGEID={2}";

            query = String.Format(query, newHTTPPage.GetTitle(), newHTTPPage.GetContent(), http_pageID);

            //Set up SQL Connection
            MySqlConnection Connect = new MySqlConnection(ConnectionString);

            //Give the connection a query
            MySqlCommand cmd = new MySqlCommand(query, Connect);

            //Try to update a page with the information provided to us.
            try
            {
                //Open the database connection
                Connect.Open();
                //Run our query command on the database
                cmd.ExecuteNonQuery();
                //Debug purpose
                Debug.WriteLine("Executed query " + query);
            }
            //An exception occured
            catch (Exception ex)
            {
                //If that doesn't seem to work, check Debug>Windows>Output for the below message
                Debug.WriteLine("Something went wrong in the UpdatePage Method!");
                Debug.WriteLine(ex.ToString());
            }

            //Close our database connection
            Connect.Close();
        }
Пример #3
0
        //This code is referenced from SCHOOLDB.cs in our examples
        public void AddPage(HTTP_Page newPage)
        {
            //Our query string
            string query = "insert into http_pages (HTTPPAGETITLE, HTTPPAGECONTENT, HTTPPAGEDATE) values ('{0}','{1}','{2}')";

            query = String.Format(query, newPage.GetTitle(), newPage.GetContent(), newPage.GetDate().ToString("yyyy/MM/dd"));

            //Set up SQL Connection
            MySqlConnection Connect = new MySqlConnection(ConnectionString);

            //Give the connection a query
            MySqlCommand cmd = new MySqlCommand(query, Connect);

            //Try to add a page with the information provided to us.
            try
            {
                //Open the database connection
                Connect.Open();
                //Run our query command on the database
                cmd.ExecuteNonQuery();
                //Debug purpose
                Debug.WriteLine("Executed query " + query);
            }
            //An exception occured
            catch (Exception ex)
            {
                Debug.WriteLine("Something went wrong in the AddPage Method!");
                Debug.WriteLine(ex.ToString());
            }

            //Close our database connection
            Connect.Close();
        }
Пример #4
0
        //if the user clicks on the Update Page button
        protected void UpdatePage(object sender, EventArgs e)
        {
            //Create our database object
            HTTP_PAGEDB db = new HTTP_PAGEDB();

            //Our flag to know if the data can be obtained or not
            bool valid = true;

            //Get the http_pageID from the query
            string http_pageID = Request.QueryString["http_pageID"];

            //if there is no id then user must have went to this page without a id
            if (String.IsNullOrEmpty(http_pageID))
            {
                valid = false;
            }

            //if there is a id on the page then
            if (valid)
            {
                //Create a new HTTP_Page object
                HTTP_Page newPage = new HTTP_Page();

                //Set the necessary value in the HTTP_Page object that will get updated
                newPage.SetTitle(pageTitle.Text);
                newPage.SetContent(pageContent.Text);

                try
                {
                    //Update the HTTP_Page to the database
                    db.UpdatePage(Int32.Parse(http_pageID), newPage);
                    //Go back to the show page of this particular HTTP_Page we are updating
                    Response.Redirect("ShowHTTP_Page.aspx?http_pageID=" + http_pageID);
                }
                catch
                {
                    valid = false;
                }
            }

            //No id was found or failed to update
            if (!valid)
            {
                http_page.InnerHtml = "There was an error updating that page.";
            }
        }
Пример #5
0
        //When user clicks on the Add Page button
        protected void AddPage(object sender, EventArgs e)
        {
            //Create connection
            HTTP_PAGEDB db = new HTTP_PAGEDB();

            //Create a new particular HTTP_Page
            HTTP_Page newPage = new HTTP_Page();

            //Set that page data
            newPage.SetTitle(pageTitle.Text);
            newPage.SetContent(pageContent.Text);
            newPage.SetDate(DateTime.Today);

            //Add the page to the database
            db.AddPage(newPage);

            //Go back to the list of HTTP_Pages
            Response.Redirect("Manage_HTTP_Pages.aspx");
        }
Пример #6
0
        //This code is referenced from SCHOOLDB.cs in our examples
        public List <HTTP_Page> List_Query(string query)
        {
            //Set up SQL Connection
            MySqlConnection Connect = new MySqlConnection(ConnectionString);

            //Our list of HTTP_Page that is the result from the query
            List <HTTP_Page> ResultSet = new List <HTTP_Page>();

            try
            {
                Debug.WriteLine("Connection Initialized...");
                Debug.WriteLine("Attempting to execute query " + query);
                //open the db connection
                Connect.Open();
                //give the connection a query
                MySqlCommand cmd = new MySqlCommand(query, Connect);
                //grab the result set
                MySqlDataReader resultset = cmd.ExecuteReader();

                //for every row in the result set
                while (resultset.Read())
                {
                    //Create a new HTTP_Page object
                    HTTP_Page Row = new HTTP_Page();
                    //for every column in the row
                    for (int i = 0; i < resultset.FieldCount; i++)
                    {
                        //Switch statement to set the value to their correct column
                        switch (resultset.GetName(i))
                        {
                        case "HTTPPAGEID":
                            Row.SetID(resultset.GetString(i));
                            break;

                        case "HTTPPAGETITLE":
                            Row.SetTitle(resultset.GetString(i));
                            break;

                        case "HTTPPAGECONTENT":
                            Row.SetContent(resultset.GetString(i));
                            break;

                        case "HTTPPAGEDATE":
                            Row.SetDate(DateTime.Parse(resultset.GetString(i)));
                            break;

                        default:
                            Debug.WriteLine("The column name is not in the HTTP_Page");
                            break;
                        }
                    }
                    //Add the object to the list result
                    ResultSet.Add(Row);
                }//end row

                //Finish reading (no more content left)
                resultset.Close();
            }
            //Exception occured
            catch (Exception ex)
            {
                Debug.WriteLine("Something went wrong in the List_Query method!");
                Debug.WriteLine(ex.ToString());
            }
            //Close the connection to the database
            Connect.Close();
            Debug.WriteLine("Database Connection Terminated.");

            //Return our result
            return(ResultSet);
        }
Пример #7
0
        //This code is referenced from SCHOOLDB.cs in our examples
        public HTTP_Page FindPage(int id)
        {
            //Utilize the connection string
            MySqlConnection Connect = new MySqlConnection(ConnectionString);

            //Create a new HTTP_Page Object to be used for are return value
            HTTP_Page result_page = new HTTP_Page();

            //we will try to grab HTTP_Page data from the database, if we fail, a message will appear in Debug>Windows>Output dialogue
            try
            {
                //Build a custom query with the id information provided
                string query = "select * from http_pages where HTTPPAGEID = " + id;
                Debug.WriteLine("Connection Initialized...");
                //open the db connection
                Connect.Open();
                //Run out query against the database
                MySqlCommand cmd = new MySqlCommand(query, Connect);
                //grab the result set
                MySqlDataReader resultset = cmd.ExecuteReader();

                //Create a list of pages (although we're only trying to get 1)
                List <HTTP_Page> pages = new List <HTTP_Page>();

                //read through the result set
                while (resultset.Read())
                {
                    //information that will store a single page
                    HTTP_Page currentPage = new HTTP_Page();

                    //Look at each column in the result set row, add both the column name and the column value to our Student dictionary
                    for (int i = 0; i < resultset.FieldCount; i++)
                    {
                        string key   = resultset.GetName(i);
                        string value = resultset.GetString(i);
                        Debug.WriteLine("Attempting to transfer " + key + " data of " + value);
                        //Switch statement to set the value to their correct column
                        switch (key)
                        {
                        case "HTTPPAGEID":
                            currentPage.SetID(value);
                            break;

                        case "HTTPPAGETITLE":
                            currentPage.SetTitle(value);
                            break;

                        case "HTTPPAGECONTENT":
                            currentPage.SetContent(value);
                            break;

                        case "HTTPPAGEDATE":
                            currentPage.SetDate(DateTime.Parse(value));
                            break;

                        default:
                            Debug.WriteLine("The column name is not in the HTTP_Page");
                            break;
                        }
                    }
                    //Add the page to the list of pages
                    pages.Add(currentPage);
                }
                //get the first page
                result_page = pages[0];
            }
            //An exception occured
            catch (Exception ex)
            {
                //If something (anything) goes wrong with the try{} block, this block will execute
                Debug.WriteLine("Something went wrong in the find Page method!");
                Debug.WriteLine(ex.ToString());
            }
            //Close the database connection
            Connect.Close();
            Debug.WriteLine("Database Connection Terminated.");

            //Return our result
            return(result_page);
        }