/// <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"));
}
