public void AddUpdateDeleteDepartmentTest() { IDataController dtCtrl = LocalDataController.Instance; //Add a new department Department dept1 = new Department(); dept1.Name = "Dept1"; dept1.CompanyID = 4; dept1.SupDepartmentID = 0; dept1.ID = dtCtrl.AddDepartment(dept1); Assert.Greater(dept1.ID, 0); //Add a new sub-department Department dept2 = new Department(); dept2.Name = "Dept2"; dept2.CompanyID = 4; dept2.SupDepartmentID = dept1.ID; dept2.ID = dtCtrl.AddDepartment(dept2); Assert.Greater(dept2.ID, 0); //Add a empty named department Department dept3 = new Department(); dept3.Name = ""; dept3.CompanyID = 4; dept3.SupDepartmentID = 0; Assert.Less(dtCtrl.AddDepartment(dept3), 0); //Add a duplicated department Department dept4 = new Department(); dept4.Name = "Dept1"; dept4.CompanyID = 4; dept4.SupDepartmentID = 0; Assert.Less(dtCtrl.AddDepartment(dept4), 0); //Add a non-company department Department dept5 = new Department(); dept5.Name = "Dept5"; dept5.SupDepartmentID = 0; Assert.Less(dtCtrl.AddDepartment(dept5), 0); //Update an existing department Assert.AreEqual(true, dtCtrl.UpdateDepartment(dept1)); //Update an exist department using an exist Name dept1.Name = "Dept2"; Assert.AreEqual(false, dtCtrl.UpdateDepartment(dept1)); //Update an exist department using an empty Name dept1.Name = ""; Assert.AreEqual(false, dtCtrl.UpdateDepartment(dept1)); //Delete exist departments Assert.AreEqual(true, dtCtrl.DeleteDepartment(dept2.ID)); Assert.AreEqual(true, dtCtrl.DeleteDepartment(dept1.ID)); }
public void TestDeleteCompany() { Assert.AreEqual(true, _dtCtrl.DeleteCompany(com1.ID)); Assert.AreEqual(true, _dtCtrl.DeleteCompany(com2.ID)); Assert.AreEqual(null, _dtCtrl.GetCompany(com1.ID)); //delete again Assert.AreEqual(false, _dtCtrl.DeleteCompany(com1.ID)); Assert.AreEqual(false, _dtCtrl.DeleteCompany(-1)); //delete non-empty company com1.ID = _dtCtrl.AddCompany(com1); Department dep1 = new Department(); dep1.CompanyID = com1.ID; dep1.Name = "Dep1"; dep1.SupDepartmentID = 0; //root dep1.ID = _dtCtrl.AddDepartment(dep1); Assert.AreEqual(false, _dtCtrl.DeleteCompany(com1.ID)); _dtCtrl.DeleteDepartment(dep1.ID); Assert.AreEqual(true, _dtCtrl.DeleteCompany(com1.ID)); }
private void BindDepartment() { if (cbxCompany.SelectedValue != null) { int CompanyID = (int)cbxCompany.SelectedValue; List<Department> departmentList = _dtCtrl.GetDepartmentByCompany(CompanyID); Department department = new Department(); department.ID = 0; department.Name = "Root"; departmentList.Insert(0, department); cbxSupDepartment.DataSource = departmentList; } }
private void BindDepartment() { if (cbxCompany.SelectedValue != null) { int CompanyID = (int)cbxCompany.SelectedValue; if (CompanyID == -1) { cbxDepartment.Enabled = false; return; } cbxDepartment.Enabled = true; List<Department> departmentList = _dtCtrl.GetDepartmentByCompany(CompanyID); Department department = new Department(); department.ID = -1; department.Name = "All departments"; departmentList.Insert(0, department); cbxDepartment.DataSource = departmentList; } }
private List<Department> GetDepartmentListByGroup(int id) { OleDbCommand odCom = BuildSelectCmd("Department", "ID", "ID=@ID OR SupDepartmentID=@ID", new object[] { "@ID", id }); OleDbDataReader odRdr = odCom.ExecuteReader(); List<Department> departmentList = new List<Department>(); Department department = null; while (odRdr.Read()) { department = new Department(); department.ID = (int)odRdr["ID"]; departmentList.Add(department); } odRdr.Close(); return departmentList; }
public bool UpdateDepartment(Department department) { if (department == null || CheckExistDepartmentName(department.Name, department.CompanyID, department.ID)) return false; OleDbCommand odCom1 = BuildUpdateCmd("Department", new string[] { "Name", "CompanyID", "SupDepartmentID" }, new object[] { department.Name, department.CompanyID, department.SupDepartmentID }, "ID=@ID", new object[] { "@ID", department.ID } ); Department dep1 = GetDepartment(department.ID); if (dep1.SupDepartmentID != department.SupDepartmentID) { bool isRelationship = false; Department dep2 = GetDepartment(department.SupDepartmentID); while (dep2 != null) { if (dep2.ID == department.ID) { isRelationship = true; break; } dep2 = GetDepartment(dep2.SupDepartmentID); } if (isRelationship) { BeginTransaction(); OleDbCommand odCom2 = BuildUpdateCmd("Department", new string[] { "SupDepartmentID" }, new object[] { dep1.SupDepartmentID }, "ID=@ID", new object[] { "@ID", department.SupDepartmentID } ); odCom1.Transaction = transaction; int rs = ExecuteNonQuery(odCom1); int rs1 = ExecuteNonQuery(odCom2); if (rs > 0 && rs1 > 0) { CommitTransaction(); return true; } else { RollbackTransaction(); return false; } } } int rs2 = ExecuteNonQuery(odCom1); return rs2 > 0 ? true : false; }
public int AddDepartment(Department department) { if (department == null || CheckExistDepartmentName(department.Name, department.CompanyID, 0)) return -1; OleDbCommand odCom1 = BuildInsertCmd("Department", new string[] { "Name", "CompanyID", "SupDepartmentID" }, new object[] { department.Name, department.CompanyID, department.SupDepartmentID } ); if (ExecuteNonQuery(odCom1) == 1) { odCom1.CommandText = "SELECT @@IDENTITY"; int rs = Convert.ToInt32(odCom1.ExecuteScalar().ToString()); return rs; } return -1; }
public List<Department> GetDepartmentList() { OleDbCommand odCom = BuildSelectCmd("Department", "*", null); OleDbDataReader odRdr = odCom.ExecuteReader(); List<Department> departmentList = new List<Department>(); Department department = null; while (odRdr.Read()) { department = new Department(); department.ID = (int)odRdr["ID"]; department.Name = odRdr["Name"].ToString(); department.CompanyID = (int)odRdr["CompanyID"]; department.SupDepartmentID = (int)odRdr["SupDepartmentID"]; departmentList.Add(department); } odRdr.Close(); return departmentList; }
public List<Department> GetDepartmentByCompany(int companyID, bool viewDefault) { OleDbCommand odCom = BuildSelectCmd("Department", "*", "CompanyID=@ID" + (viewDefault ? "" : " AND ID<>1"), new object[] { "@ID", companyID }); OleDbDataReader odRdr = odCom.ExecuteReader(); List<Department> departmentList = new List<Department>(); Department department = null; while (odRdr.Read()) { department = new Department(); department.ID = (int)odRdr["ID"]; department.Name = odRdr["Name"].ToString(); department.CompanyID = (int)odRdr["CompanyID"]; department.SupDepartmentID = (int)odRdr["SupDepartmentID"]; departmentList.Add(department); } odRdr.Close(); return departmentList; }
public Department GetDepartment(string name) { OleDbCommand odCom = BuildSelectCmd("Department", "TOP 1 *", "Name=@Name", new object[] { "@Name", name }); OleDbDataReader odRdr = odCom.ExecuteReader(); Department department = null; if (odRdr.Read()) { department = new Department(); department.ID = (int)odRdr["ID"]; department.Name = odRdr["Name"].ToString(); department.CompanyID = (int)odRdr["CompanyID"]; department.SupDepartmentID = (int)odRdr["SupDepartmentID"]; } odRdr.Close(); return department; }
private void AddTestData() { _dtCtrl.BeginTransaction(); try { Invoke(new SetTextCallBack(SetText), new object[] { txtProgress, "Adding ..." }); //add test company Company com = new Company(); com.Name = DateTime.Now.Ticks.ToString(); com.ID = _dtCtrl.AddCompany(com); //add test department Department dep = new Department(); dep.CompanyID = com.ID; dep.Name = DateTime.Now.Ticks.ToString(); dep.SupDepartmentID = 0; //root dep.ID = _dtCtrl.AddDepartment(dep); //add test working calendar WorkingCalendar wCal = new WorkingCalendar(); wCal.Name = DateTime.Now.Ticks.ToString(); wCal.RegularWorkingFrom = new DateTime(2000, 2, 2, 9, 0, 0); wCal.RegularWorkingTo = new DateTime(2000, 2, 2, 18, 0, 0); wCal.WorkOnMonday = true; wCal.WorkOnTuesday = true; wCal.WorkOnWednesday = true; wCal.WorkOnThursday = true; wCal.WorkOnFriday = true; wCal.GraceForwardToEntry = 30; wCal.GraceBackwardToExit = 30; wCal.EarliestBeforeEntry = 60; wCal.LastestAfterExit = 180; List<Break> breakList = new List<Break>(); Break break1 = new Break(); break1.From = new DateTime(2000, 2, 2, 12, 0, 0); break1.To = new DateTime(2000, 2, 2, 13, 0, 0); break1.Name = "break1"; break1.Paid = true; breakList.Add(break1); List<Holiday> holidayList = new List<Holiday>(); PaymentRate workingDayPaymentRate = new PaymentRate(); workingDayPaymentRate.NumberOfRegularHours = 8; workingDayPaymentRate.RegularRate = 100; workingDayPaymentRate.NumberOfOvertime1 = 8; workingDayPaymentRate.OvertimeRate1 = 200; PaymentRate nonWorkingDayPaymentRate = workingDayPaymentRate; PaymentRate holidayPaymentRate = workingDayPaymentRate; PayPeriod payPeriod = new PayPeriod(); payPeriod.CustomPeriod = 5; payPeriod.PayPeriodTypeID = 5; //custom payPeriod.StartFrom = new DateTime(2010, 1, 1); wCal.ID = _dtCtrl.AddWorkingCalendar(wCal, breakList, holidayList, workingDayPaymentRate, nonWorkingDayPaymentRate, holidayPaymentRate, payPeriod); //add test employee Employee emp = new Employee(); emp.Active = true; emp.ActiveFrom = DateTime.Today; emp.ActiveTo = DateTime.Today.AddDays(1); emp.Address = DateTime.Now.Ticks.ToString(); emp.Birthday = DateTime.Today.AddYears(-20); emp.DepartmentID = dep.ID; emp.EmployeeNumber = 0; emp.FirstName = DateTime.Now.Ticks.ToString(); emp.JobDescription = DateTime.Now.Ticks.ToString(); emp.HiredDate = DateTime.Today; emp.LeftDate = DateTime.Today.AddYears(1); emp.LastName = DateTime.Now.Ticks.ToString(); emp.PhoneNumber = DateTime.Now.Ticks.ToString(); emp.WorkingCalendarID = wCal.ID; emp.PayrollNumber = _dtCtrl.AddEmployee(emp, new List<Terminal>()); //add test att records //att1 : expected totalHours: 9 AttendanceRecord att11 = new AttendanceRecord(); att11.EmployeeNumber = emp.EmployeeNumber; att11.Time = new DateTime(2010, 1, 1, 9, 0, 0); att11.ID = _dtCtrl.AddAttendanceRecord(att11); AttendanceRecord att12 = new AttendanceRecord(); att12.EmployeeNumber = emp.EmployeeNumber; att12.Time = new DateTime(2010, 1, 1, 18, 0, 0); att12.ID = _dtCtrl.AddAttendanceRecord(att12); AttendanceRecord att13 = new AttendanceRecord(); att13.EmployeeNumber = emp.EmployeeNumber; att13.Time = new DateTime(2010, 1, 1, 12, 0, 0); att13.ID = _dtCtrl.AddAttendanceRecord(att13); AttendanceRecord att14 = new AttendanceRecord(); att14.EmployeeNumber = emp.EmployeeNumber; att14.Time = new DateTime(2010, 1, 1, 13, 0, 0); att14.ID = _dtCtrl.AddAttendanceRecord(att14); //att2 : expected totalHours: 9 AttendanceRecord att21 = new AttendanceRecord(); att21.EmployeeNumber = emp.EmployeeNumber; att21.Time = new DateTime(2010, 1, 2, 8, 45, 0); att21.ID = _dtCtrl.AddAttendanceRecord(att21); AttendanceRecord att22 = new AttendanceRecord(); att22.EmployeeNumber = emp.EmployeeNumber; att22.Time = new DateTime(2010, 1, 2, 18, 15, 0); att22.ID = _dtCtrl.AddAttendanceRecord(att22); //att3 : expected totalHours: 9.75 AttendanceRecord att31 = new AttendanceRecord(); att31.EmployeeNumber = emp.EmployeeNumber; att31.Time = new DateTime(2010, 1, 3, 8, 15, 0); att31.ID = _dtCtrl.AddAttendanceRecord(att31); AttendanceRecord att32 = new AttendanceRecord(); att32.EmployeeNumber = emp.EmployeeNumber; att32.Time = new DateTime(2010, 1, 3, 18, 0, 0); att32.ID = _dtCtrl.AddAttendanceRecord(att32); //att4 : expected totalHours: 0 + out mistake alert AttendanceRecord att41 = new AttendanceRecord(); att41.EmployeeNumber = emp.EmployeeNumber; att41.Time = new DateTime(2010, 1, 4, 7, 00, 0); att41.ID = _dtCtrl.AddAttendanceRecord(att41); AttendanceRecord att42 = new AttendanceRecord(); att42.EmployeeNumber = emp.EmployeeNumber; att42.Time = new DateTime(2010, 1, 4, 18, 0, 0); att42.ID = _dtCtrl.AddAttendanceRecord(att42); //att5 : expected totalHours: 8.8x AttendanceRecord att51 = new AttendanceRecord(); att51.EmployeeNumber = emp.EmployeeNumber; att51.Time = new DateTime(2010, 1, 5, 9, 06, 0); att51.ID = _dtCtrl.AddAttendanceRecord(att51); AttendanceRecord att52 = new AttendanceRecord(); att52.EmployeeNumber = emp.EmployeeNumber; att52.Time = new DateTime(2010, 1, 5, 18, 2, 0); att52.ID = _dtCtrl.AddAttendanceRecord(att52); //att6 : expected totalHours: 8.5 AttendanceRecord att61 = new AttendanceRecord(); att61.EmployeeNumber = emp.EmployeeNumber; att61.Time = new DateTime(2010, 1, 6, 9, 0, 0); att61.ID = _dtCtrl.AddAttendanceRecord(att61); AttendanceRecord att62 = new AttendanceRecord(); att62.EmployeeNumber = emp.EmployeeNumber; att62.Time = new DateTime(2010, 1, 6, 18, 0, 0); att62.ID = _dtCtrl.AddAttendanceRecord(att62); AttendanceRecord att63 = new AttendanceRecord(); att63.EmployeeNumber = emp.EmployeeNumber; att63.Time = new DateTime(2010, 1, 6, 12, 30, 0); att63.ID = _dtCtrl.AddAttendanceRecord(att63); AttendanceRecord att64 = new AttendanceRecord(); att64.EmployeeNumber = emp.EmployeeNumber; att64.Time = new DateTime(2010, 1, 6, 13, 30, 0); att64.ID = _dtCtrl.AddAttendanceRecord(att64); _dtCtrl.CommitTransaction(); Invoke(new SetTextCallBack(SetText), new object[] { txtProgress, "Adding Complete." }); } catch (Exception ex) { _dtCtrl.RollbackTransaction(); Invoke(new AddTextCallBack(SetText), new object[] { txtProgress, "Error: " + ex.Message }); } }
private void AddTestOneShiftFlexi(ref IDataController _dtCtrl) { #region add test company Company com = new Company(); com.Name = DateTime.Now.Ticks.ToString(); com.ID = _dtCtrl.AddCompany(com); #endregion #region add test department Department dep = new Department(); dep.CompanyID = com.ID; dep.Name = DateTime.Now.Ticks.ToString(); dep.SupDepartmentID = 0; //root dep.ID = _dtCtrl.AddDepartment(dep); #endregion #region add test working calendar List<Break> breakList = new List<Break>(); Break break1 = new Break(); break1.From = new DateTime(2000, 2, 2, 12, 0, 0); break1.To = new DateTime(2000, 2, 2, 13, 0, 0); break1.Name = "break1"; break1.Paid = true; breakList.Add(break1); List<Holiday> holidayList = new List<Holiday>(); PaymentRate workingDayPaymentRate = new PaymentRate(); workingDayPaymentRate.NumberOfRegularHours = 7; workingDayPaymentRate.RegularRate = 100; workingDayPaymentRate.NumberOfOvertime1 = 8; workingDayPaymentRate.OvertimeRate1 = 200; PaymentRate nonWorkingDayPaymentRate = workingDayPaymentRate; PaymentRate holidayPaymentRate = workingDayPaymentRate; PayPeriod payPeriod = new PayPeriod(); payPeriod.CustomPeriod = 5; payPeriod.PayPeriodTypeID = 5; //custom payPeriod.StartFrom = new DateTime(2010, 1, 1); WorkingCalendar wCal = new WorkingCalendar(); wCal.Name = DateTime.Now.Ticks.ToString(); wCal.ApplyFlexiHours = true; wCal.FlexiHours = 40; wCal.WeekStartsOn = 3; //Thursday List<Shift> shiftList = new List<Shift>(); Shift shift1 = new Shift(); shift1.From = new DateTime(2000, 2, 2, 9, 0, 0); shift1.To = new DateTime(2000, 2, 2, 18, 0, 0); shiftList.Add(shift1); wCal.WorkOnMonday = true; wCal.WorkOnTuesday = true; wCal.WorkOnWednesday = true; wCal.WorkOnThursday = true; wCal.WorkOnFriday = true; wCal.GraceForwardToEntry = 30; wCal.GraceBackwardToExit = 30; wCal.EarliestBeforeEntry = 60; wCal.LastestAfterExit = 180; wCal.ID = _dtCtrl.AddWorkingCalendar(wCal, shiftList, new List<Break>(), holidayList, workingDayPaymentRate, nonWorkingDayPaymentRate, holidayPaymentRate, payPeriod); #endregion #region add test employee Employee emp = new Employee(); emp.Active = true; emp.ActiveFrom = DateTime.Today; emp.ActiveTo = DateTime.Today.AddDays(1); emp.Address = DateTime.Now.Ticks.ToString(); emp.Birthday = DateTime.Today.AddYears(-20); emp.DepartmentID = dep.ID; emp.EmployeeNumber = 0; emp.FirstName = DateTime.Now.Ticks.ToString(); emp.JobDescription = DateTime.Now.Ticks.ToString(); emp.HiredDate = DateTime.Today; emp.LeftDate = DateTime.Today.AddYears(1); emp.LastName = DateTime.Now.Ticks.ToString(); emp.PhoneNumber = DateTime.Now.Ticks.ToString(); emp.WorkingCalendarID = wCal.ID; emp.PayrollNumber = _dtCtrl.AddEmployee(emp, new List<Terminal>()); #endregion #region add test att records 2 //att7 : expected regHour: 10 AttendanceRecord att71 = new AttendanceRecord(); att71.EmployeeNumber = emp.EmployeeNumber; att71.Time = new DateTime(2010, 1, 7, 9, 0, 0); att71.ID = _dtCtrl.AddAttendanceRecord(att71); AttendanceRecord att72 = new AttendanceRecord(); att72.EmployeeNumber = emp.EmployeeNumber; att72.Time = new DateTime(2010, 1, 7, 19, 0, 0); att72.ID = _dtCtrl.AddAttendanceRecord(att72); //att8 : expected regHour: 8 AttendanceRecord att81 = new AttendanceRecord(); att81.EmployeeNumber = emp.EmployeeNumber; att81.Time = new DateTime(2010, 1, 8, 9, 0, 0); att81.ID = _dtCtrl.AddAttendanceRecord(att81); AttendanceRecord att82 = new AttendanceRecord(); att82.EmployeeNumber = emp.EmployeeNumber; att82.Time = new DateTime(2010, 1, 8, 17, 0, 0); att82.ID = _dtCtrl.AddAttendanceRecord(att82); //att9 : expected regHour: 8 AttendanceRecord att91 = new AttendanceRecord(); att91.EmployeeNumber = emp.EmployeeNumber; att91.Time = new DateTime(2010, 1, 9, 9, 0, 0); att91.ID = _dtCtrl.AddAttendanceRecord(att91); AttendanceRecord att92 = new AttendanceRecord(); att92.EmployeeNumber = emp.EmployeeNumber; att92.Time = new DateTime(2010, 1, 9, 17, 0, 0); att92.ID = _dtCtrl.AddAttendanceRecord(att92); //att10 : expected regHour: 8 AttendanceRecord att101 = new AttendanceRecord(); att101.EmployeeNumber = emp.EmployeeNumber; att101.Time = new DateTime(2010, 1, 10, 9, 00, 0); att101.ID = _dtCtrl.AddAttendanceRecord(att101); AttendanceRecord att102 = new AttendanceRecord(); att102.EmployeeNumber = emp.EmployeeNumber; att102.Time = new DateTime(2010, 1, 10, 17, 0, 0); att102.ID = _dtCtrl.AddAttendanceRecord(att102); //att11 : expected regHour: 4 AttendanceRecord att111 = new AttendanceRecord(); att111.EmployeeNumber = emp.EmployeeNumber; att111.Time = new DateTime(2010, 1, 11, 9, 0, 0); att111.ID = _dtCtrl.AddAttendanceRecord(att111); AttendanceRecord att112 = new AttendanceRecord(); att112.EmployeeNumber = emp.EmployeeNumber; att112.Time = new DateTime(2010, 1, 11, 13, 0, 0); att112.ID = _dtCtrl.AddAttendanceRecord(att112); //att12 : expected regHour: 2 overHour: 2 AttendanceRecord att121 = new AttendanceRecord(); att121.EmployeeNumber = emp.EmployeeNumber; att121.Time = new DateTime(2010, 1, 12, 9, 0, 0); att121.ID = _dtCtrl.AddAttendanceRecord(att121); AttendanceRecord att122 = new AttendanceRecord(); att122.EmployeeNumber = emp.EmployeeNumber; att122.Time = new DateTime(2010, 1, 12, 13, 0, 0); att122.ID = _dtCtrl.AddAttendanceRecord(att122); //att13 : expected overHour: 2 AttendanceRecord att131 = new AttendanceRecord(); att131.EmployeeNumber = emp.EmployeeNumber; att131.Time = new DateTime(2010, 1, 13, 9, 0, 0); att131.ID = _dtCtrl.AddAttendanceRecord(att131); AttendanceRecord att132 = new AttendanceRecord(); att132.EmployeeNumber = emp.EmployeeNumber; att132.Time = new DateTime(2010, 1, 13, 11, 0, 0); att132.ID = _dtCtrl.AddAttendanceRecord(att132); #endregion }
private void AddTestMultiShiftNonFlexi(ref IDataController _dtCtrl) { #region add test company Company com = new Company(); com.Name = DateTime.Now.Ticks.ToString(); com.ID = _dtCtrl.AddCompany(com); #endregion #region add test department Department dep = new Department(); dep.CompanyID = com.ID; dep.Name = DateTime.Now.Ticks.ToString(); dep.SupDepartmentID = 0; //root dep.ID = _dtCtrl.AddDepartment(dep); #endregion #region add test working calendar WorkingCalendar wCal = new WorkingCalendar(); wCal.Name = DateTime.Now.Ticks.ToString(); wCal.WorkOnMonday = true; wCal.WorkOnTuesday = true; wCal.WorkOnWednesday = true; wCal.WorkOnThursday = true; wCal.WorkOnFriday = true; wCal.GraceForwardToEntry = 30; wCal.GraceBackwardToExit = 30; wCal.EarliestBeforeEntry = 60; wCal.LastestAfterExit = 60; List<Shift> shiftList = new List<Shift>(); Shift shift1 = new Shift(); shift1.From = new DateTime(2000, 2, 2, 8, 0, 0); shift1.To = new DateTime(2000, 2, 2, 12, 0, 0); shiftList.Add(shift1); Shift shift2 = new Shift(); shift2.From = new DateTime(2000, 2, 2, 14, 0, 0); shift2.To = new DateTime(2000, 2, 2, 18, 0, 0); shiftList.Add(shift2); Shift shift3 = new Shift(); shift3.From = new DateTime(2000, 2, 2, 20, 0, 0); shift3.To = new DateTime(2000, 2, 3, 0, 0, 0); shiftList.Add(shift3); List<Break> breakList = new List<Break>(); //Break break1 = new Break(); //break1.From = new DateTime(2000, 2, 2, 12, 0, 0); //break1.To = new DateTime(2000, 2, 2, 13, 0, 0); //break1.Name = "break1"; //break1.Paid = true; //breakList.Add(break1); List<Holiday> holidayList = new List<Holiday>(); PaymentRate workingDayPaymentRate = new PaymentRate(); workingDayPaymentRate.NumberOfRegularHours = 4; workingDayPaymentRate.RegularRate = 100; workingDayPaymentRate.NumberOfOvertime1 = 1; workingDayPaymentRate.OvertimeRate1 = 200; PaymentRate nonWorkingDayPaymentRate = workingDayPaymentRate; PaymentRate holidayPaymentRate = workingDayPaymentRate; PayPeriod payPeriod = new PayPeriod(); payPeriod.CustomPeriod = 5; payPeriod.PayPeriodTypeID = 5; //custom payPeriod.StartFrom = new DateTime(2010, 1, 1); wCal.ID = _dtCtrl.AddWorkingCalendar(wCal, shiftList, breakList, holidayList, workingDayPaymentRate, nonWorkingDayPaymentRate, holidayPaymentRate, payPeriod); #endregion #region add test employee Employee emp = new Employee(); emp.Active = true; emp.ActiveFrom = DateTime.Today; emp.ActiveTo = DateTime.Today.AddDays(1); emp.Address = DateTime.Now.Ticks.ToString(); emp.Birthday = DateTime.Today.AddYears(-20); emp.DepartmentID = dep.ID; emp.EmployeeNumber = 0; emp.FirstName = DateTime.Now.Ticks.ToString(); emp.JobDescription = DateTime.Now.Ticks.ToString(); emp.HiredDate = DateTime.Today; emp.LeftDate = DateTime.Today.AddYears(1); emp.LastName = DateTime.Now.Ticks.ToString(); emp.PhoneNumber = DateTime.Now.Ticks.ToString(); emp.WorkingCalendarID = wCal.ID; emp.PayrollNumber = _dtCtrl.AddEmployee(emp, new List<Terminal>()); #endregion #region add test att records 1 //att1 : expected totalHours: 4 AttendanceRecord att11 = new AttendanceRecord(); att11.EmployeeNumber = emp.EmployeeNumber; att11.Time = new DateTime(2010, 1, 1, 8, 0, 0); att11.ID = _dtCtrl.AddAttendanceRecord(att11); AttendanceRecord att12 = new AttendanceRecord(); att12.EmployeeNumber = emp.EmployeeNumber; att12.Time = new DateTime(2010, 1, 1, 12, 0, 0); att12.ID = _dtCtrl.AddAttendanceRecord(att12); //att2 : expected totalHours: 4 AttendanceRecord att13 = new AttendanceRecord(); att13.EmployeeNumber = emp.EmployeeNumber; att13.Time = new DateTime(2010, 1, 1, 14, 0, 0); att13.ID = _dtCtrl.AddAttendanceRecord(att13); AttendanceRecord att14 = new AttendanceRecord(); att14.EmployeeNumber = emp.EmployeeNumber; att14.Time = new DateTime(2010, 1, 1, 18, 0, 0); att14.ID = _dtCtrl.AddAttendanceRecord(att14); //att3 : expected totalHours: 4 AttendanceRecord att21 = new AttendanceRecord(); att21.EmployeeNumber = emp.EmployeeNumber; att21.Time = new DateTime(2010, 1, 1, 20, 0, 0); att21.ID = _dtCtrl.AddAttendanceRecord(att21); AttendanceRecord att22 = new AttendanceRecord(); att22.EmployeeNumber = emp.EmployeeNumber; att22.Time = new DateTime(2010, 1, 2, 0, 0, 0); att22.ID = _dtCtrl.AddAttendanceRecord(att22); //att4 : expected totalHours: 2.67 AttendanceRecord att31 = new AttendanceRecord(); att31.EmployeeNumber = emp.EmployeeNumber; att31.Time = new DateTime(2010, 1, 2, 8, 15, 0); att31.ID = _dtCtrl.AddAttendanceRecord(att31); AttendanceRecord att32 = new AttendanceRecord(); att32.EmployeeNumber = emp.EmployeeNumber; att32.Time = new DateTime(2010, 1, 2, 11, 0, 0); att32.ID = _dtCtrl.AddAttendanceRecord(att32); //att4 : expected totalHours: 4 + 1 over AttendanceRecord att41 = new AttendanceRecord(); att41.EmployeeNumber = emp.EmployeeNumber; att41.Time = new DateTime(2010, 1, 2, 14, 00, 0); att41.ID = _dtCtrl.AddAttendanceRecord(att41); AttendanceRecord att42 = new AttendanceRecord(); att42.EmployeeNumber = emp.EmployeeNumber; att42.Time = new DateTime(2010, 1, 2, 19, 0, 0); att42.ID = _dtCtrl.AddAttendanceRecord(att42); //att4 : expected totalHours: AttendanceRecord att51 = new AttendanceRecord(); att51.EmployeeNumber = emp.EmployeeNumber; att51.Time = new DateTime(2010, 1, 2, 20, 06, 0); att51.ID = _dtCtrl.AddAttendanceRecord(att51); AttendanceRecord att52 = new AttendanceRecord(); att52.EmployeeNumber = emp.EmployeeNumber; att52.Time = new DateTime(2010, 1, 2, 23, 2, 0); att52.ID = _dtCtrl.AddAttendanceRecord(att52); #endregion }
private Department GetDepartmentUserInput() { object oCompanyID = cbxCompany.SelectedValue; object oSupDepartmentID = cbxSupDepartment.SelectedValue; string departmentName = txtDepartmentName.Text; if (oCompanyID == null && oSupDepartmentID == null) { MessageBox.Show("Please select company and department."); return null; } else //check sup deparment { if (btnSubmit.Tag != null) { if ((int)oSupDepartmentID == (int)btnSubmit.Tag) { MessageBox.Show("Department can not be a subordinate of itself."); return null; } } } if (string.IsNullOrEmpty(departmentName)) //check empty name { errProviders.SetError(txtDepartmentName, "Please enter department name."); return null; } else //check duplicated name { Department depWithSameName = _dtCtrl.GetDepartment(departmentName); if (depWithSameName != null && btnSubmit.Tag != null) { if (depWithSameName.ID != (int)btnSubmit.Tag) { MessageBox.Show("This name has been used by another Department. Please choose a different name."); return null; } } } Department department = new Department(); department.CompanyID = (int)oCompanyID; department.SupDepartmentID = (int)oSupDepartmentID; department.Name = departmentName; return department; }
private void AddEmployee() { //com.Name = DateTime.Now.Ticks.ToString(); //com.ID = _dtCtrl.AddCompany(com); //dep.Name = DateTime.Now.Ticks.ToString(); //dep.CompanyID = com.ID; //dep.SupDepartmentID = 0; //dep.ID = _dtCtrl.AddDepartment(dep); //wCal.Name = DateTime.Now.Ticks.ToString(); //wCal.RegularWorkingFrom = DateTime.Today; //wCal.RegularWorkingTo = DateTime.Today; //List<Break> breakList = new List<Break>(); //List<Holiday> holidayList = new List<Holiday>(); //PaymentRate workingDayPaymentRate = new PaymentRate(); //PaymentRate nonWorkingDayPaymentRate = new PaymentRate(); //PaymentRate holidayPaymentRate = new PaymentRate(); //PayPeriod payPeriod = new PayPeriod(); //payPeriod.CustomPeriod = 5; //payPeriod.PayPeriodTypeID = 5; //custom //payPeriod.StartFrom = DateTime.Today; //wCal.ID = _dtCtrl.AddWorkingCalendar(wCal, breakList, holidayList, workingDayPaymentRate, nonWorkingDayPaymentRate, holidayPaymentRate, payPeriod); dep = _dtCtrl.GetDepartmentList()[0]; com = _dtCtrl.GetCompany(dep.CompanyID); wCal = _dtCtrl.GetWorkingCalendarList()[0]; ter = _dtCtrl.GetTerminalList()[0]; emp = new Employee(); emp.Active = true; emp.ActiveFrom = DateTime.Today; emp.ActiveTo = DateTime.Today.AddDays(1); emp.Address = DateTime.Now.Ticks.ToString(); emp.Birthday = DateTime.Today.AddYears(-20); emp.DepartmentID = dep.ID; emp.EmployeeNumber = 0; emp.FirstName = DateTime.Now.Ticks.ToString(); emp.JobDescription = DateTime.Now.Ticks.ToString(); emp.HiredDate = DateTime.Today; emp.LeftDate = DateTime.Today.AddYears(1); emp.LastName = DateTime.Now.Ticks.ToString(); emp.PhoneNumber = DateTime.Now.Ticks.ToString(); emp.WorkingCalendarID = wCal.ID; emp.FaceData1 = ""; emp.FaceData2 = ""; emp.FaceData3 = ""; emp.FaceData4 = ""; emp.FaceData5 = ""; emp.FaceData6 = ""; emp.FaceData7 = ""; emp.FaceData8 = ""; emp.FaceData9 = ""; emp.FaceData10 = ""; emp.FaceData11 = ""; emp.FaceData12 = ""; emp.FaceData13 = ""; emp.FaceData14 = ""; emp.FaceData15 = ""; emp.FaceData16 = ""; emp.FaceData17 = ""; emp.FaceData18 = ""; emp.PayrollNumber = _dtCtrl.AddEmployee(emp, new List<Terminal>(){ter}); }