public void Update(Models.ArtworkTag artworkTag) { var existing = db.ArtworkTags.SingleOrDefault(x => x.Id == artworkTag.Id); if (existing != null) { existing.TagId = artworkTag.TagId; db.SaveChanges(); } }
public int Insert(Models.ArtworkTag artworkTag) { tblArtworkTag newArtworkTag = new Data1.tblArtworkTag { ArtworkId = artworkTag.ArtworkId, TagId = artworkTag.TagId }; db.ArtworkTags.Add(newArtworkTag); db.SaveChanges(); return(newArtworkTag.Id); }
public void DeleteTest() { ArtworkTag artworkTag = new ArtworkTag(); List <Models.ArtworkTag> artworkTags = new List <Models.ArtworkTag>(); artworkTags = artworkTag.Load(); Models.ArtworkTag row = artworkTags.Where(x => x.Id == 2).FirstOrDefault(); if (row != null) { bool actual = artworkTag.Delete(row.Id); Assert.IsTrue(actual == true); } }
public void UpdateTest() { ArtworkTag artworkTag = new ArtworkTag(); List <Models.ArtworkTag> artworkTags = new List <Models.ArtworkTag>(); artworkTags = artworkTag.Load(); Models.ArtworkTag row = artworkTags.Where(m => m.Id == 3).FirstOrDefault(); row.ArtworkId = 1; artworkTag.Update(row); List <Models.ArtworkTag> updated = new List <Models.ArtworkTag>(); updated = artworkTag.Load(); Models.ArtworkTag updatedArtworkTag = updated.Where(x => x.Id == 3).FirstOrDefault(); Assert.AreNotEqual(updatedArtworkTag, row); }