public async Task ReserveTicket(TicketsToReserve ticketsToReserve, Guid ReservationKey, long ExpiryTs, int eventid) { await WithConnection2( async c => { var sqlparams = new DynamicParameters(); sqlparams.Add("@ticketclassid", ticketsToReserve.ticketclassid, DbType.Int32); sqlparams.Add("@eventid", eventid, DbType.Int32); sqlparams.Add("@ticketquantity", ticketsToReserve.ticketsselected, DbType.Int32); sqlparams.Add("@reservationkey", ReservationKey, DbType.Guid); sqlparams.Add("@expirytime", ExpiryTs, DbType.Int64); await c.ExecuteAsync("ReserveTicket", sqlparams, commandType: CommandType.StoredProcedure); } ); }
/** **/ public async Task AddTicketToOrder(TicketsToReserve ticketsToReserve, DateTime expiryttime, int orderid, int eventid) { await WithConnection2( async c => { var sqlparams = new DynamicParameters(); sqlparams.Add("@ticketclassid", ticketsToReserve.ticketclassid, DbType.Int32); sqlparams.Add("@eventid", eventid, DbType.Int32); sqlparams.Add("@ticketquantity", ticketsToReserve.ticketsselected, DbType.Int32); sqlparams.Add("@orderid", orderid, DbType.Int32); sqlparams.Add("@expirytime", expiryttime, DbType.DateTime); await c.ExecuteAsync("AddTicketToOrder", sqlparams, commandType: CommandType.StoredProcedure); } ); }
public async Task AddRecurringTicketToOrder(TicketsToReserve ticketsToReserve, DateTime expiryttime, int orderid, int eventid, DateTime recurrencekey) { TicketRespository ticketRespository = new TicketRespository(); await ticketRespository.CheckIfRecurrenceDateExists(recurrencekey, eventid, ticketsToReserve.ticketclassid); await WithConnection2( async c => { var sqlparams = new DynamicParameters(); sqlparams.Add("@ticketclassid", ticketsToReserve.ticketclassid, DbType.Int32); sqlparams.Add("@eventid", eventid, DbType.Int32); sqlparams.Add("@ticketquantity", ticketsToReserve.ticketsselected, DbType.Int32); sqlparams.Add("@orderid", orderid, DbType.Int32); sqlparams.Add("@expirytime", expiryttime, DbType.DateTime); sqlparams.Add("@recurrencekey", recurrencekey, DbType.DateTime); await c.ExecuteAsync("AddRecurringTicketToOrderv32", sqlparams, commandType: CommandType.StoredProcedure); } ); }