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