public void TestEmployeeInsert() { Employee testEmployee = new Employee(Employee.GenerateNextEid(), "UnitTestEmployee", "UnitTestLname", "", "", 0); Assert.True(testEmployee.Insert()); testEmployee.Delete(); }
public void TestSearchEmployeesWithValidQueryWithCloseFname() { int eid1 = Employee.GenerateNextEid(); Employee e1 = new Employee(eid1, "SearchFname1", "SearchLname1", "", "", 1); e1.Insert(); int eid2 = Employee.GenerateNextEid(); Employee e2 = new Employee(eid2, "SearchFname2", "SearchLname2", "", "", 1); e2.Insert(); List<string> db = new List<string>(); db.Add("fname"); List<string> s = new List<string>(); s.Add("Search"); Search search = new Search("Employee"); search.UseInputs(db, s); List<Employee> e = Search.SearchEmployees(search.GetBuiltQuery()); Assert.True(e.Count >= 2); e1.Delete(); e2.Delete(); }
public void TestGetSetEid() { Employee e = new Employee(1); Assert.True(e.Eid == 1); e.Eid = 2; Assert.True(e.Eid == 2); }
public void TestGetEmployees() { Employee testEmployee = new Employee(Employee.GenerateNextEid(), "UnitTestEmployee", "UnitTestLname", "", "", 0); testEmployee.Insert(); List<Employee> employees = Employee.GetEmployees(); Assert.IsNotEmpty(employees); testEmployee.Delete(); }
public void TestEmployeeUpdate() { Employee testEmployee = new Employee(Employee.GenerateNextEid(), "UnitTestEmployee", "UnitTestLname", "", "", 0); testEmployee.Insert(); testEmployee.Fname = "ChangedName"; Assert.True(testEmployee.Update()); testEmployee.Delete(); }
/* Returns a list of employees based on query built from entries in UI */ public static List<Employee> SearchEmployees(string queryBuilt) { List<Employee> getEmployees = new List<Employee>(); try { List<object[]> employeeList = Database.Select(queryBuilt); if(employeeList != null) foreach (object[] row in employeeList) { Employee newEmployee = new Employee(Convert.ToInt32(row[0]), row[1].ToString(), row[2].ToString(), row[3].ToString(), row[4].ToString(), Convert.ToInt32(row[5])); getEmployees.Add(newEmployee); } } catch (Exception) { System.Windows.MessageBox.Show("Error getting data from database and/or converting"); } return getEmployees; }
public void TestSearchEmployeeWithMultipleExactFields() { int eid1 = Employee.GenerateNextEid(); Employee e1 = new Employee(eid1, "SearchFname1", "SearchLname1", "Spec1", "Doctor", 100000); e1.Insert(); int eid2 = Employee.GenerateNextEid(); Employee e2 = new Employee(eid2, "SearchFname2", "SearchLname2", "Spec2", "Nurse", 120000); e2.Insert(); List<string> db = new List<string>(); db.Add("fname"); db.Add("lname"); db.Add("specialty"); List<string> s = new List<string>(); s.Add("SearchFname1"); s.Add("SearchLname1"); s.Add("Spec1"); Search search = new Search("Employee"); search.UseInputs(db, s); List<Employee> e = Search.SearchEmployees(search.GetBuiltQuery()); Assert.True(e[0].Eid == eid1); e1.Delete(); e2.Delete(); }
public void TestSearchEmployeesWithValidQueryWithOtherSpecialty() { int eid1 = Employee.GenerateNextEid(); Employee e1 = new Employee(eid1, "SearchFname1", "SearchLname1", "Spec1", "Doctor", 100000); e1.Insert(); int eid2 = Employee.GenerateNextEid(); Employee e2 = new Employee(eid2, "SearchFname2", "SearchLname2", "Spec2", "Nurse", 120000); e2.Insert(); List<string> db = new List<string>(); db.Add("specialty"); List<string> s = new List<string>(); s.Add("Spec"); Search search = new Search("Employee"); search.UseInputs(db, s); List<Employee> e = Search.SearchEmployees(search.GetBuiltQuery()); Assert.True(e.Count >= 2); e1.Delete(); e2.Delete(); }
public void TestSearchEmployeesWithValidQueryWithExactType() { int eid1 = Employee.GenerateNextEid(); Employee e1 = new Employee(eid1, "SearchFname1", "SearchLname1", "", "Type1", 100000); e1.Insert(); int eid2 = Employee.GenerateNextEid(); Employee e2 = new Employee(eid2, "SearchFname2", "SearchLname2", "", "Type2", 120000); e2.Insert(); List<string> db = new List<string>(); db.Add("employee_type"); List<string> s = new List<string>(); s.Add("Type1"); Search search = new Search("Employee"); search.UseInputs(db, s); List<Employee> e = Search.SearchEmployees(search.GetBuiltQuery()); //Assert.True(e[0].Eid == eid1); e1.Delete(); e2.Delete(); }
public void TestGetSetSpecialty() { Employee e = new Employee(); e.Specialty = "Test"; Assert.True(e.Specialty == "Test"); }
public void TestGetSetLname() { Employee e = new Employee(); e.Lname = "Test"; Assert.True(e.Lname == "Test"); }
public void TestGetSetType() { Employee e = new Employee(); e.Employee_type = "Test"; Assert.True(e.Employee_type == "Test"); }
public void TestGetSetSupervisor() { Employee e = new Employee(); e.Supervisor_id = 1; Assert.True(e.Supervisor_id == 1); }
public EmployeeInformation(Employee Employee) { InitializeComponent(); _isNewEmployee = false; //A new employee will not have an employee id to reference employee = Employee; }
//Required for databinding -- END public EmployeeInformation() { InitializeComponent(); employee = new Employee(); generatedEID.Content = Employee.GenerateNextEid(); //Show the next EID when page loads }
//Send in empty string if no search public static List<Employee> GetEmployees() { List<object[]> employeeList = Database.Select("Select * FROM Employee"); List<Employee> getEmployees = new List<Employee>(); if (employeeList != null) foreach (object[] row in employeeList) { Employee newEmployee = new Employee(Convert.ToInt32(row[0]), row[1].ToString(), row[2].ToString(), row[3].ToString(), row[4].ToString(), Convert.ToInt32(row[5])); getEmployees.Add(newEmployee); } return getEmployees; }