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