public LTypeList all_l_types()
{
LTypeDB db = new LTypeDB();
LTypeList list = db.SelectAll();
return(list);
}
public LTypeList SelectAll()
{
Ltypes = new LTypeList();
cmd.CommandText = "SELECT * From LTypes";
Ltypes = new LTypeList(base.Select());
return(Ltypes);
}
private void Client_all_l_typesCompleted(object sender, all_l_typesCompletedEventArgs e)
{
Device.BeginInvokeOnMainThread(
async() =>
{
if (e.Error != null)
{
await DisplayAlert("An Error", e.Error.ToString(), "Exit");
}
else if (e.Cancelled == true)
{
await DisplayAlert("Event Cancelled", "Cancelled", "Exit");
}
else
{
LTypeList locl = e.Result;
if (locl == null)
{
await DisplayAlert("Failed to retreive list", "Unable to get list", "Exit");
}
else
{
locbox.ItemsSource = locl;
}
}
}
);
}
//public static LType SelectByID(int id)
//{
// if (lTypes==null)
// {
// LTypeDB db = new LTypeDB();
// Types = db.SelectAll();
// }
// LType lTypes = lTypes.Find(c => c.ID == id);
// return lTypes;
//}
public LType SelectByID(int id)
{
if (Ltypes == null)
{
LTypeDB db = new LTypeDB();
Ltypes = db.SelectAll();
}
// LType xx=null;
// foreach (LType lt in Ltypes)
// {
// if ( lt.ID == id)
// xx = lt;
//}
LType fl = Ltypes.Find(lt => lt.ID == id);
return(fl);
}
