private string BlueBookHonoraryRegularList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.BlueBookHonoraryRegularList();
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 = "/1" + (Convert.ToString(dr["OldGuard"]) == "Y" ? "*" : "");
strOutput += "/2" + Convert.ToString(dr["ReportName"]).Trim();
strOutput += "/3" + memberDate;
strOutput += "/4" + (Convert.ToString(dr["TalentText"]) == "" ? "" : Convert.ToString(dr["TalentText"]));
strOutput += "/5";
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}