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