//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 loadCCI(java.io.File paramFile, String paramString1, String paramString2, String paramString3) throws Exception
private void loadCCI(File paramFile, string paramString1, string paramString2, string paramString3)
{
StreamReader bufferedReader = new StreamReader(paramFile);
LocalizationProfileTable localizationProfileTable = new LocalizationProfileTable();
localizationProfileTable.SupportsState = false;
localizationProfileTable.ProfileName = paramString3;
localizationProfileTable.CreateDate = DateTime.Now;
localizationProfileTable.LastUpdate = DateTime.Now;
localizationProfileTable.CreateUserId = "rsmeans";
localizationProfileTable.EditorId = "rsmeans";
localizationProfileTable.FromCountry = "US";
localizationProfileTable.FromState = "US AVERAGE";
long?long = (long?)DatabaseDBUtil.currentSession().save(localizationProfileTable);
localizationProfileTable = (LocalizationProfileTable)DatabaseDBUtil.currentSession().load(typeof(LocalizationProfileTable), long);
this.localizationProfileId = long;
if (localizationProfileTable.Factors == null)
{
localizationProfileTable.Factors = new List <object>();
}
sbyte b = 0;
while (true)
{
string str1 = bufferedReader.ReadLine();
if (string.ReferenceEquals(str1, null))
{
break;
}
string str2 = str1.Substring(0, 4);
string str3 = str1.Substring(4, 3);
string str4 = str1.Substring(7, 2);
string str5 = StringUtils.removeSpacesFromEnd(str1.Substring(9, 23));
string str6 = str1.Substring(32, 3);
string str7 = StringUtils.removeSpacesFromStart(str1.Substring(35, 12));
string str8 = StringUtils.removeSpacesFromStart(str1.Substring(47, 12));
string str9 = StringUtils.removeSpacesFromStart(str1.Substring(59, 12));
LocalizationFactorTable localizationFactorTable = new LocalizationFactorTable();
localizationFactorTable.AssemblyFactor = BigDecimalMath.ONE;
localizationFactorTable.EquipmentFactor = BigDecimalMath.ONE;
localizationFactorTable.Online = true;
localizationFactorTable.EditorId = "rsmeans";
localizationFactorTable.SubcontractorFactor = BigDecimalMath.ONE;
localizationFactorTable.LaborFactor = new BigDecimalFixed(str8);
localizationFactorTable.MaterialFactor = new BigDecimalFixed(str7);
localizationFactorTable.ConsumableFactor = BigDecimalMath.ONE;
LocationData locationData = null;
if (locationData == null)
{
locationData = new LocationData();
locationData.City = str5.ToUpper();
locationData.State = str4.ToUpper();
locationData.Country = paramString1;
locationData.ZipCode = str3;
locationData.GeoPolygon = "";
Console.WriteLine("LOADED: " + str3 + ", " + str4 + ", " + str5 + "," + paramString1);
}
localizationFactorTable.ToCountry = locationData.Country;
localizationFactorTable.ToState = locationData.State;
localizationFactorTable.ToCity = locationData.City;
localizationFactorTable.ToZipCode = locationData.ZipCode;
localizationFactorTable.GroupCodeName = paramString2;
localizationFactorTable.ParentCode = str6;
localizationFactorTable.GeoPolygon = locationData.GeoPolygon;
localizationFactorTable.LocalizationProfileTable = localizationProfileTable;
localizationProfileTable.Factors.Add(localizationFactorTable);
DatabaseDBUtil.currentSession().save(localizationFactorTable);
if (++b % 'Ǵ' == 'dz')
{
DatabaseDBUtil.currentSession().Transaction.commit();
DatabaseDBUtil.currentSession().beginTransaction();
Console.WriteLine("Committed " + b + " factors");
}
}
bufferedReader.Close();
DatabaseDBUtil.currentSession().update(localizationProfileTable);
}
