private static List <ItemVendaBean> SetInstance(OracleDataReader dr, VendaBean venda, OracleTransaction trans) { List <ItemVendaBean> list = new List <ItemVendaBean>(); try { while (dr.Read()) { ItemVendaBean obj = new ItemVendaBean(); obj.idItemVenda = Convert.ToInt32(dr["id_item_venda"].ToString()); obj.qtdProduto = Convert.ToDouble(dr["qtd_produto"].ToString()); //obj.vlrUnitario = Convert.ToDouble(dr["vlr_unitario"].ToString()); obj.venda = venda; obj.produto = ProdutoDAO.getRecord(Convert.ToInt32(dr["id_produto"].ToString()), trans); list.Add(obj); } } catch (Exception ex) { throw (ex); } finally { if (!dr.IsClosed) { dr.Close(); } } return(list); }
private static OracleDataReader LoadDataReader(VendaBean venda, OracleTransaction trans) { OracleParameter[] parms = { /*00*/ new OracleParameter("ID_VENDA", OracleDbType.Int32, ParameterDirection.Input) }; parms[0].Value = venda.idVenda; return(REFOracleDatabase.ExecuteReader(trans, CommandType.Text, CMDSELECTBYIDCLI, parms)); }
public DMLVenda() { InitializeComponent(); bean = new VendaBean(); tipoDML = TipoDMLForm.INSERT; tabela = TabelaDAO.getByNome("EST_ITEM_VENDA"); dgvItens.initGrid(tabela.colunas); }
public void init(VendaBean paramBean, TipoDMLForm tipoDMLForm) { bean = paramBean; setBeanIntoTextBox(); bean.itens.Sort(CompareItensByProduto); dgvItens.DataSource = bean.itens; tipoDML = tipoDMLForm; setBtnConfirmarText("Cancelar"); if (tipoDML == TipoDMLForm.DELETE || tipoDML == TipoDMLForm.VIEW) { pnlPrincipal.Enabled = false; } }
private static List <VendaBean> SetInstance(OracleDataReader dr, PessoaBean cliente, OracleTransaction trans) { List <VendaBean> list = new List <VendaBean>(); try { while (dr.Read()) { VendaBean obj = new VendaBean(); obj.idVenda = Convert.ToInt32(dr["id_venda"].ToString()); obj.dtVenda = dr.GetDateTime(2); obj.dtUltAlteracao = dr.GetDateTime(3); obj.dtEmissao = dr.GetDateTime(4); obj.notaVenda = dr["NOTA_VENDA"].ToString(); obj.vlrDesconto = Convert.ToDouble(dr["VLR_DESCONTO"].ToString()); obj.tipoVenda = dr["TIPO_VENDA"].ToString(); obj.qtdParcelas = Convert.ToInt32(dr["QTD_PARCELAS"].ToString()); obj.obs = dr["OBS"].ToString(); obj.status = dr["STATUS"].ToString(); if (dr[13] != DBNull.Value) { obj.dtVencParcela1 = dr.GetDateTime(13); } else { obj.dtVencParcela1 = null; } obj.cliente = cliente; obj.itens = ItemVendaDAO.getRecordsByIdVenda(obj, trans); list.Add(obj); } } catch (Exception ex) { throw (ex); } finally { if (!dr.IsClosed) { dr.Close(); } } return(list); }
private void cancelar() { if (dgvDados.SelectedRows.Count > 0) { DMLVenda form = new DMLVenda(); VendaBean bean = (dgvDados.DataSource as List <VendaBean>)[dgvDados.SelectedRows[0].Index]; form.init(bean, TipoDMLForm.DELETE); form.ShowDialog(this); } else { MessageBox.Show("Selecione um registro para alterá-lo."); } dgvDados.Select(); }
public static List <ItemVendaBean> getRecordsByIdVenda(VendaBean venda, OracleTransaction trans) { List <ItemVendaBean> list = null; OracleDataReader dr = LoadDataReader(venda, trans); try { list = SetInstance(dr, venda, trans); } catch (Exception ex) { throw (ex); } return(list); }
public static List <ItemVendaBean> getRecordsByIdVenda(VendaBean venda) { List <ItemVendaBean> list = null; using (OracleConnection conn = new OracleConnection(REFOracleDatabase.CONN_STRING)) { conn.Open(); using (OracleTransaction trans = conn.BeginTransaction()) { list = getRecordsByIdVenda(venda, trans); } } return(list); }
private void novaVenda() { if (dgvDados.SelectedRows.Count > 0) { DMLVenda frm = new DMLVenda(); VendaBean v = new VendaBean(); v.cliente = (dgvDados.DataSource as List <PessoaBean>)[dgvDados.SelectedRows[0].Index]; frm.init(v, TipoDMLForm.INSERT); frm.ShowDialog(); } else { MessageBox.Show("Selecione um cliente para registrar a venda."); } dgvDados.Select(); }
private static void SetParameters(OracleParameter[] parms, VendaBean bean) { parms[0].Value = bean.idVenda; parms[1].Value = bean.cliente.idPessoa; parms[2].Value = bean.dtVenda; parms[3].Value = bean.dtUltAlteracao; parms[4].Value = bean.dtEmissao; parms[5].Value = bean.notaVenda; parms[6].Value = bean.vlrDesconto; parms[7].Value = bean.vlrProdutos; parms[8].Value = bean.vlrTotal; parms[9].Value = bean.qtdParcelas; parms[10].Value = bean.tipoVenda; parms[11].Value = bean.obs; parms[12].Value = bean.status; parms[13].Value = bean.dtVencParcela1; }
public static int insert(VendaBean bean) { int qtdInsert = 0; using (OracleConnection conn = new OracleConnection(REFOracleDatabase.CONN_STRING)) { OracleParameter[] parms = GetParameters(true); SetParameters(parms, bean); conn.Open(); using (OracleTransaction trans = conn.BeginTransaction()) { try { //inseir a venda OracleCommand cmd = REFOracleDatabase.ExecuteNonQueryCmd(trans, CommandType.Text, CMDINSERT, out qtdInsert, parms); bean.idVenda = Convert.ToInt32(cmd.Parameters["id_venda_out"].Value.ToString()); //inserir os itens foreach (ItemVendaBean item in bean.itens) { if (item.qtdProduto > 0) { ItemVendaDAO.insert(item, trans); } } cmd.Parameters.Clear(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw (ex); } } } return(qtdInsert); }