Esempio n. 1
0
        //issue book
        private void btn_issue_Click(object sender, EventArgs e)
        {
            if (tb_studentName.Text == "")
            {
                MessageBox.Show("Please select student name");
            }
            else
            {
                if (Convert.ToDateTime(date_issue.Text) < DateTime.Today || Convert.ToDateTime(date_issue.Text) > DateTime.Today)
                {
                    MessageBox.Show("You can not issue book on previous or future dates!! Please select today's date!!");
                }
                else
                {
                    if (qty == 0)
                    {
                        MessageBox.Show("Books out of stock!");
                    }
                    else
                    {
                        try
                        {
                            //insert in issue book table
                            date = date_issue.Text;
                            int        id     = Increment.issueBookIncrement();
                            SqlCommand cmd    = new SqlCommand("Insert into issue_book values('" + id + "','" + tb_bookId.Text + "','" + cb_bookName.Text + "','" + cb_edition.Text + "','" + cb_publisher.Text + "','" + tb_studentId.Text + "','" + tb_enrollment.Text + "','" + tb_studentName.Text + "','" + tb_course.Text + "','" + tb_year.Text + "','" + tb_sem.Text + "','" + tb_contact.Text + "','" + date + "')", con);
                            int        result = cmd.ExecuteNonQuery();
                            //decrease quantity
                            SqlCommand cmd1 = new SqlCommand("update book set available_qty=available_qty-1 where book_id='" + tb_bookId.Text + "'", con);
                            cmd1.ExecuteNonQuery();

                            if (result == 1)
                            {
                                MessageBox.Show("Book Issued!");
                                cb_bookName.Items.Clear();
                                loadCombo();
                                tb_bookId.Text      = "";
                                tb_enrollment.Text  = "";
                                tb_studentName.Text = "";
                                tb_studentId.Text   = "";
                                tb_course.Text      = "";
                                tb_year.Text        = "";
                                tb_sem.Text         = "";
                                tb_contact.Text     = "";
                            }
                            else
                            {
                                MessageBox.Show("Something Went Wrong!");
                            }
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                    }
                }
            }
        }