void displayLibrarianData() { DatabaseAdapter databaseadapter = new DatabaseAdapter(); DataTable librariantable = new DataTable(); librariantable = databaseadapter.getLibrarian(); dataGridViewLibrarian.DataSource = librariantable; }
void displayBookData() { DatabaseAdapter databaseadapter = new DatabaseAdapter(); DataTable booktable = new DataTable(); booktable = databaseadapter.getBooks(); dataGridViewBooks.DataSource = booktable; }
void displayBookData() { DatabaseAdapter databaseadapter = new DatabaseAdapter(); DataTable booktable = new DataTable(); booktable = databaseadapter.getBooks(); dataGridViewBooks.DataSource = booktable; }
void displayMemberData() { DatabaseAdapter databaseadapter = new DatabaseAdapter(); DataTable membertable = new DataTable(); membertable = databaseadapter.getMember(); dataGridViewMember.DataSource = membertable; databaseadapter = null; }
void displayLibrarianData() { DatabaseAdapter databaseadapter = new DatabaseAdapter(); DataTable librariantable = new DataTable(); librariantable = databaseadapter.getLibrarian(); dataGridViewLibrarian.DataSource = librariantable; }
void displayMemberData() { DatabaseAdapter databaseadapter = new DatabaseAdapter(); DataTable membertable = new DataTable(); membertable = databaseadapter.getMember(); dataGridViewMember.DataSource = membertable; databaseadapter = null; }
private void buttonDelete_Click(object sender, EventArgs e) { DatabaseAdapter databaseadapter = new DatabaseAdapter (); int row = dataGridViewMember.CurrentCell.RowIndex; if (row == -1) { MessageBox.Show("Select an entry to delete."); } else { int id = Convert.ToInt32(dataGridViewMember.Rows[row].Cells[0].Value.ToString()); databaseadapter.deleteMember(id); displayMemberData(); MessageBox.Show("Deleted Successfully!"); } }
private void buttonDelete_Click(object sender, EventArgs e) { DatabaseAdapter databaseadapter = new DatabaseAdapter(); int row = dataGridViewMember.CurrentCell.RowIndex; if (row == -1) { MessageBox.Show("Select an entry to delete."); } else { int id = Convert.ToInt32(dataGridViewMember.Rows[row].Cells[0].Value.ToString()); databaseadapter.deleteMember(id); displayMemberData(); MessageBox.Show("Deleted Successfully!"); } }
private void buttonLoginSubmit_Click(object sender, EventArgs e) { string email = textLibrarianEmail.Text; string password = textPassword.Text; DatabaseAdapter databaseadapter = new DatabaseAdapter(); string message = databaseadapter.isLibrarian(email, password); if (message == "Success") { MessageBox.Show("Login Successful! Welcome!"); AdminPanel adminpanel = new AdminPanel(this, email); } else if (message == "Incorrect Password") { MessageBox.Show("Incorrect Password. Try Again!"); } else { MessageBox.Show("No such account"); } }
private void buttonUpdate_Click(object sender, EventArgs e) { DatabaseAdapter databaseadapter = new DatabaseAdapter(); int row = dataGridViewMember.CurrentCell.RowIndex; if (row == -1) { MessageBox.Show("Select an entry to delete."); } else { int id = Convert.ToInt32(dataGridViewMember.Rows[row].Cells[0].Value.ToString()); string name = dataGridViewMember.Rows[row].Cells[1].Value.ToString(); int age = Convert.ToInt32(dataGridViewMember.Rows[row].Cells[2].Value.ToString()); string contact = dataGridViewMember.Rows[row].Cells[3].Value.ToString(); string email = dataGridViewMember.Rows[row].Cells[4].Value.ToString(); databaseadapter.updateMember(id, name, age, contact, email); displayMemberData(); MessageBox.Show("Updated Successfully!"); } }
private void buttonUpdate_Click(object sender, EventArgs e) { DatabaseAdapter databaseadapter = new DatabaseAdapter(); int row = dataGridViewMember.CurrentCell.RowIndex; if (row == -1) { MessageBox.Show("Select an entry to delete."); } else { int id = Convert.ToInt32(dataGridViewMember.Rows[row].Cells[0].Value.ToString()); string name = dataGridViewMember.Rows[row].Cells[1].Value.ToString(); int age = Convert.ToInt32(dataGridViewMember.Rows[row].Cells[2].Value.ToString()); string contact = dataGridViewMember.Rows[row].Cells[3].Value.ToString(); string email = dataGridViewMember.Rows[row].Cells[4].Value.ToString(); databaseadapter.updateMember(id, name, age, contact, email); displayMemberData(); MessageBox.Show("Updated Successfully!"); } }
private void buttonUpdate_Click(object sender, EventArgs e) { DatabaseAdapter databaseadapter = new DatabaseAdapter(); int row = dataGridViewBooks.CurrentCell.RowIndex; if (row == -1) { MessageBox.Show("Select an entry to update."); } else { int id = Convert.ToInt32(dataGridViewBooks.Rows[row].Cells[0].Value.ToString()); string name = dataGridViewBooks.Rows[row].Cells[1].Value.ToString(); string author = dataGridViewBooks.Rows[row].Cells[2].Value.ToString(); string publisher = dataGridViewBooks.Rows[row].Cells[3].Value.ToString(); int price = Convert.ToInt32(dataGridViewBooks.Rows[row].Cells[2].Value.ToString()); int quantity = Convert.ToInt32(dataGridViewBooks.Rows[row].Cells[2].Value.ToString()); string readerclass = dataGridViewBooks.Rows[row].Cells[4].Value.ToString(); databaseadapter.updateBook(id, name, author, publisher, price, quantity, readerclass); displayBookData(); MessageBox.Show("Updated Successfully!"); } }
private void buttonLoginSubmit_Click(object sender, EventArgs e) { string email = textLibrarianEmail.Text; string password = textPassword.Text; DatabaseAdapter databaseadapter = new DatabaseAdapter(); string message = databaseadapter.isLibrarian(email, password); if (message == "Success") { MessageBox.Show("Login Successful! Welcome!"); AdminPanel adminpanel = new AdminPanel(this, email); } else if (message == "Incorrect Password") { MessageBox.Show("Incorrect Password. Try Again!"); } else { MessageBox.Show("No such account"); } }
private void buttonUpdate_Click(object sender, EventArgs e) { DatabaseAdapter databaseadapter = new DatabaseAdapter(); int row = dataGridViewBooks.CurrentCell.RowIndex; if (row == -1) { MessageBox.Show("Select an entry to update."); } else { int id = Convert.ToInt32(dataGridViewBooks.Rows[row].Cells[0].Value.ToString()); string name = dataGridViewBooks.Rows[row].Cells[1].Value.ToString(); string author = dataGridViewBooks.Rows[row].Cells[2].Value.ToString(); string publisher = dataGridViewBooks.Rows[row].Cells[3].Value.ToString(); int price = Convert.ToInt32(dataGridViewBooks.Rows[row].Cells[2].Value.ToString()); int quantity = Convert.ToInt32(dataGridViewBooks.Rows[row].Cells[2].Value.ToString()); string readerclass = dataGridViewBooks.Rows[row].Cells[4].Value.ToString(); databaseadapter.updateBook(id, name, author, publisher, price, quantity, readerclass); displayBookData(); MessageBox.Show("Updated Successfully!"); } }