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();
}
}
}
