/// <summary>
/// Delete simulation
/// </summary>
/// <param name="simulationID">SimulationID of simulation to delete</param>
public static void DeleteSimulation(string simulationID)
{
if (DB.CheckIfTableExists(DB.TablePrefix + "SIMULATION_1_" + simulationID) == 1)
{
DB.DropTable(DB.TablePrefix + "SIMULATION_1_" + simulationID);
}
if (DB.CheckIfTableExists(DB.TablePrefix + "BENEFITCOST_1_" + simulationID) == 1)
{
DB.DropTable(DB.TablePrefix + "BENEFITCOST_1_" + simulationID);
}
if (DB.CheckIfTableExists(DB.TablePrefix + "REPORT_1_" + simulationID) == 1)
{
DB.DropTable(DB.TablePrefix + "REPORT_1_" + simulationID);
}
if (DB.CheckIfTableExists(DB.TablePrefix + "TARGET_1_" + simulationID) == 1)
{
DB.DropTable(DB.TablePrefix + "TARGET_1_" + simulationID);
}
using (SqlConnection connection = new SqlConnection(DB.ConnectionString))
{
try
{
connection.Open();
SqlCommand cmd = new SqlCommand("DELETE FROM " + DB.TablePrefix + "SIMULATIONS WHERE SIMULATIONID=@simulationID", connection);
cmd.Parameters.Add(new SqlParameter("simulationID", simulationID));
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
Utility.ExceptionHandling.DataAccessExceptionHandler.HandleException(e, false);
}
}
}
