Exemplo n.º 1
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private nomitech.common.db.local.EquipmentTable saveOrUpdateEquipmentTable(org.hibernate.Session paramSession, Desktop.common.nomitech.common.migration.spon.SponLineItem paramSponLineItem) throws Exception
        private EquipmentTable saveOrUpdateEquipmentTable(Session paramSession, SponLineItem paramSponLineItem)
        {
            SponLineItem sponLineItem;

            for (sponLineItem = (SponLineItem)paramSponLineItem.Parent; string.ReferenceEquals(sponLineItem.WbsCode, null); sponLineItem = (SponLineItem)sponLineItem.Parent)
            {
                ;
            }
            double?double = convertToCostOSRate(paramSponLineItem.Unit, paramSponLineItem.Plant);

            null             = BlankResourceInitializer.createBlankEquipment(null);
            null.EquipmentId = null;
            string str1 = paramSponLineItem.makeShortTitle();

            null.Title = str1;
            null.Model = "";
            null.Make  = "";
            string str2 = convertToCostOSUnit(paramSponLineItem.Unit);

            if (string.ReferenceEquals(str2, null))
            {
                throw new Exception("FATAL: UNIT WAS NULL FOR " + paramSponLineItem.Unit);
            }
            null.GroupCode     = sponLineItem.WbsCode + " - " + sponLineItem.makeShortTitle();
            null.GekCode       = "";
            null.ExtraCode1    = "";
            null.ExtraCode2    = "";
            null.ExtraCode3    = "";
            null.ExtraCode4    = "";
            null.ExtraCode5    = "";
            null.ExtraCode6    = "";
            null.ExtraCode7    = "";
            null.ExtraCode8    = "";
            null.ExtraCode9    = "";
            null.ExtraCode10   = "";
            null.Country       = "GB";
            null.StateProvince = "";
            null.Unit          = str2;
            null.EditorId      = "spon";
            null.Unit          = "HOUR";
            if (str2.Equals("DAY"))
            {
                double = Convert.ToDouble(double.Value * 0.125D);
            }
            else if (str2.Equals("WEEK"))
            {
                double = Convert.ToDouble(double.Value * 0.025D);
            }
            else if (str2.Equals("MONTH"))
            {
                double = Convert.ToDouble(double.Value * 0.00625D);
            }
            if (str1.ToLower().IndexOf("diesel", StringComparison.Ordinal) != -1)
            {
                null.FuelType = "DIESEL";
            }
            else if (str1.ToLower().IndexOf("gas", StringComparison.Ordinal) != -1)
            {
                null.FuelType = "PETROL";
            }
            else if (str1.ToLower().IndexOf("electric", StringComparison.Ordinal) != -1)
            {
                null.FuelType = "ELECTRIC";
            }
            else
            {
                null.FuelType = "OTHER";
            }
            null.DepreciationCalculationMethod = EquipmentTable.USER_DEFINED_METHOD;
            null.DepreciationYears             = BigInteger.Parse("6");
            null.OccupationalFactor            = new BigDecimalFixed("0.73");
            null.OccupationHoursPerMonth       = new BigDecimalFixed("175.0");
            null.InitAquasitionPrice           = new BigDecimalFixed("0.0");
            null.InterestRate     = new BigDecimalFixed("0.065");
            null.LubricatesRate   = new BigDecimalFixed("0");
            null.TiresRate        = new BigDecimalFixed("0");
            null.FuelConsumption  = new BigDecimalFixed("0");
            null.SparePartsRate   = new BigDecimalFixed("0");
            null.ReservationRate  = new BigDecimalFixed("" + double);
            null.DepreciationRate = new BigDecimalFixed("0");
            null.FuelRate         = new BigDecimalFixed("0");
            null.TotalRate        = new BigDecimalFixed("" + double);
            null.Currency         = "GBP";
            null.Notes            = "SPON Major Rate";
            null.Description      = paramSponLineItem.makeFullDescription() + "\nCODE: " + paramSponLineItem.Code;
            null.LastUpdate       = this.lastUpdate;
            null.CreateDate       = this.lastUpdate;
            null.CreateUserId     = "spon";
            null.recalculate();
            long?long = null.EquipmentId;

            if (long == null)
            {
                long = (long?)paramSession.save(null);
            }
            else
            {
                paramSession.update(null);
            }
            return((EquipmentTable)DatabaseDBUtil.loadBulk(typeof(EquipmentTable), new long?[] { long })[0]);
        }
