public static List <LogMudanca> buscaListaPorPeriodo(string dataI, string dataF)
{
using (FbConnection fbConn = new FbConnection(Util.DAO.Conn))
{
using (FbCommand cmd = new FbCommand())
{
try
{
fbConn.Open();
cmd.Connection = fbConn;
int codI = retornaCodInicio(dataI, Convert.ToDateTime(dataF));
int codF = retornaCodFim(Convert.ToDateTime(dataI), dataF);
if (codI != -1 && codF != -1)
{
cmd.CommandText = "SELECT * FROM LOGMUDANCA WHERE CODMUDANCA >= " + codI +
" AND CODMUDANCA <= " + codF + " ORDER BY CODMUDANCA";
FbDataReader dr = cmd.ExecuteReader();
List <LogMudanca> listaMudanca = new List <LogMudanca>();
while (dr.Read())
{
LogMudanca log = new LogMudanca();
log.codMudanca = (int)dr["CODMUDANCA"];
log.descricao = dr["DESCRICAO"].ToString();
log.crg = Convert.ToInt32(dr["CRG"]);
log.data = Convert.ToDateTime(dr["DATA"] + " " + dr["HORA"]);
log.responsavel = dr["RESPONSAVEL"].ToString();
listaMudanca.Add(log);
}
return(listaMudanca);
}
return(new List <LogMudanca>());
}
catch (FbException fbError)
{
LogErro logErro = new LogErro();
logErro.crg = 0;
logErro.descricao = "Erro ao listar os Logs de mudança por periodo";
logErro.data = DateTime.Now;
logErro.maisDetalhes = fbError.Message;
LogErroDAO.inserirLogErro(logErro, 0);
return(null);
}
catch (Exception error)
{
LogErro logErro = new LogErro();
logErro.crg = 0;
logErro.descricao = "Erro ao listar os Logs de mudança por periodo";
logErro.data = DateTime.Now;
logErro.maisDetalhes = error.Message;
LogErroDAO.inserirLogErro(logErro, 0);
return(null);
}
}
}
}
public static List <LogMudanca> listaLogMudancas()
{
using (FbConnection fbConn = new FbConnection(Util.DAO.Conn))
{
using (FbCommand cmd = new FbCommand())
{
try
{
fbConn.Open();
cmd.Connection = fbConn;
cmd.CommandText = "SELECT * FROM LOGMUDANCA";
FbDataReader dr = cmd.ExecuteReader();
List <LogMudanca> listaMudanca = new List <LogMudanca>();
while (dr.Read())
{
LogMudanca log = new LogMudanca();
log.codMudanca = (int)dr["CODMUDANCA"];
log.descricao = dr["DESCRICAO"].ToString();
log.crg = Convert.ToInt32(dr["CRG"]);
log.data = Convert.ToDateTime(dr["DATA"] + " " + dr["HORA"]);
log.responsavel = dr["RESPONSAVEL"].ToString();
listaMudanca.Add(log);
}
return(listaMudanca);
}
catch (FbException fbError)
{
LogErro logErro = new LogErro();
logErro.crg = 0;
logErro.descricao = "Erro ao listar os Logs de mudança";
logErro.data = DateTime.Now;
logErro.maisDetalhes = fbError.Message;
LogErroDAO.inserirLogErro(logErro, 0);
return(null);
}
catch (Exception error)
{
LogErro logErro = new LogErro();
logErro.crg = 0;
logErro.descricao = "Erro ao listar os Logs de mudança";
logErro.data = DateTime.Now;
logErro.maisDetalhes = error.Message;
LogErroDAO.inserirLogErro(logErro, 0);
return(null);
}
}
}
}
public static bool alteraLogMudanca(LogMudanca log)
{
using (FbConnection fbConn = new FbConnection(Util.DAO.Conn))
{
using (FbCommand cmd = new FbCommand())
{
try
{
fbConn.Open();
cmd.Connection = fbConn;
cmd.CommandText = "UPDATE LOGMUDANCA SET DESCRICAO = @DESCRICAO, CRG = @CRG, DATA = @DATA, " +
"RESPONSAVEL = @RESPONSAVEL, HORA = @HORA WHERE CODMUDANCA = " + log.codMudanca;
cmd.Parameters.AddWithValue("@DESCRICAO", log.descricao);
cmd.Parameters.AddWithValue("@CRG", log.crg);
cmd.Parameters.AddWithValue("@DATA", log.data.ToString().Substring(0, 10));
cmd.Parameters.AddWithValue("@RESPONSAVEL", log.responsavel);
cmd.Parameters.AddWithValue("@HORA", log.data.ToString().Substring(11, 8));
cmd.ExecuteNonQuery();
return(true);
}
catch (FbException fbError)
{
LogErro logErro = new LogErro();
logErro.crg = 0;
logErro.descricao = "Erro no alterar Log de mudança";
logErro.data = DateTime.Now;
logErro.maisDetalhes = fbError.Message;
LogErroDAO.inserirLogErro(logErro, 0);
return(false);
}
catch (Exception error)
{
LogErro logErro = new LogErro();
logErro.crg = 0;
logErro.descricao = "Erro no alterar Log de mudança";
logErro.data = DateTime.Now;
logErro.maisDetalhes = error.Message;
LogErroDAO.inserirLogErro(logErro, 0);
return(false);
}
}
}
}
public static bool insereLogMudanca(LogMudanca log)
{
using (FbConnection fbConn = new FbConnection(Util.DAO.Conn))
{
using (FbCommand cmd = new FbCommand())
{
try
{
fbConn.Open();
cmd.Connection = fbConn;
cmd.CommandText = "INSERT INTO LOGMUDANCA(DESCRICAO,CRG,RESPONSAVEL,DATA,HORA) VALUES(@DESCRICAO, @CRG, @RESPONSAVEL, @DATA, @HORA)";
cmd.Parameters.AddWithValue("@DESCRICAO", log.descricao);
cmd.Parameters.AddWithValue("@CRG", log.crg);
cmd.Parameters.AddWithValue("@RESPONSAVEL", log.responsavel);
cmd.Parameters.AddWithValue("@DATA", log.data.ToString("dd.MM.yyyy"));
cmd.Parameters.AddWithValue("@HORA", log.data.ToString("HH:mm:ss"));
cmd.ExecuteNonQuery();
return(true);
}
catch (FbException fbError)
{
LogErro logErro = new LogErro();
logErro.crg = 0;
logErro.descricao = "Erro no inserir Log de mudança";
logErro.data = DateTime.Now;
logErro.maisDetalhes = fbError.Message;
LogErroDAO.inserirLogErro(logErro, 0);
return(false);
}
catch (Exception error)
{
LogErro logErro = new LogErro();
logErro.crg = 0;
logErro.descricao = "Erro no inserir Log de mudança";
logErro.data = DateTime.Now;
logErro.maisDetalhes = error.Message;
LogErroDAO.inserirLogErro(logErro, 0);
return(false);
}
}
}
}
