Beispiel #1
0
    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);
    }
Beispiel #2
0
    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);
    }