/// <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)); }