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()); }