public static Day getByDayID(int dayID)
{
var path = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "db.sqlite");
Day day = new Day();
using (SQLite.Net.SQLiteConnection conn = new SQLite.Net.SQLiteConnection(new SQLite.Net.Platform.WinRT.SQLitePlatformWinRT(), path))
{
day = (from d in conn.Table<Day>()
where d.DayID == dayID
select d
).ToList().FirstOrDefault();
}
return day;
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
var parameter = e.Parameter as HaveMealClass;
_day = parameter.Day;
_kind = parameter.Kind;
//get eats
cbMeal.ItemsSource = MealDB.getAll();
cbMeal.DisplayMemberPath = "Name";
cbMeal.SelectedValuePath = "MealID";
cbMeal.SelectedIndex = 0;
}
public void updateDay()
{
// _day = null;
if (this._day == null || (this._day.Date.Date.Year != DateTime.Now.Date.Year || this._day.Date.Date.DayOfYear != DateTime.Now.Date.DayOfYear))
{
//create day
this._day = new Day();
this._day.User = this.user;
this._day.Date = DateTime.Now;
this._day.LastMeal = (int)DateTime.Now.TimeOfDay.TotalMinutes;
DayDB ddb = new DayDB(this._day);
ddb.save();
var localSettings = Windows.Storage.ApplicationData.Current.LocalSettings;
localSettings.Values["dayID"] = _day.DayID;
List<Eat> eats = new List<Eat> { };
eats.Add(new Eat(_day.DayID, "Breakfest"));
eats.Add(new Eat(_day.DayID, "Lunch"));
eats.Add(new Eat(_day.DayID, "Dinner"));
foreach(Eat e in eats)
{
EatDB edb = new EatDB(e);
edb.save();
}
this.tbDate.Text = DateTime.Now.Day.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Year.ToString();
//Update meals from servers everyday
NetworkService.updateMeals();
}
}
public void getStorageInfo()
{
var localSettings = Windows.Storage.ApplicationData.Current.LocalSettings;
if (localSettings.Values["userID"] != null)
{
int userID = (int)localSettings.Values["userID"];
user = UserDB.getByUserID(userID);
}
if (localSettings.Values["dayID"] != null)
{
int dayID = (int)localSettings.Values["dayID"];
_day = DayDB.getByDayID(dayID);
}
if (user != null)
helloUser.Text = "Hello, " + user.Name + "!";
}
public DayDB(Day Day)
{
this._Day = Day;
}
public HaveMealClass(Day day, string kind)
{
_day = day;
_kind = kind;
}