public frmNovoFuncionario()
{
InitializeComponent();
if (AvencaPermission.HasPermission(this, true))
{
this.ShowDialog();
}
}
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
//if (!this.DesignMode)
if ((string)this.Tag != "granted")
{
AvencaPermission.HasPermission(this);
}
}
public static AvencaFuncionario FuncionarioGet(string pUsername, string pPassword)
{
AvencaFuncionario funcionario = null;
using (var connection = new SqlConnection(AvencaDB.ConnectionString))
{
using (var command = new SqlCommand())
{
try
{
command.Connection = connection;
command.CommandType = CommandType.Text;
command.CommandText = string.Format("SELECT * FROM FUNCIONARIO WHERE Username = @Username AND Password = @Password");
command.Parameters.AddWithValue("@Username", pUsername);
command.Parameters.AddWithValue("@Password", AvencaPermission.HashPassword(pPassword));
connection.Open();
var reader = command.ExecuteReader();
if (reader.Read())
{
funcionario = new AvencaFuncionario();
funcionario.Username = pUsername;
funcionario.Password = pPassword;
funcionario.Id = (int)reader["Id"];
funcionario.Nome = reader["Nome"].ToString();
funcionario.CPF = reader["CPF"].ToString();
funcionario.DataNascimentoStr = reader["DataNascimento"].ToString();
funcionario.Email = reader["Email"].ToString();
funcionario.Endereco = reader["Endereco"].ToString();
funcionario.HorarioEntradaStr = reader["HorarioEntrada"].ToString();
funcionario.HorarioSaidaStr = reader["HorarioSaida"].ToString();
funcionario.Setor = reader["Setor"].ToString();
funcionario.Sexo = reader["Sexo"].ToString();
funcionario.Telefone = reader["Telefone"].ToString();
funcionario.IdPermissionGroup = (int)reader["IdPermissionGroup"];
}
reader.Close();
}
catch (Exception ex)
{
AvencaErrorHandler.eventLogError(ex);
}
finally
{
connection.Close();
}
}
}
return(funcionario);
}
