private void btnAddOnlineDrive_Click(object sender, EventArgs e) { QDAddPublicDrive addDrive = new QDAddPublicDrive(); if (addDrive.ShowDialog() == DialogResult.OK) { try { mysql.ExecuteNonQueryACon("INSERT INTO qd_drives (ID, DefaultName, DefaultDriveLetter, LocalPath, IsPublic, IsDeployable) VALUES (?,?,?,?,?,?)", Guid.NewGuid(), addDrive.DriveName, addDrive.DriveLetter, addDrive.DrivePath, true, addDrive.CanBeDeployed ); } catch { MessageBox.Show("Could not add drive. Please try again later.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } UpdateOnlineDrives(); } }
private void EditSelectedDrive() { if (lbxOnlineDrives.SelectedIndex != -1) { string driveID = lbxOnlineDrives.SelectedValue.ToString(); if (!QDLib.ManagedDBOpen(mysql)) { QDLib.DBOpenFailed(); return; } string drivePath = mysql.ExecuteScalar <string>("SELECT LocalPath FROM qd_drives WHERE ID = ?", driveID); string defaultName = mysql.ExecuteScalar <string>("SELECT DefaultName FROM qd_drives WHERE ID = ?", driveID); string defaultLetter = mysql.ExecuteScalar <string>("SELECT DefaultDriveLetter FROM qd_drives WHERE ID = ?", driveID); bool canBeDeployed = Convert.ToBoolean(mysql.ExecuteScalar <short>("SELECT IsDeployable FROM qd_drives WHERE ID = ?", driveID)); mysql.Close(); QDAddPublicDrive editDrive = new QDAddPublicDrive { EditMode = true, DrivePath = drivePath, DriveName = defaultName, DriveLetter = defaultLetter, CanBeDeployed = canBeDeployed }; if (editDrive.ShowDialog() == DialogResult.OK) { try { mysql.ExecuteNonQueryACon("UPDATE qd_drives SET DefaultName = ?, DefaultDriveLetter = ?, LocalPath = ?, IsDeployable = ? WHERE ID = ?", editDrive.DriveName, editDrive.DriveLetter, editDrive.DrivePath, editDrive.CanBeDeployed, driveID ); } catch { MessageBox.Show("Could not update drive data. Please try again later.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } UpdateOnlineDrives(); } } }