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; }
/// <summary> /// Checks input looking for password /// <param name="input">Admin action selector</param> /// </summary> public static bool IsAdmin(string input) { EmployeesDatabase employees = new EmployeesDatabase(); foreach (var emp in employees.Employees) { if (emp.Password == input) { adminName = emp.Name; return(true); } } return(false); }
/// <summary> /// Returns following JsonObject: /// { /// "phone numbers" : { "work" : "425-555-0123", "home": "425-555-0134" } /// "reporting employees" : /// { /// "software developers" : /// { /// "full time employees" : /JsonObject of 3 employees from database/ /// "intern employees" : /JsonObject of 2 employees from database/ /// }, /// "HR" : /JsonObject of 10 employees from database/ /// } /// } /// </summary> /// <returns></returns> public static JsonObject GetManager() { var manager = GetNextEmployee().Value as JsonObject; manager.Add ( "phone numbers", new JsonObject() { { "work", "425-555-0123" }, { "home", "425-555-0134" } } ); manager.Add ( "reporting employees", new JsonObject { { "software developers", new JsonObject { { "full time employees", new JsonObject { EmployeesDatabase.GetNextEmployee(), EmployeesDatabase.GetNextEmployee(), EmployeesDatabase.GetNextEmployee(), } }, { "intern employees", new JsonObject { EmployeesDatabase.GetNextEmployee(), EmployeesDatabase.GetNextEmployee(), } } } }, { "HR", new JsonObject { { "full time employees", new JsonObject(EmployeesDatabase.GetTenBestEmployees()) } } } } ); return(manager); }
public void Delete(EmployeeBindingModel model) { using (var context = new EmployeesDatabase()) { var employee = context.Employees.FirstOrDefault(rec => rec.Id == model.Id); if (employee != null) { context.Employees.Remove(employee); context.SaveChanges(); } else { throw new Exception("Элемент не найден"); } } }
public List <EmployeeViewModel> Read(EmployeeBindingModel filter) { using (var context = new EmployeesDatabase()) { return(context.Employees .Where(rec => filter == null || rec.Id == filter.Id) .ToList() .Select(rec => new EmployeeViewModel { Id = rec.Id, Name = rec.Name, Surname = rec.Surname, Patronymic = rec.Patronymic, Position = rec.Position, VacationStart = rec.VacationStart }) .ToList()); } }
public void CreateOrUpdate(EmployeeBindingModel model) { Employee employee; using (var context = new EmployeesDatabase()) { if (model.Id.HasValue) { employee = context.Employees.FirstOrDefault(rec => rec.Id == model.Id); if (employee == null) { throw new Exception("Элемент не найден"); } } else { employee = new Employee { Name = model.Name, Surname = model.Surname, Patronymic = model.Patronymic, VacationStart = model.VacationStart, Position = model.Position }; context.Employees.Add(employee); context.SaveChanges(); return; } employee.Name = model.Name; employee.Surname = model.Surname; employee.Patronymic = model.Patronymic; employee.VacationStart = model.VacationStart; employee.Position = model.Position; context.SaveChanges(); } }