public static List <logs> ListarLogs() { logs logs; List <logs> listarLogs = new List <logs>(); string sql = "ListarLogs"; using (var con = new SqlConnection(conexao)) { var comando = new SqlCommand(sql, con); comando.CommandType = CommandType.StoredProcedure; SqlDataReader read; con.Open(); using (read = comando.ExecuteReader()) { while (read.Read()) { logs = new logs(); logs.idLogs = Convert.ToInt32(read["ID"].ToString()); logs.data = read["data"].ToString(); logs.hora = read["hora"].ToString(); logs.usuario = read["usuario"].ToString(); logs.mensagem = read["mensagem"].ToString(); logs.idAtivo = Convert.ToInt32(read["idAtivo"].ToString()); listarLogs.Add(logs); } } return(listarLogs); } }
public static int InserirLog(logs log) { string sql = "InserirLog"; using (var con = new SqlConnection(conexao)) { var comando = new SqlCommand(sql, con); comando.CommandType = CommandType.StoredProcedure; comando.Parameters.AddWithValue("@data", log.data); comando.Parameters.AddWithValue("@hora", log.hora); comando.Parameters.AddWithValue("@usuario", log.usuario); comando.Parameters.AddWithValue("@mensagem", log.mensagem); comando.Parameters.AddWithValue("@idAtivo", log.idAtivo); con.Open(); log.idLogs = Convert.ToInt32(comando.ExecuteScalar()); } return(log.idLogs); }