Beispiel #1
0
        //nuevo Funcion
        public static List<Tarifa> comBoxTarifa()
        {
            List<Tarifa> lista = new List<Tarifa>();

            string connectionString = ConfigurationManager.ConnectionStrings["ParkeoConnString"].ConnectionString;

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand("PDB_horasReserva", connection);
                command.CommandType = CommandType.StoredProcedure;

                try
                {
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();

                    while (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            Tarifa t = new Tarifa();

                            t.CantidadHora = reader.GetInt16(0);
                            t.Precio = reader.GetDecimal(1);

                            lista.Add(t);
                        }
                        reader.NextResult();
                    }
                    reader.Close();
                }
                catch (SqlException ex)
                {
                    throw ex;
                }
                catch (Exception ex)
                {
                    throw ex;
                }

            }
            return lista;
        }
Beispiel #2
0
        public static List<Tarifa> buscarTarifa(DateTime inicio, DateTime fin)
        {
            List<Tarifa> tarifas = new List<Tarifa>();

            string connectionString = ConfigurationManager.ConnectionStrings["ParkeoConnString"].ConnectionString;

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand("PDB_buscarTarifa", connection);
                command.CommandType = CommandType.StoredProcedure;

                command.Parameters.AddWithValue("inicio", inicio);
                command.Parameters.AddWithValue("fin", fin);

                try
                {
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();

                    while (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            Tarifa t = new Tarifa();

                            t.Precio = reader.GetDecimal(0);
                            t.TipoReserva = reader.GetString(1);
                            t.Fecha = reader.GetDateTime(2);

                            tarifas.Add(t);
                        }
                        reader.NextResult();
                    }
                    reader.Close();
                }
                catch (SqlException ex)
                {
                    throw ex;
                }
                catch (Exception ex)
                {
                    throw ex;
                }

            }
            return tarifas;
        }
Beispiel #3
0
        public static Tarifa tarifaActualReserva()
        {
            Tarifa precio = new Tarifa();
            string connectionString = ConfigurationManager.ConnectionStrings["ParkeoConnString"].ConnectionString;

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand command = new SqlCommand("PDB_TarifaActual", connection);
                command.CommandType = CommandType.StoredProcedure;

                try
                {
                    connection.Open();
                    SqlDataReader reader = command.ExecuteReader();

                    while (reader.HasRows)
                    {
                        while (reader.Read())
                        {
                            precio.IdTarifa = reader.GetInt32(0);
                            precio.Precio = reader.GetDecimal(1);
                        }
                        reader.NextResult();
                    }
                    reader.Close();
                }
                catch (SqlException ex)
                {
                    throw ex;
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            return precio;
        }