public string INSS() { tb_financial financial = DB.tb_financial.First(t => t.id_emp == id); double bruto = Convert.ToDouble(financial.vl_grossSalary); if (bruto <= 1659.38) { inss = bruto * 0.08; } if (bruto > 1659.38 && bruto <= 2765.66) { inss = bruto * 0.09; } if (bruto >= 2765.67 && bruto <= 5531.31) { inss = bruto * 0.11; } if (bruto > 5531.31) { inss = 00.00; } SL = SL - inss; return("R$ " + inss.ToString()); }
public string FGTS() { tb_financial F = DB.tb_financial.First(t => t.id_emp == id); double fgts = Convert.ToDouble(F.vl_grossSalary) * 0.08; return("R$ " + fgts.ToString()); }
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); }
public string VericarParametros(tb_financial fin) { if (fin.vl_grossSalary == Convert.ToDecimal(0.0)) { return("Salário Obrigatório!"); } if (fin.ds_typeSalary == string.Empty) { return("Tipo de Salário Obrigatório!"); } return(string.Empty); }
private tb_financial ReadFinancial() { tb_financial fin = new tb_financial(); fin.vl_grossSalary = nudSalárioBruto.Value; fin.dt_fromDate = DateTime.Now.ToShortDateString(); fin.dt_toDate = "01/01/9998"; fin.ds_typeSalary = cboTipoDeSalário.Text; fin.dt_fromDate = DateTime.Now.ToString("dd/MM/yyyy"); fin.dt_toDate = "01/01/9998"; return(fin); }
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 void SaveFinancials(TurnKeyBrokerSignUpDataContext dataContext, int accountId, string annual_income, string tax_rate, string net_worth, string liquid_net_worth, string annual_expense, string special_expense, string special_expense_time, bool isDebug) { if (dataContext == null) { dataContext = new TurnKeyBrokerSignUpDataContext(); } tb_financial financial; int update = 0; var tb_financial = dataContext.tb_financials.Where(t => t.account_id == accountId).FirstOrDefault(); if (tb_financial != null) { financial = tb_financial; update = 1; } else { financial = new tb_financial(); } financial.account_id = accountId; financial.annual_income = annual_income; financial.tax_rate = tax_rate; financial.net_worth = net_worth; financial.liquid_net_worth = liquid_net_worth; financial.annual_expense = annual_expense; financial.special_expense = special_expense; financial.special_expense_time = special_expense_time; financial.date_created = DateTime.Now; if (update == 0) { dataContext.tb_financials.InsertOnSubmit(financial); } if (!isDebug) { dataContext.SubmitChanges(); } }
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()); }
public string ValeTransporte(int ano, int mes) { Model.PayrollModel.Tarifa = Convert.ToDecimal(8.60); tb_benefits tb = DB.tb_benefits.First(t => t.id_emp == id); tb_financial F = DB.tb_financial.First(t => t.id_emp == id); if (tb.bt_transport == true) { int qtdDiasUteis = this.QtdDeDiasUteis(ano, mes); double VL = Convert.ToDouble(Model.PayrollModel.Tarifa) * qtdDiasUteis; double bruto = Convert.ToDouble(F.vl_grossSalary); SL = bruto - (bruto * 0.06); return("R$ " + VL.ToString()); } else { return("R$ 00,00"); } }
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 void insirir(tb_financial fin, int id) { fin.id_emp = id; db.Inserir(fin); }
public string Bruto() { tb_financial tb = DB.tb_financial.First(t => t.id_emp == id); return("R$ " + tb.vl_grossSalary); }
public void Remover(tb_financial fin) { db.Remover(fin); }
public void Alterar(tb_financial fin, int id) { fin.id_emp = id; db.Alterar(fin); }