public static string Execute(string[] command)
{
int years;
if (!int.TryParse(command[1], out years) || years < 0)
{
throw new ArgumentException("Invalid Id");
}
var result = new StringBuilder();
using (var db = new HomeworkDbContext())
{
var employees = db.Employees
.Include(x => x.Manager)
.ThenInclude(x => x.FirstName)
.ProjectTo <ListEmployeesOlderThanDto>()
.ToList();
if (!employees.Any())
{
throw new ArgumentException($"No employees older than {years}");
}
foreach (var e in employees)
{
var manager = e.Manager == null ? "[no manager]" : e.Manager.LastName;
result.AppendLine($"{e.FirstName} {e.LastName} - ${e.Salary:f2} - Manager: {manager}");
}
}
return(result.ToString());
}
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, HomeworkDbContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.ConfigureCustomExceptionHandler();
app.UseSwagger();
app.UseSwaggerUI(c =>
{
c.SwaggerEndpoint("/swagger/v1/swagger.json", "HW3");
});
//app.UseHttpsRedirection();
app.UseCors(bulder =>
bulder.AllowAnyHeader()
.AllowAnyMethod()
.AllowCredentials()
.WithOrigins("http://localhost:4200"));
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
});
context.Database.Migrate();
}
public static string Execute(string[] command)
{
int id;
if (!int.TryParse(command[1], out id))
{
throw new ArgumentException("Invalid Id");
}
var result = new StringBuilder();
using (var db = new HomeworkDbContext())
{
var employee = db.Employees
.Find(id);
var dto = Mapper.Map <EmployeeDto>(employee);
if (dto == null)
{
throw new ArgumentException("No Employee with that id !");
}
result.Append($"ID: {id} - {dto.FirstName} {dto.LastName} - ${dto.Salary:f2}");
}
return(result.ToString());
}
// TODO: reverse
//[Authorize(Roles = "Student")]
public ActionResult Student()
{
HomeworkDbContext homeworkDb = new HomeworkDbContext();
// TODO: get homework by courseID
List <Homework> model = (from homework in homeworkDb.DbSet select homework).ToList();
return(View(model));
}
private static void ResetDatabase()
{
using (var db = new HomeworkDbContext())
{
db.Database.EnsureDeleted();
db.Database.EnsureCreated();
}
}
public static string Execute(string[] command)
{
var id = int.Parse(command[1]);
var address = string.Join(" ", command.Skip(2));
using (var db = new HomeworkDbContext())
{
var employee = db.Employees.Find(id);
employee.Address = address;
db.SaveChanges();
}
return("Address is set");
}
public static string Execute(string[] command)
{
var id = int.Parse(command[1]);
var date = DateTime.ParseExact(command[3], "dd-MM-yyyy", CultureInfo.InvariantCulture);
using (var db = new HomeworkDbContext())
{
var employee = db.Employees.Find(id);
employee.BirthDay = date;
db.SaveChanges();
}
return($"Birthday is set");
}
public static string Execute(string[] command)
{
var empId = int.Parse(command[1]);
var manId = int.Parse(command[2]);
using (var db = new HomeworkDbContext())
{
var employee = db.Employees.Find(empId);
var manager = db.Employees.Find(manId);
manager.Employees.Add(employee);
db.SaveChanges();
}
return($"Manager with Id {manId} is now a Manager to Employee with Id {empId}");
}
public static string Execute(string[] command)
{
int id;
if (!int.TryParse(command[1], out id))
{
throw new ArgumentException("Invalid Id");
}
var result = new StringBuilder();
using (var db = new HomeworkDbContext())
{
var employee = db.Employees.Find(id);
var dto = Mapper.Map <EmployeeDto>(employee);
if (dto == null)
{
throw new ArgumentException("No Employee with that id !");
}
var date = "no date !";
var address = employee.Address;
if (employee.BirthDay != null)
{
date = employee.BirthDay.ToString();
}
if (employee.Address == null)
{
address = "No Address";
}
result.Append($"ID: {id} - {dto.FirstName} {dto.LastName} - ${dto.Salary:f2}"
+ Environment.NewLine
+ $"Birthday: {date}"
+ Environment.NewLine
+ $"Address: {address}");
}
return(result.ToString());
}
public static string Execute(string[] command)
{
int id;
try
{
id = int.Parse(command[1]);
}
catch (Exception)
{
throw new ArgumentException("invalid id");
}
var result = new StringBuilder();
using (var db = new HomeworkDbContext())
{
var manager = db.Employees
.Include(x => x.Employees)
.SingleOrDefault(x => x.Id == id);
if (manager == null)
{
throw new ArgumentException("There is No Person With That Id !");
}
var dto = Mapper.Map <ManagerDto>(manager);
if (dto.EmployeesCount == 0)
{
throw new ArgumentException($"{dto.FirstName} is not a manager !");
}
result.AppendLine($"{dto.FirstName} {dto.LastName} | Employees: {dto.EmployeesCount}");
foreach (var e in dto.Employees)
{
result.AppendLine($"- {e.FirstName} {e.LastName} - ${e.Salary:f2}");
}
}
return(result.ToString());
}
public static string Execute(string[] command)
{
var firstName = command[1];
var lastName = command[2];
var salary = decimal.Parse(command[3]);
using (var db = new HomeworkDbContext())
{
var employee = new EmployeeDto()
{
FirstName = firstName,
LastName = lastName,
Salary = salary
};
db.Employees.Add(Mapper.Map <Employee>(employee));
db.SaveChanges();
}
return($"Employee {firstName} {lastName} with Salary {salary} was added");
}
public ProductController(HomeworkDbContext context)
{
_context = context;
}
public Repository(HomeworkDbContext context, IUnitOfWork unitOfWork)
{
_context = context;
this.unitOfWork = unitOfWork;
}
public UnitOfWork(HomeworkDbContext context)
{
_context = context;
}
public CategoriesController(HomeworkDbContext context)
{
_context = context;
}
