public TaskRDG(int TaskID, WorkerRDG Worker, Transaction trans)
{
this._taskID = TaskID;
this._worker = Worker;
this.trans = trans;
cmd = new SqlCommand();
}
public void ReassignTask(int TaskID, string WorkerUsername)
{
Transaction trans = new Transaction();
WorkerRDG worker = new WorkerRDG(WorkerUsername);
TaskRDG task = new TaskRDG(TaskID, worker, trans);
trans.BeginTransaction();
try
{
task.ReassignTask();
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
trans.Commit();
}
public List<WorkerDTO> GetAllWorkers()
{
Transaction trans = new Transaction();
List<WorkerDTO> LowDTO;
WorkerRDG wRDG = new WorkerRDG(trans);
trans.BeginTransaction();
try
{
LowDTO = wRDG.GetAllWorkers();
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
trans.Commit();
return LowDTO;
}
public List<TaskDTO> GetAllTasksFromWorker(string Username)
{
Transaction trans = new Transaction();
WorkerRDG WRDG = new WorkerRDG(Username);
TaskRDG TRDG = new TaskRDG(WRDG, trans);
List<TaskDTO> ListOfTasks = new List<TaskDTO>();
trans.BeginTransaction();
try
{
ListOfTasks = TRDG.GetAllTasksFromWorker(TRDG);
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
trans.Commit();
return ListOfTasks;
}
public TaskRDG(WorkerRDG Worker, Transaction trans)
{
_worker = Worker;
this.trans = trans;
cmd = new SqlCommand();
}
