public List <Models.Filmes.Genero> Buscar() { SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand cmd = new SqlCommand("select * from generos"); cmd.Connection = conn; SqlDataReader d = cmd.ExecuteReader(); List <Models.Filmes.Genero> list = new List <Models.Filmes.Genero>(); while (d.Read()) { Models.Filmes.Genero gg = new Models.Filmes.Genero(); gg.Nome = d["Nome"].ToString(); gg.Id = Convert.ToInt32(d["Id"].ToString()); list.Add(gg); } return(list); }
public List <Models.Filmes.Genero> Pegar(string genero) { SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand cmd = new SqlCommand("select * from generos where Nome LIKE @1"); cmd.Connection = conn; cmd.Parameters.AddWithValue("@1", genero); SqlDataReader d = cmd.ExecuteReader(); List <Models.Filmes.Genero> list = new List <Models.Filmes.Genero>(); while (d.Read()) { Models.Filmes.Genero gg = new Models.Filmes.Genero(); gg.Nome = d["Nome"].ToString(); gg.Id = Convert.ToInt32(d["Id"].ToString()); list.Add(gg); } return(list); }
public void Atualizar(Models.Filmes.Genero g) { SqlConnection conn = new SqlConnection(connString); conn.Open(); SqlCommand cmd = new SqlCommand("update generos set Nome = @1 where Id = @11"); cmd.Connection = conn; cmd.Parameters.AddWithValue("@1", g.Nome); cmd.Parameters.AddWithValue("@11", g.Id); cmd.ExecuteNonQuery(); }
private void ListaGeneros_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex == 0) { d.Excluir(Convert.ToInt32(ListaGeneros.CurrentRow.Cells[2].Value.ToString())); MessageBox.Show("Campos Deletados"); } else if (e.ColumnIndex == 1) { Models.Filmes.Genero u = new Models.Filmes.Genero(); u.Id = Convert.ToInt32(ListaGeneros.CurrentRow.Cells[2].Value.ToString()); u.Nome = ListaGeneros.CurrentRow.Cells[3].Value.ToString(); d.Atualizar(u); MessageBox.Show("Campos Atualizados"); } ListaGeneros.DataSource = d.Buscar(); }