static public void Update(Library.Logon logons)
{
SqlConnection conexao = null;
try
{
conexao = new SqlConnection(global::Connection.Connection.String());
SqlCommand comando = conexao.CreateCommand();
comando.CommandText = "UPDATE Logon 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.Diagnostics.Logger.Error(ex);;
}
finally
{
conexao.Close();
}
}
static public void Save(Library.Logon logons)
{
SqlConnection conexao = null;
try
{
conexao = new SqlConnection(global::Connection.Connection.String());
SqlCommand comando = conexao.CreateCommand();
comando.CommandText = "INSERT INTO Logon (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.Diagnostics.Logger.Error(ex);;
}
finally
{
conexao.Close();
}
}
private void logarButton_Click(object sender, EventArgs e)
{
Library.Funcionario funcionario;
string message = "";
if (Library.FuncionarioBD.Logar(this.loginTB.Text, this.senhaTB.Text, out funcionario, out message))
{
Library.LogonBD.DeleteAll();
Library.Logon logon = new Library.Logon();
logon.Funcionario = funcionario;
logon.Data = DateTime.Now;
Library.LogonBD.Save(logon);
this.DialogResult = DialogResult.OK;
}
else
{
MessageBox.Show(message);
}
}
static public Library.Logon FindLogonById(long idLogon)
{
SqlConnection conexao = null;
SqlDataAdapter dap = null;
DataSet ds = null;
Library.Logon logons = null;
try
{
conexao = new SqlConnection(global::Connection.Connection.String());
dap = new SqlDataAdapter("SELECT * FROM Logon WHERE id='" + idLogon + "'", conexao);
ds = new DataSet();
dap.Fill(ds, "Logon");
if (ds.Tables["Logon"].Rows.Count == 1)
{
logons = new Logon();
logons.Id = (long)ds.Tables["Logon"].Rows[0]["id"];
logons.Funcionario = Library.FuncionarioBD.FindById((long)ds.Tables["Logon"].Rows[0]["idFuncionario"]);
logons.Data = (DateTime)ds.Tables["Logon"].Rows[0]["data"];
}
return(logons);
}
catch (Exception ex)
{
Library.Diagnostics.Logger.Error(ex);;
}
finally
{
conexao.Close();
dap.Dispose();
ds.Dispose();
}
return(null);
}
static public void Delete(Library.Logon logons)
{
SqlConnection conexao = null;
try
{
conexao = new SqlConnection(global::Connection.Connection.String());
SqlCommand comando = conexao.CreateCommand();
comando.CommandText = "DELETE FROM Logon WHERE id='" + logons.Id + "'";
conexao.Open();
comando.ExecuteNonQuery();
}
catch (Exception ex)
{
Library.Diagnostics.Logger.Error(ex);
}
finally
{
conexao.Close();
}
}
