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); }