public TaskRDG(ToolRDG tool, NormalUser worker, string Description, DateTime Date, Transaction trans)
{
this._tool = tool;
this._description = Description;
this._date = Date;
this._user = worker;
this.trans = trans;
cmd = new SqlCommand();
}
public bool createToolWithMileage(string type, DateTime servicedate, int servicemileage, int actualmileage, int milesperday)
{
Transaction trans = new Transaction();
ToolRDG TOOLRDG = new ToolRDG(type, trans);
trans.BeginTransaction();
try
{
TOOLRDG.CreateToolMileage(servicedate, servicemileage, actualmileage, milesperday);
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
trans.Commit();
return true;
}
public void CreateTask(string Description, string Username, int ToolID, DateTime Date)
{
Transaction trans = new Transaction();
ToolRDG toolrdg = new ToolRDG(ToolID);
NormalUser woerkerdg = new NormalUser(Username);
TaskRDG TRDG = new TaskRDG(toolrdg,woerkerdg,Description, Date, trans);
trans.BeginTransaction();
try
{
TRDG.CreateTaskDB();
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
trans.Commit();
}
public void DeleteTool(int toolID)
{
Transaction trans = new Transaction();
ToolRDG TOOLRDG = new ToolRDG(toolID, trans);
trans.BeginTransaction();
try
{
TOOLRDG.DeleteTool();
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
trans.Commit();
}
public void UpdateActualMileage(int ToolID, int ActualMileage)
{
Transaction trans = new Transaction();
ToolRDG tool = new ToolRDG(ToolID, ActualMileage, trans);
trans.BeginTransaction();
try
{
tool.UpdateActualMileage();
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
trans.Commit();
}
public List<int> GetAllToolsID()
{
Transaction trans = new Transaction();
ToolRDG TOOLRDG = new ToolRDG(trans);
List<int> ToolIDList = new List<int>();
trans.BeginTransaction();
try
{
ToolIDList = TOOLRDG.GetAllToolsID();
}
catch (Exception e)
{
throw e;
}
return ToolIDList;
}
public List<ToolDTO> GetAllTools()
{
Transaction trans = new Transaction();
List<ToolDTO> tools;
ToolRDG toolRDG = new ToolRDG(trans);
trans.BeginTransaction();
try
{
tools = toolRDG.GetAllTools();
}
catch(Exception e)
{
trans.Rollback();
throw e;
}
trans.Commit();
return tools;
}
public List<TaskDTO> GetAllTaskForATool(int ToolId)
{
Transaction trans = new Transaction();
ToolRDG tool = new ToolRDG(ToolId);
TaskRDG task = new TaskRDG(tool, trans);
List<TaskDTO> tasks = new List<TaskDTO>();
trans.BeginTransaction();
try
{
tasks = task.GetAllTasksFromTool(task);
}
catch (Exception e)
{
trans.Rollback();
throw e;
}
trans.Commit();
return tasks;
}
public TaskRDG(ToolRDG Tool, Transaction trans)
{
this._tool = Tool;
this.trans = trans;
cmd = new SqlCommand();
}
