protected void dropDownEditSearch_SelectedIndexChanged(object sender, EventArgs e)
        {
            //Program clears out the current text
            lbl_result.Text = "";
            lbl_error.Text  = "";

            double isbn   = double.Parse(dropDownEditSearch.SelectedValue);
            double rating = 0;
            string format = "";

            BookInventoryTableAdapters.BookTableAdapter tableAdapter  = new BookInventoryTableAdapters.BookTableAdapter();
            BookInventory.BookInventoryTableDataTable   bookInventory = tableAdapter.GetDataByIsbn(isbn);

            //Foreach loop goes through the rows
            foreach (BookInventory.BookInventoryTableRow br in bookInventory)
            {
                //Program updates each item with the current information from the database
                textEditIsbn.Text      = br.Isbn.ToString();
                textEditFirstName.Text = br.AuthorFName.ToString();
                textEditLastName.Text  = br.AuthorLName.ToString();
                textEditTitle.Text     = br.Title.ToString();

                cbEditCategory.Items.FindByText("Fiction").Selected       = (bool)br.Fiction;
                cbEditCategory.Items.FindByText("Children's").Selected    = (bool)br._Children_s;
                cbEditCategory.Items.FindByText("Foreign").Selected       = (bool)br.Foreign;
                cbEditCategory.Items.FindByText("Romance").Selected       = (bool)br.Romance;
                cbEditCategory.Items.FindByText("Suspense").Selected      = (bool)br.Suspense;
                cbEditCategory.Items.FindByText("Non-Fiction").Selected   = (bool)br._Non_Fiction;
                cbEditCategory.Items.FindByText("Comedy").Selected        = (bool)br.Comedy;
                cbEditCategory.Items.FindByText("History").Selected       = (bool)br.History;
                cbEditCategory.Items.FindByText("Sci-Fi").Selected        = (bool)br._Sci_Fi;
                cbEditCategory.Items.FindByText("Textbook").Selected      = (bool)br.Textbook;
                cbEditCategory.Items.FindByText("AutoBiography").Selected = (bool)br.Autobiography;
                cbEditCategory.Items.FindByText("Drama").Selected         = (bool)br.Drama;
                cbEditCategory.Items.FindByText("Horror").Selected        = (bool)br.Horror;
                cbEditCategory.Items.FindByText("Self-Help").Selected     = (bool)br._Self_Help;
                cbEditCategory.Items.FindByText("Thriller").Selected      = (bool)br.Thriller;
                cbEditCategory.Items.FindByText("Biography").Selected     = (bool)br.Biography;
                cbEditCategory.Items.FindByText("Fantasy").Selected       = (bool)br.Fantasy;
                cbEditCategory.Items.FindByText("Religious").Selected     = (bool)br.Religious;

                rating = br.Rating;
                format = br.Format;
            }

            int index = DropDownQuestNum.Items.IndexOf(DropDownQuestNum.Items.FindByValue(rating.ToString()));

            DropDownQuestNum.SelectedIndex = index;

            int rbindex = rblst_format.Items.IndexOf(rblst_format.Items.FindByValue(format));

            rblst_format.SelectedIndex = rbindex;
        }
예제 #2
0
        protected void dropDownEditSearch_SelectedIndexChanged(object sender, EventArgs e)
        {
            //Program gets the isbn, rating, and format
            double isbn   = double.Parse(dropDownEditSearch.SelectedValue);
            double rating = 0;
            string format = "";

            //Creating objects for the table adapter and bookInventory
            BookInventoryTableAdapters.BookTableAdapter tableAdapter  = new BookInventoryTableAdapters.BookTableAdapter();
            BookInventory.BookInventoryTableDataTable   bookInventory = tableAdapter.GetDataByIsbn(isbn);

            //Foreach loop goes through each row of data
            foreach (BookInventory.BookInventoryTableRow br in bookInventory)
            {
                //Program sets the label text to the current record
                lblFirstName.Text = br.AuthorFName.ToString();
                lblLastName.Text  = br.AuthorLName.ToString();
                lblTitle.Text     = br.Title.ToString();
                lblRating.Text    = br.Rating.ToString();
                rating            = br.Rating;
                format            = br.Format;
            }

            //Program gets the book categories
            string categorySql = "SELECT Fiction, [Children's], [Foreign], Romance, Suspense, [Non-Fiction], Comedy, History, [Sci-Fi], Textbook, Autobiography, Drama, Horror, [Self-Help], Thriller, Biography, Fantasy, Religious" +
                                 " FROM categories WHERE Isbn = @Isbn";

            List <string> categoryNames = new List <string>();

            //Program opens a new connection to the database
            using (SqlConnection con = new SqlConnection(GetConnectionString()))
            {
                using (SqlCommand cmd = new SqlCommand(categorySql, con))
                {
                    //Program executes the query
                    cmd.Parameters.AddWithValue("Isbn", isbn);
                    con.Open();
                    using (SqlDataReader reader = cmd.ExecuteReader())
                    {
                        //While loop adds the category names to the list of categories
                        while (reader.Read())
                        {
                            for (int i = 0; i < 18; i++)
                            {
                                if (reader.GetBoolean(i) == true)
                                {
                                    categoryNames.Add(reader.GetName(i).ToString());
                                }
                            }
                        }
                    }
                }
            }

            string cat = "";

            //For loop sets cat to the formatted list of categories
            for (int i = 0; i < categoryNames.Count; i++)
            {
                if (categoryNames.Count - i == 1)
                {
                    cat += categoryNames[i];
                }
                else
                {
                    cat += categoryNames[i] + ", ";
                }
            }

            //Program displays the categories
            lblCategories.Text = cat;
        }