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();
}
