/// <summary>
/// informs the respective persons about the new status
/// </summary>
/// <param name="VacationRequest">VacationRequest of the Requester</param>
/// <param name="message">Content of email</param>
/// <returns></returns>
public void sendMessage(VacationRequest vacationRequest, String message)
{
DBQuery dbq = new DBQuery();
if (message.Equals("SUBMISSION"))
{
Employee deputy = dbq.SelectDeputy(vacationRequest.getEmployeeID());
Employee divisionManager = dbq.SelectDivisionManager(vacationRequest.getEmployeeID());
// TODO: implement Email sending procedure
}
else if (message.Equals("AGREED"))
{
Employee divisionManager = dbq.SelectDivisionManager(vacationRequest.getEmployeeID());
Employee requester = dbq.SelectRequester(vacationRequest.getVacationRequestID());
// TODO: implement Email sending procedure
}
else if (message.Equals("PERMITTED"))
{
}
else if (message.Equals("REJECTED"))
{
Employee requester = dbq.SelectRequester(vacationRequest.getVacationRequestID());
// TODO: implement Email sending procedure
}
}
/// <summary>
/// Dependent on the checktype, method checks either for overlaps between the new submitted vacation request and DB-stored lock periods,
/// or between overlaps with a vacation request by the deputy
/// </summary>
/// <param name="CheckType"> an int value that choose the test type</param>
/// <returns> true if no lock or overlap is present, else false</returns>
public Boolean Validate(int CheckType)
{
Boolean result = true; // assumes that no locks or overlaps exist
switch (CheckType)
{
case CHECK_CATEGORY_LOCK_PERIOD:
DBQuery dbqLock = new DBQuery();
// the DB Query checks whether on ore more lock period(s) lie(s) in vacation request time period
var lockList = dbqLock.SelectLockPeriods(_vacationRequest);
if (lockList.Count() > 0)
{
result = false;
}
break;
case CHECK_CATEGORY_VACATION_OVERLAP_PERIOD:
DBQuery dbqDeputy = new DBQuery();
String deputyID = dbqDeputy.SelectDeputy(_vacationRequest);
if ( !deputyID.Equals("null") && deputyID != String.Empty)
{
var overlapList = dbqDeputy.SelectUncanceledEmployeeVacationRequestInTimePeriod(_vacationRequest, deputyID);
if (overlapList.Count() > 0)
{
foreach (var i in overlapList)
{
//change OverlapNote of existing VacationRequest of Deputy
DBQuery dbq = new DBQuery();
dbq.UpdateVacationRequestPeriodOverlapNote(i.Item1, true);
}
result = false;
}
}
break;
default: break;
}
return result;
}
/// <summary>
/// Removes the TRUE-flag in all vacation requests of the shift partner, if the given vacation request is cancelled by its requester.
/// Use requester ID of vacation request to identity the shiftpartner and startdate and enddate to retrieve vacation requests of the deputy
/// </summary>
/// <param name="vacationRequest">use requesterID to find deputy, use time period to specify overlap time period </param>
/// <returns>TRUE if successful, else FALSE</returns>
private Boolean RemoveVacationPeriodOverlapNote(VacationRequest vacationRequest)
{
Boolean result = true;
DBQuery dbq = new DBQuery();
String deputyID = dbq.SelectDeputy(vacationRequest);
if (!deputyID.Equals("null") && deputyID != String.Empty)
{
var overlapList = dbq.SelectUncanceledEmployeeVacationRequestInTimePeriod(vacationRequest, deputyID);
if (overlapList.Count > 0)
{
foreach (var i in overlapList)
{
//change OverlapNote of existing VacationRequest of Deputy
result = dbq.UpdateVacationRequestPeriodOverlapNote(i.Item1, false);
if (!result) break;
}
}
}
return result;
}
public List<EmployeeVacationRequestViewItem> GetVacationRequests()
{
String currentUserId = User.Identity.GetUserId();
List<GUIManagement.EmployeeVacationRequestViewItem> resultList = new List<GUIManagement.EmployeeVacationRequestViewItem>();
DBQuery dbq = new DBQuery();
List<VacationManagement.VacationRequest> vacationRequestList = dbq.SelectAllVacationRequestsOfEmployee(currentUserId);
String shiftPartnerID = dbq.SelectShiftPartner(currentUserId);
String shiftParterName = "-";
if (shiftPartnerID != null)
{
Employee shiftPartner = dbq.SelectDeputy(currentUserId);
shiftParterName = dbq.SelectEmployeeFullName(shiftPartner.getEmployeeID());
}
foreach (VacationManagement.VacationRequest vr in vacationRequestList)
{
var employeeVacationRequest = new GUIManagement.EmployeeVacationRequestViewItem(vr, shiftParterName);
resultList.Add(employeeVacationRequest);
}
return resultList;
}
