public List <Modelo.hDisponivel> SelectAll()
        {
            Modelo.hDisponivel        aArea;
            List <Modelo.hDisponivel> aListAreas = new List <Modelo.hDisponivel>();
            SqlConnection             conn       = new SqlConnection(connectionstring);

            conn.Open();
            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandText = "Select * from horario_Disponivel";
            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    aArea = new Modelo.hDisponivel(
                        Alternadores.AlternadorI(dr["dia_semana"].ToString()),
                        dr["hora_inicio"].ToString(),
                        dr["hora_fim"].ToString(),
                        Alternadores.AlternadorI(dr["id_AreaPoliesportiva"].ToString())
                        );
                    aListAreas.Add(aArea);
                }
            }
            dr.Close();
            conn.Close();

            return(aListAreas);
        }
        public List <Modelo.AreaSport> SelectAll()
        {
            Modelo.AreaSport        aAreaSports;
            List <Modelo.AreaSport> aListAreaSports = new List <Modelo.AreaSport>();
            SqlConnection           conn            = new SqlConnection(connectionString);

            conn.Open();
            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandText = "Select * from area_Atividade";
            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    aAreaSports = new Modelo.AreaSport(
                        Alternadores.AlternadorI(dr["id_AtividadeEsportiva"].ToString()),
                        Alternadores.AlternadorI(dr["id_AreaPoliesportiva"].ToString()));
                    aListAreaSports.Add(aAreaSports);
                }
            }
            dr.Close();
            conn.Close();
            return(aListAreaSports);
        }
        public List <Modelo.Usuario> SelectAll()
        {
            Modelo.Usuario        aUsuario;
            List <Modelo.Usuario> aListUsuario = new List <Modelo.Usuario>();
            SqlConnection         conn         = new SqlConnection(connectionString);

            conn.Open();
            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandText = "Select * from usuario";
            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    aUsuario = new Modelo.Usuario(
                        dr["senha"].ToString(),
                        Alternadores.AlternadorI(dr["tipo_Usuario"].ToString()),
                        dr["nome"].ToString(),
                        dr["email"].ToString(),
                        dr["email"].ToString(),
                        dr["telefone"].ToString()
                        );
                    aListUsuario.Add(aUsuario);
                }
            }
            dr.Close();
            conn.Close();
            return(aListUsuario);
        }
        public static int Identity()
        {
            int           i    = 0;
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["SGEConnectionString"].ConnectionString);

            conn.Open();
            SqlCommand com = conn.CreateCommand();
            SqlCommand cmd = new SqlCommand();

            cmd.CommandText = @"select top(1) id from usuario
                                order by id desc";
            cmd.Connection  = conn;
            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    i = Alternadores.AlternadorI(dr["id"].ToString());
                }
            }
            dr.Close();
            conn.Close();
            return(i + 1);
        }
        public List <Modelo.Usuario> Select(string id)
        {
            Modelo.Usuario        aUsuario;
            List <Modelo.Usuario> aListUsuario = new List <Modelo.Usuario>();
            SqlConnection         conn         = new SqlConnection(connectionString);

            conn.Open();
            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandText = "Select * from Usuario Where id = @id";
            cmd.Parameters.AddWithValue("@id", id);
            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    aUsuario = new Modelo.Usuario(dr["senha"].ToString(), Alternadores.AlternadorI(dr["tipo_Usuario"].ToString()), dr["nome"].ToString(), dr["email"].ToString(), dr["telefones"].ToString());
                    aListUsuario.Add(aUsuario);
                }
            }
            else
            {
                return(null);
            }
            dr.Close();
            conn.Close();
            return(aListUsuario);
        }
        public List <Modelo.SolicitacaoReserva> SelectAll()
        {
            Modelo.SolicitacaoReserva        aSolicitacaoReserva;
            List <Modelo.SolicitacaoReserva> aListSolicitacaoReserva = new List <Modelo.SolicitacaoReserva>();
            SqlConnection conn = new SqlConnection(connectionstring);

            conn.Open();
            SqlCommand cmd = conn.CreateCommand();

            cmd.CommandText = "Select * from solicitacao_Reserva";
            SqlDataReader dr = cmd.ExecuteReader();

            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    aSolicitacaoReserva = new Modelo.SolicitacaoReserva(
                        Alternadores.AlternadorDT(dr["horario_Solicitacao"].ToString()),
                        dr["atividades_Realizadas"].ToString(),
                        dr["motivo_Solicitacao"].ToString(),
                        Alternadores.AlternadorDT(dr["Data_ini"].ToString()),
                        Alternadores.AlternadorDT(dr["Data_fim"].ToString()),
                        Alternadores.AlternadorI(dr["id_Usuario_Solicitante"].ToString()),
                        Alternadores.AlternadorI(dr["id_AreaPoliesportiva"].ToString())
                        );
                    aListSolicitacaoReserva.Add(aSolicitacaoReserva);
                }
            }
            dr.Close();
            conn.Close();

            return(aListSolicitacaoReserva);
        }
Exemple #7
0
 public bool InsertAreaImg(string url, int idArea)
 {
     try {
         Modelo.Img    mimg = new Modelo.Img(url);
         SqlConnection conn = new SqlConnection(connectionstring);
         conn.Open();
         SqlCommand cmd = conn.CreateCommand();
         cmd.CommandText = @"Insert into Img (img_Url) values (@url) 
                             Select max(id) as id from Img";
         cmd.Parameters.AddWithValue("@url", url);
         SqlDataReader dr = cmd.ExecuteReader();
         int           id = 0;
         if (dr.HasRows)
         {
             int i = 0;
             while (dr.Read())
             {
                 if (i > 0)
                 {
                     break;
                 }
                 id = Alternadores.AlternadorI(dr["id"].ToString());
                 i++;
             }
         }
         dr.Close();
         SqlCommand ncmd = conn.CreateCommand();
         if (id > 0)
         {
             ncmd.CommandText = "Insert into Area_Img (id_Area,id_Img) values (@idA,@idI)"; ncmd.Parameters.AddWithValue("@idA", Identity()); ncmd.Parameters.AddWithValue("@idI", id);
             ncmd.ExecuteNonQuery();
         }
         else
         {
             throw new Exception();
         }
         return(true);
     }
     catch {
         return(false);
     }
 }