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