Exemplo n.º 2
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private nomitech.common.db.local.SubcontractorTable saveOrSubcontractorTable(org.hibernate.Session paramSession, Desktop.common.nomitech.common.migration.spon.SponLineItem paramSponLineItem, System.Nullable<double> paramDouble) throws Exception
        private SubcontractorTable saveOrSubcontractorTable(Session paramSession, SponLineItem paramSponLineItem, double?paramDouble)
        {
            SponLineItem sponLineItem;

            for (sponLineItem = (SponLineItem)paramSponLineItem.Parent; string.ReferenceEquals(sponLineItem.WbsCode, null); sponLineItem = (SponLineItem)sponLineItem.Parent)
            {
                ;
            }
            null = BlankResourceInitializer.createBlankSubcontractor(null);
            null.SubcontractorId = null;
            null.Title           = paramSponLineItem.makeShortTitle();
            string str = convertToCostOSUnit(paramSponLineItem.Unit);

            if (string.ReferenceEquals(str, null))
            {
                throw new Exception("FATAL: UNIT WAS NULL FOR " + paramSponLineItem.Unit);
            }
            null.GroupCode       = sponLineItem.WbsCode + " - " + sponLineItem.makeShortTitle();
            null.GekCode         = "";
            null.ExtraCode1      = "";
            null.ExtraCode2      = "";
            null.ExtraCode3      = "";
            null.ExtraCode4      = "";
            null.ExtraCode5      = "";
            null.ExtraCode6      = "";
            null.ExtraCode7      = "";
            null.ExtraCode8      = "";
            null.ExtraCode9      = "";
            null.ExtraCode10     = "";
            null.Unit            = str;
            null.EditorId        = "spon";
            null.ContactPerson   = "";
            null.PhoneNumber     = "";
            null.MobileNumber    = "";
            null.FaxNumber       = "";
            null.Email           = "";
            null.Url             = "";
            null.Company         = "";
            null.Performance     = "8";
            null.Address         = "";
            null.City            = "";
            null.IKA             = BigDecimalMath.ZERO;
            null.SubMaterialRate = BigDecimalMath.ZERO;
            null.Rate            = new BigDecimalFixed("" + convertToCostOSRate(paramSponLineItem.Unit, paramDouble));
            null.Project         = "";
            null.Country         = "GB";
            null.StateProvince   = "";
            null.Currency        = "GBP";
            null.Accuracy        = "enum.quotation.accuracy.estimated";
            null.Inclusion       = "enum.inclusion.subonly";
            null.Quantity        = new BigDecimalFixed(0);
            null.Notes           = "SPON Major Rate";
            null.Description     = paramSponLineItem.makeFullDescription() + "\nCODE: " + paramSponLineItem.Code;
            null.LastUpdate      = this.lastUpdate;
            null.CreateDate      = this.lastUpdate;
            null.CreateUserId    = "spon";
            null.recalculate();
            long?long = null.SubcontractorId;

            if (long == null)
            {
                long = (long?)paramSession.save(null);
            }
            else
            {
                paramSession.update(null);
            }
            return((SubcontractorTable)DatabaseDBUtil.loadBulk(typeof(SubcontractorTable), new long?[] { long })[0]);
        }
