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