clsImportPlanning Class

public class clsImportPlanning : clsImportBase

Public Class clsImportPlanning
	Inherits clsImportBase

private int CreatePlanningEmployee(string sEmployee, DateTime dtPlanDate) {
    Log($"CreatePlanningEmployee({sEmployee}, {dtPlanDate.ToShortDateString()})");
    //Create one day planning for one employee

    clsImportPlanning NewPlanning = new clsImportPlanning();
    NewPlanning.ProjectNumber = "P100005";
    NewPlanning.ContractID = 100008; // SELECT ContractID FROM MARIContract WHERE ProjectNumber=N'P100005'
    NewPlanning.ContractPos = 100031; // SELECT ContractPositionId FROM MARIContractPositions WHERE ContractID=100008 AND PositionType=4 --(ServiceAtCost)
    NewPlanning.PhaseID = 100018; // SELECT PhaseID FROM MARIProjectPhases WHERE ProjectNumber=N'P100005'
    NewPlanning.DateFrom = dtPlanDate;
    NewPlanning.Activity = "Plantext";
    NewPlanning.PlanningType = clsImportPlanning.ePlanningType.DayPlanning; //default
    NewPlanning.PlanningResourceType = clsImportPlanning.ePlanningResourceType.Employee; //default
    NewPlanning.ResourceID = sEmployee;
    //NewPlanning.QuantityTime = ... When no time is given, the planning will use the standard calendar for the full day planning.
    //Costs /  TargetedRevenues are calculated from the employees political cost and the sales position


    if (oMPInterface.bImportPlanning(NewPlanning, clsImportBase.eImportMode.ValidateAndImport)) {
        return NewPlanning.PlanningJobDayID;
    } else {
        throw new Exception(oMPInterface.oErrors.PrintErrors());
    }
}

private int CreatePlanningPoolPeriodPlanning(DateTime dtPlanDate) {
    Log($"CreatePlanningPoolPeriodPlanning({dtPlanDate.ToShortDateString()})");
    clsImportPlanning NewPlanning = new clsImportPlanning();
    NewPlanning.ProjectNumber = "P100024";
    NewPlanning.ContractID = 102036; //sales contract. Can be mandatory for planning, depending on settnig
    NewPlanning.ContractPos = 102304; // sales contract position
    NewPlanning.PhaseID = 100032; //Erdarbeiten
    NewPlanning.DateFrom = dtPlanDate;
    NewPlanning.PlanningResourceType = clsImportPlanning.ePlanningResourceType.Pool;
    NewPlanning.ResourceID = "00002"; // Ressource pool id: CAD-Designer
    NewPlanning.PlanningType = clsImportPlanning.ePlanningType.PeriodPlanning;
    NewPlanning.TimeUnit = clsImportPlanning.eTimeUnit.Days;
    NewPlanning.QuantityTime = 10; //hours
    NewPlanning.QuantityResources = 2; //two employees are expected to work together on this task
    NewPlanning.Activity = "Pool Planning";

    if (oMPInterface.bImportPlanning(NewPlanning, clsImportBase.eImportMode.ValidateAndImport)) {
        return NewPlanning.PlanningJobDayID;
    } else {
        throw new Exception(oMPInterface.oErrors.PrintErrors());
    }
}

private int CreatePlanningStandardPool(DateTime dtPlanDate) {
    Log($"CreatePlanningStandardPool({dtPlanDate.ToShortDateString()})");
    clsImportPlanning NewPlanning = new clsImportPlanning();
    NewPlanning.ProjectNumber = "P100024";
    NewPlanning.ContractID = 102036; // can be mandatory, depending on settnig
    NewPlanning.ContractPos = 102304;
    NewPlanning.PhaseID = 100032; //Erdarbeiten
    NewPlanning.DateFrom = dtPlanDate;
    NewPlanning.ResourceID = ""; // will be the standard pool
    NewPlanning.PlanningResourceType = clsImportPlanning.ePlanningResourceType.StandardPool;
    NewPlanning.PlanningType = clsImportPlanning.ePlanningType.PeriodPlanning;
    NewPlanning.QuantityTime = 8;
    NewPlanning.QuantityResources = 2;
    NewPlanning.Activity = "StandardPool Planning";

    if (oMPInterface.bImportPlanning(NewPlanning, clsImportBase.eImportMode.ValidateAndImport)) {
        return NewPlanning.PlanningJobDayID;
    } else {
        throw new Exception(oMPInterface.oErrors.PrintErrors());
    }
}

