protected void btnBuscar_Click(object sender, EventArgs e)
{
itemDAL iDAL = new itemDAL();
gvItens.DataSource = iDAL.BuscarItemFiltros(txtDesc.Text, txtAtor.Text, txtGenero.Text);
gvItens.DataBind();
}
private void btnInserir_Click(object sender, EventArgs e)
{
if (pbItem.Image != null)
{
Item objItem = SelectItem();
itemDAL iDAL = new itemDAL();
generoDAL gDAL = new generoDAL();
iDAL.InserirItem(objItem);
foreach (DataGridViewRow linha in dgvGeneros.Rows)
{
gDAL.InserirGeneroItem(iDAL.BuscarCodUltimoItem(), Convert.ToInt32(linha.Cells[0].Value));
}
foreach (DataGridViewRow linha in dgvParticipacoes.Rows)
{
iDAL.InserirParticipacao(iDAL.BuscarCodUltimoItem(), Convert.ToInt32(linha.Cells[0].Value), linha.Cells[2].Value.ToString());
}
limparTela();
MessageBox.Show("Item inserido");
}
else
{
MessageBox.Show("Imagem Requerida");
}
}
private void CarregarItens()
{
itemDAL iDAL = new itemDAL();
gvItens.DataSource = iDAL.ListarItens();
gvItens.DataBind();
}
private void btnAlterar_Click(object sender, EventArgs e)
{
Item objItem = SelectItem();
itemDAL iDAL = new itemDAL();
iDAL.AlteraItem(objItem);
}
private void RefreshGrid()
{
itemDAL iDAL = new itemDAL();
dgvItens.DataSource = iDAL.ListarItens();
dgvItens.Columns[10].Visible = false;
}
private void CBcarregarItens()
{
itemDAL iDAL = new itemDAL();
cbItens.DataSource = iDAL.ListarItens();
cbItens.DisplayMember = "Descricao";
cbItens.ValueMember = "Codigo";
}
private void btnAddItem_Click(object sender, EventArgs e)
{
itemDAL iDAL = new itemDAL();
Item objItem = new Item();
objItem = iDAL.BuscarItemCodigo(Convert.ToInt32(cbItens.SelectedValue));
dgvItens.Rows.Add(objItem.Codigo, objItem.CodigoDeBarras, objItem.Descricao, objItem.Preco);
txtTotal.Text = Convert.ToString((Convert.ToDecimal(txtTotal.Text) + objItem.Preco));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
itemDAL iDAL = new itemDAL();
gvItens.DataSource = iDAL.Listar10UltimosItens();
gvItens.DataBind();
}
}
protected void btnBuscar_Click(object sender, EventArgs e)
{
itemDAL iDAL = new itemDAL();
Item objItem = iDAL.BuscarItemCodigo(Convert.ToInt32(txtCod.Text));
List <Item> lista = new List <Item>();
lista.Add(objItem);
gvItem.DataSource = lista;
gvGeneros.DataSource = iDAL.ListarGenerosDeItem(Convert.ToInt32(txtCod.Text));
gvParticipacoes.DataSource = iDAL.ListarArtistasDeItem(Convert.ToInt32(txtCod.Text));
gvItem.DataBind();
gvGeneros.DataBind();
gvParticipacoes.DataBind();
}
private void btnBuscar_Click(object sender, EventArgs e)
{
itemDAL iDAL = new itemDAL();
Item objitem = iDAL.BuscarItemCodigo(Convert.ToInt32(txtCod.Text));
txtCod.Text = Convert.ToString(objitem.Codigo);
txtDescricao.Text = objitem.Descricao;
txtDiretor.Text = objitem.Diretor;
txtCodBar.Text = Convert.ToString(objitem.CodigoDeBarras);
txtAno.Text = Convert.ToString(objitem.Ano);
cbTipo.Text = Convert.ToString(objitem.Tipo);
dtpCompra.Value = objitem.DtCompra;
txtPreco.Text = Convert.ToString(objitem.Preco);
cbTipoItem.Text = objitem.Tipo;
txtVlCusto.Text = Convert.ToString(objitem.VlCusto);
pbItem.Image = Image.FromStream(new MemoryStream(objitem.Imagem));
cbTipo.Text = "BLU RAY 3D";
pbItem.Refresh();
}
private void btnExcluir_Click(object sender, EventArgs e)
{
itemDAL iDAL = new itemDAL();
iDAL.ExcluirItem(Convert.ToInt32(txtCod.Text));
}
