public ActionResult Delete(ulong id)
{
DBQuery dbq = new DBQuery();
VacationRequest vr = dbq.SelectVacationRequest(id);
int netWorkingDays = vr.getNetVacationDays();
int remainingVacationDays = dbq.SelectRemainingVacationDays(vr.getEmployeeID());
Boolean update = dbq.UpdateRemainingVacationDays(vr.getEmployeeID(), netWorkingDays + remainingVacationDays);
if (update)
{
Boolean result = dbq.DeleteVacationRequest(id);
if (result)
{
ErrorState.ErrorStateInstance.setError(ErrorState.DATABASE_ERROR);
TempData["success"] = "Der Urlaubsantrag wurde erfolgreich gelöscht";
}
else
{
ErrorState.ErrorStateInstance.setError(ErrorState.DATABASE_ERROR);
//TempData["error"] = "Die Änderung konnte nicht in die Datenbank übernommen werden!";
}
}
else
{
ErrorState.ErrorStateInstance.setError(ErrorState.DATABASE_ERROR);
//TempData["error"] = "Die Änderung konnte nicht in die Datenbank übernommen werden!";
}
int lastError = ErrorState.ErrorStateInstance.getLastError();
if (lastError != ErrorState.OK)
{
TempData["error"] = "Der Urlaubsantrag konnte nicht gelöscht werden. Grund: " + ErrorState.ErrorStateInstance.getErrorMessage(lastError);
}
return RedirectToAction("All");
}
private Boolean RestoreVacationDaysInEmployeeVacationEntitlement(VacationRequest vacationRequest)
{
Boolean result = false;
DBQuery dbq = new DBQuery();
int netWorkingDays = vacationRequest.getNetVacationDays();
int remainingVacationDays = dbq.SelectRemainingVacationDays(vacationRequest.getEmployeeID());
result = dbq.UpdateRemainingVacationDays(vacationRequest.getEmployeeID(), netWorkingDays + remainingVacationDays);
return result;
}
/// <summary>
/// 1. writes an information email
/// 2. writes vacation request in the database
/// </summary>
/// <returns>Boolean status if the insert into database was successful</returns>
private Boolean SendDataToDB()
{
Boolean result = false;
DBQuery dbq = new DBQuery();
result = dbq.InsertNewVacationRequest(this);
if (result)
{
int remainingVacationDays = dbq.SelectRemainingVacationDays(_employeeID) - this._netVacationDays;
result = dbq.UpdateRemainingVacationDays(_employeeID, remainingVacationDays);
}
if (!result)
{
ErrorState.ErrorStateInstance.setError(ErrorState.DATABASE_ERROR);
}
return result;
}