public void DeleteTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
Guid projectLanguageGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblProjectLanguage projectLanguage = dc.tblProjectLanguages.FirstOrDefault(p => p.Id == projectLanguageGuid);
dc.tblProjectLanguages.Remove(projectLanguage);
dc.SaveChanges();
tblProjectLanguage deletedProjectLanguage = dc.tblProjectLanguages.FirstOrDefault(p => p.Id == projectLanguageGuid);
Assert.IsNull(deletedProjectLanguage);
}
}
public int Insert()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblProjectLanguage projectlanguage = new tblProjectLanguage();
projectlanguage.Id = Guid.NewGuid();
projectlanguage.ProjectId = this.ProjectId;
projectlanguage.LanguageId = this.LanguageId;
this.Id = projectlanguage.Id;
dc.tblProjectLanguages.Add(projectlanguage);
return(dc.SaveChanges());
}
}
catch (Exception ex) { throw ex; }
}
public Guid?CheckIfExists()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblProjectLanguage projectlanguage = dc.tblProjectLanguages.Where(pl => pl.ProjectId == this.ProjectId && pl.LanguageId == this.LanguageId).FirstOrDefault();
if (projectlanguage != null)
{
return(projectlanguage.Id);
}
else
{
return(Guid.Empty);
}
}
}
catch (Exception ex) { throw ex; }
}
public void UpdateTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Retrieve test user based on ID and update it
Guid projectLanguageGuid = Guid.Parse("11112222-3333-4444-5555-666677778888");
tblProjectLanguage projectLanguage = dc.tblProjectLanguages.FirstOrDefault(p => p.Id == projectLanguageGuid);
Guid languageGuid = Guid.Parse("88887777-6666-5555-4444-333322221111");
projectLanguage.LanguageId = languageGuid;
//Save changes and get it back out
dc.SaveChanges();
tblProjectLanguage updatedProjectLanguage = dc.tblProjectLanguages.FirstOrDefault(p => p.LanguageId == languageGuid);
//Make sure the Ids match
Assert.AreEqual(projectLanguage.Id, updatedProjectLanguage.Id);
}
}
public int Delete()
{
try
{
using (PortfolioEntities dc = new PortfolioEntities())
{
tblProjectLanguage projectlanguage = dc.tblProjectLanguages.Where(pl => pl.Id == this.Id).FirstOrDefault();
if (projectlanguage != null)
{
dc.tblProjectLanguages.Remove(projectlanguage);
return(dc.SaveChanges());
}
else
{
throw new Exception("ProjectLanguage not found");
}
}
}
catch (Exception ex) { throw ex; }
}
public void InsertTest()
{
using (PortfolioEntities dc = new PortfolioEntities())
{
//Create a user
tblProjectLanguage projectLanguage = new tblProjectLanguage
{
//User a GUID for testing purposes
Id = Guid.Parse("11112222-3333-4444-5555-666677778888"),
LanguageId = Guid.NewGuid(),
ProjectId = Guid.NewGuid()
};
//Add the user to the database
dc.tblProjectLanguages.Add(projectLanguage);
//Commit changes
int rowsInserted = dc.SaveChanges();
Assert.IsTrue(rowsInserted == 1);
}
}
