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