private async Task GetSampleDataFromAzure() { try{ var items = await Result.Take(88).ToListAsync(); // var items = await Result.ToCollectionAsync(); SQLiteAsyncConnection conn = new SQLiteAsyncConnection("ATMOS.db"); list.Clear(); foreach (Events i in items) { list.Add(i); } await conn.DropTableAsync <Events>(); await conn.CreateTableAsync <Events>(); list.Sort((ev1, ev2) => DateTime.Compare(ev1.startTime, ev2.startTime)); await conn.InsertAllAsync(list); EventsGroupByDate group1 = new EventsGroupByDate("1", "10th October"); EventsGroupByDate group2 = new EventsGroupByDate("2", "11th October"); EventsGroupByDate group3 = new EventsGroupByDate("3", "12th October"); EventsGroupByDate group4 = new EventsGroupByDate("1", "Current Events"); EventsGroupByDate group5 = new EventsGroupByDate("2", "Future Events"); this.Groupsh.Clear(); int uid = 1; foreach (Events i in list) { if (TimeLine.stb == 1) { string d = i.startTime.Date.ToString("dd/MM/yyyy"); if (d.Equals("12/10/2014")) { group3.Items.Add(i); } else if (d.Equals("11/10/2014")) { group2.Items.Add(i); } else { group1.Items.Add(i); } } else if (TimeLine.stb == 3) { if (DateTime.Compare(i.startTime, DateTime.Now) > 0) { group5.Items.Add(i); } else if (DateTime.Compare(i.endTime, DateTime.Now) > 0 && DateTime.Compare(i.startTime, DateTime.Now) <= 0) { group4.Items.Add(i); } } else { if (this._groupsh.Count == 0) { EventsGroupByHour group = new EventsGroupByHour(); group.UniqueId = "1"; group.Time = i.startTime.ToString("hh:mm tt dd/MM/yyyy"); group.Items.Add(i); this.Groupsh.Add(group); } else if (this.Groupsh[_groupsh.Count - 1].Time.Equals(i.startTime.ToString("hh:mm tt dd/MM/yyyy"))) { EventsGroupByHour group = this._groupsh[_groupsh.Count - 1]; group.Items.Add(i); } else { uid++; EventsGroupByHour group = new EventsGroupByHour(); group.UniqueId = uid.ToString(); group.Time = i.startTime.ToString("hh:mm tt dd/MM/yyyy"); group.Items.Add(i); this.Groupsh.Add(group); } } } if (TimeLine.stb == 1) { this.Groupsd.Clear(); this.Groupsd.Add(group1); this.Groupsd.Add(group2); this.Groupsd.Add(group3); } else if (TimeLine.stb == 3) { this.Groupsw.Clear(); this.Groupsw.Add(group4); this.Groupsw.Add(group5); } } catch (Exception e1) { MessageDialog ob = new MessageDialog("Please connect to internet to download the schedule."); ob.ShowAsync(); } }
private async Task GetSampleDataAsync() { bool flag = false; try { SQLiteAsyncConnection conn = new SQLiteAsyncConnection("ATMOS.db"); var allresults = await conn.QueryAsync <Events>("SELECT * FROM Schedule"); if (list.Count == 0) { list = allresults; } if (this._groupsd.Count != 0) { return; } list.Sort((ev1, ev2) => DateTime.Compare(ev1.startTime, ev2.startTime)); EventsGroupByDate group1 = new EventsGroupByDate("1", "10th October"); EventsGroupByDate group2 = new EventsGroupByDate("2", "11th October"); EventsGroupByDate group3 = new EventsGroupByDate("3", "12th October"); EventsGroupByDate group4 = new EventsGroupByDate("1", "Current Events"); EventsGroupByDate group5 = new EventsGroupByDate("2", "Future Events"); int uid = 1; foreach (Events i in list) { if (TimeLine.stb == 1) { string d = i.startTime.Date.ToString("dd/MM/yyyy"); if (d.Equals("12/10/2014")) { group3.Items.Add(i); } else if (d.Equals("11/10/2014")) { group2.Items.Add(i); } else { group1.Items.Add(i); } } else if (TimeLine.stb == 3) { if (DateTime.Compare(i.startTime, DateTime.Now) > 0) { group5.Items.Add(i); } else if (DateTime.Compare(i.endTime, DateTime.Now) > 0 && DateTime.Compare(i.startTime, DateTime.Now) <= 0) { group4.Items.Add(i); } } else { if (this._groupsh.Count == 0) { EventsGroupByHour group = new EventsGroupByHour(); group.UniqueId = "1"; group.Time = i.startTime.ToString("hh:mm tt dd/MM/yyyy"); group.Items.Add(i); this.Groupsh.Add(group); } else if (this.Groupsh[_groupsh.Count - 1].Time.Equals(i.startTime.ToString("hh:mm tt dd/MM/yyyy"))) { EventsGroupByHour group = this._groupsh[_groupsh.Count - 1]; group.Items.Add(i); } else { uid++; EventsGroupByHour group = new EventsGroupByHour(); group.UniqueId = uid.ToString(); group.Time = i.startTime.ToString("hh:mm tt dd/MM/yyyy"); group.Items.Add(i); this.Groupsh.Add(group); } } } int k = this._groupsh.Count; if (TimeLine.stb == 1) { this.Groupsd.Add(group1); this.Groupsd.Add(group2); this.Groupsd.Add(group3); } else if (TimeLine.stb == 3) { this.Groupsw.Add(group4); this.Groupsw.Add(group5); } } catch (Exception) { flag = true; } if (NetworkInterface.GetIsNetworkAvailable()) { // await GetSampleDataFromAzure(); } else if (flag) { MessageDialog ob = new MessageDialog("Please connect to internet to download the schedule."); await ob.ShowAsync(); } }