Exemplo n.º 3
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private SPONMigrationUtil(String paramString1, String paramString2) throws Exception
        private SPONMigrationUtil(string paramString1, string paramString2)
        {
            initializeRateConverter();
            this.sponLineItemList = SponLineTimeLoader.loadLineItems(paramString1, paramString2);
            System.Collections.IEnumerator iterator1 = this.sponLineItemList.GetEnumerator();
            this.rootNode = new DefaultMutableTreeNode();
            sbyte b;

            for (b = 0; iterator1.MoveNext(); b++)
            {
                SponLineItem sponLineItem = (SponLineItem)iterator1.Current;
                sponLineItem.Index = b;
                DefaultMutableTreeNode defaultMutableTreeNode = findParentForLineItem(sponLineItem, b);
                defaultMutableTreeNode.add(sponLineItem);
            }
            System.Collections.IEnumerator enumeration = this.rootNode.children();
            LinkedList linkedList = new LinkedList();

            while (enumeration.MoveNext())
            {
                linkedList.AddLast(enumeration.Current);
            }
            Hashtable hashMap = new Hashtable();

            foreach (SponLineItem sponLineItem1 in linkedList)
            {
                SponLineItem sponLineItem2 = null;
                LinkedList   linkedList1   = null;
                System.Collections.IEnumerator enumeration1 = sponLineItem1.children();
                Console.WriteLine("" + sponLineItem1);
                while (enumeration1.MoveNext())
                {
                    SponLineItem sponLineItem = (SponLineItem)enumeration1.Current;
                    string       str          = sponLineItem.Code;
                    if (str.IndexOf("/", StringComparison.Ordinal) != -1)
                    {
                        if (str.IndexOf("N", StringComparison.Ordinal) == -1)
                        {
                            str = StringHelper.SubstringSpecial(str, str.IndexOf("/", StringComparison.Ordinal) + 1, str.Length);
                        }
                        else
                        {
                            str = StringHelper.SubstringSpecial(str, str.IndexOf("/", StringComparison.Ordinal), str.Length);
                        }
                    }
                    if (str.Length == 3)
                    {
                        sponLineItem2          = sponLineItem;
                        linkedList1            = new LinkedList();
                        hashMap[sponLineItem2] = linkedList1;
                        Console.WriteLine(" " + sponLineItem);
                        continue;
                    }
                    if (linkedList1 == null)
                    {
                        Console.WriteLine("I was trying;" + sponLineItem);
                    }
                    linkedList1.AddLast(sponLineItem);
                }
            }
            foreach (SponLineItem sponLineItem in hashMap.Keys)
            {
                foreach (SponLineItem sponLineItem1 in (System.Collections.IList)hashMap[sponLineItem])
                {
                    sponLineItem1.removeFromParent();
                }
                foreach (SponLineItem sponLineItem1 in (System.Collections.IList)hashMap[sponLineItem])
                {
                    sponLineItem.add(sponLineItem1);
                }
            }
            Session     session     = DatabaseDBUtil.currentSession();
            Transaction transaction = session.beginTransaction();

            try
            {
                Console.WriteLine("\n\n\n\n");
                enumeration = this.rootNode.preorderEnumeration();
                b           = 0;
                while (enumeration.MoveNext())
                {
                    DefaultMutableTreeNode defaultMutableTreeNode = (DefaultMutableTreeNode)enumeration.Current;
                    if (defaultMutableTreeNode.Root)
                    {
                        continue;
                    }
                    SponLineItem sponLineItem = (SponLineItem)defaultMutableTreeNode;
                    string       str1         = null;
                    string       str2         = sponLineItem.Code;
                    if (++b % 'Ǵ' == '\x0000')
                    {
                        Console.WriteLine("PROCESSED: " + b + " lines");
                        transaction.commit();
                        DatabaseDBUtil.closeSession();
                        session     = DatabaseDBUtil.currentSession();
                        transaction = session.beginTransaction();
                    }
                    if (b % '✐' == '\x0000')
                    {
                        Thread.Sleep(2000L);
                    }
                    if (sponLineItem.Composite)
                    {
                        if (defaultMutableTreeNode.Path.length == 2)
                        {
                            str1 = str2;
                        }
                        else if (defaultMutableTreeNode.Path.length == 3)
                        {
                            str1 = str2.Substring(0, 1) + "." + str2.Substring(1, str2.Length - 1);
                        }
                        else if (defaultMutableTreeNode.Path.length == 4)
                        {
                            string str4 = ((SponLineItem)defaultMutableTreeNode.Parent).WbsCode;
                            string str5 = StringHelper.SubstringSpecial(str2, str4.Length - 1 - "C".Length, str2.Length);
                            str1 = str4 + "." + str5;
                        }
                        else
                        {
                            SponLineItem sponLineItem1 = (SponLineItem)defaultMutableTreeNode.Parent;
                            string       str           = sponLineItem1.WbsCode;
                            sbyte        b2            = 1;
                            System.Collections.IEnumerator enumeration1 = sponLineItem1.children();
                            while (enumeration1.MoveNext())
                            {
                                SponLineItem sponLineItem2 = (SponLineItem)enumeration1.Current;
                                if (sponLineItem2.Equals(sponLineItem))
                                {
                                    break;
                                }
                                b2++;
                            }
                            str1 = str + "." + b2;
                        }
                    }
                    string str3 = "";
                    for (sbyte b1 = 1; b1 < defaultMutableTreeNode.Path.length; b1++)
                    {
                        str3 = str3 + " ";
                    }
                    if (sponLineItem.Composite)
                    {
                        if (sponLineItem.Depth == 1)
                        {
                            System.Collections.IEnumerator enumeration1 = sponLineItem.children();
                            while (enumeration1.MoveNext())
                            {
                                SponLineItem sponLineItem1 = (SponLineItem)enumeration1.Current;
                                sponLineItem1.MoreDescription.Add(sponLineItem.Description);
                                if (!string.ReferenceEquals(sponLineItem.SecondDescription, null))
                                {
                                    sponLineItem1.MoreSecondDescription.Add(sponLineItem.SecondDescription);
                                }
                            }
                            continue;
                        }
                        if (sponLineItem.ChildCount == 0)
                        {
                            bool         @bool         = sponLineItem.NoteItem;
                            SponLineItem sponLineItem1 = (SponLineItem)defaultMutableTreeNode.Parent;
                            System.Collections.IEnumerator enumeration1 = sponLineItem1.children();
                            bool bool1 = false;
                            while (enumeration1.MoveNext())
                            {
                                SponLineItem sponLineItem2 = (SponLineItem)enumeration1.Current;
                                if (sponLineItem2.Equals(sponLineItem))
                                {
                                    bool1 = true;
                                    continue;
                                }
                                if (bool1 == true)
                                {
                                    if (@bool)
                                    {
                                        sponLineItem2.Notes = sponLineItem.Description;
                                        setNotesToAllSubItems(sponLineItem2, sponLineItem2.Notes);
                                        continue;
                                    }
                                    if (sponLineItem2.NoteItem)
                                    {
                                        string str = sponLineItem2.Description;
                                        sponLineItem2.Description = sponLineItem.Description;
                                        sponLineItem2.Notes       = str;
                                        setNotesToAllSubItems(sponLineItem2, sponLineItem2.Notes);
                                        sponLineItem.Notes = sponLineItem2.Description;
                                    }
                                }
                            }
                            continue;
                        }
                        if (sponLineItem.NoteItem)
                        {
                            setNotesToAllSubItems(sponLineItem, sponLineItem.Description);
                        }
                    }
                    if (!string.ReferenceEquals(str1, null))
                    {
                        if (!str1.StartsWith("C", StringComparison.Ordinal))
                        {
                            sponLineItem.WbsCode = "C" + str1;
                        }
                        else
                        {
                            sponLineItem.WbsCode = str1;
                        }
                        GroupCodeTable groupCodeTable = new GroupCodeTable();
                        groupCodeTable.GroupCode   = sponLineItem.WbsCode;
                        groupCodeTable.Title       = sponLineItem.makeShortTitle();
                        groupCodeTable.Unit        = "";
                        groupCodeTable.UnitFactor  = BigDecimalMath.ONE;
                        groupCodeTable.Description = sponLineItem.Description + "\n" + sponLineItem.Notes;
                        groupCodeTable.Notes       = sponLineItem.Code;
                        groupCodeTable.EditorId    = "spon";
                        session.save(groupCodeTable);
                        continue;
                    }
                    processSponCostItem(sponLineItem, session);
                }
                transaction.commit();
            }
            catch (Exception exception)
            {
                Console.WriteLine(exception.ToString());
                Console.Write(exception.StackTrace);
                transaction.rollback();
            }
            DatabaseDBUtil.closeSession();
            Console.WriteLine("\n\n\n\nUNIT MAP TO CONVERT:");
            System.Collections.IEnumerator iterator2 = this.unitMap.Values.GetEnumerator();
            while (iterator2.MoveNext())
            {
                Console.WriteLine(iterator2.Current);
            }
        }
