public List <Database.Entities.tb_employees> Consultar(Database.Entities.tb_employees employees)
{
List <Database.Entities.tb_employees> list = new List <Database.Entities.tb_employees>();
if (employees.nm_firstName != string.Empty && employees.nr_rg == string.Empty && employees.ds_sex == null)
{
list = db.ConsultarPorNome(employees);
}
else if (employees.nm_firstName == string.Empty && employees.nr_rg != string.Empty && employees.ds_sex == null)
{
list = db.ConsultarPorRG(employees);
}
else if (employees.nm_firstName == string.Empty && employees.nr_rg == string.Empty && employees.ds_sex != null)
{
list = db.ConsultarPorSexo(employees);
}
else if (employees.nm_firstName != string.Empty && employees.nr_rg != string.Empty && employees.ds_sex == null)
{
list = db.ConsultarPorNomeRG(employees);
}
else if (employees.nm_firstName != string.Empty && employees.nr_rg == string.Empty && employees.ds_sex != null)
{
list = db.ConsultarPorNomeSexo(employees);
}
else if (employees.nm_firstName == string.Empty && employees.nr_rg != string.Empty && employees.ds_sex != null)
{
list = db.ConsultarPorRGSexo(employees);
}
return(list);
}
private void btnEntrar_Click(object sender, EventArgs e)
{
try
{
Database.Entities.tb_employees emp = new Database.Entities.tb_employees();
emp.ds_email = Model.LoginModel.Email = txtEmail.Text.Trim();
emp.pw_password = Model.LoginModel.Senha = txtSenha.Text.Trim();
Business.EmployeesBusiness busemp = new Business.EmployeesBusiness();
bool verificacao = busemp.Login(emp);
if (verificacao == true)
{
frmMenu tela = new frmMenu();
tela.Show();
Hide();
}
else
{
MessageBox.Show("Usuário Inexistente!");
}
}
catch (Exception)
{
MessageBox.Show("Ocorreu um erro!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void Inserir1(Database.Entities.tb_employees employees)
{
employees.nm_firstName = Model.EmployeesModel.firstName;
employees.nm_lastName = Model.EmployeesModel.lastName;
employees.nr_rg = Model.EmployeesModel.RG;
employees.nr_cpf = Model.EmployeesModel.CPF;
employees.nr_dependents = Model.EmployeesModel.dependents;
employees.ds_sex = Model.EmployeesModel.sex;
employees.dt_birth = Model.EmployeesModel.birth;
employees.ds_state = Model.EmployeesModel.state;
employees.nr_cep = Model.EmployeesModel.CEP;
employees.ds_address = Model.EmployeesModel.address;
employees.ds_note = Model.EmployeesModel.note;
employees.nr_cellphone = Model.EmployeesModel.cellphone;
employees.nr_tellphone = Model.EmployeesModel.tellphone;
employees.ds_email = Model.EmployeesModel.email;
employees.pw_password = Model.EmployeesModel.password;
employees.bt_manager = Model.EmployeesModel.manager;
employees.bt_employee = Model.EmployeesModel.employeer;
employees.bt_rh = Model.EmployeesModel.RH;
employees.bt_financial = Model.EmployeesModel.financial;
employees.bt_stock = Model.EmployeesModel.stock;
employees.bt_crm = Model.EmployeesModel.CRM;
db.Inserir1(employees);
}
public void AlterarRecuperação(Database.Entities.tb_employees employees)
{
if (employees.pw_password == string.Empty || employees.pw_password == "Senha do usuário")
{
throw new ArgumentException("O campo senha deve ser preenchido");
}
db.AlterarRecuperação(employees);
}
private void CustomizeDesign()
{
panelSubMenuRecursosHumanos.Visible = false;
panelSubMenuFinanceiro.Visible = false;
panelSubMenuFornecedor.Visible = false;
panelSubMenuEstoque.Visible = false;
panelSubMenuCRM.Visible = false;
Database.Entities.tb_employees tb = DB.UsuárioLogado(Model.LoginModel.Email, Model.LoginModel.Senha);
if (tb.bt_financial != true)
{
btnFinanceiro.Visible = false;
}
if (tb.bt_crm != true)
{
btnCRM.Visible = false;
}
if (tb.bt_provider != true)
{
btnFornecedor.Visible = false;
}
if (tb.bt_rh != true)
{
btnRecursosHumanos.Visible = false;
}
if (tb.bt_stock != true)
{
btnEstoque.Visible = false;
}
if (tb.bt_employee == true || tb.bt_manager == true)
{
btnCartãoDePonto.Visible = true;
btnConsultarCartãoDePonto.Visible = true;
}
string usuario = "Usuário:";
if (tb.bt_manager == true && tb.bt_employee == false)
{
usuario = "Gerente:";
}
if (tb.bt_manager == false && tb.bt_employee == true)
{
usuario = "Funcionario:";
}
lblUsuário.Text = usuario + " " + tb.nm_firstName + " " + tb.nm_lastName + " / Entrou às: " + DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss");
}
public bool Login(Database.Entities.tb_employees emp)
{
if (emp.ds_email == string.Empty || emp.ds_email == "Email do usuário")
{
throw new ArgumentException("O campo email deve ser preenchido");
}
else if (emp.pw_password == string.Empty || emp.pw_password == "Senha do usuário")
{
throw new ArgumentException("O campo senha deve ser preenchido");
}
else
{
return(db.Login(emp));
}
}
public void VerificarRecuperação(Database.Entities.tb_employees employees)
{
if (employees.nr_rg == string.Empty)
{
throw new ArgumentException("O campo RG deve ser preenchido");
}
if (employees.nr_cpf == string.Empty)
{
throw new ArgumentException("O campo CPF deve ser preenchido");
}
if (employees.nr_cellphone == string.Empty)
{
throw new ArgumentException("O campo celular deve ser preenchido");
}
db.VerificarRecuperação(employees);
}
private void btnContinuar_Click(object sender, EventArgs e)
{
try
{
this.InserirModel();
Database.Entities.tb_employees employees = new Database.Entities.tb_employees
{
nm_firstName = txtNome.Text.Trim(),
nm_lastName = txtSobrenome.Text.Trim(),
nr_rg = mtxtRG.Text.Trim(),
nr_cpf = mtxtCPF.Text.Trim(),
nr_dependents = Convert.ToInt32(nudDependentes.Value),
ds_sex = cboSexo.Text,
dt_birth = dtpNascimento.Value.ToShortDateString(),
ds_state = cboEstado.Text,
nr_cep = mtxtCEP.Text.Trim(),
ds_note = txtComplemento.Text.Trim(),
ds_address = txtEndereço.Text.Trim(),
nr_cellphone = mtxtCelular.Text.Trim(),
nr_tellphone = mtxtTelefone.Text.Trim(),
ds_email = txtEmail.Text.Trim(),
pw_password = txtSenha.Text.Trim(),
bt_manager = rdbGerente.Checked,
bt_employee = rdbFuncionário.Checked,
bt_rh = chkRH.Checked,
bt_financial = chkFinanceiro.Checked,
bt_stock = chkEstoque.Checked,
bt_crm = chkCRM.Checked
};
Business.EmployeesBusiness db = new Business.EmployeesBusiness();
db.Inserir(employees);
frmMenu.Current.openContedor(new frmRegisterEmployee1());
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception)
{
MessageBox.Show("Ocorreu um erro!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public string Dependents()
{
Database.Entities.tb_employees tb = DB.tb_employees.First(t => t.id_emp == id);
return(tb.nr_dependents.ToString());
}
public string NomeCompleto()
{
Database.Entities.tb_employees tb = DB.tb_employees.First(t => t.id_emp == id);
return(tb.nm_firstName + " " + tb.nm_lastName);
}
private void btnSalvar_Click(object sender, EventArgs e)
{
try
{
Database.Entities.tb_employees tbemployees = new Database.Entities.tb_employees();
Business.EmployeesBusiness busemployee = new Business.EmployeesBusiness();
Database.Entities.tb_department tbdepartment = new Database.Entities.tb_department();
Business.DepartmentBusiness busdepartment = new Business.DepartmentBusiness();
Database.Entities.tb_function tbfunction = new Database.Entities.tb_function();
Business.FunctionBusiness busfunction = new Business.FunctionBusiness();
Database.Entities.tb_timecard tbtimecard = new Database.Entities.tb_timecard();
Business.TimeCardBusiness bustimecard = new Business.TimeCardBusiness();
Database.Entities.tb_financial tbfinancial = new Database.Entities.tb_financial();
Business.FinancialBusiness busfinancial = new Business.FinancialBusiness();
Database.Entities.tb_benefits tbbenefits = new Database.Entities.tb_benefits();
Business.BenefitsBusiness busbenefits = new Business.BenefitsBusiness();
Database.Entities.tb_bankaccount tbbank = new Database.Entities.tb_bankaccount();
Business.BankAccountBusiness busbank = new Business.BankAccountBusiness();
tbemployees.dt_hiring = dtpContratação.Value.ToShortDateString();
tbemployees.dt_resignation = dtpDemissão.Value.ToShortDateString();
tbdepartment.nm_department = cboDepartamento.Text;
tbfunction.nm_function = cboCargo.Text;
tbtimecard.hr_fixedInput = mtxtInício.Text;
tbtimecard.hr_fixedIntInput = mtxtInícioIntervalo.Text;
tbtimecard.hr_fixedIntOutput = mtxtTérminoIntervalo.Text;
tbtimecard.hr_fixedOutput = mtxtTérminoIntervalo.Text;
tbfinancial.vl_grossSalary = nudSalárioBruto.Value;
tbbenefits.bt_food = Convert.ToBoolean(chkValeAlimentação.Checked);
tbbenefits.bt_meal = Convert.ToBoolean(chkValeRefeição.Checked);
tbbenefits.bt_lifeSafe = Convert.ToBoolean(chkSeguroDeVida.Checked);
tbbenefits.bt_transport = Convert.ToBoolean(chkValeTransporte.Checked);
tbbenefits.bt_planHealth = Convert.ToBoolean(chkPlanoDeSáude.Checked);
tbbenefits.bt_planDental = Convert.ToBoolean(chkPlanoDental.Checked);
tbbank.nm_bank = txtNomeDoBanco.Text;
tbbank.nr_account = mtxtCódigoDoBanco.Text;
tbbank.nr_agency = Convert.ToInt32(mtxtAgênciaDoBanco.Text);
tbbank.ds_typePerson = cboTipoDePessoa.Text;
busemployee.Inserir1(tbemployees);
busdepartment.Inserir(tbdepartment);
busfunction.Inserir(tbfunction);
bustimecard.Inserir(tbtimecard);
busfinancial.Inserir(tbfinancial);
busbenefits.Inserir(tbbenefits);
busbank.Inserir(tbbank);
MessageBox.Show("Funcionário cadastrado com sucesso");
Model.EmployeesModel.firstName = string.Empty;
Model.EmployeesModel.lastName = string.Empty;
Model.EmployeesModel.RG = string.Empty;
Model.EmployeesModel.CPF = string.Empty;
Model.EmployeesModel.dependents = 0;
Model.EmployeesModel.birth = Convert.ToString(DateTime.Now);
Model.EmployeesModel.CEP = string.Empty;
Model.EmployeesModel.note = string.Empty;
Model.EmployeesModel.address = string.Empty;
Model.EmployeesModel.email = string.Empty;
Model.EmployeesModel.cellphone = string.Empty;
Model.EmployeesModel.tellphone = string.Empty;
Model.EmployeesModel.password = string.Empty;
Model.EmployeesModel.manager = Convert.ToBoolean(string.Empty);
Model.EmployeesModel.employeer = Convert.ToBoolean(string.Empty);
Model.EmployeesModel.RH = Convert.ToBoolean(string.Empty);
Model.EmployeesModel.financial = Convert.ToBoolean(string.Empty);
Model.EmployeesModel.stock = Convert.ToBoolean(string.Empty);
Model.EmployeesModel.CRM = Convert.ToBoolean(string.Empty);
}
catch (ArgumentException ex)
{
MessageBox.Show(ex.Message, "Atenção", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception)
{
MessageBox.Show("Ocorreu um erro!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void CarregarFuncionario(Database.Entities.tb_employees employees)
{
this.employees = employees;
}
public void Inserir(Database.Entities.tb_employees employees)
{
if (employees.nm_firstName == string.Empty)
{
throw new ArgumentException("O campo nome deve ser preenchido");
}
if (employees.nm_lastName == string.Empty)
{
throw new ArgumentException("O campo sobrenome deve ser preenchido");
}
if (employees.nr_rg == string.Empty)
{
throw new ArgumentException("O campo RG deve ser preenchido");
}
if (employees.nr_cpf == string.Empty)
{
throw new ArgumentException("O campo CPF deve ser preenchido");
}
if (employees.ds_sex == string.Empty)
{
throw new ArgumentException("O campo sexo deve ser preenchido");
}
if (employees.ds_sex == "Masculino")
{
employees.ds_sex = "M";
}
else
{
employees.ds_sex = "F";
}
if (employees.ds_state == string.Empty)
{
throw new ArgumentException("O campo Estado deve ser preenchido");
}
if (employees.nr_cep == string.Empty)
{
throw new ArgumentException("O campo CEP deve ser preenchido");
}
if (employees.ds_address == string.Empty)
{
throw new ArgumentException("O campo endereço deve ser preenchido");
}
if (employees.ds_note == string.Empty)
{
throw new ArgumentException("O campo complemento deve ser preenchido");
}
if (employees.nr_cellphone == string.Empty && employees.nr_tellphone == string.Empty)
{
throw new ArgumentException("Celular ou Telefone devem ser preenchidos");
}
if (employees.ds_email == string.Empty)
{
throw new ArgumentException("O campo nome deve ser preenchido");
}
if (employees.pw_password == string.Empty)
{
throw new ArgumentException("O campo nome deve ser preenchido");
}
Regex regex = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$");
Match match = regex.Match(employees.ds_email);
if (match.Success == false)
{
throw new ArgumentException(employees.ds_email + " é um e-mail inválido!");
}
if (employees.bt_employee == false && employees.bt_manager == false)
{
throw new ArgumentException("Escolha Funcionario ou Gerente!");
}
}
public void Alterar(Database.Entities.tb_employees employees)
{
if (employees.nm_firstName == string.Empty)
{
throw new ArgumentException("O campo nome deve ser preenchido");
}
if (employees.nm_lastName == string.Empty)
{
throw new ArgumentException("O campo sobrenome deve ser preenchido");
}
if (employees.nr_rg == string.Empty)
{
throw new ArgumentException("O campo RG deve ser preenchido");
}
if (employees.nr_cpf == string.Empty)
{
throw new ArgumentException("O campo CPF deve ser preenchido");
}
if (employees.ds_sex == string.Empty)
{
throw new ArgumentException("O campo sexo deve ser preenchido");
}
if (employees.ds_sex == "Masculino")
{
employees.ds_sex = "M";
}
else
{
employees.ds_sex = "F";
}
if (employees.ds_state == string.Empty)
{
throw new ArgumentException("O campo Estado deve ser preenchido");
}
if (employees.nr_cep == string.Empty)
{
throw new ArgumentException("O campo CEP deve ser preenchido");
}
if (employees.ds_address == string.Empty)
{
throw new ArgumentException("O campo endereço deve ser preenchido");
}
if (employees.ds_note == string.Empty)
{
throw new ArgumentException("O campo complemento deve ser preenchido");
}
if (employees.nr_cellphone == string.Empty && employees.nr_tellphone == string.Empty)
{
throw new ArgumentException("Celular ou Telefone devem ser preenchidos");
}
if (employees.ds_email == string.Empty)
{
throw new ArgumentException("O campo nome deve ser preenchido");
}
if (employees.pw_password == string.Empty)
{
throw new ArgumentException("O campo nome deve ser preenchido");
}
Regex regex = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$");
Match match = regex.Match(employees.ds_email);
if (match.Success == false)
{
throw new ArgumentException(employees.ds_email + " é um e-mail inválido!");
}
Model.EmployeesModel.firstName = employees.nm_firstName;
Model.EmployeesModel.lastName = employees.nm_lastName;
Model.EmployeesModel.RG = employees.nr_rg;
Model.EmployeesModel.CPF = employees.nr_cpf;
Model.EmployeesModel.dependents = employees.nr_dependents;
Model.EmployeesModel.sex = employees.ds_sex;
Model.EmployeesModel.birth = employees.dt_birth;
Model.EmployeesModel.state = employees.ds_state;
Model.EmployeesModel.CEP = employees.nr_cep;
Model.EmployeesModel.address = employees.ds_state;
Model.EmployeesModel.note = employees.ds_note;
Model.EmployeesModel.cellphone = employees.nr_cellphone;
Model.EmployeesModel.tellphone = employees.nr_tellphone;
Model.EmployeesModel.email = employees.ds_email;
Model.EmployeesModel.password = employees.pw_password;
Model.EmployeesModel.manager = Convert.ToBoolean(employees.bt_manager);
Model.EmployeesModel.employeer = Convert.ToBoolean(employees.bt_employee);
Model.EmployeesModel.RH = Convert.ToBoolean(employees.bt_rh);
Model.EmployeesModel.financial = Convert.ToBoolean(employees.bt_financial);
Model.EmployeesModel.stock = Convert.ToBoolean(employees.bt_stock);
Model.EmployeesModel.CRM = Convert.ToBoolean(employees.bt_crm);
db.Alterar(employees);
}
public Database.Entities.tb_employees ConsultarPorID(int id)
{
Database.Entities.tb_employees employees = db.ConsultaPorID(id);
return(employees);
}
