private void getSearchedBooks(object sender, EventArgs e)
{
DBUtils.DBBook dBBook = new DBUtils.DBBook();
int searchIndex = searchCategoryCombo.SelectedIndex;
string searchWord = searchWordTextBox.Text.ToString();
List <Models.Book> searchedBooks = dBBook.getSearchedBooks(searchIndex, searchWord);
var bindingSearchedList = new BindingList <Models.Book>(searchedBooks);
dataGridView1.DataSource = bindingSearchedList;
}
private void insertNewBook(object sender, EventArgs e)
{
DBUtils.DBBook dBBook = new DBUtils.DBBook();
string isbn = textBox1.Text.ToString();
string name = textBox2.Text.ToString();
string publisher = textBox3.Text.ToString();
int page;
bool isPageParsed = int.TryParse(textBox4.Text.ToString(), out page);
if (!isPageParsed)
{
MessageBox.Show("페이지는 숫자만 입력해주세요.");
return;
}
dBBook.insertNewBook(dataGridView1, isbn, name, publisher, page);
sendInsertSuccessMessage();
}
public void removeSelectedBook(object sender, EventArgs e)
{
DBUtils.DBBook dBBook = new DBUtils.DBBook();
int id = 0;
if (dataGridView1.SelectedCells.Count > 0)
{
int selectedRowIndex = dataGridView1.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = dataGridView1.Rows[selectedRowIndex];
id = int.Parse(selectedRow.Cells["id"].Value.ToString());
}
dBBook.removeSelectedBook(dataGridView1, id);
sendInsertSuccessMessage();
}
public Form1()
{
InitializeComponent();
Text = "도서관 관리";
DBUtils.DBUser dBUser = new DBUtils.DBUser();
DBUtils.DBBook dBBook = new DBUtils.DBBook();
// 라벨 설정
//label5.Text = DataManager.Books.Count.ToString();
label5.Text = dBBook.getBookCount().ToString();
label6.Text = dBUser.getUserCount().ToString();
label7.Text = DataManager.Books.Where((x) => x.isBorrowed).Count().ToString();
label8.Text = DataManager.Books.Where((x) =>
{
return(x.isBorrowed && x.BorrowedAt.AddDays(7) > DateTime.Now);
}).Count().ToString();
// 데이터 그리드 설정
//dataGridView1.DataSource = DataManager.Books;
dBBook.bookDataGridViewConnect(dataGridView1);
dataGridView1.ReadOnly = true;
//dataGridView2.DataSource = DataManager.Users;
dBUser.userDataGridViewConnect(dataGridView2);
dataGridView2.ReadOnly = true;
dataGridView1.CurrentCellChanged += DataGridView1_CurrentCellChanged;
dataGridView2.CurrentCellChanged += DataGridView2_CurrentCellChanged;
// 버튼 이벤트 설정
//button1.Click += Button1_Click;
button1.Click += borrowButtonClick;
//button2.Click += Button2_Click;
button2.Click += returnBook;
// 대여 및 반납기록 클릭 이벤트
대여및반납기록ToolStripMenuItem.Click += ShowHistoryForm;
}
private void searchAll(object sender, EventArgs e)
{
DBUtils.DBBook dBBook = new DBUtils.DBBook();
dBBook.bookDataGridViewConnect(dataGridView1);
}
