public void DeleteTest() { using (PortfolioEntities dc = new PortfolioEntities()) { Guid screenshotGuid = Guid.Parse("11112222-3333-4444-5555-666677778888"); tblScreenshot screenshot = dc.tblScreenshots.FirstOrDefault(s => s.Id == screenshotGuid); dc.tblScreenshots.Remove(screenshot); dc.SaveChanges(); tblScreenshot deletedScreenshot = dc.tblScreenshots.FirstOrDefault(s => s.Id == screenshotGuid); Assert.IsNull(deletedScreenshot); } }
public void UpdateTest() { using (PortfolioEntities dc = new PortfolioEntities()) { //Retrieve test screenshot based on ID and update it Guid screenshotGuid = Guid.Parse("11112222-3333-4444-5555-666677778888"); tblScreenshot screenshot = dc.tblScreenshots.FirstOrDefault(s => s.Id == screenshotGuid); Guid projectGuid = Guid.Parse("88887777-6666-5555-4444-333322221111"); screenshot.ProjectId = projectGuid; //Save changes and get it back out dc.SaveChanges(); tblScreenshot updatedScreenshot = dc.tblScreenshots.FirstOrDefault(s => s.ProjectId == projectGuid); //Make sure the Ids match Assert.AreEqual(screenshot.Id, updatedScreenshot.Id); } }
public static int Delete(Guid id) { try { using (PortfolioEntities dc = new PortfolioEntities()) { tblScreenshot screenshot = dc.tblScreenshots.Where(s => s.Id == id).FirstOrDefault(); if (screenshot != null) { dc.tblScreenshots.Remove(screenshot); return(dc.SaveChanges()); } else { throw new Exception("Screenshot not found"); } } } catch (Exception ex) { throw ex; } }
public int Update() { try { using (PortfolioEntities dc = new PortfolioEntities()) { tblScreenshot screenshot = dc.tblScreenshots.Where(s => s.Id == Id).FirstOrDefault(); if (screenshot != null) { screenshot.Filepath = FilePath; screenshot.ProjectId = ProjectId; return(dc.SaveChanges()); } else { throw new Exception("Screenshot not found"); } } } catch (Exception ex) { throw ex; } }
public int Insert() { try { using (PortfolioEntities dc = new PortfolioEntities()) { tblScreenshot screenshot = new tblScreenshot() { Id = Guid.NewGuid(), Filepath = FilePath, ProjectId = ProjectId }; //Save the Id this.Id = screenshot.Id; dc.tblScreenshots.Add(screenshot); return(dc.SaveChanges()); } } catch (Exception ex) { throw ex; } }
public void InsertTest() { using (PortfolioEntities dc = new PortfolioEntities()) { //Create a screenshot tblScreenshot screenshot = new tblScreenshot { //Screenshot a GUID for testing purposes Id = Guid.Parse("11112222-3333-4444-5555-666677778888"), Filepath = "Test", ProjectId = Guid.NewGuid() }; //Add the screenshot to the database dc.tblScreenshots.Add(screenshot); //Commit changes int rowsInserted = dc.SaveChanges(); Assert.IsTrue(rowsInserted == 1); } }