Exemple #1
0
        public EAP_STATUS createNewEmptyDatabase(String aDataBaseName)
        {
            try
            {
                string connString = "Server=" + m_server + ";user="******";port=" + m_port + ";password="******"Connecting to MySQL...");
                    this.m_DatabaseConnection.Open();
                    //*** Drop database if it already exist
                    MySqlCommand cmd = this.m_DatabaseConnection.CreateCommand();
                    cmd.CommandText = "DROP DATABASE IF EXISTS " + aDataBaseName;
                    Console.WriteLine("Droping database " + aDataBaseName + "if it exist");
                    cmd.ExecuteNonQuery();
                    //*** Create New database if it not exist
                    cmd.CommandText = "CREATE DATABASE IF NOT EXISTS " + aDataBaseName;
                    Console.WriteLine("Creating database " + aDataBaseName + "if it not exist");
                    cmd.ExecuteNonQuery();
                    m_database = aDataBaseName;
                    //*** Close connection to server
                    Console.WriteLine("Closinng connection to SQL server");
                    m_DatabaseConnection.Close();
                    //*** Connect to the newly created database
                    connString = "Server=" + m_server + ";database=" + m_database + ";user="******";port=" + m_port + ";password="******"Connecting to MySQL Database " + m_database);
                    this.m_DatabaseConnection.Open();
                }
                catch (Exception ex)
                {
                    Console.WriteLine(ex.ToString());
                }
                cEAPWSProjectTypesTable projectTypesTable = new cEAPWSProjectTypesTable(m_DatabaseConnection);
                projectTypesTable.createTable();

                cEAPWSCompetenceTypesTable competenceTypesTable = new cEAPWSCompetenceTypesTable(m_DatabaseConnection);
                competenceTypesTable.createTable();

                cEAPWSWPTable wpTable = new cEAPWSWPTable(m_DatabaseConnection);
                wpTable.createTable();

                cEAPWSEstTimePeriodTable estTimePeriodTable = new cEAPWSEstTimePeriodTable(m_DatabaseConnection);
                estTimePeriodTable.createTable();

                cEAPWSJobsTable jobsTable = new cEAPWSJobsTable(m_DatabaseConnection);
                jobsTable.createTable();

                cEAPWSEstTimesTable estTimesTable = new cEAPWSEstTimesTable(m_DatabaseConnection);
                estTimesTable.createTable();

                cEAPWSCalenderTable calenderTable = new cEAPWSCalenderTable(m_DatabaseConnection);
                calenderTable.createTable();

                cEAPWSCalenderItemTable calenderItemTable = new cEAPWSCalenderItemTable(m_DatabaseConnection);
                calenderItemTable.createTable();

                cEAPWSNewestEstView newestEstView = new cEAPWSNewestEstView(m_DatabaseConnection);
                newestEstView.createView();

                cEAPWSJobEstView jobEstView = new cEAPWSJobEstView(m_DatabaseConnection);
                jobEstView.createView();

                cEAPWSWPJobEstView wpJobEstView = new cEAPWSWPJobEstView(m_DatabaseConnection);
                wpJobEstView.createView();

                cEAPWSNewestWPJobEstView newestWPJobEstView = new cEAPWSNewestWPJobEstView(m_DatabaseConnection);
                newestWPJobEstView.createView();

                cEAPWSCalenderedNewestWPJobEstView caledNewestWPJobEstView = new cEAPWSCalenderedNewestWPJobEstView(m_DatabaseConnection);
                caledNewestWPJobEstView.createView();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
            }

            return(EAP_STATUS.OK);
        }
