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