private tb_employees ReadEmployees()
{
tb_employees emp = new tb_employees();
emp.id_emp = EmployeesModel.ID;
emp.nm_firstName = EmployeesModel.firstName;
emp.nm_lastName = EmployeesModel.lastName;
emp.nr_rg = EmployeesModel.RG.Contains(",") ? EmployeesModel.RG.Replace(",", ".") : EmployeesModel.RG;
emp.nr_cpf = EmployeesModel.CPF;
emp.nr_dependents = EmployeesModel.dependents;
emp.ds_sex = EmployeesModel.sex;
emp.dt_birth = EmployeesModel.birth;
emp.ds_state = EmployeesModel.state;
emp.nr_cep = EmployeesModel.CEP;
emp.ds_address = EmployeesModel.address;
emp.ds_note = EmployeesModel.note;
emp.nr_cellphone = EmployeesModel.cellphone;
emp.nr_tellphone = EmployeesModel.tellphone;
emp.ds_email = EmployeesModel.email;
emp.pw_password = EmployeesModel.password;
emp.bt_manager = EmployeesModel.manager;
emp.bt_employee = EmployeesModel.employeer;
emp.bt_rh = EmployeesModel.RH;
emp.bt_provider = EmployeesModel.Provider;
emp.bt_financial = EmployeesModel.financial;
emp.bt_stock = EmployeesModel.stock;
emp.bt_crm = EmployeesModel.CRM;
emp.dt_hiring = dtpContratação.Value.ToShortDateString();
emp.dt_resignation = "01/01/9998";
return(emp);
}
public void Remover(tb_employees emp, tb_deptfunction defu, tb_timecard ticd,
tb_financial fin, tb_benefits ben, tb_bankaccount bank, tb_discounts dis)
{
defuB.Remover(defu);
ticdB.Remover(ticd);
finB.Remover(fin);
benB.Remover(ben);
bankB.Remover(bank);
disB.Remover(dis);
db.Remover(emp);
}
private void LoadControls()
{
int id = EmployeesModel.ID;
EmployeesDatabase DBemp = new EmployeesDatabase();
DeptFunctionDatabase DBdefu = new DeptFunctionDatabase();
TimeCardDatabase DBticd = new TimeCardDatabase();
FinancialDatabase DBfin = new FinancialDatabase();
BenefitsDatabase DBben = new BenefitsDatabase();
BankAccountDatabase DBbank = new BankAccountDatabase();
DiscountsDatabase DBdis = new DiscountsDatabase();
tb_employees emp = DBemp.ConsultarPorID(id);
tb_deptfunction defu = DBdefu.ConsultarPorID(id);
tb_timecard ticd = DBticd.ConsultarPorID(id);
tb_financial fin = DBfin.ConsultarPorID(id);
tb_benefits ben = DBben.ConsultarPorID(id);
tb_bankaccount bank = DBbank.ConsultarPorID(id);
tb_discounts dis = DBdis.ConsultarPorID(id);
if (emp == null)
{
return;
}
dtpContratação.Value = Convert.ToDateTime(emp.dt_hiring);
dtpDemissão.Value = Convert.ToDateTime(emp.dt_resignation);
cboDepartamento.Text = defu.nm_department;
cboCargo.Text = defu.nm_function;
nudSalárioBruto.Value = fin.vl_grossSalary;
chkValeTransporte.Checked = ben.bt_transport;
chkValeAlimentação.Checked = ben.bt_food;
chkValeRefeição.Checked = ben.bt_meal;
chkSeguroDeVida.Checked = ben.bt_lifeSafe;
chkPlanoDeSáude.Checked = ben.bt_planHealth;
chkPlanoDental.Checked = ben.bt_planDental;
nudTarifa.Value = Convert.ToDecimal(ben.vl_transport);
nudValeAlimentação.Value = Convert.ToDecimal(ben.vl_food);
nudValeRefeição.Value = Convert.ToDecimal(ben.vl_meal);
nudSeguroDeVida.Value = Convert.ToDecimal(ben.vl_lifeSafe);
nudPlanoDeSáude.Value = Convert.ToDecimal(ben.vl_planHealth);
nudPlanoDental.Value = Convert.ToDecimal(ben.vl_planDental);
txtNomeDoBanco.Text = bank.nm_bank;
mtxtAgência.Text = bank.nr_agency.ToString();
mtxtConta.Text = bank.nr_account;
cboTipoDePessoa.Text = bank.ds_typePerson;
nudPensãoAlimentícia.Value = Convert.ToDecimal(dis.vl_foodPension);
cboTipoDeSalário.Text = fin.ds_typeSalary;
mtxtEntrada.Text = ticd.hr_fixedInput;
mtxtSaída.Text = ticd.hr_fixedOutput;
mtxtInícioInt.Text = ticd.hr_fixedIntInput;
mtxtFinalInt.Text = ticd.hr_fixedIntOutput;
}
private void Insirir(tb_employees emp, tb_deptfunction defu, tb_timecard ticd,
tb_financial fin, tb_benefits ben, tb_bankaccount bank, tb_discounts dis)
{
int id = db.Insirir(emp);
defuB.Insirir(defu, id);
ticdB.Insirir(ticd, id);
finB.insirir(fin, id);
benB.Insirir(ben, id);
bankB.Insirir(bank, id);
disB.insirir(dis, id);
}
private void Alterar(tb_employees emp, tb_deptfunction defu, tb_timecard ticd,
tb_financial fin, tb_benefits ben, tb_bankaccount bank, tb_discounts dis)
{
int id = EmployeesModel.ID;
defuB.Alterar(defu, id);
ticdB.Alterar(ticd, id);
finB.Alterar(fin, id);
benB.Alterar(ben, id);
bankB.Alterar(bank, id);
disB.Alterar(dis, id);
db.Alterar(emp, id);
}
public string UpdateEmployee(tb_employees emp, tb_deptfunction defu, tb_timecard ticd,
tb_financial fin, tb_benefits ben, tb_bankaccount bank, tb_discounts dis)
{
string error = string.Empty;
if (error == string.Empty)
{
error = this.VericarParametros(emp);
}
if (error == string.Empty)
{
error = defuB.VericarParametros(defu);
}
if (error == string.Empty)
{
error = ticdB.VericarParametros(ticd);
}
if (error == string.Empty)
{
error = finB.VericarParametros(fin);
}
if (error == string.Empty)
{
error = benB.VericarParametros(ben);
}
if (error == string.Empty)
{
error = bankB.VericarParametros(bank);
}
if (error == string.Empty)
{
error = disB.VericarParametros(dis);
}
if (error == string.Empty)
{
this.Alterar(emp, defu, ticd, fin, ben, bank, dis);
return("Alterado com sucesso!");
}
else
{
return(error);
}
}
public bool Login(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 string DeleteEmployee(int id)
{
tb_employees emp = ConsultarPorID(id);
tb_deptfunction defu = defuB.ConsultarPorID(id);
tb_timecard ticd = ticdB.ConsultarPorID(id);
tb_financial fin = finB.ConsultarPorID(id);
tb_benefits ben = benB.ConsultarPorID(id);
tb_bankaccount bank = bankB.ConsultarPorID(id);
tb_discounts dis = disB.ConsultarPorID(id);
if (emp != null && defu != null && ticd != null && fin != null && ben != null && bank != null && dis != null)
{
this.Remover(emp, defu, ticd, fin, ben, bank, dis);
return("Funcionário Removido com Sucesso!");
}
else
{
return("Funcionário Inexistente!");
}
}
public string ImpostoDeRenda()
{
tb_financial financial = DB.tb_financial.First(t => t.id_emp == id);
tb_employees tb = DB.tb_employees.First(t => t.id_emp == id);
double bruto = Convert.ToDouble(financial.vl_grossSalary);
double IR = 00.00;
double aliquota = 00.00;
double dedução = 00.00;
if (bruto <= 1903.98)
{
aliquota = 0.0;
dedução = 0.0;
}
if (bruto >= 1903.99 && bruto <= 2826.65)
{
aliquota = 0.075;
dedução = 142.80;
}
if (bruto >= 2826.66 && bruto <= 3751.05)
{
aliquota = 0.15;
dedução = 354.80;
}
if (bruto >= 3751.06 && bruto <= 4664.68)
{
aliquota = 0.225;
dedução = 636.13;
}
if (bruto >= 4664.69)
{
aliquota = 0.275;
dedução = 869.36;
}
double dependentes = tb.nr_dependents * 189.59;
IR = ((bruto - dependentes - inss) * aliquota) - dedução;
return("R$ " + IR.ToString());
}
private void nudID_Leave(object sender, EventArgs e)
{
try
{
tb_employees emp = EB.ConsultarPorID(Convert.ToInt32(nudID.Value));
if (emp != null)
{
txtNome.Text = emp.nm_firstName;
txtSobrenome.Text = emp.nm_lastName;
mtxtRG.Text = emp.nr_rg;
mtxtCPF.Text = emp.nr_cpf;
nudDependentes.Value = emp.nr_dependents;
cboSexo.Text = emp.ds_sex == "M" ? "Masculino" : "Feminino";
dtpNascimento.Value = Convert.ToDateTime(emp.dt_birth);
cboEstado.Text = emp.ds_state;
mtxtCEP.Text = emp.nr_cep;
txtEndereço.Text = emp.ds_address;
txtComplemento.Text = emp.ds_note;
mtxtCelular.Text = emp.nr_cellphone;
mtxtTelefone.Text = emp.nr_tellphone;
txtEmail.Text = emp.ds_email;
txtSenha.Text = emp.pw_password;
rdbFuncionário.Checked = Convert.ToBoolean(emp.bt_employee);
rdbGerente.Checked = Convert.ToBoolean(emp.bt_manager);
chkCRM.Checked = Convert.ToBoolean(emp.bt_crm);
chkFornecedor.Checked = Convert.ToBoolean(emp.bt_provider);
chkEstoque.Checked = Convert.ToBoolean(emp.bt_stock);
chkRH.Checked = Convert.ToBoolean(emp.bt_rh);
chkFinanceiro.Checked = Convert.ToBoolean(emp.bt_financial);
}
else
{
this.EmptyControls();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ocorreu um erro!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSalvar_Click(object sender, EventArgs e)
{
try
{
tb_employees emp = this.ReadEmployees();
tb_deptfunction defu = this.ReadDeptFunction();
tb_timecard ticd = this.ReadTimeCard();
tb_financial fin = this.ReadFinancial();
tb_benefits ben = this.ReadBenefits();
tb_bankaccount bank = this.ReadBankAccount();
tb_discounts dis = this.ReadDiscounts();
EmployeesBusiness EB = new EmployeesBusiness();
string res = EB.UpdateEmployee(emp, defu, ticd, fin, ben, bank, dis);
MessageBox.Show(res, "liriou's Burguer", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Ocorreu um erro!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public string SalárioFamília()
{
tb_employees tb = DB.tb_employees.First(t => t.id_emp == id);
tb_financial financial = DB.tb_financial.First(t => t.id_emp == id);
double bruto = Convert.ToDouble(financial.vl_grossSalary);
double SF;
if (bruto <= 907.77)
{
SF = tb.nr_dependents * 46.54;
}
else if (bruto > 907.77 && bruto < 1364.43)
{
SF = tb.nr_dependents * 32.80;
}
else
{
SF = 00.00;
}
SL = SL + SF;
return("R$ " + SL.ToString());
}
public string VericarParametros(tb_employees emp)
{
if (emp.nm_firstName == string.Empty)
{
return("O campo nome deve ser preenchido!");
}
if (emp.nm_lastName == string.Empty)
{
return("O campo sobrenome deve ser preenchido!");
}
if (emp.nr_rg == string.Empty)
{
return("O campo RG deve ser preenchido!");
}
if (emp.nr_cpf == string.Empty)
{
return("O campo CPF deve ser preenchido!");
}
if (emp.ds_sex != "Masculino" && emp.ds_sex != "Feminino")
{
return("O campo sexo deve ser preenchido!");
}
if (emp.ds_sex == "Masculino")
{
emp.ds_sex = "M";
}
if (emp.ds_sex == "Feminino")
{
emp.ds_sex = "F";
}
if (emp.ds_state == string.Empty)
{
return("O campo estado deve ser preenchido!");
}
if (emp.nr_cep == string.Empty)
{
return("O campo CEP deve ser preenchido!");
}
if (emp.ds_address == string.Empty)
{
return("O campo endereço deve ser preenchido!");
}
if (emp.ds_email == string.Empty)
{
return("O campo email deve ser preenchido!");
}
if (emp.ds_email != string.Empty)
{
Regex regex = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$");
Match match = regex.Match(emp.ds_email);
if (match.Success == false)
{
return(emp.ds_email + " Não é um email válido");
}
}
if (emp.pw_password == string.Empty)
{
return("O campo senha deve ser preenchido!");
}
if (emp.bt_employee == false && emp.bt_manager == false)
{
return("Escolha Funcionario ou Gerente!");
}
if (emp.bt_manager == true && emp.bt_employee == false)
{
emp.bt_crm = true;
emp.bt_provider = true;
emp.bt_financial = true;
emp.bt_rh = true;
emp.bt_stock = true;
}
return(string.Empty);
}
public tb_employees ConsultarPorID(int id)
{
tb_employees emp = db.ReturnEmployee(id);
return(emp);
}
public string NomeCompleto()
{
tb_employees tb = DB.tb_employees.First(t => t.id_emp == id);
return(tb.nm_firstName + " " + tb.nm_lastName);
}
public string Dependents()
{
tb_employees tb = DB.tb_employees.First(t => t.id_emp == id);
return("Qtd " + tb.nr_dependents.ToString());
}
public void CarregarFuncionario(tb_employees employees)
{
this.employees = employees;
}
