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