コード例 #1
0
        void AddNewBook()
        {
            try
            {
                string genres = "";
                foreach (int i in ListBox1.GetSelectedIndices())
                {
                    genres = genres + ListBox1.Items[i] + ",";
                }
                // genres = Adventure,Self Help,
                genres = genres.Remove(genres.Length - 1);

                string filepath = "~/book_inventory/books1.png";
                string filename = Path.GetFileName(FIleUpload1.PostedFile.FileName);
                FIleUpload1.SaveAs(Server.MapPath("book_inventory/" + filename));
                filepath = "~/book_inventory/" + filename;


                SqlConnection con = new SqlConnection(strcon);
                if (con.State == ConnectionState.Closed)
                {
                    con.Open();
                }



                SqlCommand     cmd2 = new SqlCommand("SELECT * from author_master_tbl WHERE author_name = '" + DropDownList3.SelectedItem.Value + "' ", con);
                SqlDataAdapter sda  = new SqlDataAdapter(cmd2);
                DataTable      sdt  = new DataTable();
                sda.Fill(sdt);
                var aid = "";
                if (sdt.Rows.Count >= 1)
                {
                    aid = sdt.Rows[0]["author_id"].ToString().Trim();
                }

                else
                {
                    Response.Write("<script>alert('Author Not Found.');</script>");
                }


                SqlCommand     cmd3 = new SqlCommand("SELECT * from publisher_master_tbl WHERE publisher_name = '" + DropDownList2.SelectedItem.Value + "' ", con);
                SqlDataAdapter sda2 = new SqlDataAdapter(cmd3);
                DataTable      sdt2 = new DataTable();
                sda2.Fill(sdt2);
                var pid = "";
                if (sdt.Rows.Count >= 1)
                {
                    pid = sdt2.Rows[0]["publisher_id"].ToString().Trim();
                }
                else
                {
                    Response.Write("<script>alert('Publisher Not Found.');</script>");
                }


                SqlCommand cmd = new SqlCommand("INSERT INTO book_master_tbl (book_id,book_name,genre,author,publisher,published_date,language,edition,book_price,no_of_pages,book_description,actual_stock,current_stock,book_img_link) values (@book_id,@book_name,@genre,@author,@publisher,@published_date,@language,@edition,@book_price,@no_of_pages,@book_description,@actual_stock,@current_stock,@book_img_link)", con);
                cmd.Parameters.AddWithValue("@book_id", TextBox3.Text.Trim());
                cmd.Parameters.AddWithValue("@book_name", TextBox4.Text.Trim());
                cmd.Parameters.AddWithValue("@genre", genres);
                cmd.Parameters.AddWithValue("@author", aid);
                cmd.Parameters.AddWithValue("@publisher", pid);
                cmd.Parameters.AddWithValue("@published_date", TextBox6.Text.Trim());
                cmd.Parameters.AddWithValue("@language", DropDownList1.SelectedItem.Value);
                cmd.Parameters.AddWithValue("@edition", TextBox2.Text.Trim());
                cmd.Parameters.AddWithValue("@book_price", TextBox9.Text.Trim());
                cmd.Parameters.AddWithValue("@no_of_pages", TextBox1.Text.Trim());
                cmd.Parameters.AddWithValue("@book_description", TextBox10.Text.Trim());
                cmd.Parameters.AddWithValue("@actual_stock", TextBox8.Text.Trim());
                cmd.Parameters.AddWithValue("@current_stock", TextBox7.Text.Trim());
                cmd.Parameters.AddWithValue("@book_img_link", filepath);

                cmd.ExecuteNonQuery();
                con.Close();
                Response.Write("<script>alert('Book added successfully.');</script>");
                GridView1.DataBind();
                ClearForm();
            }
            catch (Exception ex)
            {
                Response.Write("<script>alert('" + ex.Message + "');</script>");
            }
        }
