public void setRLocation(LocationConnection locationConnection) { GameData gameData = GameManager.Instance.GameData; this.locationConnection = locationConnection; if (!String.IsNullOrEmpty(locationConnection.Label)) { Text.text = locationConnection.Label; } else { Text.text = locationConnection.TargetLocation.Label.Text(gameData); } RawImage.texture = locationConnection.Texture; Button.onClick.RemoveAllListeners(); if (locationConnection.TargetLocation.isOpen()) { Button.onClick.AddListener(() => locationConnection.execute()); } else { Button.interactable = false; } }
public string UpdateEvent(int eventId, string name, DateTime eventdate, string addressStreetName, string addressStreetNumber, string addressPostalCode, string location, string phone, string email, string city, string countryCode, Boolean official) { string sql = ""; DataSet drA = null; DataSet drL = null; LocationConnection locationConnection = new LocationConnection(); sql = "select location_id from events where id = '" + eventId + "'; "; drL = this.Query(sql); int locationId = int.Parse(drL.Tables[0].Rows[0][0].ToString()); // getting the location_address id sql = "select address_id from locations where id = '" + locationId + "'; "; drA = this.Query(sql); int addressId = int.Parse(drA.Tables[0].Rows[0][0].ToString()); this._UpdateEvent(eventId, name, eventdate, official, locationId); locationConnection.UpdateLocation(locationId, location, phone, email, addressId); AddressConnection addConn = new AddressConnection(); addConn.UpdateAddress(addressId, addressStreetName, addressStreetNumber, city, addressPostalCode, countryCode); return ""; }
public LocationButton(LocationConnection locationConnection) : this() { Image.Source = locationConnection.Texture; TextDestinationLabel.Text = locationConnection.Label; TextDuration.Text = locationConnection.Duration.ToString(); Button.IsEnabled = locationConnection.IsEnabled(); Button.Click += delegate { locationConnection.execute(); GameManager.Instance.Update(); }; }
public static CommandsCollection GotoCommandsList(LocationConnection locationConnection) { var result = new CommandsCollection(); if (locationConnection.interruptible) { result.Add(new CommandInterrupt(locationConnection.Type)); } result.Add(new CommandTimePass(locationConnection.Duration.GetValueOrDefault(0))); result.Add(new CommandGotoLocation(locationConnection.TargetLocation)); return(result); }
public string InsertNewEvent(string name, DateTime eventdate, string addressStreetName, string addressStreetNumber, string addressPostalCode, string location, string phone, string email, string city , string countryCode, Boolean official) { AddressConnection addConn = new AddressConnection(); string addressId = addConn.InsertNewAddress(addressStreetName, addressStreetNumber, city, addressPostalCode, countryCode); LocationConnection locationConnection = new LocationConnection(); string locationId = locationConnection.InsertNewLocation(location, phone, email, "" + addressId); string eventId = this._InsertEvent(name, eventdate, official , locationId); return eventId; }
private static List <LocationConnection> LocationConnections(GameLocation from) { var connections = new List <LocationConnection>(); foreach (Warp warp in from.warps) { GameLocation targetLoc = Game1.getLocationFromName(warp.TargetName); if (targetLoc != null) { var lc = new LocationConnection(warp.TargetName, warp.X, warp.Y, false, targetLoc.IsOutdoors); connections.Add(lc); } } foreach (var doorDict in from.doors) { foreach (var door in doorDict) { Point point = door.Key; string locName = door.Value; GameLocation targetLoc = Game1.getLocationFromName(locName); if (targetLoc != null) { var lc = new LocationConnection(locName, point.X, point.Y, true, targetLoc.IsOutdoors); connections.Add(lc); } } } if (from is StardewValley.Locations.BuildableGameLocation) { StardewValley.Locations.BuildableGameLocation bl = from as StardewValley.Locations.BuildableGameLocation; foreach (var b in bl.buildings) { if (b.indoors.Value != null) { var point = b.humanDoor.Value; var locName = b.indoors.Value.NameOrUniqueName; var lc = new LocationConnection(locName, point.X + b.tileX.Value, point.Y + b.tileY.Value, true, false); connections.Add(lc); } ; } } return(connections); }
private void eSuggestionList_SelectionChanged(object sender, SelectionChangedEventArgs e) { int country_position = 0; int city_position = 0; int index; int location_id; int address_id; addressConnection = new AddressConnection(); locationConnection = new LocationConnection(); DataSet dsA; DataSet dsL; if (eSuggestionList.ItemsSource != null) { eSuggestionList.Visibility = System.Windows.Visibility.Collapsed; eventName.TextChanged -= new TextChangedEventHandler(eventName_TextChanged); index = eSuggestionList.SelectedIndex; if (eSuggestionList.SelectedIndex != -1) { ListData item = (ListData)eSuggestionList.SelectedItem; _eventId = item.id; location_id = int.Parse(filteredEvents.Tables[0].Rows[index][4].ToString()); this.eventName.Text = filteredEvents.Tables[0].Rows[index][1].ToString(); this.eventDate.SelectedDate = (DateTime)filteredEvents.Tables[0].Rows[index][2]; this.eventOfficial.IsChecked = (Boolean)filteredEvents.Tables[0].Rows[index][3]; dsL = locationConnection.getLocation(location_id); this.eventLocation.Text = dsL.Tables[0].Rows[0][1].ToString(); this.eventPhone.Text = dsL.Tables[0].Rows[0][2].ToString(); this.eventEmail.Text = dsL.Tables[0].Rows[0][3].ToString(); address_id = int.Parse(dsL.Tables[0].Rows[0][4].ToString()); dsA = addressConnection.getAddress(address_id); this.eventAddress.Text = dsA.Tables[0].Rows[0][1].ToString(); this.eventAddressNum.Text = dsA.Tables[0].Rows[0][2].ToString(); this.eventTK.Text = dsA.Tables[0].Rows[0][4].ToString(); string eventCity = dsA.Tables[0].Rows[0][3].ToString(); int ix = dsA.Tables[0].Columns.Count; string eventCountry = dsA.Tables[0].Rows[0][5].ToString(); // //the fix for the country selection error // CountryConnection countryconn = new CountryConnection(); DataSet countriname = countryconn.getCountryNameByCode(eventCountry); eventCountry = countriname.Tables[0].Rows[0][0].ToString(); for (int i = 0; i < this.cmbECountryChooses.Items.Count; i++) { if (eventCountry.Equals(cmbECountryChooses.Items[i].ToString())) { country_position = i; break; } } this.cmbECountryChooses.SelectedIndex = country_position; CityConnection cityConnection = new CityConnection(); DataSet cityNa = cityConnection.GetCityNameByCityId(int.Parse(eventCity)); eventCity = cityNa.Tables[0].Rows[0][0].ToString(); for (int i = 0; i < this.cmbECityChooses.Items.Count; i++) { if (eventCity.Equals(cmbECityChooses.Items[i].ToString())) { city_position = i; break; } } this.cmbECityChooses.SelectedIndex = city_position; } eventName.TextChanged += new TextChangedEventHandler(eventName_TextChanged); } }
private void initialize() { addressConnection = new AddressConnection(); locationConnection = new LocationConnection(); //cities kai countries cityConnection = new CityConnection(); countryConnection = new CountryConnection(); this.countries = countryConnection.GetCountries(); foreach (DataRow dr in countries.Tables[0].Rows) { cmbECountryChooses.Items.Add(dr[1].ToString()); } cmbECountryChooses.SelectedIndex = 0; this.eventUpdateCities("CY"); //events eventConnection = new EventConnection(); this.events = eventConnection.getEvents(); cmbTEventChooser.Items.Add("Select Event"); foreach (DataRow dr in events.Tables[0].Rows) { cmbTEventChooser.Items.Add(dr[1].ToString()); } cmbTEventChooser.SelectedIndex = 0; //ages cmbTAgeFrom.Items.Add("From"); cmbTAgeTo.Items.Add("To"); for (int i = 5; i <= 60; i++) { cmbTAgeFrom.Items.Add(i.ToString()); cmbTAgeTo.Items.Add(i.ToString()); } cmbTAgeFrom.SelectedIndex = 0; cmbTAgeTo.SelectedIndex = 0; //levels cmbTLevelFrom.Items.Add("From"); cmbTLevelFrom.Items.Add("A"); cmbTLevelFrom.Items.Add("B"); cmbTLevelFrom.Items.Add("C"); cmbTLevelFrom.Items.Add("D"); cmbTLevelTo.Items.Add("To"); cmbTLevelTo.Items.Add("A"); cmbTLevelTo.Items.Add("B"); cmbTLevelTo.Items.Add("C"); cmbTLevelTo.Items.Add("D"); cmbTLevelFrom.SelectedIndex = 0; cmbTLevelTo.SelectedIndex = 0; //games cmbTGame.Items.Add("Select game type"); cmbTGame.Items.Add("Game A"); cmbTGame.Items.Add("Game B"); cmbTGame.Items.Add("Game C"); cmbTGame.Items.Add("Game D"); cmbTGame.Items.Add("Game E"); cmbTGame.SelectedIndex = 0; }