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