Exemplo n.º 1
0
        //ACTUALIZAR:
        public static int actualizarRol(Rol r)
        {
            SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
            SqlCommand cmd = new SqlCommand();
            int k = 0;

            cmd.CommandText = "UPDATE Rol " +
            "SET nombre= @nombre, descripcion= @descripcion" +
            " WHERE idRol= @idRol ";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;

            cmd.Parameters.AddWithValue("@nombre", r.Nombre);
            cmd.Parameters.AddWithValue("@descripcion", r.Descripcion);
            cmd.Parameters.AddWithValue("@idRol", r.IdRol);

            try
            {
                conn.Open();
                k = cmd.ExecuteNonQuery();
                conn.Close();
            }

            catch (Exception e)
            {
                MessageBox.Show(e.StackTrace.ToString());
            }

            return k;
        }
Exemplo n.º 2
0
        public static Rol buscarRolPorId(int idRol)
        {
            Rol r = null;

            SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
            SqlCommand cmd = new SqlCommand();
            SqlDataReader reader;

            cmd.CommandText = "SELECT * FROM Rol WHERE idRol=@idRol ";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;
            cmd.Parameters.AddWithValue("@idRol", idRol);

            try
            {
                conn.Open();
                reader = cmd.ExecuteReader();

                if (reader.Read())
                {
                    r = new Rol();
                    r.IdRol = Int32.Parse(reader["idRol"].ToString());
                    r.Nombre = reader["nombre"].ToString();
                    r.Estado = Int32.Parse(reader["estado"].ToString());
                    r.Descripcion = reader["descripcion"].ToString();
                }
                else
                {
                    conn.Close();
                }
            }
            catch (Exception e)
            {
                MessageBox.Show(e.StackTrace.ToString());
            }

            return r;
        }
Exemplo n.º 3
0
 public BindableCollection<Rol> ListarRol()
 {
     BindableCollection<Rol> lstRol = new BindableCollection<Rol>();
     SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
     SqlCommand cmd = new SqlCommand();
     SqlDataReader reader;
     cmd.CommandText = "SELECT * FROM Rol ";
     cmd.CommandType = CommandType.Text;
     cmd.Connection = conn;
     try
     {
         conn.Open();
         reader = cmd.ExecuteReader();
         while (reader.Read())
         {
             Rol r = new Rol();
             r.IdRol = Int32.Parse("" + reader["idRol"]);
             r.Nombre = reader["nombre"].ToString();
             r.Descripcion = reader["descripcion"].ToString();
             r.Estado = Int32.Parse("" + reader["estado"]);
             if (r.Estado == 1)
                 lstRol.Add(r);
         }
         conn.Close();
     }
     catch (Exception e)
     {
         MessageBox.Show(e.StackTrace.ToString());
     }
     return lstRol;
 }
Exemplo n.º 4
0
        //INSERTAR:
        public static int insertarRol(Rol r)
        {
            SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
            SqlCommand cmd = new SqlCommand();
            int k = 0;

            cmd.CommandText = "INSERT INTO Rol(nombre,descripcion,estado) " +
            "VALUES (@nombre,@descripcion,@estado)";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;

            cmd.Parameters.AddWithValue("@nombre", r.Nombre);
            cmd.Parameters.AddWithValue("@descripcion", r.Descripcion);
            cmd.Parameters.AddWithValue("@estado", r.Estado);

            try
            {
                conn.Open();
                k = cmd.ExecuteNonQuery();
                conn.Close();
            }
            catch (Exception e)
            {
                MessageBox.Show(e.StackTrace.ToString());
            }
            return k;
        }
Exemplo n.º 5
0
        //ELIMINAR:
        public static int eliminarRol(Rol r)
        {
            SqlConnection conn = new SqlConnection(Properties.Settings.Default.inf245g4ConnectionString);
            SqlCommand cmd = new SqlCommand();
            int k = 0;

            cmd.CommandText = "UPDATE Rol " +
            "SET estado= @estado" +
            " WHERE idRol= @idRol ";

            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;

            cmd.Parameters.AddWithValue("@estado", 0);  //0: Eliminado Lógico
            cmd.Parameters.AddWithValue("@idRol", r.IdRol);

            try
            {
                conn.Open();
                k = cmd.ExecuteNonQuery();
                conn.Close();

            }
            catch (Exception e)
            {
                MessageBox.Show(e.StackTrace.ToString());
            }

            return k;
        }