public IActionResult Index(SortingInputModel sorting, int pageId = 1) { if (sorting.OrderBy == null) { sorting = new SortingInputModel() { Ascending = true, OrderBy = "Name", }; } var orderBySelector = GetOrderBySelector(sorting); var skip = DefaultItemsPerPage * (pageId - 1); var citiesViewModel = new CitiesViewModel() { Cities = this.citiesService .GetMany <CityViewModel>( orderBySelector: orderBySelector, asc: sorting.Ascending, skip: skip, take: DefaultItemsPerPage), Common = new CommonViewModel() { Pagination = this.GetPaginationModel(pageId, this.citiesService.Count()), Sorting = sorting, }, }; return(this.View(citiesViewModel)); }
public List <CitiesViewModel> GetAllCitiesByName(string cityName) { Query = "SELECT * FROM CitiesViewModel WHERE CityName LIKE '%' + @CityName + '%' ORDER BY CityName "; Command = new SqlCommand(Query, Connection); Command.Parameters.Clear(); Command.Parameters.Add("CityName", SqlDbType.NVarChar); Command.Parameters["CityName"].Value = cityName; Connection.Open(); Reader = Command.ExecuteReader(); List <CitiesViewModel> yCityList = new List <CitiesViewModel>(); while (Reader.Read()) { CitiesViewModel aCity = new CitiesViewModel(); aCity.CityName = Reader["CityName"].ToString(); aCity.CityAbout = Reader["About"].ToString(); aCity.NoOfDwellers = (int)Reader["NoOfDwellers"]; aCity.Location = Reader["Location"].ToString(); aCity.Weather = Reader["Weather"].ToString(); aCity.CountryName = Reader["Country"].ToString(); aCity.AboutCountry = Reader["About Country"].ToString(); yCityList.Add(aCity); } Reader.Close(); Connection.Close(); return(yCityList); }
public List <CitiesViewModel> GetAllCitiesByCountryId(string selectedCountryId) { Query = "SELECT * FROM CitiesViewModel WHERE CountryId = @CountryId"; Command = new SqlCommand(Query, Connection); Command.Parameters.Clear(); Command.Parameters.Add("CountryId", SqlDbType.Int); Command.Parameters["CountryId"].Value = Convert.ToInt32(selectedCountryId); Connection.Open(); Reader = Command.ExecuteReader(); List <CitiesViewModel> yCityList = new List <CitiesViewModel>(); while (Reader.Read()) { CitiesViewModel aCity = new CitiesViewModel(); aCity.CityName = Reader["CityName"].ToString(); aCity.CityAbout = Reader["About"].ToString(); aCity.NoOfDwellers = (int)Reader["NoOfDwellers"]; aCity.Location = Reader["Location"].ToString(); aCity.Weather = Reader["Weather"].ToString(); aCity.CountryName = Reader["Country"].ToString(); aCity.AboutCountry = Reader["About Country"].ToString(); yCityList.Add(aCity); } Reader.Close(); Connection.Close(); return(yCityList); }
public ActionResult Index() { StudentEntities obj = new StudentEntities(); List <SelectListItem> listitem = new List <SelectListItem>(); foreach (tblCity city in obj.tblCities) { SelectListItem selectlistitem = new SelectListItem() { Text = city.Name, Value = city.ID.ToString(), Selected = city.IsSelected }; listitem.Add(selectlistitem); } CitiesViewModel CitiesViewModel = new CitiesViewModel(); CitiesViewModel.Cities = listitem; return(View(CitiesViewModel)); }
public IActionResult GetCities() { var model = new CitiesViewModel(); model.Cities = _AddressData.GetCities(); return(View(model)); }
public async Task LoadCommand_CallsAlertService_LoadFailure() { // arrange var navigationsServiceMock = new Mock <IMvxNavigationService>(MockBehavior.Loose); var alertServiceMock = MockHelpers.CreateAlertService(); var citiesRepositoryMock = new Mock <ICitiesRepository>(MockBehavior.Strict); var zipCodesRepositoryMock = new Mock <IZipCodesRepository>(MockBehavior.Loose); var viewModel = new CitiesViewModel( navigationsServiceMock.Object, alertServiceMock.Object, citiesRepositoryMock.Object, zipCodesRepositoryMock.Object ); // act await viewModel.LoadCommand.ExecuteAsync(); // assert alertServiceMock.Verify(mock => mock.Alert( It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <Action>() ), Times.Once()); }
public async Task LoadCommand_SetsItemsCorrectly() { // arrange var navigationsServiceMock = new Mock <IMvxNavigationService>(MockBehavior.Loose); var alertServiceMock = MockHelpers.CreateAlertService(); var citiesRepositoryMock = new Mock <ICitiesRepository>(MockBehavior.Loose); citiesRepositoryMock.Setup(mock => mock.GetAll()) .Returns(new[] { new CityModel { Id = 1 } }); var zipCodesRepositoryMock = new Mock <IZipCodesRepository>(MockBehavior.Loose); var viewModel = new CitiesViewModel( navigationsServiceMock.Object, alertServiceMock.Object, citiesRepositoryMock.Object, zipCodesRepositoryMock.Object ); // act await viewModel.LoadCommand.ExecuteAsync(); // assert Assert.AreEqual(1, viewModel.Items.Count); }
public async Task <IActionResult> GetCities(int page, int pageSize, string cityName = null) { var cities = await _cityService.GetAllDTOAsync(cityName); var citiesViewModel = new CitiesViewModel(page, pageSize, cities, User.IsInRole(Roles.Admin)); return(Ok(citiesViewModel)); }
public async Task <IActionResult> GetCities(int page, int pageSize) { var cities = await _cityService.GetAllDTOAsync(); var citiesViewModel = new CitiesViewModel(page, pageSize, cities, User.IsInRole("Admin")); return(Ok(citiesViewModel)); }
// Get all cities public static CitiesViewModel GetCities() { CitiesViewModel model = new CitiesViewModel(); model.Cities = Startup.openAQHelper.GetCities(); return(model); }
public IActionResult GetCityList() { var cvm = new CitiesViewModel { Cities = cityService.GetCities().ToArray() }; return(View("City/GetCityList", cvm)); }
public CityListView() { vm = new CitiesViewModel(); vm.updateWeathers(); BindingContext = vm; InitializeComponent(); cityPicker.ItemsSource = vm.AllCities; }
public ActionResult Index() { var model = new CitiesViewModel { FilterText = "" }; return(View(model)); }
public MainWindow() { _viewModel = new CitiesViewModel(); Title = "Code Challenge Weather App"; InitializeComponent(); forecastListView.citySearchBoxView.searchBox.SuggestionSelected += SearchBox_SuggestionSelected; _pushpins = new List <Pushpin>(); InitializeMapPinsAndCenter(); }
public CitiesView(bool onlyFavorites) { BindingContext = new CitiesViewModel(onlyFavorites); var stack = new StackLayout { Orientation = StackOrientation.Vertical, Padding = new Thickness(0, 8, 0, 8) }; var activity = new ActivityIndicator { Color = Xamarin.Forms.Color.Blue, //Helpers.Color.DarkBlue.ToFormsColor(), IsEnabled = true }; activity.SetBinding(ActivityIndicator.IsVisibleProperty, "IsBusy"); activity.SetBinding(ActivityIndicator.IsRunningProperty, "IsBusy"); stack.Children.Add(activity); var label = new Label() { Text = "Loading...", HorizontalOptions = LayoutOptions.Center }; label.SetBinding(Label.IsVisibleProperty, "IsBusy"); label.SetBinding(Label.TextProperty, "LoadingLabel"); stack.Children.Add(label); var listView = new ListView(); listView.SetBinding(ListView.IsVisibleProperty, "IsNotBusy"); listView.ItemsSource = ViewModel.Items; var cell = new DataTemplate(typeof(TextCell)); cell.SetBinding(TextCell.TextProperty, "NameEn"); cell.SetBinding(TextCell.DetailProperty, "Province"); listView.ItemTapped += (sender, args) => { if (listView.SelectedItem == null) { return; } this.Navigation.PushAsync(new ForecastView(listView.SelectedItem as City)); listView.SelectedItem = null; }; listView.ItemTemplate = cell; stack.Children.Add(listView); Content = stack; }
public IActionResult Index() { CitiesViewModel vm = new CitiesViewModel() { Cities = _db.Cities.ToList(), Countries = _db.Countries.ToList() }; return(View(vm)); }
void AddSelectedCity(object sender, EventArgs e) { CitiesViewModel cvm = MSProApp.Locator.CitiesVM; string Selected = CitiesToSelect.SelectedItem.ToString().Replace(" ", "|"); string[] Temp = Selected.Split('|'); string City = Temp[0]; cvm.AddSelectedCity(City); }
public CitySearchView() { _viewModel = new CitiesViewModel(); DataContext = _viewModel; InitializeComponent(); foreach (var city in _viewModel.Cities) { searchBox.AddItem(new AutoCompleteEntry(city.CityName, city.CityName.ToLower(), city.CityName.ToUpper())); } }
public JsonResult Cities(CitiesViewModel viewModel) { var cities = (from r in this._db.Cities where r.StateCode == viewModel._value select r).ToDictionary(x => x.id.ToString(), x => x.Name); cities.Add("0", "Please select ..."); JavaScriptSerializer serializer = new JavaScriptSerializer(); string html = "[" + serializer.Serialize(cities) + "]"; return(Json(html, JsonRequestBehavior.AllowGet)); }
public ActionResult GetGroup(int idPriceGroup) { ViewBag.breadcrumbViewModel = new BreadcrumbViewModel("Grupo", "fa-table", "Grupo"); var group = Business.Groups.GetPriceGroup(idPriceGroup); var cities = Business.City.GetCities(idPriceGroup); CitiesViewModel citiesViewModel = new CitiesViewModel(); citiesViewModel.group = group; citiesViewModel.cities = cities; citiesViewModel.plans = group.Product.PlanProducts; return(View("/Views/Group/GroupDetailsView.cshtml", citiesViewModel)); }
public async Task <IActionResult> Create(int id) { var result = _context.Cities.Where(city => city.Country != null && city.Country.Id == id).ToList(); _logger.LogInformation("Юзер запросил создание города для страны у которой id == " + id); var citiesViewModel = new CitiesViewModel { SelectedCountry = _context.Countries.SingleOrDefault(x => x.Id == id), Cities = result }; _logger.LogInformation("Юзер запросил создание города для страны у которой id == " + id); return(View(citiesViewModel)); }
public async Task LoadCommand_SetsGroupsInCorrectOrder() { // arrange var cities = new[] { new CityModel { Id = 1, Name = "ACity" }, new CityModel { Id = 2, Name = "ACity2" }, new CityModel { Id = 3, Name = "CCity2" } }; var navigationsServiceMock = new Mock <IMvxNavigationService>(MockBehavior.Loose); var alertServiceMock = MockHelpers.CreateAlertService(); var citiesRepositoryMock = new Mock <ICitiesRepository>(MockBehavior.Loose); citiesRepositoryMock.Setup(mock => mock.GetAll()) .Returns(cities); var zipCodesRepositoryMock = new Mock <IZipCodesRepository>(MockBehavior.Loose); var viewModel = new CitiesViewModel( navigationsServiceMock.Object, alertServiceMock.Object, citiesRepositoryMock.Object, zipCodesRepositoryMock.Object ); // act await viewModel.LoadCommand.ExecuteAsync(); // assert Assert.AreEqual(1, viewModel.Items.First().First().Model.Id); Assert.AreEqual(2, viewModel.Items.First().Last().Model.Id); Assert.AreEqual(3, viewModel.Items.Last().First().Model.Id); }
public ActionResult GetRegulationGroup(int idPriceGroup) { ViewBag.breadcrumbViewModel = new BreadcrumbViewModel("Regulamentos", "fa-table", "Regulamento");; var group = Business.Groups.GetPriceGroup(idPriceGroup); var cities = Business.City.GetCities(idPriceGroup); var planregulations = Business.PlanRegulation.GetPlanRegulations(idPriceGroup); CitiesViewModel citiesViewModel = new CitiesViewModel { @group = @group, cities = cities, plans = @group.Product.PlanProducts }; return(View("/Views/Regulation/RegulationDetailsView.cshtml", planregulations.ToList())); }
async void GetCitiesList(object sender, EventArgs e) { CitiesViewModel cvm = MSProApp.Locator.CitiesVM; WaitLabel.IsVisible = true; GetCitiesListBtn.IsEnabled = false; await cvm.GetCitiesListThread(); CitiesToSelect.ItemsSource = cvm.ExitCities; SelectedCities.ItemsSource = cvm.SelectedCitiesList; TotalCitiesLabel.Text = AppStrings.TotalCities + " " + cvm.TotalCities.ToString(); TotalUnknownCitiesLabel.Text = AppStrings.TotalUnknownLocations + " " + cvm.NotSpecifiedListNum.ToString(); TotalExitRelaysLabel.Text = AppStrings.TotalExitRelays + " " + cvm.TotalExitRouters.ToString(); WaitLabel.IsVisible = false; GetCitiesListBtn.IsEnabled = true; }
public ActionResult Index() { SampleDBContext db = new SampleDBContext(); List <SelectListItem> listSelectListItem = new List <SelectListItem>(); foreach (City city in db.Cities) { listSelectListItem.Add(new SelectListItem { Text = city.Name, Value = city.ID.ToString(), Selected = city.IsSelected }); } CitiesViewModel citiesViewModel = new CitiesViewModel(); citiesViewModel.Cities = listSelectListItem; return(View(citiesViewModel)); }
public async Task <IActionResult> Create([Bind("Id, Name")] CitiesViewModel citiesViewModel) { if (ModelState.IsValid) { var cities = new City { Name = citiesViewModel.Name, Country = _context.Countries.SingleOrDefault(x => x.Id == citiesViewModel.Id) }; _context.Add(cities); await _context.SaveChangesAsync(); return(RedirectToAction("Index", "Countries")); } return(View(citiesViewModel)); }
void RemoveSelectedCity(object sender, EventArgs e) { if (SelectedCities.SelectedItem == null) { return; } if (CitiesToSelect.ItemsSource == null || ((List <string>)CitiesToSelect.ItemsSource).Count == 0) { DisplayAlert(AppStrings.Warning, AppStrings.GetCitiesFirst, AppStrings.OK); return; } CitiesViewModel cvm = MSProApp.Locator.CitiesVM; string Selected = SelectedCities.SelectedItem.ToString().Replace(" ", "|"); string[] Temp = Selected.Split('|'); string City = Temp[0]; cvm.RemoveSelectedCity(City); }
void ApplyCitiesList(object sender, EventArgs e) { if (CitiesToSelect.ItemsSource == null || ((List <string>)CitiesToSelect.ItemsSource).Count == 0) { DisplayAlert(AppStrings.Warning, AppStrings.GetCitiesFirst, AppStrings.OK); return; } CitiesViewModel cvm = MSProApp.Locator.CitiesVM; if (cvm.ApplySelectedCitiesList()) { DisplayAlert("Mask Surf Pro", AppStrings.CitiesSelected, AppStrings.OK); } else { DisplayAlert(AppStrings.Warning, AppStrings.CitiesNotSelected, AppStrings.OK); } SelectedCities.ItemsSource = cvm.SelectedCitiesList; }
public ViewModelLocator() { myNavigationService = new MyNavigationService(); appViewModel = new AppViewModel(myNavigationService); logInViewModel = new LogInViewModel(myNavigationService); menyuViewModel = new MenyuViewModel(myNavigationService); tripsViewModel = new TripsViewModel(myNavigationService); registrationViewModel = new RegistrationViewModel(myNavigationService); weatherViewModel = new WeatherViewModel(myNavigationService); ticketsPDFViewModel = new TicketsPDFViewModel(myNavigationService); citiesViewModel = new CitiesViewModel(myNavigationService); introViewModel = new IntroViewModel(myNavigationService); mapViewModel = new MapViewModel(myNavigationService); searchInfoViewModel = new SearchInfoViewModel(myNavigationService); ticketsViewModel = new TicketsViewModel(myNavigationService); myNavigationService.Register <LogInViewModel>(logInViewModel); myNavigationService.Register <MenyuViewModel>(menyuViewModel); myNavigationService.Register <TripsViewModel>(tripsViewModel); myNavigationService.Register <RegistrationViewModel>(registrationViewModel); myNavigationService.Register <WeatherViewModel>(weatherViewModel); myNavigationService.Register <TicketsPDFViewModel>(ticketsPDFViewModel); myNavigationService.Register <CitiesViewModel>(citiesViewModel); myNavigationService.Register <IntroViewModel>(introViewModel); myNavigationService.Register <MapViewModel>(mapViewModel); myNavigationService.Register <SearchInfoViewModel>(searchInfoViewModel); myNavigationService.Register <TicketsViewModel>(ticketsViewModel); //myNavigationService.Register("LogIn", logInViewModel); //myNavigationService.Register("Menyu", menyuViewModel); //myNavigationService.Register("Trips", tripsViewModel); //myNavigationService.Register("Registration", registrationViewModel); //myNavigationService.Navigate<LogInViewModel>(); myNavigationService.Navigate <IntroViewModel>(); //myNavigationService.Navigate<TicketsPDFViewModel>(); //myNavigationService.Navigate<TripsViewModel>(); //myNavigationService.Navigate("LogIn"); }
public async Task SelectCommand_CallsAlertService_OneZipCode_ZipCodeNotFound() { // arrange var navigationsServiceMock = new Mock <IMvxNavigationService>(MockBehavior.Loose); var alertServiceMock = MockHelpers.CreateAlertService(); var citiesRepositoryMock = new Mock <ICitiesRepository>(MockBehavior.Loose); citiesRepositoryMock.Setup(mock => mock.GetAll()) .Returns(new[] { new CityModel { Id = 1 } }); var zipCodesRepositoryMock = new Mock <IZipCodesRepository>(MockBehavior.Loose); zipCodesRepositoryMock.Setup(mock => mock.GetZipCodesCount(It.IsAny <int>())) .Returns(1); zipCodesRepositoryMock.Setup(mock => mock.GetFirstForCity(It.IsAny <int>())) .Returns <ZipCodeModel>(null); var viewModel = new CitiesViewModel( navigationsServiceMock.Object, alertServiceMock.Object, citiesRepositoryMock.Object, zipCodesRepositoryMock.Object ); // act await viewModel.LoadCommand.ExecuteAsync(); await viewModel.SelectCommand.ExecuteAsync(viewModel.Items.First().First()); // assert alertServiceMock.Verify(mock => mock.Alert( It.IsAny <string>(), It.IsAny <string>(), It.IsAny <string>(), It.IsAny <Action>() ), Times.Once()); }
public ActionResult Index() { SampleDBContext db = new SampleDBContext(); List<SelectListItem> listSelectListItems = new List<SelectListItem>(); foreach (City city in db.Cities) { SelectListItem selectList = new SelectListItem() { Text = city.Name, Value = city.ID.ToString(), Selected = city.IsSelected }; listSelectListItems.Add(selectList); } CitiesViewModel citiesViewModel = new CitiesViewModel() { Cities = listSelectListItems }; return View(citiesViewModel); }