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