public Personnel ToPersonnel(PersonnelDto personnel)
{
return(new Personnel()
{
Adress = personnel.Adress, FamilyState = personnel.FamilyState, ContactId = personnel.ContactId, DepartmentId = personnel.DepartmentId, LastName = personnel.LastName, MiddleName = personnel.MiddleName, Name = personnel.Name, PersonnelId = personnel.PersonnelId, Photo = personnel.Photo
});
}
public PersonnelDto GetPersonnelById(int id)
{
string commandName = "GetPersonnelById";
string paramString = "@personnelId";
PersonnelDto result = new PersonnelDto();
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand())
{
command.Connection = connection;
command.CommandType = CommandType.StoredProcedure;
command.CommandText = commandName;
var param = new SqlParameter();
param.DbType = DbType.Int32;
param.ParameterName = paramString;
param.Value = id;
command.Parameters.Add(param);
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet dataSet = new DataSet();
adapter.Fill(dataSet);
foreach (DataTable table in dataSet.Tables)
{
foreach (DataRow dataRow in table.Rows)
{
result = new PersonnelDto {
PersonnelId = (int)dataRow[0], Name = (string)dataRow[1], LastName = (string)dataRow[2], MiddleName = (string)dataRow[3], DepartmentId = (int)dataRow[4], Adress = (string)dataRow[5], FamilyState = (bool)dataRow[6], Photo = (string)dataRow[7]
};
}
}
}
}
return(result);
}
public PersonnelDto GetPersonnelById(int id)
{
var service = new PersonnelDepartmentServiceClient();
service.Open();
PersonnelDto result = service.GetPersonnelById(id);
service.Close();
return(result);
}
private string GenerateDutyRequestContent(PersonnelDto personnel
, Duty duty, RequestDuration duration, DateTime from, DateTime to)
{
return("request type : "
+ " " + (duration == RequestDuration.Daily ? "daily" : "hourly")
+ "duty" + " " + duty.Title
+ ", requested by: " + (personnel.Gender == Gender.Male ? "Mr." : "Mrs.")
+ "" + personnel.FullName
+ $", from date: {from.ToShortDateString()} to date:" +
$" {to.ToShortDateString()}.");
}
public async Task <IActionResult> Create(PersonnelHolidayDto personnelHoliday)
{
personnelHoliday.PersonnelId = Convert.ToInt32(TempData["Id"]);
PersonnelDto personnelDto = _personnelService.GetWithIPersonnelHolidayGetByAsync(personnelHoliday.PersonnelId);
if (_personnelService.GetControl(personnelDto, personnelHoliday)) //aynı departmandan girilen tarihler arasında personel iznini sorgular
{
await _personnelHolidayService.AddAsync(_mapper.Map <PersonnelHoliday>(personnelHoliday));
}
return(RedirectToAction("Index", "Personnel"));
}
private string GenerateShiftReplacementRequestContent(PersonnelDto personnel
, PersonnelDto replacedPersonnel, string shiftTitle
, string workingHourTitle, string replacedWorkingHourTitle, DateTime date)
{
return("request type: shift replacement"
+ " " + ", requested by: "
+ (personnel.Gender == Gender.Male ? "Mr." : "Mrs.")
+ "" + personnel.FullName + "replace with" + " "
+ (replacedPersonnel.Gender == Gender.Male ? "Mr." : "Mrs.")
+ "" + replacedPersonnel.FullName
+ $" shift title: {shiftTitle}, working hour title: {workingHourTitle}"
+ " " + "replace with" + $" working hour title: {replacedWorkingHourTitle}"
+ $", requested date: {date.ToShortDateString()}.");
}
public IHttpActionResult CreatePersonnel(PersonnelDto personnelDto)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var personnel = Mapper.Map <PersonnelDto, KhadamatMashiniPersonnel>(personnelDto);
_db.KhadamatMashiniPersonnels.Add(personnel);
_db.SaveChanges();
personnelDto.Id = personnel.Id; // assign generated id by DB for personnel to Dto object
return(Created(new Uri(Request.RequestUri + "/" + personnel.Id), personnelDto));
}
public IHttpActionResult UpdatePersonnel(int id, PersonnelDto personnelDto)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
var personnelInDb = _db.KhadamatMashiniPersonnels.SingleOrDefault(k => k.Id == id);
if (personnelInDb == null)
{
return(NotFound());
}
Mapper.Map(personnelDto, personnelInDb);
_db.SaveChanges();
return(Ok());
}
public IActionResult Personnel(string search, int competitionId)
{
ViewData["CurrentFilter"] = search;
var competition = _competitionService.GetCompetitionByIdAsync(competitionId);
competition.Wait();
var usersDto = _adminService.GetUsers();
if (!String.IsNullOrEmpty(search))
{
var searchToUpper = search.ToUpper();
usersDto = usersDto.Where(u => u.FirstName.ToUpper().Contains(searchToUpper) ||
u.LastName.ToUpper().Contains(searchToUpper) ||
u.Username.ToUpper().Contains(searchToUpper));
}
var assignedRoles = _competitionService.GetAllRolesForCompetition(competitionId);
var roles = new Role();
var newUsersDto = new List <UserDto>();
//TODO: Þetta tekur alltof langan tíma að loada 3000ms
//TODO: Þarf mögulega að setja cache virkni hér þegar fleiri users bætast við
foreach (var item in usersDto)
{
if (assignedRoles.FirstOrDefault(x => x.UserId == item.Id) == null)
{
newUsersDto.Add(item);
}
}
var personnelDto = new PersonnelDto()
{
AssignedRoles = assignedRoles.OrderBy(x => x.FirstName),
Competition = competition.Result,
Roles = roles,
Users = newUsersDto.OrderBy(x => x.FirstName).Take(10)
};
return(View(personnelDto));
}
public bool GetControl(PersonnelDto personnelDto, PersonnelHolidayDto personnelHoliday)
{
return(_unitOfWork.Personnels.GetControl(personnelDto, personnelHoliday));
}
public async Task <IActionResult> GetById(int id)
{
PersonnelDto personels = await _personnelService.GetWithIPersonnelHolidayGetByAsync(id);
return(Ok(_mapper.Map <PersonnelWithPersonnelHolidayDto>(personels)));
}
