/// <summary>
    /// submit the order
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        Affinity.Account account = this.GetAccount();
        // create a new order for this request
        Affinity.Order order = new Affinity.Order(this.phreezer);

        order.OriginatorId       = account.Id;
        order.CustomerStatusCode = Affinity.OrderStatus.PendingCode;
        order.InternalStatusCode = Affinity.OrderStatus.PendingCode;
        order.InternalId         = Affinity.Order.DefaultInternalId;

        order.ClientName       = txtClientName.Text;
        order.Pin              = txtPIN.Text;
        order.AdditionalPins   = txtAdditionalPins.Text;
        order.PropertyAddress  = txtPropertyAddress.Text;
        order.PropertyAddress2 = txtPropertyAddress2.Text;
        order.PropertyCity     = txtPropertyCity.Text;
        order.PropertyState    = txtPropertyState.Text;
        order.PropertyZip      = txtPropertyZip.Text;
        order.CustomerId       = txtCustomerId.Text;
        order.PropertyCounty   = txtPropertyCounty.Text;
        order.PropertyUse      = (radioResidential.Checked)? "Residential" : "Nonresidential";


        try
        {
            order.ClosingDate = DateTime.Parse(txtClosingDate.Text);
            bool isRefinance = radioRefinance.Checked;

            Affinity.Order PreviousOrder = order.GetPrevious();
            // verify the user has not submitted this PIN in the past
            if (PreviousOrder == null || isDupOrderWarnedHdn.Value.Equals("true"))
            {
                order.Insert();

                this.Redirect("MyRequestSubmit.aspx?new=true&id=" + order.Id + "&code=" + this.rtype.Code);
            }
            else
            {
                isDupOrderWarnedHdn.Value = "true";

                string AffinityIdMessage = "";

                if (!PreviousOrder.InternalId.Equals(""))
                {
                    AffinityIdMessage = " and Affinity ID: " + PreviousOrder.InternalId;
                }

                this.Master.ShowFeedback("You previously submitted order " + PreviousOrder.Id + " for a similar property (PIN " + order.Pin + AffinityIdMessage + ").  Please verify that this is not a duplicate order and click Continue... Otherwise click Cancel.", MasterPage.FeedbackType.Warning);
            }
        }
        catch (FormatException ex)
        {
            this.Master.ShowFeedback("Please check that the estimated closing date is valid and in the format 'mm/dd/yyyy'", MasterPage.FeedbackType.Error);
        }
        catch (Exception ex)
        {
            this.Master.ShowFeedback(ex.Message, MasterPage.FeedbackType.Error);
        }
    }
Beispiel #2
0
    public Affinity.WsResponse SyncRequest(Affinity.WsToken token, System.Xml.XmlDocument doc)
    {
        Affinity.WsResponse resp = new Affinity.WsResponse();

        Phreezer phreezer = new Phreezer(ConfigurationManager.ConnectionStrings["DBConn"].ConnectionString);

        try
        {
            Hashtable   ht     = new Hashtable();
            XmlNodeList fields = doc.GetElementsByTagName("field");

            // enumerate all the fields and convert to a hashtable
            foreach (XmlNode field in fields)
            {
                ht.Add(XmlForm.GetAttribute(field, "sp_id"), field.InnerText);
            }

            if (ht.ContainsKey("WEB_ID") == false || ht["WEB_ID"].Equals(""))
            {
                throw new Exception("WEB_ID is required");
            }

            if (ht.ContainsKey("AFF_ID") == false || ht["AFF_ID"].Equals(""))
            {
                throw new Exception("AFF_ID is required");
            }

            Affinity.Order order = new Affinity.Order(phreezer);
            order.Load(ht["WEB_ID"]);

            if (order.InternalId.Equals(""))
            {
                // the order doesn't have an AFF ID so this is a confirmation

                // we have to get the system settings to pass them in to the order confirm method
                Hashtable settings = (Hashtable)Application[Affinity.SystemSetting.DefaultCode];

                resp = order.Confirm(ht["AFF_ID"].ToString(), settings);
            }
            else
            {
                resp.IsSuccess      = true;
                resp.ActionWasTaken = false;
                resp.Message        = "No action was taken";
            }
        }
        catch (Exception ex)
        {
            resp.Message = ex.Message;
        }
        finally
        {
            phreezer.Close();
        }

        return(resp);
    }
