private void createSubcontractor(Session paramSession, AssemblyTable paramAssemblyTable, string paramString1, decimal paramBigDecimal1, string paramString2, decimal paramBigDecimal2) { SubcontractorTable subcontractorTable = BlankResourceInitializer.createBlankSubcontractor(paramAssemblyTable); subcontractorTable.Title = paramString1; subcontractorTable.Unit = paramString2; subcontractorTable.Rate = paramBigDecimal1; subcontractorTable.Currency = "USD"; subcontractorTable.EditorId = "admin"; subcontractorTable.Country = "US"; subcontractorTable.LastUpdate = this.lastUpdate; subcontractorTable.CreateDate = this.lastUpdate; subcontractorTable.CreateUserId = "admin"; subcontractorTable.EditorId = "admin"; long?long = (long?)paramSession.save(subcontractorTable.clone()); subcontractorTable.Id = long; subcontractorTable = (SubcontractorTable)paramSession.load(typeof(SubcontractorTable), long); AssemblySubcontractorTable assemblySubcontractorTable = new AssemblySubcontractorTable(); assemblySubcontractorTable.Factor1 = BigDecimalMath.ONE; assemblySubcontractorTable.Factor2 = BigDecimalMath.ONE; assemblySubcontractorTable.Factor3 = BigDecimalMath.ONE; assemblySubcontractorTable.ExchangeRate = BigDecimalMath.ONE; assemblySubcontractorTable.QuantityPerUnit = paramBigDecimal2; assemblySubcontractorTable.QuantityPerUnitFormula = ""; assemblySubcontractorTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblySubcontractorTable.LocalFactor = BigDecimalMath.ONE; assemblySubcontractorTable.LocalCountry = ""; assemblySubcontractorTable.LocalStateProvince = ""; assemblySubcontractorTable.LastUpdate = paramAssemblyTable.LastUpdate; long = (long?)paramSession.save(assemblySubcontractorTable); assemblySubcontractorTable.AssemblySubcontractorId = long; paramAssemblyTable.AssemblySubcontractorSet.Add(assemblySubcontractorTable); paramSession.saveOrUpdate(paramAssemblyTable); assemblySubcontractorTable.SubcontractorTable = subcontractorTable; assemblySubcontractorTable.AssemblyTable = paramAssemblyTable; paramSession.saveOrUpdate(assemblySubcontractorTable); }
//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); }
private void assignToResource(Session paramSession, AssemblyTable paramAssemblyTable, ResourceTable paramResourceTable, decimal paramBigDecimal) { AssemblyConsumableTable assemblyConsumableTable; if (paramResourceTable is AssemblyTable) { assemblyConsumableTable = new AssemblyAssemblyTable(); ((AssemblyAssemblyTable)assemblyConsumableTable).LastUpdate = this.lastUpdate; } else if (paramResourceTable is EquipmentTable) { assemblyConsumableTable = new AssemblyEquipmentTable(); ((AssemblyEquipmentTable)assemblyConsumableTable).LastUpdate = this.lastUpdate; } else if (paramResourceTable is SubcontractorTable) { assemblyConsumableTable = new AssemblySubcontractorTable(); ((AssemblySubcontractorTable)assemblyConsumableTable).LastUpdate = this.lastUpdate; } else if (paramResourceTable is LaborTable) { assemblyConsumableTable = new AssemblyLaborTable(); ((AssemblyLaborTable)assemblyConsumableTable).LastUpdate = this.lastUpdate; } else if (paramResourceTable is MaterialTable) { assemblyConsumableTable = new AssemblyMaterialTable(); ((AssemblyMaterialTable)assemblyConsumableTable).LastUpdate = this.lastUpdate; } else if (paramResourceTable is ConsumableTable) { assemblyConsumableTable = new AssemblyConsumableTable(); ((AssemblyConsumableTable)assemblyConsumableTable).LastUpdate = this.lastUpdate; } else { return; } assemblyConsumableTable.ExchangeRate = BigDecimalMath.ONE; assemblyConsumableTable.LocalStateProvince = ""; assemblyConsumableTable.LocalCountry = ""; assemblyConsumableTable.LocalFactor = BigDecimalMath.ONE; assemblyConsumableTable.Factor1 = BigDecimalMath.ONE; assemblyConsumableTable.Factor2 = BigDecimalMath.ONE; assemblyConsumableTable.Factor3 = BigDecimalMath.ONE; assemblyConsumableTable.QuantityPerUnit = paramBigDecimal; assemblyConsumableTable.QuantityPerUnitFormula = ""; assemblyConsumableTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; long?long = (long?)paramSession.save(assemblyConsumableTable); ResourceToAssignmentTable resourceToAssignmentTable = (ResourceToAssignmentTable)paramSession.load(assemblyConsumableTable.GetType(), long); if (paramResourceTable is AssemblyTable) { paramAssemblyTable.AssemblyChildSet.Add((AssemblyAssemblyTable)resourceToAssignmentTable); } else if (paramResourceTable is EquipmentTable) { paramAssemblyTable.AssemblyEquipmentSet.Add((AssemblyEquipmentTable)resourceToAssignmentTable); } else if (paramResourceTable is SubcontractorTable) { paramAssemblyTable.AssemblySubcontractorSet.Add((AssemblySubcontractorTable)resourceToAssignmentTable); } else if (paramResourceTable is LaborTable) { paramAssemblyTable.AssemblyLaborSet.Add((AssemblyLaborTable)resourceToAssignmentTable); } else if (paramResourceTable is MaterialTable) { paramAssemblyTable.AssemblyMaterialSet.Add((AssemblyMaterialTable)resourceToAssignmentTable); } else if (paramResourceTable is ConsumableTable) { paramAssemblyTable.AssemblyConsumableSet.Add((AssemblyConsumableTable)resourceToAssignmentTable); } resourceToAssignmentTable.setResourceTable(paramAssemblyTable); resourceToAssignmentTable.AssignmentResourceTable = paramResourceTable; paramSession.update(paramAssemblyTable); paramSession.update(paramResourceTable); paramSession.update(resourceToAssignmentTable); }