private bool LoadStatus(int _resourceid)
{
bool boolRed = false;
DataSet dsStatus = oResourceRequest.GetStatuss(_resourceid);
rptStatus.DataSource = dsStatus;
rptStatus.DataBind();
lblNoStatus.Visible = (rptStatus.Items.Count == 0);
double dblTotalStatus = 0.00;
foreach (RepeaterItem ri in rptStatus.Items)
{
Label _status = (Label)ri.FindControl("lblStatus");
if (boolRed == false && _status.Text == "1")
{
boolRed = true;
}
double dblStatus = double.Parse(_status.Text);
if (dblTotalStatus == 0.00)
{
dblTotalStatus = dblStatus;
}
_status.Text = oResourceRequest.GetStatus(dblStatus, 50, 15);
}
lblStatus.Text = oResourceRequest.GetStatus(dblTotalStatus, 50, 15);
return(boolRed);
}
private string GetSummary(int _requestid, int _serviceid, int _number)
{
Users oUser = new Users(intProfile, dsn);
ServiceRequests oServiceRequest = new ServiceRequests(intProfile, dsn);
RequestItems oRequestItem = new RequestItems(intProfile, dsn);
Applications oApplication = new Applications(intProfile, dsn);
StringBuilder sbSummary = new StringBuilder();
DataSet ds = oResourceRequest.GetRequestService(_requestid, _serviceid, _number);
int intCount = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
intCount++;
int intResource = Int32.Parse(dr["id"].ToString());
double dblAllocated = double.Parse(dr["allocated"].ToString());
double dblUsed = oResourceRequest.GetWorkflowUsed(intResource);
DataSet dsStatus = oResourceRequest.GetStatuss(intResource);
string strStatus = "";
StringBuilder sbStatuses = new StringBuilder();
bool boolChange = false;
foreach (DataRow drStatus in dsStatus.Tables[0].Rows)
{
double dblStatus = double.Parse(drStatus["status"].ToString());
strStatus = oResourceRequest.GetStatus(dblStatus, 30, 15);
if (boolChange == true)
{
sbStatuses.Append("<tr>");
}
else
{
sbStatuses.Append("<tr bgcolor=\"#F6F6F6\">");
}
sbStatuses.Append("<td nowrap valign=\"top\" align=\"center\">");
sbStatuses.Append(oResourceRequest.GetStatus(dblStatus, 30, 10));
sbStatuses.Append("</td>");
sbStatuses.Append("<td nowrap valign=\"top\" align=\"center\">");
sbStatuses.Append(DateTime.Parse(drStatus["modified"].ToString()).ToShortDateString());
sbStatuses.Append("</td>");
sbStatuses.Append("<td width=\"100%\" valign=\"top\">");
sbStatuses.Append(drStatus["comments"].ToString());
sbStatuses.Append("</td>");
sbStatuses.Append("</tr>");
boolChange = !boolChange;
}
if (sbStatuses.ToString() != "")
{
sbStatuses.Insert(0, "<table width=\"100%\" cellpadding=\"3\" cellspacing=\"0\" border=\"0\" style=\"border:solid 1px #CCCCCC\"><tr bgcolor=\"#EEEEEE\"><td> </td><td><b><u>Date:</u></b></td><td><b><u>Comments:</u></b></td></tr>");
sbStatuses.Append("</table>");
}
double dblProgress = 0.00;
if (dblAllocated > 0.00)
{
dblProgress = (dblUsed / dblAllocated) * 100.00;
}
sbSummary.Append("<tr>");
sbSummary.Append("<td><img src=\"/images/resource_people.gif\" border=\"0\" align=\"absmiddle\"></td>");
int intUser = Int32.Parse(dr["userid"].ToString());
sbSummary.Append("<td>");
sbSummary.Append(intUser > 0 ? oUser.GetFullName(intUser) : "Pending Assignment");
sbSummary.Append("</td>");
sbSummary.Append("<td>");
sbSummary.Append(oApplication.GetName(oRequestItem.GetItemApplication(Int32.Parse(dr["itemid"].ToString()))));
sbSummary.Append("</td>");
sbSummary.Append("<td nowrap align=\"center\">");
sbSummary.Append(intUser > 0 ? strStatus : "---");
sbSummary.Append("</td>");
sbSummary.Append("<td nowrap width=\"100\">");
sbSummary.Append(intUser > 0 ? oServiceRequest.GetStatusBar(dblProgress, "100", "14", true) : "---");
sbSummary.Append("</td>");
sbSummary.Append("<td width=\"1\" nowrap><a href=\"javascript:void(0);\" onclick=\"ShowHide('div");
sbSummary.Append(intCount.ToString());
sbSummary.Append("');\">[Details]</a></td>");
sbSummary.Append("</tr>");
sbSummary.Append("<tr>");
sbSummary.Append("<td colspan=\"6\">");
sbSummary.Append("<div id=\"div");
sbSummary.Append(intCount.ToString());
sbSummary.Append("\" style=\"display:none\">");
sbSummary.Append(sbStatuses.ToString());
sbSummary.Append("</div>");
sbSummary.Append("</td>");
sbSummary.Append("</tr>");
}
sbSummary.Insert(0, "<table width=\"100%\" cellpadding=\"3\" cellspacing=\"2\" border=\"0\"><tr><td></td><td><b><u>Technician:</u></b></td><td><b><u>Department:</u></b></td><td align=\"center\"><b><u>Status:</u></b></td><td><b><u>Progress:</u></b></td><td></td></tr>");
sbSummary.Append("</table>");
return(sbSummary.ToString());
}
