/// <summary>
/// On GoToPayment-buttonclick, the shippinginformation stored in TicketBuyer is sent to SQL and given a TransactionID. Then we loop the Shoppingcart in three steps:
/// Adding a seatID to the ticketeventdate. Adding a ticketID to the seatID. Last, connecting the ticketID to the TransactionID.
/// </summary>
/// <param name="ticketBuyer"></param>
/// <returns>Returns an orderconfirmation.</returns>
public IActionResult GoToPayment(TicketTransaction ticketBuyer)
{
value.TicketBuyer = ticketApi.TicketTransactionAdd(ticketBuyer); // Lägger till köpare = TransactionID
foreach (EventSummary id in value.CartSummary)
{
SeatsAtEventDate e = ticketApi.PurchasedSeats(id); // Lägger till SeatID
Tickets x = ticketApi.PurchasedTickets(e); // Lägger till TicketID
TicketToTransaction ticketToTransaction = new TicketToTransaction();
ticketToTransaction.TransactionID = value.TicketBuyer.TransactionID;
ticketToTransaction.TicketID = x.TicketId;
ticketApi.AddTicketBuyer(ticketToTransaction); // Kopplar TicketID + TransactionID
}
Mail m = new Mail();
string s = "";
string z = "<h1> Here is a summary of your beautiful order!</h1>";
foreach (EventSummary e in value.CartSummary)
{
s = s + "<h2>" + e.EventName + "</h2>" + "[ " + e.VenueName + " - " + e.EventStartDateTime + " ] </li>";
}
s = z + s;
m.SendEmail(ticketBuyer.BuyerEmail, ticketBuyer.BuyerFirstName, s);
return(View("PurchaseCompleted", value));
}
/// <summary>
/// Adds a TicketBuyer to the TicketToTransaction table in the database.
/// </summary>
/// <param name="ticketToTransaction">TicketID, TransactionID</param>
/// <returns>TicketID, TransactionID</returns>
public TicketToTransaction AddTicketBuyer(TicketToTransaction ticketToTransaction)
{
var json = JsonConvert.SerializeObject(ticketToTransaction);
var client = new RestClient(localhost);
var request = new RestRequest("TicketTransactions/TicketBuyer/", Method.POST);
request.AddParameter("application/json", json, ParameterType.RequestBody);
var response = client.Execute <TicketToTransaction>(request);
return(response.Data);
}
public TicketToTransaction AddTicketBuyer(TicketToTransaction ticketToTransaction)
{
using (var connection = new SqlConnection(connectionString))
{
string queryString = "INSERT INTO TicketsToTransactions(TicketID, TransactionID) VALUES (@TicketID, @TransactionID)";
connection.Open();
connection.Query(queryString, new { TicketID = ticketToTransaction.TicketID, TransactionID = ticketToTransaction.TransactionID });
return(connection.Query <TicketToTransaction>("SELECT * FROM TicketsToTransactions WHERE TicketID=@Id", new { Id = ticketToTransaction.TicketID }).First());
}
}
public TicketToTransaction Post([FromBody] TicketToTransaction ticketToTransaction)
{
return(tdb.AddTicketBuyer(ticketToTransaction));
}
