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