Beispiel #3
0
    override protected void PageBase_Init(object sender, System.EventArgs e)
    {
        // we have to call the base first so phreezer is instantiated
        base.PageBase_Init(sender, e);

        int id = NoNull.GetInt(Request["id"], 0);

        this.order = new Affinity.Order(this.phreezer);
        this.order.Load(id);
    }
Beispiel #4
0
    /// <summary>
    /// The form controls are created at this point.  if we create them at page load
    /// then their viewstate will not be persisted.
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    override protected void PageBase_Init(object sender, System.EventArgs e)
    {
        // we have to call the base first so phreezer is instantiated
        base.PageBase_Init(sender, e);

        int id = NoNull.GetInt(Request["id"], 0);

        request = new Affinity.Request(this.phreezer);
        Affinity.Order order = new Affinity.Order(this.phreezer);
        order.Load(id);
        Affinity.RequestCriteria criteria = new Affinity.RequestCriteria();
        Affinity.Requests        reqs     = order.GetOrderRequests(criteria);
        Affinity.Request         req      = (Affinity.Request)reqs[0];
        this.request.Load(req.Id);
    }
    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("PropertyProfile", MasterPage.LayoutStyle.ContentOnly);
            if (Request["file"] != null)
            {
                string [] file = Request["file"].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 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);
                 */

                /*
                 * if(false)
                 * {
                 *      int len = contents.Length+50;
                 *      HttpContext.Current.Response.ContentType = "application/ms-excel";
                 *      HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment;filename=PropertyProfile.xls");
                 *      HttpContext.Current.Response.AppendHeader("Content-Length", len.ToString());
                 *
                 * HttpContext.Current.Response.Write(contents + "                                                  ");
                 *      HttpContext.Current.Response.Flush();
                 * }
                 */
            }
        }
    }
Beispiel #6
0
    protected void Page_Load(object sender, EventArgs e)
    {
        PageBase pb = (PageBase)this.Page;

        Affinity.Account acc = pb.GetAccount();
        this.Master.SetLayout("Process Order", MasterPage.LayoutStyle.ContentOnly);
        this.RequirePermission(Affinity.RolePermission.AdminSystem);

        this.btnClose.Attributes.Add("onclick", "return confirm('Mark this order as closed?');");

        if (!Page.IsPostBack)
        {
            // populate current requests grid
            Affinity.RequestCriteria rc = new Affinity.RequestCriteria();
            rc.AppendToOrderBy("Created", true);
            rGrid.DataSource = order.GetOrderRequests(rc);
            rGrid.DataBind();

            // show any attachments that go with this order
            Affinity.Attachments atts = order.GetAttachments();

            foreach (Affinity.Attachment att in atts)
            {
                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") + ") <a class=\"delete\" onclick=\"return confirm('Delete this attachment?');\" href=\"AdminAttachment.aspx?a=delete&id=" + att.Id + "\">Delete</a></div>"));
            }

            // populate the form

            btnReAssign.Visible = acc.Role.HasPermission(Affinity.RolePermission.AffinityManager);

            Affinity.OrderStatuss        codes = new Affinity.OrderStatuss(this.phreezer);
            Affinity.OrderStatusCriteria sc    = new Affinity.OrderStatusCriteria();
            sc.InternalExternal = 1;
            codes.Query(sc);

            /*
             * ddStatus.DataSource = codes;
             * ddStatus.DataTextField = "Description";
             * ddStatus.DataValueField = "Code";
             * ddStatus.SelectedValue = this.order.CustomerStatusCode;
             * ddStatus.DataBind();
             */
            lblStatus.Text = this.order.CustomerStatus.Description;

            txtId.Text               = "WEB-" + this.order.Id.ToString();
            txtInternalId.Text       = this.order.InternalId.ToString();
            txtInternalATSId.Text    = this.order.InternalATSId.ToString();
            txtCustomerId.Text       = this.order.CustomerId.ToString();
            txtPin.Text              = this.order.Pin.ToString();
            txtAdditionalPins.Text   = this.order.AdditionalPins.ToString();
            txtPropertyAddress.Text  = this.order.PropertyAddress.ToString();
            txtPropertyAddress2.Text = this.order.PropertyAddress2.ToString();
            txtPropertyCity.Text     = this.order.PropertyCity.ToString();
            txtPropertyState.Text    = this.order.PropertyState.ToString();
            txtPropertyZip.Text      = this.order.PropertyZip.ToString();
            txtPropertyCounty.Text   = this.order.PropertyCounty.ToString();
            //txtInternalStatusCode.Text = this.order.InternalStatusCode.ToString();
            //txtCustomerStatusCode.Text = this.order.CustomerStatusCode.ToString();
            txtOriginator.Text          = this.order.Account.FullName;
            txtCreated.Text             = this.order.Created.ToString("MM/dd/yyyy hh:mm tt");
            txtModified.Text            = this.order.Modified.ToString("MM/dd/yyyy hh:mm tt");
            txtClosingDate.Text         = this.order.ClosingDate.ToShortDateString();
            txtClientName.Text          = this.order.ClientName.ToString();
            radioResidential.Checked    = (this.order.PropertyUse.Equals("Residential"));
            radioNonResidential.Checked = (this.order.PropertyUse.Equals("Nonresidential"));

            if (txtInternalId.Text.Trim().Equals(""))
            {
                txtInternalId.Focus();
                txtInternalId.Text = "AFF-";
            }
            else if (txtInternalATSId.Text.Trim().Equals(""))
            {
                txtInternalATSId.Focus();
            }

            // the admin wants to see if there is a previous order from ANY user w/ the same PIN because
            // if the PIN was recently submitted, they may be able to use internal records and not have
            // to incur the expense of a full title search.
            Affinity.Order previousOrder = order.GetPrevious(false);

            // If there are any previous orders display a message to the admin
            if (previousOrder != null)
            {
                PreviousOrderNotice.InnerHtml = "This order has a potential duplicate submitted on " + previousOrder.Created.ToShortDateString() + " - order number <a href=\"AdminOrder.aspx?id=" + previousOrder.Id.ToString() + "\">" + previousOrder.Id.ToString() + "</a> " + previousOrder.InternalId.ToString();
                PreviousOrderNotice.Visible   = true;
            }
        }
    }
