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