Ejemplo n.º 1
0
        private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                if (dgvBookList.Rows.Count > 0)
                {
                    BookDT = new DataTable();
                    BookDT.Columns.Add("BookCode");
                    BookDT.Columns.Add("BookName");
                    BookDT.Columns.Add("Author");
                    BookDT.Columns.Add("ISBN");
                    BookDT.Columns.Add("Category");

                    foreach (DataGridViewRow row in dgvBookList.Rows)
                    {
                        DataRow dr = BookDT.NewRow();
                        dr["BookCode"] = row.Cells[1].Value.ToString();
                        dr["BookName"] = row.Cells[2].Value.ToString();
                        dr["Author"]   = row.Cells[3].Value.ToString();
                        dr["ISBN"]     = row.Cells[4].Value.ToString();

                        string category = row.Cells[5].Value.ToString();
                        dr["Category"] = Category_DAO.getCategoryID(category);

                        BookDT.Rows.Add(dr);
                        dr = null;
                    }

                    if (BookDT.Rows.Count > 0)
                    {
                        if (Book_DAO.SaveNewBook(BookDT) > 0)
                        {
                            MessageBox.Show("Save Successfully.", "Save");
                            dgvBookList.DataSource = null;
                        }
                    }
                }
                else
                {
                    MessageBox.Show("No Data found to Save.");
                }
            }catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }
Ejemplo n.º 2
0
        //Generate Book Code
        private void GenerateBookCode()
        {
            int Code = Book_DAO.getBookCount() + dgvBookList.Rows.Count;

            txtBookCode.Text = string.Format("BK-" + "{0:00000}", ++Code);
        }