clsImportQualificationTask Class |
Technically the qualifiation task is close to an internal service task
MS Access Table: MARIProjektImportQualificationTasks. See clsImportBase.eImportMode relative tables in MS-Access.
Use MPInterface.bImportQualificationTask(clsImportQualificationTask, clsImportBaseeImportMode) to import.
Use clsImportQualificationTaskPos to import training participants.
Use clsImportWorkItemServiceTaskResource to import the teacher or equpiment to be used in the qualification task
Use clsImportWorkItemServiceTaskResults to import results to a linked checklist
MS Access Table: MARIProjectImportWorkItemQualificationTask.
Namespace: MARIInterface
The clsImportQualificationTask type exposes the following members.
| Name | Description | |
|---|---|---|
| clsImportQualificationTask | Initializes a new instance of the clsImportQualificationTask class |
| Name | Description | |
|---|---|---|
| CheckList | CheckList (int) | |
| CompanyId |
SMALLINT (2) Link to company (SBO Database)
| |
| ContractID |
INT (4) Link to Contract (Plan, Task)
| |
| ContractPositionID |
INT (4) 0=New positions as "at cost", Link to fixed price position
| |
| EndDateTime |
Datetime (8) End of Task with hh:mm
| |
| Matchcode |
NVARCHAR (50) Name of the qualification task
| |
| PhaseID |
INT (4) Link to Phase Plan, Task)
| |
| Project |
NVARCHAR (20) Link to Project (Plan, Task)
| |
| QualificationTaskDocNum |
WorkItemDocNum INT (4) Visible ID based on Number Series. Will be created automatically. Leave this blank.
| |
| QualificationTaskDocSeries |
INT (4) ID of the number series
| |
| QualificationTaskID |
Internal TaskID INT (4) Unique ID (via MPTAN). In access can be <100000 to align the positiosn
| |
| StartDateTime |
Datetime (8) Start of task with hh:mm
| |
| TaskStatus |
INT (4) Status (depending on type) 1:Request,2=Active,3=CloseReadyToInvoice,4=ClosedInvoiced. See eTaskStatus for details.
| |
| WorkDescription |
NTEXT (0) Memo What to do
| |
| WorkNotes |
NTEXT (0) Memo for notes on site
|
private int CreateQualificationTask(string sTaskName) { clsImportQualificationTask oQualiTask = new clsImportQualificationTask(); oQualiTask.Matchcode = "QualificationTask"; oQualiTask.StartDateTime = DateTime.Today; oQualiTask.EndDateTime = DateTime.Today.AddDays(6); oQualiTask.CompanyId = 1; oQualiTask.TaskStatus = clsImportQualificationTask.eTaskStatus.ServiceRequest; oQualiTask.CheckList = lChecklist; if (oMPInterface.bImportQualificationTask(oQualiTask, clsImportBase.eImportMode.ValidateAndImport)) { return oQualiTask.QualificationTaskID; } else { string sErrordetails = oMPInterface.oErrors.PrintErrors(true); Assert.False(true, sErrordetails); return 0; } } private int LinkParticipantToQualificationTask(int lQualificationTaskID, string sEmployeeNumber) { clsImportQualificationTaskPos oLinkPos = new clsImportQualificationTaskPos(); oLinkPos.QualificationTaskID = lQualificationTaskID; oLinkPos.PosType = clsImportQualificationTaskPos.eQualityTaskPositionTyp.QualificationParticipantEmployee; oLinkPos.LineKeyValue = sEmployeeNumber; // Employe number oLinkPos.QualityProcess = lChecklist; // SELECT QualityProcess FROM MARIQualityProcess WHERE ClassID=501 //Store Reference to the scheduled date oLinkPos.ReferenceQualificationPlan = lQualificationPlan; //SELECT WorkItemID FROM MARIWorkItem WHERE workitemtype=494 oLinkPos.ReferenceQualificationPlanDate = DateTime.MinValue; // automatically the next open plan date will be linked oLinkPos.QualityResult = 100002; // Result Status: SELECT QualityStatus FROM MARIQualityStatus WHERE ClassID=505 if (oMPInterface.bImportQualificationTasksPosition(oLinkPos, clsImportBase.eImportMode.ValidateAndImport)) { return oLinkPos.QualificationTaskPosID; } else { string sErrordetails = oMPInterface.oErrors.PrintErrors(true); Assert.False(true, sErrordetails); return 0; } }