public List <MatchEntity> LoadTopMatchGrades(string ConnectionString)
{
SettingFacade fac = new SettingFacade(ConnectionString);
DataTable dtResult = fac.GetTopMatchGradeSettings(true);
List <MatchEntity> lstMatches = new List <MatchEntity>();
if (dtResult.Rows.Count > 0)
{
// Get Match Grade and Confidence Code
MatchEntity objMatch = new MatchEntity();
objMatch.DnBConfidenceCode = Convert.ToInt32(0);
objMatch.DnBMatchGradeText = Convert.ToString("Select Match Grade");
lstMatches.Add(objMatch);
for (int i = 0; i < dtResult.Rows.Count; i++)
{
objMatch = new MatchEntity();
objMatch.DnBConfidenceCode = Convert.ToInt32(dtResult.Rows[i]["DnBConfidenceCode"]);
objMatch.DnBMatchGradeText = Convert.ToString(dtResult.Rows[i]["DnBMatchGradeText"]);
lstMatches.Add(objMatch);
}
}
return(lstMatches);
}
public static List <string> LoadTopMatchGrades(bool IsFirst)
{
List <string> lstMatchGrade = new List <string>();
SettingFacade fac = new SettingFacade("");
DataTable dtTopMatchResult = new DataTable();
dtTopMatchResult = fac.GetTopMatchGradeSettings(IsFirst);
if (dtTopMatchResult != null && dtTopMatchResult.Rows.Count > 0)
{
DataView dtView = dtTopMatchResult.DefaultView;
if (dtView != null)
{
dtView.Sort = "DnBMatchGradeText DESC";
DataTable dtResult = dtView.ToTable(true, "DnBMatchGradeText");
for (int i = 0; i < dtResult.Rows.Count; i++)
{
lstMatchGrade.Add(dtResult.Rows[i][0].ToString());
}
}
}
return(lstMatchGrade);
}
