private void AddTranslationToData()
{
string ntFormat = " -nt";
//Countries
/*
* foreach (string tempitem in CountriesList)
* {
* CountriesLngDict.TryGetValue(tempitem, out string value);
*
* if (value != null && value != "")
* {
* tempitem.CountryNameTranslated = value;
* }
* else
* {
* string CapName = CultureInfo.InvariantCulture.TextInfo.ToTitleCase(tempitem);
* tempitem.CountryNameTranslated = CapName;
* }
* }
*/
//Cities
foreach (City _city in from x in CitiesList where !x.Disabled select x)
{
CitiesLngDict.TryGetValue(_city.CityName, out string _translated);
if (_translated != null && _translated != "")
{
_city.CityNameTranslated = _translated;
}
else
{
_city.CityNameTranslated = _city.CityName + ntFormat;
}
}
CitiesList = CitiesList.OrderBy(x => x.CityNameTranslated).ToList();
//Garages
foreach (Garages _garage in GaragesList)
{
CitiesLngDict.TryGetValue(_garage.GarageName, out string _translated);
if (_translated != null && _translated != "")
{
_garage.GarageNameTranslated = _translated;
}
else
{
_garage.GarageNameTranslated = _garage.GarageName + ntFormat;
}
}
GaragesList = GaragesList.OrderBy(x => x.GarageNameTranslated).ToList();
//Companies
}
//Translate CB
private void RefreshComboboxes()
{
int savedindex = 0, j = 0;
string savedvalue = "", ntFormat = " -nt";
DataTable temptable = new DataTable();
//Countries ComboBoxes
temptable = comboBoxFreightMarketCountries.DataSource as DataTable;
if (temptable != null)
{
savedindex = comboBoxFreightMarketCountries.SelectedIndex;
if (savedindex != -1)
{
savedvalue = comboBoxFreightMarketCountries.SelectedValue.ToString();
}
comboBoxFreightMarketCountries.SelectedIndexChanged -= comboBoxCountries_SelectedIndexChanged;
//i = 0;
foreach (DataRow temp in temptable.Rows)
{
string source = temp[0].ToString();
CountriesLngDict.TryGetValue(source, out string value);
if (value != null && value != "")
{
temp[1] = value;
}
else
{
string CapName = CultureInfo.InvariantCulture.TextInfo.ToTitleCase(source);
temp[1] = CapName;
}
}
DataTable sortedDT = temptable.DefaultView.Table.Copy();
DataView dv = sortedDT.DefaultView;
dv.Sort = "CountryName ASC";
sortedDT = dv.ToTable();
sortedDT.DefaultView.Sort = "";
//Shift All
DataRow sourceRow = sortedDT.Select("Country = '+all'")[0];
int rowi = sortedDT.Rows.IndexOf(sourceRow);
DataRow row = sortedDT.NewRow();
row.ItemArray = sourceRow.ItemArray;
sortedDT.Rows.RemoveAt(rowi);
sortedDT.Rows.InsertAt(row, 0);
//Shift Unsorted
try
{
sourceRow = sortedDT.Select("Country = '+unsorted'")[0];
rowi = sortedDT.Rows.IndexOf(sourceRow);
row = sortedDT.NewRow();
row.ItemArray = sourceRow.ItemArray;
sortedDT.Rows.RemoveAt(rowi);
sortedDT.Rows.InsertAt(row, 1);
}
catch { }
comboBoxFreightMarketCountries.DataSource = sortedDT;
if (savedindex != -1)
{
comboBoxFreightMarketCountries.SelectedValue = savedvalue;
}
else
{
comboBoxFreightMarketCountries.SelectedValue = "+all";
}
comboBoxFreightMarketCountries.SelectedIndexChanged += comboBoxCountries_SelectedIndexChanged;
}
//Companies
temptable = comboBoxFreightMarketCompanies.DataSource as DataTable;
if (temptable != null)
{
savedindex = comboBoxFreightMarketCompanies.SelectedIndex;
if (savedindex != -1)
{
savedvalue = comboBoxFreightMarketCompanies.SelectedValue.ToString();
}
comboBoxFreightMarketCompanies.SelectedIndexChanged -= comboBoxCompanies_SelectedIndexChanged;
//i = 0;
foreach (DataRow temp in temptable.Rows)
{
string source = temp[0].ToString();
CompaniesLngDict.TryGetValue(source, out string value);
if (value != null && value != "")
{
temp[1] = value;
}
else
{
temp[1] = source + ntFormat;
}
}
DataTable sortedDT = temptable.DefaultView.Table.Copy();
DataView dv = sortedDT.DefaultView;
dv.Sort = "CompanyName ASC";
sortedDT = dv.ToTable();
sortedDT.DefaultView.Sort = "";
DataRow sourceRow = sortedDT.Select("Company = '+all'")[0];
int rowi = sortedDT.Rows.IndexOf(sourceRow);
DataRow row = sortedDT.NewRow();
row.ItemArray = sourceRow.ItemArray;
sortedDT.Rows.RemoveAt(rowi);
sortedDT.Rows.InsertAt(row, 0);
comboBoxFreightMarketCompanies.DataSource = sortedDT;
if (savedindex != -1)
{
comboBoxFreightMarketCompanies.SelectedValue = savedvalue;
}
else
{
comboBoxFreightMarketCompanies.SelectedValue = "+all";
}
comboBoxFreightMarketCompanies.SelectedIndexChanged += comboBoxCompanies_SelectedIndexChanged;
}
//////
//Cities ComboBoxes
ComboBox[] CitiesCB = { comboBoxFreightMarketSourceCity, comboBoxFreightMarketDestinationCity, comboBoxUserCompanyHQcity, comboBoxCargoMarketSourceCity };
EventHandler[] CitiesCBeh = { comboBoxSourceCity_SelectedIndexChanged, comboBoxDestinationCity_SelectedIndexChanged, comboBoxUserCompanyHQcity_SelectedIndexChanged, comboBoxSourceCityCM_SelectedIndexChanged };
j = 0;
foreach (ComboBox tempCB in CitiesCB)
{
temptable = tempCB.DataSource as DataTable;
if (temptable != null)
{
savedindex = tempCB.SelectedIndex;
if (savedindex != -1)
{
savedvalue = tempCB.SelectedValue.ToString();
}
tempCB.SelectedIndexChanged -= CitiesCBeh[j];
//i = 0;
foreach (DataRow temp in temptable.Rows)
{
string source = temp[0].ToString();
CitiesLngDict.TryGetValue(source, out string value);
if (value != null && value != "")
{
temp[1] = value;
}
else
{
temp[1] = source + ntFormat;
}
}
if (savedindex != -1)
{
tempCB.SelectedValue = savedvalue;
}
tempCB.SelectedIndexChanged += CitiesCBeh[j];
j++;
}
}
//////
//Companies ComboBoxes
ComboBox[] CompaniesCB = { comboBoxFreightMarketSourceCompany, comboBoxFreightMarketDestinationCompany, comboBoxSourceCargoMarketCompany };
EventHandler[] CompaniesCBeh = { comboBoxSourceCompany_SelectedIndexChanged, comboBoxDestinationCompany_SelectedIndexChanged, comboBoxSourceCompanyCM_SelectedIndexChanged };
j = 0;
foreach (ComboBox tempCB in CompaniesCB)
{
temptable = tempCB.DataSource as DataTable;
if (temptable != null)
{
savedindex = tempCB.SelectedIndex;
if (savedindex != -1)
{
savedvalue = tempCB.SelectedValue.ToString();
}
tempCB.SelectedIndexChanged -= CompaniesCBeh[j];
//i = 0;
foreach (DataRow temp in temptable.Rows)
{
string source = temp[0].ToString();
CompaniesLngDict.TryGetValue(source, out string value);
if (value != null && value != "")
{
temp[1] = value;
}
else
{
temp[1] = source + ntFormat;
}
}
if (savedindex != -1)
{
tempCB.SelectedValue = savedvalue;
}
tempCB.SelectedIndexChanged += CompaniesCBeh[j];
j++;
}
}
//Freight Market
//Cargo
temptable = comboBoxFreightMarketCargoList.DataSource as DataTable;
if (temptable != null)
{
savedindex = comboBoxFreightMarketCargoList.SelectedIndex;
if (savedindex != -1)
{
savedvalue = comboBoxFreightMarketCargoList.SelectedValue.ToString();
}
comboBoxFreightMarketCargoList.SelectedIndexChanged -= comboBoxCargoList_SelectedIndexChanged;
//i = 0;
foreach (DataRow temp in temptable.Rows)
{
string source = temp[0].ToString();
CargoLngDict.TryGetValue(source, out string value);
if (value != null && value != "")
{
temp[1] = value;
}
else
{
temp[1] = source + ntFormat;
}
}
if (savedindex != -1)
{
comboBoxFreightMarketCargoList.SelectedValue = savedvalue;
}
comboBoxFreightMarketCargoList.SelectedIndexChanged += comboBoxCargoList_SelectedIndexChanged;
}
//Urgency
temptable = comboBoxFreightMarketUrgency.DataSource as DataTable;
if (temptable != null)
{
//i = 0;
foreach (DataRow temp in temptable.Rows)
{
string source = temp[0].ToString();
UrgencyLngDict.TryGetValue(source, out string value);
if (value != null && value != "")
{
temp[1] = value;
}
else
{
temp[1] = source + ntFormat;
}
}
}
//////
//ListBoxes
FillVisitedCities(listBoxVisitedCities.TopIndex);
FillGaragesList(listBoxGarages.TopIndex);
listBoxFreightMarketAddedJobs.Refresh();
}