private void createSubcontractor(Session paramSession, AssemblyTable paramAssemblyTable, string paramString1, decimal paramBigDecimal1, string paramString2, decimal paramBigDecimal2)
{
SubcontractorTable subcontractorTable = BlankResourceInitializer.createBlankSubcontractor(paramAssemblyTable);
subcontractorTable.Title = paramString1;
subcontractorTable.Unit = paramString2;
subcontractorTable.Rate = paramBigDecimal1;
subcontractorTable.Currency = "USD";
subcontractorTable.EditorId = "admin";
subcontractorTable.Country = "US";
subcontractorTable.LastUpdate = this.lastUpdate;
subcontractorTable.CreateDate = this.lastUpdate;
subcontractorTable.CreateUserId = "admin";
subcontractorTable.EditorId = "admin";
long?long = (long?)paramSession.save(subcontractorTable.clone());
subcontractorTable.Id = long;
subcontractorTable = (SubcontractorTable)paramSession.load(typeof(SubcontractorTable), long);
AssemblySubcontractorTable assemblySubcontractorTable = new AssemblySubcontractorTable();
assemblySubcontractorTable.Factor1 = BigDecimalMath.ONE;
assemblySubcontractorTable.Factor2 = BigDecimalMath.ONE;
assemblySubcontractorTable.Factor3 = BigDecimalMath.ONE;
assemblySubcontractorTable.ExchangeRate = BigDecimalMath.ONE;
assemblySubcontractorTable.QuantityPerUnit = paramBigDecimal2;
assemblySubcontractorTable.QuantityPerUnitFormula = "";
assemblySubcontractorTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA;
assemblySubcontractorTable.LocalFactor = BigDecimalMath.ONE;
assemblySubcontractorTable.LocalCountry = "";
assemblySubcontractorTable.LocalStateProvince = "";
assemblySubcontractorTable.LastUpdate = paramAssemblyTable.LastUpdate;
long = (long?)paramSession.save(assemblySubcontractorTable);
assemblySubcontractorTable.AssemblySubcontractorId = long;
paramAssemblyTable.AssemblySubcontractorSet.Add(assemblySubcontractorTable);
paramSession.saveOrUpdate(paramAssemblyTable);
assemblySubcontractorTable.SubcontractorTable = subcontractorTable;
assemblySubcontractorTable.AssemblyTable = paramAssemblyTable;
paramSession.saveOrUpdate(assemblySubcontractorTable);
}
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private void saveOrUpdateAssemblyTable(org.hibernate.Session paramSession, Desktop.common.nomitech.common.migration.spon.SponLineItem paramSponLineItem, nomitech.common.db.local.MaterialTable paramMaterialTable, nomitech.common.db.local.SubcontractorTable paramSubcontractorTable, nomitech.common.db.local.EquipmentTable paramEquipmentTable) throws Exception
private void saveOrUpdateAssemblyTable(Session paramSession, SponLineItem paramSponLineItem, MaterialTable paramMaterialTable, SubcontractorTable paramSubcontractorTable, EquipmentTable paramEquipmentTable)
{
SponLineItem sponLineItem;
for (sponLineItem = (SponLineItem)paramSponLineItem.Parent; string.ReferenceEquals(sponLineItem.WbsCode, null); sponLineItem = (SponLineItem)sponLineItem.Parent)
{
;
}
AssemblyTable assemblyTable = BlankResourceInitializer.createBlankAssembly(null);
assemblyTable.AssemblyId = null;
assemblyTable.Title = paramSponLineItem.makeShortTitle();
string str = convertToCostOSUnit(paramSponLineItem.Unit);
if (string.ReferenceEquals(str, null))
{
throw new Exception("FATAL: UNIT WAS NULL FOR " + paramSponLineItem.Unit);
}
assemblyTable.GroupCode = sponLineItem.WbsCode + " - " + sponLineItem.makeShortTitle();
assemblyTable.GekCode = "";
assemblyTable.Unit = str;
assemblyTable.EditorId = "spon";
assemblyTable.StateProvince = "";
assemblyTable.Country = "GB";
assemblyTable.Currency = "GBP";
assemblyTable.Productivity = BigDecimalMath.ZERO;
assemblyTable.Project = "";
assemblyTable.PublishedRate = new BigDecimalFixed("" + convertToCostOSRate(paramSponLineItem.Unit, paramSponLineItem.Total));
assemblyTable.PublishedRevisionCode = paramSponLineItem.Code;
assemblyTable.Notes = "SPON Major Rate";
assemblyTable.Description = paramSponLineItem.makeFullDescription() + "\nCODE: " + paramSponLineItem.Code;
assemblyTable.Virtual = false;
assemblyTable.VirtualEquipment = false;
assemblyTable.VirtualSubcontractor = false;
assemblyTable.VirtualLabor = false;
assemblyTable.VirtualMaterial = false;
assemblyTable.VirtualConsumable = false;
assemblyTable.LastUpdate = this.lastUpdate;
assemblyTable.Quantity = new BigDecimalFixed("0");
assemblyTable.Accuracy = "enum.quotation.accuracy.estimated";
assemblyTable.CreateDate = assemblyTable.LastUpdate;
assemblyTable.CreateUserId = "spon";
Serializable serializable = assemblyTable.AssemblyId;
if (serializable == null)
{
serializable = paramSession.save(assemblyTable);
}
else
{
paramSession.update(assemblyTable);
}
assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), serializable);
if (paramSubcontractorTable != null)
{
paramSubcontractorTable = (SubcontractorTable)DatabaseDBUtil.loadBulk(typeof(SubcontractorTable), new long?[] { paramSubcontractorTable.SubcontractorId })[0];
AssemblySubcontractorTable assemblySubcontractorTable = new AssemblySubcontractorTable();
assemblySubcontractorTable.Factor1 = BigDecimalMath.ONE;
assemblySubcontractorTable.Factor2 = BigDecimalMath.ONE;
assemblySubcontractorTable.Factor3 = BigDecimalMath.ONE;
assemblySubcontractorTable.QuantityPerUnit = BigDecimalMath.ONE;
assemblySubcontractorTable.QuantityPerUnitFormula = "";
assemblySubcontractorTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA;
assemblySubcontractorTable.LocalFactor = BigDecimalMath.ONE;
assemblySubcontractorTable.LocalCountry = "";
assemblySubcontractorTable.LocalStateProvince = "";
assemblySubcontractorTable.LastUpdate = assemblyTable.LastUpdate;
long?long = (long?)paramSession.save(assemblySubcontractorTable);
assemblySubcontractorTable.AssemblySubcontractorId = long;
if (DatabaseDBUtil.LocalCommunication)
{
paramSubcontractorTable.AssemblySubcontractorSet.Add(assemblySubcontractorTable);
paramSession.saveOrUpdate(paramSubcontractorTable);
assemblyTable.AssemblySubcontractorSet.Add(assemblySubcontractorTable);
paramSession.saveOrUpdate(assemblyTable);
assemblySubcontractorTable.SubcontractorTable = paramSubcontractorTable;
assemblySubcontractorTable.AssemblyTable = assemblyTable;
paramSession.saveOrUpdate(assemblySubcontractorTable);
}
else
{
assemblySubcontractorTable = (AssemblySubcontractorTable)DatabaseDBUtil.associateAssemblyResource(assemblyTable, paramSubcontractorTable, assemblySubcontractorTable);
assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id);
}
}
if (paramMaterialTable != null)
{
paramMaterialTable = (MaterialTable)DatabaseDBUtil.loadBulk(typeof(MaterialTable), new long?[] { paramMaterialTable.MaterialId })[0];
AssemblyMaterialTable assemblyMaterialTable = new AssemblyMaterialTable();
assemblyMaterialTable.Factor1 = BigDecimalMath.ONE;
assemblyMaterialTable.Factor2 = BigDecimalMath.ONE;
assemblyMaterialTable.Factor3 = BigDecimalMath.ONE;
assemblyMaterialTable.QuantityPerUnit = BigDecimalMath.ONE;
assemblyMaterialTable.QuantityPerUnitFormula = "";
assemblyMaterialTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA;
assemblyMaterialTable.LocalFactor = BigDecimalMath.ONE;
assemblyMaterialTable.LocalCountry = "";
assemblyMaterialTable.LocalStateProvince = "";
assemblyMaterialTable.LastUpdate = assemblyTable.LastUpdate;
long?long = (long?)paramSession.save(assemblyMaterialTable);
assemblyMaterialTable.AssemblyMaterialId = long;
if (DatabaseDBUtil.LocalCommunication)
{
paramMaterialTable.AssemblyMaterialSet.Add(assemblyMaterialTable);
paramSession.saveOrUpdate(paramMaterialTable);
assemblyTable.AssemblyMaterialSet.Add(assemblyMaterialTable);
paramSession.saveOrUpdate(assemblyTable);
assemblyMaterialTable.MaterialTable = paramMaterialTable;
assemblyMaterialTable.AssemblyTable = assemblyTable;
paramSession.saveOrUpdate(assemblyMaterialTable);
}
else
{
assemblyMaterialTable = (AssemblyMaterialTable)DatabaseDBUtil.associateAssemblyResource(assemblyTable, paramMaterialTable, assemblyMaterialTable);
assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id);
}
}
if (paramEquipmentTable != null)
{
paramEquipmentTable = (EquipmentTable)DatabaseDBUtil.loadBulk(typeof(EquipmentTable), new long?[] { paramEquipmentTable.EquipmentId })[0];
AssemblyEquipmentTable assemblyEquipmentTable = new AssemblyEquipmentTable();
assemblyEquipmentTable.Factor1 = BigDecimalMath.ONE;
assemblyEquipmentTable.Factor2 = BigDecimalMath.ONE;
assemblyEquipmentTable.Factor3 = BigDecimalMath.ONE;
assemblyEquipmentTable.QuantityPerUnit = BigDecimalMath.ONE;
assemblyEquipmentTable.QuantityPerUnitFormula = "";
assemblyEquipmentTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA;
assemblyEquipmentTable.LocalFactor = BigDecimalMath.ONE;
assemblyEquipmentTable.LocalCountry = "";
assemblyEquipmentTable.LocalStateProvince = "";
assemblyEquipmentTable.EnergyPrice = BigDecimalMath.ZERO;
assemblyEquipmentTable.FuelRate = BigDecimalMath.ZERO;
assemblyEquipmentTable.LastUpdate = assemblyTable.LastUpdate;
long?long = (long?)paramSession.save(assemblyEquipmentTable);
assemblyEquipmentTable.AssemblyEquipmentId = long;
if (DatabaseDBUtil.LocalCommunication)
{
paramEquipmentTable.AssemblyEquipmentSet.Add(assemblyEquipmentTable);
paramSession.saveOrUpdate(paramEquipmentTable);
assemblyTable.AssemblyEquipmentSet.Add(assemblyEquipmentTable);
paramSession.saveOrUpdate(assemblyTable);
assemblyEquipmentTable.EquipmentTable = paramEquipmentTable;
assemblyEquipmentTable.AssemblyTable = assemblyTable;
paramSession.saveOrUpdate(assemblyEquipmentTable);
}
else
{
assemblyEquipmentTable = (AssemblyEquipmentTable)DatabaseDBUtil.associateAssemblyResource(assemblyTable, paramEquipmentTable, assemblyEquipmentTable);
assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id);
}
}
assemblyTable = (AssemblyTable)paramSession.load(typeof(AssemblyTable), assemblyTable.Id);
assemblyTable.recalculate();
paramSession.update(assemblyTable);
}
private void assignToResource(Session paramSession, AssemblyTable paramAssemblyTable, ResourceTable paramResourceTable, decimal paramBigDecimal)
{
AssemblyConsumableTable assemblyConsumableTable;
if (paramResourceTable is AssemblyTable)
{
assemblyConsumableTable = new AssemblyAssemblyTable();
((AssemblyAssemblyTable)assemblyConsumableTable).LastUpdate = this.lastUpdate;
}
else if (paramResourceTable is EquipmentTable)
{
assemblyConsumableTable = new AssemblyEquipmentTable();
((AssemblyEquipmentTable)assemblyConsumableTable).LastUpdate = this.lastUpdate;
}
else if (paramResourceTable is SubcontractorTable)
{
assemblyConsumableTable = new AssemblySubcontractorTable();
((AssemblySubcontractorTable)assemblyConsumableTable).LastUpdate = this.lastUpdate;
}
else if (paramResourceTable is LaborTable)
{
assemblyConsumableTable = new AssemblyLaborTable();
((AssemblyLaborTable)assemblyConsumableTable).LastUpdate = this.lastUpdate;
}
else if (paramResourceTable is MaterialTable)
{
assemblyConsumableTable = new AssemblyMaterialTable();
((AssemblyMaterialTable)assemblyConsumableTable).LastUpdate = this.lastUpdate;
}
else if (paramResourceTable is ConsumableTable)
{
assemblyConsumableTable = new AssemblyConsumableTable();
((AssemblyConsumableTable)assemblyConsumableTable).LastUpdate = this.lastUpdate;
}
else
{
return;
}
assemblyConsumableTable.ExchangeRate = BigDecimalMath.ONE;
assemblyConsumableTable.LocalStateProvince = "";
assemblyConsumableTable.LocalCountry = "";
assemblyConsumableTable.LocalFactor = BigDecimalMath.ONE;
assemblyConsumableTable.Factor1 = BigDecimalMath.ONE;
assemblyConsumableTable.Factor2 = BigDecimalMath.ONE;
assemblyConsumableTable.Factor3 = BigDecimalMath.ONE;
assemblyConsumableTable.QuantityPerUnit = paramBigDecimal;
assemblyConsumableTable.QuantityPerUnitFormula = "";
assemblyConsumableTable.QuantityPerUnitFormulaState = ResourceToAssignmentTable.QTYPUFORM_NOFORMULA;
long?long = (long?)paramSession.save(assemblyConsumableTable);
ResourceToAssignmentTable resourceToAssignmentTable = (ResourceToAssignmentTable)paramSession.load(assemblyConsumableTable.GetType(), long);
if (paramResourceTable is AssemblyTable)
{
paramAssemblyTable.AssemblyChildSet.Add((AssemblyAssemblyTable)resourceToAssignmentTable);
}
else if (paramResourceTable is EquipmentTable)
{
paramAssemblyTable.AssemblyEquipmentSet.Add((AssemblyEquipmentTable)resourceToAssignmentTable);
}
else if (paramResourceTable is SubcontractorTable)
{
paramAssemblyTable.AssemblySubcontractorSet.Add((AssemblySubcontractorTable)resourceToAssignmentTable);
}
else if (paramResourceTable is LaborTable)
{
paramAssemblyTable.AssemblyLaborSet.Add((AssemblyLaborTable)resourceToAssignmentTable);
}
else if (paramResourceTable is MaterialTable)
{
paramAssemblyTable.AssemblyMaterialSet.Add((AssemblyMaterialTable)resourceToAssignmentTable);
}
else if (paramResourceTable is ConsumableTable)
{
paramAssemblyTable.AssemblyConsumableSet.Add((AssemblyConsumableTable)resourceToAssignmentTable);
}
resourceToAssignmentTable.setResourceTable(paramAssemblyTable);
resourceToAssignmentTable.AssignmentResourceTable = paramResourceTable;
paramSession.update(paramAssemblyTable);
paramSession.update(paramResourceTable);
paramSession.update(resourceToAssignmentTable);
}
