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