public WebPicture GetPicture(int idPicture)
{
WebPicture pic = new WebPicture();
SQLiteConnection db = new SQLiteConnection(SQLiteConnStr("PictureDatabase"));
try
{
db.Open();
}
catch (Exception)
{
return(pic);
}
SQLiteCommand cmd = db.CreateCommand();
cmd.CommandText = "SELECT * FROM picture WHERE idPicture=" + idPicture.ToString();
SQLiteDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
pic = new WebPicture(reader.GetInt32(0), reader.GetString(1), reader.GetInt32(2), reader.GetDateTime(3));
}
reader.Close(); reader.Dispose(); cmd.Dispose(); db.Close(); db.Dispose();
return(pic);
}
private void WebPicture_ImageFailed(object sender, ExceptionRoutedEventArgs e)
{
Image image = sender as Image;
WebPicture picture = image.DataContext as WebPicture;
LongListMultiSelector selector = picture.SourceOrigin == SourceOrigin.BingToday ? BingTodayPictureSelector : (picture.SourceOrigin == SourceOrigin.Search ? WebPictureSelector : NasaTodayPictureSelector);
WebImageLoadFailed(image, selector);
}
public int AddWebPicture(WebPicture WebPicture)
{
using (AIYunNetContext context = new AIYunNetContext())
{
context.WebPicture.Add(WebPicture);
context.SaveChanges();
return(1);
}
}
public void CreateDeletePictureFilename()
{
Int64 pictureId = 33;
List <WebPictureMetaData> pictureMetaData = new List <WebPictureMetaData>
{
new WebPictureMetaData
{
PictureMetaDataId = 1,
HasPictureMetaDataId = true,
Value = "(C) Test 2014"
},
new WebPictureMetaData
{
PictureMetaDataId = 2,
HasPictureMetaDataId = true,
Value = "Test Author"
},
new WebPictureMetaData
{
PictureMetaDataId = 3,
HasPictureMetaDataId = true,
Value = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")
}
};
WebPicture picture = WebServiceProxy.PictureService.GetPictureById(GetClientInformation(), pictureId, null, null, 0, false, string.Empty);
String filename = @"\Temp\JN_Leiobunum-blackwalli_226679_Hane_new.jpg";
Int32 affectedRows;
DateTime lastModified = DateTime.Now;
List <Int32> pictureMetaDataIds = new List <int> {
1, 2, 3
};
String updatedBy = "test test";
List <WebPictureMetaData> newPictureMetaData;
WebPictureResponse webPictureResponse;
using (IWebServiceTransaction transaction = new WebServiceTransaction(GetClientInformation(), WebServiceProxy.PictureService))
{
webPictureResponse = WebServiceProxy.PictureService.CreatePictureFilename(GetClientInformation(), picture.Image, filename, lastModified, true, picture.VersionId + 1, updatedBy, pictureMetaData);
Assert.AreEqual(webPictureResponse.AffectedRows, 1);
Assert.IsTrue(webPictureResponse.Id > 0);
newPictureMetaData = WebServiceProxy.PictureService.GetPictureMetaDataById(GetClientInformation(), webPictureResponse.Id, pictureMetaDataIds);
Assert.IsNotNull(newPictureMetaData);
Assert.IsTrue(newPictureMetaData.IsNotEmpty());
Assert.AreEqual(pictureMetaData.Count, newPictureMetaData.Count);
for (int i = 0; i < newPictureMetaData.Count; i++)
{
Assert.AreEqual(pictureMetaData[i].PictureMetaDataId, newPictureMetaData[i].PictureMetaDataId);
Assert.AreEqual(pictureMetaData[i].Value, newPictureMetaData[i].Value);
}
affectedRows = WebServiceProxy.PictureService.DeletePictureMetaData(GetClientInformation(), webPictureResponse.Id, pictureMetaData);
Assert.AreEqual(affectedRows, pictureMetaData.Count);
affectedRows = WebServiceProxy.PictureService.DeletePictureFilename(GetClientInformation(), null, filename, picture.PictureStringId);
Assert.AreEqual(affectedRows, 4);
}
}
public void GetPictureById_Resized640x480()
{
Int64 pictureId = 2;
WebPicture webPicture = WebServiceProxy.PictureService.GetPictureById(GetClientInformation(), pictureId, 480, 640, 0, true, string.Empty);
Assert.IsNotNull(webPicture);
Assert.AreEqual(pictureId, webPicture.Id);
Assert.IsNotNull(webPicture.Image);
Assert.IsTrue(webPicture.Size != webPicture.OriginalSize);
}
public void GetPictureById_Get100x100Thumbnail()
{
Int64 pictureId = 2;
WebPicture webPicture = WebServiceProxy.PictureService.GetPictureById(GetClientInformation(), pictureId, 100, 100, 0, true, string.Empty);
Assert.IsNotNull(webPicture);
Assert.AreEqual(pictureId, webPicture.Id);
Assert.IsNotNull(webPicture.Image);
Assert.IsTrue(webPicture.Size < webPicture.OriginalSize);
}
public void GetPictureById()
{
Int64 pictureId = 2;
WebPicture webPicture = WebServiceProxy.PictureService.GetPictureById(GetClientInformation(), pictureId, null, null, 0, false, string.Empty);
Assert.IsNotNull(webPicture);
Assert.AreEqual(pictureId, webPicture.Id);
Assert.IsNotNull(webPicture.Image);
Assert.IsTrue(webPicture.Size == webPicture.OriginalSize);
}
public int DeleteWebPicture(int WebPictureID)
{
using (AIYunNetContext context = new AIYunNetContext())
{
WebPicture WebPicture = context.WebPicture.Find(WebPictureID);
if (WebPicture != null)
{
WebPicture.FlagDelete = 1;
WebPicture.DeleteOn = DateTime.Now;
context.SaveChanges();
return(1);
}
else
{
return(0);
}
}
}
//웹이미지 로딩이 실패한 경우에 대한 처리
private void WebImageLoadFailed(Image image, LongListMultiSelector selector)
{
BitmapImage img = image.Source as BitmapImage;
string errorUrl = img.UriSource.OriginalString;
string decodedErrorUrl = HttpUtility.UrlDecode(errorUrl);
for (int i = 0; i < selector.ItemsSource.Count; i++)
{
WebPicture pic = (WebPicture)selector.ItemsSource[i];
if (pic.Path == errorUrl || pic.Path == decodedErrorUrl)
{
selector.ItemsSource.Remove(pic);//
}
}
image.Source = null;
img.UriSource = null;
}
public int UpdateWebPicture(WebPicture WebPicture)
{
using (AIYunNetContext context = new AIYunNetContext())
{
if (WebPicture != null)
{
WebPicture origWebPicture = context.WebPicture.Find(WebPicture.PictureID);
if (origWebPicture != null)
{
origWebPicture.PictureName = WebPicture.PictureName;
origWebPicture.PictureImg = WebPicture.PictureImg;
origWebPicture.thumbnailImage = WebPicture.thumbnailImage;
origWebPicture.WebImgID = WebPicture.WebImgID;
origWebPicture.EditOn = DateTime.Now;
context.SaveChanges();
}
}
return(1);
}
}
public void UpdatePictures()
{
Int64 pictureId = 33;
WebPicture oldPicture = WebServiceProxy.PictureService.GetPictureById(GetClientInformation(), pictureId, 50, 50, 0, false, string.Empty);
List <WebPicture> updatePictures = new List <WebPicture>
{
new WebPicture
{
Id = pictureId,
IsPublic = true,
IsArchived = true,
LastUpdated = DateTime.Now,
UpdatedBy = "test test"
}
};
String updatedBy = "test test";
Int32 affectedRows;
using (IWebServiceTransaction transaction = new WebServiceTransaction(GetClientInformation(), WebServiceProxy.PictureService))
{
affectedRows = WebServiceProxy.PictureService.UpdatePictures(GetClientInformation(), updatePictures, updatedBy);
Assert.IsTrue((affectedRows > 0) && (affectedRows == updatePictures.Count));
WebPicture updatedPicture = WebServiceProxy.PictureService.GetPictureById(GetClientInformation(), pictureId, 50, 50, 0, false, string.Empty);
Assert.AreEqual(pictureId, updatedPicture.Id);
Assert.AreEqual(updatePictures[0].IsPublic, updatedPicture.IsPublic);
Assert.AreEqual(updatePictures[0].IsArchived, updatedPicture.IsArchived);
Assert.IsTrue(updatePictures[0].LastUpdated <= updatedPicture.LastUpdated);
Assert.AreEqual(updatePictures[0].UpdatedBy, updatedPicture.UpdatedBy);
affectedRows = WebServiceProxy.PictureService.UpdatePictures(GetClientInformation(), new List <WebPicture> {
oldPicture
}, updatedBy);
Assert.IsTrue((affectedRows > 0) && (affectedRows == 1));
}
}
