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