public Quest GetQuestByGear(UniqueGear gear)
{
using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation))
{
return(conn.Table <Quest>().Where(x => x.QuestName.Contains(gear.Quest)).FirstOrDefault());
}
}
public Location GetLocationByGear(UniqueGear gear)
{
using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation))
{
return(conn.Table <Location>().Where(x => gear.Location.Contains(x.LocationName)).FirstOrDefault());
}
}
private void CheckBox_CheckedChanged(object sender, CheckedChangedEventArgs e)
{
var gs = new UniqueGearService();
var gearChecked = (CheckBox)sender;
UniqueGear gear = gearChecked.BindingContext as UniqueGear;
gs.UpdateGearCheck(gearChecked.IsChecked, gear);
}
public void UpdateGearCheck(bool check, UniqueGear gear)
{
using (SQLiteConnection conn = new SQLiteConnection(App.DatabaseLocation))
{
var result = conn.Table <UniqueGear>().Where(x => x.ID == gear.ID).FirstOrDefault();
result.Check = check;
conn.Update(result);
}
}
public UniqueGearPage(UniqueGear gear)
{
Gear = gear;
InitializeComponent();
var gs = new UniqueGearService();
GearLocation = gs.GetLocationByGear(Gear);
GearQuest = gs.GetQuestByGear(Gear);
this.BindingContext = new UniqueGearViewModel(Gear);
}
public UniqueGearViewModel(UniqueGear item)
{
Item = item;
var gs = new UniqueGearService();
if (Item.Quest != "")
{
GearQuest = gs.GetQuestByGear(Item);
}
if (Item.Location != "")
{
GearLocation = gs.GetLocationByGear(Item);
}
HasQuestLink = (GearQuest != null);
HasLocationLink = (GearLocation != null);
}
