/// <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);
}
}
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);
}
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);
}
/// <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();
* }
*/
}
}
}
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;
}
}
}
/// <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>";
}
}
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();
}
}
}
/// <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 = "© 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));
}
}
}
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);
}
}
