private string BlueBookRosterList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.BlueBookRosterList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
string strOutput = "";
DateTime dtMemberDate;
string memberDate = "";
if (DateTime.TryParse(Convert.ToString(dr["MemberDate"]), out dtMemberDate) == true)
{
memberDate = dtMemberDate.ToString("MMMM d, yyyy");
}
strOutput = (Convert.ToString(dr["OldGuard"]) == "Y" ? "*" : "");
strOutput += "\t" + Convert.ToString(dr["ReportName"]).Trim();
strOutput += Convert.ToString(dr["MembershipCategoryID"]) == "9" ? " " + Convert.ToString(dr["MilitaryServiceText"]) : (" " + Convert.ToString(dr["MembershipCategoryText"])) + (Convert.ToString(dr["MemberText"]) == "" ? "" : " " + Convert.ToString(dr["MemberText"]));
strOutput += "\t" + memberDate;
strOutput += "\t" + (Convert.ToString(dr["TalentText"]) == "" ? "" : Convert.ToString(dr["TalentText"])); // dum line of code why do we need to check? - Copied from BCIS
strOutput += "\t";
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}