public List <UseCasesShared.DTOs.Ink> RetrieveInks()
{
var useCaseInks = new List <UseCasesShared.DTOs.Ink>();
using (SQLiteConnection conn = new SQLiteConnection(_databaseLocation))
{
conn.CreateTable <Ink>();
List <Ink> inks = conn.Table <Ink>().ToList();
foreach (Ink ink in inks)
{
useCaseInks.Add(SchemaToUseCaseDtoConverter.Convert(ink));
}
}
return(useCaseInks);
}
public List <UseCasesShared.DTOs.Pen> RetrievePens()
{
var useCasePens = new List <UseCasesShared.DTOs.Pen>();
using (SQLiteConnection conn = new SQLiteConnection(_databaseLocation))
{
conn.CreateTable <Pen>();
List <Pen> pens = conn.Table <Pen>().ToList();
foreach (Pen pen in pens)
{
useCasePens.Add(SchemaToUseCaseDtoConverter.Convert(pen,
RetrieveInk(pen.InkId)));
}
}
return(useCasePens);
}
private UseCasesShared.DTOs.Ink RetrieveInk(int inkId)
{
UseCasesShared.DTOs.Ink useCaseInk = null;
using (SQLiteConnection conn = new SQLiteConnection(_databaseLocation))
{
conn.CreateTable <Ink>();
Ink ink = conn.Table <Ink>().ToList().Find(ink => ink.Id == inkId);
if (ink != null)
{
useCaseInk = SchemaToUseCaseDtoConverter.Convert(ink);
}
}
return(useCaseInk);
}