public static void DeleteProductVersion(LoginUser loginUser, int productVersionID)
{
ProductVersions productVersions = new ProductVersions(loginUser);
using (SqlCommand command = new SqlCommand())
{
command.CommandText = "DELETE FROM OrganizationProducts WHERE (ProductVersionID = @ProductVersionID)";
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.Parameters.AddWithValue("@ProductVersionID", productVersionID);
productVersions.ExecuteNonQuery(command, "OrganizationProducts");
command.CommandText = "UPDATE Tickets SET SolvedVersionID = null WHERE (SolvedVersionID = @ProductVersionID)";
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.Parameters.AddWithValue("@ProductVersionID", productVersionID);
productVersions.ExecuteNonQuery(command, "Tickets");
command.CommandText = "UPDATE Tickets SET ReportedVersionID = null WHERE (ReportedVersionID = @ProductVersionID)";
command.CommandType = CommandType.Text;
command.Parameters.Clear();
command.Parameters.AddWithValue("@ProductVersionID", productVersionID);
productVersions.ExecuteNonQuery(command, "Tickets");
}
productVersions.LoadByProductVersionID(productVersionID);
if (!productVersions.IsEmpty)
{
productVersions[0].Delete();
}
productVersions.Save();
}
