private void MapToDatabase(tblPersonalProject project)
{
project.Name = Name;
project.Languages = Languages;
project.Description = Description;
project.GitHubRepository = GitHubRepository;
project.Demonstration = Demonstration;
}
private void MapToObject(tblPersonalProject project)
{
Id = project.Id;
Name = project.Name;
Languages = project.Languages;
Description = project.Description;
GitHubRepository = project.GitHubRepository;
Demonstration = project.Demonstration;
}
public void DeleteTest()
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
{
tblPersonalProject project = oDc.tblPersonalProjects.FirstOrDefault(pp => pp.Id == 4);
oDc.tblPersonalProjects.Remove(project);
oDc.SaveChanges();
tblPersonalProject deletedProject = oDc.tblPersonalProjects.FirstOrDefault(pp => pp.Id == 4);
Assert.IsNull(deletedProject);
}
}
public void UpdateTest()
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
{
tblPersonalProject project = oDc.tblPersonalProjects.FirstOrDefault(pp => pp.Id == 4);
project.Languages = "C++";
oDc.SaveChanges();
tblPersonalProject updatedProject = oDc.tblPersonalProjects.FirstOrDefault(pp => pp.Id == 4);
Assert.AreEqual(updatedProject.Languages, project.Languages);
}
}
public void InsertTest()
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
{
tblPersonalProject newRow = new tblPersonalProject();
newRow.Name = "Test Project";
newRow.Languages = "C#";
newRow.GitHubRepository = "Test Repo";
newRow.Description = "Test Description";
newRow.Demonstration = "Test Demonstration";
oDc.tblPersonalProjects.Add(newRow);
oDc.SaveChanges();
tblPersonalProject projects = oDc.tblPersonalProjects.FirstOrDefault(pp => pp.Id == 4);
Assert.IsNotNull(projects);
}
}
public void Delete()
{
try
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
{
tblPersonalProject project = oDc.tblPersonalProjects.FirstOrDefault(p => p.Id == Id);
oDc.tblPersonalProjects.Remove(project);
oDc.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Insert()
{
try
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
{
tblPersonalProject project = new tblPersonalProject();
MapToDatabase(project);
oDc.tblPersonalProjects.Add(project);
oDc.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
