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 LoadTest()
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
{
int expected = 3;
var projects = (from pp in oDc.tblPersonalProjects
select pp).ToList();
int actual = projects.Count;
Assert.AreEqual(expected, actual);
}
}
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 Load()
{
try
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
oDc.tblPersonalProjects.OrderByDescending(p => p.Id).ToList().ForEach(p => Add(new PersonalProject(p.Id, p.Name, p.Languages, p.Description, p.GitHubRepository, p.Demonstration)));
}
catch (Exception ex)
{
throw ex;
}
}
public void Load()
{
try
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
oDc.tblUsers.ToList().ForEach(u => Add(new User(u.Id, u.UserId, u.FirstName, u.LastName, u.UserPass)));
}
catch (Exception ex)
{
throw ex;
}
}
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;
}
}
public bool Login()
{
try
{
if (!String.IsNullOrWhiteSpace(UserId))
{
if (!String.IsNullOrWhiteSpace(UserPass))
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
{
tblUser user = oDc.tblUsers.FirstOrDefault(u => u.UserId == UserId);
if (user != null)
{
if (user.UserPass == GetHash())
{
FirstName = user.FirstName;
LastName = user.LastName;
Id = user.Id;
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
}
else
{
throw new Exception("Password needs to be set.");
}
}
else
{
throw new Exception("UserId needs to be set.");
}
}
catch (Exception ex)
{
throw ex;
}
}
public void LoadById()
{
try
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
{
var project = oDc.tblPersonalProjects.FirstOrDefault(p => p.Id == Id);
if (project != null)
{
MapToObject(project);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void Insert()
{
try
{
using (PersonalProjectEntities oDc = new PersonalProjectEntities())
{
tblUser user = new tblUser();
Map(user);
user.Id = oDc.tblUsers.Any() ? oDc.tblUsers.Max(u => u.Id) + 1 : 1;
oDc.tblUsers.Add(user);
oDc.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
