public PostalAddressListViewModel GetPostalAddressList(Guid customerid) { if (customerid != Guid.Empty) { using (var context = new ApplicationDbContext()) { var postalAddresses = context.PostalAddresses.AsNoTracking() .Where(x => x.CustomerID == customerid) .OrderBy(x => x.PostalAddressID); if (postalAddresses != null) { var postalAddressListVm = new PostalAddressListViewModel(); foreach (var address in postalAddresses) { var postalAddressVm = new PostalAddressViewModel() { CustomerID = address.CustomerID.ToString("D"), PostalAddressID = address.PostalAddressID, StreetAddress1 = address.StreetAddress1, StreetAddress2 = address.StreetAddress2, City = address.City }; var regionsRepo = new RegionsRepository(); postalAddressVm.RegionNameEnglish = regionsRepo.GetRegionNameEnglish(address.RegionCode); var countryRepo = new CountriesRepository(); postalAddressVm.CountryNameEnglish = countryRepo.GetCountryNameEnglish(address.Iso3); postalAddressListVm.PostalAddresses.Add(postalAddressVm); } return(postalAddressListVm); } } } return(null); }
public void BindDDLs(PlaceView placeView, ObjectContext db) { //countries ddl ICountriesRepository countriesRepository = new CountriesRepository(db); placeView.Countries = new SelectList(countriesRepository.GetValid().OrderBy("Name ASC").ToList(), "CountryPK", "Name"); //counties ddl if (placeView.CountryFK != null) { ICountiesRepository countiesRepository = new CountiesRepository(db); placeView.Counties = new SelectList(countiesRepository.GetCountiesByCountry(Convert.ToInt32(placeView.CountryFK)).OrderBy("Name ASC"), "CountyPK", "Name"); } else { placeView.Counties = new SelectList(new List <County>(), "CountyPK", "Name"); } //postal offices ddl if (placeView.CountyFK != null) { IPostalOfficesRepository postalOfficesRepository = new PostalOfficesRepository(db); var postalOffices = postalOfficesRepository.GetValidByCounty(Convert.ToInt32(placeView.CountyFK)).OrderBy(c => c.Name); placeView.PostalOffices = new SelectList(postalOffices.Select(c => new { value = c.PostalOfficePK, text = c.Name + " (" + SqlFunctions.StringConvert((double)c.Number).Trim() + ")" }), "value", "text"); } else { placeView.PostalOffices = new SelectList(new List <PostalOffice>(), "PostalOfficePK", "Name"); } }
public PostalAddressViewModel GetPostalAddress(Guid customerid, int postaladdressid) { if (customerid != Guid.Empty) { using (var context = new ApplicationDbContext()) { var postalAddress = context.PostalAddresses.AsNoTracking() .Where(x => x.CustomerID == customerid && x.PostalAddressID == postaladdressid) .SingleOrDefault(); if (postalAddress != null) { var postalAddressVm = new PostalAddressViewModel() { CustomerID = postalAddress.CustomerID.ToString("D"), StreetAddress1 = postalAddress.StreetAddress1?.Trim(), StreetAddress2 = postalAddress.StreetAddress2?.Trim(), City = postalAddress.City?.Trim() }; var countriesRepo = new CountriesRepository(); postalAddressVm.CountryNameEnglish = countriesRepo.GetCountryNameEnglish(postalAddress.Iso3); var regionsRepo = new RegionsRepository(); postalAddressVm.RegionNameEnglish = regionsRepo.GetRegionNameEnglish(postalAddress.RegionCode); return(postalAddressVm); } } } return(null); }
public CustomerEditViewModel GetCustomer(Guid customerid) { if (customerid != Guid.Empty) { using (var context = new ApplicationDbContext()) { var customer = context.Customers.AsNoTracking() .Where(x => x.CustomerID == customerid) .SingleOrDefault(); if (customer != null) { var customerEditVm = new CustomerEditViewModel() { CustomerID = customer.CustomerID.ToString("D"), CustomerName = customer.CustomerName.Trim(), SelectedCountryIso3 = customer.CountryIso3, SelectedRegionCode = customer.RegionCode }; var countriesRepo = new CountriesRepository(); customerEditVm.Countries = countriesRepo.GetCountries(); var regionsRepo = new RegionsRepository(); customerEditVm.Regions = regionsRepo.GetRegions(customer.CountryIso3); return(customerEditVm); } } } return(null); }
public PostalAddressEditViewModel SavePostalAddress(PostalAddressEditViewModel model) { if (model != null && Guid.TryParse(model.CustomerID, out Guid customerid)) { using (var context = new ApplicationDbContext()) { var postalAddress = new PostalAddress() { CustomerID = customerid, StreetAddress1 = model.StreetAddress1?.Trim(), StreetAddress2 = model.StreetAddress2?.Trim(), City = model.City?.Trim(), PostalCode = model.PostalCode, RegionCode = model.SelectedRegionCode, Iso3 = model.SelectedCountryIso3 }; postalAddress.Region = context.Regions.Find(postalAddress.RegionCode); postalAddress.Country = context.Countries.Find(postalAddress.Iso3); context.PostalAddresses.Add(postalAddress); context.SaveChanges(); var countriesRepo = new CountriesRepository(); model.Countries = countriesRepo.GetCountries(); var regionsRepo = new RegionsRepository(); model.Regions = regionsRepo.GetRegions(model.SelectedCountryIso3); return(model); } } return(null); }
public void CRUD() { ICountriesRepository repository = new CountriesRepository("Assets/countries.xml"); Assert.NotNull(repository); RetrieveByKey(repository); }
//Returnerar lista med länder public List <Country> getInfoOnSelectedCountry() { var c = new CountriesRepository(); var count = c.GetAllCountries(); return(count); }
public static void TestFixtureSetup(TestContext context) { con = new NpgsqlConnection(cs); con.Open(); regionsRepository = new RegionsRepository(con); countriesRepository = new CountriesRepository(con); manufacturersRepository = new ManufacturersRepository(con); manufacturerValidation = new ManufacturerValidation(con); carsRepository = new CarsRepository(con); regionsRepository.Save(Region1); regionsRepository.Save(Region2); regionsRepository.Save(Region3); regionsRepository.Flush(); countriesRepository.Save(Country1); countriesRepository.Save(Country2); countriesRepository.Save(Country3); countriesRepository.Flush(); manufacturersRepository.Save(Manufacturer1); manufacturersRepository.Save(Manufacturer2); manufacturersRepository.Save(Manufacturer3); manufacturersRepository.Flush(); carsRepository.SaveAndFlush(Car2); }
public List <Country> GetCountries() { var rept = new CountriesRepository(); var hej = rept.GetAllCountries(); return(hej); }
[TestInitialize] public override void TestInitialize() { base.TestInitialize(); repository = new CountriesRepository(db); controller = "countries"; detailsViewCaption = "Country"; }
public static void TestFixtureSetup(TestContext context) { con = new NpgsqlConnection(cs); con.Open(); regionsRepository = new RegionsRepository(con); countriesRepository = new CountriesRepository(con); manufacturersRepository = new ManufacturersRepository(con); manufacturersService = new ManufacturersService(con); regionsRepository.Save(Region1); regionsRepository.Save(Region2); regionsRepository.Save(Region3); regionsRepository.Flush(); countriesRepository.Save(Country1); countriesRepository.Save(Country2); countriesRepository.Save(Country3); countriesRepository.Save(Country4); countriesRepository.Save(Country5); countriesRepository.Flush(); manufacturersRepository.Save(Manufacturer1); manufacturersRepository.Save(Manufacturer2); manufacturersRepository.Save(Manufacturer3); manufacturersRepository.Save(Manufacturer4); manufacturersRepository.Save(Manufacturer5); manufacturersRepository.Save(Manufacturer6); manufacturersRepository.Save(Manufacturer7); manufacturersRepository.Save(Manufacturer8); manufacturersRepository.Save(Manufacturer9); manufacturersRepository.Flush(); }
public ActionResult AddressTypePartial(AddressTypeViewModel model) { if (ModelState.IsValid && !String.IsNullOrWhiteSpace(model.CustomerID)) { switch (model.SelectedAddressType) { case "Email": var emailAddressModel = new EmailAddressViewModel() { CustomerID = model.CustomerID }; return(PartialView("CreateEmailAddressPartial", emailAddressModel)); case "Postal": var postalAddressModel = new PostalAddressEditViewModel() { CustomerID = model.CustomerID }; var countriesRepo = new CountriesRepository(); postalAddressModel.Countries = countriesRepo.GetCountries(); var regionsRepo = new RegionsRepository(); postalAddressModel.Regions = regionsRepo.GetRegions(); return(PartialView("CreatePostalAddressPartial", postalAddressModel)); default: return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } } return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); }
public static void ReceiveRequest() { SevenWondersContext db = new SevenWondersContext(); CountriesRepository countriesRepository = new CountriesRepository(db); var factory = new ConnectionFactory() { HostName = "localhost" }; factory.Protocol = Protocols.DefaultProtocol; factory.Port = AmqpTcpEndpoint.UseDefaultPort; using (var connection = factory.CreateConnection()) using (var channel = connection.CreateModel()) { channel.QueueDeclare(queue: "rpc_queue", durable: false, exclusive: false, autoDelete: false, arguments: null); channel.BasicQos(0, 1, false); var consumer = new EventingBasicConsumer(channel); channel.BasicConsume(queue: "rpc_queue", autoAck: false, consumer: consumer); Console.WriteLine(" [x] Awaiting RPC requests"); consumer.Received += (model, ea) => { string response = null; var body = ea.Body; var props = ea.BasicProperties; var replyProps = channel.CreateBasicProperties(); replyProps.CorrelationId = props.CorrelationId; try { var countries = countriesRepository.GetCountries(); var json = JsonConvert.SerializeObject(countries); response = json; } catch (Exception e) { Console.WriteLine(" [.] " + e.Message); response = ""; } finally { var responseBytes = Encoding.UTF8.GetBytes(response); channel.BasicPublish(exchange: "", routingKey: props.ReplyTo, basicProperties: replyProps, body: responseBytes); channel.BasicAck(deliveryTag: ea.DeliveryTag, multiple: false); } }; Console.WriteLine(" Press [enter] to exit."); Console.ReadLine(); } }
public void GetAllCountries() { using (var db = new ExampleContext(Connection)) { ICountriesRepository repository = new CountriesRepository(db); var countries = repository.GetAll(); Assert.That(countries.Count(), Is.EqualTo(3)); } }
public static void TestFixtureSetup(TestContext context) { con = new NpgsqlConnection(cs); con.Open(); regionsRepository = new RegionsRepository(con); countriesRepository = new CountriesRepository(con); manufacturersRepository = new ManufacturersRepository(con); carsRepository = new CarsRepository(con); carValidation = new CarValidation(con); ownerCarsRepository = new OwnerCarsRepository(con); ownersRepository = new OwnersRepository(con); regionsRepository.Save(Region1); regionsRepository.Save(Region2); regionsRepository.Save(Region3); regionsRepository.Flush(); countriesRepository.Save(Country1); countriesRepository.Save(Country2); countriesRepository.Save(Country3); countriesRepository.Save(Country4); countriesRepository.Save(Country5); countriesRepository.Flush(); manufacturersRepository.Save(Manufacturer1); manufacturersRepository.Save(Manufacturer2); manufacturersRepository.Save(Manufacturer3); manufacturersRepository.Save(Manufacturer4); manufacturersRepository.Save(Manufacturer5); manufacturersRepository.Save(Manufacturer6); manufacturersRepository.Save(Manufacturer7); manufacturersRepository.Save(Manufacturer8); manufacturersRepository.Save(Manufacturer9); manufacturersRepository.Flush(); carsRepository.Save(Car1); carsRepository.Save(Car2); carsRepository.Save(Car3); carsRepository.Save(Car4); carsRepository.Save(Car5); carsRepository.Save(Car6); carsRepository.Save(Car7); carsRepository.Save(Car8); carsRepository.Save(Car9); carsRepository.Save(Car10); carsRepository.Save(Car11); carsRepository.Save(Car12); carsRepository.Save(Car13); carsRepository.Save(Car14); carsRepository.Save(Car15); carsRepository.Flush(); ownersRepository.SaveAndFlush(Owner2); ownerCarsRepository.SaveAndFlush(OwnerCar2); }
public RegistrationViewModel(ApplicationManager appManager) { _appManager = appManager; _countriesRepository = new CountriesRepository(); SelectedCountry = Countries.First(); SelectedSex = Sexes.First(); SelectedAge = Ages.First(); }
public UnitOfWork(TransaviaDbContext ctx, IEventDispatcher eventDispatcher) { _ctx = ctx; _eventDispatcher = eventDispatcher; AirportTypes = new AirportTypesRepository(ctx, eventDispatcher); AirportStatuses = new AirportStatusesRepository(ctx, eventDispatcher); AirportSizes = new AirportSizesRepository(ctx, eventDispatcher); Countries = new CountriesRepository(ctx, eventDispatcher); Continents = new ContinentsRepository(ctx, eventDispatcher); Airports = new AirportsRepository(ctx, eventDispatcher); }
public MainWindow() { InitializeComponent(); PopulateCurrencyData(); PopulateListViewUsers(); PupulateListViewCountries(); localHandeler.SaveCountriesfromDBtoXML(); TbTotalKm.IsReadOnly = true; tbUserID.IsEnabled = false; tbUsername.IsEnabled = false; tbBoss.IsEnabled = false; notesLoading = notesHandler.LoadNotes("Notes.xml"); tbNotes.Text = notesLoading.Note; var rep = new CountriesRepository(); main = this; var hej = rep.GetAllCountries(); foreach(var x in hej) { CbCountries.Items.Add(x.Name); } try { _reportDraftLoading = reportHandler.LoadDraft("DraftReport.xml"); TbTotalKm.Text = _reportDraftLoading.NumberOfKilometersDrivenInTotal.ToString(); TbCarTripLengthKm.Text = _reportDraftLoading.KilometersDriven.ToString(); tbDoneOnTrip.Text = _reportDraftLoading.Description; dpStartDate.Text = _reportDraftLoading.StartDate; dpEndDate.Text = _reportDraftLoading.EndDate; foreach (var kvitto in _reportDraftLoading.imagePathsList) { listBoxReceipts.Items.Add(kvitto); } foreach (var dayinfo in _reportDraftLoading.daysSpentInCountry) { listBoxDays.Items.Add(dayinfo); } } catch { MessageBox.Show("Det finns inget sparat utkast att ladda"); } }
public CustomerEditViewModel CreateCustomer() { var cRepo = new CountriesRepository(); var rRepo = new RegionsRepository(); var customer = new CustomerEditViewModel() { CustomerID = Guid.NewGuid().ToString(), Countries = cRepo.GetCountries(), Regions = rRepo.GetRegions() }; return(customer); }
// GET: api/Countries public IEnumerable<Country> Get() { var countries = new List<Country>(); var db = new CountriesRepository(); for (int i = 1; i <= MaxCountryId; i++) { countries.Add(GetCountry(db, i)); } return countries; // return new string[] { "value1", "value2" }; }
public static void TestFixtureSetup(TestContext context) { con = new NpgsqlConnection(cs); con.Open(); regionsRepository = new RegionsRepository(con); countriesRepository = new CountriesRepository(con); regionsRepository.Save(Region1); regionsRepository.Save(Region2); regionsRepository.Save(Region3); regionsRepository.Flush(); }
public void Should_return_supported_countries() { var listOfSupportCountries = new List<Country>() { new Country { Name = "Canada" }, new Country { Name = "Mexico"}, new Country { Name = "United States" } }; var listOfCountries = new CountriesRepository().GetAll(); foreach(var cntry in listOfSupportCountries) { var exists = listOfCountries.Exists( c => c.Name == cntry.Name); Assert.IsTrue(exists); } }
public TerritoryRegionCountryServices() { if (territoriesRepository == null) { territoriesRepository = new TerritoriesRepository(); } if (regionsRepository == null) { regionsRepository = new RegionsRepository(); } if (countriesRepository == null) { countriesRepository = new CountriesRepository(); } }
private static void CountriesWork() { while (true) { Console.WriteLine("Выберите действие\n1 - Посмотреть страны\n2 - Добавить страну\n3 - Редактировать страну\n4 - Удалить страну"); int answer = int.Parse(Console.ReadLine()); switch (answer) { case 1: using (var repository = new CountriesRepository()) { var countries = repository.Select(); foreach (var country in countries) { Console.WriteLine($"{country.Name} - {country.Population} человек"); } } break; case 2: using (var repository = new CountriesRepository()) { var newCountry = new Country(); while (newCountry.Name == null || newCountry.Name == string.Empty) { Console.Write("Введите название: "); newCountry.Name = Console.ReadLine(); } while (newCountry.Population < 0) { Console.Write("Введите численность населения: "); newCountry.Population = int.Parse(Console.ReadLine()); } newCountry.CreationDate = DateTime.Now; repository.Insert(newCountry); } break; case 3: break; case 4: break; default: Console.WriteLine("Нет такого варианта"); break; } } }
public ActionResult Index() { ICountiesRepository countiesRepository = new CountiesRepository(db); ICountriesRepository countriesRepository = new CountriesRepository(db); IPostalOfficesRepository postalOfficesRepository = new PostalOfficesRepository(db); IPlacesRepository placesRepository = new PlacesRepository(db); int page = !String.IsNullOrWhiteSpace(Request.QueryString["page"]) ? Convert.ToInt32(Request.QueryString["page"]) : 1; int pageSize = !String.IsNullOrWhiteSpace(Request.QueryString["pageSize"]) ? Convert.ToInt32(Request.QueryString["pageSize"]) : Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ResultsPerPage"]); string sortOrder = !String.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC"; string sortColumn = !String.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "PlacePK"; string ordering = sortColumn + " " + sortOrder; ordering = ordering.Trim(); IQueryable <PlaceView> places = PlaceView.GetPlaceView(placesRepository.GetValid(), postalOfficesRepository.GetValid(), countiesRepository.GetValid(), countriesRepository.GetValid()) .OrderBy(ordering); if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"])) { string searchString = Request.QueryString["searchString"].ToString(); places = places.Where(c => c.Name.Contains(searchString)); } places = places.Page(page, pageSize); if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"])) { string searchString = Request.QueryString["searchString"].ToString(); ViewData["numberOfRecords"] = placesRepository.GetValid().Where(c => c.Name.Contains(searchString)).Count(); } else { ViewData["numberOfRecords"] = placesRepository.GetValid().Count(); } int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize; if (page > numberOfPages) { string url = LinkHelper.getQueryStringArray(new string[] { "page" }); return(Redirect("Place?" + url + "page=" + numberOfPages)); } else { return(View("Index", places.ToList())); } }
public void uppdateCountry(string currname, string newname, string newcurr, int newsub) { var countryrep = new CountriesRepository(); var list = countryrep.GetAllCountries(); var cid = 1; foreach (var c in list) { if (c.Name == currname) { cid = c.CID; } } CountriesRepository.UpdateCountry(cid, newname, newcurr, newsub); }
public ActionResult Delete(int?countryPK) { ICountriesRepository countriesRepository = new CountriesRepository(db); if (countryPK != null) { Country country = countriesRepository.GetCountryByPK((int)countryPK); country.Deleted = true; countriesRepository.SaveChanges(); TempData["message"] = LayoutHelper.GetMessage("DELETE", country.CountryPK); } return(Redirect(Request.UrlReferrer.AbsoluteUri)); }
public void BindDDLs(LegalEntityBranchView legalEntityBranchView, ObjectContext db) { //countries ddl ICountriesRepository countriesRepository = new CountriesRepository(db); legalEntityBranchView.Countries = new SelectList(countriesRepository.GetValid().OrderBy("Name ASC").ToList(), "CountryPK", "Name"); //counties ddl ICountiesRepository countiesRepository = new CountiesRepository(db); legalEntityBranchView.Counties = new SelectList(countiesRepository.GetCountiesByCountry((int)legalEntityBranchView.CountryFK).OrderBy("Name ASC").ToList(), "CountyPK", "Name"); //citiesCommunities dll if (legalEntityBranchView.CountyFK != null) { ICitiesCommunitiesRepository citiesCommunitiesRepository = new CitiesCommunitiesRepository(db); legalEntityBranchView.CitiesCommunities = new SelectList(citiesCommunitiesRepository.GetCitiesCommunitiesByCounty(Convert.ToInt32(legalEntityBranchView.CountyFK)).OrderBy("Name ASC"), "CityCommunityPK", "Name", legalEntityBranchView.CityCommunityFK); } else { legalEntityBranchView.CitiesCommunities = new SelectList(new List <CityCommunity>(), "CityCommunityPK", "Name"); } //postal offices dll if (legalEntityBranchView.CountyFK != null) { IPostalOfficesRepository postalOfficesRepository = new PostalOfficesRepository(db); legalEntityBranchView.PostalOffices = new SelectList(postalOfficesRepository.GetValidByCounty(Convert.ToInt32(legalEntityBranchView.CountyFK)).OrderBy("Name ASC"), "PostalOfficePK", "Name", legalEntityBranchView.PostalOfficeFK); } else { legalEntityBranchView.PostalOffices = new SelectList(new List <PostalOffice>(), "PostalOfficePK", "Name"); } //places dll if (legalEntityBranchView.PostalOfficeFK != null) { IPlacesRepository placesRepository = new PlacesRepository(db); legalEntityBranchView.Places = new SelectList(placesRepository.GetPlacesByPostalOffice(Convert.ToInt32(legalEntityBranchView.PostalOfficeFK)).OrderBy("Name ASC"), "PlacePK", "Name", legalEntityBranchView.PlaceFK); } else { legalEntityBranchView.Places = new SelectList(new List <Place>(), "PlacePK", "Name"); } }
public void BindDDLs(CityCommunityView cityCommunityView, ObjectContext db) { //countries ddl ICountriesRepository countriesRepository = new CountriesRepository(db); cityCommunityView.Countries = new SelectList(countriesRepository.GetValid().OrderBy("Name ASC").ToList(), "CountryPK", "Name"); //counties ddl if (cityCommunityView.CountryFK != null) { ICountiesRepository countiesRepository = new CountiesRepository(db); cityCommunityView.Counties = new SelectList(countiesRepository.GetCountiesByCountry(Convert.ToInt32((int)cityCommunityView.CountryFK)).OrderBy("Name ASC"), "CountyPK", "Name"); } else { cityCommunityView.Counties = new SelectList(new List <County>(), "CountyPK", "Name"); } }
public ActionResult Edit(int?countryPK) { if (countryPK != null) { ICountriesRepository countriesRepository = new CountriesRepository(db); Country country = countriesRepository.GetCountryByPK((int)countryPK); CountryView countryView = new CountryView(); countryView.ConvertFrom(country, countryView); return(View(countryView)); } else { return(RedirectToAction("Index", "Country")); } }
public UnitOfWork(DataContext context) { _context = context; Users = new UsersRepository(_context); Photos = new PhotosRepository(_context); Groups = new GroupsRepository(_context); Memberships = new MembershipsRepository(_context); Auths = new AuthRepository(_context); Comments = new CommentsRepository(_context); Achievements = new AchievementsRepository(_context); Cities = new CitiesRepository(_context); Countries = new CountriesRepository(_context); Locations = new LocationsRepository(_context); Matchdays = new MatchdaysRepository(_context); MatchStatuses = new MatchStatusesRepository(_context); Friends = new FriendsRepository(_context); Messages = new MessagesRepository(_context); Chats = new ChatsRepository(_context); }
private Country GetCountry(CountriesRepository db, int id) { var country = db.Countries.Where(x => x.CountryId == id).FirstOrDefault(); if (country == null) return new Country { Name = "NOT_FOUND", Name_nl = "NOT_FOUND", Region = "", SubRegion = "", Code = "", ShowSubRegion = false, DifficultyLevel = 0 }; return new Country { Id = country.CountryId.ToString(), Name = country.Name, Name_nl = country.Name_nl, Region = country.Region, SubRegion = country.SubRegion, Code = country.Code, ShowSubRegion = country.ShowSubRegion, DifficultyLevel = country.DifficultyLevel }; }
public ActionResult Edit(CountryView countryView) { if (ModelState.IsValid) { ICountriesRepository countriesRepository = new CountriesRepository(db); Country country = countriesRepository.GetCountryByPK((int)countryView.CountryPK); countryView.ConvertTo(countryView, country); countriesRepository.SaveChanges(); TempData["message"] = LayoutHelper.GetMessage("UPDATE", country.CountryPK); return(RedirectToAction("Index", "Country")); } else { return(View(countryView)); } }
public QuestionCountryViewModel Get(int difficultyLevel, string excludeList) { var excludeCountries = new List<int>(); if (excludeList != null) { string[] ar = excludeList.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); foreach (var item in ar) { excludeCountries.Add(int.Parse(item)); } } // ToDo: Take excludeList into account. var db = new CountriesRepository(); var countries = db.Countries.Where(x => x.DifficultyLevel == difficultyLevel).ToArray(); Random random = new Random(); List<int> answers = new List<int>(); // Get answer to question var cntry = GetRandomUniqueCountry(random, countries, excludeCountries, true); var answerId = cntry.CountryId; answers.Add(answerId); var region = cntry.Region; var subRegion = cntry.SubRegion; // Try to get 4 answers from the same region var countriesSameSubRegion = db.Countries.Where(x => x.Region == region && x.SubRegion == subRegion).ToArray(); if (countriesSameSubRegion.Length <= 4) { foreach (var c in countriesSameSubRegion) { if (c.CountryId != answerId) answers.Add(c.CountryId); } } else { for (int i = 0; i < 4; i++) { var country = GetRandomUniqueCountry(random, countriesSameSubRegion, answers); if (country != null) { answers.Add(country.CountryId); } } } // Get other multiple choice answers var allCountries = db.Countries.ToArray(); var answerCount = NumberOfChoices - answers.Count; int y= 0; while (y < answerCount) { var country = GetRandomUniqueCountry(random, allCountries, answers); if (country != null) { answers.Add(country.CountryId); y++; } } var questionCountries = GetCountries(answers); var shuffeledCountries = GetShuffeledCountries(random, questionCountries); return new QuestionCountryViewModel() { Answer = questionCountries[0], Choices = shuffeledCountries }; }
/// <summary> /// /// </summary> /// <param name="id">Answer to the question</param> /// <param name="count">Random other answers</param> /// <returns></returns> private Country[] GetCountries(List<int> ids) { var countries = new Country[ids.Count]; var db = new CountriesRepository(); int i = 0; foreach (var id in ids) { countries[i] = GetCountry(db, id); i++; } return countries; }
// GET: api/Countries/5 public Country Get(int id) { var db = new CountriesRepository(); return GetCountry(db, id); }