<%@ Page Language="C#" AutoEventWireup="true" Inherits="Tessitura.WebAPI.Controls.ConfirmationEmailPage" EnableViewState="false" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="Tessitura" %>
<%@ Import Namespace="System.Xml" %>
<%@ Import Namespace="System.Web.Mail" %>
<%
    uxDelivery.Address = OrderData.DeliveryAddress;
    uxBilling.Address = OrderData.BillingAddress;
%>
<% 
     MailMessage objMail = new MailMessage();
     objMail.From = "patronservices@mccarter.org";
     objMail.To =   "jballinger@mccarter.org";
     objMail.Subject = "Response from website";
     objMail.Body = "Hiya";
     SmtpMail.SmtpServer = "192.9.200.137"; 
     SmtpMail.Send(objMail);
     
    
    
    if (OrderData.Custom.Custom2.Length > 0)
    {
        Subject = OrderData.Custom.Custom2;
    }
    else
    {
        Subject = "McCarter Theatre Order Confirmation";
    }

    Tessitura.WebAPI.Tessitura tess = new Tessitura.WebAPI.Tessitura();
    string sessionkey = tess.GetNewSessionKey("");
    string lsal = "";
    
   
    DataSet ds = tess.ExecuteLocalProcedure(sessionkey, 1, "@ORDER_NO=" + OrderData.OrderNumber);

    for (int i = 0; i < ds.Tables[0].Rows.Count; ++i)
    {
        string superPkgNo = ds.Tables[0].Rows[i]["super_pkg_no"].ToString();
        string superPkgDesc = ds.Tables[0].Rows[i]["description"].ToString();
        string totPurAmt = ds.Tables[0].Rows[i]["tot_pur_amt"].ToString();
        string totRetAmt = ds.Tables[0].Rows[i]["tot_ret_amt"].ToString();
        string numPur = ds.Tables[0].Rows[i]["num_seats_pur"].ToString();
        string numRet = ds.Tables[0].Rows[i]["num_seats_ret"].ToString();
        string li_seq_no = ds.Tables[0].Rows[i]["li_seq_no"].ToString();

        XmlNode xm = OrderData.CartDocument.SelectSingleNode("//LineItem[li_seq_no=" + li_seq_no + "]");

        if (xm != null)
        {

            XmlElement xePkgNo = OrderData.CartDocument.CreateElement("super_pkg_no");
            xePkgNo.InnerText = superPkgNo;

            XmlElement xePkgDesc = OrderData.CartDocument.CreateElement("super_pkg_desc");
            xePkgDesc.InnerText = superPkgDesc;

            XmlElement xeTotPurAmt = OrderData.CartDocument.CreateElement("tot_pur_amt");
            xeTotPurAmt.InnerText = totPurAmt;

            XmlElement xeTotRetAmt = OrderData.CartDocument.CreateElement("tot_ret_amt");
            xeTotRetAmt.InnerText = totRetAmt;

            XmlElement xeNumPur = OrderData.CartDocument.CreateElement("num_seats_pur");
            xeNumPur.InnerText = numPur;
            
            XmlElement xeNumRet = OrderData.CartDocument.CreateElement("num_seats_ret");
            xeNumRet.InnerText = numRet;
            
            xm.AppendChild(xePkgDesc);
            xm.AppendChild(xePkgNo);
            xm.AppendChild(xeTotPurAmt);
            xm.AppendChild(xeTotRetAmt);
            xm.AppendChild(xeNumRet);
            xm.AppendChild(xeNumPur);

        }

    }
   
    
    ds = tess.ExecuteLocalProcedure(sessionkey, 2, "@CUSTOMER=" + OrderData.CustomerNumber);
    lsal = ds.Tables[0].Rows[0]["lsal_desc"].ToString();             
  
%>
 Dear <%= lsal%>,
                                            
<%= OrderData.Custom.Custom3 %>

Thank you for your ticket purchase to McCarter Theatre Center.
Please save a copy of this email. If you would like to contact us about this order, e-mail patronservices@mccarter.org or call the Ticket Office at 609-258-ARTS (2787). Please include the order number in any correspondence with us.
If tickets are being mailed to you, you should expect to receive them within 7-10 days from the date you placed your order. If you do not receive them in that period of time, please contact the Ticket Office.
                                              
                                          
Order Details

============================================================
Order Date:		<%= OrderData.OrderDate.ToString("MM/dd/yyyy h:mmtt") %>
Order Number:	<%= OrderData.OrderNumber %>

Billing Information:
<tweb:AddressControl runat="server" ID="uxBilling" SwitchStreetLines="false" />
<%= OrderData.Customer.FullName %>
<%= OrderData.Customer.Phone %>
<%= OrderData.Customer.EmailAddress %>

------------------------------------------------------------------

Delivery Information:
<%= OrderData.Customer.FullName %>
<% if (OrderData.DeliveryMethod == -1) { %>
Hold order at Box Office
~ Please pick up your tickets no later than 30 minutes before curtain
<% } else { %>
<tweb:AddressControl runat="server" id="uxDelivery" DefaultCountry="[country]" />
<% } %>


<%= TransformXml("~/templates/Ticket_Subs_text.xsl")%>