protected void btnSave_Click(Object Sender, EventArgs e)
{
intRequest = oRequest.Add(0, intProfile);
int intItemID = oService.GetItemId(intService);
int intResource = oServiceRequest.AddRequest(intRequest, intItemID, intService, 0, 0.00, (int)EnhancementStatus.UnderReview, 1, dsnServiceEditor);
oServiceRequest.Update(intRequest, txtTitle.Text);
oResourceRequest.UpdateName(intResource, txtTitle.Text);
oServiceRequest.Add(intRequest, 1, 1);
intID = oEnhancement.Add(txtTitle.Text, txtDescription.Text, Int32.Parse(ddlUsers.SelectedItem.Value), txtURL.Text, fileUpload, intEnvironment, Int32.Parse(radRelease1.SelectedItem.Value), Int32.Parse(radRelease2.SelectedItem.Value), intProfile, intResource);
if (oServiceRequest.NotifyApproval(intResource, intResourceRequestApprove, intEnvironment, "", dsnServiceEditor) == false)
{
oServiceRequest.NotifyTeamLead(intItemID, intResource, intAssignPage, intViewPage, intEnvironment, "", dsnServiceEditor, dsnAsset, dsnIP, 0);
}
oEnhancement.AddLog(intID, 0, "Submitted Original Enhancement", intProfile, "");
Response.Redirect(oPage.GetFullLinkRelated(intPage));
}
protected void btnSubmit_Click(Object Sender, EventArgs e)
{
int intResourceParent = Int32.Parse(lblResourceParent.Text);
ds = oResourceRequest.Get(intResourceParent);
if (ds.Tables[0].Rows.Count > 0)
{
int intRequest = Int32.Parse(ds.Tables[0].Rows[0]["requestid"].ToString());
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());
string strCVT = "CVT" + intRequest.ToString() + "-" + intService.ToString() + "-" + intNumber.ToString();
string strService = oService.GetName(intService);
if (intService == 0)
{
strService = oRequestItem.GetItemName(intItem);
}
int intApp = oRequestItem.GetItemApplication(intItem);
int intProject = Int32.Parse(oRequest.Get(intRequest, "projectid"));
Projects oProject = new Projects(intProfile, dsn);
ProjectsPending oProjectsPending = new ProjectsPending(intProfile, dsn, intEnvironment);
Variables oVariable = new Variables(intEnvironment);
RequestFields oRequestField = new RequestFields(intProfile, dsn);
int intRequester = Int32.Parse(oRequest.Get(intRequest, "userid"));
int intPC = 0;
int intIE = 0;
if (intProject > 0)
{
if (oProject.Get(intProject, "lead") != "")
{
intPC = Int32.Parse(oProject.Get(intProject, "lead"));
}
if (oProject.Get(intProject, "engineer") != "")
{
intIE = Int32.Parse(oProject.Get(intProject, "engineer"));
}
}
else
{
try
{
intPC = Int32.Parse(oProjectsPending.GetRequest(intRequest, "lead"));
intIE = Int32.Parse(oProjectsPending.GetRequest(intRequest, "engineer"));
}
catch { }
}
string strCC = "";
if (intPC > 0)
{
strCC += oUser.GetName(intPC) + ";";
}
if (intIE > 0)
{
strCC += oUser.GetName(intIE) + ";";
}
int intEnhancement = 0;
if (panEnhancement.Visible)
{
DataSet dsEnhancement = oEnhancement.GetRequest(intRequest);
if (dsEnhancement.Tables[0].Rows.Count == 1)
{
intEnhancement = Int32.Parse(dsEnhancement.Tables[0].Rows[0]["id"].ToString());
}
}
if (radReject.Checked == true || (panEnhancement.Visible && radEnhancementReject.Checked))
{
string strComments = txtEnhancementReject.Text.Trim();
if (strComments == "" && txtReject.Text.Trim() != "")
{
strComments = "<p>The following comments were added:<br/>" + oFunction.FormatText(txtReject.Text) + "</p>";
}
string strDefault = oUser.GetApplicationUrl(intRequester, intAssignPage);
string strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_REQUEST_ASSIGNMENT,EMAILGRP_REQUEST_STATUS");
if (strDefault == "" || oApplication.Get(intApp, "tpm") != "1")
{
oFunction.SendEmail("Request REJECTED: " + strService, oUser.GetName(intRequester), strCC, strEMailIdsBCC, "Request REJECTED: " + strService, "<p>The following request has been rejected by <b>" + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetSummary(intResourceParent, 0, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>" + strComments, true, false);
}
else
{
oFunction.SendEmail("Request REJECTED: " + strService, oUser.GetName(intRequester), strCC, strEMailIdsBCC, "Request REJECTED: " + strService, "<p>The following request has been rejected by <b>" + oUser.GetFullName(intProfile) + "</b><p><p>" + oResourceRequest.GetSummary(intResourceParent, 0, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>" + strComments + "<p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/" + strDefault + oPage.GetFullLink(intAssignPage) + "?rrid=" + intResourceParent.ToString() + "\" target=\"_blank\">Click here to assign a new project manager to your request.</a></p>", true, false);
}
oResourceRequest.UpdateAccepted(intResourceParent, -1);
oResourceRequest.UpdateReason(intResourceParent, txtReject.Text);
if (panEnhancement.Visible)
{
oResourceRequest.UpdateStatusOverall(intResourceParent, (int)EnhancementStatus.Denied);
oResourceRequest.UpdateReason(intResourceParent, txtEnhancementReject.Text);
oEnhancement.AddLog(intEnhancement, 0, "Rejected", intProfile, "");
}
}
else if (radHold.Checked == true)
{
oResourceRequest.UpdateStatusOverall(intResourceParent, 5);
oResourceRequest.UpdateReason(intResourceParent, txtHold.Text);
}
else
{
if (panEnhancement.Visible && radEnhancementLong.Checked)
{
oResourceRequest.UpdateStatusOverall(intResourceParent, (int)EnhancementStatus.AwaitingLongDocument);
oEnhancement.AddLog(intEnhancement, 0, "Sent Back to Client for Additonal Requirements", intProfile, "");
}
else if (panEnhancement.Visible && radEnhancementDuplicate.Checked)
{
oResourceRequest.UpdateStatusOverall(intResourceParent, (int)EnhancementStatus.Duplicate);
oEnhancement.AddLog(intEnhancement, 0, "Duplicate", intProfile, "");
}
else
{
if (oResourceRequest.Get(intResourceParent, "assigned") == "") // hasn't already been assigned.
{
string strComments = "";
if (txtComments.Text != "")
{
strComments = "<p>The following comments were added:<br/>" + oFunction.FormatText(txtComments.Text) + "</p>";
}
if (panEnhancement.Visible)
{
oEnhancement.UpdateModuleID(intResourceParent, Int32.Parse(ddlModule.SelectedItem.Value));
oEnhancement.AddLog(intEnhancement, 0, "Assigned", intProfile, "");
}
bool boolSolo = (oResourceRequest.Get(intResourceParent, "solo") == "1");
int intAssigned = 0;
bool boolRejected = (oResourceRequest.Get(intResourceParent, "accepted") == "-1");
if (boolRejected == true)
{
oResourceRequest.UpdateRejected(intResourceParent, 1);
intAssigned = Int32.Parse(Request.Form[hdnManager.UniqueID]);
}
else
{
intAssigned = Int32.Parse(ddlUser.SelectedItem.Value);
oResourceRequest.UpdateAccepted(intResourceParent, 1);
}
# region "Send Service Center Notification"
// intAssigned = USERID
//if (intService = Configuration.AppSettings["DECOMMISSION_SERVER_NEW"]
// get serverid from cv_WM_server_decommission based on requestid, itemid, number
// generate SC email with attachment in HTML format with "Assign TO: USER" at the top (only for non-vmware)
//int intServerDecommServiceID = Int32.Parse(ConfigurationManager.AppSettings["SERVICEID_SERVER_DECOMMISSION"]);
//if (intService == intServerDecommServiceID)
//{
// SendServiceCenterNotification(intRequest, intItem, intNumber, intAssigned);
//}
#endregion
oProject.Update(intProject, 2);
int intResourceWorkflow = oResourceRequest.AddWorkflow(intResourceParent, 0, oResourceRequest.Get(intResourceParent, "name"), intAssigned, Int32.Parse(txtQuantity.Text), double.Parse(txtHours.Text), 2, 0);
oLog.AddEvent(intRequest.ToString(), strCVT, "Request assigned by " + oUser.GetFullNameWithLanID(intProfile) + " to " + oUser.GetFullNameWithLanID(intAssigned), LoggingType.Debug);
oResourceRequest.UpdateComments(intResourceParent, txtComments.Text);
oResourceRequest.UpdateAssignedBy(intResourceParent, intProfile);
ProjectRequest oProjectRequest = new ProjectRequest(intProfile, dsn);
string strDefault = oUser.GetApplicationUrl(intAssigned, intViewPage);
string strNotify = "";
string strSpacerRow = "<tr><td colspan=\"3\"><img src=\"" + oVariable.ImageURL() + "/images/spacer.gif\" border=\"0\" width=\"1\" height=\"7\" /></td></tr>";
if (txtHours.Enabled == true)
{
oResourceRequest.UpdateDevices(intResourceParent, Int32.Parse(txtQuantity.Text), double.Parse(txtHours.Text));
}
if (boolSolo == true)
{
oResourceRequest.UpdateStatusOverall(intResourceParent, 2);
if (oApplication.Get(intApp, "tpm") != "1" && oProject.Get(intProject, "number") == "")
{
oProject.Update(intProject, oProjectNumber.New());
}
if (intItem != intImplementorDistributed && intItem != intImplementorMidrange)
{
string strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_REQUEST_ASSIGNMENT");
//if (oProject.Get(intProject, "number").StartsWith("CV") == false)
// strNotify = "<p><span style=\"color:#0000FF\"><b>PROJECT COORDINATOR:</b> Please allocate the hours listed above for each resource in Clarity.</span></p>";
if (strDefault == "")
{
oFunction.SendEmail("Request Assignment: " + strService, oUser.GetName(intAssigned), "", strEMailIdsBCC, "Request Assignment: " + strService, "<p><b>The following request has been assigned to you by " + oUser.GetFullName(intProfile) + "</b><p>" + strComments + "<p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p>", true, false);
}
else
{
if (intProject > 0)
{
oFunction.SendEmail("Request Assignment: " + strService, oUser.GetName(intAssigned), "", strEMailIdsBCC, "Request Assignment: " + strService, "<p><b>The following request has been assigned to you by " + oUser.GetFullName(intProfile) + "</b><p>" + strComments + "<p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/" + strDefault + oPage.GetFullLink(intViewPage) + "?pid=" + intProject.ToString() + "\" target=\"_blank\">Click here to review your new assignment.</a></p>", true, false);
}
else
{
oFunction.SendEmail("Request Assignment: " + strService, oUser.GetName(intAssigned), "", strEMailIdsBCC, "Request Assignment: " + strService, "<p><b>The following request has been assigned to you by " + oUser.GetFullName(intProfile) + "</b><p>" + strComments + "<p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/frame/resource_request.aspx?rrid=" + intResourceWorkflow.ToString() + "\" target=\"_blank\">Click here to review your new assignment.</a></p>", true, false);
}
}
string strActivity = "<tr><td><b>Resource:</b></td><td> </td><td>" + oUser.GetFullName(intAssigned) + "</td></tr>";
strActivity += strSpacerRow;
strActivity += "<tr><td><b>Service:</b></td><td> </td><td>" + strService + "</td></tr>";
strActivity = "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\">" + strActivity + "</table>";
string strDeliverable = oApplication.Get(intApp, "deliverables_doc");
if (strDeliverable.Trim() != "")
{
strDeliverable = "<p><a href=\"" + oVariable.URL() + strDeliverable + "\">Click here to view the service deliverables</a></p>";
}
if (oService.Get(intService, "notify_client") != "0")
{
oFunction.SendEmail("Request Assignment: " + strService, oUser.GetName(intRequester), strCC, strEMailIdsBCC, "Request Assignment: " + strService, "<p><b>A resource has been assigned to the following request...</b><p><p>" + oResourceRequest.GetWorkflowSummary(intResourceWorkflow, intEnvironment, dsnServiceEditor, dsnAsset, dsnIP) + "</p><p>" + strActivity + "</p>" + strDeliverable + strNotify, true, false);
}
}
}
else
{
// ADD PM
string strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_REQUEST_ASSIGNMENT");
if (strDefault == "")
{
oFunction.SendEmail("Request Assignment", oUser.GetName(intAssigned), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following project has been assigned to you by " + oUser.GetFullName(intProfile) + "</b><p>" + strComments + "<p>" + oProjectRequest.GetBody(intRequest, intEnvironment, true) + "</p>", true, false);
}
else
{
if (intProject > 0)
{
oFunction.SendEmail("Request Assignment", oUser.GetName(intAssigned), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following project has been assigned to you by " + oUser.GetFullName(intProfile) + "</b><p>" + strComments + "<p>" + oProjectRequest.GetBody(intRequest, intEnvironment, true) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/" + strDefault + oPage.GetFullLink(intViewPage) + "?pid=" + intProject.ToString() + "\" target=\"_blank\">Click here to review your new assignment.</a></p>", true, false);
}
else
{
oFunction.SendEmail("Request Assignment", oUser.GetName(intAssigned), "", strEMailIdsBCC, "Request Assignment", "<p><b>The following project has been assigned to you by " + oUser.GetFullName(intProfile) + "</b><p>" + strComments + "<p>" + oProjectRequest.GetBody(intRequest, intEnvironment, true) + "</p><p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/frame/resource_request.aspx?rrid=" + intResourceWorkflow.ToString() + "\" target=\"_blank\">Click here to review your new assignment.</a></p>", true, false);
}
}
string strExecutive = oProject.Get(intProject, "executive");
string strWorking = oProject.Get(intProject, "working");
string strActivity = "<tr><td><b>Resource:</b></td><td> </td><td>" + oUser.GetFullName(intAssigned) + "</td></tr>";
strActivity += strSpacerRow;
strActivity += "<tr><td><b>Service:</b></td><td> </td><td>Project Coordinator</td></tr>";
strActivity = "<table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" style=\"" + oVariable.DefaultFontStyle() + "\">" + strActivity + "</table>";
string strDeliverable = oApplication.Get(intApp, "deliverables_doc");
if (strDeliverable.Trim() != "")
{
strDeliverable = "<p><a href=\"" + oVariable.URL() + strDeliverable + "\">Click here to view the service deliverables</a></p>";
}
if (oService.Get(intService, "notify_client") != "0")
{
oFunction.SendEmail("Request Assignment", oUser.GetName(intRequester), strExecutive + ";" + strWorking + ";" + strCC, strEMailIdsBCC, "Request Assignment", "<p><b>A resource has been assigned to the following project...</b><p><p>" + oProjectRequest.GetBody(intRequest, intEnvironment, true) + "</p><p>" + strActivity + "</p>" + strDeliverable + strNotify, true, false);
}
}
}
}
}
}
protected void btnSave_Click(Object Sender, EventArgs e)
{
int intResourceWorkflow = Int32.Parse(lblResourceWorkflow.Text);
int intResourceParent = oResourceRequest.GetWorkflowParent(intResourceWorkflow);
oResourceRequest.UpdateWorkflowName(intResourceWorkflow, txtCustom.Text, intProfile);
int intClient = oRequest.GetUser(intRequest);
switch (Request.Form[hdnTab.UniqueID])
{
case "2": // Execution
int intStep = Int32.Parse(lblStep.Text);
string strNow = DateTime.Now.ToString();
switch (intStep)
{
case 1:
// Functional Requirements
int intDays = 0;
int intVersion = 0;
if (filFunctional.FileName != "" && filFunctional.PostedFile != null && Int32.TryParse(txtDays.Text, out intDays) && Int32.TryParse(radEstimate.SelectedItem.Value, out intVersion))
{
string strExtension = filFunctional.FileName;
string strType = strExtension.Substring(0, 3);
strExtension = strExtension.Substring(strExtension.LastIndexOf("."));
string strFile = DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString() + "_" + intProfile.ToString() + strExtension;
string strPath = oVariable.UploadsFolder() + strFile;
oFile.PostedFile.SaveAs(strPath);
oEnhancement.AddDocument(intID, strPath, intDays, intVersion);
}
if (chk1.Checked)
{
oEnhancement.AddStep(intID, intStep, strNow, "");
oEnhancement.AddLog(intID, intStep, "Functional Requirements Approval", intProfile, "");
oResourceRequest.UpdateStatusOverall(intResourceParent, (int)EnhancementStatus.AwaitingApproval);
}
break;
case 2:
// Approvers
if (chk2.Checked)
{
oEnhancement.AddStep(intID, intStep, strNow, strNow);
oEnhancement.AddLog(intID, intStep, "Approvals Skipped", intProfile, strNow);
oResourceRequest.UpdateStatusOverall(intResourceParent, (int)EnhancementStatus.InDevelopment);
}
break;
}
Response.Redirect(Request.Path + "?rrid=" + intResourceWorkflow.ToString() + "&menu_tab=2&save=true");
break;
case "3": // Message Thread
if (txtText.Text != "")
{
string strXid = oUser.GetName(intClient);
string strVirtualPath = "";
string strFile = "";
if (oFile.FileName != "" && oFile.PostedFile != null)
{
string strExtension = oFile.FileName;
string strType = strExtension.Substring(0, 3);
strExtension = strExtension.Substring(strExtension.LastIndexOf("."));
strFile = DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + DateTime.Now.Year.ToString() + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Millisecond.ToString() + "_" + intProfile.ToString() + strExtension;
strVirtualPath = oVariable.UploadsFolder() + strFile;
string strPath = oVariable.UploadsFolder() + strFile;
oFile.PostedFile.SaveAs(strPath);
}
oEnhancement.AddMessage(intID, txtText.Text, strVirtualPath, intProfile, 1);
string strDefault = oUser.GetApplicationUrl(intClient, intEnhancementPage);
string strBody = "";
if (strDefault != "")
{
strBody += "<p><a href=\"" + oVariable.URL() + "/redirect.aspx?referrer=/" + strDefault + oPage.GetFullLink(intEnhancementPage) + "?id=" + intID.ToString() + "\" target=\"_blank\">Click here to view this ticket or submit a response</a></p>";
}
strBody += "<table width=\"100%\" cellpadding=\"4\" cellspacing=\"3\" border=\"0\" align=\"center\" style=\"border:solid 1px #CCCCCC;" + oVariable.DefaultFontStyle() + "\">";
//DataSet dsMessages = oCustomized.GetMessages(intRequest, 0);
//foreach (DataRow drMessage in dsMessages.Tables[0].Rows)
//{
// strBody += "<tr bgcolor=\"#EEEEEE\"><td><span style=\"" + oVariable.DefaultFontStyleHeader() + "\">" + (drMessage["admin"].ToString() == "1" ? "ClearView Administrator" : oUser.GetFullName(intProfile)) + "</span> [" + DateTime.Parse(drMessage["created"].ToString()).ToString() + "]:</td></tr>";
// strBody += "<tr><td>" + drMessage["message"].ToString() + "</td></tr>";
// strBody += "<tr><td> </td></tr>";
//}
strBody += "<tr bgcolor=\"#EEEEEE\"><td><span style=\"" + oVariable.DefaultFontStyleHeader() + "\">ClearView Administrator</span> [" + DateTime.Now.ToString() + "]:</td></tr>";
strBody += "<tr><td>" + oFunction.FormatText(txtText.Text) + "</td></tr>";
if (strVirtualPath != "")
{
strBody += "<tr><td style=\"border-bottom:dashed 1px #CCCCCC\"> </td></tr>";
//strBody += "<tr><td><img src=\"" + oVariable.ImageURL() + "/images/file.gif\" align=\"absmiddle\" border=\"0\"/> <a href=\"" + oVariable.URL() + strVirtualPath + "\" target=\"_blank\">" + strFile + "</a></td></tr>";
strBody += "<tr><td><img src=\"" + oVariable.ImageURL() + "/images/file.gif\" align=\"absmiddle\" border=\"0\"/> <a href=\"" + strVirtualPath + "\" target=\"_blank\">" + strFile + "</a></td></tr>";
}
strBody += "</table>";
strEMailIdsBCC = oFunction.GetGetEmailAlertsEmailIds("EMAILGRP_DEVELOPER_ALERT");
oFunction.SendEmail("Enhancement Response [CVT" + intRequest.ToString() + "]", strXid, "", strEMailIdsBCC, "Enhancement Response [#CVT" + intRequest.ToString() + "]", "<p>" + oEnhancement.GetBody(intID, intEnvironment) + "</p><p>" + strBody + "</p>", true, false);
Response.Redirect(Request.Path + "?rrid=" + intResourceWorkflow.ToString() + "&menu_tab=3&save=true");
}
break;
}
}