protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProjectRequest = new ProjectRequest(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oProjectNumber = new ProjectNumber(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oService = new Services(intProfile, dsn);
oDelegate = new Delegates(intProfile, dsn);
oStatusLevel = new StatusLevels();
oEnhancement = new Enhancements(intProfile, dsn);
oLog = new Log(intProfile, dsn);
oFunction = new Functions(intProfile, dsn, intEnvironment);
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.QueryString["action"] != null && Request.QueryString["action"] != "")
{
panFinish.Visible = true;
}
else
{
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
if (!IsPostBack)
{
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
lblResourceParent.Text = Request.QueryString["rrid"];
int intResourceParent = Int32.Parse(lblResourceParent.Text);
ds = oResourceRequest.Get(intResourceParent);
if (ds.Tables[0].Rows.Count > 0)
{
int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
int intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
Forecast oForecast = new Forecast(intProfile, dsn);
if (intService == intStorageService)
{
try
{
OnDemandTasks oOnDemandTask = new OnDemandTasks(0, dsn);
Locations oLocation = new Locations(0, dsn);
DataSet dsDesign = oOnDemandTask.GetServerStorage(intRequest, intItem, intNumber);
if (dsDesign.Tables[0].Rows.Count == 1)
{
int intAnswer = Int32.Parse(dsDesign.Tables[0].Rows[0]["answerid"].ToString());
int intAddress = Int32.Parse(oForecast.GetAnswer(intAnswer, "addressid"));
lblLocation.Text = oLocation.GetFull(intAddress);
panLocation.Visible = true;
}
}
catch { }
}
int intProject = Int32.Parse(oRequest.Get(intRequest, "projectid"));
int intApp = oRequestItem.GetItemApplication(intItem);
int intForecast = 0;
DataSet dsForecast = oForecast.GetProject(intProject);
if (dsForecast.Tables[0].Rows.Count > 0)
{
intForecast = Int32.Parse(dsForecast.Tables[0].Rows[0]["id"].ToString());
}
if (intForecast > 0)
{
btnView.Attributes.Add("oncontextmenu", "return OpenWindow('NEW_WINDOW','" + oPage.GetFullLink(intDesignBuilder) + "?id=" + intForecast.ToString() + "');");
}
else
{
btnView.Attributes.Add("oncontextmenu", "alert('There is no design for this project');return false;");
}
if (ds.Tables[0].Rows[0]["solo"].ToString() == "0")
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewRequest.ToString() + "&rid=" + intRequest.ToString() + "');");
btnView.Text = "Click here to view the project details";
lblType.Text = "Project Request";
}
else
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewResourceRequest.ToString() + "&rrid=" + intResourceParent.ToString() + "');");
if (oApplication.Get(intApp, "tpm") == "1")
{
btnView.Text = "Click here to view the project details";
}
else
{
btnView.Text = "Click here to view this request";
}
lblType.Text = "Service Request";
}
btnAssignments.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intSearchPage.ToString() + "&pid=" + intProject + "&aid=" + intApp.ToString() + "&sort=userid');");
//btnAssignments.Attributes.Add("onclick", "return OpenNewWindowMenu('/datapoint/projects/datapoint_projects.aspx?id=" + oFunction.encryptQueryString(intProject.ToString()) + "', '800', '600');");
lblItem.Text = intItem.ToString();
lblService.Text = oService.GetName(intService);
if (oApplication.Get(intApp, "request_items") == "1")
{
lblGroup.Text = oApplication.GetName(intApp) + " | " + oRequestItem.GetItemName(intItem);
}
else
{
lblGroup.Text = oApplication.GetName(intApp);
}
int intUser = Int32.Parse(oRequest.Get(intRequest, "userid"));
int intAppManager = oApplication.GetManager(intApp);
if (ds.Tables[0].Rows[0]["accepted"].ToString() == "-1" && oApplication.Get(intApp, "tpm") == "1")
{
if (intUser == intProfile || oDelegate.Get(intUser, intProfile) > 0)
{
panRequest.Visible = true;
panAssignSingle.Visible = true;
txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
panHours.Visible = !(oApplication.Get(intApp, "tpm") == "1");
txtHours.Enabled = (oService.Get(intService, "disable_hours") == "1" ? false : true);
lblQuantity.Text = ds.Tables[0].Rows[0]["devices"].ToString();
lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
panQuantity.Visible = (lblQuantity.Text != "0");
txtQuantity.Text = lblQuantity.Text;
txtQuantity.Enabled = (txtQuantity.Text != "0");
txtQuantity.Enabled = false;
lblAssign.Text = oUser.GetFullName(intProfile);
strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false);
}
else
{
Response.Write("no rights");
panDenied.Visible = true;
}
btnSubmit.Attributes.Add("onclick", "return ValidateNumber0('" + txtHours.ClientID + "','Please enter a valid number for the hours allocated') && ValidateHidden('" + hdnManager.ClientID + "','" + txtManager.ClientID + "','Please enter a valid LAN ID') && ProcessButton(this);");
}
else
{
string strValidate = "";
if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile) || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1"))
{
panRequest.Visible = true;
panAssignMultiple.Visible = true;
btnSubmit.Enabled = (ds.Tables[0].Rows[0]["assigned"].ToString() == "");
if (ds.Tables[0].Rows[0]["status"].ToString() == "5")
{
radHold.Checked = true;
divChoice.Style["display"] = "inline";
divHold.Style["display"] = "inline";
txtHold.Text = ds.Tables[0].Rows[0]["reason"].ToString();
}
else
{
divChoice.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "0" ? "inline" : "none");
divAccept.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "1" ? "inline" : "none");
}
int intEnhancementService = 0;
Int32.TryParse(ConfigurationManager.AppSettings["HELP_ENHANCEMENT_SERVICEID"], out intEnhancementService);
if (intService == intEnhancementService)
{
panEnhancement.Visible = true;
ddlModule.DataTextField = "name";
ddlModule.DataValueField = "id";
ddlModule.DataSource = oEnhancement.GetModules(1);
ddlModule.DataBind();
ddlModule.Items.Insert(0, new ListItem("-- SELECT --", "0"));
strValidate += "ValidateDropDown('" + ddlModule.ClientID + "','Select a classification') && ";
radEnhancementShort.Checked = true;
radEnhancementReject.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','inline');ShowHideDiv('" + trEnhancementClassification.ClientID + "','none');ShowHideDiv('" + divAccept.ClientID + "','none');");
radEnhancementDuplicate.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','inline');ShowHideDiv('" + trEnhancementClassification.ClientID + "','none');ShowHideDiv('" + divAccept.ClientID + "','none');");
radEnhancementShort.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','none');ShowHideDiv('" + trEnhancementClassification.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','inline');");
radEnhancementLong.Attributes.Add("onclick", "ShowHideDiv('" + trEnhancementReject.ClientID + "','inline');ShowHideDiv('" + trEnhancementClassification.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','inline');");
}
panDelete.Visible = (intItem == intImplementorDistributed || intItem == intImplementorMidrange);
btnDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this request');");
txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
panHours.Visible = !(oApplication.Get(intApp, "tpm") == "1");
txtHours.Enabled = (oService.Get(intService, "disable_hours") == "1" ? false : true);
lblQuantity.Text = ds.Tables[0].Rows[0]["devices"].ToString();
panQuantity.Visible = (lblQuantity.Text != "0");
txtQuantity.Text = lblQuantity.Text;
txtQuantity.Enabled = (txtQuantity.Text != "0");
txtQuantity.Enabled = false;
lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
trAssigned.Visible = !(btnSubmit.Enabled);
string strAssign = "";
DataSet dsManager = oService.GetUser(intService, 1);
foreach (DataRow drManager in dsManager.Tables[0].Rows)
{
if (strAssign != "")
{
strAssign += ", ";
}
strAssign += oUser.GetFullName(Int32.Parse(drManager["userid"].ToString()));
}
lblAssign.Text = strAssign;
DataSet dsReports = oUser.GetManagerReports(intAppManager, intRequest, intService, intNumber);
DataTable dtReports = dsReports.Tables[0].Copy();
dtReports.Clear();
DataSet dsAssignment = oService.GetUser(intService, -100);
foreach (DataRow drAssignment in dsAssignment.Tables[0].Rows)
{
int intAssignment = Int32.Parse(drAssignment["userid"].ToString());
DataSet dsAssignees = oUser.GetManagerReports(intAssignment, intRequest, intService, intNumber);
foreach (DataRow drAssignee in dsAssignees.Tables[0].Rows)
{
dtReports.ImportRow(drAssignee);
}
}
if (dtReports.Rows.Count > 0)
{
// Use custom assignment list
// First, remove duplicates
Hashtable hTable = new Hashtable();
ArrayList duplicateList = new ArrayList();
foreach (DataRow drow in dtReports.Rows)
{
if (hTable.Contains(drow["userid"]))
{
duplicateList.Add(drow);
}
else
{
hTable.Add(drow["userid"], string.Empty);
}
}
foreach (DataRow dRow in duplicateList)
{
dtReports.Rows.Remove(dRow);
}
// Next, sort by username
dtReports.DefaultView.Sort = "username";
// Now add to dataset
dsReports = new DataSet();
dsReports.Tables.Add(dtReports.DefaultView.ToTable());
}
LoadList(dsReports, intApp);
LoadAvailable(dsReports, intApp);
strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false);
}
else
{
Response.Write("no delegate");
panDenied.Visible = true;
}
btnSubmit.Attributes.Add("onclick", "return " + strValidate + "ValidateChoice('" + divChoice.ClientID + "','" + radAccept.ClientID + "','" + radReject.ClientID + "','" + radHold.ClientID + "','" + ddlUser.ClientID + "','" + txtHours.ClientID + "') && ProcessButton(this);");
}
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
}
btnClose.Attributes.Add("onclick", "return CloseWindow();");
lnkAvailable.Attributes.Add("onclick", "return ShowHideAvailable('" + divAvailable.ClientID + "');");
radAccept.Attributes.Add("onclick", "ShowHideDiv('" + divAccept.ClientID + "','inline');ShowHideDiv('" + divReject.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');");
radReject.Attributes.Add("onclick", "ShowHideDiv('" + divReject.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');");
radHold.Attributes.Add("onclick", "ShowHideDiv('" + divHold.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divReject.ClientID + "','none');");
txtManager.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divManager.ClientID + "','" + lstManager.ClientID + "','" + hdnManager.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstManager.Attributes.Add("ondblclick", "AJAXClickRow();");
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProject = new Projects(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oOrganization = new Organizations(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oService = new Services(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oApplication = new Applications(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oUser = new Users(intProfile, dsn);
if (Request.QueryString["action"] != null && Request.QueryString["action"] != "")
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "saved", "<script type=\"text/javascript\">alert('Information Saved Successfully');<" + "/" + "script>");
}
if (!IsPostBack)
{
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
lblResourceWorkflow.Text = Request.QueryString["rrid"];
int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
ds = oResourceRequest.Get(intResourceParent);
if (ds.Tables[0].Rows.Count > 0)
{
int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
int intApp = oRequestItem.GetItemApplication(intItem);
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
int intProject = oRequest.GetProjectNumber(intRequest);
bool boolManager = false;
if (intProject > 0)
{
panProject.Visible = true;
lblName.Text = oProject.Get(intProject, "name");
lblNumber.Text = oProject.Get(intProject, "number");
lblOrganization.Text = oOrganization.GetName(Int32.Parse(oProject.Get(intProject, "organization")));
}
else
{
panTask.Visible = true;
lblTaskName.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "name");
lblTaskNumber.Text = "CVT" + intRequest.ToString();
}
lblSubmitter.Text = oUser.GetFullName(oRequest.GetUser(intRequest));
lblStatement.Text = oRequest.Get(intRequest, "description");
if (oRequest.Get(intRequest, "start_date") != "")
{
lblStart.Text = DateTime.Parse(oRequest.Get(intRequest, "start_date")).ToShortDateString();
}
else
{
lblStart.Text = "N / A";
}
if (oRequest.Get(intRequest, "end_date") != "")
{
lblEnd.Text = DateTime.Parse(oRequest.Get(intRequest, "end_date")).ToShortDateString();
}
else
{
lblEnd.Text = "N / A";
}
double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow);
lblUsed.Text = dblUsed.ToString("F");
lblAllocated.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated");
txtAllocated.Text = lblAllocated.Text;
txtDevices.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "devices");
lblDevices.Text = txtDevices.Text;
if (ds.Tables[0].Rows[0]["solo"].ToString() == "0")
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewRequest.ToString() + "&rid=" + intRequest.ToString() + "');");
btnView.Text = "View Original Request Details";
}
else
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewResourceRequest.ToString() + "&rrid=" + intResourceParent.ToString() + "');");
if (oApplication.Get(intApp, "tpm") == "1")
{
btnView.Text = "View Original Request Details";
}
else
{
btnView.Text = "View Original Request Details";
}
}
string strStatus = ds.Tables[0].Rows[0]["status"].ToString();
int intAppManager = oApplication.GetManager(intApp);
LoadList(intAppManager, intApp);
LoadAvailable(intAppManager, intApp);
if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile) || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1") || (oUser.IsManager(intUser, intProfile, true) && oApplication.Get(intApp, "disable_manager") != "1"))
{
boolManager = true;
}
else if (intProfile == intUser)
{
panVirtual.Visible = true;
btnVirtual.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST','" + intResourceWorkflow.ToString() + "');");
btnVirtual.Text = "View This Request";
}
try
{
ddlActivity.SelectedValue = intItem.ToString();
lblActivity.Text = ddlActivity.SelectedItem.Text;
ddlUser.SelectedValue = intUser.ToString();
lblUser.Text = ddlUser.SelectedItem.Text;
}
catch { }
if (boolManager == true)
{
Master.Page.Title = "Resource Request #" + intResourceWorkflow.ToString() + " Management View";
panView.Visible = true;
panManager.Visible = true;
chkOpen.Enabled = (strStatus == "3" || strStatus == "-2" || strStatus == "5");
txtAllocated.Visible = true;
txtDevices.Visible = true;
ddlActivity.Visible = true;
ddlUser.Visible = true;
lnkAvailable.Visible = true;
panVirtual.Visible = true;
btnVirtual.Attributes.Add("onclick", "return OpenWindow('RESOURCE_REQUEST','" + intResourceWorkflow.ToString() + "');");
btnVirtual.Text = "Virtual Login as " + oUser.Get(intUser, "fname") + " " + oUser.Get(intUser, "lname");
btnSave.Attributes.Add("onclick", "return ValidateNumber('" + txtAllocated.ClientID + "','Please enter a valid number for the allocated hours')" +
" && ValidateNumber('" + txtDevices.ClientID + "','Please enter a valid number for the device count')" +
" && ValidateDropDown('" + ddlActivity.ClientID + "','Please make a selection for the activity type')" +
" && ValidateDropDown('" + ddlUser.ClientID + "','Please make a selection for the assigned technician')" +
";");
}
else
{
Master.Page.Title = "Resource Request #" + intResourceWorkflow.ToString() + " Technician View";
panView.Visible = true;
lblAllocated.Visible = true;
lblDevices.Visible = true;
lblActivity.Visible = true;
lblUser.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
lnkAvailable.Attributes.Add("onclick", "return ShowHideAvailable('" + divAvailable.ClientID + "');");
btnFinish.Attributes.Add("onclick", "return CloseWindow();");
btnClose.Attributes.Add("onclick", "return CloseWindow();");
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
}
}
protected void Page_Load(object sender, EventArgs e)
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
oProjectRequest = new ProjectRequest(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oProjectNumber = new ProjectNumber(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oApplication = new Applications(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oService = new Services(intProfile, dsn);
oDelegate = new Delegates(intProfile, dsn);
oStatusLevel = new StatusLevels();
oServiceDetail = new ServiceDetails(intProfile, dsn);
oLog = new Log(intProfile, dsn);
if (Request.QueryString["pageid"] != null && Request.QueryString["pageid"] != "")
{
intPage = Int32.Parse(Request.QueryString["pageid"]);
}
if (Request.QueryString["action"] != null && Request.QueryString["action"] != "")
{
panFinish.Visible = true;
}
else
{
if (Request.QueryString["applicationid"] != null && Request.QueryString["applicationid"] != "")
{
intApplication = Int32.Parse(Request.QueryString["applicationid"]);
}
if (Request.Cookies["application"] != null && Request.Cookies["application"].Value != "")
{
intApplication = Int32.Parse(Request.Cookies["application"].Value);
}
if (!IsPostBack)
{
if (Request.QueryString["rrid"] != null && Request.QueryString["rrid"] != "")
{
lblResourceParent.Text = Request.QueryString["rrid"];
int intResourceParent = Int32.Parse(lblResourceParent.Text);
ds = oResourceRequest.Get(intResourceParent);
if (ds.Tables[0].Rows.Count > 0)
{
int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
int intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
int intProject = Int32.Parse(oRequest.Get(intRequest, "projectid"));
int intApp = oRequestItem.GetItemApplication(intItem);
int intForecast = 0;
Forecast oForecast = new Forecast(intProfile, dsn);
DataSet dsForecast = oForecast.GetProject(intProject);
if (dsForecast.Tables[0].Rows.Count > 0)
{
intForecast = Int32.Parse(dsForecast.Tables[0].Rows[0]["id"].ToString());
}
if (intForecast > 0)
{
btnView.Attributes.Add("oncontextmenu", "return OpenWindow('NEW_WINDOW','" + oPage.GetFullLink(intDesignBuilder) + "?id=" + intForecast.ToString() + "');");
}
else
{
btnView.Attributes.Add("oncontextmenu", "alert('There is no design for this project');return false;");
}
if (ds.Tables[0].Rows[0]["solo"].ToString() == "0")
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewRequest.ToString() + "&rid=" + intRequest.ToString() + "');");
btnView.Text = "Click here to view the project details";
lblType.Text = "Project Request";
}
else
{
btnView.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intViewResourceRequest.ToString() + "&rrid=" + intResourceParent.ToString() + "');");
if (oApplication.Get(intApp, "tpm") == "1")
{
btnView.Text = "Click here to view the project details";
}
else
{
btnView.Text = "Click here to view this request";
}
lblType.Text = "Service Request";
}
btnAssignments.Attributes.Add("onclick", "return OpenWindow('PRINTER_FRIENDLY','?page=" + intSearchPage.ToString() + "&pid=" + intProject + "&aid=" + intApp.ToString() + "&sort=userid');");
lblItem.Text = intItem.ToString();
lblService.Text = oService.GetName(intService);
lblServiceID.Text = intService.ToString();
if (oApplication.Get(intApp, "request_items") == "1")
{
lblGroup.Text = oApplication.GetName(intApp) + " | " + oRequestItem.GetItemName(intItem);
}
else
{
lblGroup.Text = oApplication.GetName(intApp);
}
int intUser = Int32.Parse(oRequest.Get(intRequest, "userid"));
int intAppManager = oApplication.GetManager(intApp);
if (ds.Tables[0].Rows[0]["accepted"].ToString() == "-1" && oApplication.Get(intApp, "tpm") == "1")
{
if (intUser == intProfile || oDelegate.Get(intUser, intProfile) > 0)
{
panRequest.Visible = true;
panAssignSingle.Visible = true;
txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
lblHoursOverall.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
txtQuantityOverall.Text = ds.Tables[0].Rows[0]["devices"].ToString();
txtQuantityOverall.Enabled = false;
txtQuantity.Text = txtQuantityOverall.Text;
txtQuantity.Enabled = false;
lblHours.Visible = true;
lblHours.Text = txtHours.Text;
lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
txtQuantity.Text = ds.Tables[0].Rows[0]["devices"].ToString();
btnAssign.Enabled = (txtQuantity.Text != "0");
lblAssignBy.Text = oUser.GetFullName(intProfile);
strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false);
}
else
{
Response.Write("no rights");
panDenied.Visible = true;
}
btnSubmit.Attributes.Add("onclick", "return ValidateNumber0('" + txtHours.ClientID + "','Please enter a valid number for the hours allocated') && ValidateHidden('" + hdnManager.ClientID + "','" + txtManager.ClientID + "','Please enter a valid LAN ID') && ProcessButton(this);");
}
else
{
if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile) || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1"))
{
panRequest.Visible = true;
panAssignMultiple.Visible = true;
btnSubmit.Enabled = (ds.Tables[0].Rows[0]["assigned"].ToString() == "");
if (ds.Tables[0].Rows[0]["status"].ToString() == "5")
{
radHold.Checked = true;
divChoice.Style["display"] = "inline";
divHold.Style["display"] = "inline";
txtHold.Text = ds.Tables[0].Rows[0]["reason"].ToString();
}
else
{
divChoice.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "0" ? "inline" : "none");
if (Request.QueryString["assign"] != null)
{
divAccept.Style["display"] = "inline";
radAccept.Checked = true;
}
else
{
divAccept.Style["display"] = (ds.Tables[0].Rows[0]["accepted"].ToString() == "1" ? "inline" : "none");
}
}
panDelete.Visible = (intItem == intImplementorDistributed || intItem == intImplementorMidrange);
btnDelete.Attributes.Add("onclick", "return confirm('Are you sure you want to delete this request');");
txtHours.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
lblHoursOverall.Text = double.Parse(ds.Tables[0].Rows[0]["allocated"].ToString()).ToString("F");
txtQuantityOverall.Text = ds.Tables[0].Rows[0]["devices"].ToString();
if (oApplication.Get(intApp, "tpm") == "1")
{
lblHours.Visible = true;
lblHours.Text = txtHours.Text;
txtQuantityOverall.Enabled = false;
txtQuantity.Enabled = false;
btnAssign.Attributes.Add("onclick", "return ValidateDropDown('" + ddlUser.ClientID + "','Please select a technician')" +
" && ProcessButton(this)" +
";");
}
else if (oServiceDetail.Gets(intService, 1).Tables[0].Rows.Count > 0)
{
lblHours.Visible = true;
lblHours.Text = "TBD ";
btnWhy.Visible = true;
btnAssign.Attributes.Add("onclick", "return ValidateDropDown('" + ddlUser.ClientID + "','Please select a technician')" +
" && ValidateNumber0('" + txtQuantity.ClientID + "','Please enter the quantity')" +
" && ProcessButton(this)" +
";");
}
else if (oService.Get(intService, "disable_hours") == "1")
{
lblHours.Visible = true;
lblHours.Text = txtHours.Text;
btnAssign.Attributes.Add("onclick", "return ValidateDropDown('" + ddlUser.ClientID + "','Please select a technician')" +
" && ValidateNumber0('" + txtQuantity.ClientID + "','Please enter the quantity')" +
" && ProcessButton(this)" +
";");
}
else
{
txtHours.Visible = true;
btnAssign.Attributes.Add("onclick", "return ValidateDropDown('" + ddlUser.ClientID + "','Please select a technician')" +
" && ValidateNumber0('" + txtQuantity.ClientID + "','Please enter the quantity')" +
" && ValidateNumber0('" + txtHours.ClientID + "','Please enter the hours')" +
" && ProcessButton(this)" +
";");
}
btnUpdate.Attributes.Add("onclick", "return ValidateNumber0('" + txtQuantityOverall.ClientID + "') && ProcessButton(this);");
DataSet dsAssigned = oResourceRequest.GetWorkflowsAssign(intResourceParent);
int intQuantity = Int32.Parse(ds.Tables[0].Rows[0]["devices"].ToString());
foreach (DataRow drAssigned in dsAssigned.Tables[0].Rows)
{
intQuantity = intQuantity - Int32.Parse(drAssigned["devices"].ToString());
}
txtQuantity.Text = intQuantity.ToString();
btnAssign.Enabled = (txtQuantity.Text != "0");
lblStatus.Text = oStatusLevel.HTML(Int32.Parse(ds.Tables[0].Rows[0]["status"].ToString()));
lblAssigned.Visible = !(btnSubmit.Enabled);
string strAssign = "";
DataSet dsManager = oService.GetUser(intService, 1);
foreach (DataRow drManager in dsManager.Tables[0].Rows)
{
if (strAssign != "")
{
strAssign += ", ";
}
strAssign += oUser.GetFullName(Int32.Parse(drManager["userid"].ToString()));
}
lblAssignBy.Text = strAssign;
DataSet dsReports = oUser.GetManagerReports(intAppManager, intRequest, intService, intNumber);
DataTable dtReports = dsReports.Tables[0].Copy();
dtReports.Clear();
DataSet dsAssignment = oService.GetUser(intService, -100);
foreach (DataRow drAssignment in dsAssignment.Tables[0].Rows)
{
int intAssignment = Int32.Parse(drAssignment["userid"].ToString());
DataSet dsAssignees = oUser.GetManagerReports(intAssignment, intRequest, intService, intNumber);
foreach (DataRow drAssignee in dsAssignees.Tables[0].Rows)
{
dtReports.ImportRow(drAssignee);
}
}
if (dtReports.Rows.Count > 0)
{
// Use custom assignment list
// First, remove duplicates
Hashtable hTable = new Hashtable();
ArrayList duplicateList = new ArrayList();
foreach (DataRow drow in dtReports.Rows)
{
if (hTable.Contains(drow["userid"]))
{
duplicateList.Add(drow);
}
else
{
hTable.Add(drow["userid"], string.Empty);
}
}
foreach (DataRow dRow in duplicateList)
{
dtReports.Rows.Remove(dRow);
}
// Next, sort by username
dtReports.DefaultView.Sort = "username";
// Now add to dataset
dsReports = new DataSet();
dsReports.Tables.Add(dtReports.DefaultView.ToTable());
}
LoadList(dsReports, intApp);
LoadAvailable(dsReports, intApp);
rptAssign.DataSource = dsAssigned;
rptAssign.DataBind();
foreach (RepeaterItem ri in rptAssign.Items)
{
((LinkButton)ri.FindControl("btnDeleteAssign")).Attributes.Add("onclick", "return confirm('Are you sure you want to delete this assignment?');");
}
lblAssign.Visible = (rptAssign.Items.Count == 0);
strSummary = oResourceRequest.GetBodyOverallFix(intResourceParent, 0, intEnvironment, false);
btnSubmit.Attributes.Add("onclick", "return ValidateChoice('" + divChoice.ClientID + "','" + radAccept.ClientID + "','" + radReject.ClientID + "','" + radHold.ClientID + "'," + dsAssigned.Tables[0].Rows.Count.ToString() + ") && ProcessButton(this);");
}
else
{
Response.Write("no delegate");
panDenied.Visible = true;
}
}
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
}
btnClose.Attributes.Add("onclick", "return CloseWindow();");
lnkAvailable.Attributes.Add("onclick", "return ShowHideAvailable('" + divAvailable.ClientID + "');");
radAccept.Attributes.Add("onclick", "ShowHideDiv('" + divAccept.ClientID + "','inline');ShowHideDiv('" + divReject.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');");
radReject.Attributes.Add("onclick", "ShowHideDiv('" + divReject.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divHold.ClientID + "','none');");
radHold.Attributes.Add("onclick", "ShowHideDiv('" + divHold.ClientID + "','inline');ShowHideDiv('" + divAccept.ClientID + "','none');ShowHideDiv('" + divReject.ClientID + "','none');");
txtManager.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divManager.ClientID + "','" + lstManager.ClientID + "','" + hdnManager.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstManager.Attributes.Add("ondblclick", "AJAXClickRow();");
btnWhy.Attributes.Add("onclick", "return ShowHideAvailable('" + divWhy.ClientID + "');");
}
protected void Page_Load(object sender, EventArgs e)
{
AuthenticateUser();
if (Request.Cookies["profileid"] != null && Request.Cookies["profileid"].Value != "")
{
intProfile = Int32.Parse(Request.Cookies["profileid"].Value);
}
oProject = new Projects(intProfile, dsn);
oServiceRequest = new ServiceRequests(intProfile, dsn);
oOrganization = new Organizations(intProfile, dsn);
oResourceRequest = new ResourceRequest(intProfile, dsn);
oRequestItem = new RequestItems(intProfile, dsn);
oService = new Services(intProfile, dsn);
oPage = new Pages(intProfile, dsn);
oVariable = new Variables(intEnvironment);
oApplication = new Applications(intProfile, dsn);
oRequest = new Requests(intProfile, dsn);
oUser = new Users(intProfile, dsn);
oServiceDetail = new ServiceDetails(intProfile, dsn);
oStatusLevel = new StatusLevels(intProfile, dsn);
oLog = new Log(intProfile, dsn);
if (Request.QueryString["save"] != null)
{
panSave.Visible = true;
}
if (Request.QueryString["close"] != null)
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Page), "close", "<script type=\"text/javascript\">window.close();<" + "/" + "script>");
}
if (!IsPostBack)
{
if (Request.QueryString["id"] != null && Request.QueryString["id"] != "")
{
lblResourceWorkflow.Text = Request.QueryString["id"];
int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
string strHeader = intResourceWorkflow.ToString();
lblHeader.Text = """ + strHeader + """;
Master.Page.Title = "DataPoint | Resource (" + strHeader + ") Administration";
lblHeaderSub.Text = "Provides administration of a resource request...";
ds = oResourceRequest.Get(intResourceParent);
if (ds.Tables[0].Rows.Count > 0)
{
int intItem = Int32.Parse(ds.Tables[0].Rows[0]["itemid"].ToString());
int intService = Int32.Parse(ds.Tables[0].Rows[0]["serviceid"].ToString());
int intApp = oRequestItem.GetItemApplication(intItem);
int intUser = Int32.Parse(oResourceRequest.GetWorkflow(intResourceWorkflow, "userid"));
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
int intNumber = Int32.Parse(ds.Tables[0].Rows[0]["number"].ToString());
int intProject = oRequest.GetProjectNumber(intRequest);
if (oService.Get(intService, "disable_hours") != "1")
{
txtAllocated.Enabled = false;
txtAllocated.ToolTip = intService.ToString();
panDynamic.Visible = true;
}
bool boolManager = false;
double dblUsed = oResourceRequest.GetWorkflowUsed(intResourceWorkflow);
lblUsed.Text = dblUsed.ToString("F");
lblAllocated.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "allocated");
txtAllocated.Text = lblAllocated.Text;
txtDevices.Text = oResourceRequest.GetWorkflow(intResourceWorkflow, "devices");
lblDevices.Text = txtDevices.Text;
string strStatus = ds.Tables[0].Rows[0]["status"].ToString();
ddlStatus.DataValueField = "StatusValue";
ddlStatus.DataTextField = "StatusDescription";
ddlStatus.DataSource = oStatusLevel.GetStatusList("RRWFSTATUS");
ddlStatus.DataBind();
ddlStatus.SelectedValue = strStatus;
int intAppManager = oApplication.GetManager(intApp);
LoadList(intAppManager, intApp);
LoadAvailable(intAppManager, intApp, intRequest, intService, intNumber);
if (oUser.IsAdmin(intProfile) || oService.IsManager(intService, intProfile) || (oApplication.IsManager(intApp, intProfile) && oApplication.Get(intApp, "disable_manager") != "1") || (oUser.IsManager(intUser, intProfile, true) && oApplication.Get(intApp, "disable_manager") != "1"))
{
boolManager = true;
}
try
{
ddlActivity.SelectedValue = intItem.ToString();
lblActivity.Text = ddlActivity.SelectedItem.Text;
hdnUser.Value = intUser.ToString();
txtUser.Text = oUser.GetFullName(intUser) + " (" + oUser.GetName(intUser) + ")";
lblUser.Text = txtUser.Text;
}
catch { }
if (boolManager == true)
{
Master.Page.Title = "Resource Request #" + intResourceWorkflow.ToString() + " Management View";
panView.Visible = true;
panManager.Visible = true;
txtAllocated.Visible = true;
txtDevices.Visible = true;
ddlActivity.Visible = true;
panUser.Visible = true;
ddlStatus.Enabled = true;
btnSave.Attributes.Add("onclick", "return ValidateNumber('" + txtAllocated.ClientID + "','Please enter a valid number for the allocated hours')" +
" && ValidateNumber('" + txtDevices.ClientID + "','Please enter a valid number for the device count')" +
" && ValidateDropDown('" + ddlActivity.ClientID + "','Please make a selection for the activity type')" +
" && ValidateHidden0('" + hdnUser.ClientID + "','" + txtUser.ClientID + "','Please select an assigned technician')" +
" && ProcessControlButton()" +
";");
btnSaveClose.Attributes.Add("onclick", "return ValidateNumber('" + txtAllocated.ClientID + "','Please enter a valid number for the allocated hours')" +
" && ValidateNumber('" + txtDevices.ClientID + "','Please enter a valid number for the device count')" +
" && ValidateDropDown('" + ddlActivity.ClientID + "','Please make a selection for the activity type')" +
" && ValidateHidden0('" + hdnUser.ClientID + "','" + txtUser.ClientID + "','Please select an assigned technician')" +
" && ProcessControlButton()" +
";");
}
else
{
Master.Page.Title = "Resource Request #" + intResourceWorkflow.ToString() + " Technician View";
panView.Visible = true;
lblAllocated.Visible = true;
lblDevices.Visible = true;
lblActivity.Visible = true;
lblUser.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
}
else
{
panDenied.Visible = true;
}
txtUser.Attributes.Add("onkeyup", "return AJAXTextBoxGet(this,'300','195','" + divUser.ClientID + "','" + lstUser.ClientID + "','" + hdnUser.ClientID + "','" + oVariable.URL() + "/frame/users.aspx',2);");
lstUser.Attributes.Add("ondblclick", "AJAXClickRow();");
lnkAvailable.Attributes.Add("onclick", "return ShowHideAvailable('" + divAvailable.ClientID + "');");
btnFinish.Attributes.Add("onclick", "return CloseWindow();");
btnClose.Attributes.Add("onclick", "return CloseWindow();");
btnDenied.Attributes.Add("onclick", "return CloseWindow();");
}
}
