protected void Page_Load(object sender, EventArgs e) { this.RequirePermission(Affinity.RolePermission.SubmitOrders); this.Master.SetLayout("Order Details", MasterPage.LayoutStyle.ContentOnly); string id = NoNull.GetString(Request["id"]); // this is used to track if a property changes was submitted int changeId = 0; Affinity.Order order = new Affinity.Order(this.phreezer); order.Load(id); // make sure this user has permission to make updates to this order if (!order.CanRead(this.GetAccount())) { this.Crash(300, "Permission denied."); } //order.CustomerStatusCode //order.InternalStatusCode lblWorkingId.Text = order.WorkingId; txtCustomerId.Text = order.CustomerId; txtClientName.Text = order.ClientName; txtPIN.Text = order.Pin; txtAdditionalPins.Text = order.AdditionalPins; txtPropertyAddress.Text = order.PropertyAddress; txtPropertyAddress2.Text = order.PropertyAddress2; txtPropertyCity.Text = order.PropertyCity; txtPropertyState.Text = order.PropertyState; txtPropertyZip.Text = order.PropertyZip; txtCustomerId.Text = order.CustomerId; txtPropertyCounty.Text = order.PropertyCounty; txtClosingDate.Text = order.ClosingDate.ToShortDateString(); // show any attachments that go with this order Affinity.Attachments atts = new Affinity.Attachments(this.phreezer); Affinity.AttachmentCriteria attc = new Affinity.AttachmentCriteria(); attc.OrderId = order.Id; atts.Query(attc); // see if the user has access to the attachment Affinity.AttachmentRole ardao = new Affinity.AttachmentRole(this.phreezer); Affinity.AttachmentRolesCriteria arcrit = new Affinity.AttachmentRolesCriteria(); arcrit.RoleCode = this.GetAccount().RoleCode; foreach (Affinity.Attachment att in atts) { arcrit.AttachmentPurposeCode = att.AttachmentPurpose.Code; Affinity.AttachmentRoles aroles = ardao.GetAttachmentRoles(arcrit); // if the user has permission to view this attachment if (aroles.Count > 0 || this.GetAccount().Id == order.OriginatorId) { pnlAttachments.Controls.Add(new LiteralControl("<div><a class=\"attachment\" href=\"MyAttachment.aspx?id=" + att.Id + "\">" + att.Name + "</a> (" + att.Created.ToString("M/dd/yyyy hh:mm tt") + ")</div>")); } } // show the entire order history Affinity.RequestCriteria rc = new Affinity.RequestCriteria(); rc.AppendToOrderBy("Created", true); rGrid.DataSource = order.GetOrderRequests(rc); rGrid.DataBind(); // show the available actions that can be done with this order Affinity.RequestTypes rts = order.GetAvailableRequestTypes(); pnlActions.Controls.Add(new LiteralControl("<div class=\"actions\">")); foreach (Affinity.RequestType rt in rts) { pnlActions.Controls.Add(new LiteralControl("<div><a class=\"add\" href=\"MyRequestSubmit.aspx?id=" + order.Id + "&code=" + rt.Code + "\">Add a " + rt.Description + " to this Order</a></div>")); } pnlActions.Controls.Add(new LiteralControl("<div><a class=\"add\" href=\"documents.aspx?id=" + order.Id + "\">Closing Document Manager – Forms</a></div>")); pnlActions.Controls.Add(new LiteralControl("</div>")); // show the details for the active requests Affinity.Requests rs = order.GetCurrentRequests(); foreach (Affinity.Request r in rs) { // we don't want to show changes to the property information if (r.RequestType.Code != Affinity.RequestType.DefaultChangeCode) { XmlForm xf = new XmlForm(this.GetAccount()); //Hashtable labels = xf.GetLabelHashtable(r.RequestType.Definition); Hashtable responses = XmlForm.GetResponseHashtable(r.Xml); pnlRequests.Controls.Add(new LiteralControl("<div class=\"groupheader\">" + r.RequestType.Description + " [<a href=\"MyRequestSubmit.aspx?change=" + r.Id + "&id=" + order.Id + "&code=" + r.RequestType.Code + "\">Edit</a>]" + "</div>")); pnlRequests.Controls.Add(new LiteralControl("<fieldset class=\"history\">")); // add the basic info pnlRequests.Controls.Add(NewLine("Request Status", r.RequestStatus.Description)); pnlRequests.Controls.Add(NewLine("Notes", r.Note)); pnlRequests.Controls.Add(NewLine("Submitted", r.Created.ToString("MM/dd/yyyy hh:mm tt"))); ArrayList keys = new ArrayList(responses.Keys); keys.Sort(); foreach (string key in keys) { // we check for fields ending with "_validator" due to a bug with order prior to 03/13/07 // if (responses[key].ToString().Equals("") == false) if (responses[key].ToString().Equals("") == false && key.EndsWith("_validator") == false) { //pnlRequests.Controls.Add(new LiteralControl("<div>" + labels[key].ToString() + ": " + responses[key].ToString() + "</div>")); pnlRequests.Controls.Add(NewLine(key, responses[key])); } } pnlRequests.Controls.Add(new LiteralControl("</fieldset>")); } else { changeId = r.Id; } } lnkChange.NavigateUrl = "MyRequestSubmit.aspx?id=" + order.Id + "&change=" + changeId + "&code=" + Affinity.RequestType.DefaultChangeCode; }
protected void Page_Load(object sender, EventArgs e) { /* * // get stack trace * System.Diagnostics.StackFrame fr = new System.Diagnostics.StackFrame(1, true); * System.Diagnostics.StackTrace st = new System.Diagnostics.StackTrace(fr); * Response.Write( "method = " + fr.GetMethod().Name + " trace = " + st.ToString() ); */ // we have to call the base first so phreezer is instantiated base.PageBase_Init(sender, e); PageBase pb = (PageBase)this.Page; Affinity.Account acc = pb.GetAccount(); string contents = ""; int id = NoNull.GetInt(Request["id"], 0); //Response.Write(Request["file"]); //Response.End(); if (id > 0) { Affinity.Order order = new Affinity.Order(this.phreezer); order.Load(id); int filecount = 0; this.Master.SetLayout("Documents", MasterPage.LayoutStyle.ContentOnly); if (Request["file"] != null) { string [] file = Request["file"].Split(','); string [] MailAddress = "".Split(','); if (Request["MailAddress"] != null) { MailAddress = Request["MailAddress"].Split(','); } for (int i = 0; i < file.Length; i++) { if ((file[i].Equals("WD") || file[i].Equals("WD_S") || file[i].Equals("WD_JT") || file[i].Equals("WD_TE")) && Request["warrantyfile"] == null) { continue; } string path = HttpContext.Current.Server.MapPath(".") + "\\downloads\\" + file[i] + ".xml"; if (File.Exists(path)) { filecount++; } } //Response.Write(path); string header = ""; string footer = ""; using (FileStream fs = new FileStream(HttpContext.Current.Server.MapPath(".") + "\\downloads\\header.xml", FileMode.OpenOrCreate, FileAccess.ReadWrite)) { using (StreamReader sr = new StreamReader(fs)) { header = sr.ReadToEnd() + "\n"; } } using (FileStream fs = new FileStream(HttpContext.Current.Server.MapPath(".") + "\\downloads\\footer.xml", FileMode.OpenOrCreate, FileAccess.ReadWrite)) { using (StreamReader sr = new StreamReader(fs)) { footer = sr.ReadToEnd() + "\n"; } } contents = header; for (int i = 0; i < file.Length; i++) { if ((file[i].Equals("WD") || file[i].Equals("WD_S") || file[i].Equals("WD_JT") || file[i].Equals("WD_TE")) && Request["warrantyfile"] == null) { continue; } string path = HttpContext.Current.Server.MapPath(".") + "\\downloads\\" + file[i] + ".xml"; if (File.Exists(path)) { using (FileStream fs = new FileStream(path, FileMode.OpenOrCreate, FileAccess.ReadWrite)) { using (StreamReader sr = new StreamReader(fs)) { contents += sr.ReadToEnd(); if ((i + 1) < filecount) { contents += "\n\n\n<w:p w:rsidR=\"00F4055C\" w:rsidRDefault=\"00F4055C\"/><w:p w:rsidR=\"005D7E36\" w:rsidRDefault=\"005D7E36\"><w:r><w:br w:type=\"page\"/></w:r></w:p><w:p w:rsidR=\"005D7E36\" w:rsidRDefault=\"005D7E36\"><w:bookmarkStart w:id=\"0\" w:name=\"_GoBack\"/><w:bookmarkEnd w:id=\"0\"/></w:p>"; } } } } } contents += footer; //Response.Write(contents); //Response.End(); string County = ""; string CommittmentDate = ""; string Grantee = ""; string Grantor = ""; string Grantee2 = ""; string Grantor2 = ""; DateTime DeedDate = order.ClosingDate; string ContractDate = ""; string BuyersName = ""; string SellersName = ""; string SellersAddress = ""; string BuyersAddress = ""; string GrantorAddressLine1 = ""; string GrantorAddressLine2 = ""; string GrantorCity = ""; string GrantorState = ""; string GrantorZip = ""; string GrantorCounty = ""; DateTime now = DateTime.Now; string DateDay = Ordinal(now.Day).ToString(); string DateMonth = now.ToString("MMMM"); string DateYear = now.ToString("yyyy"); string PIN = ""; string SellersAttorney = ""; string SellersAttorneyAddress = ""; int day = DeedDate.Day; string DeedDateOrdinal = day.ToString(); if (day == 11 || day == 12 || day == 13) { DeedDateOrdinal += "th"; } else { switch (day % 10) { case 1: DeedDateOrdinal += "st"; break; case 2: DeedDateOrdinal += "nd"; break; case 3: DeedDateOrdinal += "rd"; break; default: DeedDateOrdinal += "th"; break; } } //Response.Write(request.Xml); //Response.End(); try { XmlDocument doc = new XmlDocument(); // show the details for the active requests Affinity.Requests rs = order.GetCurrentRequests(); foreach (Affinity.Request r in rs) { if (r.IsCurrent) { doc.LoadXml(r.Xml); //Response.Write(r.Xml); //Response.End(); XmlNode node = doc.SelectSingleNode("//response/field[@name = 'CommittmentDeadline']"); if (node != null) { CommittmentDate = XMLEscape(node.InnerText.Replace("T:00:00:00", "")); } node = doc.SelectSingleNode("//response/field[@name = 'Seller']"); if (node != null) { SellersName = XMLEscape(node.InnerText); } Grantor = SellersName; node = doc.SelectSingleNode("//response/field[@name = 'Seller1Name2']"); if (node != null) { Grantor2 = " and " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'Buyer']"); if (node != null) { BuyersName = XMLEscape(node.InnerText); } Grantee = BuyersName; node = doc.SelectSingleNode("//response/field[@name = 'Buyer1Name2']"); if (node != null) { Grantee2 = " and " + XMLEscape(node.InnerText); BuyersName += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'Buyer2Name1']"); if (node != null) { BuyersName += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'Buyer2Name2']"); if (node != null) { BuyersName += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'Buyer3Name1']"); if (node != null) { BuyersName += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'Buyer3Name2']"); if (node != null) { BuyersName += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'Buyer4Name1']"); if (node != null) { BuyersName += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'Buyer4Name2']"); if (node != null) { BuyersName += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'Buyer5Name1']"); if (node != null) { BuyersName += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'Buyer5Name2']"); if (node != null) { BuyersName += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'ApplicantAddress']"); if (node != null) { BuyersAddress = XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'ApplicantAddress2']"); if (node != null) { BuyersAddress += " " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'ApplicantCity']"); if (node != null) { BuyersAddress += " " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'ApplicantState']"); if (node != null) { BuyersAddress += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'ApplicantZip']"); if (node != null) { BuyersAddress += " " + XMLEscape(node.InnerText); } BuyersAddress = BuyersAddress.Trim(); node = doc.SelectSingleNode("//response/field[@name = 'SellersAttorneyName']"); if (node != null) { SellersAttorney = XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'SellersAttorneyAddress']"); if (node != null) { SellersAttorneyAddress = XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'SellersAttorneyAddress2']"); if (node != null) { SellersAttorneyAddress += " " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'SellersAttorneyCity']"); if (node != null) { SellersAttorneyAddress += " " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'SellersAttorneyState']"); if (node != null) { SellersAttorneyAddress += ", " + XMLEscape(node.InnerText); } node = doc.SelectSingleNode("//response/field[@name = 'SellersAttorneyZip']"); if (node != null) { SellersAttorneyAddress += " " + XMLEscape(node.InnerText); } GrantorAddressLine1 = XMLEscape(order.PropertyAddress); GrantorAddressLine2 = XMLEscape(order.PropertyAddress2); GrantorCity = XMLEscape(order.PropertyCity); GrantorState = XMLEscape(order.PropertyState); GrantorZip = XMLEscape(order.PropertyZip); GrantorCounty = XMLEscape(order.PropertyCounty); SellersAddress = GrantorAddressLine1 + " " + GrantorAddressLine2 + " " + GrantorCity + ", " + GrantorState + " " + GrantorZip; ContractDate = XMLEscape(order.ClosingDate.ToString()).Replace(" 12:00:00 AM", ""); County = order.PropertyCounty; PIN = order.Pin; } } } catch (Exception err) {} contents = contents.Replace("[COUNTY]", County).Replace("[GRANTOR]", Grantor).Replace("[GRANTOR2]", Grantor2).Replace("[GRANTORCITY]", GrantorCity).Replace("[GRANTORCOUNTY]", GrantorCounty).Replace("[GRANTORADDRESSLINE1]", GrantorAddressLine1).Replace("[GRANTORADDRESSLINE2]", GrantorAddressLine2).Replace("[GRANTEE]", Grantee).Replace("[GRANTEE2]", Grantee2).Replace("[DEEDDATE]", DeedDate.ToString("MM/dd/yyyy")).Replace("[DEEDMONTH]", DeedDate.ToString("MMMM")).Replace("[DEEDYEAR]", DeedDate.ToString("yyyy")).Replace("[DEEDDAY]", DeedDateOrdinal).Replace("[CONTRACTDATE]", ContractDate).Replace("[BUYERSNAME]", BuyersName).Replace("[BUYERSADDRESS]", BuyersAddress).Replace("[SELLERSNAME]", SellersName).Replace("[SELLERSADDRESS]", SellersAddress).Replace("[COMMITMENTDATE]", CommittmentDate).Replace("[DATEDAY]", DateDay).Replace("[DATEMONTH]", DateMonth).Replace("[DATEYEAR]", DateYear).Replace("[PIN]", PIN).Replace("[SELLERSATTORNEY]", SellersAttorney).Replace("[SELLERSATTORNEYADDRESS]", SellersAttorneyAddress); contents = contents.Replace("[MAILTONAME]", ""); contents = contents.Replace("[MAILTOADDRESS1]", ""); contents = contents.Replace("[MAILTOADDRESS2]", ""); contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type month]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type year]\" </w:instrText>", ""); if (!County.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type in county]\" </w:instrText>", ""); } if (!CommittmentDate.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type in commitment date]\" </w:instrText>", ""); } if (!Grantee.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantee's name]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantees' names]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantee's name]\" </w:instrText>", ""); } if (!Grantor.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantor's name]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantors' names]\" </w:instrText>", ""); } if (!GrantorAddressLine1.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantor's address line 1]\" </w:instrText>", ""); } if (!GrantorAddressLine1.Equals("") || !GrantorAddressLine2.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantor's address line 2]\" </w:instrText>", ""); } if (!GrantorCity.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantors' town]\" </w:instrText>", ""); } if (!GrantorCounty.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantors’s County]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type county]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type in County}\" </w:instrText>", ""); } if (!DeedDate.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type in date of deed]\" </w:instrText>", ""); contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type month of deed]\" </w:instrText>", ""); contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type date of deed]\" </w:instrText>", ""); contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type month of deed]\" </w:instrText>", ""); contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type year of deed]\" </w:instrText>", ""); } if (!ContractDate.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type contract date]\" </w:instrText>", ""); } if (!SellersName.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type sellers' names]\" </w:instrText>", ""); } if (!BuyersName.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type buyers' name]\" </w:instrText>", ""); } if (!BuyersAddress.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type buyers' address]\" </w:instrText>", ""); } if (!SellersAddress.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type sellers' address]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesInDoc \"[Click and type property address]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantee's address]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type property address]\" </w:instrText>", "").Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type grantees' address]\" </w:instrText>", ""); } if (!PIN.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type PIN]\" </w:instrText>", ""); } if (!SellersAttorney.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type Attorney's Name]\" </w:instrText>", ""); } if (!SellersAttorneyAddress.Equals("")) { contents = contents.Replace("<w:instrText xml:space=\"preserve\"> MACROBUTTON AcceptAllChangesShown \"[Click here and type Attorney's Address]\" </w:instrText>", ""); } /* * string fileNameXML = HttpContext.Current.Server.MapPath(".") + "\\downloads\\Disclosure_Agent.doc"; * string FileName = HttpContext.Current.Server.MapPath(".") + "\\downloads\\tested.xml"; * * Document dc = new Document(); * dc.LoadFromFile(fileNameXML, FileFormat.Doc); * dc.SaveToFile(FileName, FileFormat.Xml); * //dc.SaveToStream(HttpContext.Current.Response.OutputStream, FileFormat.Xml); */ int len = contents.Length + 50; HttpContext.Current.Response.ContentType = "application/ms-word"; HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=ATS.doc"); HttpContext.Current.Response.AppendHeader("Content-Length", len.ToString()); HttpContext.Current.Response.Write(contents + " "); HttpContext.Current.Response.Flush(); } } }