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