protected string GetResources(int CType, int itemType, int itemId, int stateId, bool isOverdue)
{
StringBuilder builder = new StringBuilder();
if (itemType > 0)
{
bool hasResources = false;
switch (itemType)
{
case (int)ObjectTypes.Project:
using (IDataReader reader = Project.GetListTeamMemberNames(itemId))
{
while (reader.Read())
{
hasResources = true;
if (stateId == (int)ObjectStates.Completed)
{
builder.AppendFormat("<tr><td><span style='color:#999999;text-decoration:line-through'>{0}</span></td></tr>", Util.CommonHelper.GetUserStatus((int)reader["UserId"], ""));
}
else if (stateId == (int)ObjectStates.Overdue || isOverdue)
{
builder.AppendFormat("<tr><td>{0}</td></tr>", Util.CommonHelper.GetUserStatus((int)reader["UserId"], "red"));
}
else
{
builder.AppendFormat("<tr><td>{0}</td></tr>", Util.CommonHelper.GetUserStatus((int)reader["UserId"], ""));
}
}
}
break;
case (int)ObjectTypes.Task:
using (IDataReader reader = Task.GetListResources(itemId))
{
while (reader.Read())
{
hasResources = true;
if (stateId == (int)ObjectStates.Completed)
{
builder.AppendFormat("<tr><td><span style='color:#999999;text-decoration:line-through'>{0}</span></td>{1}</tr>", Util.CommonHelper.GetUserStatus((int)reader["UserId"], ""), (CType == (int)CompletionType.All) ? ("<td style='padding-left:7'><span style='color:#999999;text-decoration:line-through'><span style='color:black'>" + reader["PercentCompleted"].ToString() + "%</span></span></td>") : "");
}
else if (stateId == (int)ObjectStates.Overdue || isOverdue)
{
builder.AppendFormat("<tr><td>{0}</td>{1}</tr>", Util.CommonHelper.GetUserStatus((int)reader["UserId"], "red"), (CType == (int)CompletionType.All) ? "<td style='padding-left:7'><span style='color:red'>" + reader["PercentCompleted"].ToString() + "%</span></td>" : "");
}
else
{
builder.AppendFormat("<tr><td>{0}</td>{1}</tr>", Util.CommonHelper.GetUserStatus((int)reader["UserId"], ""), (CType == (int)CompletionType.All) ? "<td style='padding-left:7'>" + reader["PercentCompleted"].ToString() + "%</td>" : "");
}
}
}
break;
case (int)ObjectTypes.ToDo:
using (IDataReader reader = Mediachase.IBN.Business.ToDo.GetListResources(itemId))
{
while (reader.Read())
{
hasResources = true;
if (stateId == (int)ObjectStates.Completed)
{
builder.AppendFormat("<tr><td><span style='color:#999999;text-decoration:line-through'>{0}</span></td>{1}</tr>", Util.CommonHelper.GetUserStatus((int)reader["UserId"], ""), (CType == (int)CompletionType.All) ? ("<td style='padding-left:7'><span style='color:#999999;text-decoration:line-through'><span style='color:black'>" + reader["PercentCompleted"].ToString() + "%</span></span></td>") : "");
}
else if (stateId == (int)ObjectStates.Overdue || isOverdue)
{
builder.AppendFormat("<tr><td>{0}</td>{1}</tr>", Util.CommonHelper.GetUserStatus((int)reader["UserId"], "red"), (CType == (int)CompletionType.All) ? "<td style='padding-left:7'><span style='color:red'>" + reader["PercentCompleted"].ToString() + "%</span></td>" : "");
}
else
{
builder.AppendFormat("<tr><td>{0}</td>{1}</tr>", Util.CommonHelper.GetUserStatus((int)reader["UserId"], ""), (CType == (int)CompletionType.All) ? "<td style='padding-left:7'>" + reader["PercentCompleted"].ToString() + "%</td>" : "");
}
}
}
break;
case (int)ObjectTypes.Document:
using (IDataReader reader = Document.GetListResources(itemId))
{
while (reader.Read())
{
hasResources = true;
if (stateId == (int)ObjectStates.Completed)
{
builder.AppendFormat("<tr><td><span style='color:#999999;text-decoration:line-through'>{0}</span></td></tr>", Util.CommonHelper.GetUserStatus((int)reader["PrincipalId"], ""));
}
else if (stateId == (int)ObjectStates.Overdue || isOverdue)
{
builder.AppendFormat("<tr><td>{0}</td></tr>", Util.CommonHelper.GetUserStatus((int)reader["PrincipalId"], "red"));
}
else
{
builder.AppendFormat("<tr><td>{0}</td></tr>", Util.CommonHelper.GetUserStatus((int)reader["PrincipalId"], ""));
}
}
}
break;
case (int)ObjectTypes.Issue:
using (IDataReader reader = Incident.GetListIncidentResources(itemId))
{
while (reader.Read())
{
hasResources = true;
if (stateId == (int)ObjectStates.Completed)
{
builder.AppendFormat("<tr><td><span style='color:#999999;text-decoration:line-through'>{0}</span></td></tr>", Util.CommonHelper.GetUserStatus((int)reader["PrincipalId"], ""));
}
else if (stateId == (int)ObjectStates.Overdue || isOverdue)
{
builder.AppendFormat("<tr><td>{0}</td></tr>", Util.CommonHelper.GetUserStatus((int)reader["PrincipalId"], "red"));
}
else
{
builder.AppendFormat("<tr><td>{0}</td></tr>", Util.CommonHelper.GetUserStatus((int)reader["PrincipalId"], ""));
}
}
}
break;
case (int)ObjectTypes.CalendarEntry:
using (IDataReader reader = CalendarEntry.GetListResources(itemId))
{
while (reader.Read())
{
hasResources = true;
if (stateId == (int)ObjectStates.Completed)
{
builder.AppendFormat("<tr><td><span style='color:#999999;text-decoration:line-through'>{0}</span></td></tr>", Util.CommonHelper.GetUserStatus((int)reader["PrincipalId"], ""));
}
else if (stateId == (int)ObjectStates.Overdue || isOverdue)
{
builder.AppendFormat("<tr><td>{0}</td></tr>", Util.CommonHelper.GetUserStatus((int)reader["PrincipalId"], "red"));
}
else
{
builder.AppendFormat("<tr><td>{0}</td></tr>", Util.CommonHelper.GetUserStatus((int)reader["PrincipalId"], ""));
}
}
}
break;
}
if (hasResources)
{
builder.Insert(0, "<table class='text' cellspacing='0' cellpadding='1' border='0'>");
builder.Append("</table>");
}
}
return(builder.ToString());
}
