protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// Used parts from https://www.paypaltech.com/PDTGen/
// Visit above URL to auto-generate PDT script
authToken = WebConfigurationManager.AppSettings["PDTToken"];
//read in txn token from querystring
txToken = Request.QueryString.Get("tx");
query = string.Format("cmd=_notify-synch&tx={0}&at={1}", txToken, authToken);
// Create the request back
string url = WebConfigurationManager.AppSettings["PayPalSubmitUrl"];
HttpWebRequest req = (HttpWebRequest)WebRequest.Create(url);
// Set values for the request back
req.Method = "POST";
req.ContentType = "application/x-www-form-urlencoded";
req.ContentLength = query.Length;
// Write the request back IPN strings
StreamWriter stOut = new StreamWriter(req.GetRequestStream(), System.Text.Encoding.ASCII);
stOut.Write(query);
stOut.Close();
// Do the request to PayPal and get the response
StreamReader stIn = new StreamReader(req.GetResponse().GetResponseStream());
strResponse = stIn.ReadToEnd();
stIn.Close();
//string strResponse = "SUCCESS mc_gross=145.35 protection_eligibility=Ineligible address_status=confirmed payer_id=WJ3SRWX9PXP94 tax=0.00 address_street=1+Main+St payment_date=07%3A13%3A35+Sep+06%2C+2012+PDT payment_status=Pending terminal_id= charset=windows-1252 address_zip=95131 first_name=sdgsd receipt_reference_number= mc_fee=4.52 address_country_code=US address_name=sdgsd+sdgs custom=80%2C9b5dc3f5-54d2-413b-9803-1fbabe6770ac payer_status=verified business=sellpr_1346179874_biz%40yahoo.com address_country=United+States address_city=San+Jose quantity=1 payer_email=adver_1345188328_per%40yahoo.com txn_id=059835996R2655052 payment_type=instant last_name=sdgs address_state=CA receiver_email=sellpr_1346179874_biz%40yahoo.com store_id= payment_fee=4.52 receiver_id=EVBLGJGBR8RL8 pending_reason=paymentreview pos_transaction_type= txn_type=web_accept item_name=ewtwet num_offers=0 mc_currency=USD item_number=1 residence_country=US handling_amount=0.00 transaction_subject=80%2C9b5dc3f5-54d2-413b-9803-1fbabe6770ac payment_gross=145.35 shipping=0.00 ";
// sanity check
//Response.Write(strResponse);
string CustomerID = GetCustomerID();
PDTHolder pdt = PDTHolder.Parse(strResponse);
// If response was SUCCESS, parse response string and output details
//The payment is succesful
if (strResponse.StartsWith("SUCCESS"))
{
using (var context = new SidejobEntities())
{
try
{
var Custom = pdt.Custom.Split(',');
//var custom = GetProjectID() + "," + GetCustomerID() + "," + GetPaymentID();
int ProjectId = int.Parse(Custom[0]);
int CustomerId = int.Parse(Custom[1]);
int PaymentId = int.Parse(Custom[2]);
var result = from c in context.ArchivedCustomerSuccessfulPDTs
where c.CustomerID == CustomerId && c.ProjectID == ProjectId && c.TransactionId == pdt.TransactionId
select c;
var resultQuery = result.FirstOrDefault();
if (resultQuery == null)
{
HiddenLabel.Text = string.Format("Thank you {0} {1} [{2}] for your payment of {3} {4}!",
pdt.PayerFirstName, pdt.PayerLastName, pdt.PayerEmail, pdt.GrossTotal, pdt.Currency);
//Insert into Successful PDT
var CustomerSuccessfulPDT = new CustomerSuccessfulPDT
{
PDTID = GetNextSuccessfulPDTID(),
GrossTotal = pdt.GrossTotal,
Invoice = pdt.InvoiceNumber,
PaymentStatus = pdt.PaymentStatus,
FirstName = pdt.PayerFirstName,
LastName = pdt.PayerLastName,
PaymentFee = pdt.PaymentFee,
BusinessEmail = pdt.BusinessEmail,
TxToken = Request.QueryString.Get("tx"),
ReceiverEmail = pdt.ReceiverEmail,
ItemName = pdt.ItemName,
CurrencyCode = pdt.Currency,
TransactionId = pdt.TransactionId,
Custom = pdt.Custom,
//Testing this one
subscriberId = pdt.SubscriberId,
//subscriberId = "",
CustomerID = CustomerId,
ProjectID = ProjectId
};
var PaymentID = int.Parse(Custom[2]);
CustomerPaymentDue currentpaymentdue = (from c in context.CustomerPaymentDues
where c.PaymentDueID == PaymentID
select c).FirstOrDefault();
//Response.Write(pdt.PaymentStatus.ToString());
if (pdt.PaymentStatus == "Completed")
{
//Archived PDT
var archivedcustomerSuccessfulPDT = new ArchivedCustomerSuccessfulPDT
{
PDTID = GetNextSuccessfulPDTID(),
GrossTotal = pdt.GrossTotal,
Invoice = pdt.InvoiceNumber,
PaymentStatus = pdt.PaymentStatus,
FirstName = pdt.PayerFirstName,
LastName = pdt.PayerLastName,
PaymentFee = pdt.PaymentFee,
BusinessEmail = pdt.BusinessEmail,
TxToken = Request.QueryString.Get("tx"),
ReceiverEmail = pdt.ReceiverEmail,
ItemName = pdt.ItemName,
CurrencyCode = pdt.Currency,
TransactionId = pdt.TransactionId,
Custom = pdt.Custom,
subscriberId = pdt.SubscriberId,
CustomerID = CustomerId,
ProjectID = ProjectId
};
context.AddToArchivedCustomerSuccessfulPDTs(archivedcustomerSuccessfulPDT);
//Archived Payment Due
var archivedpaymentdue = new ArchivedCustomerPayment
{
CustomerID = currentpaymentdue.CustomerID,
PaymentDueID = currentpaymentdue.PaymentDueID,
ProjectID = currentpaymentdue.ProjectID,
ProjectAmount = currentpaymentdue.ProjectAmount,
Date = currentpaymentdue.Date,
StatusID = currentpaymentdue.StatusID,
CurrencyCode = currentpaymentdue.CurrencyCode,
PaymentDue = currentpaymentdue.PaymentDue,
PhaseStatus = currentpaymentdue.PhaseStatus
};
context.AddToArchivedCustomerPayments(archivedpaymentdue);
//Update PaymentDue
context.CustomerPaymentDues.DeleteObject(currentpaymentdue);
context.SaveChanges();
//invoke timeup for customerpayment
//Approve Ad
//ApproveAd(AdID);
}
else
{
currentpaymentdue.Status = pdt.PaymentStatus;
currentpaymentdue.PaymentProcess = true;
}
context.AddToCustomerSuccessfulPDTs(CustomerSuccessfulPDT);
context.SaveChanges();
}
else
{
HiddenLabel.Text = Resources.Resource.AlreadyPaid;
}
}
catch (Exception e1)
{
string failuremessage = pdt.PayerFirstName + " " +
pdt.PayerLastName + "<br/>";
failuremessage += Resources.Resource.FailedTransaction + "<br/>";
failuremessage += Resources.Resource.FailurePDT;
HiddenLabel.Text = failuremessage;
}
}
}
else
{
using (var context = new SidejobEntities())
{
try
{
string[] Custom = pdt.Custom.Split(',');
//var custom = GetProjectID() + "," + GetCustomerID() + "," + GetPaymentID();
int ProjectId = int.Parse(Custom[0]);
int CustomerId = int.Parse(Custom[1]);
int PaymentId = int.Parse(Custom[2]);
//Insert into HackedPDT
var CustomerHackedPDT = new CustomerHackedPDT
{
PDTID = GetNextSuccessfulPDTID(),
GrossTotal = pdt.GrossTotal,
Invoice = pdt.InvoiceNumber,
PaymentStatus = pdt.PaymentStatus,
FirstName = pdt.PayerFirstName,
LastName = pdt.PayerLastName,
PaymentFee = pdt.PaymentFee,
BusinessEmail = pdt.BusinessEmail,
TxToken = Request.QueryString.Get("tx"),
ReceiverEmail = pdt.ReceiverEmail,
ItemName = pdt.ItemName,
CurrencyCode = pdt.Currency,
TransactionId = pdt.TransactionId,
Custom = pdt.Custom,
SubscriberId = pdt.SubscriberId,
CustomerID = CustomerId,
ProjectID = ProjectId
};
context.AddToCustomerHackedPDTs(CustomerHackedPDT);
context.SaveChanges();
//Email Admin
EmailAdmin("HackedPDT", GetNextSuccessfulPDTID());
string failuremessage = pdt.PayerFirstName + " " +
pdt.PayerFirstName + "<br/>";
failuremessage += Resources.Resource.FailedTransaction + "<br/>";
failuremessage += Resources.Resource.FailurePDT;
HiddenLabel.Text = failuremessage;
}
catch (Exception e1)
{
EmailAdmin("HackedPDT", GetNextSuccessfulPDTID());
string failuremessage = pdt.PayerFirstName + " " +
pdt.PayerFirstName + "<br/>";
failuremessage += Resources.Resource.FailedTransaction + "<br/>";
failuremessage += Resources.Resource.FailurePDT;
HiddenLabel.Text = failuremessage;
}
}
}
}
}
public void CheckRefundedCustomerPDT(int customerId, CustomerSuccessfulPDT e, SidejobEntities context)
{
//Check to see if exist
var r = (from c in context.RefundCustomerSuccessfulPDTs
where c.ProjectID == ProjectID && c.CustomerID == customerId
select c).FirstOrDefault();
if (r == null)
{
//Check if Record exist
if ((from c in context.RefundCustomerSuccessfulPDTs
where PDTID == e.PDTID
select c).FirstOrDefault() == null)
{
//Insert the new refund from the successful table
var refund = new RefundCustomerSuccessfulPDT
{
PDTID = e.PDTID,
GrossTotal = e.GrossTotal,
Invoice = e.Invoice,
PaymentStatus = e.PaymentStatus,
FirstName = e.FirstName,
LastName = e.LastName,
PaymentFee = e.PaymentFee,
BusinessEmail = e.BusinessEmail,
TxToken = e.TxToken,
ReceiverEmail = e.ReceiverEmail,
ItemName = e.ItemName,
CurrencyCode = e.CurrencyCode,
TransactionId = e.TransactionId,
Custom = e.Custom,
subscriberId = e.subscriberId,
CustomerID = e.CustomerID,
ProjectID = e.ProjectID
};
context.AddToRefundCustomerSuccessfulPDTs(refund);
context.SaveChanges();
PDTID = e.PDTID;
}
}
}
