private void aButtonDeleteLog_Click(object sender, EventArgs e)
{
List <int> SelectedRows = new List <int>();
//SelectedRows = Utilities.DGVGetSelectedRows_Int(aDataGridViewLogs); // Gets Row Id of each selected row/cell.
SelectedRows = DGVUtilities.DGVGetColumXofSelectedCell(aDataGridViewLogs, 0); // Gets Row Id of each selected row/cell.
int SelectedRowIndex = aDataGridViewLogs.CurrentCell.RowIndex;
if (SelectedRows.Count >= 1)
{
// VERIFY DELETE
DialogResult dialogResultMulti = MessageBox.Show($"Are you sure you want to delete the selected logs from the database?", "Verification", MessageBoxButtons.YesNo);
if (dialogResultMulti == DialogResult.Yes)
{
// DELETE SELECTED ROW/S
foreach (int row in SelectedRows)
{
DataAccess_ChangeLogTable db = new DataAccess_ChangeLogTable();
db.DeleteLog(row, Config.DBDir_Name);
}
// REFRESH LOGS
ViewLogsForm_Shown(this, e);
if (SelectedRowIndex > 0)
{
aDataGridViewLogs.CurrentCell = aDataGridViewLogs.Rows[SelectedRowIndex - 1].Cells[1];
}
else
{
aDataGridViewLogs.CurrentCell = aDataGridViewLogs.Rows[SelectedRowIndex].Cells[1];
}
}
}
}
private void aButtonDelete_Click(object sender, EventArgs e)
{
// SAVE POSITION AND SORTATION
Class_Library.DataGridView.DGVPositionInfo DGVPOS = DGVUtilities.GetPosition(aDataGridViewMachines);
Class_Library.DataGridView.DGVSortInfo DGVSortInfo = DGVUtilities.GetSortation(aDataGridViewMachines);
if (aDataGridViewMachines.SelectedCells.Count > 1) // IF MULTIPLE MACHINES ARE SELECTED
{
// INSTANTIATE LIST FOR STORING MACHINE ID'S
List <int> SelectedMachines_ID = new List <int>();
// GET LIST OF MACHINE ID'S
SelectedMachines_ID = DGVUtilities.DGVGetColumXofSelectedCell(aDataGridViewMachines, 0);
DialogResult dialogResult = MessageBox.Show($"Are you sure you want to delete {SelectedMachines_ID.Count()} machines from the database?", "Verification", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
// GET CHANGES MADE
List <string> ChangesMade = new List <string>();
ChangesMade.Add($"Deleted {SelectedMachines_ID.Count} machines.");
// CREATE LOG OF DELETED MACHINE
Utilities.CreateLog(ChangesMade, InputLicense.Id);
// DELETE MACHINE
DataAccess_LicensedMachinesTable.DeleteLicensedMachine(SelectedMachines_ID, Config.DBDir_Name);
}
}
else if (aDataGridViewMachines.SelectedCells.Count == 1) // IF 1 MACHINE IS SELECTED
{
// CONFIRM DELETE
string MachineName = $"{aDataGridViewMachines[2, aDataGridViewMachines.CurrentCell.RowIndex].FormattedValue.ToString()}";
DialogResult dialogResult = MessageBox.Show($"Are you sure you want to delete '{MachineName}' from the database?", "Verification", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
// GET CHANGES MADE
List <string> ChangesMade = new List <string>();
ChangesMade.Add($"Deleted Machine: '{MachineName}'");
// CREATE LOG OF DELETED MACHINE
Utilities.CreateLog(ChangesMade, InputLicense.Id);
// DELETE MACHINE
DataAccess_LicensedMachinesTable.DeleteLicensedMachine(Convert.ToInt32(aDataGridViewMachines[0, aDataGridViewMachines.CurrentCell.RowIndex].FormattedValue), Config.DBDir_Name);
}
}
else // IF NO MACHINES ARE SELECTED
{
return;
}
RefreshDataGridViewTable();
// SET POSITION AND SORTATION
DGVPOS.SelectedRow -= 1; // Minus 1 for cases where the last machine in the list was deleted.
DGVUtilities.SetPosition(DGVPOS, aDataGridViewMachines);
DGVUtilities.SetSortation(DGVSortInfo, aDataGridViewMachines);
}