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