public void DeleteAvailability(DeleteAvailabilityRequest request)
{
using (var connection = connectionFactory.Connect()) {
string sql = @"DELETE PlayerAvailability
FROM PlayerAvailability PA
INNER JOIN Players P ON PA.PlayerId = P.PlayerId
INNER JOIN Squads S ON P.SquadId = S.SquadId
INNER JOIN Clubs C ON S.ClubId = C.ClubId
WHERE C.Guid = @ClubGuid AND P.Guid = @PlayerGuid AND PA.Guid = @AvailabilityGuid" ;
var p = new DynamicParameters();
p.Add("@ClubGuid", request.ClubId.ToString());
p.Add("@PlayerGuid", request.PlayerId.ToString());
p.Add("@AvailabilityGuid", request.AvailabilityId.ToString());
connection.Open();
connection.Execute(sql, p);
}
}
public Response DeleteAvailability(DeleteAvailabilityRequest request)
{
if (request == null)
{
return(Response.CreateResponse(new ArgumentNullException()));
}
var response = VerifyIntegrity(request.ClubId, request.PlayerId, request.AvailabilityId);
if (response != null)
{
return(response);
}
try {
repository.DeleteAvailability(request);
return(Response.CreateSuccessResponse());
}catch (Exception ex) {
return(Response.CreateResponse(ex));
}
}
