public void SaveAddToSetStatus(AImg img) { if (img.IsAddToSetCompleted == false) { return; } string updateAddToSet = string.Format("update {0} " + "set {1} = \"{2}\" ," + " {3} = \"{4}\" ," + " {5} = \"{6}\"" + "where {7} = \"{8}\"", tblImages, colFlickrPhotoSetId, img.FlickrPhotoSetId, colDateAddedToSet, img.DateAddedToSet.ToString("yyyy-MM-dd HH:mm:ss.000"), colSecondsToAddToSet, img.SecondsToAddToSet, colFullFilePath, img.FileFullPath); using (var dbConnection = GetConnection()) { using (var command = new SQLiteCommand(updateAddToSet, dbConnection)) { int result = command.ExecuteNonQuery(); _log.InfoFormat("SaveAddToSetStatus {0}", result); } } }
public void AddPhotoToSet(AImg img,Photoset set) { _log.InfoFormat("adding {0} to photoset : {1}",img.FileFullPath,set.PhotosetId); try { Stopwatch stopWatch = Stopwatch.StartNew(); _flickr.PhotosetsAddPhoto(set.PhotosetId, img.FlickrPhotoId); stopWatch.Stop(); _log.DebugFormat("Add to Set success. Took:{0}s.", stopWatch.Elapsed.TotalSeconds); img.UpdatePhotosetId(set.PhotosetId, DateTime.Now, stopWatch.Elapsed.TotalSeconds); } catch (FlickrApiException ex) { if (ex.Code == 3) //photo already exists. { //DONT consider this as failure img.UpdatePhotosetId(set.PhotosetId, DateTime.Now, 0); } else { img.AddToSetEx = ex; _log.Error(string.Format("Failed to add {0} to photoset : {1}", img.FileFullPath, set.Title), ex); } } catch (Exception ex) { img.AddToSetEx = ex; _log.Error(string.Format("Failed to add {0} to photoset : {1}", img.FileFullPath, set.Title), ex); } }
/// <summary> /// This is called for each grouping.This can throw exception !!! /// </summary> /// <param name="photosetname"></param> /// <param name="photoid"></param> /// <returns></returns> public Photoset GetSet(string photosetname, AImg photoid) { Photoset existingset = null; if (Exists(photosetname, ref existingset)) { return existingset; } Photoset newset = _flickr.PhotosetsCreate(photosetname, photoid.FlickrPhotoId); return newset; }
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; }
private void AddToDb(AImg imgToAdd) { string insertstatement = string.Format("insert into {0} ({1},{2}) values (\"{3}\",{4})", tblImages, colFullFilePath,colSize, imgToAdd.FileFullPath,imgToAdd.Size); using (var dbConnection = GetConnection()) { using (var command = new SQLiteCommand(insertstatement, dbConnection)) { int result = command.ExecuteNonQuery(); _log.InfoFormat("AddToDb {0}", result); } } }