public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid privacyGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblPrivacy privacy = dc.tblPrivacies.FirstOrDefault(u => u.Id == privacyGuid);
dc.tblPrivacies.Remove(privacy);
dc.SaveChanges();
tblPrivacy deletedPrivacy = dc.tblPrivacies.FirstOrDefault(u => u.Id == privacyGuid);
Assert.IsNull(deletedPrivacy);
}
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test privacy based on ID and update it
Guid privacyGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblPrivacy privacy = dc.tblPrivacies.FirstOrDefault(u => u.Id == privacyGuid);
privacy.Description = "UpdatedPrivacy";
//Save changes and get it back out
dc.SaveChanges();
tblPrivacy updatedPrivacy = dc.tblPrivacies.FirstOrDefault(u => u.Description == "UpdatedPrivacy");
//Make sure the Ids match
Assert.AreEqual(privacy.Id, updatedPrivacy.Id);
}
}
public void LoadById(Guid id)
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblPrivacy privacy = dc.tblPrivacies.Where(p => p.Id == id).FirstOrDefault();
if (privacy != null)
{
Id = privacy.Id;
Description = privacy.Description;
}
else
{
throw new Exception("Privacy not found");
}
}
}
catch (Exception ex) { throw ex; }
}
public int Update()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblPrivacy privacy = dc.tblPrivacies.Where(p => p.Id == Id).FirstOrDefault();
if (privacy != null)
{
privacy.Description = Description;
return(dc.SaveChanges());
}
else
{
throw new Exception("Privacy not found");
}
}
}
catch (Exception ex) { throw ex; }
}
public int Insert()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblPrivacy privacy = new tblPrivacy()
{
Id = Guid.NewGuid(),
Description = Description
};
//Save the Id
this.Id = privacy.Id;
dc.tblPrivacies.Add(privacy);
return(dc.SaveChanges());
}
}
catch (Exception ex) { throw ex; }
}
public void InsertTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Create a privacy
tblPrivacy privacy = new tblPrivacy
{
//Privacy a GUID for testing purposes
Id = Guid.Parse("11112222-3333-4444-5555-666677778888"),
Description = "Test"
};
//Add the privacy to the database
dc.tblPrivacies.Add(privacy);
//Commit changes
int rowsInserted = dc.SaveChanges();
Assert.IsTrue(rowsInserted == 1);
}
}
