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