private string OwlWorksAssociateList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.OwlWorksAssociateList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
string strOutput = "";
string strData = "";
DateTime datDate = new DateTime();
foreach (DataColumn dc in dt.Columns)
{
if (dc.Ordinal > 0)
{
strOutput += "\t";
}
strOutput += dc.Caption;
}
sb.AppendLine(strOutput);
foreach (DataRow dr in dt.Rows)
{
strOutput = "";
foreach (DataColumn dc1 in dt.Columns)
{
strData = Convert.ToString(dr[dc1.Ordinal]);
switch (dc1.Caption)
{
case "ProbationaryDate":
case "HonoraryDate":
case "WhiteAppApprovedDate":
case "WhiteAppReceivedDate":
{
if (DateTime.TryParse(strData, out datDate) == true)
{
strData = datDate.ToString("MM/dd/yyyy");
}
else
{
strData = "";
}
break;
}
default:
break;
}
if (dc1.Ordinal > 0)
{
strOutput += "\t";
}
strOutput += strData;
}
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}