public static PictureData GetPicture(int id) { PictureData result; try { PictureDb p = DatabaseManager.db.Get <PictureDb>(id); PictureData pictureData = DbTypeConvertor.ToPictureData(p); result = pictureData; } catch { result = null; } return(result); }
public static List <PictureData> GetLocalPictures() { List <PictureData> list = new List <PictureData>(); try { string query = "SELECT * FROM PictureDb"; List <PictureDb> list2 = DatabaseManager.db.Query <PictureDb>(query, new object[0]); if (list2 != null) { for (int i = 0; i < list2.Count; i++) { list.Add(DbTypeConvertor.ToPictureData(list2[i])); } } } catch (Exception ex) { FMLogger.Log("queue all local pics error. " + ex.Message); AnalyticsManager.DbTransactionError("picDb", "GetLocalPictures: " + ex.Message); } return(list); }