private async Task <List <UsersTickets> > GetUsersTicketsData(SqlDataReader reader) { List <UsersTickets> lst = new List <UsersTickets>(); try { while (await reader.ReadAsync()) { UsersTickets uTicket = new UsersTickets() { ID = (Guid)reader["ID"], UserID = (Guid)reader["UserID"], TicketID = (Guid)reader["TicketID"], DestinationID = (Guid)reader["DestinationID"], DepartureID = (Guid)reader["DepartureID"], }; lst.Add(uTicket); } } catch (Exception ex) { throw ex; } finally { reader.Close(); } return(lst); }
public async Task Reserve([FromQuery] Guid userID, [FromQuery] Guid ticketID, [FromQuery] Guid destinationID, [FromQuery] Guid departureID) { UsersTickets uTicket = new UsersTickets() { ID = Guid.NewGuid(), UserID = userID, TicketID = ticketID, DestinationID = destinationID, DepartureID = departureID }; await _dataService.ReserveTicket(uTicket); BonusPoints points = new BonusPoints() { Id = Guid.NewGuid(), Points = 5, DateAquired = DateTime.Now }; await _dataService.AddPoints(points); UserBonusPoints userBonus = new UserBonusPoints() { Id = Guid.NewGuid(), UserID = userID, PointID = points.Id }; await _dataService.AddUserBonusPoints(userBonus); }
public async void Cancel([FromQuery] Guid userID, [FromQuery] Guid ticketID, [FromQuery] Guid destinationID, [FromQuery] Guid departureID) { UsersTickets uTicket = new UsersTickets() { UserID = userID, TicketID = ticketID, DestinationID = destinationID, DepartureID = departureID }; await _dataService.CancelTicket(uTicket); }
public async Task Reserve([FromQuery] Guid userID, [FromQuery] Guid ticketID, [FromQuery] Guid destinationID, [FromQuery] Guid departureID) { UsersTickets uTicket = new UsersTickets() { ID = Guid.NewGuid(), UserID = userID, TicketID = ticketID, DestinationID = destinationID, DepartureID = departureID }; await _dataService.ReserveTicket(uTicket); }
public async Task ReserveTicket(UsersTickets uTickets) // gives the user the ticketID and changes the AvailableID of the Ticket to a new Guid wich indicates it's "taken" status. { using (SqlConnection con = new SqlConnection(connectionString)) { string sql = "INSERT INTO UsersTickets(ID, UserID, TicketID, DestinationID, DepartureID) Values(@id, @userID, @ticketID, @destinationID, @departureID)"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@id", uTickets.ID); cmd.Parameters.AddWithValue("@userID", uTickets.UserID); cmd.Parameters.AddWithValue("@ticketID", uTickets.TicketID); cmd.Parameters.AddWithValue("@destinationID", uTickets.DestinationID); cmd.Parameters.AddWithValue("@departureID", uTickets.DepartureID); con.Open(); await cmd.ExecuteNonQueryAsync(); con.Close(); } }
public async Task CancelTicket(UsersTickets uTickets) { using (SqlConnection con = new SqlConnection(connectionString)) { string sql = "DELETE From UsersTickets WHERE TicketID = @ticketID AND UserID = @userID AND DestinationID = @destinationID AND DepartureID = @departureID"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@userID", uTickets.UserID); cmd.Parameters.AddWithValue("@ticketID", uTickets.TicketID); cmd.Parameters.AddWithValue("@destinationID", uTickets.DestinationID); cmd.Parameters.AddWithValue("@departureID", uTickets.DepartureID); Thread.Sleep(20); con.Open(); await cmd.ExecuteNonQueryAsync(); con.Close(); } }
public async Task CancelTicket(UsersTickets uTickets) // removes the TicketID from the user and changes the AvailableID of the ticket which indicates it's "Available" status. { using (SqlConnection con = new SqlConnection(connectionString)) { string sql = "DELETE From [EasyFlights].[dbo].[UsersTickets] WHERE TicketID = @ticketID AND UserID = @userID AND DestinationID = @destinationID AND DepartureID = @departureID"; SqlCommand cmd = new SqlCommand(sql, con); cmd.Parameters.AddWithValue("@userID", uTickets.UserID); cmd.Parameters.AddWithValue("@ticketID", uTickets.TicketID); cmd.Parameters.AddWithValue("@destinationID", uTickets.DestinationID); cmd.Parameters.AddWithValue("@departureID", uTickets.DepartureID); Thread.Sleep(20); con.Open(); await cmd.ExecuteNonQueryAsync(); con.Close(); } }
public async Task CancelTicket(UsersTickets uTickets) { await _userRepository.CancelTicket(uTickets); }
public async Task ReserveTicket(UsersTickets uTickets) { await _userRepository.ReserveTicket(uTickets); }
public Task CancelTicket(UsersTickets uTicket) { throw new NotImplementedException(); }
public Task ReserveTicket(UsersTickets uTicket) { throw new NotImplementedException(); }