public void TestProjectDelete()
{
var Project_bll = new sp_Project_BLL();
var allProjects = Project_bll.ListProjects();
Assert.IsTrue(allProjects.Count > 0, "The ListProjects() is broken, or no data in DB");
var currProject = allProjects[0];
//TODO: change activeflg to bool not bool?
var notActive = currProject.ActiveFlg != true;
var i = 1;
while (notActive)
{
currProject = allProjects[i];
notActive = currProject.ActiveFlg != true;
}
Project_bll.DeleteProjectContext(currProject);
var selectedProject = Project_bll.ListProjects(currProject.ProjectID);
//TODO: change activeflg to bool not bool?
Assert.IsNotNull(selectedProject.ActiveFlg);
Assert.IsFalse(selectedProject.ActiveFlg == true);
Assert.IsTrue(selectedProject.ActiveFlg == false);
}
public void TestProjectCreate()
{
string ProjectName = "TestProject";
string ProjectDesc = "We Rock!";
bool ActiveFlg = true;
var Project_bll = new sp_Project_BLL();
var Project_dm = new sp_Project_DM();
var VendAdress_bll = new sp_VendAddress_BLL();
Project_dm.ProjectName = ProjectName;
Project_dm.ProjectDesc = ProjectDesc;
var allAddresses = VendAdress_bll.ListAddresses();
Assert.IsTrue(allAddresses.Count > 0, "The ListAddresses() is broken, or no data in DB");
Project_dm.AddrID = allAddresses[0].AddrID;
Project_dm.ActiveFlg = ActiveFlg;
var ProjectID = Project_bll.InsertProjectContext(ref Project_dm).ProjectID;
Project_dm.ProjectID = ProjectID;
var Project_dm_selected = Project_bll.ListProjects(ProjectID);
Assert.IsTrue(Equals(Project_dm, Project_dm_selected));
}
public void TestProjectEventCreate()
{
DateTime StartDate = new DateTime(2014, 05, 01, 10, 0, 0);
DateTime EndDate = new DateTime(2014, 05, 02, 11, 0, 0);
var ProjectEvent_bll = new sp_ProjectEvent_BLL();
var ProjectEvent_dm = new sp_ProjectEvent_DM();
var Project_bll = new sp_Project_BLL();
var VendAdress_bll = new sp_VendAddress_BLL();
ProjectEvent_dm.StartDateTime = StartDate;
ProjectEvent_dm.EndDateTime = EndDate;
var allProjects = Project_bll.ListProjects();
Assert.IsTrue(allProjects.Count > 0, "The ListProjects() is broken, or no data in DB");
ProjectEvent_dm.ProjectID = allProjects[0].ProjectID;
var allAddresses = VendAdress_bll.ListAddresses();
Assert.IsTrue(allAddresses.Count > 0, "The ListAddresses() is broken, or no data in DB");
ProjectEvent_dm.AddrID = allAddresses[0].AddrID;
//var ProjectID = ProjectEvent_bll.InsertEventContext(ref ProjectEvent_dm).ProjectID;
//ProjectEvent_dm.ProjectID = ProjectID;
//var ProjectEvent_dm_selected = ProjectEvent_bll.ListEvents(ProjectID);
//Assert.IsTrue(Equals(ProjectEvent_dm, ProjectEvent_dm_selected));
}
public void TestProjectRead()
{
//Pull our data from the excel file
string helperDir = cExcel.GetHelperFilesDir();
DataTable dt = cExcel.ReadExcelFile("Sheet1", Path.Combine(helperDir, "Project.xlsx"));
var excelDMs = DMsFrom(dt);
//Pull our data directly from the DB
var numRows = cExcel.getNumRecordsFromDB("[Vend].[tblProject]");
//Pull our data from the DB through the BLL
var Project_bll = new sp_Project_BLL();
var allProjects = Project_bll.ListProjects();
//Test the data from the BLL
Assert.AreEqual(numRows, allProjects.Count);
foreach (var testProject in excelDMs)
{
var selectedProject = Project_bll.ListProjects(testProject.ProjectID);
Assert.IsTrue(Equals(testProject, selectedProject));
}
}
public void TestProjectUpdate()
{
var Project_bll = new sp_Project_BLL();
var allProjects = Project_bll.ListProjects();
Assert.IsTrue(allProjects.Count > 0, "The ListProjects() is broken, or no data in DB");
var firstProject = allProjects[0];
var newProjectName = "Updated Project Name";
firstProject.ProjectName = newProjectName;
Project_bll.UpdateProjectContext(firstProject);
var selectedProject = Project_bll.ListProjects(firstProject.ProjectID);
Assert.IsTrue(Equals(firstProject, selectedProject));
Assert.AreEqual(newProjectName, selectedProject.ProjectName);
}
