/// <summary> /// Load an entry based from a given Username /// </summary> /// <param name="perBatch"></param> /// <param name="currentBatch"></param> public DataTable LoadFromDbViaUsername(string emailUsername, int perBatch = 50, int currentBatch = 1) { Dictionary <string, string> criteriaX = new Dictionary <string, string>() { ["EmailUsername"] = emailUsername }; MyDbUtils mdu = new MyDbUtils(this.DbPath); return(mdu.LoadEntries(tableName: TABLE_NAME, orderBy: "EmailUsername", perBatch: perBatch, currentBatch: currentBatch, criteria: criteriaX)); }
/// <summary> /// Load an entry based from a given Username /// </summary> /// <param name="perBatch"></param> /// <param name="currentBatch"></param> /// <param name="phaseX">PHASE1 PHASE2 or PHASE3</param> public DataTable LoadFromDbIsAvailable(string phaseX, int perBatch = 50, int currentBatch = 1) { string groupX = string.Empty; if (!string.IsNullOrEmpty(phaseX)) { groupX = phaseX?.Last().ToString().Trim() ?? string.Empty; } Dictionary <string, string> criteriaX = new Dictionary <string, string>() { ["IsAvailable"] = "YES", ["RecipientGroup"] = groupX }; MyDbUtils mdu = new MyDbUtils(this.DbPath); return(mdu.LoadEntries(tableName: TABLE_NAME, orderBy: "RecipientGroup", perBatch: perBatch, currentBatch: currentBatch, criteria: criteriaX)); }