//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private CCIToLocalizationLoader(String paramString1, boolean paramBoolean, String paramString2) throws Exception
private CCIToLocalizationLoader(string paramString1, bool paramBoolean, string paramString2)
{
this.online = paramBoolean;
this.CCI = paramString2;
File file1 = new File(paramString1 + File.separator + "City Cost Index" + File.separator + paramString2 + ".up");
File file2 = new File(paramString1 + File.separator + "City Cost Index" + File.separator + paramString2 + ".sys");
try
{
DatabaseDBUtil.currentSession().beginTransaction();
Console.WriteLine("PROCESSING: " + file1.AbsolutePath);
loadCCI(file1, "US", "extraCode1", "RSMeans Unit Cost Base");
Transaction transaction = DatabaseDBUtil.currentSession().Transaction;
transaction.commit();
DatabaseDBUtil.currentSession().beginTransaction();
Console.WriteLine("PROCESSING: " + file2.AbsolutePath);
loadCCI(file2, "US", "extraCode3", "RSMeans Assemblies Base");
transaction = DatabaseDBUtil.currentSession().Transaction;
transaction.commit();
}
catch (Exception exception)
{
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
Transaction transaction = DatabaseDBUtil.currentSession().Transaction;
if (transaction.Active)
{
transaction.rollback();
}
DatabaseDBUtil.closeSession();
throw exception;
}
DatabaseDBUtil.closeSession();
}
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private UniFormatLoader(String paramString1, String paramString2) throws Exception
private UniFormatLoader(string paramString1, string paramString2)
{
this.costDataFolder = paramString1;
this.asm = paramString2;
Session session = DatabaseDBUtil.currentSession();
Transaction transaction = session.beginTransaction();
try
{
loadUniCodes("Assembly", "ASM", session);
loadUniCodes("Civil", "CVL", session);
loadUniCodes("Commercial", "COM", session);
loadUniCodes("Concrete", "CON", session);
loadUniCodes("Electrical", "ELE", session);
loadUniCodes("Facility", "FAC", session);
loadUniCodes("Green Building", "GRN", session);
loadUniCodes("Heavy", "HVY", session);
loadUniCodes("Interior", "INT", session);
loadUniCodes("Master", "ALL", session);
loadUniCodes("Mechanical", "MEC", session);
loadUniCodes("Plumbing", "PLU", session);
loadUniCodes("Site Work", "SIT", session);
loadUniCodes("Square Foot", "SF", session);
transaction.commit();
}
catch (Exception exception)
{
transaction.rollback();
DatabaseDBUtil.closeSession();
throw exception;
}
DatabaseDBUtil.closeSession();
}
private bool checkRequiresAltering(ProjectUrlTable paramProjectUrlTable)
{
if (paramProjectUrlTable.CreatesNewDatabases != null && !paramProjectUrlTable.CreatesNewDatabases.Value)
{
return(false);
}
Session session = DatabaseDBUtil.currentSession();
try
{
string str1 = "SELECT PVAL as VER FROM " + paramProjectUrlTable.DatabaseName + ".dbo.PRJPROP WHERE PKEY LIKE 'costos.estimating.version' and PRJID = " + ProjectUrlId;
string str2 = (string)session.createSQLQuery(str1).addScalar("VER", StringType.INSTANCE).uniqueResult();
if (string.ReferenceEquals(str2, null))
{
DatabaseDBUtil.closeSession();
return(true);
}
if (StringUtils.checkEquality(str2, ProjectDBProperties.PROPERTIES_VERSION))
{
DatabaseDBUtil.closeSession();
return(false);
}
}
catch (Exception exception)
{
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
}
DatabaseDBUtil.closeSession();
return(true);
}
public virtual void resetAll()
{
bool @bool = !DatabaseDBUtil.hasOpenedSession() ? 1 : 0;
Session session = DatabaseDBUtil.currentSession();
if (@bool)
{
session.beginTransaction();
}
System.Collections.IEnumerator iterator = session.createQuery("from FieldCustomizationTable").list().GetEnumerator();
List <object> arrayList = new List <object>();
while (iterator.MoveNext())
{
arrayList.Add(iterator.Current);
}
iterator = arrayList.GetEnumerator();
while (iterator.MoveNext())
{
session.delete(iterator.Current);
}
if (@bool)
{
session.Transaction.commit();
}
if (@bool)
{
DatabaseDBUtil.closeSession();
}
initializeFieldsMap();
}
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: public static boolean deleteLocalIcon(String paramString, Class paramClass) throws Exception
public static bool deleteLocalIcon(string paramString, Type paramClass)
{
bool @bool = !DatabaseDBUtil.hasOpenedSession() ? 1 : 0;
int i = ((Number)DatabaseDBUtil.currentSession().createQuery("select count(o.icon) from " + paramClass.Name + " o where o.icon = '" + paramString + "'").iterate().next()).intValue();
if (i > 1)
{
return(false);
}
if (@bool)
{
DatabaseDBUtil.closeSession();
}
File file1 = new File(getLocalPathOfIcon(paramString, paramClass, 16));
File file2 = new File(getLocalPathOfIcon(paramString, paramClass, 24));
File file3 = new File(getLocalPathOfIcon(paramString, paramClass, 32));
if (file1.exists())
{
file1.delete();
}
if (file2.exists())
{
file2.delete();
}
if (file3.exists())
{
file3.delete();
}
return(true);
}
public virtual void storeToDatabase(IList <FieldCustomizationTable> paramList)
{
Session session = DatabaseDBUtil.currentSession();
session.beginTransaction();
foreach (FieldCustomizationTable fieldCustomizationTable in paramList)
{
storeToDatabase(fieldCustomizationTable);
}
session.Transaction.commit();
DatabaseDBUtil.closeSession();
}
public virtual void reloadFromDatabase()
{
initializeFieldsMap();
bool @bool = !DatabaseDBUtil.hasOpenedSession() ? 1 : 0;
Session session = DatabaseDBUtil.currentSession();
foreach (FieldCustomizationTable fieldCustomizationTable in session.createQuery("from FieldCustomizationTable").list())
{
this.fieldsMap[new FieldCustomizationKey(this, fieldCustomizationTable.Name, fieldCustomizationTable.ResourceType)] = (FieldCustomizationTable)fieldCustomizationTable.clone();
}
if (@bool)
{
DatabaseDBUtil.closeSession();
}
}
private void reload(Session paramSession)
{
this.functions.Clear();
this.definitions.Clear();
if (paramSession == null)
{
if (DatabaseDBUtil.LocalCommunication)
{
bool @bool = !DatabaseDBUtil.hasOpenedSession() ? 1 : 0;
paramSession = DatabaseDBUtil.currentSession();
foreach (FunctionTable functionTable1 in paramSession.createQuery("from FunctionTable o left join fetch o.functionArgumentList").list())
{
FunctionTable functionTable2 = functionTable1.copyWithVariables();
this.functions[functionTable1.Name] = new ExprDBFunction(functionTable2);
this.definitions[functionTable1.Name] = new ExprFunctionDefinition(functionTable2);
}
if (@bool)
{
DatabaseDBUtil.closeSession();
}
}
else
{
try
{
foreach (FunctionTable functionTable in DatabaseDBUtil.loadAllDeepCopy(typeof(FunctionTable)))
{
this.functions[functionTable.Name] = new ExprDBFunction(functionTable);
this.definitions[functionTable.Name] = new ExprFunctionDefinition(functionTable);
}
}
catch (Exception exception)
{
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
}
}
}
else
{
foreach (FunctionTable functionTable1 in paramSession.createQuery("from FunctionTable o left join fetch o.functionArgumentList").list())
{
FunctionTable functionTable2 = functionTable1.copyWithVariables();
this.functions[functionTable1.Name] = new ExprDBFunction(functionTable2);
this.definitions[functionTable1.Name] = new ExprFunctionDefinition(functionTable2);
}
}
}
public static ProjectInfoTable findProjectInfoFromUrl(ProjectUrlTable paramProjectUrlTable)
{
Query query = DatabaseDBUtil.currentSession().createQuery("select prjInfo from ProjectInfoTable as prjInfo join prjInfo.urlSet as urlTable with urlTable.projectUrlId = :urlid");
query.setLong("urlid", paramProjectUrlTable.ProjectUrlId.Value);
System.Collections.IEnumerator iterator = query.iterate();
//JAVA TO C# CONVERTER TODO TASK: Java iterators are only converted within the context of 'while' and 'for' loops:
if (!iterator.hasNext())
{
DatabaseDBUtil.closeSession();
return(null);
}
//JAVA TO C# CONVERTER TODO TASK: Java iterators are only converted within the context of 'while' and 'for' loops:
ProjectInfoTable projectInfoTable = (ProjectInfoTable)DatabaseDBUtil.currentSession().load(typeof(ProjectInfoTable), ((ProjectInfoTable)iterator.next()).Id);
projectInfoTable = projectInfoTable.copyWithAssignments();
DatabaseDBUtil.closeSession();
return(projectInfoTable);
}
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private CitiesToLocalizationLoader(java.sql.Connection paramConnection) throws Exception
private CitiesToLocalizationLoader(Connection paramConnection)
{
this.con = paramConnection;
Console.WriteLine("Caching cities...");
loadCities();
Console.WriteLine("Caching averages...");
loadAverages();
Console.WriteLine("Loading the location profile...");
try
{
loadProfile();
}
catch (Exception exception)
{
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
DatabaseDBUtil.currentSession().Transaction.rollback();
DatabaseDBUtil.closeSession();
}
}
public TimberlineMigrationUtil(string paramString1, string paramString2, string paramString3, string paramString4)
{
paramString1 = "C:\\DPR\\DB-SAVED\\MFL";
paramString2 = "C:\\DPR\\DB-SAVED\\UNI";
paramString3 = "C:\\DPR\\DB-SAVED\\CMiC.xls";
paramString4 = "C:\\DPR\\DB-SAVED\\DPR Items DB.xls";
Session session = DatabaseDBUtil.currentSession();
session.beginTransaction();
try
{
Console.WriteLine("Starting Importing of Resources and Crews...");
session.Transaction.commit();
session.beginTransaction();
Console.WriteLine("PROCESSING CSI...");
loadCSI(session, paramString1);
session.Transaction.commit();
session.beginTransaction();
Console.WriteLine("PROCESSING UNI...");
loadUniFormat(session, paramString2);
session.Transaction.commit();
session.beginTransaction();
Console.WriteLine("PROCESSING CMIC...");
loadCmic(session, paramString3);
session.Transaction.commit();
session.beginTransaction();
Console.WriteLine("PROCESSING LINE ITEMS...");
loadLineItems(session, paramString4);
session.Transaction.commit();
}
catch (Exception exception)
{
if (session.Transaction.Active)
{
session.Transaction.rollback();
}
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
}
DatabaseDBUtil.closeSession();
}
public virtual void storeToDatabase(FieldCustomizationTable paramFieldCustomizationTable)
{
bool @bool = !DatabaseDBUtil.hasOpenedSession() ? 1 : 0;
Session session = DatabaseDBUtil.currentSession();
if (@bool)
{
session.beginTransaction();
}
System.Collections.IEnumerator iterator = session.createQuery("from FieldCustomizationTable o where o.name = '" + paramFieldCustomizationTable.Name + "' and o.resourceType = '" + paramFieldCustomizationTable.ResourceType + "'").list().GetEnumerator();
FieldCustomizationTable fieldCustomizationTable = paramFieldCustomizationTable;
//JAVA TO C# CONVERTER TODO TASK: Java iterators are only converted within the context of 'while' and 'for' loops:
Console.WriteLine("FOUND: " + iterator.hasNext());
//JAVA TO C# CONVERTER TODO TASK: Java iterators are only converted within the context of 'while' and 'for' loops:
if (iterator.hasNext())
{
//JAVA TO C# CONVERTER TODO TASK: Java iterators are only converted within the context of 'while' and 'for' loops:
fieldCustomizationTable = (FieldCustomizationTable)iterator.next();
fieldCustomizationTable.Data = paramFieldCustomizationTable;
session.update(fieldCustomizationTable);
}
else
{
long?long = (long?)session.save(fieldCustomizationTable);
fieldCustomizationTable.Id = long;
}
Console.WriteLine("SAVED " + fieldCustomizationTable.DisplayName);
this.fieldsMap[new FieldCustomizationKey(this, fieldCustomizationTable)] = (FieldCustomizationTable)fieldCustomizationTable.clone();
if (@bool)
{
session.Transaction.commit();
}
if (@bool)
{
DatabaseDBUtil.closeSession();
}
}
private CCCMigrationUtil(string paramString1, string paramString2, string paramString3)
{
Session session = DatabaseDBUtil.currentSession();
session.beginTransaction();
try
{
Console.WriteLine("Starting Importing...");
session.Transaction.commit();
session.beginTransaction();
loadCSI95(session, paramString1);
session.Transaction.commit();
session.beginTransaction();
loadResourceCodes(session);
session.Transaction.commit();
session.beginTransaction();
loadResources(session, paramString3);
session.Transaction.commit();
session.beginTransaction();
loadOperations(session, paramString3);
session.Transaction.commit();
session.beginTransaction();
loadWorkgroups(session, paramString3);
session.Transaction.commit();
session.beginTransaction();
}
catch (Exception exception)
{
if (session.Transaction.Active)
{
session.Transaction.rollback();
}
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
}
DatabaseDBUtil.closeSession();
}
public TimberlineMigrationUtil2(string paramString)
{
paramString = "C:\\Cocosing\\DB-SAVED\\LINE_ITEMS.xls";
Session session = DatabaseDBUtil.currentSession();
session.beginTransaction();
try
{
Console.WriteLine("Starting Importing of Resources and Crews...");
Console.WriteLine("PROCESSING LINE ITEMS...");
loadLineItems(session, paramString);
session.Transaction.commit();
}
catch (Exception exception)
{
if (session.Transaction.Active)
{
session.Transaction.rollback();
}
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
}
DatabaseDBUtil.closeSession();
}
//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 loadProfile() throws Exception
private void loadProfile()
{
DatabaseDBUtil.currentSession().beginTransaction();
LocalizationProfileTable localizationProfileTable = new LocalizationProfileTable();
localizationProfileTable.SupportsState = false;
localizationProfileTable.ProfileName = "Richardson Base";
localizationProfileTable.CreateDate = DateTime.Now;
localizationProfileTable.LastUpdate = DateTime.Now;
localizationProfileTable.CreateUserId = "richardson";
localizationProfileTable.EditorId = "richardson";
localizationProfileTable.FromCountry = "US";
localizationProfileTable.FromState = "US AVERAGE";
long?long = (long?)DatabaseDBUtil.currentSession().save(localizationProfileTable);
localizationProfileTable = (LocalizationProfileTable)DatabaseDBUtil.currentSession().load(typeof(LocalizationProfileTable), long);
if (localizationProfileTable.Factors == null)
{
localizationProfileTable.Factors = new List <object>();
}
string str = "SELECT * FROM CRAFT";
PreparedStatement preparedStatement = this.con.prepareStatement(str);
ResultSet resultSet = preparedStatement.executeQuery();
sbyte b = 0;
while (resultSet.next())
{
int? integer = Convert.ToInt32(resultSet.getInt(1));
string str1 = resultSet.getString(2);
string str2 = resultSet.getString(3);
string str3 = resultSet.getString(4);
double?double1;
double?double2 = (double1 = Convert.ToDouble(resultSet.getDouble(5))).valueOf(resultSet.getDouble(6));
string str4 = resultSet.getString(7);
if (str1.Equals("0RICH0"))
{
continue;
}
double? double3 = (double?)this.averagesMap[str3];
RichardsonCity richardsonCity = (RichardsonCity)this.citiesMap[str1];
double d = (double1.Value + double2.Value) / double3.Value;
LocalizationFactorTable localizationFactorTable = new LocalizationFactorTable();
localizationFactorTable.AssemblyFactor = BigDecimalMath.ONE;
localizationFactorTable.EquipmentFactor = BigDecimalMath.ONE;
localizationFactorTable.Online = true;
localizationFactorTable.EditorId = "richardson";
localizationFactorTable.SubcontractorFactor = BigDecimalMath.ONE;
localizationFactorTable.LaborFactor = new BigDecimalFixed("" + d);
localizationFactorTable.MaterialFactor = BigDecimalMath.ONE;
localizationFactorTable.ConsumableFactor = BigDecimalMath.ONE;
string str5 = richardsonCity.CountryCode;
if (str5.Equals("USA"))
{
str5 = "US";
}
else if (str5.Equals("CAN"))
{
str5 = "CA";
}
LocationData locationData = LocationDataRetriever.Instance.retrieveForNorthAmericaData(richardsonCity.ZipCode, richardsonCity.StateCode, richardsonCity.City, str5);
if (locationData == null)
{
Console.WriteLine("NO LOCATION DATA FOUND FOR: " + richardsonCity);
continue;
}
localizationFactorTable.ToCountry = locationData.Country;
localizationFactorTable.ToState = locationData.State;
localizationFactorTable.ToCity = locationData.City;
localizationFactorTable.ToZipCode = locationData.ZipCode;
localizationFactorTable.GroupCodeName = "";
localizationFactorTable.ParentCode = str3;
localizationFactorTable.GeoPolygon = locationData.GeoPolygon;
localizationFactorTable.LocalizationProfileTable = localizationProfileTable;
localizationProfileTable.Factors.Add(localizationFactorTable);
Console.WriteLine("I AM SAVING: " + localizationFactorTable.ToCountry + ", " + localizationFactorTable.ToState + ", " + localizationFactorTable.ToCity + ", " + localizationFactorTable.ToZipCode);
DatabaseDBUtil.currentSession().save(localizationFactorTable);
if (++b % 'Ǵ' == 'dz')
{
DatabaseDBUtil.currentSession().Transaction.commit();
DatabaseDBUtil.currentSession().beginTransaction();
Console.WriteLine("\n\n\n\n\n\nCommitted " + b + " factors");
}
}
preparedStatement.close();
DatabaseDBUtil.currentSession().Transaction.commit();
DatabaseDBUtil.closeSession();
}
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private void backUpAndRestore() throws Exception
private void backUpAndRestore()
{
string str1 = ((ProjectServerDBUtil)this.source).ProjectUrl.DatabaseName;
string str2 = ((ProjectServerDBUtil)this.dest).ProjectUrl.DatabaseName;
string str3 = null;
string str4 = null;
this.dest.closeProject();
this.dest.closeSession();
this.progress.TotalTimes = 7;
this.progress.Progress = "Backing up " + str1 + " to " + str2;
Console.WriteLine("STARTED BACKUP [" + str2 + "] RESTORE TO [" + str1 + "]");
Session session = DatabaseDBUtil.currentSession();
try
{
string str5 = stringFromQuery(session, "select physical_name from " + str1 + ".sys.database_files where physical_name not like '%.ldf'");
Console.WriteLine(" SOURCE DATABASE FILE: " + str5);
if (StringUtils.isNullOrBlank(str5))
{
throw new System.InvalidOperationException("Null database file for: " + str1);
}
this.progress.incrementProgress(1);
DatabaseDBUtil.closeSession();
executeUpdate(DatabaseDBUtil.currentSession(), "ALTER DATABASE " + str2 + " MODIFY NAME = " + str2 + "tmp");
DatabaseDBUtil.closeSession();
session = DatabaseDBUtil.currentSession();
str3 = str2 + "tmp";
Console.WriteLine(" RENAMED DESTINATION TEMPORARILY FROM " + str2 + " TO: " + str3);
this.progress.incrementProgress(1);
string str6 = str5.Substring(0, str5.LastIndexOf("\\", StringComparison.Ordinal));
string str7 = str6 + "\\" + str1 + ".bak";
executeUpdate(session, "BACKUP DATABASE " + str1 + " TO DISK = '" + str7 + "' WITH COPY_ONLY");
str4 = str7;
Console.WriteLine(" BACKED UP " + str1 + " TO FILE: " + str7);
this.progress.incrementProgress(1);
System.Collections.IList list = session.createSQLQuery("RESTORE FILELISTONLY FROM DISK = '" + str7 + "'").list();
string str8 = null;
string str9 = null;
foreach (object[] arrayOfObject in list)
{
string str12 = arrayOfObject[0].ToString();
string str13 = arrayOfObject[2].ToString();
if (string.ReferenceEquals(str8, null) && str13.Equals("D"))
{
str8 = str12;
continue;
}
if (string.ReferenceEquals(str9, null) && str13.Equals("L"))
{
str9 = str12;
}
}
if (string.ReferenceEquals(str8, null))
{
throw new Exception("No DATA file found in backup: " + str7);
}
if (string.ReferenceEquals(str9, null))
{
throw new Exception("No LOG file found in backup: " + str7);
}
this.progress.incrementProgress(1);
string str10 = str6 + "\\" + str2;
str10 = StringUtils.replaceAll(str10, "cep_", "cep_b");
string str11 = "RESTORE DATABASE " + str2 + " FROM DISK = '" + str7 + "' WITH MOVE '" + str8 + "' TO '" + str10 + ".mdf', MOVE '" + str9 + "' TO '" + str10 + ".ldf'";
this.progress.Progress = "Restoring to " + str2;
executeUpdate(session, str11);
Console.WriteLine(" RESTORED FILE " + str7 + " TO DATABASE: " + str2);
this.progress.incrementProgress(1);
try
{
executeUpdate(session, "IF DB_ID('" + str3 + "') IS NOT NULL BEGIN DROP DATABASE [" + str3 + "]; END");
Console.WriteLine(" DROPPED TEMPORARY DATABASE " + str3);
}
catch (Exception exception)
{
Console.WriteLine("WARN: FAILED TO DROP DATABASE: " + str3);
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
}
this.progress.incrementProgress(1);
try
{
executeUpdate(session, "EXECUTE master.dbo.xp_delete_file 0,N'" + str4 + "'");
Console.WriteLine(" DELETED BACKUP: " + str4);
}
catch (Exception exception)
{
Console.WriteLine("WARN: FAILED TO DELETE BACKUP: " + str4);
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
}
this.progress.incrementProgress(1);
Console.WriteLine("SUCCESS");
}
catch (Exception exception)
{
this.progress.Indeterminate = true;
Console.WriteLine("FAILED: " + exception.Message);
try
{
if (!string.ReferenceEquals(str3, null))
{
executeUpdate(session, "ALTER DATABASE " + str3 + " MODIFY NAME = " + str2);
}
}
catch (Exception exception1)
{
Console.WriteLine("WARN: FAILED TO ALTER DATABASE: " + str3);
Console.WriteLine(exception1.ToString());
Console.Write(exception1.StackTrace);
}
try
{
if (!string.ReferenceEquals(str4, null))
{
executeUpdate(session, "EXECUTE master.dbo.xp_delete_file 0,N'" + str4 + "'");
}
}
catch (Exception exception1)
{
Console.WriteLine("WARN: FAILED TO DELETE BACKUP: " + str4);
Console.WriteLine(exception1.ToString());
Console.Write(exception1.StackTrace);
}
DatabaseDBUtil.closeSession();
throw exception;
}
this.progress.Indeterminate = true;
DatabaseDBUtil.closeSession();
}
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private SPONMigrationUtil(String paramString1, String paramString2) throws Exception
private SPONMigrationUtil(string paramString1, string paramString2)
{
initializeRateConverter();
this.sponLineItemList = SponLineTimeLoader.loadLineItems(paramString1, paramString2);
System.Collections.IEnumerator iterator1 = this.sponLineItemList.GetEnumerator();
this.rootNode = new DefaultMutableTreeNode();
sbyte b;
for (b = 0; iterator1.MoveNext(); b++)
{
SponLineItem sponLineItem = (SponLineItem)iterator1.Current;
sponLineItem.Index = b;
DefaultMutableTreeNode defaultMutableTreeNode = findParentForLineItem(sponLineItem, b);
defaultMutableTreeNode.add(sponLineItem);
}
System.Collections.IEnumerator enumeration = this.rootNode.children();
LinkedList linkedList = new LinkedList();
while (enumeration.MoveNext())
{
linkedList.AddLast(enumeration.Current);
}
Hashtable hashMap = new Hashtable();
foreach (SponLineItem sponLineItem1 in linkedList)
{
SponLineItem sponLineItem2 = null;
LinkedList linkedList1 = null;
System.Collections.IEnumerator enumeration1 = sponLineItem1.children();
Console.WriteLine("" + sponLineItem1);
while (enumeration1.MoveNext())
{
SponLineItem sponLineItem = (SponLineItem)enumeration1.Current;
string str = sponLineItem.Code;
if (str.IndexOf("/", StringComparison.Ordinal) != -1)
{
if (str.IndexOf("N", StringComparison.Ordinal) == -1)
{
str = StringHelper.SubstringSpecial(str, str.IndexOf("/", StringComparison.Ordinal) + 1, str.Length);
}
else
{
str = StringHelper.SubstringSpecial(str, str.IndexOf("/", StringComparison.Ordinal), str.Length);
}
}
if (str.Length == 3)
{
sponLineItem2 = sponLineItem;
linkedList1 = new LinkedList();
hashMap[sponLineItem2] = linkedList1;
Console.WriteLine(" " + sponLineItem);
continue;
}
if (linkedList1 == null)
{
Console.WriteLine("I was trying;" + sponLineItem);
}
linkedList1.AddLast(sponLineItem);
}
}
foreach (SponLineItem sponLineItem in hashMap.Keys)
{
foreach (SponLineItem sponLineItem1 in (System.Collections.IList)hashMap[sponLineItem])
{
sponLineItem1.removeFromParent();
}
foreach (SponLineItem sponLineItem1 in (System.Collections.IList)hashMap[sponLineItem])
{
sponLineItem.add(sponLineItem1);
}
}
Session session = DatabaseDBUtil.currentSession();
Transaction transaction = session.beginTransaction();
try
{
Console.WriteLine("\n\n\n\n");
enumeration = this.rootNode.preorderEnumeration();
b = 0;
while (enumeration.MoveNext())
{
DefaultMutableTreeNode defaultMutableTreeNode = (DefaultMutableTreeNode)enumeration.Current;
if (defaultMutableTreeNode.Root)
{
continue;
}
SponLineItem sponLineItem = (SponLineItem)defaultMutableTreeNode;
string str1 = null;
string str2 = sponLineItem.Code;
if (++b % 'Ǵ' == '\x0000')
{
Console.WriteLine("PROCESSED: " + b + " lines");
transaction.commit();
DatabaseDBUtil.closeSession();
session = DatabaseDBUtil.currentSession();
transaction = session.beginTransaction();
}
if (b % '✐' == '\x0000')
{
Thread.Sleep(2000L);
}
if (sponLineItem.Composite)
{
if (defaultMutableTreeNode.Path.length == 2)
{
str1 = str2;
}
else if (defaultMutableTreeNode.Path.length == 3)
{
str1 = str2.Substring(0, 1) + "." + str2.Substring(1, str2.Length - 1);
}
else if (defaultMutableTreeNode.Path.length == 4)
{
string str4 = ((SponLineItem)defaultMutableTreeNode.Parent).WbsCode;
string str5 = StringHelper.SubstringSpecial(str2, str4.Length - 1 - "C".Length, str2.Length);
str1 = str4 + "." + str5;
}
else
{
SponLineItem sponLineItem1 = (SponLineItem)defaultMutableTreeNode.Parent;
string str = sponLineItem1.WbsCode;
sbyte b2 = 1;
System.Collections.IEnumerator enumeration1 = sponLineItem1.children();
while (enumeration1.MoveNext())
{
SponLineItem sponLineItem2 = (SponLineItem)enumeration1.Current;
if (sponLineItem2.Equals(sponLineItem))
{
break;
}
b2++;
}
str1 = str + "." + b2;
}
}
string str3 = "";
for (sbyte b1 = 1; b1 < defaultMutableTreeNode.Path.length; b1++)
{
str3 = str3 + " ";
}
if (sponLineItem.Composite)
{
if (sponLineItem.Depth == 1)
{
System.Collections.IEnumerator enumeration1 = sponLineItem.children();
while (enumeration1.MoveNext())
{
SponLineItem sponLineItem1 = (SponLineItem)enumeration1.Current;
sponLineItem1.MoreDescription.Add(sponLineItem.Description);
if (!string.ReferenceEquals(sponLineItem.SecondDescription, null))
{
sponLineItem1.MoreSecondDescription.Add(sponLineItem.SecondDescription);
}
}
continue;
}
if (sponLineItem.ChildCount == 0)
{
bool @bool = sponLineItem.NoteItem;
SponLineItem sponLineItem1 = (SponLineItem)defaultMutableTreeNode.Parent;
System.Collections.IEnumerator enumeration1 = sponLineItem1.children();
bool bool1 = false;
while (enumeration1.MoveNext())
{
SponLineItem sponLineItem2 = (SponLineItem)enumeration1.Current;
if (sponLineItem2.Equals(sponLineItem))
{
bool1 = true;
continue;
}
if (bool1 == true)
{
if (@bool)
{
sponLineItem2.Notes = sponLineItem.Description;
setNotesToAllSubItems(sponLineItem2, sponLineItem2.Notes);
continue;
}
if (sponLineItem2.NoteItem)
{
string str = sponLineItem2.Description;
sponLineItem2.Description = sponLineItem.Description;
sponLineItem2.Notes = str;
setNotesToAllSubItems(sponLineItem2, sponLineItem2.Notes);
sponLineItem.Notes = sponLineItem2.Description;
}
}
}
continue;
}
if (sponLineItem.NoteItem)
{
setNotesToAllSubItems(sponLineItem, sponLineItem.Description);
}
}
if (!string.ReferenceEquals(str1, null))
{
if (!str1.StartsWith("C", StringComparison.Ordinal))
{
sponLineItem.WbsCode = "C" + str1;
}
else
{
sponLineItem.WbsCode = str1;
}
GroupCodeTable groupCodeTable = new GroupCodeTable();
groupCodeTable.GroupCode = sponLineItem.WbsCode;
groupCodeTable.Title = sponLineItem.makeShortTitle();
groupCodeTable.Unit = "";
groupCodeTable.UnitFactor = BigDecimalMath.ONE;
groupCodeTable.Description = sponLineItem.Description + "\n" + sponLineItem.Notes;
groupCodeTable.Notes = sponLineItem.Code;
groupCodeTable.EditorId = "spon";
session.save(groupCodeTable);
continue;
}
processSponCostItem(sponLineItem, session);
}
transaction.commit();
}
catch (Exception exception)
{
Console.WriteLine(exception.ToString());
Console.Write(exception.StackTrace);
transaction.rollback();
}
DatabaseDBUtil.closeSession();
Console.WriteLine("\n\n\n\nUNIT MAP TO CONVERT:");
System.Collections.IEnumerator iterator2 = this.unitMap.Values.GetEnumerator();
while (iterator2.MoveNext())
{
Console.WriteLine(iterator2.Current);
}
}
//JAVA TO C# CONVERTER WARNING: Method 'throws' clauses are not available in C#:
//ORIGINAL LINE: private MasterFormatLoader(String paramString1, String paramString2, String paramString3) throws Exception
private MasterFormatLoader(string paramString1, string paramString2, string paramString3)
{
this.costDataFolder = paramString1;
this.csiType = paramString3;
Session session = DatabaseDBUtil.currentSession();
Transaction transaction = session.beginTransaction();
try
{
if (!string.ReferenceEquals(paramString1, null))
{
loadCSICodes("BCCD", "BCCD", session);
loadCSICodes("Civil", "CIVL", session);
loadCSICodes("Commercial", "COMM", session);
loadCSICodes("Concrete", "CONC", session);
loadCSICodes("Commercial Renovation (R&R)", "R&R", session);
loadCSICodes("Electrical", "ELEC", session);
loadCSICodes("Facility", "FACL", session);
loadCSICodes("Green Building", "GRN", session);
loadCSICodes("Heavy", "HVY", session);
loadCSICodes("Interior", "INTR", session);
loadCSICodes("Light Commercial", "LITE", session);
loadCSICodes("Master", "MSTR", session);
loadCSICodes("Mechanical", "MECH", session);
loadCSICodes("Open Shop", "Open", session);
loadCSICodes("Plumbing", "PLUM", session);
loadCSICodes("Residential", "RESI", session);
loadCSICodes("Site Work", "SITE", session);
}
if (!string.ReferenceEquals(paramString2, null))
{
this.costDataFolder = paramString2;
if (paramString3.Equals("MF14.CSI"))
{
this.csiType = "CSI14";
}
else if (paramString3.Equals("MF12.CSI"))
{
this.csiType = "CSI12";
}
else if (paramString3.Equals("MF04.CSI"))
{
this.csiType = "CSI04";
}
else
{
this.csiType = "CSI95";
}
loadCSICodesAss("Assembly", "ASM", session);
loadCSICodesAss("Civil", "CVL", session);
loadCSICodesAss("Commercial", "COM", session);
loadCSICodesAss("Concrete", "CON", session);
loadCSICodesAss("Electrical", "ELE", session);
loadCSICodesAss("Facility", "FAC", session);
loadCSICodesAss("Green Building", "GRN", session);
loadCSICodesAss("Heavy", "HVY", session);
loadCSICodesAss("Interior", "INT", session);
loadCSICodesAss("Master", "ALL", session);
loadCSICodesAss("Mechanical", "MEC", session);
loadCSICodesAss("Plumbing", "PLU", session);
loadCSICodesAss("Site Work", "SIT", session);
loadCSICodesAss("Square Foot", "SF", session);
}
Console.WriteLine("BEFORE COMMIT " + paramString3);
transaction.commit();
Console.WriteLine("AFTER COMMIT " + paramString3);
}
catch (Exception exception)
{
transaction.rollback();
DatabaseDBUtil.closeSession();
throw exception;
}
DatabaseDBUtil.closeSession();
}