/// <summary> /// Delete all damage extents of project in the database /// </summary> /// <param name="projectId"></param> public void deleteDamageExtentsFromDB(int projectId) { if (projectId < 1) { return; } string _deleteQueryString = $"delete " + $"from \"DamageExtent\" " + $"where \"DamageExtent\".\"MappedObjectId\" in " + $"(select damageextent.\"MappedObjectId\" " + $"from \"DamageExtent\" as damageextent, \"Intensity\" as intensity " + $"where intensity.\"Project_Id\" = {projectId} " + $"and damageextent.\"IntensityId\" = intensity.\"ID\") "; using (var transaction = DBManager.ActiveSession.BeginTransaction()) { ISQLQuery query = ActiveSession.CreateSQLQuery(_deleteQueryString); query.ExecuteUpdate(); DBManager.ActiveSession.Flush(); transaction.Commit(); } //Change the project to state "Started" var _resultController = new ResultController(); _resultController.setProjectStatus(projectId, 1); }