private string OwlWorksWaitingListList()
{
StringBuilder sb = new StringBuilder();
ExportManager oEM = new ExportManager();
DataTable dt = ExportDataDAL.OwlWorksWaitingListList();
if (dt != null && dt.Rows != null && dt.Rows.Count > 0)
{
string strOutput = "";
string strData = "";
DateTime datDate = new DateTime();
string memberId = "";
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 dc in dt.Columns)
{
strData = Convert.ToString(dr[dc.Ordinal]);
switch (dc.Caption)
{
case "BirthDate":
case "MemberDate":
case "ProbationaryDate":
case "ApplicationDate":
case "EWLDate":
case "WhiteAppApprovedDate":
case "WhiteAppReceivedDate":
{
if (DateTime.TryParse(strData, out datDate) == true)
{
strData = datDate.ToString("MM/dd/yyyy");
}
else
{
strData = "";
}
break;
}
case "YearsInClub":
memberId = Convert.ToString(dr["MemberID"]);
strData = oEM.GetYearsInClub(memberId).ToString();
break;
default:
break;
}
if (dc.Ordinal > 0)
{
strOutput += "\t";
}
strOutput += strData;
}
sb.AppendLine(strOutput);
}
}
return(sb.ToString());
}