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