public CreateCharCityGump(byte profession) : base(0, 0) { _selectedProfession = profession; var loginScene = CUOEnviroment.Client.GetScene <LoginScene>(); _maps = loginScene.Cities.GroupBy(city => city.Map) .ToDictionary(group => group.Key, group => new CityCollection(_mapInfo[group.Key], group.ToArray()) { X = 57, Y = 49, OnSelect = SelectCity } ); SelectedMapIndex = UOFileManager.ClientVersion >= ClientVersions.CV_70130 ? 0 : 3; if (_selectedMap.SkipSection) { SelectCity(_selectedMap.FirstOrDefault()); OnButtonClick((int)Buttons.Finish); Dispose(); return; } //why we make calculations on program if it could be done outside? var mapCenterX = 253; //393 / 2 + 57; Add(new Button((int)Buttons.PreviousCollection, 0x15A1, 0x15A3, 0x15A2) { X = mapCenterX - 65, Y = 440, ButtonAction = ButtonAction.Activate }); Add(new Button((int)Buttons.NextCollection, 0x15A4, 0x15A6, 0x15A5) { X = mapCenterX + 50, Y = 440, ButtonAction = ButtonAction.Activate }); Add(new Button((int)Buttons.PreviousScreen, 0x15A1, 0x15A3, 0x15A2) { X = 586, Y = 435, ButtonAction = ButtonAction.Activate }); Add(new Button((int)Buttons.Finish, 0x15A4, 0x15A6, 0x15A5) { X = 610, Y = 435, ButtonAction = ButtonAction.Activate }); }
public void Open(string guid, string kladr) { connection.ConnectionString = ConnectionString; connection.Open(); CustomReloadCollection(RegionCollection, FiasSql.RegionSql, null); var searchResult = new Dictionary <string, string>(); using (var transaction = connection.BeginTransaction()) { using (var query = new DbQuery(connection, transaction)) { query.SqlText = "select ID_REGION, ID_AUTO, ID_AREA, ID_CITY, ID_CTAR, ID_PLACE, ID_STREET, ID_HOUSE from PR_FIAS_EXTRACT(@ID_GUID, @ID_KLADR)"; query.Parameters.Add(query.GetNewParameter("ID_GUID", guid == string.Empty ? null : guid)); query.Parameters.Add(query.GetNewParameter("ID_KLADR", kladr == string.Empty ? null : kladr)); query.ExecuteDataReader(); if (query.DataReader.Read()) { for (var i = 0; i < query.DataReader.FieldCount; i++) { searchResult.Add(query.DataReader.GetName(i), query.DataReader[i].ToString()); } } } } if (searchResult.Count == 0) { return; } if (searchResult["ID_REGION"] != string.Empty) { SelectedRegion = RegionCollection.FirstOrDefault(a => a.Id == searchResult["ID_REGION"]); } if (searchResult["ID_AUTO"] != string.Empty) { SelectedAuto = AutoCollection.FirstOrDefault(a => a.Id == searchResult["ID_AUTO"]); } if (searchResult["ID_AREA"] != string.Empty) { SelectedArea = AreaCollection.FirstOrDefault(a => a.Id == searchResult["ID_AREA"]); } if (searchResult["ID_CITY"] != string.Empty) { SelectedCity = CityCollection.FirstOrDefault(a => a.Id == searchResult["ID_CITY"]); } if (searchResult["ID_CTAR"] != string.Empty) { SelectedCtar = CtarCollection.FirstOrDefault(a => a.Id == searchResult["ID_CTAR"]); } if (searchResult["ID_PLACE"] != string.Empty) { SelectedPlace = PlaceCollection.FirstOrDefault(a => a.Id == searchResult["ID_PLACE"]); } if (searchResult["ID_STREET"] != string.Empty) { SelectedStreet = StreetCollection.FirstOrDefault(a => a.Id == searchResult["ID_STREET"]); } if (searchResult["ID_HOUSE"] != string.Empty) { SelectedHouse = HouseCollection.FirstOrDefault(a => a.Id == searchResult["ID_HOUSE"]); } }