/// <summary> /// Load an entry based from a given Phase /// </summary> /// <param name="targetPhase">PHASE1, PHASE2, PHASE3</param> /// <param name="perBatch"></param> /// <param name="currentBatch"></param> public DataTable LoadPhaseXFromDb(string targetPhase = "PHASE1", int perBatch = 50, int currentBatch = 1) { Dictionary <string, string> innerC = new Dictionary <string, string>() { ["Phase"] = targetPhase }; MyDbUtils mdu = new MyDbUtils(this.DbPath); return(mdu.LoadEntriesViaSubquery(TABLE_NAME, perBatch, currentBatch, targetColumn: "FileName", innerCriteria: innerC)); }
/// <summary> /// Load an entry based from a given FileName /// </summary> /// <param name="targetFile"></param> /// <param name="perBatch"></param> /// <param name="currentBatch"></param> public DataTable LoadFileNameAndPhaseFromDb(string targetFile, string targetPhase, int perBatch = 50, int currentBatch = 1) { Dictionary <string, string> innerC = new Dictionary <string, string>() { ["FileName"] = targetFile, ["Phase"] = targetPhase }; Dictionary <string, string> outerC = new Dictionary <string, string>() { ["FileName"] = targetFile, ["Phase"] = targetPhase }; MyDbUtils mdu = new MyDbUtils(this.DbPath); return(mdu.LoadEntriesViaSubquery(TABLE_NAME, perBatch, currentBatch, targetColumn: "FileName", innerCriteria: innerC, outerCriteria: outerC, outerOrderBy: "Phase")); }