private async Task <List <UserBonusPoints> > GetDataUBP(SqlDataReader reader)
{
List <UserBonusPoints> lst = new List <UserBonusPoints>();
try
{
while (await reader.ReadAsync())
{
UserBonusPoints points = new UserBonusPoints()
{
Id = (Guid)reader["Id"],
UserID = (Guid)reader["UserID"],
PointID = (Guid)reader["PointID"]
};
lst.Add(points);
}
}
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 Task <UserBonusPoints> AddUserBonusPoints(UserBonusPoints userBonus)
{
UserBonusPoints usrBonus = new UserBonusPoints();
using (SqlConnection con = new SqlConnection(connectionString))
{
string sql = "INSERT INTO UserBonusPoints(Id, UserID, PointID)";
sql += "Values(@Id, @UserId, @PointId)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@Id", userBonus.Id);
cmd.Parameters.AddWithValue("@UserId", userBonus.UserID);
cmd.Parameters.AddWithValue("@PointId", userBonus.PointID);
con.Open();
await cmd.ExecuteNonQueryAsync();
con.Close();
return(usrBonus);
}
}
public async Task <UserBonusPoints> AddUserBonusPoints(UserBonusPoints userBonus)
{
return(await _bonusPRepository.AddUserBonusPoints(userBonus));
}
public Task <UserBonusPoints> AddUserBonusPoints(UserBonusPoints userBonus)
{
throw new NotImplementedException();
}