Exemple #2
0
        public EAP_STATUS populateDatabaseWithExamples(String aDataBaseName)
        {
            EAP_STATUS status         = EAP_STATUS.OK;
            int        lastAddedWPId  = 0;
            int        lastAddedJobId = 0;

            const int compSW       = 1;
            const int compSysVer   = 2;
            const int compMech     = 3;
            const int compElec     = 4;
            const int compTechInfo = 5;
            const int compProj     = 6;

            const int wpTypeR = 1;
            const int wpTypeT = 2;
            const int wpTypeP = 3;
            const int wpTypeM = 4;

            int calenderAgressive = 0;
            int calenderSafe      = 0;


            cEAPWSWPTable           wpTable           = new cEAPWSWPTable(m_DatabaseConnection);
            cEAPWSJobsTable         jobsTable         = new cEAPWSJobsTable(m_DatabaseConnection);
            cEAPWSEstTimesTable     estTimesTable     = new cEAPWSEstTimesTable(m_DatabaseConnection);
            cEAPWSCalenderTable     calenderTable     = new cEAPWSCalenderTable(m_DatabaseConnection);
            cEAPWSCalenderItemTable calenderItemTable = new cEAPWSCalenderItemTable(m_DatabaseConnection);

            if (EAP_STATUS.OK == status)
            {
                status = calenderTable.addCalender("'PM -Agressive'", "'Product Managers aggresiv suggestion for product/project roadmap'", ref calenderAgressive);
            }
            if (EAP_STATUS.OK == status)
            {
                status = calenderTable.addCalender("'PM -Safe'", "'Product Managers safe suggestion for product/project roadmap'", ref calenderSafe);
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeR, "'R - Brushless Main Motor'", "'Research if it is feasible from a cost and performance perspective to use a brushless main motor. If so the project shall have a recommendation of supplier and a specific motor'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "'Work for implemetation of test sw for lab purposes'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 80, 2, 0, "20160824120000");
                    }
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 80, 2);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compElec, "'Work for evaluating different options regarding brushless main motor'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 800, 6);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Small follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 25, 6);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD CALENDER ITEM ******************
                    DateTime date = new DateTime(2016, 01, 23, 12, 0, 0);
                    date   = date.ToUniversalTime();
                    status = calenderItemTable.addCalenderItem(calenderAgressive, lastAddedWPId, date.ToString());
                }
            }

            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeR, "'R - RFID identification of accessories'", "'Research if it is feasible from a cost and performance perspective to use RFID to detect differnt attached accessories. Identify associated/possible features. Evaluate customer value.'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "'Work for implemetation of test sw for lab purposes, Workshops for feature identification'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 200, 3);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compElec, "'Work for evaluating different options regarding RFID identification'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 800, 6);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 80, 6);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeR, "'R - Blender drive line  Gen 4'", "'Research a solution for a new drive line (motor, transmission) lighter, longer life, higher speed and more torque. Evaluate customer value.'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "'Work for for investigating, specifying and elimanate risks'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 2000, 12);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 160, 12);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeR, "'R - Blender cover set  Gen 4'", "'Research a solution for a new cover set. Module, reusable for many models and a modern look'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "'Work for for investigating, preliminar design, specifying and elimanate risks'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 2000, 12);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 160, 12);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeT, "'T - Brushless main motor'", "'Develop technology for first use in a product accordint to specification decided based on coresponding R-project'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "'Work for implemetation of driver of brushless main motor'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 800, 6, 3);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "'Work for verification of quality and usability of brushless main motor'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 300, 2, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 200, 6, 6);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compElec, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 800, 6, 6);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 80, 1, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 240, 12);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeT, "'T - RFID identification of accessories'", "'Develop technology for first use in a product according to specification decided based on coresponding R-project. Includes development/modofocation of 3 accesories to use RFID'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 800, 6, 3);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 80, 2, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 800, 6, 6);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compElec, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 800, 6, 6);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 180, 3, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 240, 12);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeT, "'T - Facelift Main Cover Design'", "'Complete new cover set'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 30, 8, 4);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 800, 8, 6);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 10, 4);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeT, "'T - Battery Low warning to App'", "'Add battery low warning to existing apps for ios and android'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 100, 2, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 20, 1, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Tiny follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 5, 2, 0);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeP, "'P - Blender Gen 2 Low-Range classic'", "'Facelift of existing model'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 2, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 200, 6, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 400, 6, 3);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 2, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 100, 9, 0);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeP, "'P - Blender Gen 2 Mid-Range classic'", "'Facelift of existing model'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 2, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 200, 6, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 400, 6, 3);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 2, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 100, 9, 0);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeP, "'P - Blender Gen 2 High-Range classic'", "'Facelift of existing model'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 2, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 200, 6, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 400, 6, 3);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 2, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 100, 9, 0);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeP, "'P - Blender Gen 3 Low-Range'", "'New model on platform Gen 3'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 2, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 300, 6, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 400, 6, 3);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 200, 2, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 300, 9, 0);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeP, "'P - Blender Gen 3 Mid-Range'", "'New model on platform Gen 3'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 2, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 300, 6, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 400, 6, 3);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 200, 2, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 300, 9, 0);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeP, "'P - Blender Gen 3 High-Range'", "'New model on platform Gen 3'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 120, 2, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 300, 6, 1);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 400, 6, 3);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 200, 2, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compProj, "'Medium follow up work'", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 300, 9, 0);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeM, "'M - Product Maintenance Blenders Gen 2'", "'Planned Maintenance for 3 years after launch'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 180, 36, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 180, 36, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 360, 36, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 72, 36, 0);
                    }
                }
            }
            if (EAP_STATUS.OK == status)
            {
                // ****** ADD WORKPACKAGE ******************
                status = wpTable.addWP(wpTypeM, "'M - Product Maintenance Blenders Gen 3'", "'Planned Maintenance for 3 years after launch'", ref lastAddedWPId);
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSW, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 360, 36, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compSysVer, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 240, 36, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compMech, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 360, 36, 0);
                    }
                }
                if (EAP_STATUS.OK == status)
                {
                    // ****** ADD JOB ******************
                    status = jobsTable.addJob(lastAddedWPId, compTechInfo, "''", ref lastAddedJobId);
                    if (EAP_STATUS.OK == status)
                    {
                        // ****** ADD ESTIMATES ******************
                        status = estTimesTable.addEstimation(lastAddedJobId, 72, 36, 0);
                    }
                }
            }
            return(status);
        }