public DeficientResult GetData(SimulationModel data, int[] totalYears) { // Deficient and DeficientResults are models. Deficient gets data // from the database. DeficientResult gets the processed data IQueryable <DeficientReportModel> deficients = null; DeficientResult result = null; var select = "SELECT TargetID, Years, TargetMet, IsDeficient " + " FROM Target_" + data.NetworkId + "_" + data.SimulationId; try { var rawDeficientList = db.Database.SqlQuery <DeficientReportModel>(select).AsQueryable(); deficients = rawDeficientList.Where(_ => _.IsDeficient == true); var targetAndYear = this.deficients.GetData(deficients); result = GetDeficientInformation(data, targetAndYear, totalYears); } catch (SqlException ex) { HandleException.SqlError(ex, "Target"); } catch (OutOfMemoryException ex) { HandleException.OutOfMemoryError(ex); } catch (Exception ex) { HandleException.GeneralError(ex); } return(result); }
public DeficientReportDAL(BridgeCareContext context, TargetsMetDAL deficient, CellAddress cell) { db = context ?? throw new ArgumentNullException(nameof(context)); deficients = deficient ?? throw new ArgumentNullException(nameof(deficient)); address = cell ?? throw new ArgumentNullException(nameof(cell)); }
public TargetsDAL(TargetsMetDAL targetsMetDAL, TargetResultsDAL targetCells) { this.targetsMetDAL = targetsMetDAL ?? throw new ArgumentNullException(nameof(targetsMetDAL)); this.targetCells = targetCells ?? throw new ArgumentNullException(nameof(targetCells)); }