Exemplo n.º 4
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private nomitech.common.db.local.MaterialTable saveOrUpdateMaterialTable(org.hibernate.Session paramSession, Desktop.common.nomitech.common.migration.spon.SponLineItem paramSponLineItem) throws Exception
        private MaterialTable saveOrUpdateMaterialTable(Session paramSession, SponLineItem paramSponLineItem)
        {
            SponLineItem sponLineItem;

            for (sponLineItem = (SponLineItem)paramSponLineItem.Parent; string.ReferenceEquals(sponLineItem.WbsCode, null); sponLineItem = (SponLineItem)sponLineItem.Parent)
            {
                ;
            }
            null            = BlankResourceInitializer.createBlankMaterial(null);
            null.MaterialId = null;
            null.Title      = paramSponLineItem.makeShortTitle();
            string str = convertToCostOSUnit(paramSponLineItem.Unit);

            if (string.ReferenceEquals(str, null))
            {
                throw new Exception("FATAL: UNIT WAS NULL FOR " + paramSponLineItem.Unit);
            }
            null.GroupCode           = sponLineItem.WbsCode + " - " + sponLineItem.makeShortTitle();
            null.GekCode             = "";
            null.ExtraCode1          = "";
            null.ExtraCode2          = "";
            null.ExtraCode3          = "";
            null.ExtraCode4          = "";
            null.ExtraCode5          = "";
            null.ExtraCode6          = "";
            null.ExtraCode7          = "";
            null.ExtraCode8          = "";
            null.ExtraCode9          = "";
            null.ExtraCode10         = "";
            null.Unit                = str;
            null.EditorId            = "spon";
            null.Weight              = new BigDecimalFixed("0");
            null.WeightUnit          = "KG";
            null.RawMaterial         = "enum.rm.unspecified";
            null.RawMaterialReliance = new BigDecimalFixed("100");
            null.Rate                = new BigDecimalFixed("" + convertToCostOSRate(paramSponLineItem.Unit, paramSponLineItem.Material));
            null.Project             = "";
            null.Country             = "GB";
            null.StateProvince       = "";
            null.Currency            = "GBP";
            null.Notes               = "SPON Major Rate";
            null.Description         = paramSponLineItem.makeFullDescription() + "\nCODE: " + paramSponLineItem.Code;
            null.LastUpdate          = this.lastUpdate;
            null.Accuracy            = "enum.quotation.accuracy.estimated";
            null.Inclusion           = "enum.inclusion.matonly";
            null.Quantity            = new BigDecimalFixed(0);
            null.DistanceToSite      = new BigDecimalFixed(0);
            null.DistanceUnit        = "MILE";
            null.ShipmentRate        = new BigDecimalFixed(0);
            null.FabricationRate     = new BigDecimalFixed(0);
            null.TotalRate           = null.Rate;
            null.CreateDate          = this.lastUpdate;
            null.CreateUserId        = "spon";
            null.recalculate();
            long?long = null.MaterialId;

            if (long == null)
            {
                long = (long?)paramSession.save(null);
            }
            else
            {
                paramSession.update(null);
            }
            return((MaterialTable)DatabaseDBUtil.loadBulk(typeof(MaterialTable), new long?[] { long })[0]);
        }
