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);
}