Beispiel #7
0
    /// <summary>
    /// submit the order
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void btnSubmit_Click(object sender, EventArgs e)
    {
        this.RequirePermission(Affinity.RolePermission.AffinityManager);

        if (!fuAttachment.HasFile)
        {
            pnlResults.Visible = true;
            pResults.InnerHtml = "<h3 style=\"color:red;\">No File Uploaded.  Please choose an Excel file to upload.<h3>";
        }
        else
        {
            int    accountidInt     = 0;
            string originalfilename = fuAttachment.FileName;
            string ext             = System.IO.Path.GetExtension(fuAttachment.FileName);
            string accountid       = ddNewOriginator.SelectedValue;
            string county          = txtPropertyCounty.Text;
            string transactiontype = ddTransactionType.SelectedValue;
            string tractsearch     = (TractSearch.Checked.Equals("True")? "Yes" : "No");

            int.TryParse(accountid, out accountidInt);

            // Get the next available Internal ID and then increment for each order
            int internalId = 0;

            using (MySqlDataReader reader = this.phreezer.ExecuteReader("select Max(REPLACE(REPLACE(o_internal_id, 'AFF_', ''), 'AFF', '')) as maxId from `order` where o_internal_id like 'AFF%'"))
            {
                if (reader.Read())
                {
                    string numStr = reader["maxId"].ToString();
                    int.TryParse(numStr, out internalId);
                    internalId++;
                }
            }

            string internalIdStr = internalId.ToString();
            string filename      = internalIdStr + ext;
            int    uploadidInt   = 0;

            using (MySqlDataReader reader = this.phreezer.ExecuteReader("insert into order_upload_log (oul_a_id, oul_original_filename, oul_filename, oul_starting_internal_id, oul_created, oul_modified) VALUES (" + this.GetAccount().Id.ToString() + ", '" + originalfilename + "', '" + filename + "', " + internalIdStr + ", '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "', '" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "'); SELECT @@IDENTITY as id;"))
            {
                if (reader.Read())
                {
                    int.TryParse(reader["id"].ToString(), out uploadidInt);
                }
            }

            SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
            string path     = Server.MapPath(".\\") + "XlsUploads\\";
            string filepath = path + filename;

            if (File.Exists(filepath))
            {
                File.Delete(filepath);
            }
            fuAttachment.SaveAs(filepath);

            ExcelFile xlsFile = new ExcelFile();

            if (ext.Equals(".xlsx"))
            {
                string zippath = path + internalIdStr + "\\";

                if (!Directory.Exists(zippath))
                {
                    Directory.CreateDirectory(zippath);
                }

                string zipfilepath = path + internalIdStr + ".zip";
                if (File.Exists(zipfilepath))
                {
                    File.Delete(zipfilepath);
                }
                File.Move(filepath, zipfilepath);
                Xceed.Zip.Licenser.LicenseKey = "ZIN20N4AFUNK71J44NA";
                string[] sarr = { "*" };


                Xceed.Zip.QuickZip.Unzip(zipfilepath, zippath, sarr);
                xlsFile.LoadXlsxFromDirectory(zippath, XlsxOptions.None);
            }
            else
            {
                xlsFile.LoadXls(path);
            }
            ExcelWorksheet ws = xlsFile.Worksheets[0];

            pnlResults.Visible = true;
            pnlForm.Visible    = false;
            btnSubmit.Visible  = false;
            btnCancel.Text     = "Back to Admin";
            ListDictionary duplicatePINs = new ListDictionary();


            string pin                 = " ";
            string address             = " ";
            string address1            = "";
            string address2            = "";
            string city                = "";
            string state               = "";
            string zip                 = "";
            string firmname            = "";
            string attorney            = "";
            string attorneyaddress1    = "";
            string attorneyaddress2    = "";
            string attorneycity        = "";
            string attorneystate       = "";
            string attorneyzip         = "";
            string attorneyphone       = "";
            string attorneyemail       = "";
            string attorneyattentionto = "";
            int    idx                 = 1;

            /****************************************************************************************
            *  GET ACCOUNT INFORMATION
            ****************************************************************************************/
            Affinity.Account account = new Affinity.Account(this.phreezer);

            account.Load(accountid);

            XmlDocument preferencesXML = new XmlDocument();
            preferencesXML.LoadXml(account.PreferencesXml);

            XmlNode node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantName']");
            if (node != null)
            {
                firmname = node.InnerText;
            }

            node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantAttorneyName']");
            if (node != null)
            {
                attorney = node.InnerText;
            }

            node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantAddress']");
            if (node != null)
            {
                attorneyaddress1 = node.InnerText;
            }

            node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantAddress2']");
            if (node != null)
            {
                attorneyaddress2 = node.InnerText;
            }

            node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantCity']");
            if (node != null)
            {
                attorneycity = node.InnerText;
            }

            node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantState']");
            if (node != null)
            {
                attorneystate = node.InnerText;
            }

            node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantZip']");
            if (node != null)
            {
                attorneyzip = node.InnerText;
            }

            node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantPhone']");
            if (node != null)
            {
                attorneyphone = node.InnerText;
            }

            node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantEmail']");
            if (node != null)
            {
                attorneyemail = node.InnerText;
            }

            node = preferencesXML.SelectSingleNode("//Field[@name='ApplicantAttentionTo']");
            if (node != null)
            {
                attorneyattentionto = node.InnerText;
            }

            string xml = "<response><field name=\"CommittmentDeadline\"></field><field name=\"PreviousTitleEvidence\"></field><field name=\"Prior\"></field><field name=\"TypeOfProperty\">Single Family</field><field name=\"PropertyUse\"></field><field name=\"TransactionType\">[TRANSACTIONTYPE]</field><field name=\"TractSearch\">[TRACTSEARCH]</field><field name=\"ShortSale\"></field><field name=\"Foreclosure\"></field><field name=\"CashSale\"></field><field name=\"ConstructionEscrow\"></field><field name=\"ReverseMortgage\"></field><field name=\"EndorsementEPA\"></field><field name=\"EndorsementLocation\"></field><field name=\"EndorsementCondo\"></field><field name=\"EndorsementComp\"></field><field name=\"EndorsementARM\"></field><field name=\"EndorsementPUD\"></field><field name=\"EndorsementBalloon\"></field><field name=\"EndorsementOther\"></field><field name=\"MortgageAmount\">1.00</field><field name=\"PurchasePrice\"></field><field name=\"TRID\">No</field><field name=\"LoanNumber\"></field><field name=\"SecondMortgage\">No</field><field name=\"SecondMortgageAmount\"></field><field name=\"LoanNumber2nd\"></field><field name=\"ChainOfTitle\">No</field><field name=\"Buyer\">" + (TractSearch.Checked.Equals("True")? "." : "") + "</field><field name=\"Buyer1Name2\"></field><field name=\"AddBuyer2\"></field><field name=\"Buyer2Name1\"></field><field name=\"Buyer2Name2\"></field><field name=\"AddBuyer3\"></field><field name=\"Buyer3Name1\"></field><field name=\"Buyer3Name2\"></field><field name=\"AddBuyer4\"></field><field name=\"Buyer4Name1\"></field><field name=\"Buyer4Name2\"></field><field name=\"AddBuyer5\"></field><field name=\"Buyer5Name1\"></field><field name=\"Buyer5Name2\"></field><field name=\"Seller\"></field><field name=\"Seller1Name2\"></field><field name=\"AddSeller2\"></field><field name=\"Seller2Name1\"></field><field name=\"Seller2Name2\"></field><field name=\"AddSeller3\"></field><field name=\"Seller3Name1\"></field><field name=\"Seller3Name2\"></field><field name=\"AddSeller4\"></field><field name=\"Seller4Name1\"></field><field name=\"Seller4Name2\"></field><field name=\"AddSeller5\"></field><field name=\"Seller5Name1\"></field><field name=\"Seller5Name2\"></field><field name=\"Underwriter\"></field><field name=\"ApplicantName\">[FIRMNAME]</field><field name=\"ApplicantAttorneyName\">[ATTORNEY]</field><field name=\"ApplicantAddress\">[ADDRESS1]</field><field name=\"ApplicantAddress2\">[ADDRESS1]</field><field name=\"ApplicantCity\">[CITY]</field><field name=\"ApplicantState\">[STATE]</field><field name=\"ApplicantZip\">[ZIP]</field><field name=\"ApplicantPhone\">[PHONE]</field><field name=\"ApplicantFax\"></field><field name=\"ApplicantEmail\">[EMAIL]</field><field name=\"ApplicantAttentionTo\">[ATTENTIONTO]</field><field name=\"CopyApplicationTo\"></field><field name=\"LenderName\"></field><field name=\"LenderContact\"></field><field name=\"LenderAddress\"></field><field name=\"LenderAddress2\"></field><field name=\"LenderCity\"></field><field name=\"LenderState\"></field><field name=\"LenderZip\"></field><field name=\"LenderPhone\"></field><field name=\"LenderFax\"></field><field name=\"LenderEmail\"></field><field name=\"BrokerName\"></field><field name=\"BrokerLoanOfficer\"></field><field name=\"BrokerAddress\"></field><field name=\"BrokerAddress2\"></field><field name=\"BrokerCity\"></field><field name=\"BrokerState\"></field><field name=\"BrokerZip\"></field><field name=\"BrokerPhone\"></field><field name=\"BrokerFax\"></field><field name=\"BrokerEmail\"></field><field name=\"Notes\"></field><field name=\"Source\">Web Order ID</field><field name=\"SubmittedDate\">[DATE]</field><field name=\"OrderRequestStatus\">Requested</field></response>".Replace("[TRANSACTIONTYPE]", transactiontype).Replace("[TRACTSEARCH]", tractsearch).Replace("[FIRMNAME]", firmname).Replace("[ATTORNEY]", attorney).Replace("[ADDRESS1]", attorneyaddress1).Replace("[ADDRESS2]", attorneyaddress2).Replace("[CITY]", attorneycity).Replace("[STATE]", attorneystate).Replace("[ZIP]", attorneyzip).Replace("[PHONE]", attorneyphone).Replace("[EMAIL]", attorneyemail).Replace("[ATTENTIONTO]", attorneyattentionto).Replace("[DATE]", DateTime.Now.ToString());

            /****************************************************************************************
            *  END GETTING ACCOUNT INFORMATION
            ****************************************************************************************/

            while (!pin.Equals("") && ws.Rows[idx] != null && ws.Rows[idx].Cells[1] != null && ws.Rows[idx].Cells[1].Value != null)
            {
                pin                 = ws.Rows[idx].Cells[1].Value.ToString();
                address             = ws.Rows[idx].Cells[3].Value.ToString();
                address1            = "";
                address2            = "";
                city                = "";
                state               = "";
                zip                 = "";
                firmname            = "";
                attorney            = "";
                attorneyaddress1    = "";
                attorneyaddress2    = "";
                attorneycity        = "";
                attorneystate       = "";
                attorneyzip         = "";
                attorneyphone       = "";
                attorneyemail       = "";
                attorneyattentionto = "";

                if (!address.Equals(""))
                {
                    XmlDocument doc = new XmlDocument();
                    string      url = "http://maps.googleapis.com/maps/api/geocode/xml?address=" + address + "&key=";

                    System.Net.HttpWebRequest req = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(url);
                    req.Method    = "GET";
                    req.Accept    = "text/xml";
                    req.KeepAlive = false;

                    System.Net.HttpWebResponse response = null;

                    using (response = (System.Net.HttpWebResponse)req.GetResponse()) //attempt to get the response.
                    {
                        using (Stream RespStrm = response.GetResponseStream())
                        {
                            doc.Load(RespStrm);
                        }
                    }

                    XmlNode streetnumbernode = doc.SelectSingleNode("/GeocodeResponse/result/address_component[type='street_number']");
                    if (streetnumbernode != null)
                    {
                        address1 += streetnumbernode.SelectSingleNode("long_name").InnerText;
                    }

                    XmlNode routenode = doc.SelectSingleNode("/GeocodeResponse/result/address_component[type='route']");
                    if (routenode != null)
                    {
                        address1 += " " + routenode.SelectSingleNode("long_name").InnerText;
                    }

                    XmlNode citynode = doc.SelectSingleNode("/GeocodeResponse/result/address_component[type='locality']");
                    if (citynode != null)
                    {
                        city = citynode.SelectSingleNode("long_name").InnerText;
                    }

                    if (county.Equals(""))
                    {
                        XmlNode countynode = doc.SelectSingleNode("/GeocodeResponse/result/address_component[type='administrative_area_level_2']");
                        if (countynode != null)
                        {
                            county = countynode.SelectSingleNode("long_name").InnerText;
                        }
                    }

                    XmlNode statenode = doc.SelectSingleNode("/GeocodeResponse/result/address_component[type='administrative_area_level_1']");
                    if (statenode != null)
                    {
                        state = statenode.SelectSingleNode("short_name").InnerText;
                    }

                    XmlNode zipnode = doc.SelectSingleNode("/GeocodeResponse/result/address_component[type='postal_code']");
                    if (zipnode != null)
                    {
                        zip = zipnode.SelectSingleNode("long_name").InnerText;
                    }

                    //Response.Write(idx.ToString() + " - " + pin + " - " + address1 + " - " + city + " - " + state + " - " + zip + " - " + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "<br/>");

                    // create a new order for this request
                    Affinity.Order order = new Affinity.Order(this.phreezer);

                    order.OriginatorId       = accountidInt;
                    order.CustomerStatusCode = Affinity.OrderStatus.ReadyCode;
                    order.InternalStatusCode = Affinity.OrderStatus.ReadyCode;
                    order.InternalId         = "";

                    order.ClientName       = "";
                    order.Pin              = pin;
                    order.AdditionalPins   = "";
                    order.PropertyAddress  = address1;
                    order.PropertyAddress2 = address2;
                    order.PropertyCity     = city;
                    order.PropertyState    = state;
                    order.PropertyZip      = zip;
                    order.CustomerId       = pin;
                    order.PropertyCounty   = county;
                    order.PropertyUse      = "Residential";
                    order.OrderUploadLogId = uploadidInt;

                    try
                    {
                        Affinity.Order PreviousOrder = order.GetPrevious();
                        // verify the user has not submitted this PIN in the past
                        if (PreviousOrder == null)
                        {
                            order.Insert();
                            internalId++;

                            Affinity.Request rq = new Affinity.Request(this.phreezer);
                            rq.OrderId         = order.Id;
                            rq.OriginatorId    = accountidInt;
                            rq.RequestTypeCode = "Refinance";
                            rq.StatusCode      = Affinity.RequestStatus.DefaultCode;

                            rq.Xml = xml;

                            rq.Insert();
                        }
                        else
                        {
                            duplicatePINs.Add(pin, "");
                        }
                    }
                    catch (FormatException ex)
                    {
                        this.Master.ShowFeedback("Please check that the estimated closing date is valid and in the format 'mm/dd/yyyy'", MasterPage.FeedbackType.Error);
                    }
                }

                idx++;
            }
            pnlResults.Visible = true;
            pResults.InnerHtml = "<h1 style=\"color:black;\">" + (idx - duplicatePINs.Count).ToString() + " orders have been imported. " + duplicatePINs.Count.ToString() + " records failed.</h1>";
        }
    }
Beispiel #8
0
    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;
    }
Beispiel #9
0
    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();
            }
        }
    }