private int CreatePlanningEquipmentCatDay(DateTime dtPlanDate) {
    Log($"CreatePlanningEquipmentCatDay({dtPlanDate.ToShortDateString()})");
    clsImportPlanning NewPlanning = new clsImportPlanning();
    NewPlanning.ProjectNumber = "P100024";
    NewPlanning.ContractID = 102036; // sales contract for the rental of the digger
    NewPlanning.ContractPos = 102285; //sales contract position for the duration of the digger rental
    NewPlanning.PhaseID = 100031; //selected phase
    NewPlanning.DateFrom = dtPlanDate;
    NewPlanning.DateTo = dtPlanDate.AddDays(5);
    NewPlanning.PlanningResourceType = clsImportPlanning.ePlanningResourceType.EquipmentCategoryDays;
    NewPlanning.ResourceID = "100001"; // digger equipment category
    NewPlanning.PlanningType = clsImportPlanning.ePlanningType.DayPlanning;
    NewPlanning.TimeUnit = clsImportPlanning.eTimeUnit.Days;
    NewPlanning.QuantityResources = 2; //two digger at the same time
    NewPlanning.Activity = "EqCat Planning";

    if (oMPInterface.bImportPlanning(NewPlanning, clsImportBase.eImportMode.ValidateAndImport)) {
        return NewPlanning.PlanningJobDayID;
    } else {
        throw new Exception(oMPInterface.oErrors.PrintErrors());
    }
}
private int CreatePlanningEquipmentCat(DateTime dtPlanDate) {
    Log($"CreatePlanningEquipmentCat({dtPlanDate.ToShortDateString()})");
    clsImportPlanning NewPlanning = new clsImportPlanning();
    NewPlanning.ProjectNumber = "P100024";
    NewPlanning.ContractID = 102036; // sales contract for the rental of the digger
    NewPlanning.ContractPos = 102285; //sales contract position for the duration of the digger rental
    NewPlanning.PhaseID = 100031; //selected phase for the plan
    NewPlanning.DateFrom = dtPlanDate;
    NewPlanning.DateTo = dtPlanDate.AddDays(5);
    NewPlanning.PlanningResourceType = clsImportPlanning.ePlanningResourceType.EquipmentMasterDays;
    NewPlanning.ResourceID = "E110000"; // specific digger
    NewPlanning.PlanningType = clsImportPlanning.ePlanningType.DayPlanning;
    NewPlanning.TimeUnit = clsImportPlanning.eTimeUnit.Days;
    //NewPlanning.QuantityTime = 10;
    NewPlanning.QuantityResources = 2;
    NewPlanning.Activity = "Equipment Planning";

    if (oMPInterface.bImportPlanning(NewPlanning, clsImportBase.eImportMode.ValidateAndImport)) {
        return NewPlanning.PlanningJobDayID;
    } else {
        throw new Exception(oMPInterface.oErrors.PrintErrors());
    }
}

private int CreatePlanningItem(string ItemCode, DateTime FirstDayOfPeriod) {
    Log($"CreatePlanningItem({ItemCode}, {FirstDayOfPeriod.ToShortDateString()})");
    //Create one day planning for one employee

    clsImportPlanning NewPlanning = new clsImportPlanning();
    NewPlanning.ProjectNumber = "P100011";
    NewPlanning.ContractID = 100015; // SELECT ContractID FROM MARIContract WHERE ProjectNumber=N'P100011'
    NewPlanning.ContractPos = 100054; // SELECT ContractPositionId FROM MARIContractPositions WHERE ContractID=100008 AND WHERE PositionType=1 and ItemCode='230001' --(ItemAtCost)
    NewPlanning.PhaseID = 0; //(no phase on this project) SELECT PhaseID FROM MARIProjectPhases WHERE ProjectNumber=N'P100011'
    NewPlanning.DateFrom = FirstDayOfPeriod;
    NewPlanning.Activity = "material plan";
    NewPlanning.PlanningType = clsImportPlanning.ePlanningType.PeriodPlanning; //cost is planned in the month
    NewPlanning.PlanningResourceType = clsImportPlanning.ePlanningResourceType.Item;
    NewPlanning.ResourceID = ItemCode;
    NewPlanning.Costs = 800m;
    NewPlanning.TargetedRevenues = 1000m;
    NewPlanning.QuantityResources = 10;

    if (oMPInterface.bImportPlanning(NewPlanning, clsImportBase.eImportMode.ValidateAndImport)) {
        return NewPlanning.PlanningJobDayID;
    } else {
        throw new Exception(oMPInterface.oErrors.PrintErrors());
    }
}