private void RemoveEmployeeFromTerminal()
{
try
{
_dtCtrl = Properties.Settings.Default.IsClient ? RemoteDataController.Instance : LocalDataController.Instance;
List <UndeletedEmployeeNumber> undelEmployeeNumberList = null;
lock (_dtCtrl)
{
undelEmployeeNumberList = _dtCtrl.GetUndeletedEmployeeNumberList();
}
foreach (UndeletedEmployeeNumber undelEmployeeNumber in undelEmployeeNumberList)
{
Terminal terminal = null;
lock (_dtCtrl)
{
terminal = _dtCtrl.GetTerminal(undelEmployeeNumber.TerminalID);
}
_terCtrl = new TerminalController();
if (_terCtrl.RemoveEmployee(terminal, undelEmployeeNumber.EmployeeNumber))
{
bool deleted = false;
lock (_dtCtrl)
{
deleted = _dtCtrl.DeleteUndeletedEmployeeNumber(undelEmployeeNumber);
}
if (deleted == false)
{
throw new Exception();
}
}
else
{
throw new Exception();
}
}
Thread.Sleep(_timeToSleep2);
RemoveEmployeeFromTerminal();
}
catch
{
Thread.Sleep(_timeToSleep1);
RemoveEmployeeFromTerminal();
}
}
private void RemoveEmployeeFromTerminal()
{
try
{
_dtCtrl = Properties.Settings.Default.IsClient ? RemoteDataController.Instance : LocalDataController.Instance;
List<UndeletedEmployeeNumber> undelEmployeeNumberList = null;
lock (_dtCtrl)
{
undelEmployeeNumberList = _dtCtrl.GetUndeletedEmployeeNumberList();
}
foreach (UndeletedEmployeeNumber undelEmployeeNumber in undelEmployeeNumberList)
{
Terminal terminal = null;
lock (_dtCtrl)
{
terminal = _dtCtrl.GetTerminal(undelEmployeeNumber.TerminalID);
}
_terCtrl = new TerminalController();
if (_terCtrl.RemoveEmployee(terminal, undelEmployeeNumber.EmployeeNumber))
{
bool deleted = false;
lock (_dtCtrl)
{
deleted = _dtCtrl.DeleteUndeletedEmployeeNumber(undelEmployeeNumber);
}
if (deleted == false)
throw new Exception();
}
else
{
throw new Exception();
}
}
Thread.Sleep(_timeToSleep2);
RemoveEmployeeFromTerminal();
}
catch
{
Thread.Sleep(_timeToSleep1);
RemoveEmployeeFromTerminal();
}
}
private void ClearDB()
{
_dtCtrl.BeginTransaction();
try
{
Invoke(new SetTextCallBack(SetText), new object[] { txtProgress, "Clearing..." });
//clear undel employee
foreach (UndeletedEmployeeNumber undelEmp in _dtCtrl.GetUndeletedEmployeeNumberList())
{
_dtCtrl.DeleteUndeletedEmployeeNumber(undelEmp);
}
//clear uncal att records
_dtCtrl.DeleteAllUncalculatedAttendanceRecord();
//clear att reports
_dtCtrl.DeleteAllAttendanceReport();
//clear att records
_dtCtrl.DeleteAllAttendanceRecord();
//clear employee
foreach (Employee emp in _dtCtrl.GetEmployeeList())
{
//clear employee terminal
_dtCtrl.DeleteEmployeeTerminalByEmployee(emp.EmployeeNumber);
_dtCtrl.DeleteEmployee(emp.PayrollNumber);
}
//clear employee number
//clear department
foreach (Department dep in _dtCtrl.GetDepartmentList())
{
if (dep.ID != 1)
{
_dtCtrl.DeleteDepartment(dep.ID);
}
}
//clear company
foreach (Company com in _dtCtrl.GetCompanyList())
{
if (com.ID != 1)
{
_dtCtrl.DeleteCompany(com.ID);
}
}
//clear working calendar
foreach (WorkingCalendar wCal in _dtCtrl.GetWorkingCalendarList())
{
List <Shift> shiftList = _dtCtrl.GetShiftListByWorkingCalendar(wCal.ID);
foreach (Shift shift in shiftList)
{
_dtCtrl.DeleteShift(shift.ID);
}
_dtCtrl.DeleteWorkingCalendar(wCal.ID);
}
//clear pay period
_dtCtrl.CommitTransaction();
Invoke(new SetTextCallBack(SetText), new object[] { txtProgress, "Clearing Complete." });
}
catch (Exception ex)
{
_dtCtrl.RollbackTransaction();
Invoke(new AddTextCallBack(SetText), new object[] { txtProgress, "Error: " + ex.Message });
}
}
