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