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