public List <CityView> ViewCity() { List <CityView> citiesView = new List <CityView>(); SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM CityView ORDER BY CityName"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); CityView aNewCityView = null; while (reader.Read()) { string cityName = reader["CityName"].ToString(); string aboutCity = reader["About"].ToString(); int noOfDwellers = Convert.ToInt32(reader["NoOfdwellers"]); string location = reader["Location"].ToString(); string weather = reader["Weather"].ToString(); string country = reader["Country"].ToString(); string aboutCountry = reader["AboutCountry"].ToString(); aNewCityView = new CityView(country, aboutCountry, cityName, aboutCity, noOfDwellers, location, weather); citiesView.Add(aNewCityView); } connection.Close(); return(citiesView); }
private void CreateCity(int nameId) { _city = Game.AddCity(_player, nameId, _x, _y); if (_city != null) { if (_player.IsHuman) { // TODO fire-eggs not showing may lose side-effects //if (!Game.Animations) { CityView cityView = new CityView(_city, founded: true); cityView.Closed += CityFounded; cityView.Skipped += CityViewed; Common.AddScreen(cityView); return; } { CityManager cityManager = new CityManager(_city); cityManager.Closed += CityManagerClosed; Common.AddScreen(cityManager); return; } } if (_unit != null) { Game.DisbandUnit(_unit); } } Game.UpdateResources(_city.Tile); EndTask(); }
public List <CityView> GetAllInfoCity() { List <CityView> cities = new List <CityView>(); SqlConnection connection = new SqlConnection(connectionString); string query = "Select * from CityView ORDER BY CityName"; connection.Open(); SqlCommand command = new SqlCommand(query, connection); SqlDataReader reader = command.ExecuteReader(); CityView aNewCityView = null; while (reader.Read()) { string cityname = reader["CityName"].ToString(); int noOfDwellers = Convert.ToInt32(reader["NoOfdwellers"]); string country = reader["Country"].ToString(); aNewCityView = new CityView(); aNewCityView.CityName = cityname; aNewCityView.NoOfDwellers = noOfDwellers; aNewCityView.CountryName = country; cities.Add(aNewCityView); } connection.Close(); return(cities); }
void Awake() { if (Instance == null) { Instance = this; } }
public void Edit(CityView view) { City city = UnitOfWork.To <City>(view); UnitOfWork.Update(city); UnitOfWork.Commit(); }
private void MenuItemCity_Click(object sender, RoutedEventArgs e) { CityView view = new CityView(); view.Owner = this; view.Show(); }
//public IActionResult GetCities(string countryCode) //{ // CitySqlDAO dao = new CitySqlDAO(connectionString); // IList<City> cities = dao.GetCities(countryCode); // return View(cities); //} //public IActionResult GetCities(string countryCode, string district) //{ // CitySqlDAO dao = new CitySqlDAO(connectionString); // IList<City> cities = dao.GetCities(countryCode, district); // return View(cities); //} public IActionResult GetCities(CityView city) { CitySqlDAO dao = new CitySqlDAO(connectionString); IList <City> cities = dao.GetCities(city.CountryCode, city.district); return(View(cities)); }
public override void Run() { if (Human != _city.Owner) { Console.WriteLine($"{_city.Name} builds {(_improvement as ICivilopedia).Name}."); EndTask(); return; } IScreen cityView; if (!Settings.Animations) { cityView = new Newspaper(_city, new string[] { $"{_city.Name} builds", $"{(_improvement as ICivilopedia).Name}." }, showGovernment: false); } else if (_improvement is IBuilding) { cityView = new CityView(_city, production: (_improvement as IBuilding)); } else if (_improvement is IWonder) { cityView = new CityView(_city, production: (_improvement as IWonder)); } else { EndTask(); return; } cityView.Closed += ClosedCityView; Common.AddScreen(cityView); }
private void CityFounded(object sender, EventArgs args) { CityView cityView = new CityView(_city, firstView: true); cityView.Closed += CityViewed; Common.AddScreen(cityView); }
public List <CityView> GetAllCity() { connection.ConnectionString = connectionString; string query = "SELECT * FROM CityView"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <CityView> cityList = new List <CityView>(); while (reader.Read()) { CityView cityView = new CityView(); cityView.CityName = reader["CityName"].ToString(); cityView.CityAbout = reader["CityAbout"].ToString(); if (!reader["NoOfDwellers"].Equals(System.DBNull.Value)) { cityView.NoOfDwellers = reader.GetInt64(reader.GetOrdinal("NoOfDwellers")); } else { cityView.NoOfDwellers = 0; } cityView.Location = reader["Location"].ToString(); cityView.Weather = reader["Weather"].ToString(); cityView.CountryName = reader["CountryName"].ToString(); cityView.CountryAbout = reader["CountryAbout"].ToString(); cityList.Add(cityView); } reader.Close(); connection.Close(); return(cityList); }
internal List <CityView> SearchByCountryName(string countryName) { List <CityView> citiesView = new List <CityView>(); SqlConnection connection = new SqlConnection(connectionString); string query = "SELECT * FROM CityView WHERE Country LIKE '%' + @countryName + '%'"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Clear(); command.Parameters.Add("@countryName", SqlDbType.VarChar); command.Parameters["@countryName"].Value = countryName; connection.Open(); SqlDataReader reader = command.ExecuteReader(); CityView aNewCityView = null; while (reader.Read()) { string cityName = reader["CityName"].ToString(); string aboutCity = reader["About"].ToString(); int noOfDwellers = Convert.ToInt32(reader["NoOfdwellers"]); string location = reader["Location"].ToString(); string weather = reader["Weather"].ToString(); string country = reader["Country"].ToString(); string aboutCountry = reader["AboutCountry"].ToString(); aNewCityView = new CityView(country, aboutCountry, cityName, aboutCity, noOfDwellers, location, weather); citiesView.Add(aNewCityView); } connection.Close(); return(citiesView); }
public IActionResult GetForm() { CityView cityView = new CityView(); cityView.CountryCode = "USA"; return(View(cityView)); }
private Dictionary <Vector3, SimpleMapPlaceable> _placedBuildingDictionary; // A dict of all placed Object in the map. Used to avoid collisions. #endregion #region Constructors public BuildingManager() { _placedBuildingDictionary = new Dictionary <Vector3, SimpleMapPlaceable>(); _routeCreationView = Object.FindObjectOfType <TransportRouteCreationView>(); _productProcessorView = Object.FindObjectOfType <ProductProcessorView>(); _cityView = Object.FindObjectOfType <CityView>(); _storageContainerView = Object.FindObjectOfType <StorageContainerView>(); SimpleMapPlaceable.OnClickAction += OnPlaceableClick; }
public void Create(CityView view) { City city = UnitOfWork.To <City>(view); city.StateId = view.StateId; city.Name = view.Name; UnitOfWork.Insert(city); UnitOfWork.Commit(); }
public IActionResult Calendar(int skip = 0) => _authenticationProvider.SomeIfAdministrator(User).Map( administrator => { var now = DateTime.UtcNow; var nowMonth = new DateTime(now.Year, now.Month, 1); var month = nowMonth.AddMonths(-skip); var talks = _talkService.List(month, month.AddMonths(1), administrator.City); return((IActionResult)View(new TalkCalendarView(month, CityView.FromDomain(administrator.City), talks.Select(TalkView.FromDomain).ToArray()))); } ).ValueOr(() => RedirectToAction("Administrator", "Authentication"));
public void SelectValue(object sender, EventArgs e) { int[] rows = CityView.GetSelectedRows(); SelectedValue = Convert.ToInt32(CityView.GetRowCellValue(rows[0], "Id")); SelectedCode = CityView.GetRowCellValue(rows[0], "Name").ToString(); SelectedText = CityView.GetRowCellValue(rows[0], "Name").ToString(); Hide(); }
public void Get_ReturnsViewById() { CityView actual = service.Get <CityView>(city.Id); CityView expected = Mapper.Map <CityView>(city); Assert.Equal(expected.CreationDate, actual.CreationDate); Assert.Equal(expected.Id, actual.Id); Assert.True(false, "Not all properties tested"); }
public ActionResult Edit(CityView city) { if (!Validator.CanEdit(city)) { return(View(city)); } Service.Edit(city); return(RedirectIfAuthorized("Index")); }
public ActionResult Create([Bind(Exclude = "Id")] CityView city) { if (!Validator.CanCreate(city)) { return(View(city)); } Service.Create(city); return(RedirectIfAuthorized("Index")); }
private void CityView_Click(object sender, EventArgs e) { City city = (player.availableActions.First(a => a is InteractCity) as InteractCity).city; CityView cityView = new CityView(city, player, this); controller.Stop(); cityView.ShowDialog(); if (running) { controller.Start(); } }
public CitiesControllerTests() { validator = Substitute.For <ICityValidator>(); service = Substitute.For <ICityService>(); city = ObjectFactory.CreateCityView(); controller = Substitute.ForPartsOf <CitiesController>(validator, service); controller.ControllerContext = new ControllerContext { RouteData = new RouteData() }; }
private void GetFocusedRowData(int index) { if (index >= 0 && CityView.RowCount > 0) { CityView.FocusedRowHandle = index; btnSave.Enabled = false; btnAddNew.Enabled = btnModify.Enabled = true; txtCityCode.Text = CityView.GetRowCellValue(index, CityManager.CityDetails.CityCode.ToString()).ToString(); txtCityName.Text = CityView.GetRowCellValue(index, CityManager.CityDetails.CityName.ToString()).ToString(); cmbCountry.Text = CityView.GetRowCellValue(index, CityManager.CityDetails.CountryName.ToString()).ToString(); } }
public CityController(CityDatabase cityDatabase, CityView cityView, DayCounterController dayCounterController, HourController hourController, BuildingInfoBuyPanelPresenter buildingInfoBuyPanelPresenter) { _cityDatabase = cityDatabase; _cityView = cityView; _dayCounterController = dayCounterController; _hourController = hourController; _buildingInfoBuyPanelPresenter = buildingInfoBuyPanelPresenter; }
public void Create_City() { CityView view = ObjectFactory.CreateCityView(1); service.Create(view); City actual = context.Set <City>().AsNoTracking().Single(model => model.Id != city.Id); CityView expected = view; Assert.Equal(expected.CreationDate, actual.CreationDate); Assert.True(false, "Not all properties tested"); }
protected void btnSave_Click(object sender, EventArgs e) { if (Request.QueryString["action"] != null) { string shortSpelling = string.Empty; string spelling = string.Empty; int hotlevel = 0; if (!string.IsNullOrEmpty(this.txtShortSpelling.Text.Trim())) { shortSpelling = this.txtShortSpelling.Text.Trim(); } if (!string.IsNullOrEmpty(this.txtSpelling.Text.Trim())) { spelling = this.txtSpelling.Text.Trim(); } if (!string.IsNullOrEmpty(this.txtHotLevel.Text.Trim())) { hotlevel = int.Parse(this.txtHotLevel.Text.Trim()); } CityView cityView = new CityView() { Code = this.txtCityCode.Text.Trim(), Name = this.txtCityName.Text.Trim(), ProvinceCode = this.ddlProvinceName.SelectedValue, ShortSpelling = shortSpelling, Spelling = spelling, HotLevel = hotlevel }; if (Request.QueryString["action"].ToString() == "add") { try { FoundationService.AddCity(cityView, ""); RegisterScript("alert('添加成功!'); window.location.href='City.aspx'"); } catch (Exception ex) { ShowExceptionMessage(ex, "添加"); } } else { try { FoundationService.UpdateCity(cityView, ""); RegisterScript("alert('修改成功!'); window.location.href='City.aspx?Search=Back'"); } catch (Exception ex) { ShowExceptionMessage(ex, "修改"); } } } }
internal static City GetCity(CityView cityView) { if (null == cityView) { throw new ArgumentNullException("cityView"); } cityView.Validate(); return(new City(cityView.Code.Trim()) { ProvinceCode = StringUtility.Trim(cityView.ProvinceCode), Name = StringUtility.Trim(cityView.Name), Spelling = StringUtility.Trim(cityView.Spelling), ShortSpelling = StringUtility.Trim(cityView.ShortSpelling), HotLevel = cityView.HotLevel }); }
public void Edit_City() { CityView view = ObjectFactory.CreateCityView(city.Id); Assert.True(false, "No update made"); service.Edit(view); City actual = context.Set <City>().AsNoTracking().Single(); City expected = city; Assert.Equal(expected.CreationDate, actual.CreationDate); Assert.Equal(expected.Id, actual.Id); Assert.True(false, "Not all properties tested"); }
private CityView CreateCityView(Transform parent, MapView mapView, City city, string prefabName) { var unitPrefab = Resources.Load <CityView>(prefabName); if (unitPrefab == null) { Debug.LogError("Can't load unit " + prefabName); return(null); } CityView cityView = Instantiate(unitPrefab); cityView.gameObject.SetActive(true); cityView.transform.parent = parent; cityView.Init(city, mapView.CellCoordToPosition(city.Coordinate)); return(cityView); }
public static void AddCity(CityView cityView, string account) { var city = City.GetCity(cityView); if (QueryCity(city.Code) != null) { throw new ChinaPay.Core.Exception.KeyRepeatedException("代码[" + city.Code + "]已存在"); } var sameNameCity = QueryCityByName(city.Name); if (sameNameCity != null && sameNameCity.ProvinceCode == city.ProvinceCode) { throw new ChinaPay.Core.Exception.KeyRepeatedException("名称[" + city.Name + "]已存在"); } CityCollection.Instance.Add(city.Code, city); saveAddLog("市", city.ToString(), city.Code, account); }
public List <CityView> GetCityByCountryName(string countrySearchName) { connection.ConnectionString = connectionString; string query = "SELECT * FROM CityView WHERE (CountryName LIKE '%'+@countrySearchName+'%')"; SqlCommand command = new SqlCommand(query, connection); command.Parameters.Add("countrySearchName", SqlDbType.VarChar); command.Parameters["countrySearchName"].Value = countrySearchName; List <CityView> cityList = new List <CityView>(); connection.Open(); SqlDataReader reader = command.ExecuteReader(); CityView cityView = null; while (reader.Read()) { cityView = new CityView(); cityView.CityName = reader["CityName"].ToString(); cityView.CityAbout = reader["CityAbout"].ToString(); if (!reader["NoOfDwellers"].Equals(System.DBNull.Value)) { cityView.NoOfDwellers = reader.GetInt64(reader.GetOrdinal("NoOfDwellers")); } else { cityView.NoOfDwellers = 0; } cityView.Location = reader["Location"].ToString(); cityView.Weather = reader["Weather"].ToString(); cityView.CountryName = reader["CountryName"].ToString(); cityView.CountryAbout = reader["CountryAbout"].ToString(); cityList.Add(cityView); } reader.Close(); connection.Close(); return(cityList); }