private void grvDeviceTypes_GroupViewItemDoubleClick(GroupView sender, GroupViewItemDoubleClickEventArgs e)
{
btnApply.Enabled = true;
SelectedDeviceType = grvDeviceTypes.GroupViewItems[grvDeviceTypes.SelectedItem].Text;
this.DialogResult = DialogResult.OK;
this.Close();
}
private void grvDevices_GroupViewItemDoubleClick(GroupView sender, GroupViewItemDoubleClickEventArgs e)
{
// Add to group
sql.Open();
if (sql.ExecuteScalar <int>($"SELECT COUNT(*) FROM GroupAssigns WHERE GroupID = '{GroupID}' AND MACAddress = '{grvDevices.GroupViewItems[grvDevices.SelectedItem].Tag}'") == 0)
{
sql.ExecuteNonQuery($"INSERT INTO GroupAssigns (GroupID, MACAddress, IsPrimary) VALUES ('{GroupID}','{grvDevices.GroupViewItems[grvDevices.SelectedItem].Tag}', '0')");
}
sql.Close();
UpdateGroupDeviceList();
}
private void grvDevicesInGroup_GroupViewItemDoubleClick(GroupView sender, GroupViewItemDoubleClickEventArgs e)
{
// Remove from group
sql.ExecuteNonQueryACon($"DELETE FROM GroupAssigns WHERE GroupID = '{GroupID}' AND MACAddress = '{grvDevicesInGroup.GroupViewItems[grvDevicesInGroup.SelectedItem].Tag}'");
UpdateGroupDeviceList();
}
