public bool Load(CCommand Command, string FileName, string BranchCode, string TaskCode)
{
int LineNum;
bool Result = true;
string DebitAcc, CreditAcc, DebitIBAN, CreditIBAN;
if (AFileReader == null)
{
return(false);
}
if (AFileReader.Open(FileName, CAbc.CHARSET_DOS))
{
string ShortFileName = CCommon.GetFileName(FileName);
LineNum = 1;
while (AFileReader.Read())
{
DebitAcc = AFileReader[CSepAFileInfo.L_DEBITACC].Replace("'", "`").Trim();
DebitAcc = CCommon.IsDigit(DebitAcc) ? DebitAcc : AFileReader[CSepAFileInfo.L_DEBITACC_EXT].Replace("'", "`").Trim();
DebitAcc = CCommon.IsDigit(DebitAcc) ? DebitAcc : "";
CreditAcc = AFileReader[CSepAFileInfo.L_CREDITACC].Replace("'", "`").Trim();
CreditAcc = CCommon.IsDigit(CreditAcc) ? CreditAcc : AFileReader[CSepAFileInfo.L_CREDITACC_EXT].Replace("'", "`").Trim();
CreditAcc = CCommon.IsDigit(CreditAcc) ? CreditAcc : "";
DebitIBAN = AFileReader[CSepAFileInfo.L_DEBITIBAN].Replace("'", "`").Trim();
DebitIBAN = CCommon.IsLetter(DebitIBAN) ? DebitIBAN : CAbc.EMPTY;
CreditIBAN = AFileReader[CSepAFileInfo.L_CREDITIBAN].Replace("'", "`").Trim();
CreditIBAN = CCommon.IsLetter(CreditIBAN) ? CreditIBAN : CAbc.EMPTY;
CmdText = "exec dbo.pMega_OpenGate_AddPalvis "
+ " @TaskCode = '" + TaskCode.Trim() + "'"
+ ",@BranchCode = '" + BranchCode.Trim() + "'"
+ ",@FileName = '" + ShortFileName + "'"
+ ",@LineNum = " + LineNum.ToString()
+ ",@Code = '" + AFileReader[CSepAFileInfo.L_NDOC].Replace("'", "`").Trim() + "'"
+ ",@Ctrls = '" + AFileReader[CSepAFileInfo.L_SYMBOL].Replace("'", "`").Trim() + "'"
+ ",@SourceCode = '" + AFileReader[CSepAFileInfo.L_DEBITMFO].Replace("'", "`").Trim() + "'"
+ ",@DebitMoniker = '" + DebitAcc + "'"
+ ",@DebitName = '" + AFileReader[CSepAFileInfo.L_DEBITNAME].Replace("'", "`").Trim() + "'"
+ ",@DebitState = '" + AFileReader[CSepAFileInfo.L_OKPO1].Replace("'", "`").Trim() + "'"
+ ",@DebitIBAN = '" + DebitIBAN + "'"
+ ",@TargetCode = '" + AFileReader[CSepAFileInfo.L_CREDITMFO].Replace("'", "`").Trim() + "'"
+ ",@CreditMoniker= '" + CreditAcc + "'"
+ ",@CreditName = '" + AFileReader[CSepAFileInfo.L_CREDITNAME].Replace("'", "`").Trim() + "'"
+ ",@CreditState = '" + AFileReader[CSepAFileInfo.L_OKPO2].Replace("'", "`").Trim() + "'"
+ ",@CreditIBAN = '" + CreditIBAN + "'"
+ ",@CrncyAmount = " + AFileReader[CSepAFileInfo.L_SUMA].Replace("'", "`").Trim()
+ ",@CurrencyId = " + AFileReader[CSepAFileInfo.L_CURRENCY].Replace("'", "`").Trim()
+ ",@Purpose = '" + AFileReader[CSepAFileInfo.L_PURPOSE].Replace("'", "`").Trim() + "'"
+ ",@OrgDate = " + CCommon.StrDate_To_IntDate("20" + AFileReader[CSepAFileInfo.L_DATE2].Trim())
+ ",@UserName = '******'"
;
if (Command.Execute(CmdText) != true)
{
Result = false;
}
LineNum = LineNum + 1;
CConsole.ShowBox("", " Загружается строка" + CCommon.StrI(LineNum, 5) + " ", "");
}
}
AFileReader.Close();
return(Result);
}
public void ShowFuncInfo()
{
Console.WriteLine(LineNum.ToString());
Console.WriteLine(UsefulStringsNum.ToString());
Console.WriteLine(KeywordsNum.ToString());
Console.WriteLine(FuncName);
}
public override string ToString()
{
string value1 = string.Empty;
if (TokenType == LexerTokenType.KEYWORD)
{
value1 = Keyword.ToString();
}
else
{
value1 = Value;
}
StringBuilder sb = new StringBuilder(128);
sb.Append("Token value:");
sb.Append(Value);
sb.Append(", type:");
sb.Append(TokenType.ToString());
if (TokenType == LexerTokenType.KEYWORD)
{
sb.Append(", key:" + Keyword.ToString());
}
sb.Append(", lineNum:");
sb.Append(LineNum.ToString());
sb.Append(", position:");
sb.Append(Position.ToString());
return(sb.ToString());
}
public void UpdateDetails(int iOItemID, int iLoadID, int iLineN, string sULOOrgCode, int iValid, string sComments, int iJustification,
string sJustificationAddOn, string sJustificationOther, string sCode, string sCodeComment, string sRWA, int iUpdateUser)
{
/*****************************************************************/
//1. - update Line properties
/*****************************************************************/
var objLine = new LineNum(iOItemID, iLineN);
var reviewer = objLine.ReviewerUserID;
var line_prev_validation = objLine.Valid;
objLine.Valid = iValid;
objLine.Comments = sComments;
objLine.JustificationCode = iJustification;
objLine.JustificationAddOn = sJustificationAddOn;
objLine.JustificationOther = sJustificationOther;
objLine.Code = sCode;
objLine.CodeComments = sCodeComment;
objLine.RWA = sRWA;
objLine.Save(iUpdateUser);
iJustification = objLine.JustificationCode;
//get Open Item details
var objItem = new OpenItem(iOItemID, iLoadID, sULOOrgCode, reviewer);
var document_valid = objItem.ValidCode;
var item_status = objItem.StatusCode;
var item_new_status = objItem.StatusCode;
var item_orig_orgcode = objItem.OriginalOrgCode;
var doc_number = objItem.DocNumber;
//2. - insert History on update Line Properties
// OR
//3. - insert History on update Line Validation if it has been changed
// (insert only one record to the History due to not duplicate records)
if (line_prev_validation != iValid)
{
History.InsertHistoryOnLineUpdate((int)HistoryActions.haLineValidationUpdate, iLoadID, iOItemID, item_orig_orgcode, sULOOrgCode,
doc_number, iLineN, item_status, iValid, sCode, sCodeComment, iJustification, sJustificationAddOn, sComments, reviewer, iUpdateUser);
}
else
{
History.InsertHistoryOnLineUpdate((int)HistoryActions.haLinePropertiesUpdate, iLoadID, iOItemID, item_orig_orgcode, sULOOrgCode,
doc_number, iLineN, item_status, line_prev_validation, sCode, sCodeComment, iJustification, sJustificationAddOn, sComments, reviewer, iUpdateUser);
}
/*****************************************************************/
//4. - update Item Status if necessary
/*****************************************************************/
item_new_status = Item.CalculateItemStatus(iOItemID, sULOOrgCode, reviewer);
if (item_status != item_new_status)
{
Item.UpdateItemStatus(iOItemID, iLoadID, sULOOrgCode, reviewer, item_new_status);
//5. - insert History on update Item Status
History.InsertHistoryOnItemUpdate((int)HistoryActions.haItemPropertiesUpdate, iLoadID, iOItemID, item_orig_orgcode, sULOOrgCode,
doc_number, item_new_status, document_valid, null, reviewer, iUpdateUser);
}
}
private void AlignRight()
{
LineNum.SelectAll();
LineNum.SelectionAlignment = HorizontalAlignment.Right;
LineNum.DeselectAll();
OutputText.SelectAll();
OutputText.SelectionAlignment = HorizontalAlignment.Center;
OutputText.DeselectAll();
}
private void ProcessFileCheckBox_CheckedChanged(object sender, EventArgs e)
{
string result;
System.Text.RegularExpressions.Regex numeric = new System.Text.RegularExpressions.Regex("^[0-9](\\.?[0-9])+$");
if ((sender as CheckBox).Checked)
{
using (StreamReader sr = new StreamReader(file.Text))
{
// initialize some accumulator variables (for lines of numbers count and average)
int numCount = 0;
int count = 0;
string line = sr.ReadLine();
while (line != null) // null is returned at the end of the file
{
// Process
if (numeric.IsMatch(line))
{
// process all lines that are numeric
numCount++;
}
// read the next line
line = sr.ReadLine();
count++;
}
result = String.Format($"{openFileDialog1.FileName} contains {numCount} line(s) of numbers ({(double)numCount / count:P0})");
OutputText.Text += result;
using (StreamWriter writer = new StreamWriter("Result.txt", true))
{
writer.WriteLine(result);
}
LineNum.AppendText($"{File.ReadAllLines("Result.txt").Count()}");
}
LineNum.Visible = true;
OutputGrouping.Visible = true;
OutputText.Visible = true;
}
else
{
OutputText.Text += "\n";
LineNum.Text += "\n";
}
}
private void LoadLineNumDetails(LineNum line_item, bool EnableForUpdate, bool IsArchived)
{
lblLineNum.Text = line_item.LineNumID.ToString();
lblReviewer.Text = line_item.Reviewer;
txtReviewerEmail.Value = Admin.GetEmailByUserID(line_item.ReviewerUserID);
lblOrganization.Text = line_item.Organization;
lblOrgCode.Text = line_item.ULOOrgCode;
if (IsArchived)
{
lblStatus.Text = line_item.Status + " (Archived)";
}
else
{
lblStatus.Text = line_item.StatusDescription;
}
//display Line ULOOrgCode only if it's different from Open Item ULOOrgCode:
/*
* if (lblOrgCode.Text != line_item.ULOOrgCode)
* {
* lblLineOrgCode.Text = String.Format(" ({0})", line_item.ULOOrgCode);
* lblLineOrgCode.Visible = true;
* }
* else
* lblLineOrgCode.Visible = false;
*/
lblValid.Text = line_item.ValidDescription;
if (line_item.Valid == (int)OpenItemValidation.vlInvalid)
{
lblDeobligatedDate.Visible = true;
lblDeobligatedInfo.Visible = true;
lblDeobligatedDate.Text = Utility.DisplayDateFormat(line_item.DeobligatedDate, "MMM dd, yyyy");
}
else
{
lblDeobligatedInfo.Visible = false;
lblDeobligatedDate.Visible = false;
}
lblTotalLineLine.Text = Utility.DisplayMoneyFormat(line_item.TotalLine);
lblProjNum.Text = line_item.ProjectNumber;
lblBA.Text = line_item.BA;
txtRWA.Text = line_item.RWA;
lblAGRE_BLDG.Text = line_item.AGRE_BLDG;
lblBuilding.Text = line_item.Building;
lblVendCD.Text = line_item.VendorCD;
lblVendName.Text = line_item.VendorName;
lblACTG_PD.Text = Utility.DisplayDateFormat(line_item.ACTG_PD, "MMM dd, yyyy");
lblLastPaidLine.Text = Utility.DisplayDateFormat(line_item.LastPaid, "MMM dd, yyyy");
lblBBFY.Text = line_item.BBFY.ToString();
lblEBFY.Text = line_item.EBFY.ToString();
lblUDOLine.Text = Utility.DisplayMoneyFormat(line_item.UDO);
lblFC.Text = line_item.FC;
lblOC.Text = line_item.OC.ToString();
lblCE.Text = line_item.CE.ToString();
lblACCRLine.Text = Utility.DisplayMoneyFormat(line_item.ACCR);
lblPENDPYMTLine.Text = Utility.DisplayMoneyFormat(line_item.PEND_PYMT);
lblPYMTS_CONFLine.Text = Utility.DisplayMoneyFormat(line_item.PYMTS_CONF);
lblHOLDBACKSLine.Text = Utility.DisplayMoneyFormat(line_item.HOLDBACKS);
txtComment.Text = line_item.Comments;
if (line_item.LineInfo.Length > 0)
{
txtLineInfo.Text = line_item.LineInfo;
txtLineInfo.Enabled = false;
tblLineInfo.Visible = true;
}
else
{
tblLineInfo.Visible = false;
}
ddlCode.SelectedValue = line_item.Code;
txtCodeComment.Text = line_item.CodeComments;
if (line_item.Code != "")
{
var drCode = dtCodeList.Select("Code = '" + line_item.Code + "'");
if (drCode.Length > 0)
{
lblCode.Text = drCode[0]["Code"].ToString();
}
}
ddlValid.SelectedValue = line_item.Valid.ToString();
//display Justification Value:
var justifications = Lookups.GetJustificationValues();
var justification = justifications.Where(j => j.Justification == line_item.JustificationCode);
if (justification.Any())
{
var firstJustification = justification.First();
if (firstJustification.InDefaultList)
{
rblJustification.SelectedValue = line_item.JustificationCode.ToString();
if (firstJustification.DisplayAddOnField)
{
lblJustificationExplanation.Text = (string)Utility.GetNotNullValue(firstJustification.AddOnDescription, "String");
txtAddJustification.Text = line_item.JustificationAddOn;
}
else
{
lblJustificationExplanation.AddVisibilityHidden();
txtAddJustification.AddVisibilityHidden();
lblJustAddInfo.AddVisibilityHidden();
}
txtJustOther.AddVisibilityHidden();
lblJustOther.AddVisibilityHidden();
}
else
{
rblJustification.SelectedValue = "6";
lblJustificationExplanation.AddVisibilityHidden();
txtAddJustification.AddVisibilityHidden();
txtJustOther.Text = (string)Utility.GetNotNullValue(firstJustification.JustificationDescription, "String");
}
}
else
{
lblJustificationExplanation.AddVisibilityHidden();
txtAddJustification.AddVisibilityHidden();
lblJustAddInfo.AddVisibilityHidden();
txtJustOther.AddVisibilityHidden();
lblJustOther.AddVisibilityHidden();
}
var sb = new StringBuilder();
sb.Append("<script type='text/javascript' >");
sb.Append("var original_selected_just = '");
sb.Append(rblJustification.SelectedValue);
sb.Append("';");
sb.Append("var original_add_on = '");
sb.Append(txtAddJustification.Text);
sb.Append("';");
sb.Append("</script>");
Page.RegisterStartupScript("orig_just", sb.ToString());
if (!EnableForUpdate)
{
txtRWA.Enabled = false;
txtComment.Enabled = false;
ddlValid.Enabled = false;
ddlCode.Enabled = false;
txtCodeComment.Enabled = false;
rblJustification.Enabled = false;
txtAddJustification.Enabled = false;
txtJustOther.Enabled = false;
}
else
{
//check if there are values for UDO & DO Should Be fields:
var str_msg = "";
if (lblCompletionDate.Text == "")
{
str_msg = str_msg + "Expected Completion Date.<br />";
}
if (lblUDOShouldBe.Text.Trim() == "$" || lblUDOShouldBe.Text.Trim().Length == 0)
{
str_msg = str_msg + "UDO Should Be.<br />";
}
if (lblDOShouldBe.Text.Trim() == "$" || lblDOShouldBe.Text.Trim().Length == 0)
{
str_msg = str_msg + "DO Should Be.<br />";
}
if (str_msg.Length > 0)
{
str_msg = "The following fields are required:<br />" + str_msg + "Please fill these fields before Line validation. <br/>";
lblMsgValidation.Visible = true;
lblMsgValidation.Text = str_msg;
ddlValid.Enabled = false;
ddlCode.Enabled = false;
txtCodeComment.Enabled = false;
rblJustification.Enabled = false;
txtAddJustification.Enabled = false;
txtJustOther.Enabled = false;
}
}
}
private void InitControlsByItem(int OItemID, string Lines, string ULOOrgCode, string PrevReviewer)
{
txtItemID.Value = OItemID.ToString();
if (Lines == "" || Lines == "0")
{
//init by item properties:
lblLines.Text = "all";
int reviewer_id;
if (PrevReviewer == "" || PrevReviewer == "0")
{
reviewer_id = 0;
}
else
{
reviewer_id = Int32.Parse(PrevReviewer);
}
var item = new OpenItem(OItemID, (new PageBase()).LoadID, ULOOrgCode, reviewer_id);
txtCurrentReviewer.Value = item.ReviewerUserID.ToString();
lblPrevReviewer.Text = item.Reviewer;
lblDocNumber.Text = item.DocNumber;
lblOrgCode.Text = item.ULOOrgCode;
InitAssignUsersList(OItemID, ULOOrgCode, 0);
}
else
{
//init by lines properties:
lblLines.Text = Lines;
var line_num = 0;
Int32.TryParse(Lines, out line_num);
if (line_num == 0)
{
//we have multiline selection:
lblDocNumber.Text = Request.QueryString["doc"];
var str_org = "";
var str_names = "";
var ds = Item.GetULOOrganizationsByItemLines(OItemID, Lines);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (str_org.IndexOf((string)dr["ULOOrgCode"]) == -1)
{
str_org = str_org + (string)dr["ULOOrgCode"] + ", ";
}
if (str_names.IndexOf((string)dr["ReviewerName"]) == -1)
{
str_names = str_names + (string)dr["ReviewerName"] + "<br/>";
}
}
lblOrgCode.Text = str_org.Substring(0, str_org.Length - 2);
lblPrevReviewer.Text = str_names;
InitAssignUsersList(OItemID, ULOOrgCode, 0);
}
else
{
//one line selected
var line = new LineNum(OItemID, line_num);
txtCurrentReviewer.Value = line.ReviewerUserID.ToString();
lblPrevReviewer.Text = line.Reviewer;
lblDocNumber.Text = line.DocNumber;
lblOrgCode.Text = line.ULOOrgCode;
InitAssignUsersList(OItemID, line.ULOOrgCode, 0);
}
}
//init with default settings:
InitUsersOrganizationsList("", 0);
}
private void InitControlsByItem(int OItemID, string Lines, string ULOOrgCode, string PrevReviewer)
{
txtItemID.Value = OItemID.ToString();
if (Lines == "" || Lines == "0")
{
//init by item properties:
lblLines.Text = "all";
int reviewer_id;
if (PrevReviewer == "" || PrevReviewer == "0")
{
reviewer_id = 0;
}
else
{
reviewer_id = Int32.Parse(PrevReviewer);
}
var item = new OpenItem(OItemID, (new PageBase()).LoadID, ULOOrgCode, reviewer_id);
txtPrevOrganization.Value = item.Organization + " : " + item.ULOOrgCode;
txtPrevReviewer.Value = item.ReviewerUserID.ToString();
lblDocNumber.Text = item.DocNumber;
lblPrevOrganization.Text = item.Organization;
lblPrevOrgCode.Text = item.ULOOrgCode;
lblPrevReviewerName.Text = item.Reviewer;
}
else
{
//init by lines properties:
lblLines.Text = Lines;
var line_num = 0;
Int32.TryParse(Lines, out line_num);
if (line_num == 0)
{
//we have multiline selection:
lblDocNumber.Text = Request.QueryString["doc"];
var str_org = "";
var str_names = "";
var ds = Item.GetULOOrganizationsByItemLines(OItemID, Lines);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (str_org.IndexOf((string)dr["Organization"]) == -1)
{
str_org = str_org + (string)dr["Organization"] + ", ";
}
if (str_names.IndexOf((string)dr["ReviewerName"]) == -1)
{
str_names = str_names + (string)dr["ReviewerName"] + "<br/>";
}
}
lblPrevOrganization.Text = str_org.Substring(0, str_org.Length - 2);
lblPrevOrgCode.Style.Add("display", "none");
lblPrevReviewerName.Text = str_names;
}
else
{
//one line selected
var line = new LineNum(OItemID, line_num);
txtPrevOrganization.Value = line.Organization + " : " + line.ULOOrgCode;
txtPrevReviewer.Value = line.ReviewerUserID.ToString();
lblDocNumber.Text = line.DocNumber;
lblPrevOrganization.Text = line.Organization;
lblPrevOrgCode.Text = line.ULOOrgCode;
lblPrevReviewerName.Text = line.Reviewer;
}
}
ctrlOrgUsers.OrganizationLabel = "Select Organization:";
ctrlOrgUsers.UsersLabel = "Select Reviewer:";
ctrlOrgUsers.InitLists();
}
override public String ToString()
{
return(Type.ToString() + ":\t" + Message + "\t@" + LineNum.ToString());
}
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();
}
