public void grava_acesso(cUsuario user)
{
try
{
#region QUERY
cGlobal.query = "INSERT INTO USUARIO_TB (USUARIO," +
"EMAIL," +
"LOGIN," +
"PWD," +
"DTCAD," +
"RESET_PWD," +
"ADM," +
"ATIVO," +
"ID_SETOR)" +
"VALUES('" + user.usuario + "', " +
"'" + user.email + "', " +
"'" + user.login + "', " +
"'" + user.senha + "', " +
"'" + user.dtcad + "'," +
"0," +
"0," +
"0," +
"1)";
dao.executa_query(cGlobal.query);
#endregion
}
catch (OleDbException ex)
{
throw ex;
}
}
public void grava_setor(cSetor cst)
{
try
{
#region QUERY
cGlobal.query = "INSERT INTO SETOR_TB (SETOR, USERCAD, DTCAD) " +
"VALUES('" + cst.setor + "', '" + cGlobal.userlogado + "', '" + DateTime.Now + "') ";
dao.executa_query(cGlobal.query);
#endregion
}
catch (OleDbException ex)
{
throw ex;
}
}
public bool exclui_fundo(cFundo cfun)
{
try
{
#region QUERY
cGlobal.query = "DELETE FROM FUNDO_TB WHERE ID_SETOR = " + cfun.codfundo + " ";
dao.executa_query(cGlobal.query, "cnn");
return(false);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
public void grava_log(cLog log)
{
try
{
#region QUERY
cGlobal.query = "INSERT INTO LOG_TB(LOG,FORM,METODO,DT,USER_SISTEMA,USER_REDE,TERMINAL,FLAG) VALUES('" + log.log + "','" + log.form + "', '" + log.metodo + "', '" + log.dt + "','" + log.usersistema + "','" + log.userRede + "','" + log.terminal + "', " + log.tp_flag + ")";
dao.executa_query(cGlobal.query);
#endregion
}
catch (OleDbException ex)
{
throw ex;
}
}
public void update_conexao(cConfiguracao cf)
{
try
{
#region QUERY
cDAO dao = new cDAO();
cGlobal.query = "UPDATE CONEXAO_TB SET DIRETORIO = '" + cf.diretorio + "', TAMANHO = '" + cf.tamanho + "' WHERE BANCO = '" + cf.banco + "' ";
dao.executa_query(cGlobal.query);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
public void update_diretorios(cConfiguracao cf)
{
try
{
#region QUERY
cDAO dao = new cDAO();
if (cf.setor.Equals("PROCESSAMENTO"))
{
cGlobal.query = "UPDATE DIRETORIO_TB SET " +
"SAC = '" + cf.sac + "', " +
"DI8 = '" + cf.di8 + "' " +
"WHERE ID_SETOR = (SELECT ID_SETOR FROM SETOR_TB WHERE SETOR = '" + cf.setor + "')";
}
dao.executa_query(cGlobal.query);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}