private void GetAllProjects() { ProjectSqlDAL dal = new ProjectSqlDAL(DatabaseConnection); List <Project> projects = dal.GetAllProjects(); if (projects.Count > 0) { projects.ForEach(proj => { Console.WriteLine(proj); }); } else { Console.WriteLine("**** NO RESULTS ****"); } }
private void RemoveEmployeeFromProject() { int projectId = CLIHelper.GetInteger("Which project id is the employee removed from:"); int employeeId = CLIHelper.GetInteger("Which employee is getting removed:"); ProjectSqlDAL dal = new ProjectSqlDAL(DatabaseConnection); bool result = dal.RemoveEmployeeFromProject(projectId, employeeId); if (result) { Console.WriteLine("*** SUCCESS ***"); } else { Console.WriteLine("*** DID NOT CREATE ***"); } }
private void AssignEmployeeToProject() { int projectId = CLIHelper.GetInteger("Which project id is the employee assigned to:"); int employeeId = CLIHelper.GetInteger("Which employee is getting added:"); ProjectSqlDAL dal = new ProjectSqlDAL(DatabaseConnection); bool result = dal.AssignEmployeeToProject(projectId, employeeId); if (result) { Console.WriteLine("*** SUCCESS ***"); } else { Console.WriteLine("*** DID NOT CREATE ***"); } }
private void GetAllProjects() { ProjectSqlDAL dal = new ProjectSqlDAL(DatabaseConnection); IList <Project> projects = dal.GetAllProjects(); if (projects.Count > 0) { foreach (Project proj in projects) { Console.WriteLine(proj.ProjectId.ToString().PadRight(5) + proj.Name.PadRight(20) + proj.StartDate.ToShortDateString().PadRight(10) + proj.EndDate.ToShortDateString().PadRight(10)); } } else { Console.WriteLine("**** NO RESULTS ****"); } }
public void ProjectsTest() { Project thisProj = new Project(); thisProj.Name = "TESTprojTEST"; thisProj.StartDate = DateTime.Now; thisProj.EndDate = DateTime.Now; ProjectSqlDAL psdTest = new ProjectSqlDAL(connectionString); Assert.AreEqual(true, psdTest.CreateProject(thisProj)); Assert.AreEqual(projectCount + 1, psdTest.GetAllProjects().Count); Assert.AreEqual(true, psdTest.AssignEmployeeToProject(projectCount, 1)); Assert.AreEqual(true, psdTest.RemoveEmployeeFromProject(projectCount, 1)); Assert.AreNotEqual(true, psdTest.RemoveEmployeeFromProject(projectCount + 1, 1)); }
public void TestCreateProject() { //Arrange ProjectSqlDAL projectDAL = new ProjectSqlDAL(connectionString); Project updatedProject = new Project(); updatedProject.Name = "UpdatedProjectName"; updatedProject.StartDate = DateTime.Now; updatedProject.EndDate = updatedProject.StartDate.AddYears(1); //Act bool successChange = projectDAL.CreateProject(updatedProject); List <Project> projects = projectDAL.GetAllProjects(); //Assert Assert.AreEqual(projectCount + 1, projects.Count); }
public void CreateProjectTest() { //Arrange ProjectSqlDAL projectDAL = new ProjectSqlDAL(connectionString); Project newProj = new Project() { Name = "TechElevator", StartDate = new DateTime(2018, 01, 29), EndDate = new DateTime(2018, 05, 04) }; //Act bool wasSuccessful = projectDAL.CreateProject(newProj); //Assert Assert.AreEqual(true, wasSuccessful); }
public void CreateProjectTest() { //Arrange int originalCount = GetNumberOfProjects(); ProjectSqlDAL dal = new ProjectSqlDAL(ConnectionString); Project newProj = new Project { Name = "New Project 2", StartDate = DateTime.Now, EndDate = DateTime.Now }; //Act bool result = dal.CreateProject(newProj); //Assert Assert.IsTrue(result); Assert.AreEqual(originalCount + 1, GetNumberOfProjects()); }
public void TestAssignEmployee() { //Arrange ProjectSqlDAL projectDAL = new ProjectSqlDAL(connectionString); //Act bool employeeAssigned = projectDAL.AssignEmployeeToProject(1, 1); //Assert int alteredprojects = 0; using (SqlConnection connection = new SqlConnection(connectionString)) { SqlCommand cmd; connection.Open(); cmd = new SqlCommand("SELECT COUNT(*) FROM project_employee;", connection); alteredprojects = (int)cmd.ExecuteScalar(); } Assert.AreEqual(employeeProjectCount + 1, alteredprojects); }
public void RemoveEmployeeFromProjectTest() { ProjectSqlDAL newProject = new ProjectSqlDAL(connectionString); bool worked = newProject.RemoveEmployeeFromProject(projectId, employeeId); }
public void AssignEmployeeToProjectTest() { ProjectSqlDAL newProject = new ProjectSqlDAL(connectionString); bool worked = newProject.AssignEmployeeToProject(projectId, employeeId); }