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