public HttpResponseMessage deleteReserva(DeleteReservaRequest delReserva)
{
var reservaDA = new ReservaDataAccess();
var reservaEliminada = reservaDA.DeleteReserva(delReserva);
return(Request.CreateResponse(HttpStatusCode.OK, reservaEliminada));
}
/*
* //METODO LISTAR RESERVAS
* public IEnumerable<ReservaModel> GetReservas()
* {
* try
* {
* using (var context = new BDReservasEntities())
* {
* List<ReservaModel> listReservas = (from V_RESERVAS_PISTAS in context.V_RESERVAS_PISTAS
* select new ReservaModel
* {
* Fecha = V_RESERVAS_PISTAS.fecha.Trim(),
* H_ini = V_RESERVAS_PISTAS.h_ini.Trim(),
* H_fin = V_RESERVAS_PISTAS.h_fin.Trim(),
* Id_Reserva = V_RESERVAS_PISTAS.id_reserva,
* Pista = V_RESERVAS_PISTAS.pista.Trim(),
* Email = V_RESERVAS_PISTAS.email.Trim()
*
* }).ToList<ReservaModel>();
* return listReservas;
* }
* }
* catch (Exception ex)
* {
* throw ex;
* }
*
* }
*/
//METODO ELIMINAR RESERVA
public DeleteReservaResponse DeleteReserva(DeleteReservaRequest delReserva)
{
try
{
using (var context = new BDReservasEntities())
{
ObjectParameter RETCODE = new ObjectParameter("RETCODE", typeof(int));
ObjectParameter MENSAJE = new ObjectParameter("MENSAJE", typeof(string));
context.PA_DELETE_RESERVA(delReserva.Id_Reserva, RETCODE, MENSAJE);
if ((int)RETCODE.Value < 0)
{
throw new Exception("Error no controlado");
}
if ((int)RETCODE.Value > 0)
{
throw new Exception(MENSAJE.Value.ToString().Trim());
}
return(new DeleteReservaResponse()
{
Retcode = (int)RETCODE.Value,
Mensaje = MENSAJE.Value.ToString().Trim()
});
}
}
catch (Exception ex)
{
return(new DeleteReservaResponse()
{
Retcode = -1,
Mensaje = ex.Message
});
}
}