Exemplo n.º 5
0
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private void saveOrUpdateAssemblyTable(org.hibernate.Session paramSession, Desktop.common.nomitech.common.migration.spon.SponLineItem paramSponLineItem, nomitech.common.db.local.MaterialTable paramMaterialTable, nomitech.common.db.local.SubcontractorTable paramSubcontractorTable, nomitech.common.db.local.EquipmentTable paramEquipmentTable) throws Exception
        private void saveOrUpdateAssemblyTable(Session paramSession, SponLineItem paramSponLineItem, MaterialTable paramMaterialTable, SubcontractorTable paramSubcontractorTable, EquipmentTable paramEquipmentTable)
        {
            SponLineItem sponLineItem;

            for (sponLineItem = (SponLineItem)paramSponLineItem.Parent; string.ReferenceEquals(sponLineItem.WbsCode, null); sponLineItem = (SponLineItem)sponLineItem.Parent)
            {
                ;
            }
            AssemblyTable assemblyTable = BlankResourceInitializer.createBlankAssembly(null);

            assemblyTable.AssemblyId = null;
            assemblyTable.Title      = paramSponLineItem.makeShortTitle();
            string str = convertToCostOSUnit(paramSponLineItem.Unit);

            if (string.ReferenceEquals(str, null))
            {
                throw new Exception("FATAL: UNIT WAS NULL FOR " + paramSponLineItem.Unit);
            }
            assemblyTable.GroupCode             = sponLineItem.WbsCode + " - " + sponLineItem.makeShortTitle();
            assemblyTable.GekCode               = "";
            assemblyTable.Unit                  = str;
            assemblyTable.EditorId              = "spon";
            assemblyTable.StateProvince         = "";
            assemblyTable.Country               = "GB";
            assemblyTable.Currency              = "GBP";
            assemblyTable.Productivity          = BigDecimalMath.ZERO;
            assemblyTable.Project               = "";
            assemblyTable.PublishedRate         = new BigDecimalFixed("" + convertToCostOSRate(paramSponLineItem.Unit, paramSponLineItem.Total));
            assemblyTable.PublishedRevisionCode = paramSponLineItem.Code;
            assemblyTable.Notes                 = "SPON Major Rate";
            assemblyTable.Description           = paramSponLineItem.makeFullDescription() + "\nCODE: " + paramSponLineItem.Code;
            assemblyTable.Virtual               = false;
            assemblyTable.VirtualEquipment      = false;
            assemblyTable.VirtualSubcontractor  = false;
            assemblyTable.VirtualLabor          = false;
            assemblyTable.VirtualMaterial       = false;
            assemblyTable.VirtualConsumable     = false;
            assemblyTable.LastUpdate            = this.lastUpdate;
            assemblyTable.Quantity              = new BigDecimalFixed("0");
            assemblyTable.Accuracy              = "enum.quotation.accuracy.estimated";
            assemblyTable.CreateDate            = assemblyTable.LastUpdate;
            assemblyTable.CreateUserId          = "spon";
            Serializable serializable = assemblyTable.AssemblyId;

            if (serializable == null)
            {
                serializable = paramSession.save(assemblyTable);
            }
            else
            {
                paramSession.update(assemblyTable);
            }
            assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), serializable);
            if (paramSubcontractorTable != null)
            {
                paramSubcontractorTable = (SubcontractorTable)DatabaseDBUtil.loadBulk(typeof(SubcontractorTable), new long?[] { paramSubcontractorTable.SubcontractorId })[0];
                AssemblySubcontractorTable assemblySubcontractorTable = new AssemblySubcontractorTable();
                assemblySubcontractorTable.Factor1                     = BigDecimalMath.ONE;
                assemblySubcontractorTable.Factor2                     = BigDecimalMath.ONE;
                assemblySubcontractorTable.Factor3                     = BigDecimalMath.ONE;
                assemblySubcontractorTable.QuantityPerUnit             = BigDecimalMath.ONE;
                assemblySubcontractorTable.QuantityPerUnitFormula      = "";
                assemblySubcontractorTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA;
                assemblySubcontractorTable.LocalFactor                 = BigDecimalMath.ONE;
                assemblySubcontractorTable.LocalCountry                = "";
                assemblySubcontractorTable.LocalStateProvince          = "";
                assemblySubcontractorTable.LastUpdate                  = assemblyTable.LastUpdate;
                long?long = (long?)paramSession.save(assemblySubcontractorTable);
                assemblySubcontractorTable.AssemblySubcontractorId = long;
                if (DatabaseDBUtil.LocalCommunication)
                {
                    paramSubcontractorTable.AssemblySubcontractorSet.Add(assemblySubcontractorTable);
                    paramSession.saveOrUpdate(paramSubcontractorTable);
                    assemblyTable.AssemblySubcontractorSet.Add(assemblySubcontractorTable);
                    paramSession.saveOrUpdate(assemblyTable);
                    assemblySubcontractorTable.SubcontractorTable = paramSubcontractorTable;
                    assemblySubcontractorTable.AssemblyTable      = assemblyTable;
                    paramSession.saveOrUpdate(assemblySubcontractorTable);
                }
                else
                {
                    assemblySubcontractorTable = (AssemblySubcontractorTable)DatabaseDBUtil.associateAssemblyResource(assemblyTable, paramSubcontractorTable, assemblySubcontractorTable);
                    assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id);
                }
            }
            if (paramMaterialTable != null)
            {
                paramMaterialTable = (MaterialTable)DatabaseDBUtil.loadBulk(typeof(MaterialTable), new long?[] { paramMaterialTable.MaterialId })[0];
                AssemblyMaterialTable assemblyMaterialTable = new AssemblyMaterialTable();
                assemblyMaterialTable.Factor1                     = BigDecimalMath.ONE;
                assemblyMaterialTable.Factor2                     = BigDecimalMath.ONE;
                assemblyMaterialTable.Factor3                     = BigDecimalMath.ONE;
                assemblyMaterialTable.QuantityPerUnit             = BigDecimalMath.ONE;
                assemblyMaterialTable.QuantityPerUnitFormula      = "";
                assemblyMaterialTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA;
                assemblyMaterialTable.LocalFactor                 = BigDecimalMath.ONE;
                assemblyMaterialTable.LocalCountry                = "";
                assemblyMaterialTable.LocalStateProvince          = "";
                assemblyMaterialTable.LastUpdate                  = assemblyTable.LastUpdate;
                long?long = (long?)paramSession.save(assemblyMaterialTable);
                assemblyMaterialTable.AssemblyMaterialId = long;
                if (DatabaseDBUtil.LocalCommunication)
                {
                    paramMaterialTable.AssemblyMaterialSet.Add(assemblyMaterialTable);
                    paramSession.saveOrUpdate(paramMaterialTable);
                    assemblyTable.AssemblyMaterialSet.Add(assemblyMaterialTable);
                    paramSession.saveOrUpdate(assemblyTable);
                    assemblyMaterialTable.MaterialTable = paramMaterialTable;
                    assemblyMaterialTable.AssemblyTable = assemblyTable;
                    paramSession.saveOrUpdate(assemblyMaterialTable);
                }
                else
                {
                    assemblyMaterialTable = (AssemblyMaterialTable)DatabaseDBUtil.associateAssemblyResource(assemblyTable, paramMaterialTable, assemblyMaterialTable);
                    assemblyTable         = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id);
                }
            }
            if (paramEquipmentTable != null)
            {
                paramEquipmentTable = (EquipmentTable)DatabaseDBUtil.loadBulk(typeof(EquipmentTable), new long?[] { paramEquipmentTable.EquipmentId })[0];
                AssemblyEquipmentTable assemblyEquipmentTable = new AssemblyEquipmentTable();
                assemblyEquipmentTable.Factor1                     = BigDecimalMath.ONE;
                assemblyEquipmentTable.Factor2                     = BigDecimalMath.ONE;
                assemblyEquipmentTable.Factor3                     = BigDecimalMath.ONE;
                assemblyEquipmentTable.QuantityPerUnit             = BigDecimalMath.ONE;
                assemblyEquipmentTable.QuantityPerUnitFormula      = "";
                assemblyEquipmentTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA;
                assemblyEquipmentTable.LocalFactor                 = BigDecimalMath.ONE;
                assemblyEquipmentTable.LocalCountry                = "";
                assemblyEquipmentTable.LocalStateProvince          = "";
                assemblyEquipmentTable.EnergyPrice                 = BigDecimalMath.ZERO;
                assemblyEquipmentTable.FuelRate                    = BigDecimalMath.ZERO;
                assemblyEquipmentTable.LastUpdate                  = assemblyTable.LastUpdate;
                long?long = (long?)paramSession.save(assemblyEquipmentTable);
                assemblyEquipmentTable.AssemblyEquipmentId = long;
                if (DatabaseDBUtil.LocalCommunication)
                {
                    paramEquipmentTable.AssemblyEquipmentSet.Add(assemblyEquipmentTable);
                    paramSession.saveOrUpdate(paramEquipmentTable);
                    assemblyTable.AssemblyEquipmentSet.Add(assemblyEquipmentTable);
                    paramSession.saveOrUpdate(assemblyTable);
                    assemblyEquipmentTable.EquipmentTable = paramEquipmentTable;
                    assemblyEquipmentTable.AssemblyTable  = assemblyTable;
                    paramSession.saveOrUpdate(assemblyEquipmentTable);
                }
                else
                {
                    assemblyEquipmentTable = (AssemblyEquipmentTable)DatabaseDBUtil.associateAssemblyResource(assemblyTable, paramEquipmentTable, assemblyEquipmentTable);
                    assemblyTable          = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id);
                }
            }
            assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id);
            assemblyTable.recalculate();
            paramSession.update(assemblyTable);
        }