public TaskType GetTaskType(TaskTypeIDs TaskTypeID)
{
ISelect query;
LogEnter();
Log(LogLevels.Information, $"Querying TaskType table (TaskTypeID={TaskTypeID})");
query = new Select(TaskTypeTable.TaskTypeID, TaskTypeTable.PhraseKey).From(PIODB.TaskTypeTable).Where(TaskTypeTable.TaskTypeID.IsEqualTo(TaskTypeID));
return(TrySelectFirst <TaskTypeTable, TaskType>(query).OrThrow <PIODataException>("Failed to query"));
}
public TaskType GetTaskType(TaskTypeIDs TaskTypeID)
{
if (ThrowException)
{
throw new PIODataException("UnitTestException", null, 1, "UnitTest", "UnitTest");
}
return(new TaskType()
{
TaskTypeID = TaskTypeID
});
}
public Task CreateTask(TaskTypeIDs TaskTypeID, int WorkerID, int X, int Y, int?BuildingID, ResourceTypeIDs?ResourceTypeID, BuildingTypeIDs?BuildingTypeID, DateTime ETA)
{
Task item;
if (ThrowException)
{
throw new PIODataException("UnitTestException", null, 1, "UnitTest", "UnitTest");
}
item = new Task()
{
TaskTypeID = TaskTypeID, WorkerID = WorkerID, BuildingID = BuildingID, ResourceTypeID = ResourceTypeID, BuildingTypeID = BuildingTypeID, ETA = ETA
};
items.Add(item);
return(item);
}
public TaskType CreateTaskType(TaskTypeIDs TaskTypeID, string PhraseKey)
{
IInsert query;
TaskType item;
object result;
LogEnter();
item = new TaskType()
{
TaskTypeID = TaskTypeID, PhraseKey = PhraseKey,
};
Log(LogLevels.Information, $"Inserting into TaskType table (TaskTypeID={TaskTypeID}, PhraseKey={PhraseKey})");
query = new Insert().Into(PIODB.TaskTypeTable).Set(TaskTypeTable.TaskTypeID, item.TaskTypeID).Set(TaskTypeTable.PhraseKey, item.PhraseKey);
result = Try(query).OrThrow <PIODataException>("Failed to insert");
//item.TaskTypeID = Convert.ToInt32(result);
return(item);
}
public Task CreateTask(TaskTypeIDs TaskTypeID, int WorkerID, int X, int Y, int?BuildingID, ResourceTypeIDs?ResourceTypeID, BuildingTypeIDs?BuildingTypeID, DateTime ETA)
{
IInsert query;
Task item;
object result;
LogEnter();
Log(LogLevels.Information, $"Inserting into Task table (TaskTypeID={TaskTypeID}, WorkerID={WorkerID}, ETA={ETA})");
item = new Task()
{
TaskTypeID = TaskTypeID, WorkerID = WorkerID, X = X, Y = Y, BuildingID = BuildingID, ResourceTypeID = ResourceTypeID, BuildingTypeID = BuildingTypeID, ETA = ETA
};
query = new Insert().Into(PIODB.TaskTable).Set(TaskTable.TaskTypeID, item.TaskTypeID).Set(TaskTable.WorkerID, item.WorkerID)
.Set(TaskTable.X, item.X).Set(TaskTable.Y, item.Y)
.Set(TaskTable.BuildingID, item.BuildingID)
.Set(TaskTable.ResourceTypeID, item.ResourceTypeID)
.Set(TaskTable.BuildingTypeID, item.BuildingTypeID)
.Set(TaskTable.ETA, item.ETA);
result = Try(query).OrThrow <PIODataException>("Failed to insert");
item.TaskID = Convert.ToInt32(result);
return(item);
}
public TaskType CreateTaskType(TaskTypeIDs TaskTypeID, string Name)
{
throw new NotImplementedException();
}
public Task CreateTask(TaskTypeIDs TaskTypeID, int WorkerID, int X, int Y, int?BuildingID, ResourceTypeIDs?ResourceTypeID, BuildingTypeIDs?BuildingTypeID, DateTime ETA)
{
throw new NotImplementedException();
}
public Task <TaskType> GetTaskTypeAsync(TaskTypeIDs TaskTypeID)
{
throw new NotImplementedException();
}
public TaskType GetTaskType(TaskTypeIDs TaskTypeID)
{
throw new NotImplementedException();
}
public TaskType GetTaskType(TaskTypeIDs TaskTypeID)
{
LogEnter();
return(Try(() => taskTypeModule.GetTaskType(TaskTypeID)).OrThrow(GenerateFaultException));
}
