public static string GetFinalKSAS(long JAID)
{
DbCommand commandWrapper = null;
commandWrapper = BusinessBase.GetDbCommand("spr_GetAllFinalKSAFactorByJAID");
commandWrapper.Parameters.Add(new SqlParameter("@JAID", JAID));
DataTable dt = ExecuteDataTable(commandWrapper);
int index = 0;
StringBuilder listOfKSAs = new StringBuilder();
DataRow dr;
while (index < dt.Rows.Count)
{
dr = dt.Rows[index];
listOfKSAs.AppendFormat("{0}\n", ((string)dr["JAKSAdescription"]).Trim());
index = index + 1;
}
// Author: Deepali Anuje
// Bug # 555 - Consistency of Titles and lists on CR screen vs. CR PDF
// Logic in Database Function now to be consistent with reports.
// return FormatMultilineTextWithNumbers(listOfKSAs.ToString());
return(listOfKSAs.ToString());
}