/// <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);
}
