protected void LoadAvailable(int _appmanager, int _app) { DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("name", System.Type.GetType("System.String"))); dt.Columns.Add(new DataColumn("hours", System.Type.GetType("System.Double"))); dt.Columns.Add(new DataColumn("graph", System.Type.GetType("System.Double"))); DataSet ds = oUser.GetManagerReports(intProfile, 0, 0, 0); foreach (DataRow dr in ds.Tables[0].Rows) { int intUser = Int32.Parse(dr["userid"].ToString()); DataSet dsAss = oResourceRequest.GetWorkflowAssigned(intUser, 2); double dblTotal = 0; foreach (DataRow drAss in dsAss.Tables[0].Rows) { int intId = Int32.Parse(drAss["id"].ToString()); double dblAllocated = double.Parse(drAss["allocated"].ToString()); double dblUsed = oResourceRequest.GetWorkflowUsed(intId); dblTotal += dblAllocated - dblUsed; } DataRow drRow = dt.NewRow(); drRow["name"] = oUser.GetFullName(intUser); drRow["hours"] = dblTotal; dt.Rows.Add(drRow); } DataSet dsNew = new DataSet(); dsNew.Tables.Add(dt); double dblMax = 0; foreach (DataRow dr in dsNew.Tables[0].Rows) { double dblHours = double.Parse(dr["hours"].ToString()); if (dblMax < dblHours) { dblMax = dblHours; } } if (dblMax > 0) { foreach (DataRow dr in dsNew.Tables[0].Rows) { double dblHours = double.Parse(dr["hours"].ToString()); dblHours = dblHours / dblMax; dr["graph"] = dblHours * 400; } } rptAvailable.DataSource = dsNew; rptAvailable.DataBind(); }
protected void LoadPaging(int intStart, string _sort) { string strRequest = (Request.QueryString["request"] == null ? "" : Request.QueryString["request"]); if (Request.QueryString["filter"] != null && Request.QueryString["filter"] == "buddy") { ds = oResourceRequest.GetWorkflowAssigned(intProfile, 0, 1, strRequest); ddlType.SelectedValue = "2"; } else if (Request.QueryString["filter"] != null && Request.QueryString["filter"] == "all") { ds = oResourceRequest.GetWorkflowAssigned(intProfile, 1, 1, strRequest); ddlType.SelectedValue = "1"; } else { ds = oResourceRequest.GetWorkflowAssigned(intProfile, 1, 0, strRequest); } int intCount = ds.Tables[0].Rows.Count; double dblEnd = Math.Ceiling(Double.Parse(intCount.ToString()) / Double.Parse(intRecords.ToString())); int intEnd = Int32.Parse(dblEnd.ToString()); int ii = 0; txtPage.Text = intStart.ToString(); lblPages.Text = intEnd.ToString(); if (intEnd < 7) { for (ii = 1; ii < intEnd; ii++) { LoadLink(lblTopPaging, ii, ", ", intStart); LoadLink(lblBottomPaging, ii, ", ", intStart); } LoadLink(lblTopPaging, intEnd, "", intStart); LoadLink(lblBottomPaging, intEnd, "", intStart); } else { if (intStart < 5) { for (ii = 1; ii < 6 && ii < intEnd; ii++) { LoadLink(lblTopPaging, ii, ", ", intStart); LoadLink(lblBottomPaging, ii, ", ", intStart); } if (ii < intEnd) { LoadLink(lblTopPaging, ii, " .... ", intStart); LoadLink(lblBottomPaging, ii, " .... ", intStart); } LoadLink(lblTopPaging, intEnd, "", intStart); LoadLink(lblBottomPaging, intEnd, "", intStart); } else if (intStart > (intEnd - 4)) { LoadLink(lblTopPaging, 1, " .... ", intStart); LoadLink(lblBottomPaging, 1, " .... ", intStart); for (ii = (intEnd - 5); ii < intEnd && ii > 0; ii++) { LoadLink(lblTopPaging, ii, ", ", intStart); LoadLink(lblBottomPaging, ii, ", ", intStart); } LoadLink(lblTopPaging, intEnd, "", intStart); LoadLink(lblBottomPaging, intEnd, "", intStart); } else { LoadLink(lblTopPaging, 1, " .... ", intStart); LoadLink(lblBottomPaging, 1, " .... ", intStart); for (ii = (intStart - 2); ii < (intStart + 3) && ii < intEnd && ii > 0; ii++) { if (ii == (intStart + 2)) { LoadLink(lblTopPaging, ii, " .... ", intStart); LoadLink(lblBottomPaging, ii, " .... ", intStart); } else { LoadLink(lblTopPaging, ii, ", ", intStart); LoadLink(lblBottomPaging, ii, ", ", intStart); } } LoadLink(lblTopPaging, intEnd, "", intStart); LoadLink(lblBottomPaging, intEnd, "", intStart); } } LoopRepeater(_sort, ((intStart - 1) * intRecords)); }