private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == dataGridView1.Columns[12].Index && (e.RowIndex >= 0 && e.RowIndex < dataGridView1.Rows.Count - 1))
{
int index = e.RowIndex;
DataGridViewRow row = dataGridView1.Rows[index];
String id = row.Cells[13].Value.ToString();
imag_viewer view = new imag_viewer(id);
view.Show();
}
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == dataGridView1.Columns["edit_button"].Index && (e.RowIndex >= 0))
{
int index = e.RowIndex;
DataGridViewRow row = dataGridView1.Rows[index];
DialogResult result = MessageBox.Show("Book Name:\t" + row.Cells[1].Value.ToString() + "\n\nDo you Want to update this book ?", "Wellcome User", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
String id = row.Cells[0].Value.ToString();
book_edit edit = new book_edit(id);
edit.Show();
}
}
if (account == 1)
{
if (e.ColumnIndex == dataGridView1.Columns["delete_button"].Index && (e.RowIndex >= 0))
{
int index = e.RowIndex;
DataGridViewRow row = dataGridView1.Rows[index];
DialogResult result = MessageBox.Show("Book Name:\t" + row.Cells[1].Value.ToString() + "\n\nDo you Want to Delete this book ?", "Wellcome User", MessageBoxButtons.OKCancel);
if (result == DialogResult.OK)
{
String id = row.Cells[0].Value.ToString();
try
{
String con = ConfigurationManager.ConnectionStrings["WindowsFormsApplication1.Properties.Settings.librarayManagementConnectionString"].ConnectionString;
SqlConnection sqlCon = new SqlConnection(con);
sqlCon.Open();
String query = "DELETE FROM book_registration WHERE book_id='" + id + "'";
SqlCommand cmd = new SqlCommand(query, sqlCon);
cmd.ExecuteNonQuery();
MessageBox.Show("Record has been Deleted");
sqlCon.Close();
loadbook();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
if (e.ColumnIndex == dataGridView1.Columns["review_button"].Index && (e.RowIndex >= 0))
{
int index = e.RowIndex;
DataGridViewRow row = dataGridView1.Rows[index];
String id = row.Cells[0].Value.ToString();
commentReview comment = new commentReview(id);
comment.Show();
}
if (e.ColumnIndex == dataGridView1.Columns[12].Index && (e.RowIndex >= 0))
{
int index = e.RowIndex;
DataGridViewRow row = dataGridView1.Rows[index];
String id = row.Cells[0].Value.ToString();
imag_viewer view = new imag_viewer(id);
view.Show();
}
}