static public void Save(Library.Logons logons)
{
SqlConnection conexao = null;
try
{
conexao = new SqlConnection(global::Connection.Connection.String());
SqlCommand comando = conexao.CreateCommand();
comando.CommandText = "INSERT INTO Logons (idFuncionario, data) VALUES (@idFuncionario, @data)"
+ "SELECT CAST(scope_identity() AS bigint)";
comando.Parameters.AddWithValue("@idFuncionario", logons.Funcionario.Id);
comando.Parameters.AddWithValue("@data", logons.Data);
conexao.Open();
//comando.ExecuteNonQuery();
logons.Id = (long)comando.ExecuteScalar();
}
catch (Exception ex)
{
Library.Classes.Logger.Error(ex.Message, ex.StackTrace, ex.HelpLink, ex);;
}
finally
{
conexao.Close();
}
}
static public void Update(Library.Logons logons)
{
SqlConnection conexao = null;
try
{
conexao = new SqlConnection(global::Connection.Connection.String());
SqlCommand comando = conexao.CreateCommand();
comando.CommandText = "UPDATE Logons SET idFuncionario = @idFuncionario, data = @data WHERE (id= " + logons.Id + ")";
comando.Parameters.AddWithValue("@idFuncionario", logons.Funcionario.Id);
comando.Parameters.AddWithValue("@data", logons.Data);
conexao.Open();
comando.ExecuteNonQuery();
}
catch (Exception ex)
{
Library.Classes.Logger.Error(ex.Message, ex.StackTrace, ex.HelpLink, ex);;
}
finally
{
conexao.Close();
}
}
static public Library.Logons FindLogonsById(long idLogons)
{
SqlConnection conexao = null;
SqlDataAdapter dap = null;
DataSet ds = null;
Library.Logons logons = null;
try
{
conexao = new SqlConnection(global::Connection.Connection.String());
dap = new SqlDataAdapter("SELECT * FROM Logons WHERE id='" + idLogons + "'", conexao);
ds = new DataSet();
dap.Fill(ds, "Logons");
if (ds.Tables["Logons"].Rows.Count == 1)
{
logons = new Logons();
logons.Id = (long)ds.Tables["Logons"].Rows[0]["id"];
logons.Funcionario = Library.FuncionarioBD.FindFuncionarioById((long)ds.Tables["Logons"].Rows[0]["idFuncionario"]);
logons.Data = (DateTime)ds.Tables["Logons"].Rows[0]["data"];
}
return(logons);
}
catch (Exception ex)
{
Library.Classes.Logger.Error(ex.Message, ex.StackTrace, ex.HelpLink, ex);;
}
finally
{
conexao.Close();
dap.Dispose();
ds.Dispose();
}
return(null);
}
