public Task Insert <T>(T item) where T : MyScullion.Models.BaseModel, new() { try { CheckTable <T>(); base.Insert(ExtensionMethodsSQLiteRaw.ToInsertQuery <T>(), item.GetParameters <T>()); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); } return(Task.FromResult(Unit.Default)); }
public Task <IEnumerable <T> > GetAll <T>() where T : MyScullion.Models.BaseModel, new() { CheckTable <T>(); var myCollection = new List <T>(); try { myCollection = base.Select <T>($"SELECT {ExtensionMethodsSQLiteRaw.PrepareFieldsToSelectOrInsert<T>()} FROM {typeof(T).Name}", ExtensionMethodsSQLiteRaw.SerializeCollection <T>); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); } return(Task.FromResult <IEnumerable <T> >(myCollection)); }
public Task <T> Get <T>(int id) where T : MyScullion.Models.BaseModel, new() { CheckTable <T>(); try { var myT = base.SelectFirst <T>($"SELECT {ExtensionMethodsSQLiteRaw.PrepareFieldsToSelectOrInsert<T>()} FROM {typeof(T).Name} WHERE Id = @Id", new List <object>() { new SqliteParameter("@Id", id) }, ExtensionMethodsSQLiteRaw.Serialize <T>); return(Task.FromResult(myT)); } catch (Exception e) { System.Diagnostics.Debug.WriteLine(e); } return(Task.FromResult(default(T))); }