public static int insert(AlmoxarifadoBean 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 { OracleCommand cmd = REFOracleDatabase.ExecuteNonQueryCmd(trans, CommandType.Text, CMDINSERT, out qtdInsert, parms); bean.idAlmoxarifado = Convert.ToInt32(cmd.Parameters["id_almoxarifado_out"].Value.ToString()); cmd.Parameters.Clear(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw (ex); } } } return(qtdInsert); }
public static int update(AlmoxarifadoBean bean) { int qtdUpdate = 0; using (OracleConnection conn = new OracleConnection(REFOracleDatabase.CONN_STRING)) { OracleParameter[] parms = GetParameters(false); SetParameters(parms, bean); conn.Open(); using (OracleTransaction trans = conn.BeginTransaction()) { try { OracleCommand cmd = REFOracleDatabase.ExecuteNonQueryCmd(trans, CommandType.Text, CMDUPDATE, out qtdUpdate, parms); cmd.Parameters.Clear(); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw (ex); } } } return(qtdUpdate); }
private static bool SetInstance(OracleDataReader dr, AlmoxarifadoBean obj) { try { if (dr.Read()) { obj.idAlmoxarifado = Convert.ToInt32(dr["id_almoxarifado"].ToString()); obj.descr = dr["descr"].ToString(); return(true); } else { return(false); } } catch (Exception ex) { throw (ex); } finally { if (!dr.IsClosed) { dr.Close(); } } }
private static List <AlmoxarifadoBean> SetInstance(OracleDataReader dr) { List <AlmoxarifadoBean> list = new List <AlmoxarifadoBean>(); try { while (dr.Read()) { AlmoxarifadoBean obj = new AlmoxarifadoBean(); obj.idAlmoxarifado = Convert.ToInt32(dr["id_almoxarifado"].ToString()); obj.descr = dr["descr"].ToString(); list.Add(obj); } } catch (Exception ex) { throw (ex); } finally { if (!dr.IsClosed) { dr.Close(); } } return(list); }
public void init(AlmoxarifadoBean paramBean, TipoDMLForm tipoDMLForm) { bean = paramBean; setBeanIntoTextBox(); tipoDML = tipoDMLForm; if (tipoDML == TipoDMLForm.DELETE) { pnlPrincipal.Enabled = false; } }
protected override void alterar() { if (dgvDados.SelectedRows.Count > 0) { DMLAlmoxarifado form = new DMLAlmoxarifado(); AlmoxarifadoBean bean = (dgvDados.DataSource as List <AlmoxarifadoBean>)[dgvDados.SelectedRows[0].Index]; form.init(bean, TipoDMLForm.UPDATE); form.ShowDialog(this); } else { MessageBox.Show("Selecione um registro para alterá-lo."); } }
public static AlmoxarifadoBean getRecord(int id, OracleTransaction trans) { AlmoxarifadoBean bean = new AlmoxarifadoBean(); OracleDataReader dr = LoadDataReader(id, trans); try { SetInstance(dr, bean); } catch (Exception ex) { throw (ex); } return(bean); }
public static List <AlmoxarifadoBean> getRecords(AlmoxarifadoBean filter) { OracleDataReader dr = LoadDataReader(filter); List <AlmoxarifadoBean> list = null; try { list = SetInstance(dr); } catch (Exception ex) { throw (ex); } return(list); }
private static OracleDataReader LoadDataReader(AlmoxarifadoBean filtro) { String where = null; //montar o comando if (filtro.idAlmoxarifado > 0) { where = REFOracleDatabase.addAndWhere(where, " id_almoxarifado = " + filtro.idAlmoxarifado); } if (filtro.descr != null && filtro.descr.Trim() != "") { where = REFOracleDatabase.addAndWhere(where, " upper(descr) like '" + filtro.descr.Trim().ToUpper().Replace("'", "''") + "'"); } // return(REFOracleDatabase.ExecuteReader(CommandType.Text, CMDSELECT + where + ORDER_BY)); }
private void excluir() { try { int qtdregistros = AlmoxarifadoDAO.delete(bean.idAlmoxarifado); pnlMessage.status = MessageStatus.SUCCESS; pnlMessage.textMessage = "Almoxarifado excluido com sucesso."; pnlPrincipal.Enabled = false; isCommited = true; bean = null; } catch (Exception e) { MessageBox.Show(e.Message); pnlMessage.status = MessageStatus.ERROR; pnlMessage.textMessage = "Erro ao excluir o Almoxarifado."; } }
protected override void filtrar() { try { AlmoxarifadoBean bean = new AlmoxarifadoBean(); bean.idAlmoxarifado = Uteis.stringToInt(txtId.Text); bean.descr = txtDescr.Text; List <AlmoxarifadoBean> list = AlmoxarifadoDAO.getRecords(bean); dgvDados.DataSource = list; dgvDados.Select(); } catch (InvalidPropertyValueException e) { MessageBox.Show(e.Message); txtId.Select(); } }
private static void SetParameters(OracleParameter[] parms, AlmoxarifadoBean bean) { parms[0].Value = bean.descr; parms[1].Value = bean.idAlmoxarifado; }
public DMLAlmoxarifado() { InitializeComponent(); bean = new AlmoxarifadoBean(); tipoDML = TipoDMLForm.INSERT; }