protected void Page_Load(object sender, EventArgs e) { var str_result = ""; var _page = new PageBase(); var user = _page.CurrentUserID; var intLoadID = _page.LoadID; var obj_xml = new XmlDataDocument(); try { obj_xml.Load(Request.InputStream); if (obj_xml.DocumentElement.Name == "verify_assignment") //action code 4 { var intOItemID = 0; var intReviewerUserID = 0; var strOrgCode = ""; var email_request = 0; var node = obj_xml.DocumentElement.FirstChild; var item_id = node.Attributes.GetNamedItem("item_id").Value; if (item_id.Length > 0) { intOItemID = Int32.Parse(item_id); } strOrgCode = node.Attributes.GetNamedItem("org_code").Value; var reviewer_id = node.Attributes.GetNamedItem("reviewer_id").Value; if (reviewer_id.Length > 0) { intReviewerUserID = Int32.Parse(reviewer_id); } Assign.VerifyAssignment(intOItemID, intLoadID, strOrgCode, intReviewerUserID); // action code 4 if (Settings.Default.SendEmailOnAssignVerification) { email_request = Emails.InsertEmailRequest(user, (int)HistoryActions.haAssignmentVerification, false); } History.InsertHistoryOnReasssignment((int)HistoryActions.haAssignmentVerification, intOItemID, intLoadID, strOrgCode, "", 0, intReviewerUserID, "", user, email_request); SendEmailOnReassigRequest(intOItemID, strOrgCode, "", "", "", intReviewerUserID, 0, "", "4"); //we made update of data displayed in the items grid, so we will need to reload it: _page.ItemsDataView = null; } if (obj_xml.DocumentElement.Name == "verify_reroute") //action 10 { var intRequestID = 0; var strPrevOrganization = ""; var intPrevReviewerUserID = 0; var intNewReviewerUserID = 0; var email_request = 0; var node = obj_xml.DocumentElement.FirstChild; var request_id = node.Attributes.GetNamedItem("request_id").Value; if (request_id.Length > 0) { intRequestID = Int32.Parse(request_id); } var user_id = node.Attributes.GetNamedItem("prev_user").Value; if (user_id.Length > 0) { intPrevReviewerUserID = Int32.Parse(user_id); } strPrevOrganization = node.Attributes.GetNamedItem("prev_org").Value; var new_user_id = node.Attributes.GetNamedItem("new_reviewer").Value; if (new_user_id.Length > 0) { intNewReviewerUserID = Int32.Parse(new_user_id); } var reroute_result = Assign.VerifyReroute(intRequestID); /* * return code 0 - Item was not rerouted (missed case?) ************************************************************** * LineNum = 0 --> all lines belong to the item (same ULOOrgCode + ReviewerUserID) were rerouted: * return code 1 - new item (ItemID + NewULOOrgCode + NewReviewerUserID) already exist, lines from original item joined to the new item, * original item has been deleted (only if original and new items are not the same) * return code 2 - new item (ItemID + NewULOOrgCode + NewReviewerUserID) doesn't exist, so original item has been updated to be the new one ************************************************************** * reroute specific LineNum, there are other Lines in the original item that should not be rerouted --> split item: * ------------------------- * return code 3 - new item (ItemID + NewULOOrgCode + NewReviewerUserID) already exist, requested Line from original item joined to the new item * return code 4 - new item (ItemID + NewULOOrgCode + NewReviewerUserID) doesn't exist, requested Line from original item become new item * (insert new record into tblOIOrganization) *************************************************************** * reroute specific LineNum, there are NO other Lines in the original item that should not be rerouted --> original item should be deleted or updated: * ------------------------- * return code 5 - new item (ItemID + NewULOOrgCode + NewReviewerUserID) already exist, requested Line from original item joined to the new item, * original item has been deleted (only if original and new items are not the same) * return code 6 - new item (ItemID + NewULOOrgCode + NewReviewerUserID) doesn't exist, original item has been updated to be the new one */ if (reroute_result > 0 && reroute_result < 7) { // action code 10 if (Settings.Default.SendEmailOnRerouteAssign) // 10 { email_request = Emails.InsertEmailRequest(user, (int)HistoryActions.haRerouteAssignment, true); } History.InsertHistoryOnRerouteVerification(intRequestID, strPrevOrganization, intPrevReviewerUserID, user, email_request); SendEmailOnReassigRequest(0, "", "", strPrevOrganization, "", intPrevReviewerUserID, intNewReviewerUserID, "", "10"); ////////// //update of data displayed in the items grid has been made, so we will need to reload it: _page.ItemsDataView = null; } else { //error on reassign str_result = "<error><err_msg msg='There is a problem to reroute this item. \nPlease contact System Administrator.' /></error>"; } } if (obj_xml.DocumentElement.Name == "add_contact") { var strItem = ""; var intOItemID = 0; var strDocNumber = ""; var strOrgCode = ""; var intPersonnelID = 0; var strRoleDesc = ""; var strContactName = ""; var node = obj_xml.DocumentElement.FirstChild; var pid = node.Attributes.GetNamedItem("pid").Value; if (pid.Length > 0) { intPersonnelID = Int32.Parse(pid); } strItem = node.Attributes.GetNamedItem("item").Value; if (strItem.Length > 0) { intOItemID = Int32.Parse(strItem); } strDocNumber = node.Attributes.GetNamedItem("doc").Value; strOrgCode = node.Attributes.GetNamedItem("org").Value; strRoleDesc = node.Attributes.GetNamedItem("role").Value; strContactName = node.Attributes.GetNamedItem("name").Value; var intContactUserID = Item.AddDocumentContact(strDocNumber, strOrgCode, intPersonnelID, strRoleDesc); History.InsertHistoryOnAddItemContact(strDocNumber, intOItemID, intLoadID, strOrgCode, intContactUserID, strContactName, strRoleDesc, user); } if (obj_xml.DocumentElement.Name == "delete_contact") { var strDocNumber = ""; var strOrgCode = ""; var strItem = ""; var intOItemID = 0; var strContactName = ""; var strRoleDesc = ""; var node = obj_xml.DocumentElement.FirstChild; strDocNumber = node.Attributes.GetNamedItem("doc").Value; strOrgCode = node.Attributes.GetNamedItem("org").Value; strItem = node.Attributes.GetNamedItem("item").Value; if (strItem.Length > 0) { intOItemID = Int32.Parse(strItem); } strRoleDesc = node.Attributes.GetNamedItem("role").Value; strContactName = node.Attributes.GetNamedItem("name").Value; string strFirstName; string strLastName; strLastName = strContactName.Substring(0, strContactName.IndexOf(",")); strFirstName = strContactName.Substring(strContactName.IndexOf(",") + 2); var intContactUserID = Item.DeleteDocContact(strDocNumber, strOrgCode, strRoleDesc, strFirstName, strLastName); History.InsertHistoryOnDeleteItemContact(strDocNumber, intOItemID, intLoadID, strOrgCode, intContactUserID, strContactName, strRoleDesc, user); } if (obj_xml.DocumentElement.Name == "certify_deobl") { var node = obj_xml.DocumentElement.FirstChild; var intOItemID = Int32.Parse(node.Attributes.GetNamedItem("item_id").Value); var intItemLN = Int32.Parse(node.Attributes.GetNamedItem("line_num").Value); var strOrgCode = node.Attributes.GetNamedItem("org").Value; var cert_date = LineNum.CertifyDeobligation(intOItemID, intItemLN); if (cert_date != DateTime.MinValue) { str_result = "<result_date>" + cert_date.ToString("MMM dd, yyyy") + "</result_date>"; } else { str_result = "<result_date></result_date>"; } //insert History: History.InsertHistoryOnLineDeobligation(intOItemID, intLoadID, intItemLN, strOrgCode, cert_date, user); //we made update of data displayed in the items grid, so we will need to reload it: _page.ItemsDataView = null; } if (obj_xml.DocumentElement.Name == "reassign_request") //5 { var node = obj_xml.DocumentElement.FirstChild; var strItemID = node.Attributes.GetNamedItem("item").Value; var strLines = node.Attributes.GetNamedItem("lines").Value; var strOrgCode = node.Attributes.GetNamedItem("org_code").Value; var strOrgNewValue = node.Attributes.GetNamedItem("org_new_value").Value; var strUserId = node.Attributes.GetNamedItem("user_id").Value; var strComments = node.Attributes.GetNamedItem("com").Value; //string strDocNum = node.Attributes.GetNamedItem("doc_num").Value; var strResponsibleOrganization = Lookups.GetOrganizationByOrgCode(strOrgCode); var strNewOrganization = ""; var strNewOrgCode = ""; if (strOrgNewValue.Length > 0) { strNewOrganization = strOrgNewValue.Substring(0, strOrgNewValue.IndexOf(":") - 1); strNewOrgCode = strOrgNewValue.Substring(strOrgNewValue.IndexOf(":") + 2); } var intItemID = Int32.Parse(strItemID); var intUserID = 0; if (strUserId.Length > 0) { intUserID = Int32.Parse(strUserId); } if (strLines == "") { strLines = "0"; } // ***SM var intRequestID = Assign.RequestReassignItem(intItemID, strOrgCode, strLines, user, strResponsibleOrganization, strNewOrganization, strNewOrgCode, intUserID, strComments); if (intRequestID == 0) { str_result = "<error><err_msg msg='This Open Item has been already requested for reroute. \nPlease refresh your items view.' /></error>"; } else { var email_request = 0; if (Settings.Default.SendEmailOnRerouteRequest) { email_request = Emails.InsertEmailRequest(user, (int)HistoryActions.haRerouteRequest, true); } History.InsertHistoryOnRerouteRequest(intItemID, strLines, intLoadID, strOrgCode, intRequestID, strOrgNewValue, user, intUserID, strComments, user, email_request); } //refresh Items GridResults on the next reload: _page.ItemsDataView = null; SendEmailOnReassigRequest(intItemID, strOrgCode, strNewOrgCode, strResponsibleOrganization, strNewOrganization, user, intUserID, strComments, "5"); } if (obj_xml.DocumentElement.Name == "reassign_reroute") //3 { var node = obj_xml.DocumentElement.FirstChild; var strItemID = node.Attributes.GetNamedItem("item").Value; var strOrgCode = node.Attributes.GetNamedItem("org_code").Value; var strLines = node.Attributes.GetNamedItem("lines").Value; var strOrgNewValue = node.Attributes.GetNamedItem("org_new_value").Value; var strAction = node.Attributes.GetNamedItem("action").Value; var strPrevUserId = node.Attributes.GetNamedItem("prev_user_id").Value; var strUserId = node.Attributes.GetNamedItem("user_id").Value; var strComments = node.Attributes.GetNamedItem("com").Value; var strRequestId = node.Attributes.GetNamedItem("request").Value; var strResponsibleOrganization = ""; var strNewOrganization = ""; var strNewOrgCode = ""; var intUserID = 0; var intPreviousReviewerID = 0; var email_request = 0; var intRequestID = 0; if (strUserId.Length > 0) { intUserID = Int32.Parse(strUserId); } if (strPrevUserId.Length > 0) { intPreviousReviewerID = Int32.Parse(strPrevUserId); } if (strOrgNewValue.Length > 0) { strNewOrganization = strOrgNewValue.Substring(0, strOrgNewValue.IndexOf(":") - 1); strNewOrgCode = strOrgNewValue.Substring(strOrgNewValue.IndexOf(":") + 2); } var intActionCode = Int32.Parse(strAction); var intItemID = Int32.Parse(strItemID); if (strRequestId != "") { intRequestID = Int32.Parse(strRequestId); } if (intActionCode == (int)HistoryActions.haReviewerAssignment) { //in the case of reviewer reassignment within the same organization, //instead of this: //AssignBO.ReassignItem(intItemID, strOrgCode, intPreviousReviewerID, intUserID, strComments); // we will use direct reroute for item (or specific lines) within the same organization: strResponsibleOrganization = Lookups.GetOrganizationByOrgCode(strOrgCode); /*****************************************************************************************************/ //ADD LOG FOR WATCHING RECORDS UPDATE IN THE tblOIOrganization !!!!!!!!!!! /*****************************************************************************************************/ var dt = Assign.RerouteItemDirectly(intItemID, strLines, intPreviousReviewerID, strOrgCode, strResponsibleOrganization, strOrgCode, intUserID, strComments); //if we don't have previous Reviewer - it is first time Reviewer Assignment - //we don't need to send immidiately notification email; //if we do have previous Reviewer - it is Re-Assignment within the same organization, //we should send notification email to user immidiately: if (intPreviousReviewerID == 0) { if (Settings.Default.SendEmailOnReviewerAssignment) { email_request = Emails.InsertEmailRequest(user, (int)HistoryActions.haReviewerAssignment, false); } // action code 3 History.InsertHistoryOnReasssignment((int)HistoryActions.haReviewerAssignment, intItemID, intLoadID, strOrgCode, strLines, intPreviousReviewerID, intUserID, strComments, user, email_request); } else { if (Settings.Default.SendEmailOnReviewerReassign) { email_request = Emails.InsertEmailRequest(user, (int)HistoryActions.haReviewerReassignment, true); } History.InsertHistoryOnReasssignment((int)HistoryActions.haReviewerReassignment, intItemID, intLoadID, strOrgCode, strLines, intPreviousReviewerID, intUserID, strComments, user, email_request); } //in the case of reroute request by Reviewer, the item has been already reassigned (code above), //we need to cancel reroute request in the tblReassignRequest table: if (intRequestID != 0) { Assign.CancelRerouteRequest(intRequestID); } } else if (intActionCode == (int)HistoryActions.haRerouteRequest) { //in the case of reroute request by Reviewer, //we need to cancel previous reroute request in the tblReassignRequest table, //and then to create new reroute request for BD: if (intRequestID != 0) { Assign.CancelRerouteRequest(intRequestID); } intRequestID = Assign.RequestReassignItem(intItemID, strOrgCode, strLines, intPreviousReviewerID, OIConstants.OpenItemsGridFilter_BDResponsibility, strNewOrganization, strNewOrgCode, intUserID, strComments); if (intRequestID == 0) { str_result = "<error><err_msg msg='This Open Item has been already requested for reroute. \nPlease refresh your items view.' /></error>"; } else { //send email only if current logged on user is not "BD Admin" if (!User.IsInRole(((int)UserRoles.urBudgetDivisionAdmin).ToString()) && Settings.Default.SendEmailOnRerouteRequest) { email_request = Emails.InsertEmailRequest(user, (int)HistoryActions.haRerouteRequest, true); } History.InsertHistoryOnRerouteRequest(intItemID, strLines, intLoadID, strOrgCode, intRequestID, strOrgNewValue, intPreviousReviewerID, intUserID, strComments, user, email_request); } } SendEmailOnReassigRequest(intItemID, strOrgCode, strNewOrgCode, strResponsibleOrganization, strNewOrganization, user, intUserID, strComments, "4"); //refresh Items GridResults on the next reload: _page.ItemsDataView = null; } if (obj_xml.DocumentElement.Name == "group_reroute") //action 16 { var node = obj_xml.DocumentElement.FirstChild; var strLoadID = "0"; var strItemsArray = node.Attributes.GetNamedItem("items").Value; var strOrgNewValue = node.Attributes.GetNamedItem("org_new_value").Value; var strUserID = node.Attributes.GetNamedItem("user").Value; var strComments = node.Attributes.GetNamedItem("com").Value; var strNewOrganization = ""; var strNewOrgCode = ""; var intUserID = 0; var email_request = 0; if (strUserID.Length > 0) { intUserID = Int32.Parse(strUserID); } if (strOrgNewValue.Length > 0) { strNewOrganization = strOrgNewValue.Substring(0, strOrgNewValue.IndexOf(":") - 1); strNewOrgCode = strOrgNewValue.Substring(strOrgNewValue.IndexOf(":") + 2); } if (strItemsArray.Substring(strItemsArray.Length - 1) == ",") { strItemsArray = strItemsArray.Substring(0, strItemsArray.Length - 1); } var arr = strItemsArray.Split(new char[] { ',' }); string item_id; string line_num; DataTable dt; LineNum line_obj = null; foreach (var arr_item in arr) { if (arr_item != "") { item_id = arr_item.Substring(0, arr_item.IndexOf("_")).Trim(); line_num = arr_item.Substring(arr_item.IndexOf("_") + 1).Trim(); line_obj = LineNum.GetLineNum(Int32.Parse(item_id), Int32.Parse(line_num)); if (intLoadID == 0) { strLoadID = Admin.GetLoadIDByItemID(line_obj.OItemID); if (strLoadID != null && strLoadID.Trim() != "" && strLoadID != "0") { intLoadID = Convert.ToInt32(strLoadID); } } if (strNewOrganization == "" || line_obj.Organization == strNewOrganization) { //reassignment within the same organization: // corrected by Foram dt = Assign.RerouteItemDirectly(line_obj.OItemID, line_num, line_obj.ReviewerUserID, line_obj.ULOOrgCode, line_obj.Organization, strNewOrgCode, intUserID, strComments); // //action code 16 History.InsertHistoryOnReasssignment((int)HistoryActions.haReviewerReassignment, line_obj.OItemID, intLoadID, line_obj.ULOOrgCode, line_num, line_obj.ReviewerUserID, intUserID, strComments, user, 0); } else { //reroute to an other organization: dt = Assign.RerouteItemDirectly(line_obj.OItemID, line_num, line_obj.ReviewerUserID, line_obj.ULOOrgCode, strNewOrganization, strNewOrgCode, intUserID, strComments); History.InsertHistoryOnRerouteReassign(line_obj.OItemID, dt, line_num, intLoadID, line_obj.DocNumber, line_obj.ULOOrgCode, line_obj.Organization, line_obj.ReviewerUserID, strNewOrgCode, strOrgNewValue, intUserID, strComments, user, 0); } } } if (strNewOrganization == "" && line_obj != null) { strNewOrganization = line_obj.Organization; strNewOrgCode = line_obj.ULOOrgCode; } //insert history for group assignment - for email details, //in the case of group assignment one email only will be sent to the user if (Settings.Default.SendEmailOnGroupAssign) { // action code 19 email_request = Emails.InsertEmailRequest(user, (int)HistoryActions.haGroupAssignment, true); //SendEmailOnReassigRequest(intOItemID, strCurrentOrgCode, strNewOrgCode, strCurrentOrganization, strNewOrganization, user, intUserID, strComments, "19"); } History.InsertHistoryOnGroupAssign(intLoadID, intUserID, strNewOrganization, strNewOrgCode, strComments, user, email_request); SendEmailOnReassigRequest(0, line_obj.ULOOrgCode, strNewOrgCode, line_obj.Organization, strNewOrganization, user, intUserID, strComments, "16"); //refresh Items GridResults on the next reload: _page.ItemsDataView = null; } if (obj_xml.DocumentElement.Name == "reroute") //10 { var node = obj_xml.DocumentElement.FirstChild; var strRequestID = node.Attributes.GetNamedItem("request_id").Value; var strOItemID = node.Attributes.GetNamedItem("item_id").Value; var strLines = node.Attributes.GetNamedItem("lines").Value; var strDocNum = node.Attributes.GetNamedItem("doc_num").Value; var strPrevOrganization = node.Attributes.GetNamedItem("prev_org").Value; var strPrevReviewer = node.Attributes.GetNamedItem("prev_user").Value; var strOrgNewValue = node.Attributes.GetNamedItem("org_new_value").Value; var strUserID = node.Attributes.GetNamedItem("user").Value; var strComments = node.Attributes.GetNamedItem("com").Value; var strNewOrganization = ""; var strNewOrgCode = ""; var strCurrentOrganization = ""; var strCurrentOrgCode = ""; var intOItemID = 0; var intUserID = 0; var intRequestID = 0; var intPrevUserID = 0; var email_request = 0; if (strOItemID.Length > 0) { intOItemID = Int32.Parse(strOItemID); } if (strRequestID.Length > 0) { intRequestID = Int32.Parse(strRequestID); } if (strUserID.Length > 0) { intUserID = Int32.Parse(strUserID); } if (strPrevReviewer.Length > 0) { intPrevUserID = Int32.Parse(strPrevReviewer); } if (strPrevOrganization.Length > 0) { strCurrentOrganization = strPrevOrganization.Substring(0, strPrevOrganization.IndexOf(":") - 1); strCurrentOrgCode = strPrevOrganization.Substring(strPrevOrganization.IndexOf(":") + 2); } if (strOrgNewValue.Length > 0) { strNewOrganization = strOrgNewValue.Substring(0, strOrgNewValue.IndexOf(":") - 1); strNewOrgCode = strOrgNewValue.Substring(strOrgNewValue.IndexOf(":") + 2); } if (intRequestID > 0) { //reroute item by request: var RetCode = Assign.RerouteItem(intRequestID, strNewOrganization, strNewOrgCode, intUserID, strComments); if (Settings.Default.SendEmailOnRerouteAssign) { email_request = Emails.InsertEmailRequest(user, (int)HistoryActions.haRerouteAssignment, true); } History.InsertHistoryOnRerouteReassign(intRequestID, strPrevOrganization, intPrevUserID, strOrgNewValue, intUserID, strComments, user, email_request); } else { //reroute item directly to user, the action permitted to BD Admin only: var dt = Assign.RerouteItemDirectly(intOItemID, strLines, intPrevUserID, strCurrentOrgCode, strNewOrganization, strNewOrgCode, intUserID, strComments); if (Settings.Default.SendEmailOnRerouteAssign) { email_request = Emails.InsertEmailRequest(user, (int)HistoryActions.haRerouteAssignment, true); } History.InsertHistoryOnRerouteReassign(intOItemID, dt, strLines, intLoadID, strDocNum, strCurrentOrgCode, strPrevOrganization, intPrevUserID, strNewOrgCode, strOrgNewValue, intUserID, strComments, user, email_request); //refresh Items GridResults on the next reload: _page.ItemsDataView = null; } SendEmailOnReassigRequest(intOItemID, strCurrentOrgCode, strNewOrgCode, strCurrentOrganization, strNewOrganization, user, intUserID, strComments, "10"); } if (obj_xml.DocumentElement.Name == "select_doc_to_email") { var node = obj_xml.DocumentElement.FirstChild; bool bln_selected; int doc_id; var selected_value = node.Attributes.GetNamedItem("selected").Value; var selected_doc = node.Attributes.GetNamedItem("doc").Value; if (selected_value != "" && selected_doc != "") { bln_selected = Boolean.Parse(selected_value); doc_id = Int32.Parse(selected_doc); Document.SelectSendAttachment(_page.DocNumber, doc_id, _page.LoadID, bln_selected); if (Settings.Default.InsertHistory_OnSelectAttachmentToCO) { var doc = new Document(doc_id); var file_name = doc.FileName; var doc_type = String.Join(",", doc.DocumentTypeName); History.InsertHistoryOnSelectAttachmentForEmail((int)HistoryActions.haSelectAttachmentForCOEmail, _page.DocNumber, _page.LoadID, bln_selected, doc_id, doc_type, file_name, _page.CurrentUserOrganization, user); } } } if (obj_xml.DocumentElement.Name == "select_doc_revision_email") { var node = obj_xml.DocumentElement.FirstChild; bool bln_selected; int doc_id; var selected_value = node.Attributes.GetNamedItem("selected").Value; var selected_doc = node.Attributes.GetNamedItem("doc").Value; if (selected_value != "" && selected_doc != "") { bln_selected = Boolean.Parse(selected_value); doc_id = Int32.Parse(selected_doc); Document.SelectAttachmentForRevision(_page.DocNumber, doc_id, _page.LoadID, bln_selected); if (Settings.Default.InsertHistory_OnSelectAttachmentToSME) { var doc = new Document(doc_id); var file_name = doc.FileName; var doc_type = String.Join(",", doc.DocumentTypeName); History.InsertHistoryOnSelectAttachmentForEmail((int)HistoryActions.haSelectAttachmentForSMEEmail, _page.DocNumber, _page.LoadID, bln_selected, doc_id, doc_type, file_name, _page.CurrentUserOrganization, user); } } } if (obj_xml.DocumentElement.Name == "select_doc_approved") { var node = obj_xml.DocumentElement.FirstChild; Int16 selected; int doc_id; int doc_type_code; var selected_value = node.Attributes.GetNamedItem("selected").Value; var selected_doc = node.Attributes.GetNamedItem("doc").Value; var doc_type = node.Attributes.GetNamedItem("doc_type").Value; var doc_type_name = node.Attributes.GetNamedItem("doc_type_name").Value; var file_name = node.Attributes.GetNamedItem("file_name").Value; var upload_user_email = node.Attributes.GetNamedItem("user").Value; var upload_organization = node.Attributes.GetNamedItem("org").Value; if (selected_value != "" && selected_doc != "" && doc_type != "") { selected = (Boolean.Parse(selected_value)) ? (Int16)DocRevisionStatus.dsApproved : (Int16)DocRevisionStatus.dsNotApproved; doc_id = Int32.Parse(selected_doc); doc_type_code = Int32.Parse(doc_type); Document.UpdateDocRevision(_page.LoadID, _page.DocNumber, doc_id, doc_type_code, selected); History.InsertHistoryOnDocumentRevision(_page.DocNumber, _page.LoadID, doc_id, file_name, doc_type_name, selected, upload_user_email, upload_organization, user); } } if (obj_xml.DocumentElement.Name == "save_feedback") { var intItemID = 0; var intReviewer = 0; var intLoad = 0; var intValid = 0; decimal decDO = 0; decimal decUDO = 0; var error_msg = ""; var node = obj_xml.DocumentElement.FirstChild; var item_id = node.Attributes.GetNamedItem("item_id").Value; if (item_id.Length > 0) { intItemID = Int32.Parse(item_id); } var reviewer_id = node.Attributes.GetNamedItem("reviewer_id").Value; if (reviewer_id.Length > 0) { intReviewer = Int32.Parse(reviewer_id); } var load_id = node.Attributes.GetNamedItem("load_id").Value; if (load_id.Length > 0) { intLoad = Int32.Parse(load_id); } var valid = node.Attributes.GetNamedItem("valid").Value; if (valid.Length > 0) { intValid = Int32.Parse(valid); } var udo_should_be = node.Attributes.GetNamedItem("udo").Value; var do_should_be = node.Attributes.GetNamedItem("do").Value; if (intValid == 0) { error_msg = "Please select the validation value. This is a required field. "; } try { if (udo_should_be.Length > 0 && udo_should_be != "$") { decUDO = Utility.GetDecimalFromDisplayedMoney(udo_should_be); } if (do_should_be.Length > 0 && do_should_be != "$") { decDO = Utility.GetDecimalFromDisplayedMoney(do_should_be); } } catch (Exception exp) { error_msg = error_msg + "Please verify that you have entered the correct money value."; } if (error_msg != "") { str_result = "<error><err_msg msg='" + error_msg + "' /></error>"; } else { var response = node.Attributes.GetNamedItem("response").Value; var doc_number = node.Attributes.GetNamedItem("doc_num").Value; var org_code = node.Attributes.GetNamedItem("org_code").Value; Item.SaveFeedbackResponse(intItemID, doc_number, intLoad, intValid, response, decUDO, decDO); //update item status: Item.UpdateItemStatus(intItemID, intLoad, org_code, intReviewer, (int)OpenItemStatus.stClosed); History.InsertHistoryOnFeedbackResponse(doc_number, intLoad, intItemID, org_code, intValid, response, decUDO, decDO, (int)OpenItemStatus.stClosed, intReviewer, user); //refresh Items GridResults on the next reload: _page.ItemsDataView = null; } } if (str_result == "") { str_result = "<ok/>"; } } catch (Exception ex) { str_result = "<error><err_msg msg='" + ex.Message + "' /></error>"; } Response.ContentType = "text/xml"; Response.Write(str_result); Response.Flush(); }
protected void Page_Load(object sender, EventArgs e) { var str_result = ""; var _page = new PageBase(); var user = _page.CurrentUserID; var obj_xml = new XmlDataDocument(); try { obj_xml.Load(Request.InputStream); if (obj_xml.DocumentElement.Name == "search_request") { Reports.InsertFSRequestResultsByEmail(_page.FundsSearchSelectedValues, user); } if (obj_xml.DocumentElement.Name == "update_data") { var node = obj_xml.DocumentElement.FirstChild; var entry_type = node.Attributes.GetNamedItem("type").Value.Trim(); var entry_id = node.Attributes.GetNamedItem("id").Value.Trim(); var organization = node.Attributes.GetNamedItem("org").Value.Trim(); var fiscal_year = node.Attributes.GetNamedItem("fy").Value.Trim(); var month = node.Attributes.GetNamedItem("bm").Value.Trim(); var group_code = node.Attributes.GetNamedItem("gcd").Value.Trim(); var amount = node.Attributes.GetNamedItem("amount").Value.Trim(); var doc_number = node.Attributes.GetNamedItem("doc").Value.Trim(); var explanation = node.Attributes.GetNamedItem("exp").Value.Trim(); var intEntryType = Int32.Parse(entry_type); var intEntryID = Int32.Parse(entry_id); var mAmount = Decimal.Parse(amount); var intGroupCode = Int32.Parse(group_code); //update data: FundStatus.UpdateUserEntryData(intEntryType, fiscal_year, month, organization, intGroupCode, intEntryID, doc_number, mAmount, explanation, user); //insert history log: var action_code = 0; switch (intEntryType) { case (int)FundsStatusUserEntryType.ueOverUnderAccrued: action_code = (int)HistoryActions.haUpdateOverUnderAccrued; break; case (int)FundsStatusUserEntryType.ueOneTimeAdjustment: action_code = (int)HistoryActions.haUpdateOneTimeAdjustment; break; case (int)FundsStatusUserEntryType.ueExpectedByYearEnd: action_code = (int)HistoryActions.haUpdateExpectedByYearEnd; break; } History.InsertHistoryOnUpdateFundStatusData(action_code, organization, fiscal_year, month, intGroupCode, doc_number, Utility.DisplayMoneyFormat(mAmount), explanation, user); //clear fund status report state: FSSummaryReport.DataObsoleteFlag(fiscal_year, organization); } if (obj_xml.DocumentElement.Name == "delete_entry") { var node = obj_xml.DocumentElement.FirstChild; var entry_type = node.Attributes.GetNamedItem("type").Value.Trim(); var entry_id = node.Attributes.GetNamedItem("id").Value.Trim(); var organization = node.Attributes.GetNamedItem("org").Value.Trim(); var fiscal_year = node.Attributes.GetNamedItem("fy").Value.Trim(); var month = node.Attributes.GetNamedItem("bm").Value.Trim(); var group_code = node.Attributes.GetNamedItem("gcd").Value.Trim(); var amount = node.Attributes.GetNamedItem("amount").Value.Trim(); var doc_number = node.Attributes.GetNamedItem("doc").Value.Trim(); var intEntryType = Int32.Parse(entry_type); var intEntryID = Int32.Parse(entry_id); var mAmount = Decimal.Parse(amount); //update data: FundStatus.DeleteUserEntryRecord(intEntryID, user); //insert history log: //insert history action as Update not as Delete because of displaying info message to user when last data update has been done. //if in future will be special request on separate history entries - will be changed. var action_code = 0; switch (intEntryType) { case (int)FundsStatusUserEntryType.ueOverUnderAccrued: action_code = (int)HistoryActions.haUpdateOverUnderAccrued; break; case (int)FundsStatusUserEntryType.ueOneTimeAdjustment: action_code = (int)HistoryActions.haUpdateOneTimeAdjustment; break; case (int)FundsStatusUserEntryType.ueExpectedByYearEnd: action_code = (int)HistoryActions.haUpdateExpectedByYearEnd; break; } History.InsertHistoryOnUpdateFundStatusData(action_code, organization, fiscal_year, month, Int32.Parse(group_code), doc_number, Utility.DisplayMoneyFormat(mAmount), "the record has been deleted", user); //clear fund status report state: FSSummaryReport.DataObsoleteFlag(fiscal_year, organization); } if (obj_xml.DocumentElement.Name == "recalc_report") { var node = obj_xml.DocumentElement.FirstChild; var business_line = node.Attributes.GetNamedItem("bl").Value; var organization = node.Attributes.GetNamedItem("org").Value; var fiscal_year = node.Attributes.GetNamedItem("fy").Value; //rebuild fund status report state: FundStatus.RecalculateFSReport(fiscal_year, organization, business_line); History.InsertHistoryOnRebuildFSReport(fiscal_year, organization, business_line, user); } if (obj_xml.DocumentElement.Name == "recalc_rwa") { var node = obj_xml.DocumentElement.FirstChild; var organization = node.Attributes.GetNamedItem("org").Value; var fiscal_year = node.Attributes.GetNamedItem("fy").Value; var month = node.Attributes.GetNamedItem("m").Value; var projection = node.Attributes.GetNamedItem("rwa").Value; if (FundStatus.UpdateRWAProjection(fiscal_year, month, organization, projection, user)) { FSSummaryReport.DataObsoleteFlag(fiscal_year, organization); History.InsertHistoryOnUpdateRWAProjection(organization, fiscal_year, month, projection, user); } } if (str_result == "") { str_result = "<ok/>"; } } catch (Exception ex) { str_result = "<error><err_msg msg='" + ex.Message + "' /></error>"; } Response.ContentType = "text/xml"; Response.Write(str_result); Response.Flush(); }