public int ChangeStatus(Reservacion reservacion)
        {
            try
            {
                SqlParameter[] parameters = new SqlParameter[2];
                parameters[0] = new SqlParameter("@id_reservacion", reservacion.id_reservacion);
                parameters[1] = new SqlParameter("estado_reservacion", reservacion.estado_reservacion);

                return(dataAccess.Execute("stp_reservaciones_changestatus", parameters));
            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
        }
        public int Add(Reservacion reservacion)
        {
            try
            {
                SqlParameter[] parameters = new SqlParameter[6];

                parameters[0] = new SqlParameter("@id_cancha", reservacion.id_cancha);
                parameters[1] = new SqlParameter("@entrada", reservacion.entrada);
                parameters[2] = new SqlParameter("@salida", reservacion.salida);
                parameters[3] = new SqlParameter("@arbitro", reservacion.arbitro);
                parameters[4] = new SqlParameter("@rfc", reservacion.rfc);
                parameters[5] = new SqlParameter("@total", reservacion.total);

                return(dataAccess.Execute("stp_reservaciones_add", parameters));
            }
            catch (Exception ex)
            {
                throw new ApplicationException(ex.Message);
            }
        }
Exemple #3
0
 public void Guardar(Reservacion r)
 {
     reserva.Guardar(r);
 }