//REMOVED BY DAVEB 10/01
//private static void RefundTicket(Usr actionUsr, Ticket ticket)
//{
// RefundTicket(actionUsr, ticket, false);
//}
private static void RefundTicket(Usr actionUsr, Ticket ticket, bool refundIncludeBookingFee, bool areFundsAlreadyReleased)
{
try
{
if (ticket.IsAllowedToRefund(actionUsr, Math.Round(ticket.Price + (refundIncludeBookingFee ? ticket.BookingFee : 0), 2)))
{
InvoiceDataHolder creditDH = ticket.Invoice.CreateCredit();
creditDH.ActionUsrK = actionUsr.K;
// Remove all invoice items, except that of tickets
for (int i = creditDH.InvoiceItemDataHolderList.Count - 1; i >= 0; i--)
{
// Remove only the ticket invoice item (and booking fee if refundIncludeBookingFee)
if (creditDH.InvoiceItemDataHolderList[i].BuyableObjectK != ticket.K || creditDH.InvoiceItemDataHolderList[i].BuyableObjectType != Model.Entities.ObjectType.Ticket
|| (creditDH.InvoiceItemDataHolderList[i].Type != InvoiceItem.Types.EventTickets
&& (creditDH.InvoiceItemDataHolderList[i].Type != InvoiceItem.Types.EventTicketsBookingFee || !refundIncludeBookingFee)))
{
creditDH.InvoiceItemDataHolderList.RemoveAt(i);
}
}
if (ticket.Invoice.AmountAllowedToCredit < Math.Abs(creditDH.Total))
throw new Exception("Cannot credit more than " + ticket.Invoice.AmountAllowedToCredit.ToString("c") + " for Invoice #" + ticket.Invoice.K.ToString());
decimal refundAmountRemaining = Math.Abs(creditDH.Total);
SecPay secPay = new SecPay();
// Refund that amount from transfers
foreach (InvoiceTransfer invoiceTransfer in ticket.Invoice.SuccessfulInvoiceTransfers)
{
try
{
if (refundAmountRemaining <= 0)
break;
decimal refundAmount = Math.Round(invoiceTransfer.Amount, 2) < Math.Round(refundAmountRemaining, 2) ? Math.Round(invoiceTransfer.Amount, 2) : Math.Round(refundAmountRemaining, 2);
// refund refundAmount from that transfer, the subtract that from refundAmountRemaining
Transfer transferToRefund = new Transfer(invoiceTransfer.TransferK);
secPay.MakeRefund(transferToRefund, Guid.NewGuid(), Usr.Current.K, refundAmount);
if (secPay.Transfer.Status == Transfer.StatusEnum.Success)
{
refundAmountRemaining = Math.Round(refundAmountRemaining - refundAmount, 2);
transferToRefund.UpdateAndResolveOverapplied();
Utilities.EmailTransfer(secPay.Transfer, true, false);
}
else
throw new Exception("SecPay refund #");// + secPay.Transfer.K.ToString() + " failed, by user: "******", for ticket #" + ticket.K.ToString());
}
catch (Exception ex)
{
Utilities.AdminEmailAlert("Exception in Ticket.RefundTicket(Ticket ticket)", "Exception in Ticket.RefundTicket(Ticket ticket)", ex, ticket);
}
}
if (Math.Round(refundAmountRemaining, 2) <= 0)
{
creditDH.DueDateTime = Time.Now;
Invoice credit = creditDH.UpdateInsertDelete();
// Get latest invoice from DB
ticket.Invoice = null;
ticket.Invoice.ApplyCreditToThisInvoice(credit);
if (!ticket.Invoice.Paid)
throw new Exception("Invoice #" + ticket.Invoice.K.ToString() + " was not refunded completely, please verify manually.");
ticket.Cancelled = true;
ticket.CancelledBeforeFundsRelease = !areFundsAlreadyReleased;
ticket.CancelledDateTime = Time.Now;
ticket.Update();
if (ticket.BuyerUsr != null)
{
ticket.BuyerUsr.SetPrefsNextTicketFeedbackDate();
}
Utilities.EmailTicket(ticket);
}
}
}
catch (Exception ex)
{
Utilities.AdminEmailAlert("Exception in Ticket.RefundTicket(Ticket ticket)", "Exception in Ticket.RefundTicket(Ticket ticket)", ex, ticket);
throw ex;
}
}
protected void SaveButton_Click(object sender, EventArgs e)
{
Page.Validate("");
if (Page.IsValid)
{
bool succeeded = false;
Transfer.StatusEnum previousStatus = currentTransfer.Status;
SecPay secPay = new SecPay();
try
{
LoadTransferFromScreen();
//if (CurrentTransfer.K == 0)
//{
// CurrentTransfer.SetDSIBankAccount();
//}
if (currentTransfer.Type.Equals(Transfer.TransferTypes.Refund) || currentTransfer.Amount < 0)
{
// Verify its Dave, Tim, Gee, Neil, or John
if (!Usr.Current.IsSuperAdmin)
throw new Exception("You do not have permission to refund. Please ask a super admin for assistance.");
if (currentTransfer.TransferRefundedK > 0 && currentTransfer.K == 0)
{
Transfer transferToRefund = new Transfer(currentTransfer.TransferRefundedK);
var transferToRefundAmountRemaining = TransferToRefund.AmountRemaining();
if (transferToRefundAmountRemaining < Math.Abs(currentTransfer.Amount))
throw new Exception("Cannot refund " + currentTransfer.Amount.ToString("c") + " because transfer to refund only has " + transferToRefundAmountRemaining.ToString("c") + " remaining.");
}
}
if (!Transfer.DoesDuplicateGuidExistInDb((Guid)this.ViewState["DuplicateGuid"]) || currentTransfer.K > 0)
{
if (currentTransfer.Type.Equals(Transfer.TransferTypes.Payment) && currentTransfer.Amount <= 0)
throw new Exception("Payment must have positive amount > 0");
if (currentTransfer.Type.Equals(Transfer.TransferTypes.Refund) && currentTransfer.Amount >= 0)
throw new Exception("Refund must have negative amount < 0");
if (currentTransfer.Type.Equals(Transfer.TransferTypes.Refund) && currentTransfer.Method.Equals(Transfer.Methods.Card) && currentTransfer.TransferRefundedK == 0)
throw new Exception("Cannot process card refund without an original succesful card transfer.");
// Set DateTimeCreated for new Transfers
if (currentTransfer.K == 0 || currentTransfer.DateTimeCreated.Equals(DateTime.MinValue))
{
currentTransfer.DateTimeCreated = DateTime.Now;
}
// If Transfer is now set to completed and DateTimeComplete is not set, then set it to NOW
if (!currentTransfer.Status.Equals(Transfer.StatusEnum.Pending) && currentTransfer.DateTimeComplete.Equals(DateTime.MinValue))
{
currentTransfer.DateTimeComplete = DateTime.Now;
}
// If saving new refund, first verify that original transfer amount >= new refund + original transfer amount refunded already
if (currentTransfer.K == 0 && currentTransfer.Status.Equals(Transfer.StatusEnum.Pending) && currentTransfer.Type.Equals(Transfer.TransferTypes.Refund) && currentTransfer.TransferRefundedK > 0)
{
var amountRefunded = TransferToRefund.AmountRefunded();
if (Math.Round(amountRefunded + Math.Abs(currentTransfer.Amount),2) > Math.Round(TransferToRefund.Amount,2))
{
throw new Exception("Refund cannot exceed original transfer amount. " + amountRefunded.ToString("c") + " already refunded "
+ currentTransfer.Amount.ToString("c") + " is greater than the original transfer amount " + transferToRefund.Amount.ToString("c"));
}
if (Math.Round(Math.Abs(currentTransfer.Amount), 2) == Math.Round(transferToRefund.Amount, 2))
currentTransfer.RefundStatus = Transfer.RefundStatuses.FullRefund;
else
currentTransfer.RefundStatus = Transfer.RefundStatuses.PartialRefund;
}
// for new card transactions that are marked as Pending, then process via SecPay
if (currentTransfer.K == 0 && currentTransfer.Method.Equals(Transfer.Methods.Card) && currentTransfer.Status.Equals(Transfer.StatusEnum.Pending))
{
if (currentTransfer.Type.Equals(Transfer.TransferTypes.Payment))
{
// Process card via SecPay
secPay.MakePayment(new List<InvoiceDataHolder>(), currentTransfer.Amount, new Usr(currentTransfer.UsrK), currentTransfer.PromoterK, Usr.Current.K, currentTransfer.CardName,
currentTransfer.CardAddress1, currentTransfer.CardAddressArea, currentTransfer.CardAddressTown, currentTransfer.CardAddressCounty, currentTransfer.CardAddressCountryK, currentTransfer.CardPostcode, "UK", this.CardNumberTextBox.Text.Trim().Replace(" ", ""),
currentTransfer.CardExpires, currentTransfer.CardCV2, Transfer.FraudCheckEnum.Relaxed, false, currentTransfer.DuplicateGuid, currentTransfer.CardStart,
currentTransfer.CardIssue > 0 ? currentTransfer.CardIssue.ToString() : "");
// Since SecPay doesnt store CardAddress2, we need to save it here.
secPay.Transfer.CardAddressArea = currentTransfer.CardAddressArea;
secPay.Transfer.CardAddressTown = currentTransfer.CardAddressTown;
secPay.Transfer.CardAddressCounty = currentTransfer.CardAddressCounty;
secPay.Transfer.CardAddressCountryK = currentTransfer.CardAddressCountryK;
secPay.Transfer.Update();
currentTransfer = secPay.Transfer;
}
else if (currentTransfer.Type.Equals(Transfer.TransferTypes.Refund) && currentTransfer.TransferRefundedK > 0)
{
secPay.MakeRefund(TransferToRefund, (Guid)ViewState["DuplicateGuid"], Usr.Current.K, currentTransfer.Amount);
currentTransfer = secPay.Transfer;
if (this.NotesAddOnlyTextBox.ReadOnlyTextBox.Text.Length > 0)
{
// Clear old notes, as they will be in the Notes textbox
if (TransferToRefund.Notes.Length > 0)
currentTransfer.Notes = currentTransfer.Notes.Replace(TransferToRefund.Notes, "") + "\n";
else
currentTransfer.Notes = "";
currentTransfer.Notes += this.NotesAddOnlyTextBox.ReadOnlyTextBox.Text;
}
TransferToRefund.AddNote("This transfer has been refunded " + currentTransfer.Amount.ToString("c") + " on refund transfer #" + currentTransfer.K.ToString(), "System");
TransferToRefund.UpdateAndResolveOverapplied();
Utilities.EmailTransfer(TransferToRefund, false, false);
}
if (!currentTransfer.Status.Equals(Transfer.StatusEnum.Success))
{
throw new Exception("SecPay transaction was not successful.");
//TransferK = CurrentTransfer.K;
//LoadScreenFromTransfer();
//this.ProcessingCustomValidator.IsValid = false;
//this.ProcessingCustomValidator.ErrorMessage = "Transfer #" + secPay.SecPayTransfer.K.ToString() + " failed. Please contact administrator for further details";
//return;
}
}
else
{
if (currentTransfer.K == 0 && currentTransfer.Method == Transfer.Methods.BankTransfer && currentTransfer.Type == Transfer.TransferTypes.Refund)
currentTransfer = Transfer.RefundViaBACS(currentTransfer);
else
currentTransfer.Update();
if ((currentTransfer.Status.Equals(Transfer.StatusEnum.Pending) || currentTransfer.Status.Equals(Transfer.StatusEnum.Success)) && currentTransfer.Type.Equals(Transfer.TransferTypes.Refund) && currentTransfer.TransferRefundedK > 0)
{
TransferToRefund.AddNote("This transfer has been refunded " + currentTransfer.Amount.ToString("c") + " on refund transfer #" + currentTransfer.K.ToString(), "System");
TransferToRefund.UpdateAndResolveOverapplied();
Utilities.EmailTransfer(TransferToRefund, false, false);
}
else if (currentTransfer.Status.Equals(Transfer.StatusEnum.Cancelled) && currentTransfer.Type.Equals(Transfer.TransferTypes.Refund) && currentTransfer.TransferRefundedK > 0)
{
// This scenario only occurs in very rare situations and handled only by SuperAdmins.
TransferToRefund.UpdateAndResolveOverapplied();
}
}
if (this.InvoiceK > 0 && currentTransfer.K > 0)
{
InvoiceTransfer invoiceTransfer;
try
{
invoiceTransfer = new InvoiceTransfer(this.InvoiceK, currentTransfer.K);
}
catch (Exception)
{
invoiceTransfer = new InvoiceTransfer();
invoiceTransfer.InvoiceK = this.InvoiceK;
invoiceTransfer.TransferK = currentTransfer.K;
}
invoiceTransfer.Amount = new Invoice(this.InvoiceK).Total;
if (invoiceTransfer.Amount > currentTransfer.Amount)
invoiceTransfer.Amount = currentTransfer.Amount;
invoiceTransfer.Update();
}
// Update Invoices that are affected by this transfer
currentTransfer.UpdateAffectedInvoices();
succeeded = true;
}
// Do not process if duplicate exists. User probably tried refreshing the page.
else
{
throw new Exception("Duplicate transfer already exists in the database.");
}
}
catch (Exception ex)
{
// If processing SecPay card transfer and error occurred, but transfer saved
if (secPay.Transfer != null && secPay.Transfer.K > 0 && this.TransferK == 0)
{
Mailer sm = new Mailer();
if (Vars.DevEnv)
{
sm.Subject = "Test - ";
sm.To = "*****@*****.**";
}
else
sm.To = "[email protected], [email protected], [email protected]";
sm.Body = "<p>Exception occurred using SecPay! - Usr = "******" (" + Usr.Current.K + "), PromoterK=" + secPay.Transfer.PromoterK.ToString() + "</p>";
sm.Body += "<p>Message: " + ex.Message + "</p>";
sm.Body += "<p>Transfer K: " + secPay.Transfer.K.ToString() + "</p>";
sm.Body += secPay.Transfer.AsHTML();
sm.TemplateType = Mailer.TemplateTypes.AdminNote;
sm.Subject = "Exception occurred using SecPay! Transfer K:" + secPay.Transfer.K.ToString();
sm.Send();
string redirectUrl = "";
if (this.InvoiceK > 0)
redirectUrl = secPay.Transfer.UrlAdminRetryFailedTransfer(this.InvoiceK);
else
redirectUrl = secPay.Transfer.UrlAdminRetryFailedTransfer();
string response = "<script type=\"text/javascript\">alert('Transfer #" + secPay.Transfer.K.ToString() + " " + secPay.Transfer.Status.ToString();
if (secPay.Transfer.Status.Equals(Transfer.StatusEnum.Success))
{
try
{
secPay.Transfer.UpdateAndResolveOverapplied();
}
catch (Exception)
{ }
response += ". There was an exception during saving: " + ex.Message + "'); open('" + secPay.Transfer.UrlAdmin() + "?" + Cambro.Misc.Utility.GenRandomText(5) + "', '_self');</script>";
}
else
response += ". Please try again.'); open('" + redirectUrl + "', '_self');history.go(1);</script>";
ViewState["DuplicateGuid"] = Guid.NewGuid();
Response.Write(response);
//Response.End();
}
else
{
// Display error message
this.ProcessingVal.ErrorMessage = ex.Message;
this.ProcessingVal.IsValid = false;
}
}
// Having Server.Transfer or Response.Redirect in Try{} caused an error during debugging.
if (succeeded == true)
{
// Send email to promoter and to DSI accounts
bool madeSuccessful = false;
if (!previousStatus.Equals(Transfer.StatusEnum.Success) && currentTransfer.Status.Equals(Transfer.StatusEnum.Success))
madeSuccessful = true;
// New successful transfers via SecPay will be auto emailed.
// Only new non-SecPay transfers or non-SecPay transfers made successful shall be emailed.
if (secPay.Transfer.K == 0 && (TransferK == 0 || madeSuccessful))
Utilities.EmailTransfer(currentTransfer, TransferK == 0, madeSuccessful);
string response = "<script type=\"text/javascript\">alert('Transfer #" + currentTransfer.K.ToString() + " saved successfully'); open('" + currentTransfer.UrlAdmin() + "?" + Cambro.Misc.Utility.GenRandomText(5) + "', '_self');</script>";
Response.Write(response);
Response.End();
}
}
}
