public void DeleteTest()
{
Artwork artwork = new Artwork();
List <Models.Artwork> artworks = new List <Models.Artwork>();
artworks = artwork.Load();
Models.Artwork row = artworks.Where(x => x.Id == 2).FirstOrDefault();
if (row != null)
{
bool actual = artwork.Delete(row.Id);
Assert.IsTrue(actual == true);
}
}
public void Update(Models.Artwork artwork)
{
var existing = db.Artworks.SingleOrDefault(x => x.Id == artwork.Id);
if (existing != null)
{
existing.GalleryId = artwork.GalleryId;
existing.Title = artwork.Title;
existing.Price = artwork.Price;
existing.IsCommission = artwork.IsCommission;
existing.TagId = artwork.TagId;
existing.CollectionMessageId = artwork.CollectionMessageId;
existing.DateCreated = artwork.DateCreated;
db.SaveChanges();
}
}
public void UpdateTest()
{
Artwork artwork = new Artwork();
List <Models.Artwork> artworks = new List <Models.Artwork>();
artworks = artwork.Load();
Models.Artwork row = artworks.Where(m => m.Id == 1).FirstOrDefault();
row.Title = "UPDATED: Test Art.";
artwork.Update(row);
List <Models.Artwork> updated = new List <Models.Artwork>();
updated = artwork.Load();
Models.Artwork updatedArtwork = updated.Where(x => x.Id == 1).FirstOrDefault();
Assert.AreNotEqual(updatedArtwork, row);
}
public int Insert(Models.Artwork artwork, Models.File file)
{
tblCollection newCollection = new tblCollection {
MessageTypeId = 3
};
db.Collections.Add(newCollection);
db.SaveChanges();
tblArtwork tblArtwork = new tblArtwork {
GalleryId = artwork.GalleryId,
Title = artwork.Title,
Price = artwork.Price,
IsCommission = artwork.IsCommission,
TagId = artwork.TagId,
CollectionMessageId = newCollection.Id,
DateCreated = DateTime.Now
};
db.Artworks.Add(tblArtwork);
db.SaveChanges();
tblFiles tblFiles = new tblFiles
{
FileName = file.FileName,
ContentType = file.ContentType,
Content = file.Content,
FileType = tblFileType.Photo,
ArtworkId = artwork.Id,
UserId = file.UserId,
Artwork = tblArtwork
};
db.Files.Add(tblFiles);
db.SaveChanges();
return(tblArtwork.Id);
}
public Models.Artwork LoadById(int id)
{
var artwork = db.Artworks.FirstOrDefault(a => a.Id == id);
if (artwork != null)
{
Models.Artwork a = new Models.Artwork
{
Id = artwork.Id,
GalleryId = artwork.GalleryId.GetValueOrDefault(),
Title = artwork.Title,
Price = artwork.Price.GetValueOrDefault(),
IsCommission = artwork.IsCommission.GetValueOrDefault(),
TagId = artwork.TagId.GetValueOrDefault(),
CollectionMessageId = artwork.CollectionMessageId.GetValueOrDefault(),
DateCreated = artwork.DateCreated
};
return(a);
}
else
{
return(null);
}
}