Beispiel #10
0
    /// <summary>
    /// The form controls are created at this point.  if we create them at page load
    /// then their viewstate will not be persisted.
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    override protected void PageBase_Init(object sender, System.EventArgs e)
    {
        bool isRefinance = (Request["Refinance"] != null && Request["Refinance"].Equals("True"));

        // we have to call the base first so phreezer is instantiated
        base.PageBase_Init(sender, e);

        int orderId = NoNull.GetInt(Request["id"], 0);

        string requestCode = NoNull.GetString(Request["code"], Affinity.RequestType.DefaultCode);


        this.order = new Affinity.Order(this.phreezer);
        order.Load(orderId);

        // make sure this user has permission to make updates to this order
        if (!order.CanUpdate(this.GetAccount()))
        {
            this.Crash(300, "Permission denied.");
        }

        this.rtype = new Affinity.RequestType(this.phreezer);
        rtype.Load(requestCode);

        this.xmlForm = new XmlForm(this.order.Account);

        this.changeId = NoNull.GetInt(Request["change"], 0);
        this.isChange = (!changeId.Equals(0));

        if (this.rtype.Code.Equals("ClerkingRequest"))
        {
            ContentFooterSpan.InnerHtml = "&copy; Copyright <%=DateTime.Now.Year.ToString() %>, Advocate Title Services, LLC";
        }

        string busindxml = "<field name=\"BusinessLicenseID\">" + this.GetAccount().BusinessLicenseID + "</field>" + "<field name=\"IndividualLicenseID\">" + this.GetAccount().IndividualLicenseID + "</field>";

        if (this.isChange)
        {
            // create a form for a change request
            Affinity.Request req = new Affinity.Request(this.phreezer);
            req.Load(changeId);
            pnlForm.Controls.Add(this.xmlForm.GetFormFieldControl(rtype.Definition, req.Xml.Replace("</response>", "") + busindxml + "</response>"));

            this.btnCancelChange.Visible = true;
            this.btnChange.Visible       = true;
            this.btnCancelSubmit.Visible = false;
            this.btnSubmit.Visible       = false;
        }
        else if (rtype.Code == Affinity.RequestType.DefaultChangeCode)
        {
            // this is a change to the main order, we store this as a request as well
            // but we treat it a little bit differently
            string resXml = XmlForm.XmlToString(order.GetResponse());
            pnlForm.Controls.Add(this.xmlForm.GetFormFieldControl(rtype.Definition, resXml.Replace("</response>", "") + busindxml + "</response>"));

            this.btnCancelChange.Visible = true;
            this.btnChange.Visible       = true;
            this.btnCancelSubmit.Visible = false;
            this.btnSubmit.Visible       = false;
        }
        else
        {
            // create a form for a new request
            //string reqXml = XmlForm.XmlToString(order.GetResponse());
            string reqXml = this.GetAccount().PreferencesXml;

            if (this.rtype.Code.Equals("ClerkingRequest"))
            {
                Affinity.RequestCriteria rc = new Affinity.RequestCriteria();
                rc.RequestTypeCode = "Order";
                Affinity.Requests reqs = order.GetOrderRequests(rc);

                if (reqs.Count > 0)
                {
                    Affinity.Request r = (Affinity.Request)reqs[reqs.Count - 1];


                    //log.Debug(r.Xml);
                    reqXml = reqXml.Replace("</response>", "") + busindxml +
                             XmlForm.XmlToString(order.GetResponse()).Replace("<response>", "").Replace("</response>", "") +
                             r.Xml.Replace("<response>", "");
                    pnlForm.Controls.Add(this.xmlForm.GetFormFieldControl(rtype.Definition, reqXml));
                }
                else
                {
                    reqXml = reqXml.Replace("</response>", "") + busindxml +
                             XmlForm.XmlToString(order.GetResponse()).Replace("<response>", "").Replace("</response>", "");
                    pnlForm.Controls.Add(this.xmlForm.GetFormFieldControl(rtype.Definition, XmlForm.XmlToString(order.GetResponse())));
                }
            }
            else
            {
                pnlForm.Controls.Add(this.xmlForm.GetFormFieldControl(rtype.Definition, reqXml));
            }
        }
    }
