private void dtGrid_CellClick(object sender, DataGridViewCellEventArgs e)
{
var senderGrid = (DataGridView)sender;
if (e.ColumnIndex == dtGrid.Columns["Select"].Index && e.RowIndex >= 0)
{
dtGrid.CurrentCell.Value = dtGrid.CurrentCell.FormattedValue.ToString() == "True" ? false : true;
dtGrid.RefreshEdit();
if (selectedIDs.Contains(dtGrid.Rows[e.RowIndex].Cells["id"].Value.ToString()))
{
selectedIDs.Remove(dtGrid.Rows[e.RowIndex].Cells["id"].Value.ToString());
}
else
{
selectedIDs.Add(dtGrid.Rows[e.RowIndex].Cells["id"].Value.ToString());
}
}
if (e.ColumnIndex == dtGrid.Columns["View"].Index && e.RowIndex >= 0)
{
InstructionReport form = new InstructionReport(dtGrid.Rows[e.RowIndex].Cells["no"].Value.ToString());
form.Show();
}
try
{
if (e.ColumnIndex == dtGrid.Columns["Delete"].Index && e.RowIndex >= 0)
{
if (MessageBox.Show("YES or No?", "Are you sure you want to delete this Instruction? ", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
string Query = "DELETE from instruction WHERE id ='" + dtGrid.Rows[e.RowIndex].Cells["id"].Value.ToString() + "'";
MySQL.Query(Query);
Queries q = new Queries(Guid.NewGuid().ToString(), Helper.UserName, Helper.CleanString(MySQL.Insert(Query)), "false", DateTime.Now.ToString("dd-MM-yyyy H:m:s"), Helper.CompanyID);
MySQL.Insert(q);
MessageBox.Show("Information deleted");
LoadData();
}
}
}
catch { }
}
private void button1_Click(object sender, EventArgs e)
{
InstructionReport form = new InstructionReport(noTxt.Text);
form.Show();
}