public CitiesViewModel()
{
DeleteCityCommand = new RelayCommand(Delete, () => { return(CitiesList.Contains(SelectedCity)); });
AddCity = new CityViewModel();
SelectedCity = new CityViewModel();
CitiesList = GetCities();
}
private void OKbutton_Click(object sender, EventArgs e)
{
CitiesList _cl = (CitiesList)CityComboBox.DataSource;
if (_cl.Count == 0)
{
MessageBox.Show("У вказаній країні не вказано міст. Виберіть іншу країну.", "Не вибране місто", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (_cl.Count != 0)
{
airport.AirPortName = airPortNameTextBox.Text;
airport.AirPortCityID = (int)CityComboBox.SelectedValue;
if (act == Action.update)
{
airport.UpdateAirport();
}
else if (act == Action.insert)
{
airport.InsertAirport();
}
if (airport.e != null)
{
MessageBox.Show("Внутрішня помилка, дані не можуть бути оновленні по невідомій причині. При повторній появі помилки зверніться до адміністратора.", "Невідома помилка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
}
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
CitiesList cl = CitiesList.GetCitiesListByCountry((int)countryComboBox.SelectedValue);
CityComboBox.DataSource = cl;
CityComboBox.DisplayMember = "CityName";
CityComboBox.ValueMember = "CityID";
}
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
}
private void buttonCargoMarketResetCargoCompany_Click(object sender, EventArgs e)
{
List <Company> CityCompanies = CitiesList.Find(x => x.CityName == comboBoxCargoMarketSourceCity.SelectedValue.ToString()).ReturnCompanies();
List <Company> RealCompanies = CityCompanies.FindAll(x => !x.Excluded);
RealCompanies.Find(x => x.CompanyName == comboBoxSourceCargoMarketCompany.SelectedValue.ToString()).CragoSeeds = new int[0];
PrintCargoSeeds();
}
public IActionResult Edit(CitiesList model)
{
if (ModelState.IsValid)
{
dataManager.CitiesOfList.SaveCity(model);
return(RedirectToAction(nameof(HomeController.CitiesList), nameof(HomeController).CutController()));
}
return(View(model));
}
public void Delete()
{
if (DeleteYesNoHelper.DeleteYesNoMessageBox("Искате ли да изтриете този град \n\nВнимание: Това ще изтрие и всички негови региони ", "Изтриване"))
{
DbContext.CITIES.Remove(DbContext.CITIES.Where(c => SelectedCity.CITYID == c.CITYID).FirstOrDefault());
DbContext.SaveChanges();
CitiesList.Remove(SelectedCity);
}
}
protected void butLogin_Click(object sender, ImageClickEventArgs e)
{
try
{
AdminHelper adminHelper = new AdminHelper();
double tempPrice;
double? nullPrice = null;
int tempID = 0;
CompanyCityPrice companyCityPriceTemp;
List <CompanyCityPrice> tempCCPL = new List <CompanyCityPrice>();
for (int i = 0; i < GridView1.Rows.Count; i++)
{
double.TryParse(((TextBox)GridView1.Rows[i].Cells[2].FindControl("txtPrice")).Text, out tempPrice);
int.TryParse(((HiddenField)GridView1.Rows[i].Cells[2].FindControl("hfID")).Value, out tempID);
companyCityPriceTemp = CitiesList.Where(xx => xx.CompanyCityPriceID == tempID).FirstOrDefault();
if (companyCityPriceTemp != null)
{
companyCityPriceTemp.Price = tempPrice > 0 ? tempPrice : nullPrice;
tempCCPL.Add(companyCityPriceTemp);
}
}
using (var dc = new LimoEntitiesEntityFremwork())
{
List <int> tempIDsList = tempCCPL.Select(yy => yy.CompanyCityPriceID).ToList();
List <CompanyCityPrice> dbList =
dc.CompanyCityPrices.Where(xx => tempIDsList.Contains(xx.CompanyCityPriceID)).ToList();
foreach (var companyCityPrice in dbList)
{
CompanyCityPrice tempTemp =
tempCCPL.Where(xx => xx.CompanyCityPriceID == companyCityPrice.CompanyCityPriceID).Single();
companyCityPrice.Price = tempTemp.Price;
}
dc.SaveChanges();
CitiesList =
dc.CompanyCityPrices.Where(
xx =>
xx.IsActive.HasValue && xx.CompanyID == adminHelper.CompanyObject.CompanyID && xx.IsActive.Value)
.ToList
();
foreach (var companyCityPrice in CitiesList)
{
companyCityPrice.CityName = companyCityPrice.cities_extended.CityName;
companyCityPrice.StateName = companyCityPrice.cities_extended.State.StateName;
}
}
int pageIndex = GridView1.PageIndex;
GridView1.DataSource = CitiesList;
GridView1.DataBind();
GridView1.PageIndex = pageIndex;
divConfirmation.Visible = true;
}
catch (Exception)
{
divError.Visible = true;
}
}
private void GetUIDataFromDB()
{
FlightsViewModel.GetAllCities().ForEach(c => CitiesList.Add(c));
CitiesList.Insert(0, "Not selected");
SelectedCity = CitiesList[0];
FlightsViewModel.GetAllCompanies().ForEach(c => CompaniesList.Add(c.name));
CompaniesList.Insert(0, "Not selected");
SelectedCompany = CompaniesList[0];
SelectTrips();
}
public void SaveCity(CitiesList entity)
{
if (entity.Id == default)
{
context.Entry(entity).State = EntityState.Added;
}
else
{
context.Entry(entity).State = EntityState.Modified;
}
context.SaveChanges();
}
public static void ExampleOne()
{
var query = CitiesList.Filter(c => c.StartsWith("L"));
var comprehensionQuery =
from city in CitiesList
where city.StartsWith("L")
where city.Length.Equals(6)
select city;
query.WriteForEach();
comprehensionQuery.WriteForEach();
}
private void OnSearch()
{
List <City> listaGradova = new List <City>();
City sc = new City();
CitiesList.Clear();
listaGradova = sc.GetSearchDone(Search);
foreach (var item in listaGradova)
{
CitiesList.Add(item);
}
}
public void OnShowAll()
{
bool check = true;
if (check)
{
if (Selected == null)
{
List <City> listaGradova = new List <City>();
CitiesList.Clear();
City c = new City();
listaGradova = c.GetAllCitiesListDone();
foreach (var item in listaGradova)
{
CitiesList.Add(item);
}
List <Comment> com = new List <Comment>();
Comment ccc = new Comment();
CommentList.Clear();
com = ccc.GetAllComment();
foreach (var item in com)
{
CommentList.Add(item);
}
}
else
{
List <City> listaGradova = new List <City>();
City c = new City();
c.CityName = Selected.CityName;
List <Comment> com = new List <Comment>();
Comment ccc = new Comment();
CommentList.Clear();
com = ccc.GetAllCommentSelected(c.CityName.ToString());
foreach (var item in com)
{
CommentList.Add(item);
}
Selected = null;
}
}
}
void StatesUpdated(ChangeEventArgs e)
{
//Update the state list
if (e.Value.ToString().Equals("Odisha"))
{
this.Cities = CitiesList.GetCitiesInOdisha();
}
if (e.Value.ToString().Equals("Karnataka"))
{
this.Cities = CitiesList.GetCitiesInKarnataka();
}
this.RegisterModel.State = e.Value.ToString();
}
public static void ExampleTwo()
{
var query = CitiesList.Where(c => c.StartsWith("L"))
.OrderByDescending(c => c.Length);
var comprehensionQuery =
from city in CitiesList
where city.StartsWith("L")
orderby city.Length descending
select city;
query.WriteForEach();
comprehensionQuery.WriteForEach();
}
private void countrycomboBox_SelectedValueChanged(object sender, EventArgs e)
{
if (_loaded == true)
{
int _selectedCountry = (int)countrycomboBox.SelectedValue;
CitiesList _citiesList = CitiesList.GetCitiesListByCountry(_selectedCountry);
//citycomboBox.DataSource = null;
citycomboBox.DisplayMember = "CityName";
citycomboBox.ValueMember = "CityID";
citycomboBox.DataSource = _citiesList;
}
}
public IActionResult Update(int id, CitiesList newCitiesList)
{
var citiesList = _context.citiesLists.Find(id);
if (citiesList == null)
{
return(NotFound());
}
citiesList.parentId = newCitiesList.parentId;
citiesList.cityId = newCitiesList.cityId;
_context.citiesLists.Update(citiesList);
_context.SaveChanges();
return(NoContent());
}
private void addCitiesToComboBox(int CountryID)
{
CitiesList cl = CitiesList.GetCitiesListByCountry(CountryID);
City ci = new City();
ci.CityID = 0;
ci.CityName = "Виберіть місто...";
cl.Insert(0, ci);
cityComboBox.DataSource = null;
//cityComboBox.SelectedItem = null;
//cityComboBox.Items.Clear();
cityComboBox.DataSource = cl;
cityComboBox.DisplayMember = "CityName";
cityComboBox.ValueMember = "CityID";
}
/// <summary>
/// Получения списока городов.
/// </summary>
private void GetData()
{
citiesList = new ObservableCollection <City>();
response = new InteractionServer();
List <City> lp = response.GetCitiesList();
for (int i = 0; i < lp.Count; i++)
{
CitiesList.Add(new City {
Idcity = lp[i].Idcity, Town = lp[i].Town
});
}
base.RaisePropertyChangedEvent("CitiesList");
}
private void buttonCargoMarketRandomizeCargoCompany_Click(object sender, EventArgs e)
{
List <Company> CityCompanies = CitiesList.Find(x => x.CityName == comboBoxCargoMarketSourceCity.SelectedValue.ToString()).ReturnCompanies();
List <Company> RealCompanies = CityCompanies.FindAll(x => !x.Excluded);
int[] tempseeds = new int[10];
for (int i = 0; i < tempseeds.Length; i++)
{
tempseeds[i] = InGameTime + RandomValue.Next(180, 1800);
}
RealCompanies.Find(x => x.CompanyName == comboBoxSourceCargoMarketCompany.SelectedValue.ToString()).CragoSeeds = tempseeds;
PrintCargoSeeds();
}
public CitiesList GetCities()
{
var requestJson = WebRequest.Create("https://www.redesocialdecidades.org.br/cities");
var bodyJson = requestJson.GetResponse();
string objText;
using (var sr = new StreamReader(bodyJson.GetResponseStream()))
{
objText = sr.ReadToEnd();
}
CitiesList cities = JsonConvert.DeserializeObject <CitiesList>(objText);
//var node = JsonConvert.DeserializeXmlNode(jsonObj, "Root");
return(cities /*node.DocumentElement*/);
}
private void PrintCargoSeeds()
{
listBoxCargoMarketSourceCargoSeeds.Items.Clear();
if (comboBoxCargoMarketSourceCity.SelectedValue != null && comboBoxSourceCargoMarketCompany.SelectedValue != null) //&& ExternalCompanies.Count > 0)
{
foreach (int cargoseed in CitiesList.Find(x => x.CityName == comboBoxCargoMarketSourceCity.SelectedValue.ToString()).ReturnCompanies().Find(x => x.CompanyName == comboBoxSourceCargoMarketCompany.SelectedValue.ToString()).CragoSeeds)
{
string cargoforseed = "";
listBoxCargoMarketSourceCargoSeeds.Items.Add("" + cargoseed.ToString().PadRight(12, ' ') + " | Time left " + ((cargoseed - InGameTime) / 60).ToString().PadLeft(2) + " h " +
((cargoseed - InGameTime) % 60).ToString().PadLeft(2) + " m " + cargoforseed);
}
}
else
{
}
}
private void SetupSourceCompaniesCM()
{
List <Company> CityCompanies = CitiesList.Find(x => x.CityName == comboBoxCargoMarketSourceCity.SelectedValue.ToString()).ReturnCompanies();
List <Company> RealCompanies = CityCompanies.FindAll(x => !x.Excluded);
DataTable combDT = new DataTable();
DataColumn dc = new DataColumn("Company", typeof(string));
combDT.Columns.Add(dc);
dc = new DataColumn("CompanyName", typeof(string));
combDT.Columns.Add(dc);
foreach (Company company in RealCompanies)
{
combDT.Rows.Add(company.CompanyName, company.CompanyNameTranslated);
}
combDT.DefaultView.Sort = "CompanyName ASC";
comboBoxSourceCargoMarketCompany.ValueMember = "Company";
comboBoxSourceCargoMarketCompany.DisplayMember = "CompanyName";
comboBoxSourceCargoMarketCompany.DataSource = combDT;
}
public void LoadCities()
{
CitiesList = swClient.GetCities().ToList();
SelectedCity = CitiesList.First();
}
private void EditFlightForm_Load(object sender, EventArgs e)
{
//для всіх
PlaneList _PlaneList = PlaneList.GetRefPlanesList();
planecomboBox.DataSource = _PlaneList;
planecomboBox.DisplayMember = "PlaneNumber";
planecomboBox.ValueMember = "PlaneID";
AircompaniesList _AircompaniesList = AircompaniesList.GetRefAircompaniesList();
aircompanycomboBox.DataSource = _AircompaniesList;
aircompanycomboBox.DisplayMember = "AirCompanyName";
aircompanycomboBox.ValueMember = "AirCompanyID";
if (act == Action.Insert)
{
//для вставки
CountriesList _countriesList = CountriesList.GetRefCountriesList();
countrycomboBox.DataSource = _countriesList;
countrycomboBox.DisplayMember = "CountryName";
countrycomboBox.ValueMember = "CountryID";
int _selectedCountry = (int)countrycomboBox.SelectedValue;
CitiesList _citiesList = CitiesList.GetCitiesListByCountry(_selectedCountry);
citycomboBox.DataSource = _citiesList;
citycomboBox.DisplayMember = "CityName";
citycomboBox.ValueMember = "CityID";
int _selectedCity = (int)citycomboBox.SelectedValue;
AirPortList _airportList = AirPortList.GetRefAirportListByCity(_selectedCity);
airportcomboBox.DataSource = _airportList;
airportcomboBox.DisplayMember = "AirportName";
airportcomboBox.ValueMember = "AirportID";
flightTypecomboBox.SelectedIndex = 0;
_loaded = true;
}
if (act == Action.Update)
{
//для оновлення
try
{
aircompanycomboBox.SelectedValue = Flight.FlightAircompanyID;
planecomboBox.SelectedValue = Flight.FlightPlaneID;
AirPort _apinfo = new AirPort();
_apinfo.GetAirport(Flight.FlightAirPortID);
City _City = new City();
_City.GetCity(_apinfo.AirPortCityID);
CountriesList _countriesList = CountriesList.GetRefCountriesList();
countrycomboBox.DataSource = _countriesList;
countrycomboBox.DisplayMember = "CountryName";
countrycomboBox.ValueMember = "CountryID";
countrycomboBox.SelectedValue = _City.CountryID;
CitiesList _citiesList = CitiesList.GetCitiesListByCountry(_City.CountryID);
citycomboBox.DataSource = _citiesList;
citycomboBox.DisplayMember = "CityName";
citycomboBox.ValueMember = "CityID";
citycomboBox.SelectedValue = _apinfo.AirPortCityID;
AirPortList _airportList = AirPortList.GetRefAirportListByCity(_apinfo.AirPortCityID);
airportcomboBox.DataSource = _airportList;
airportcomboBox.DisplayMember = "AirportName";
airportcomboBox.ValueMember = "AirportID";
airportcomboBox.SelectedValue = _apinfo.AirPortID;
if (Flight.FlightType == "Вхідний")
{
flightTypecomboBox.SelectedIndex = 0;
}
else if (Flight.FlightType == "Вихідний")
{
flightTypecomboBox.SelectedIndex = 1;
}
startdateTimePicker.Value = Flight.FlightDateTimeStart;
DateTime _tempDuration = Convert.ToDateTime("1900-01-01 " + Flight.FlightDuration);
economnumericUpDown.Value = Flight.FlightPriceEconom;
businessnumericUpDown.Value = Flight.FlightPriceBusiness;
firstnumericUpDown.Value = Flight.FlightPriceFirst;
numOfFlishgslabel.Visible = false;
periodicitylabel.Visible = false;
numOfFlightsnumericUpDown.Visible = false;
periodicitydateTimePicker.Visible = false;
if (Config.HasUserAccess("UpdateFlight"))
{
okButton.Visible = true;
}
else
{
okButton.Visible = false;
}
_loaded = true;
}
catch (Exception)
{
_error = true;
}
}
}
public void Add <T>(T model)
{
var theType = model.GetType().Name;
switch (theType)
{
case "User": UsersList.Add(model as User); return;
case "News": NewsesList.Add(model as Dal.Models.News); return;
case "Category": CategoriesList.Add(model as Category); return;
case "Magazine": MagazinesList.Add(model as Magazine); return;
case "SmartLink": SmartLinksList.Add(model as SmartLink); return;
case "Comment": CommentsList.Add(model as Comment); return;
case "Visit": VisitsList.Add(model as Visit); return;
case "NewsLetter": NewsLettersList.Add(model as NewsLetter); return;
case "Slider": SlidersList.Add(model as Slider); return;
case "Slide": SlidesList.Add(model as Slide); return;
case "UserMagazine": UserMagazinesList.Add(model as UserMagazine); return;
case "State": StatesList.Add(model as State); return;
case "City": CitiesList.Add(model as City); return;
case "Media": MediasList.Add(model as Media); return;
case "Report": ReportsList.Add(model as Report); return;
case "Vote": VotesList.Add(model as Vote); return;
case "Advertise": AdvertisesList.Add(model as Advertise); return;
case "AdCategory": AdCategoriesList.Add(model as AdCategory); return;
case "Galery": GaleriesList.Add(model as Galery); return;
case "GaleryImage": GaleryImagesList.Add(model as GaleryImage); return;
case "Image": ImagesList.Add(model as Image); return;
case "KeyPoint": KeyPointsList.Add(model as KeyPoint); return;
case "KeyPointsContainer": KeyPointsContainersList.Add(model as KeyPointsContainer); return;
case "Quiz": QuizesList.Add(model as Quiz); return;
case "Question": QuestionsList.Add(model as Question); return;
case "Answer": AnswersList.Add(model as Answer); return;
case "Option": OptionList.Add(model as Option); return;
case "ItemList": ItemsListList.Add(model as ItemList); return;
default: throw new Exception("The type " + theType + " is not supported.");
}
}
public IActionResult Post([FromBody] CitiesList citiesList)
{
_context.citiesLists.Add(citiesList);
_context.SaveChanges();
return(CreatedAtRoute("GetCitiesListById", new { id = citiesList.id }, citiesList));
}
internal void SetData(CitiesList cities)
{
_boxes = cities;
}
public static void ExampleTwo()
{
var query = CitiesList.StringsThatStartWith("L");
query.WriteForEach();
}
protected override void ClearData()
{
CitiesList.Clear();
}
private void AirPortEditForm_Load(object sender, EventArgs e)
{
CountriesList _countries = CountriesList.GetDefaultCountriesList();
countryComboBox.DataSource = _countries;
countryComboBox.DisplayMember = "CountryName";
countryComboBox.ValueMember = "CountryID";
//якщо кількість країн рівна нулю
if (_countries.Count == 0)
{
DialogResult di = MessageBox.Show("Список країн пустий, операція неможлива. Зверніться до адміністратора для вирішення даної проблеми.", "Операція неможлива", MessageBoxButtons.OK, MessageBoxIcon.Error);
if (di == System.Windows.Forms.DialogResult.OK)
{
this.Close();
}
}
//Якщо є інші країни
else if (_countries.Count > 0)
{
/*int countryID = (int)countryComboBox.SelectedValue;
* CitiesList _cities = CitiesList.GetCitiesListByCountry(countryID);
* CityComboBox.DataSource = _cities;
* CityComboBox.DisplayMember = "CityName";
* CityComboBox.ValueMember = "CityID";
*/
//для вставки
//для оновлення
if (act == Action.update)
{
//місто і країна в яких знаходиться аеропорт
Country country = new Country();
City city = new City();
city.GetCity(airport.AirPortCityID);
country.GetCountry(city.CountryID);
int _selectedCountryID = country.CountryID;
int _selectedCityID = city.CityID;
//Заповняємо комбобокс містами
CitiesList _cities = CitiesList.GetCitiesListByCountry(_selectedCountryID);
CityComboBox.DataSource = _cities;
CityComboBox.DisplayMember = "CityName";
CityComboBox.ValueMember = "CityID";
countryComboBox.SelectedValue = _selectedCountryID;
CityComboBox.SelectedValue = _selectedCityID;
airPortNameTextBox.Text = airport.AirPortName;
if (Config.HasUserAccess("UpdateAirport"))
{
OKbutton.Visible = true;
}
else
{
OKbutton.Visible = false;
}
}
else if (act == Action.insert)
{
}
}
}
