public async Task <HelperDTO> GetByIdAsync(int id)
{
if (string.IsNullOrEmpty(id.ToString()))
{
return(null);
}
HelperModel user = await _context.Helper.AsNoTracking().FirstOrDefaultAsync(c => c.Id == id);
HelperDTO result = new HelperDTO
{
DateCreated = user.DateCreated,
Id = user.Id,
Religion = user.Religion,
Qualification = user.Qualification,
Guarantor = string.Concat(user.Guarantor.Surname, " ", user.Guarantor.FirstName, " ", user.Guarantor.LastName),
FirstName = user.FirstName,
Gender = user.Gender,
LastName = user.LastName,
DateOfBirth = user.DateOfBirth,
State = user.State,
Surname = user.Surname
};
_context.Dispose();
return(result);
}
/// <see cref="EmployeeRepository.GetById"/>
public EmployeeDTO GetById(int employeeId)
{
var repositoryResult = EmployeeRepository.GetById(employeeId);
var returnValue = HelperDTO.CreateEmployeeDTO(repositoryResult);
return(returnValue);
}
public async Task <bool> AddAsync(HelperDTO user)
{
try
{
HelperModel helper = new HelperModel()
{
FirstName = user.FirstName,
LastName = user.LastName,
Surname = user.Surname,
Gender = user.Gender,
Qualification = user.Qualification,
GuarantorId = user.GuarantorId,
Religion = user.Religion,
State = user.State,
DateOfBirth = user.DateOfBirth
};
_context.Helper.Add(helper);
await _context.SaveChangesAsync();
return(Task.CompletedTask.IsCompleted);
}
catch (Exception ex) { }
return(Task.CompletedTask.IsCanceled);
}
public async Task <bool> UpdateAsync(HelperDTO user)
{
try
{
HelperModel helper = new HelperModel()
{
Religion = user.Religion,
Qualification = user.Qualification,
FirstName = user.FirstName,
Gender = user.Gender,
LastName = user.LastName,
DateOfBirth = user.DateOfBirth,
State = user.State,
Surname = user.Surname
};
using (var context = _context)
{
context.Helper.Attach(helper);
await _context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex) { }
return(false);
}
public ActionResult <Helper> AddHelper(DateTime date, HelperDTO model)
{
CustomDay customDayToEdit = _customDayRepository.GetByDate(date);
if (customDayToEdit == null)
{
return(NotFound());
}
else
{
User user = _userRepository.GetById(model.UserId);
if (user == null)
{
return(NotFound());
}
else
{
try
{
Helper helperToAdd = new Helper(customDayToEdit, user);
customDayToEdit.AddHelper(helperToAdd);
_customDayRepository.SaveChanges();
return(Ok(helperToAdd));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
}
}
/// <see cref="EmployeeRepository.GetAll"/>
public List <EmployeeDTO> GetAll()
{
var repositoryResult = EmployeeRepository.GetAll();
var returnValue = (from record in repositoryResult
select HelperDTO.CreateEmployeeDTO(record)).ToList <EmployeeDTO>();
return(returnValue);
}
public async Task <List <EmployeeDTO> > GetAllExternal()
{
var repositoryResult = await EmployeeRepository.GetAllExternal();
var returnValue = (from record in repositoryResult
select HelperDTO.CreateEmployeeDTOExternal(record)).ToList <EmployeeDTO>();
return(returnValue);
}
public JsonResult UpdateEmployer([FromBody] HelperDTO model)
{
if (ModelState.IsValid)
{
if (model != null)
{
return(Json(_helper.UpdateAsync(model).GetAwaiter().GetResult() ? "Done" : "Failed"));
}
}
return(Json("Null value"));
}
public void AddHelper_WrongDate_ReturnsNotFound()
{
DateTime date = new DateTime(1945, 1, 1);
HelperDTO helperDTO = new HelperDTO()
{
UserId = 2
};
_customDayRepository.Setup(c => c.GetByDate(DateTime.Today)).Returns(_dummyDBContext.CustomDay1);
ActionResult <Helper> actionResult = _controller.AddHelper(date, helperDTO);
Assert.IsType <NotFoundResult>(actionResult?.Result);
_customDayRepository.Verify(a => a.SaveChanges(), Times.Never);
}
public void AddHelper_RightDateButWrongUserId_ReturnsNotFound()
{
DateTime date = DateTime.Today;
HelperDTO helperDTO = new HelperDTO()
{
UserId = 747
};
_customDayRepository.Setup(c => c.GetByDate(date)).Returns(_dummyDBContext.CustomDay1);
_userRepository.Setup(u => u.GetById(2)).Returns(_dummyDBContext.U2);
ActionResult <Helper> actionResult = _controller.AddHelper(date, helperDTO);
Assert.IsType <NotFoundResult>(actionResult?.Result);
_customDayRepository.Verify(a => a.SaveChanges(), Times.Never);
}
public void AddHelper_RightWeekIdAndDayIdButWrongUserId_ReturnsNotFound()
{
HelperDTO helperDTO = new HelperDTO()
{
UserId = 30,
DayId = 1
};
string templateName = "eerste_week_eerste_dag";
int weekNr = 1;
int dayNr = 1;
_userRepository.Setup(u => u.GetById(1)).Returns(_dummyDBContext.U1);
_dayRepository.Setup(d => d.GetByWeekAndDay(templateName, weekNr, dayNr)).Returns(_dummyDBContext.Day1);
ActionResult <Helper> actionResult = _controller.AddHelper(templateName, weekNr, dayNr, helperDTO);
Assert.IsType <NotFoundResult>(actionResult?.Result);
_dayRepository.Verify(d => d.SaveChanges(), Times.Never());
}
public void AddHelper_Succeeds()
{
HelperDTO helperDTO = new HelperDTO()
{
UserId = 3,
DayId = 1
};
string templateName = "eerste_week_eerste_dag";
int weekNr = 1;
int dayNr = 1;
_dayRepository.Setup(d => d.GetByWeekAndDay(templateName, weekNr, dayNr)).Returns(_dummyDBContext.Day1);
_userRepository.Setup(d => d.GetById(helperDTO.UserId)).Returns(_dummyDBContext.U4);
ActionResult <Helper> actionResult = _controller.AddHelper(templateName, weekNr, dayNr, helperDTO);
var response = actionResult?.Result as OkObjectResult;
Helper helper = response?.Value as Helper;
Assert.Equal("Alihan", helper?.User.FirstName);
_dayRepository.Verify(d => d.SaveChanges(), Times.Once());
}
public ActionResult <Helper> AddHelper(string templateName, int weekNr, int dayNr, HelperDTO model)
{
Day dayToEdit = _dayRepository.GetByWeekAndDay(templateName, weekNr, dayNr);
if (dayToEdit == null)
{
return(NotFound());
}
else
{
User user = _userRepository.GetById(model.UserId);
if (user == null)
{
return(NotFound());
}
else
{
try
{
Helper helperToAdd = new Helper(dayToEdit, user);
dayToEdit.AddHelper(helperToAdd);
_dayRepository.SaveChanges();
return(Ok(helperToAdd));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
}
}
