//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]); }
//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]); }
//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]); }
//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); }