Beispiel #11
0
    protected void Page_Load(object sender, EventArgs e)
    {
        this.RequirePermission(Affinity.RolePermission.SubmitOrders);
        string id           = NoNull.GetString(Request["id"]);
        string keyAttribute = NoNull.GetString(Request["key"], "sp_id");
        string format       = NoNull.GetString(Request["format"], "hash");
        string exportformat = "PFT";

        if (!format.Equals("entire"))
        {
            Affinity.Request r = new Affinity.Request(this.phreezer);
            r.Load(id);

            // make sure this user has permission to make updates to this order
            if (!r.Order.CanRead(this.GetAccount()))
            {
                this.Crash(300, "Permission denied.");
            }

            IBaseRenderer renderer = null;

            // depending on the format requested, get the correct renderer object
            switch (format)
            {
            case "entire":
                break;

            case "xml":
                exportformat = "Generic XML";
                renderer     = new XmlRenderer(r, this.GetSystemSettings());
                break;

            case "rei":
                exportformat = "REI XML";
                renderer     = new XmlREIRenderer(r, this.GetSystemSettings());
                break;

            case "change":
                exportformat = "PFT (Changes Only)";
                renderer     = new PFTChangeRenderer(r, this.GetSystemSettings());
                break;

            case "TPS":
                exportformat = "TPS";
                renderer     = new TPSServicePFTRenderer(r, this.GetSystemSettings());
                break;

            //case "special":
            //	renderer = new XmlSpecialRenderer(r, this.GetSystemSettings());
            //	break;
            default:
                renderer = new PFTRenderer(r, this.GetSystemSettings());
                break;
            }

            Affinity.ExportLog exportlog = new Affinity.ExportLog(this.phreezer);
            Affinity.Account   account   = this.GetAccount();
            exportlog.AccountID    = account.Id;
            exportlog.OrderID      = r.OrderId;
            exportlog.RequestID    = r.Id;
            exportlog.ExportFormat = exportformat;
            exportlog.Insert();

            // output the results of the renderer
            OutputRenderer(renderer, keyAttribute);
        }
        else
        {
            Affinity.RequestTypes        rts = new Affinity.RequestTypes(this.phreezer);
            Affinity.RequestTypeCriteria rtc = new Affinity.RequestTypeCriteria();
            rtc.IsActive = 1;
            rts.Query(rtc);
            Object [] renderers = new Object[rts.Count];

            IEnumerator      i = rts.GetEnumerator();
            int              j = 0;
            bool             isClerkingServices = false;
            Affinity.Account account            = this.GetAccount();
            exportformat = "Entire Order";

            while (i.MoveNext())
            {
                Affinity.RequestType rt    = (Affinity.RequestType)i.Current;
                Affinity.Order       order = new Affinity.Order(this.phreezer);
                order.Load(id);

                Affinity.RequestCriteria rc = new Affinity.RequestCriteria();
                rc.RequestTypeCode = rt.Code;
                order.GetOrderRequests(rc);

                Affinity.Requests reqs = order.GetOrderRequests(rc);
                Affinity.Request  r    = null;

                if (reqs.Count > 0)
                {
                    r = (Affinity.Request)reqs[0];

                    if (rt.Code.Equals("ClerkingRequest"))
                    {
                        isClerkingServices = true;
                    }
                    IBaseRenderer renderer = new PFTRenderer(r, this.GetSystemSettings());

                    renderers[j] = renderer;

                    j++;
                }

                if (r != null)
                {
                    Affinity.ExportLog exportlog = new Affinity.ExportLog(this.phreezer);
                    exportlog.AccountID    = account.Id;
                    exportlog.OrderID      = r.OrderId;
                    exportlog.RequestID    = r.Id;
                    exportlog.ExportFormat = exportformat;
                    exportlog.Insert();
                }
            }

            OutputMultiRenderer(renderers, keyAttribute, isClerkingServices);
        }
    }