static IEnumerable <Task> GetTasks(Context context)
        {
            GrowSureDataService readableDatabase = new GrowSureDataService();

            var    dataStream = context.Resources.OpenRawResource(Resource.Raw.tasks);
            string data       = "";

            using (var reader = new StreamReader(dataStream))
            {
                data = reader.ReadToEnd();
            }
            var query = readableDatabase.GetActiveTasks(data.ToString());

            foreach (var task in query)
            {
                yield return(new Task(
                                 task.Type,
                                 task.TaskName,
                                 task.Assignee,
                                 task.DueOn,
                                 task.Tags,
                                 task.Location,
                                 task.QuantityUnit,
                                 task.Quantity
                                 ));
            }
        }
        internal static Category GetCategoryWith(Activity activity, string categoryId)
        {
            GrowSureDataService readableDatabase = new GrowSureDataService();
            List <UICategory>   categories       = readableDatabase.GetUiCategories();
            var cat = categories.Single <UICategory>(q => q.Id == categoryId);

            return(new Category(cat.Name, cat.Id, Theme.FromString(cat.Theme)));
        }
        static IEnumerable <Category> LoadCategories(Context context)
        {
            GrowSureDataService readableDatabase = new GrowSureDataService();
            var query = readableDatabase.GetUiCategories();

            foreach (var category in query)
            {
                yield return(new Category(
                                 category.Name,
                                 category.Id,
                                 Theme.FromString(category.Theme)
                                 ));
            }
        }
        public void TestGetActiveTasks()
        {
            GrowSureDataService data = new GrowSureDataService();

            //var taaks = data.GetActiveTasks();
        }
        public void TestGetUiCategory()
        {
            GrowSureDataService data = new GrowSureDataService();

            var catagories = data.GetUiCategories();
        }