static void Main(string[] args)
{
var context = new employeesContext();
// Select
{
foreach (var department in context.Departments)
{
Console.WriteLine(department.DeptName);
}
}
// Update
{
var department = context.Departments.FirstOrDefault(d => d.DeptNo == "d002");
department.DeptName = "Money"; // Finances => Money
context.SaveChanges();
}
// Delete
{
var department = context.Departments.FirstOrDefault(d => d.DeptNo == "d002");
context.Departments.Remove(department);
context.SaveChanges();
}
}
static void Main(string[] args)
{
Console.Write("Digite o código do departamento: ");
string codigo = Console.ReadLine();
using (var db = new employeesContext())
{
var GerenteDoDepartamento = db.DeptManager
.Include(gd => gd.DeptNoNavigation)
.Include(gd => gd.EmpNoNavigation)
.Where(gd => gd.DeptNoNavigation.DeptNo == codigo)
.OrderBy(gd => gd.ToDate);
foreach (var GerenteDepartamento in GerenteDoDepartamento)
{
Departments departamento = GerenteDepartamento.DeptNoNavigation;
Employees gerente = GerenteDepartamento.EmpNoNavigation;
if (gerente.Gender == "M")
{
Console.WriteLine($"{departamento.DeptName}: administrado pelo Sr. {gerente.LastName}");
}
else if (gerente.Gender == "F")
{
Console.WriteLine($"{departamento.DeptName}: administrado pela Sra. {gerente.LastName}");
}
}
}
}
public UMAuthentication(
IHttpContextAccessor contextAccessor,
Cryptography cryptography,
IOptions <AuthOptions> authenticationConfiguration,
employeesContext context)
{
_httpContext = contextAccessor.HttpContext;
_cryptography = cryptography;
_authenticationConfiguration = authenticationConfiguration.Value;
_context = context;
}
static void Main(string[] args)
{
string filtro;
Console.WriteLine(" --- Localizar departamento --- ");
using (var db = new employeesContext())
{
var todosDeptos = db.Departments;
foreach (var departamentos in todosDeptos)
{
string listaNomeDepto = departamentos.DeptName;
string listaCodDepto = departamentos.DeptNo;
Console.WriteLine($"Para {listaNomeDepto}, digite {listaCodDepto}");
}
}
Console.WriteLine("Digite o código do departamento desejado:");
filtro = Console.ReadLine();
using (var db = new employeesContext())
{
var emp = db.Employees;
var depto = db.Departments.Include(deptoManager => deptoManager.DeptManager).SingleOrDefault(d => d.DeptNo == filtro);
if (depto != null)
{
Console.WriteLine($"O departamento informado foi: {depto.DeptName}");
foreach (var m in depto.DeptManager.Where(filter => filter.ToDate.Year > 2019))
{
var idEmpregado = m.EmpNo;
foreach (var empreg in db.Employees.Where(loc => loc.EmpNo == idEmpregado))
{
if (empreg.Gender == "M")
{
Console.WriteLine($"{depto.DeptName} Managed by Mr. {empreg.FirstName}.");
}
else if (empreg.Gender == "F")
{
Console.WriteLine($"{depto.DeptName} Managed by Mrs. {empreg.FirstName}.");
}
;
}
}
}
else
{
Console.WriteLine("Departamento não localizado");
}
}
}
static void Main(string[] args)
{
Console.WriteLine("Lista dos funcionários mais antigos, masculino e feminino:");
using (var db = new employeesContext())
{
var masculino = db.Employees.Where(m => m.Gender == "M").First();
string sobrenomeM = masculino.LastName.ToUpper();
string nomeM = masculino.FirstName;
string generoM = masculino.Gender;
Console.WriteLine($"{sobrenomeM}, {nomeM}. Gênero: {generoM}");
var feminino = db.Employees.Where(f => f.Gender == "F").First();
string sobrenomeF = feminino.LastName.ToUpper();
string nomeF = feminino.FirstName;
string generoF = feminino.Gender;
Console.WriteLine($"{sobrenomeF}, {nomeF}. Gênero: {generoF}");
}
}
static void Main(string[] args)
{
string cd;
Console.Write("Olá usuário, digite o código do departamento:");
cd = Console.ReadLine();
using (var db = new employeesContext())
{
var GerenteDoDepartamento = db.DeptManager
.Include(gd => gd.DeptNoNavigation)
.Include(gd => gd.EmpNoNavigation)
.Where(gd => gd.DeptNoNavigation.DeptNo == cd)
.OrderBy(gd => gd.ToDate);
foreach (var GerenteDepartamento in GerenteDoDepartamento)
{
Departments depart = GerenteDepartamento.DeptNoNavigation;
Employees ger = GerenteDepartamento.EmpNoNavigation;
Console.WriteLine($"{depart.DeptName}, gerido por {ger.LastName}.");
}
}
}
public UserRegistrationController(employeesContext employeeRegistration, Cryptography cryptography, UMAuthentication emAuth)
{
_emAuth = emAuth;
_employeeRegistration = employeeRegistration;
_cryptography = cryptography;
}
public UserManagementController(employeesContext context, Cryptography cryptography)
{
_context = context;
_cryptography = cryptography;
}
public DepartmentController(employeesContext context)
{
_context = context;
}
public RegistrationController(employeesContext context)
{
_context = context;
}
public EmployeeController(employeesContext context)
{
_context = context;
}
