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