public virtual SupplierTable convertToSupplierTable(ProjectDBProperties prop) { SupplierTable obj = BlankResourceInitializer.createBlankSupplier(null); obj.DatabaseId = SupplierDatabaseId; if (DatabaseCreationDate == null) { obj.DatabaseCreationDate = 100L; //ResourceUtil.MISSING_DB_CREATE_DATE); } else { obj.DatabaseCreationDate = DatabaseCreationDate; } obj.Address = quotationTable.Address; obj.Title = quotationTable.CompanyName; obj.ContactPerson = quotationTable.ContactPerson; obj.GroupCode = boqItemTable.GroupCode; obj.GekCode = boqItemTable.GekCode; obj.Description = boqItemTable.Description; obj.Notes = boqItemTable.Notes; obj.EditorId = DatabaseDBUtil.Properties.UserId; obj.PhoneNumber = quotationTable.PhoneNumber; obj.MobileNumber = quotationTable.MobileNumber; obj.Email = quotationTable.Email; obj.Url = quotationTable.Url; obj.Country = quotationTable.Country; obj.City = quotationTable.City; obj.StateProvince = quotationTable.StateProvince; obj.GeoLocation = quotationTable.GeoLocation; obj.FaxNumber = quotationTable.FaxNumber; obj.Performance = "" + quotationTable.Performance; obj.ExtraCode1 = boqItemTable.ExtraCode1; obj.ExtraCode2 = boqItemTable.ExtraCode2; obj.ExtraCode3 = boqItemTable.ExtraCode3; obj.ExtraCode4 = boqItemTable.ExtraCode4; obj.ExtraCode5 = boqItemTable.ExtraCode5; obj.ExtraCode6 = boqItemTable.ExtraCode6; obj.ExtraCode7 = boqItemTable.ExtraCode7; obj.ExtraCode8 = boqItemTable.ExtraCode8; obj.ExtraCode9 = boqItemTable.ExtraCode9; obj.ExtraCode10 = boqItemTable.ExtraCode10; obj.CreateUserId = quotationTable.EditorId; if (quotationTable.ReceivedDate != null) { obj.LastUpdate = quotationTable.ReceivedDate; obj.CreateDate = quotationTable.ReceivedDate; } else { obj.LastUpdate = DateTime.Now; obj.CreateDate = obj.LastUpdate; } obj.recalculate(); return(obj); }
public virtual void mergeToOne(Session paramSession, IList <ParamItemTable> paramList, string paramString) { this.o_descToAccessRightsMap = new Hashtable(); System.Collections.IList list1 = createInputList(paramSession, paramList); System.Collections.IList list2 = createOutputList(paramSession, paramList); ParamItemTable paramItemTable1 = (ParamItemTable)paramList[0]; ParamItemTable paramItemTable2 = BlankResourceInitializer.createBlankParamItem(paramItemTable1); if (!StringUtils.isNullOrBlank(this.o_rootNode.UserObject.ToString())) { paramItemTable2.Title = StringUtils.makeShortTitle(this.o_rootNode.UserObject.ToString()); } else { if (paramString.IndexOf(" - ", StringComparison.Ordinal) != -1) { paramString = paramString.Substring(paramString.IndexOf(" -", StringComparison.Ordinal) + 2); } paramItemTable2.Title = paramString.ToUpper(); } paramItemTable2.Description = this.o_rootNode.UserObject.ToString(); paramItemTable2.SampleRate = BigDecimalMath.ZERO; paramItemTable2.CostModel = true; paramItemTable2.EditorId = paramItemTable1.EditorId; paramItemTable2.AccessRights = "ALL,NODOC"; paramItemTable2.Keywords = paramItemTable1.Keywords; paramItemTable2.Notes = "ALL,NODOC"; paramItemTable2.LastUpdate = paramItemTable1.LastUpdate; paramItemTable2.CreateDate = paramItemTable1.LastUpdate; paramItemTable2.CreateUserId = paramItemTable1.CreateUserId; paramItemTable2.InputSet = new HashSet <object>(); paramItemTable2.OutputSet = new HashSet <object>(); long?long = (long?)paramSession.save(paramItemTable2); paramItemTable2 = (ParamItemTable)paramSession.load(typeof(ParamItemTable), long); foreach (ParamItemInputTable paramItemInputTable in list1) { long = (long?)paramSession.save(paramItemInputTable); paramItemInputTable = (ParamItemInputTable)paramSession.load(typeof(ParamItemInputTable), long); paramItemTable2.InputSet.Add(paramItemInputTable); paramItemInputTable.ParamItemTable = paramItemTable2; paramSession.update(paramItemInputTable); } foreach (ParamItemOutputTable paramItemOutputTable in list2) { long = (long?)paramSession.save(paramItemOutputTable); paramItemOutputTable = (ParamItemOutputTable)paramSession.load(typeof(ParamItemOutputTable), long); paramItemTable2.OutputSet.Add(paramItemOutputTable); paramItemOutputTable.ParamItemTable = paramItemTable2; paramSession.update(paramItemOutputTable); } }
public virtual void valueChanged(Range param1Range, Expr param1Expr) { string str = BoqItemFormulaEvaluator.fieldFromVariable(param1Range.Dimension1Name); if (!string.ReferenceEquals(str, null) && formulaFields.Contains(str + "Formula")) { try { object @object = valueFromExpression(param1Expr); if (@object is decimal) { @object = ((decimal)@object).setScale(10, 4); } BlankResourceInitializer.setFieldValue(outerInstance.boqTable, str, @object); } catch (Exception exception) { Console.WriteLine("CAN NOT EVALUATE: " + str + " = " + param1Expr + " = " + valueFromExpression(param1Expr)); Console.WriteLine(exception.ToString()); Console.Write(exception.StackTrace); } } else { ResourceToAssignmentTable resourceToAssignmentTable = (ResourceToAssignmentTable)outerInstance.assignmentsWithFormulasMap[param1Range.Dimension1Name]; if (resourceToAssignmentTable != null) { decimal bigDecimal = resourceToAssignmentTable.QuantityPerUnit.setScale(10, 4); object @object = valueFromExpression(param1Expr); if (@object is decimal) { decimal bigDecimal1 = (decimal)@object; if (resourceToAssignmentTable.AssignmentResourceTable is nomitech.common.db.local.LaborTable || resourceToAssignmentTable.AssignmentResourceTable is nomitech.common.db.local.EquipmentTable) { bigDecimal1 = bigDecimal1 * (ProjectDBUtil.currentProjectDBUtil().Properties.getHoursFromUnit(resourceToAssignmentTable.AssignmentResourceTable.Unit)); } bigDecimal1.setScale(10, 4); if (BigDecimalMath.cmpCheckNulls(bigDecimal, bigDecimal1) != 0) { resourceToAssignmentTable.QuantityPerUnit = bigDecimal1; outerInstance.updatedResourceToAssignmentQtyPerUnitSet.Add(resourceToAssignmentTable); outerInstance.someAssignemntFormulaValueChanged = true; } } } } }
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); }
public virtual SubcontractorTable convertToSubcontractorTable(ProjectDBProperties prop) { SubcontractorTable obj = BlankResourceInitializer.createBlankSubcontractor(null); BoqItemTable boqItemTable = BoqItemTable; QuotationTable quotationTable = QuotationTable; if (Title.IndexOf(boqItemTable.Title, StringComparison.Ordinal) != -1 && Title.IndexOf(boqItemTable.Description, StringComparison.Ordinal) != -1) { obj.Title = StringUtils.makeShortTitle(boqItemTable.Title); } else { obj.Title = StringUtils.makeShortTitle(Title); } obj.DatabaseId = DatabaseId; if (DatabaseCreationDate == null) { obj.DatabaseCreationDate = 100L; //ResourceUtil.MISSING_DB_CREATE_DATE); } else { obj.DatabaseCreationDate = DatabaseCreationDate; } obj.Address = quotationTable.Address; obj.ContactPerson = quotationTable.ContactPerson; obj.GroupCode = boqItemTable.GroupCode; obj.GekCode = boqItemTable.GekCode; obj.Performance = "" + quotationTable.Performance; obj.Project = prop.getProperty("project.code") + " - " + prop.getProperty("project.name"); obj.Description = boqItemTable.Description; obj.Notes = boqItemTable.Notes; obj.EditorId = DatabaseDBUtil.Properties.UserId; obj.PhoneNumber = quotationTable.PhoneNumber; obj.MobileNumber = quotationTable.MobileNumber; obj.Email = quotationTable.Email; obj.Country = quotationTable.Country; obj.City = quotationTable.City; obj.StateProvince = quotationTable.StateProvince; obj.SubMaterialRate = MaterialRate; obj.Rate = RateWithIndirect; obj.SubMaterialRate = MaterialRate; obj.IKA = Insurance; obj.Quantity = Quantity; obj.TotalRate = calculateFinalRate(); obj.Unit = Unit; obj.Url = quotationTable.Url; obj.Company = quotationTable.CompanyName; obj.FaxNumber = quotationTable.FaxNumber; obj.Currency = quotationTable.Currency; obj.Accuracy = SubcontractorTable.QUOTED_ACCURACY; if (quotationTable.HasMaterialRate.Value) { obj.Inclusion = SubcontractorTable.MATERIAL_AND_SHIPMENT_INCLUSION; } else { obj.Inclusion = SubcontractorTable.NONE_INCLUSION; } obj.CreateUserId = quotationTable.EditorId; if (quotationTable.ReceivedDate != null) { obj.LastUpdate = quotationTable.ReceivedDate; obj.CreateDate = quotationTable.ReceivedDate; } else { obj.LastUpdate = DateTime.Now; obj.CreateDate = obj.LastUpdate; } obj.ExtraCode1 = boqItemTable.ExtraCode1; obj.ExtraCode2 = boqItemTable.ExtraCode2; obj.ExtraCode3 = boqItemTable.ExtraCode3; obj.ExtraCode4 = boqItemTable.ExtraCode4; obj.ExtraCode5 = boqItemTable.ExtraCode5; obj.ExtraCode6 = boqItemTable.ExtraCode6; obj.ExtraCode7 = boqItemTable.ExtraCode7; obj.ExtraCode8 = boqItemTable.ExtraCode8; obj.ExtraCode9 = boqItemTable.ExtraCode9; obj.ExtraCode10 = boqItemTable.ExtraCode10; obj.recalculate(); return(obj); }
public virtual MaterialTable convertToMaterialTable(ProjectDBProperties prop) { MaterialTable obj = BlankResourceInitializer.createBlankMaterial(null); BoqItemTable boqItemTable = BoqItemTable; QuotationTable quotationTable = QuotationTable; double[] projectGeoPosition = StringUtils.extractDoubles(prop.getProperty("project.geolocation")); double[] supplierGeoPosition = StringUtils.extractDoubles(quotationTable.GeoLocation); double distanceKm = HaversineDistanceUtil.distance(HaversineDistanceUtil.KM_DISTANCE, projectGeoPosition, supplierGeoPosition); if (Title.IndexOf(boqItemTable.Title, StringComparison.Ordinal) != -1 && Title.IndexOf(boqItemTable.Description, StringComparison.Ordinal) != -1) { obj.Title = StringUtils.makeShortTitle(boqItemTable.Title); } else { obj.Title = StringUtils.makeShortTitle(Title); } obj.DatabaseId = DatabaseId; if (DatabaseCreationDate == null) { obj.DatabaseCreationDate = 100L; //ResourceUtil.MISSING_DB_CREATE_DATE); } else { obj.DatabaseCreationDate = DatabaseCreationDate; } obj.Weight = BigDecimalMath.ZERO; obj.WeightUnit = "KG"; obj.GroupCode = boqItemTable.GroupCode; obj.GekCode = boqItemTable.GekCode; obj.Project = prop.getProperty("project.code") + " - " + prop.getProperty("project.name"); obj.Description = boqItemTable.Description; obj.Notes = boqItemTable.Notes; obj.EditorId = DatabaseDBUtil.Properties.UserId; obj.Country = quotationTable.Country; obj.StateProvince = quotationTable.StateProvince; obj.Rate = Rate; obj.DistanceToSite = new BigDecimalFixed("" + distanceKm); obj.DistanceUnit = "KM"; obj.RawMaterial = MaterialTable.UNSPECIFIED_RAWMAT; obj.RawMaterialReliance = BigDecimalMath.ZERO; obj.CreateUserId = quotationTable.EditorId; if (quotationTable.ReceivedDate != null) { obj.LastUpdate = quotationTable.ReceivedDate; obj.CreateDate = quotationTable.ReceivedDate; } else { obj.LastUpdate = DateTime.Now; obj.CreateDate = obj.LastUpdate; } if (quotationTable.OnSiteDelivery.Value) { if (ShipmentCost != null) { decimal indirectRate = BigDecimalMath.ZERO; if (IndirectCost != null) { decimal qty = Quantity; if (BigDecimalMath.cmpCheckNulls(qty, BigDecimalMath.ZERO) == 0) { qty = BigDecimalMath.ONE; } obj.ShipmentRate = BigDecimalMath.div(shipmentCost, qty); } // double qty = getQuantity().doubleValue(); // if ( qty == 0 ) // qty = 1; // double srate = shipmentCost.doubleValue()/getQuantity().doubleValue(); // obj.setShipmentRate(new BigDecimalFixed(""+srate)); } else { obj.ShipmentRate = BigDecimalMath.ZERO; } obj.Inclusion = MaterialTable.SHIPMENT_INCLUSION; } else { obj.Inclusion = MaterialTable.NONE_INCLUSION; obj.ShipmentRate = BigDecimalMath.ZERO; } obj.FabricationRate = BigDecimalMath.ZERO; obj.TotalRate = obj.Rate + obj.ShipmentRate; obj.Quantity = Quantity; obj.Unit = Unit; obj.Currency = quotationTable.Currency; obj.Accuracy = MaterialTable.QUOTED_ACCURACY; obj.ExtraCode1 = boqItemTable.ExtraCode1; obj.ExtraCode2 = boqItemTable.ExtraCode2; obj.ExtraCode3 = boqItemTable.ExtraCode3; obj.ExtraCode4 = boqItemTable.ExtraCode4; obj.ExtraCode5 = boqItemTable.ExtraCode5; obj.ExtraCode6 = boqItemTable.ExtraCode6; obj.ExtraCode7 = boqItemTable.ExtraCode7; obj.ExtraCode8 = boqItemTable.ExtraCode8; obj.ExtraCode9 = boqItemTable.ExtraCode9; obj.ExtraCode10 = boqItemTable.ExtraCode10; boqItemTable.loadBimMaterialsAndTypes(); obj.BimMaterial = boqItemTable.BimMaterial; obj.BimType = boqItemTable.BimType; obj.recalculate(); return(obj); }
public virtual BoqItemTable convertToBoqItem(DateTime projectStartDate, long?code, ProjectDBUtil currentDBUtil, bool online, bool useProductivity, bool replaceQuantity) { BoqItemTable boqTable = BlankResourceInitializer.createBlankBoqItem(this, code, projectStartDate, useProductivity); Timestamp updateTime = new Timestamp(DateTimeHelper.CurrentUnixTimeMillis()); //if ( useProductivity ) { // boqTable.setCalculationType(BoqItemTable.s_PRODUCTIVITY_METHOD); //} //else { // boqTable.setCalculationType(BoqItemTable.s_TOTAL_UNITS_METHOD); //} //boqTable.setProductivity(BigDecimalMath.ONE); //boqTable.setQuantity(BigDecimalMath.ONE); //boqTable.setDuration(BigDecimalMath.ONE); boqTable.LastUpdate = updateTime; boqTable.CreateDate = updateTime; boqTable.BoqItemAssemblySet = new HashSet <object>(); boqTable.BoqItemEquipmentSet = new HashSet <object>(); boqTable.BoqItemSubcontractorSet = new HashSet <object>(); boqTable.BoqItemLaborSet = new HashSet <object>(); boqTable.BoqItemMaterialSet = new HashSet <object>(); boqTable.BoqItemConsumableSet = new HashSet <object>(); boqTable.BoqItemConditionSet = new HashSet <object>(); ConditionTable conditionTable = (ConditionTable)convertToConditionTable(); BoqItemConditionTable boqConditionTable = new BoqItemConditionTable(); boqConditionTable.Factor1 = BigDecimalMath.ONE; boqConditionTable.Factor2 = BigDecimalMath.ONE; boqConditionTable.QuantityPerUnit = BigDecimalMath.ONE; boqConditionTable.Sumup = BigDecimalMath.ZERO; if (replaceQuantity) { if (conditionTable.DefaultQuantity == null || conditionTable.DefaultQuantity == 0 || conditionTable.DefaultQuantity == 1) { boqTable.Quantity = conditionTable.Quantity1; } else if (conditionTable.DefaultQuantity == 2) { boqTable.Quantity = conditionTable.Quantity2; } else if (conditionTable.DefaultQuantity == 3) { boqTable.Quantity = conditionTable.Quantity3; } else if (conditionTable.DefaultQuantity == 4) { boqTable.Quantity = conditionTable.QuantityF; } } if (conditionTable.DefaultQuantity == null || conditionTable.DefaultQuantity == 0 || conditionTable.DefaultQuantity == 1) { boqConditionTable.SelectedUnit = BoqItemConditionTable.SELECTED_UNIT1; boqTable.Quantity = conditionTable.Quantity1; boqTable.MeasuredQuantity = conditionTable.Quantity1; //boqTable.setEstimatedQuantity(conditionTable.getQuantity1()); boqTable.Unit = conditionTable.Unit1; boqTable.SecondUnit = Unit1ToUnit2Util.Instance.getUnit2(conditionTable.Unit1); boqTable.UnitsDiv = Unit1ToUnit2Util.Instance.getUnitDiv(conditionTable.Unit1); } else if (conditionTable.DefaultQuantity == 2) { boqConditionTable.SelectedUnit = BoqItemConditionTable.SELECTED_UNIT2; boqTable.Quantity = conditionTable.Quantity2; boqTable.MeasuredQuantity = conditionTable.Quantity2; //boqTable.setEstimatedQuantity(conditionTable.getQuantity2()); boqTable.Unit = conditionTable.Unit2; boqTable.SecondUnit = Unit1ToUnit2Util.Instance.getUnit2(conditionTable.Unit2); boqTable.UnitsDiv = Unit1ToUnit2Util.Instance.getUnitDiv(conditionTable.Unit2); } else if (conditionTable.DefaultQuantity == 3) { boqConditionTable.SelectedUnit = BoqItemConditionTable.SELECTED_UNIT3; boqTable.Quantity = conditionTable.Quantity3; //boqTable.setEstimatedQuantity(conditionTable.getQuantity3()); boqTable.MeasuredQuantity = conditionTable.Quantity3; boqTable.Unit = conditionTable.Unit3; boqTable.SecondUnit = Unit1ToUnit2Util.Instance.getUnit2(conditionTable.Unit3); boqTable.UnitsDiv = Unit1ToUnit2Util.Instance.getUnitDiv(conditionTable.Unit3); } else if (conditionTable.DefaultQuantity == 4) { boqConditionTable.SelectedUnit = BoqItemConditionTable.SELECTED_UNITF; boqTable.Quantity = conditionTable.QuantityF; //boqTable.setEstimatedQuantity(conditionTable.getQuantity3()); boqTable.MeasuredQuantity = conditionTable.QuantityF; boqTable.Unit = conditionTable.UnitF; boqTable.SecondUnit = Unit1ToUnit2Util.Instance.getUnit2(conditionTable.UnitF); boqTable.UnitsDiv = Unit1ToUnit2Util.Instance.getUnitDiv(conditionTable.UnitF); } boqConditionTable.LastUpdate = updateTime; boqConditionTable.ConditionTable = conditionTable; boqConditionTable.BoqItemTable = boqTable; boqTable.BoqItemConditionSet.Add(boqConditionTable); boqTable.recalculate(); return(boqTable); }
//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.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 loadWorkgroups(org.hibernate.Session paramSession, String paramString) throws Exception private void loadWorkgroups(Session paramSession, string paramString) { Console.WriteLine("\n\n\n\nLoading Workgroups"); POIFSFileSystem pOIFSFileSystem = new POIFSFileSystem(new FileStream(paramString, FileMode.Open, FileAccess.Read)); HSSFWorkbook hSSFWorkbook = new HSSFWorkbook(pOIFSFileSystem); this.o_evaluator = hSSFWorkbook.CreationHelper.createFormulaEvaluator(); HSSFSheet hSSFSheet = hSSFWorkbook.getSheetAt(4); int i = getRealNumberOfRows(hSSFSheet); int j; for (j = 1; j < i; j++) { if (j % this.rowsToCommit == 0) { paramSession.Transaction.commit(); paramSession.Transaction.begin(); Console.WriteLine("Processing next " + this.rowsToCommit + "..."); } HSSFRow hSSFRow = hSSFSheet.getRow(j); string str1 = notNull(hSSFRow.getCell(0)); string str2 = notNull(hSSFRow.getCell(1)); string str3 = toCostOSUoM(notNull(hSSFRow.getCell(2))); decimal bigDecimal1 = notNullBigDecimal(hSSFRow.getCell(3), 0.0D); decimal bigDecimal2 = notNullBigDecimal(hSSFRow.getCell(4), 1.0D); string str4 = notNull(hSSFRow.getCell(5)); string str5 = notNull(hSSFRow.getCell(8)); string str6 = ""; if (str5.Length >= 2 && !StringUtils.isBlank(str5)) { str6 = "0" + str5.Substring(0, 2) + "00"; } if (acceptProject(str1)) { AssemblyTable assemblyTable = BlankResourceInitializer.createBlankAssembly(null); assemblyTable.ItemCode = str2; assemblyTable.Title = str4; assemblyTable.Unit = str3; assemblyTable.Quantity = bigDecimal1; assemblyTable.Project = str1; assemblyTable.Currency = "USD"; assemblyTable.ActivityBased = false; assemblyTable.AssemblyChildSet = new HashSet <object>(); assemblyTable.AssemblyEquipmentSet = new HashSet <object>(); assemblyTable.AssemblySubcontractorSet = new HashSet <object>(); assemblyTable.AssemblyLaborSet = new HashSet <object>(); assemblyTable.AssemblyMaterialSet = new HashSet <object>(); assemblyTable.AssemblyConsumableSet = new HashSet <object>(); assemblyTable.EditorId = "ccc"; assemblyTable.CreateUserId = "ccc"; assemblyTable.LastUpdate = this.lastUpdate; assemblyTable.CreateDate = this.lastUpdate; assemblyTable.CustomText1 = "Workgroup"; if (this.csi95Map.ContainsKey(str6)) { assemblyTable.GroupCode = (string)this.csi95Map[str6]; } else if (!StringUtils.isBlank(str6)) { Console.WriteLine("CSI Not Found: " + str6); } long?long = (long?)paramSession.save(assemblyTable); assemblyTable = (AssemblyTable)paramSession.load(assemblyTable.GetType(), long); this.operationsMap[str1 + str2] = assemblyTable; } } hSSFSheet = hSSFWorkbook.getSheetAt(3); i = getRealNumberOfRows(hSSFSheet); for (j = 1; j < i; j++) { if (j % this.rowsToCommit == 0) { paramSession.Transaction.commit(); paramSession.Transaction.begin(); Console.WriteLine("Processing next " + this.rowsToCommit + " - " + j + "/" + i + "..."); } HSSFRow hSSFRow = hSSFSheet.getRow(j); string str1 = notNull(hSSFRow.getCell(0)); string str2 = notNull(hSSFRow.getCell(1)); string str3 = notNull(hSSFRow.getCell(2)); string str4 = notNull(hSSFRow.getCell(3)); string str5 = notNull(hSSFRow.getCell(4)); decimal bigDecimal = notNullBigDecimal(hSSFRow.getCell(5), 0.0D); AssemblyTable assemblyTable = (AssemblyTable)this.operationsMap[str1 + str2]; ResourceTable resourceTable = (ResourceTable)this.resourcesMap[str1 + str3]; if (assemblyTable == null) { Console.Error.WriteLine("Workgroup not found: " + str2 + ", project: " + str1); continue; } if (resourceTable == null) { resourceTable = (ResourceTable)this.operationsMap[str1 + str3]; if (resourceTable == null) { Console.Error.WriteLine("Operation or Resource not found: " + str3 + ", project: " + str1); continue; } } if (BigDecimalMath.cmp(BigDecimalMath.ZERO, assemblyTable.Quantity) == 0) { Console.WriteLine("Divide by zero error on workgroup: " + str2 + ", operation or resource: " + str3 + ", project: " + str1); bigDecimal = BigDecimalMath.ONE; } else { bigDecimal = BigDecimalMath.div(bigDecimal, assemblyTable.Quantity); } assignToResource(paramSession, assemblyTable, resourceTable, bigDecimal); paramSession.flush(); assemblyTable = (AssemblyTable)paramSession.load(assemblyTable.GetType(), assemblyTable.Id); assemblyTable.recalculate(); paramSession.update(assemblyTable); continue; } }
//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); }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr) { assertMinArgCount(paramArrayOfExpr, 1); for (sbyte b = 0; b < paramArrayOfExpr.Length; b++) { if (paramArrayOfExpr[b] is org.boris.expr.ExprEvaluatable) { paramArrayOfExpr[b] = evalArg(paramIEvaluationContext, paramArrayOfExpr[b]); } } if (!(paramArrayOfExpr[0] is ExprString)) { throw new ExprException("Input " + paramArrayOfExpr[0].ToString() + " is not a String."); } string str = ((ExprString)paramArrayOfExpr[0]).str; bool bool1; for (bool1 = true; bool1 < paramArrayOfExpr.Length; bool1++) { if (paramArrayOfExpr[bool1] is ExprVariable) { paramArrayOfExpr[bool1] = paramIEvaluationContext.evaluateVariable((ExprVariable)paramArrayOfExpr[bool1]); } if (!(paramArrayOfExpr[bool1] is ExprString) && !(paramArrayOfExpr[bool1] is org.boris.expr.ExprNumber) && !(paramArrayOfExpr[bool1] is ExprBoolean)) { throw new ExprException("Invalid Parameter Value: " + paramArrayOfExpr[bool1]); } } bool1 = true; Session session = null; bool bool2 = true; if (paramIEvaluationContext is ExprAbstractEvaluationContext) { session = ((ExprAbstractEvaluationContext)paramIEvaluationContext).MasterDatabaseSession; if (session == null) { bool1 = DatabaseDBUtil.hasOpenedSession(); session = DatabaseDBUtil.currentSession(); bool2 = DatabaseDBUtil.LocalCommunication; } } string[] arrayOfString = null; int i = 0; try { SQLQuery sQLQuery = null; System.Collections.IList list = Collections.EMPTY_LIST; if (bool2) { Query query; sQLQuery = session.createSQLQuery(str); sQLQuery.Cacheable = true; for (sbyte b2 = 1; b2 < paramArrayOfExpr.Length; b2++) { if (paramArrayOfExpr[b2] is ExprString) { query = sQLQuery.setString(b2 - true, ((ExprString)paramArrayOfExpr[b2]).str); } else if (paramArrayOfExpr[b2] is ExprDouble) { query = query.setDouble(b2 - true, ((ExprDouble)paramArrayOfExpr[b2]).doubleValue()); } else if (paramArrayOfExpr[b2] is ExprInteger) { query = query.setInteger(b2 - true, ((ExprInteger)paramArrayOfExpr[b2]).intValue()); } else if (paramArrayOfExpr[b2] is ExprBoolean) { query = query.setBoolean(b2 - true, ((ExprBoolean)paramArrayOfExpr[b2]).booleanValue()); } } list = query.list(); if (list.Count != 0) { object @object = list[0]; if (@object is BaseEntity) { ClassMetadata classMetadata = ((SessionImplementor)session).Factory.getClassMetadata(@object.GetType()); arrayOfString = classMetadata.PropertyNames; if (arrayOfString == null) { throw new Exception("Invalid class name: " + @object.GetType()); } i = arrayOfString.Length; } else if (@object is object[]) { i = (object[])@object.length; } else { i = 1; } } } else { List <object> arrayList = new List <object>(); for (sbyte b2 = 1; b2 < paramArrayOfExpr.Length; b2++) { if (paramArrayOfExpr[b2] is ExprString) { arrayList.Add(new HqlParameterWithValue(b2 - true, ((ExprString)paramArrayOfExpr[b2]).str)); } else if (paramArrayOfExpr[b2] is ExprDouble) { arrayList.Add(new HqlParameterWithValue(b2 - true, Convert.ToDouble(((ExprDouble)paramArrayOfExpr[b2]).doubleValue()))); } else if (paramArrayOfExpr[b2] is ExprInteger) { arrayList.Add(new HqlParameterWithValue(b2 - true, new long?(((ExprInteger)paramArrayOfExpr[b2]).intValue()))); } else if (paramArrayOfExpr[b2] is ExprBoolean) { arrayList.Add(new HqlParameterWithValue(b2 - true, "" + ((ExprBoolean)paramArrayOfExpr[b2]).booleanValue())); } } throw new System.ArgumentException("not implemented as a web service"); } ExprArray exprArray = new ExprArray(list.Count, i); sbyte b1 = 0; foreach (object @object in list) { if (@object is HqlResultValue[]) { HqlResultValue[] arrayOfHqlResultValue = (HqlResultValue[])@object; for (sbyte b2 = 0; b2 < arrayOfHqlResultValue.Length; b2++) { setArrayValue(exprArray, arrayOfHqlResultValue[b2], b1, b2); } } else if (@object is object[]) { object[] arrayOfObject = (object[])@object; for (sbyte b2 = 0; b2 < arrayOfObject.Length; b2++) { setArrayValue(exprArray, arrayOfObject[b2], b1, b2); } } else if (@object is BaseEntity) { sbyte b2 = 0; foreach (string str1 in arrayOfString) { object object1 = BlankResourceInitializer.getFieldValue((BaseEntity)@object, str1); setArrayValue(exprArray, object1, b1, b2++); } } else if (i == 1) { setArrayValue(exprArray, @object, b1, 0); } else { if (!bool1) { DatabaseDBUtil.closeSession(); } throw new ExprException("Not a persistent class: " + @object.GetType().Name); } b1++; } if (!bool1) { DatabaseDBUtil.closeSession(); } return(exprArray); } catch (Exception exception) { Console.WriteLine(exception.ToString()); Console.Write(exception.StackTrace); if (!bool1) { DatabaseDBUtil.closeSession(); } throw new ExprException(exception.Message); } }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: private void loadLineItems(org.hibernate.Session paramSession, String paramString) throws Exception private void loadLineItems(Session paramSession, string paramString) { POIFSFileSystem pOIFSFileSystem = new POIFSFileSystem(new FileStream(paramString, FileMode.Open, FileAccess.Read)); HSSFWorkbook hSSFWorkbook = new HSSFWorkbook(pOIFSFileSystem); this.o_evaluator = hSSFWorkbook.CreationHelper.createFormulaEvaluator(); HSSFSheet hSSFSheet = hSSFWorkbook.getSheetAt(0); Console.WriteLine("Loading Line Items..."); int i = getRealNumberOfRows(hSSFSheet); string str1 = null; string str2 = null; GroupCodeTable groupCodeTable = null; string str3 = null; for (int j = 1; j < i; j++) { if (j % this.rowsToCommit == 0) { paramSession.Transaction.commit(); paramSession.Transaction.begin(); Console.WriteLine("Processing next 500..."); } HSSFRow hSSFRow = hSSFSheet.getRow(j); string str4 = notNull(hSSFRow.getCell(0)); string str5 = notNull(hSSFRow.getCell(1)); if (!str4.StartsWith("Group", StringComparison.Ordinal)) { string str6 = notNull(hSSFRow.getCell(2)); string str7 = notNull(hSSFRow.getCell(3)); if (!StringUtils.isNullOrBlank(str4)) { Console.WriteLine(str6 + " - " + str7); str1 = str4; str1 = StringUtils.replaceAll(str1, ".", ""); str1 = StringUtils.replaceAll(str1, "-", ""); str1 = str1.Substring(0, 4); str3 = str1; GroupCode groupCode = addGroupCode1(str1, str7); this.dprPhaseMap[str6] = groupCode; paramSession.save(groupCode); } else if (!StringUtils.isNullOrBlank(str5)) { Console.WriteLine(str6 + " - " + str7); str2 = str5; str2 = StringUtils.replaceAll(str2, ".", ""); str2 = StringUtils.replaceAll(str2, "-", ""); str1 = str2.Substring(0, 4); str2 = str2.Substring(4, str2.Length - 4); GroupCode groupCode = addGroupCode1(str3 + "." + str2, str7); this.dprPhaseMap[str6] = groupCode; long?long = (long?)paramSession.save(groupCode); groupCodeTable = (GroupCodeTable)groupCode; groupCodeTable.GroupCodeId = long; } else { decimal bigDecimal1 = notNullBigDecimal(hSSFRow.getCell(4), 1.0D); string str8 = toCorrectUnit(notNull(hSSFRow.getCell(5))); string str9 = notNull(hSSFRow.getCell(6)); decimal bigDecimal2 = notNullBigDecimal(hSSFRow.getCell(7), 0.0D); string str10 = toCorrectUnit(notNull(hSSFRow.getCell(8))); decimal bigDecimal3 = notNullBigDecimal(hSSFRow.getCell(9), 0.0D); string str11 = toCorrectUnit(notNull(hSSFRow.getCell(10))); decimal bigDecimal4 = notNullBigDecimal(hSSFRow.getCell(11), 0.0D); string str12 = notNull(hSSFRow.getCell(12)).ToUpper(); decimal bigDecimal5 = notNullBigDecimal(hSSFRow.getCell(13), 0.0D); string str13 = toCorrectUnit(notNull(hSSFRow.getCell(14))); decimal bigDecimal6 = notNullBigDecimal(hSSFRow.getCell(15), 0.0D); decimal bigDecimal7 = notNullBigDecimal(hSSFRow.getCell(16), 1.0D); string str14 = toCorrectUnit(notNull(hSSFRow.getCell(17))); decimal bigDecimal8 = notNullBigDecimal(hSSFRow.getCell(18), 1.0D); string str15 = toCorrectUnit(notNull(hSSFRow.getCell(19))); decimal bigDecimal9 = notNullBigDecimal(hSSFRow.getCell(20), 0.0D); string str16 = toCorrectUnit(notNull(hSSFRow.getCell(21))); decimal bigDecimal10 = notNullBigDecimal(hSSFRow.getCell(22), 0.0D); decimal bigDecimal11 = notNullBigDecimal(hSSFRow.getCell(23), 0.0D); string str17 = toCorrectUnit(notNull(hSSFRow.getCell(24))); decimal bigDecimal12 = notNullBigDecimal(hSSFRow.getCell(25), 0.0D); string str18 = toCorrectUnit(notNull(hSSFRow.getCell(26))); decimal bigDecimal13 = notNullBigDecimal(hSSFRow.getCell(27), 0.0D); string str19 = toCorrectUnit(notNull(hSSFRow.getCell(28))); decimal bigDecimal14 = notNullBigDecimal(hSSFRow.getCell(29), 0.0D); string str20 = toCorrectUnit(notNull(hSSFRow.getCell(30))); decimal bigDecimal15 = notNullBigDecimal(hSSFRow.getCell(31), 0.0D); decimal bigDecimal16 = notNullBigDecimal(hSSFRow.getCell(32), 1.0D); string str21 = toCorrectUnit(notNull(hSSFRow.getCell(33))); decimal bigDecimal17 = notNullBigDecimal(hSSFRow.getCell(34), 0.0D); string str22 = toCorrectUnit(notNull(hSSFRow.getCell(35))); decimal bigDecimal18 = notNullBigDecimal(hSSFRow.getCell(36), 1.0D); string str23 = toCorrectUnit(notNull(hSSFRow.getCell(37))); decimal bigDecimal19 = notNullBigDecimal(hSSFRow.getCell(38), 0.0D); string str24 = toCorrectUnit(notNull(hSSFRow.getCell(39))); decimal bigDecimal20 = notNullBigDecimal(hSSFRow.getCell(40), 0.0D); decimal bigDecimal21 = notNullBigDecimal(hSSFRow.getCell(41), 0.0D); string str25 = toCorrectUnit(notNull(hSSFRow.getCell(42))); decimal bigDecimal22 = notNullBigDecimal(hSSFRow.getCell(43), 0.0D); string str26 = toCorrectUnit(notNull(hSSFRow.getCell(44))); decimal bigDecimal23 = notNullBigDecimal(hSSFRow.getCell(45), 0.0D); string str27 = toCorrectUnit(notNull(hSSFRow.getCell(46))); decimal bigDecimal24 = notNullBigDecimal(hSSFRow.getCell(47), 0.0D); string str28 = toCorrectUnit(notNull(hSSFRow.getCell(48))); decimal bigDecimal25 = notNullBigDecimal(hSSFRow.getCell(49), 0.0D); decimal bigDecimal26 = notNullBigDecimal(hSSFRow.getCell(50), 0.0D); string str29 = toCorrectUnit(notNull(hSSFRow.getCell(51))); decimal bigDecimal27 = notNullBigDecimal(hSSFRow.getCell(52), 0.0D); Console.WriteLine(str6 + " - " + str7 + " " + str8 + " " + bigDecimal1 + " " + str9 + " " + bigDecimal27); string str30 = notNull(hSSFRow.getCell(53)); string str31 = notNull(hSSFRow.getCell(54)); string str32 = notNull(hSSFRow.getCell(55)); string str33 = notNull(hSSFRow.getCell(56)); string str34 = notNull(hSSFRow.getCell(57)); string str35 = notNull(hSSFRow.getCell(58)); string str36 = notNull(hSSFRow.getCell(59)); AssemblyTable assemblyTable = BlankResourceInitializer.createBlankAssembly(null); assemblyTable.ItemCode = str6; assemblyTable.PublishedRevisionCode = str6; assemblyTable.Title = str7; assemblyTable.Unit = str8; assemblyTable.Currency = "USD"; assemblyTable.Country = "US"; assemblyTable.Quantity = bigDecimal1; assemblyTable.LastUpdate = this.lastUpdate; assemblyTable.Description = ""; assemblyTable.LastUpdate = this.lastUpdate; assemblyTable.CreateDate = this.lastUpdate; assemblyTable.CreateUserId = "admin"; assemblyTable.EditorId = "admin"; if (groupCodeTable != null) { assemblyTable.GroupCode = groupCodeTable.ToString(); } assemblyTable.AssemblyEquipmentSet = new HashSet <object>(); assemblyTable.AssemblySubcontractorSet = new HashSet <object>(); assemblyTable.AssemblyLaborSet = new HashSet <object>(); assemblyTable.AssemblyMaterialSet = new HashSet <object>(); assemblyTable.AssemblyConsumableSet = new HashSet <object>(); long?long = (long?)paramSession.save(assemblyTable.clone()); assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), long); if (!StringUtils.isNullOrBlank(str9)) { LaborTable laborTable = (LaborTable)this.laborCache[str9]; if (laborTable == null) { laborTable = BlankResourceInitializer.createBlankLabor(null); laborTable.Title = str9; laborTable.Unit = "HOUR"; laborTable.Rate = bigDecimal5; laborTable.IKA = BigDecimalMath.ZERO; laborTable.Currency = "USD"; laborTable.Country = "US"; laborTable.LastUpdate = this.lastUpdate; laborTable.CreateDate = this.lastUpdate; laborTable.CreateUserId = "admin"; laborTable.EditorId = "admin"; long = (long?)paramSession.save(laborTable.clone()); laborTable.Id = long; this.laborCache[str9] = laborTable; } else { laborTable = (LaborTable)paramSession.load(typeof(LaborTable), laborTable.Id); } if (BigDecimalMath.cmp(bigDecimal4, BigDecimalMath.ZERO) <= 0 && BigDecimalMath.cmp(bigDecimal2, BigDecimalMath.ZERO) > 0) { bigDecimal4 = BigDecimalMath.div(BigDecimalMath.ONE, bigDecimal2); } laborTable = (LaborTable)paramSession.load(typeof(LaborTable), laborTable.Id); AssemblyLaborTable assemblyLaborTable = new AssemblyLaborTable(); assemblyLaborTable.Factor1 = BigDecimalMath.ONE; assemblyLaborTable.Factor2 = BigDecimalMath.ONE; assemblyLaborTable.Factor3 = BigDecimalMath.ONE; assemblyLaborTable.ExchangeRate = BigDecimalMath.ONE; assemblyLaborTable.QuantityPerUnit = bigDecimal4; assemblyLaborTable.QuantityPerUnitFormula = ""; assemblyLaborTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblyLaborTable.LocalFactor = BigDecimalMath.ONE; assemblyLaborTable.LocalCountry = ""; assemblyLaborTable.LocalStateProvince = ""; assemblyLaborTable.LastUpdate = assemblyTable.LastUpdate; long = (long?)paramSession.save(assemblyLaborTable); assemblyLaborTable.AssemblyLaborId = long; assemblyTable.AssemblyLaborSet.Add(assemblyLaborTable); paramSession.saveOrUpdate(assemblyTable); assemblyLaborTable.LaborTable = laborTable; assemblyLaborTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyLaborTable); } if (bigDecimal14 != null && BigDecimalMath.cmp(bigDecimal14, BigDecimalMath.ZERO) > 0) { if (bigDecimal11 != null && BigDecimalMath.cmp(bigDecimal11, BigDecimalMath.ZERO) > 0) { decimal bigDecimal = bigDecimal13; if (BigDecimalMath.cmp(bigDecimal, BigDecimalMath.ZERO) <= 0 && BigDecimalMath.cmp(bigDecimal11, BigDecimalMath.ZERO) > 0) { bigDecimal = BigDecimalMath.div(BigDecimalMath.ONE, bigDecimal11); } if (str8.Equals("DAY")) { bigDecimal14 = BigDecimalMath.mult(bigDecimal14, BigDecimalMath.div(BigDecimalMath.ONE, HOURS_OF_DAY)); } else if (str8.Equals("WEEK") || str8.Equals("WK")) { bigDecimal14 = BigDecimalMath.mult(bigDecimal14, BigDecimalMath.div(BigDecimalMath.ONE, HOURS_OF_WEEK)); } else if (str8.Equals("MONTH") || str8.Equals("MO")) { bigDecimal14 = BigDecimalMath.mult(bigDecimal14, BigDecimalMath.div(BigDecimalMath.ONE, HOURS_OF_MONTH)); } if (str20.Equals("WEEK")) { bigDecimal = BigDecimalMath.mult(bigDecimal, HOURS_OF_WEEK); } else if (str20.Equals("MO") || str20.Equals("MONTH")) { bigDecimal = BigDecimalMath.mult(bigDecimal, HOURS_OF_MONTH); } else if (str20.Equals("DAY")) { bigDecimal = BigDecimalMath.mult(bigDecimal, HOURS_OF_DAY); } EquipmentTable equipmentTable = BlankResourceInitializer.createBlankEquipment(assemblyTable); equipmentTable.Title = assemblyTable.Title; equipmentTable.Unit = str20; equipmentTable.ReservationRate = bigDecimal14; equipmentTable.Currency = "USD"; equipmentTable.EditorId = "admin"; equipmentTable.Country = "US"; equipmentTable.LastUpdate = this.lastUpdate; equipmentTable.CreateDate = this.lastUpdate; equipmentTable.CreateUserId = "admin"; equipmentTable.EditorId = "admin"; long = (long?)paramSession.save(equipmentTable.clone()); equipmentTable.Id = long; equipmentTable = (EquipmentTable)paramSession.load(typeof(EquipmentTable), long); AssemblyEquipmentTable assemblyEquipmentTable = new AssemblyEquipmentTable(); assemblyEquipmentTable.Factor1 = BigDecimalMath.ONE; assemblyEquipmentTable.Factor2 = BigDecimalMath.ONE; assemblyEquipmentTable.Factor3 = BigDecimalMath.ONE; assemblyEquipmentTable.ExchangeRate = BigDecimalMath.ONE; assemblyEquipmentTable.QuantityPerUnit = bigDecimal; 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?)paramSession.save(assemblyEquipmentTable); assemblyEquipmentTable.AssemblyEquipmentId = long; assemblyTable.AssemblyEquipmentSet.Add(assemblyEquipmentTable); paramSession.saveOrUpdate(assemblyTable); assemblyEquipmentTable.EquipmentTable = equipmentTable; assemblyEquipmentTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyEquipmentTable); } else { createSubcontractor(paramSession, assemblyTable, "Equipment: " + assemblyTable.Title, bigDecimal14, str20, bigDecimal13); } } if (bigDecimal9 != null && BigDecimalMath.cmp(bigDecimal9, BigDecimalMath.ZERO) > 0) { MaterialTable materialTable = BlankResourceInitializer.createBlankMaterial(assemblyTable); materialTable.Title = assemblyTable.Title; materialTable.Unit = str16; materialTable.Rate = bigDecimal9; materialTable.Currency = "USD"; materialTable.EditorId = "admin"; materialTable.Country = "US"; materialTable.LastUpdate = this.lastUpdate; materialTable.CreateDate = this.lastUpdate; materialTable.CreateUserId = "admin"; materialTable.EditorId = "admin"; long = (long?)paramSession.save(materialTable.clone()); materialTable.Id = long; materialTable = (MaterialTable)paramSession.load(typeof(MaterialTable), long); AssemblyMaterialTable assemblyMaterialTable = new AssemblyMaterialTable(); assemblyMaterialTable.Factor1 = BigDecimalMath.ONE; assemblyMaterialTable.Factor2 = BigDecimalMath.ONE; assemblyMaterialTable.Factor3 = BigDecimalMath.ONE; assemblyMaterialTable.ExchangeRate = BigDecimalMath.ONE; assemblyMaterialTable.QuantityPerUnit = bigDecimal8; assemblyMaterialTable.QuantityPerUnitFormula = ""; assemblyMaterialTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblyMaterialTable.LocalFactor = BigDecimalMath.ONE; assemblyMaterialTable.LocalCountry = ""; assemblyMaterialTable.LocalStateProvince = ""; assemblyMaterialTable.LastUpdate = assemblyTable.LastUpdate; long = (long?)paramSession.save(assemblyMaterialTable); assemblyMaterialTable.AssemblyMaterialId = long; assemblyTable.AssemblyMaterialSet.Add(assemblyMaterialTable); paramSession.saveOrUpdate(assemblyTable); assemblyMaterialTable.MaterialTable = materialTable; assemblyMaterialTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyMaterialTable); } if (bigDecimal24 != null && BigDecimalMath.cmp(bigDecimal24, BigDecimalMath.ZERO) > 0) { createSubcontractor(paramSession, assemblyTable, assemblyTable.Title, bigDecimal24, str28, bigDecimal23); } if (bigDecimal19 != null && BigDecimalMath.cmp(bigDecimal19, BigDecimalMath.ZERO) > 0) { ConsumableTable consumableTable = BlankResourceInitializer.createBlankConsumable(assemblyTable); consumableTable.Title = assemblyTable.Title; consumableTable.Unit = str24; consumableTable.Rate = bigDecimal19; consumableTable.Currency = "USD"; consumableTable.EditorId = "admin"; consumableTable.Country = "US"; consumableTable.LastUpdate = this.lastUpdate; consumableTable.CreateDate = this.lastUpdate; consumableTable.CreateUserId = "admin"; consumableTable.EditorId = "admin"; long = (long?)paramSession.save(consumableTable.clone()); consumableTable.Id = long; consumableTable = (ConsumableTable)paramSession.load(typeof(ConsumableTable), long); AssemblyConsumableTable assemblyConsumableTable = new AssemblyConsumableTable(); assemblyConsumableTable.Factor1 = BigDecimalMath.ONE; assemblyConsumableTable.Factor2 = BigDecimalMath.ONE; assemblyConsumableTable.Factor3 = BigDecimalMath.ONE; assemblyConsumableTable.ExchangeRate = BigDecimalMath.ONE; assemblyConsumableTable.QuantityPerUnit = bigDecimal18; assemblyConsumableTable.QuantityPerUnitFormula = ""; assemblyConsumableTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA; assemblyConsumableTable.LocalFactor = BigDecimalMath.ONE; assemblyConsumableTable.LocalCountry = ""; assemblyConsumableTable.LocalStateProvince = ""; assemblyConsumableTable.LastUpdate = assemblyTable.LastUpdate; long = (long?)paramSession.save(assemblyConsumableTable); assemblyConsumableTable.AssemblyConsumableId = long; assemblyTable.AssemblyConsumableSet.Add(assemblyConsumableTable); paramSession.saveOrUpdate(assemblyTable); assemblyConsumableTable.ConsumableTable = consumableTable; assemblyConsumableTable.AssemblyTable = assemblyTable; paramSession.saveOrUpdate(assemblyConsumableTable); } if (DatabaseDBUtil.LocalCommunication) { assemblyTable.recalculate(); paramSession.saveOrUpdate(assemblyTable); } } } } if (hSSFWorkbook != null) { hSSFWorkbook.close(); } }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: public org.boris.expr.Expr evaluate(org.boris.expr.IEvaluationContext paramIEvaluationContext, org.boris.expr.Expr[] paramArrayOfExpr) throws org.boris.expr.ExprException public virtual Expr evaluate(IEvaluationContext paramIEvaluationContext, Expr[] paramArrayOfExpr) { assertMinArgCount(paramArrayOfExpr, 1); for (sbyte b = 0; b < paramArrayOfExpr.Length; b++) { if (paramArrayOfExpr[b] is org.boris.expr.ExprEvaluatable) { paramArrayOfExpr[b] = evalArg(paramIEvaluationContext, paramArrayOfExpr[b]); } } if (!(paramArrayOfExpr[0] is ExprString)) { throw new ExprException("Input " + paramArrayOfExpr[0].ToString() + " is not a String."); } string str = ((ExprString)paramArrayOfExpr[0]).str; bool @bool; for (@bool = true; @bool < paramArrayOfExpr.Length; @bool++) { if (paramArrayOfExpr[@bool] is ExprVariable) { paramArrayOfExpr[@bool] = paramIEvaluationContext.evaluateVariable((ExprVariable)paramArrayOfExpr[@bool]); } if (!(paramArrayOfExpr[@bool] is ExprString) && !(paramArrayOfExpr[@bool] is org.boris.expr.ExprNumber) && !(paramArrayOfExpr[@bool] is ExprBoolean)) { throw new ExprException("Invalid Parameter Value: " + paramArrayOfExpr[@bool]); } } @bool = true; Session session = null; ProjectDBUtil projectDBUtil = null; if (paramIEvaluationContext is ExprAbstractEvaluationContext) { session = ((ExprAbstractEvaluationContext)paramIEvaluationContext).ProjectDatabaseSession; if (session == null) { projectDBUtil = ProjectDBUtil.currentProjectDBUtil(); if (projectDBUtil == null) { return(new DummyExprArray()); } @bool = projectDBUtil.hasOpenedSession(); session = projectDBUtil.currentSession(); } } string[] arrayOfString = null; try { Query query = session.createQuery(str); query.Cacheable = true; for (sbyte b1 = 1; b1 < paramArrayOfExpr.Length; b1++) { if (paramArrayOfExpr[b1] is ExprString) { query = query.setString(b1 - true, ((ExprString)paramArrayOfExpr[b1]).str); } else if (paramArrayOfExpr[b1] is ExprDouble) { query = query.setDouble(b1 - true, ((ExprDouble)paramArrayOfExpr[b1]).doubleValue()); } else if (paramArrayOfExpr[b1] is ExprInteger) { query = query.setInteger(b1 - true, ((ExprInteger)paramArrayOfExpr[b1]).intValue()); } else if (paramArrayOfExpr[b1] is ExprBoolean) { query = query.setBoolean(b1 - true, ((ExprBoolean)paramArrayOfExpr[b1]).booleanValue()); } } System.Collections.IList list = query.list(); int i = 0; if (list.Count != 0) { object @object = list[0]; if (@object is BaseEntity) { ClassMetadata classMetadata = ((SessionImplementor)session).Factory.getClassMetadata(@object.GetType()); arrayOfString = classMetadata.PropertyNames; if (arrayOfString == null) { throw new Exception("Invalid class name: " + @object.GetType()); } i = arrayOfString.Length; } else if (@object is object[]) { i = (object[])@object.length; } else { i = 1; } } ExprArray exprArray = new ExprArray(list.Count, i); sbyte b2 = 0; foreach (object @object in list) { if (@object is object[]) { object[] arrayOfObject = (object[])@object; for (sbyte b3 = 0; b3 < arrayOfObject.Length; b3++) { setArrayValue(exprArray, arrayOfObject[b3], b2, b3); } } else if (@object is BaseEntity) { sbyte b3 = 0; foreach (string str1 in arrayOfString) { object object1 = BlankResourceInitializer.getFieldValue((BaseEntity)@object, str1); setArrayValue(exprArray, object1, b2, b3++); } } else if (i == 1) { setArrayValue(exprArray, @object, b2, 0); } else { if (!@bool) { projectDBUtil.closeSession(); } throw new ExprException("Not a persistent class: " + @object.GetType().Name); } b2++; } if (projectDBUtil != null && !@bool) { projectDBUtil.closeSession(); } return(exprArray); } catch (Exception exception) { Console.WriteLine(exception.ToString()); Console.Write(exception.StackTrace); if (!@bool) { projectDBUtil.closeSession(); } throw new ExprException(exception.Message); } }
//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]); }
public LineItemEvaluationContext(AssemblyTable paramAssemblyTable) { this.assemblyTable = paramAssemblyTable; this.boqItemTable = BlankResourceInitializer.createBlankBoqItem(null, null, null, false); reloadVariables(); }
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#: //ORIGINAL LINE: private void loadResources(org.hibernate.Session paramSession, String paramString) throws Exception private void loadResources(Session paramSession, string paramString) { Console.WriteLine("\n\n\n\nLoading RESOURSES"); POIFSFileSystem pOIFSFileSystem = new POIFSFileSystem(new FileStream(paramString, FileMode.Open, FileAccess.Read)); HSSFWorkbook hSSFWorkbook = new HSSFWorkbook(pOIFSFileSystem); this.o_evaluator = hSSFWorkbook.CreationHelper.createFormulaEvaluator(); HSSFSheet hSSFSheet = hSSFWorkbook.getSheetAt(0); int i = getRealNumberOfRows(hSSFSheet); for (int j = 1; j < i; j++) { if (j % this.rowsToCommit == 0) { paramSession.Transaction.commit(); paramSession.Transaction.begin(); Console.WriteLine("Processing next " + this.rowsToCommit + "..."); } HSSFRow hSSFRow = hSSFSheet.getRow(j); string str1 = notNull(hSSFRow.getCell(0)); string str2 = notNull(hSSFRow.getCell(1)); string str3 = notNull(hSSFRow.getCell(2)); string str4 = toCostOSUoM(notNull(hSSFRow.getCell(3))); decimal bigDecimal1 = notNullBigDecimal(hSSFRow.getCell(4), 0.0D); string str5 = notNull(hSSFRow.getCell(7)); decimal bigDecimal2 = notNullBigDecimal(hSSFRow.getCell(17), 0.0D); string str6 = notNull(hSSFRow.getCell(14)); string str7 = ""; if (str6.Length >= 2 && !StringUtils.isBlank(str6)) { str7 = "0" + str6.Substring(0, 2) + "00"; } if (acceptProject(str1) && !str4.Equals("")) { SubcontractorTable subcontractorTable = null; if (str5.Equals("F&O")) { subcontractorTable = BlankResourceInitializer.createBlankEquipment(null); ((EquipmentTable)subcontractorTable).Currency = "USD"; ((EquipmentTable)subcontractorTable).FuelRate = bigDecimal1; } else if (str5.Equals("LAB") && str4.Equals("HOUR")) { LaborTable laborTable = BlankResourceInitializer.createBlankLabor(null); ((LaborTable)laborTable).Currency = "USD"; ((LaborTable)laborTable).Rate = bigDecimal1; } else if (str5.Equals("STF") && str4.Equals("DAY")) { LaborTable laborTable = BlankResourceInitializer.createBlankLabor(null); ((LaborTable)laborTable).Currency = "USD"; ((LaborTable)laborTable).Rate = bigDecimal1; } else if (str5.Equals("STF") && str4.Equals("MONTH")) { LaborTable laborTable = BlankResourceInitializer.createBlankLabor(null); ((LaborTable)laborTable).Currency = "USD"; ((LaborTable)laborTable).Rate = bigDecimal1; } else if (str5.Equals("GEN") || str5.Equals("REC")) { ConsumableTable consumableTable = BlankResourceInitializer.createBlankConsumable(null); ((ConsumableTable)consumableTable).Currency = "USD"; ((ConsumableTable)consumableTable).Rate = bigDecimal1; } else if (str5.Equals("LOC") || str5.Equals("IMP")) { MaterialTable materialTable = BlankResourceInitializer.createBlankMaterial(null); ((MaterialTable)materialTable).Currency = "USD"; ((MaterialTable)materialTable).Rate = bigDecimal1; } else if (str5.Equals("S/C")) { SubcontractorTable subcontractorTable1 = BlankResourceInitializer.createBlankSubcontractor(null); ((SubcontractorTable)subcontractorTable1).Currency = "USD"; ((SubcontractorTable)subcontractorTable1).Rate = bigDecimal1; } else if (str5.Equals("PLA")) { subcontractorTable = BlankResourceInitializer.createBlankEquipment(null); ((EquipmentTable)subcontractorTable).Currency = "USD"; ((EquipmentTable)subcontractorTable).ReservationRate = bigDecimal1; } else { subcontractorTable = BlankResourceInitializer.createBlankSubcontractor(null); ((SubcontractorTable)subcontractorTable).Currency = "USD"; ((SubcontractorTable)subcontractorTable).Rate = bigDecimal1; } subcontractorTable.ItemCode = str2; subcontractorTable.Title = str3; subcontractorTable.Project = str1; subcontractorTable.Quantity = bigDecimal2; subcontractorTable.Unit = str4; subcontractorTable.GekCode = str5 + " - " + str5; if (this.csi95Map.ContainsKey(str7)) { subcontractorTable.GroupCode = (string)this.csi95Map[str7]; } else if (!StringUtils.isBlank(str7)) { Console.WriteLine("CSI Not Found: " + str7); } subcontractorTable.LastUpdate = this.lastUpdate; subcontractorTable.CreateDate = this.lastUpdate; subcontractorTable.EditorId = "ccc"; subcontractorTable.CreateUserId = "ccc"; long?long = (long?)paramSession.save(subcontractorTable); ResourceTable resourceTable = (ResourceTable)paramSession.load(subcontractorTable.GetType(), long); this.resourcesMap[str1 + str2] = resourceTable; } } }