public async Task <IEnumerable <CalendarTable> > GetCalendarAsync()
{
if (!initialized)
{
Init();
}
List <CalendarTable> calendarTables = new List <CalendarTable>();
try
{
IFolder folder = await rootFolder.CreateFolderAsync("Library", CreationCollisionOption.OpenIfExists);
// create a file, overwriting any existing fileMySubFolder
IFile Calendarfile = await folder.CreateFileAsync("Calendar.json", CreationCollisionOption.OpenIfExists);
var json = await Calendarfile.ReadAllTextAsync();
// populate the file with some text
CalendarTable = JsonConvert.DeserializeObject <CalendarInfo.RootObject>(json);
if (CalendarTable.items != null)
{
foreach (var item in CalendarTable.items)
{
CalendarTable calendar = new CalendarTable(item);
calendarTables.Add(calendar);
}
}
}
catch (Exception)
{
}
return(await Task.Run(() => calendarTables));
//sqlite.GetCalendarItems());
}
public Task AddCalendarItems(CalendarInfo.RootObject rootObject)
{
if (rootObject.items.Count > 100)
{
_connection.DeleteAll <CalendarTable>();
}
foreach (var items in rootObject.items)
{
if (items != null)
{
var Citem = new CalendarTable(items);
{
if (!_connection.Table <CalendarTable>().Any(x => x.id == Citem.id))
{
_connection.Insert(Citem);
}
else
{
_connection.Update(Citem);
}
}
}
}
return(Task.Run(() => rootObject));
}