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(); }