public void Upload(AImg img) { try { Stopwatch stopWatch = Stopwatch.StartNew(); string response = _flickr.UploadPicture(img.FileFullPath, img.FileName, description: img.FolderName, tags: img.FolderName, isPublic: _config.IsPrivate, isFamily: _config.IsPrivate, isFriend: _config.IsPrivate); stopWatch.Stop(); _log.DebugFormat("Upload success. Took:{0}s. Response :{1}", stopWatch.Elapsed.TotalSeconds, response); img.UpdateFlickrPhotoId(response, DateTime.Now, stopWatch.Elapsed.TotalSeconds); } catch (Exception ex) { img.UploadEx = ex; _log.Error(string.Format("error uploading " + img.FileFullPath), ex); } }
private List<AImg> GetImgsInDb() { string sqlselect = string.Format("select {0},{1},{2} from {3}", colFullFilePath, colFlickrPhotoSetId, colFlickrImgId, tblImages); var imgsInDb = new List<AImg>(); using (var conn = GetConnection()) { using (var command = new SQLiteCommand(sqlselect, conn)) { using (var reader = command.ExecuteReader()) { while (reader.Read()) { string fullfilepath = reader[colFullFilePath].ToString(); string flickrid = ConvertToString(reader[colFlickrImgId]); string flickrphotosetid = ConvertToString(reader[colFlickrPhotoSetId]); var imgdb = new AImg(fullfilepath); if (string.IsNullOrEmpty(flickrphotosetid) == false) { imgdb.UpdatePhotosetId(flickrphotosetid); } if (string.IsNullOrEmpty(flickrid) == false) { imgdb.UpdateFlickrPhotoId(flickrid); } imgsInDb.Add(imgdb); } } } } return imgsInDb; }