/// <summary> /// Called when an item is tapped /// </summary> /// <param name="sender">cityListView(Xamarin.Forms.ListView) object</param> /// <param name="e">ItemTappedEventArgs</param> private void CityListView_ItemTapped(object sender, ItemTappedEventArgs e) { CityRecord cityRecord = e.Item as CityRecord; TimezoneUtility.SetCurrentTimezone(TimezoneUtility.GetTimezoneByOffset(cityRecord.Offset)); Worldclock.WorldclockPage.GetInstance().OnMapViewUpdateRequest(); }
/// <summary> /// Location information is added to ListView by adding CityRecord to ListView's ItemSources /// </summary> /// <param name="item">Location</param> public void AppendItemToCustomList(Location item) { CityRecord cityRecord = CityRecordUtility.GenerateCityRecord(item.GmtOffset); cityRecord.Cities = item.Name + ", " + item.Country; CityRecordList.Add(cityRecord); }
/// <summary> /// Method for load xml data /// </summary> /// <param name="name"></param> /// <returns></returns> public List <CityRecord> LoadPortalContent() { List <CityRecord> cityRecordList = new List <CityRecord>(); try { XmlDocument _Doc = new XmlDocument(); _Doc.Load(Constatns.XmlUrl); foreach (XmlNode node in _Doc.DocumentElement.ChildNodes[0].ChildNodes) { string isvalid = node["isvalid"].InnerText; if (isvalid.Equals("1")) { if (node.SelectSingleNode("api_url") != null) { Api_Url = Convert.ToString(node["api_url"].InnerText); } else { Api_Url = string.Empty; } if (node.SelectSingleNode("city") != null) { city = Convert.ToString(node["city"].InnerText); } else { city = string.Empty; } if (node.SelectSingleNode("dataset_name") != null) { Dataset = Convert.ToString(node["dataset_name"].InnerText); } else { Dataset = string.Empty; } CityRecord cityRecord = new CityRecord(Convert.ToString(node["city"].InnerText), Convert.ToInt32(node.Attributes["_id"].InnerText)) { CityName = city, DatasetName = Dataset, APIURL = Api_Url, RowId = Convert.ToInt32(node.Attributes["_id"].InnerText), UUID = node.Attributes["_uuid"].InnerText, AddDate = DateTime.Now, ExpiryDate = DateTime.Now.AddDays(1), }; cityRecordList.Add(cityRecord); } } } catch (Exception ex) { string message = ex.Message; } return(cityRecordList); }
/// <summary> /// Used to Delete RecordByID /// </summary> /// <param name="rowIdList"></param> public void DeleteRecordByID(List <int> rowIdList) { try { if (rowIdList != null) { // Retrieve storage account from connection string CloudStorageAccount storageAccount = CloudStorageAccount.Parse(RoleEnvironment.GetConfigurationSettingValue(Constatns.StorageAccountConnectionString)); // Create the table client CloudTableClient tableClient = storageAccount.CreateCloudTableClient(); //get table references CloudTable cityTable = tableClient.GetTableReference("cityrecords"); CloudTable updateTable = tableClient.GetTableReference("updatedcityrecord"); // Get the data service context TableServiceContext serviceContext = tableClient.GetTableServiceContext(); //// Specify a partition query foreach (int id in rowIdList) { CityRecord city = (from e in serviceContext.CreateQuery <CityRecord>("cityrecords") where e.RowKey == id.ToString() select e).FirstOrDefault(); if (city != null) { city.ETag = "*"; TableOperation deleteOperation = TableOperation.Delete(city); cityTable.Execute(deleteOperation); } } //// Specify a partition query //// Specify a partition query foreach (int id in rowIdList) { UpdatedCityRecord city = (from e in serviceContext.CreateQuery <UpdatedCityRecord>("updatedcityrecord") where e.RowKey == id.ToString() select e).FirstOrDefault(); if (city != null) { city.ETag = "*"; TableOperation deleteOperation = TableOperation.Delete(city); updateTable.Execute(deleteOperation); } } } } catch (Exception ex) { string message = ex.Message; } }
/// <summary> /// Called when a data item is selected or unselected /// </summary> /// <param name="sender">ListView's data item</param> /// <param name="e">SelectedItemChangedEventArgs</param> private void WorldclockDeleteListview_ItemSelected(object sender, SelectedItemChangedEventArgs e) { if (e.SelectedItem == null) { return; } CityRecord item = (CityRecord)e.SelectedItem; item.Delete = !item.Delete; // make it deselected ((ListView)sender).SelectedItem = null; }
/// <summary> /// Generate CityRecord instance related to the given GMT offset /// </summary> /// <param name="offset">int</param> /// <returns>CityRecord</returns> public static CityRecord GenerateCityRecord(int offset) { TimezoneInfo result = GetTimezoneInformation(offset); CityRecord record = new CityRecord { CityTime = GetFormattedTime(result.newTime), CityAmPm = result.newTime.ToString("tt", CultureInfo.InvariantCulture), CityDate = String.Format("{0:ddd, d MMM}", result.newTime), RelativeToLocalCountry = result.relative, Offset = offset, Delete = false, }; return(record); }
public void LoadCity() { isInitialising = true; currentcity = (CityRecord)model.TableModels[EditorModel.CITY_TABLE].GetRecord(currentrec); CityID.Value = currentrec; CityName_Textbox.Text = currentcity.CityName; State_Textbox.Text = currentcity.StateName; CityPop.Value = currentcity.CityPopulation; TeamDemand.Value = currentcity.Demand; Region_Combobox.SelectedIndex = currentcity.Region; AvgTempJan.Value = currentcity.TempJan; AvgTempSep.Value = currentcity.TempSep; Television.Value = currentcity.Television; OnMap_Checkbox.Checked = currentcity.OnMap; FairWeatherVariance.Value = currentcity.FairWeather; FairWeatherPercentage.Value = currentcity.YearlyFairPerc; RainPercentage.Value = currentcity.YearlyRainPerc; WindPercentage.Value = currentcity.YearlyWindPerc; WinterWeather.Value = currentcity.CYww; SnowPercentage.Value = currentcity.YearlySnowPerc; Relocate.Value = currentcity.Owrc; RelocateUnknown.Value = currentcity.Orot; // Customize the min,max values for relocation year RelocateYear.Minimum = model.CurrentYearIndex + (int)model.FileVersion + currentcity.Owry; RelocateYear.Maximum = model.CurrentYearIndex + (int)model.FileVersion + currentcity.Owry + 15; RelocateYear.Value = model.CurrentYearIndex + (int)model.FileVersion + currentcity.Owry; if (model.FileVersion > MaddenFileVersion.Ver2004) { Timezone_Combobox.Enabled = true; Timezone_Combobox.SelectedIndex = currentcity.Timezone; Newspaper.Enabled = true; Newspaper.Text = currentcity.Newspaper; } else { Timezone_Combobox.Enabled = false; Timezone_Combobox.SelectedIndex = -1; Newspaper.Enabled = false; Newspaper.Text = ""; } isInitialising = false; }
public ActionResult Upload() { foreach (string file in Request.Files) { var hpf = Request.Files[file]; if (hpf == null) { continue; } using (var sr = new StreamReader(hpf.InputStream)) { var batch = new List <CityRecord>(); var db = new GeocodeDb(WebConfigurationManager.AppSettings["GeocodeDbConnectionString"]); while (!sr.EndOfStream) { var line = sr.ReadLine(); var city = new CityRecord(line); batch.Add(city); if (batch.Count == 100) { db.InsertCities(batch); batch.Clear(); } } if (batch.Count > 0) { db.InsertCities(batch); } } } return(RedirectToAction("Index")); }
public TableRecordModel ConstructRecordModel(int recno) { TableRecordModel newRecord = null; string tablename = name; // Need to reverse the name if BE if (BigEndian) { string rev = ConvertBE(name); tablename = rev; } switch (tablename) { case EditorModel.CITY_TABLE: newRecord = new CityRecord(recno, this, parentModel); break; case EditorModel.COACH_TABLE: { // coch table in streameddata is different than ros/fra if (parentModel.FileType == MaddenFileType.Streameddata) { newRecord = new CoachCollection(recno, this, parentModel); } else { newRecord = new CoachRecord(recno, this, parentModel); } break; } case EditorModel.SALARY_CAP_TABLE: newRecord = new SalaryCapRecord(recno, this, parentModel); break; case EditorModel.COACH_SLIDER_TABLE: newRecord = new CoachPrioritySliderRecord(recno, this, parentModel); break; case EditorModel.TEAM_CAPTAIN_TABLE: newRecord = new TeamCaptainRecord(recno, this, parentModel); break; case EditorModel.OWNER_TABLE: newRecord = new OwnerRecord(recno, this, parentModel); break; case EditorModel.DEPTH_CHART_TABLE: newRecord = new DepthChartRecord(recno, this, parentModel); break; case EditorModel.INJURY_TABLE: newRecord = new InjuryRecord(recno, this, parentModel); break; case EditorModel.PLAYER_TABLE: newRecord = new PlayerRecord(recno, this, parentModel); break; case EditorModel.TEAM_TABLE: newRecord = new TeamRecord(recno, this, parentModel); break; case EditorModel.SCHEDULE_TABLE: newRecord = new ScheduleRecord(recno, this, parentModel); break; case EditorModel.STADIUM_TABLE: newRecord = new StadiumRecord(recno, this, parentModel); break; case EditorModel.UNIFORM_TABLE: newRecord = new UniformRecord(recno, this, parentModel); break; // MADDEN DRAFT EDIT case EditorModel.DRAFT_PICK_TABLE: newRecord = new DraftPickRecord(recno, this, parentModel); break; case EditorModel.DRAFTED_PLAYERS_TABLE: newRecord = new RookieRecord(recno, this, parentModel); break; case EditorModel.BOXSCORE_DEFENSE_TABLE: newRecord = new BoxScoreDefenseRecord(recno, this, parentModel); break; case EditorModel.BOXSCORE_OFFENSE_TABLE: newRecord = new BoxScoreOffenseRecord(recno, this, parentModel); break; case EditorModel.CAREER_STATS_DEFENSE_TABLE: newRecord = new CareerStatsDefenseRecord(recno, this, parentModel); break; case EditorModel.CAREER_STATS_OFFENSE_TABLE: newRecord = new CareerStatsOffenseRecord(recno, this, parentModel); break; case EditorModel.SEASON_STATS_DEFENSE_TABLE: newRecord = new SeasonStatsDefenseRecord(recno, this, parentModel); break; case EditorModel.SEASON_STATS_OFFENSE_TABLE: newRecord = new SeasonStatsOffenseRecord(recno, this, parentModel); break; case EditorModel.TEAM_SEASON_STATS: newRecord = new TeamSeasonStatsRecord(recno, this, parentModel); break; case EditorModel.FRANCHISE_TIME_TABLE: newRecord = new FranchiseTimeRecord(recno, this, parentModel); break; case EditorModel.BOXSCORE_TEAM_TABLE: newRecord = new BoxScoreTeamStats(recno, this, parentModel); break; case EditorModel.BOXSCORE_OFFENSIVE_LINE_TABLE: newRecord = new BoxScoreOffensiveLineRecord(recno, this, parentModel); break; case EditorModel.SEASON_STATS_OFFENSIVE_LINE_TABLE: newRecord = new SeasonStatsOffensiveLineRecord(recno, this, parentModel); break; case EditorModel.CAREER_STATS_OFFENSIVE_LINE_TABLE: newRecord = new CareerStatsOffensiveLineRecord(recno, this, parentModel); break; case EditorModel.CAREER_GAMES_PLAYED_TABLE: newRecord = new CareerGamesPlayedRecord(recno, this, parentModel); break; case EditorModel.SEASON_GAMES_PLAYED_TABLE: newRecord = new SeasonGamesPlayedRecord(recno, this, parentModel); break; case EditorModel.CAREER_STATS_KICKPUNT_TABLE: newRecord = new CareerPuntKickRecord(recno, this, parentModel); break; case EditorModel.SEASON_STATS_KICKPUNT_TABLE: newRecord = new SeasonPuntKickRecord(recno, this, parentModel); break; case EditorModel.CAREER_STATS_KICKPUNT_RETURN_TABLE: newRecord = new CareerPKReturnRecord(recno, this, parentModel); break; case EditorModel.SEASON_STATS_KICKPUNT_RETURN_TABLE: newRecord = new SeasonPKReturnRecord(recno, this, parentModel); break; case EditorModel.SCOUTING_STATE_TABLE: newRecord = new ScoutingStateRecord(recno, this, parentModel); break; case EditorModel.RFA_STATE_TABLE: newRecord = new RFAStateRecord(recno, this, parentModel); break; case EditorModel.RFA_PLAYERS: newRecord = new RestrictedFreeAgentPlayers(recno, this, parentModel); break; case EditorModel.RFA_SALARY_TENDERS: newRecord = new RestrictedFreeAgentSigningTenders(recno, this, parentModel); break; case EditorModel.RESIGN_PLAYERS_STATE_TABLE: newRecord = new ResignPlayersStateRecord(recno, this, parentModel); break; case EditorModel.FREE_AGENCY_STATE_TABLE: newRecord = new FreeAgencyStateRecord(recno, this, parentModel); break; case EditorModel.DRAFT_STATE_TABLE: newRecord = new DraftStateRecord(recno, this, parentModel); break; case EditorModel.FRANCHISE_STAGE_TABLE: newRecord = new FranchiseStageRecord(recno, this, parentModel); break; case EditorModel.GAME_OPTIONS_TABLE: newRecord = new GameOptionRecord(recno, this, parentModel); break; case EditorModel.PLAYER_AWARDS_TABLE: newRecord = new YearlyAwards(recno, this, parentModel); break; case EditorModel.FREE_AGENT_PLAYERS: newRecord = new FreeAgentPlayers(recno, this, parentModel); break; case EditorModel.COACHES_EXPECTED_SALARY: newRecord = new CoachExpectedSalary(recno, this, parentModel); break; case EditorModel.COACHING_HISTORY_TABLE: newRecord = new CoachHistory(recno, this, parentModel); break; case EditorModel.PROGRESSION_SCHEDULE: newRecord = new ProgressionSchedule(recno, this, parentModel); break; case EditorModel.USER_OPTIONS_TABLE: newRecord = new UserOptionRecord(recno, this, parentModel); break; case EditorModel.TEAM_RIVAL_HISTORY: newRecord = new TeamRivalHistory(recno, this, parentModel); break; case EditorModel.PRO_BOWL_PLAYERS: newRecord = new ProBowlPlayer(recno, this, parentModel); break; case EditorModel.USER_INFO_TABLE: newRecord = new UserInfoRecord(recno, this, parentModel); break; #region Streamed Data case EditorModel.COLLEGES_TABLE: newRecord = new CollegesRecord(recno, this, parentModel); break; case EditorModel.PLAYER_FIRST_NAMES: newRecord = new FirstNames(recno, this, parentModel); break; case EditorModel.PLAYER_LAST_NAMES: newRecord = new LastNames(recno, this, parentModel); break; case EditorModel.ROLES_DEFINE: newRecord = new PRDF(recno, this, parentModel); break; case EditorModel.ROLES_INFO: newRecord = new RoleInfo(recno, this, parentModel); break; case EditorModel.ROLES_PLAYER_EFFECTS: newRecord = new RolePlayerEffects(recno, this, parentModel); break; case EditorModel.ROLES_TEAM_EFFECTS: newRecord = new RoleTeamEffects(recno, this, parentModel); break; case EditorModel.STATS_REQUIRED: newRecord = new SuperStarStatsRequired(recno, this, parentModel); break; case EditorModel.PROGRESSION: newRecord = new PlayerProgression(recno, this, parentModel); break; case EditorModel.REGRESSION: newRecord = new PlayerRegression(recno, this, parentModel); break; case EditorModel.PTCB: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTCE: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTDE: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTDT: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTFB: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTFS: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTGA: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTHB: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTKI: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTKP: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTMB: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTOB: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTPU: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTQB: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTSS: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTTA: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTTE: newRecord = new ProgressionTracking(recno, this, parentModel); break; case EditorModel.PTWR: newRecord = new ProgressionTracking(recno, this, parentModel); break; #endregion case EditorModel.POSITION_SUBS: newRecord = new PlayerSubs(recno, this, parentModel); break; case EditorModel.DEPTH_CHART_SUBS: newRecord = new DepthChartSubs(recno, this, parentModel); break; case EditorModel.SALARY_CAP_INCREASE: newRecord = new SalaryCapIncrease(recno, this, parentModel); break; case EditorModel.PLAYER_MINIMUM_SALARY_TABLE: newRecord = new SalaryYearsPro(recno, this, parentModel); break; case EditorModel.PLAYER_SALARY_DEMAND_TABLE: newRecord = new PlayerSalaryDemands(recno, this, parentModel); break; case EditorModel.INACTIVE_TABLE: newRecord = new InactiveRecord(recno, this, parentModel); break; case EditorModel.LEAGUE_REVENUE_TABLE: newRecord = new LeagueRevenue(recno, this, parentModel); break; case EditorModel.OWNER_REVENUE_TABLE: newRecord = new OwnerRevenue(recno, this, parentModel); break; case EditorModel.WEEKLY_INCOME_TABLE: newRecord = new Income(recno, this, parentModel); break; case EditorModel.TEAM_WIN_LOSS_RECORD: newRecord = new TeamWinLossRecord(recno, this, parentModel); break; // DB Templates case EditorModel.PLAYER_OVERALL_CALC: newRecord = new OverallRecord(recno, this, parentModel); break; case EditorModel.PLAYBOOK_TABLE: newRecord = new FRAPlayBooks(recno, this, parentModel); break; default: newRecord = new TableRecordModel(recno, this, parentModel); break; } //Add the new record to our list of records recordList.Add(newRecord); return(newRecord); }