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