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);
}
}
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;
}
