using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using vsilibrary.functions;
using vsilibrary.sql;
using System.Text;

public partial class Member_Renew_Confirmation : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
		//Bind Grid
		//DataTable dtPeople = SqlHelper.SqlExecuteSql("SELECT FirstName + ' ' + LastName AS Name, EmailPrimary as [Email/Username], UserPass AS Password, ExpirationDate AS [Expiration Date] FROM People WHERE CompanyID={0}", convert.ToInt(Session["CompanyID"]));
		//gvMembers.DataSource = dtPeople;
		//gvMembers.DataBind();

		//Load Receipt
		DataRow drReceipt = SqlHelper.SqlExecuteSql("SELECT * FROM Transactions WHERE TransactionID={0}", Request["TransactionID"]).Rows[0];

		StringBuilder sbReceipt = new StringBuilder();

		sbReceipt.AppendFormat(@"Thank you for your support.  
Please print the following receipt for your records.

Date:              {0}

Sponsorship Level: {1}
Payment Method:    {2}

Amount:            {3}


", drReceipt["Created"], drReceipt["SponsorshipLevel"], drReceipt["PaymentMethod"], convert.ToCurrency(drReceipt["Amount"]));


		ltrReceipt.Text = sbReceipt.ToString();

    }
}