コード例 #2
0
        void UpdateBookByID()
        {
            if (CheckIfBookExists())
            {
                try
                {
                    int actual_stock  = Convert.ToInt32(TextBox8.Text.Trim());
                    int current_stock = Convert.ToInt32(TextBox7.Text.Trim());

                    if (global_actual_stock == actual_stock)
                    {
                    }
                    else
                    {
                        if (actual_stock < global_issued_books)
                        {
                            Response.Write("<script>alert('Actual Stock value cannot be less than the Issued books');</script>");
                            return;
                        }
                        else
                        {
                            current_stock = actual_stock - global_issued_books;
                            TextBox7.Text = "" + current_stock;
                        }
                    }

                    string genres = "";
                    foreach (int i in ListBox1.GetSelectedIndices())
                    {
                        genres = genres + ListBox1.Items[i] + ",";
                    }
                    genres = genres.Remove(genres.Length - 1);

                    string filepath = "~/book_inventory/books1.png";
                    string filename = Path.GetFileName(FIleUpload1.PostedFile.FileName);
                    if (filename == "" || filename == null)
                    {
                        filepath = global_filepath;
                    }
                    else
                    {
                        FIleUpload1.SaveAs(Server.MapPath("book_inventory/" + filename));
                        filepath = "~/book_inventory/" + filename;
                    }

                    SqlConnection con = new SqlConnection(strcon);
                    if (con.State == ConnectionState.Closed)
                    {
                        con.Open();
                    }

                    SqlCommand     cmd2 = new SqlCommand("SELECT * FROM author_master_tbl WHERE author_name = '" + DropDownList3.SelectedItem.Value + "' ", con);
                    SqlDataAdapter sda  = new SqlDataAdapter(cmd2);
                    DataTable      sdt  = new DataTable();
                    sda.Fill(sdt);
                    var aid = "";
                    if (sdt.Rows.Count >= 1)
                    {
                        aid = sdt.Rows[0]["author_id"].ToString().Trim();
                    }

                    else
                    {
                        Response.Write("<script>alert('Author Not Found.');</script>");
                    }


                    SqlCommand     cmd3 = new SqlCommand("SELECT * from publisher_master_tbl WHERE publisher_name = '" + DropDownList2.SelectedItem.Value + "' ", con);
                    SqlDataAdapter sda2 = new SqlDataAdapter(cmd3);
                    DataTable      sdt2 = new DataTable();
                    sda2.Fill(sdt2);
                    var pid = "";
                    if (sdt.Rows.Count >= 1)
                    {
                        pid = sdt2.Rows[0]["publisher_id"].ToString().Trim();
                    }
                    else
                    {
                        Response.Write("<script>alert('Publisher Not Found.');</script>");
                    }


                    SqlCommand cmd = new SqlCommand("UPDATE book_master_tbl SET book_name=@book_name, genre=@genre, author=@author, publisher=@publisher, published_date=@published_date, language=@language, edition=@edition, book_price=@book_price, no_of_pages=@no_of_pages, book_description=@book_description, actual_stock=@actual_stock, current_stock=@current_stock, book_img_link=@book_img_link where book_id='" + TextBox3.Text.Trim() + "'", con);

                    cmd.Parameters.AddWithValue("@book_name", TextBox4.Text.Trim());
                    cmd.Parameters.AddWithValue("@genre", genres);
                    cmd.Parameters.AddWithValue("@author", aid);
                    cmd.Parameters.AddWithValue("@publisher", pid);
                    cmd.Parameters.AddWithValue("@published_date", TextBox6.Text.Trim());
                    cmd.Parameters.AddWithValue("@language", DropDownList1.SelectedItem.Value);
                    cmd.Parameters.AddWithValue("@edition", TextBox2.Text.Trim());
                    cmd.Parameters.AddWithValue("@book_price", TextBox9.Text.Trim());
                    cmd.Parameters.AddWithValue("@no_of_pages", TextBox1.Text.Trim());
                    cmd.Parameters.AddWithValue("@book_description", TextBox10.Text.Trim());
                    cmd.Parameters.AddWithValue("@actual_stock", TextBox8.Text.Trim());
                    cmd.Parameters.AddWithValue("@current_stock", TextBox7.Text.Trim());
                    cmd.Parameters.AddWithValue("@book_img_link", filepath);

                    cmd.ExecuteNonQuery();
                    con.Close();
                    GridView1.DataBind();
                    Response.Write("<script>alert('Book Updated Successfully');</script>");
                    ClearForm();
                }
                catch (Exception ex)
                {
                    Response.Write("<script>alert('" + ex.Message + "');</script>");
                }
            }
            else
            {
                Response.Write("<script>alert('Invalid Book ID');</script>");
            }
        }