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