private void UpdateVersion_Click(object sender, RoutedEventArgs e)
{
Versions currentVersion = VersionLB.SelectedItem as Versions;
bool bSuccess = false;
if (currentVersion is null)
{
MessageBox.Show("Please select a version to be deleted.");
}
else
{
bSuccess = st.UpdateVersion(currentVersion, VersionTB.Text);
if (bSuccess)
{
MessageBox.Show("The version: " + currentVersion.VersionName + " has been updated to: " + VersionTB.Text);
Versions.Where(name => name.VersionName == currentVersion.VersionName).First().VersionName = VersionTB.Text;
VersionLB.Items.Refresh();
VersionTB.Clear();
}
}
}
private void RemoveVersion_Click(object sender, RoutedEventArgs e)
{
Versions currentVersion = VersionLB.SelectedItem as Versions;
bool bSuccess = false;
if (currentVersion is null)
{
MessageBox.Show("Please select a version to be deleted.");
}
else
{
bSuccess = st.DeleteVersion(currentVersion);
if (bSuccess)
{
MessageBox.Show("The version: " + currentVersion.VersionName + " has been deleted from the version list");
Versions.Remove(currentVersion);
VersionLB.Items.Refresh();
VersionTB.Clear();
}
}
}
public bool UpdateVersion(Versions oldVersion, string newVersion)
{
string sSQL = "UPDATE St_Versions SET Version = '" + newVersion + "' WHERE Version = '" + oldVersion.VersionName + "'";
return(m_oDBConn.ExecuteNonQuery(sSQL));
}
public bool DeleteVersion(Versions Name)
{
string sSQL = "DELETE FROM St_Versions WHERE Version = '" + Name.VersionName + "'";
return(m_oDBConn.ExecuteNonQuery(sSQL));
}