public async Task <IActionResult> Edit(int id, [Bind("PaymentDetails,CardOwnerName,CardNumber,ExpirationDate,SecurityCode")] PaymentDetail paymentDetail)
{
if (id != paymentDetail.PaymentDetails)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(paymentDetail);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!PaymentDetailExists(paymentDetail.PaymentDetails))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(paymentDetail));
}
internal static void UpdateTicketsFromEventTicket(EventTicket eventTicket, PaymentContext context)
{
// get the list of all Tickets associated with this record
var tickets = context.Ticket.Where(t => t.EventTicketId == eventTicket.EvenTicketId && t.StateCode == 0);
// update their amount fields
foreach (var curTicket in tickets)
{
curTicket.AmountNonreceiptable = eventTicket.AmountNonReceiptable ?? 0;
curTicket.AmountReceipted = eventTicket.AmountReceipted ?? 0;
curTicket.SyncDate = null;
context.Update(curTicket);
}
context.SaveChanges();
}
internal static void UpdateProductsFromEventProduct(EventProduct eventProduct, PaymentContext context)
{
// get the list of all Products associated with this record
var products = context.Product.Where(p => p.EventProductId == eventProduct.EventProductId && p.StateCode == 0).ToList();
// update their amount fields
foreach (var curProduct in products)
{
curProduct.AmountNonreceiptable = eventProduct.AmountNonReceiptable ?? 0;
curProduct.AmountReceipted = eventProduct.AmountReceipted ?? 0;
curProduct.SyncDate = null;
context.Update(curProduct);
}
context.SaveChanges();
}
internal static void UpdateSponsorshipsFromEventSponsorship(EventSponsorship eventSponsorship,
PaymentContext context)
{
// get the list of all Sponsorships associated with this record
var sponsorships =
context.Sponsorship.Where(s => s.EventSponsorshipId == eventSponsorship.EventSponsorshipId && s.StateCode == 0).ToList();
// update their amount fields
foreach (var curSponsorship in sponsorships)
{
curSponsorship.AmountNonreceiptable = eventSponsorship.AmountNonReceiptable ?? 0;
curSponsorship.AmountReceipted = eventSponsorship.AmountReceipted ?? 0;
curSponsorship.SyncDate = null;
context.Update(curSponsorship);
}
context.SaveChanges();
}
internal static void UpdateEventPackage(EventPackage eventPackage, PaymentContext context)
{
// get all the Tickets, Products and Sponsorships associated with the Event Package
var tickets = context.Ticket.Where(t => t.EventPackageId == eventPackage.EventPackageId);
Console.WriteLine("Found " + tickets.Count() + " Tickets associated with the Event Package");
var products = context.Product.Where(p => p.EventPackageId == eventPackage.EventPackageId);
Console.WriteLine("Found " + products.Count() + " Products associated with the Event Package");
var sponsorships =
context.Sponsorship.Where(s => s.EventPackageId == eventPackage.EventPackageId);
Console.WriteLine("Found " + sponsorships.Count() + " Sponsorships associated with the Event Package");
decimal ticketNonReceiptable = 0;
decimal productNonReceiptable = 0;
decimal sponsorshipNonpReceiptable = 0;
decimal totalNonReceiptable = 0;
var eventPackageTotalAmount = eventPackage.Amount;
ticketNonReceiptable = tickets.Sum(t => t.AmountNonreceiptable ?? 0);
productNonReceiptable = products.Sum(p => p.AmountNonreceiptable ?? 0);
sponsorshipNonpReceiptable = sponsorships.Sum(s => s.AmountNonreceiptable ?? 0);
Console.WriteLine("Sum of Ticket Amount Non-Receipetable: " + ticketNonReceiptable);
Console.WriteLine("Sum of Product Amount ReceiNon-Receipetablepted: " + productNonReceiptable);
Console.WriteLine("Sum of Sponsorship Amount Non-Receipetable: " + sponsorshipNonpReceiptable);
totalNonReceiptable = ticketNonReceiptable + productNonReceiptable + sponsorshipNonpReceiptable;
Console.WriteLine("Total Amount Non-Receipetable:" + totalNonReceiptable);
eventPackage.AmountNonReceiptable = totalNonReceiptable;
eventPackage.AmountReceipted = eventPackageTotalAmount - totalNonReceiptable;
eventPackage.SyncDate = null;
context.Update(eventPackage);
context.SaveChanges();
Console.WriteLine("Updated Event Package: " + eventPackage.EventPackageId);
}