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