public UnitOfWork(ApplicationDbContext db) { _db = db; Category = new CategoryRepository(_db); Frequency = new FrequencyRepository(_db); Service = new ServiceRepository(_db); }
private void Find_Click(object sender, EventArgs e) { var defaultTime = "Choose time"; var defaultWeather = "Choose weather"; var defaultDistrict = "Choose district"; var isDefaultTimeTo = string.Equals(_timeTo.SelectedItem.ToString(), defaultTime, OrdinalIgnoreCase); var isDefaultTimeFrom = string.Equals(_timeFrom.SelectedItem.ToString(), defaultTime, OrdinalIgnoreCase); var isDefaultWeather = string.Equals(_weather.SelectedItem.ToString(), defaultWeather, OrdinalIgnoreCase); var isDefaultDistrict = string.Equals(_district.SelectedItem.ToString(), defaultDistrict, OrdinalIgnoreCase); if (isDefaultTimeTo && isDefaultTimeFrom && isDefaultWeather && isDefaultDistrict) { Toast.MakeText(this, "Select minimum one criteria", ToastLength.Short).Show(); _gridView.Adapter = null; return; } var to = isDefaultTimeTo ? string.Empty : _timeTo.SelectedItem.ToString(); var from = isDefaultTimeFrom ? string.Empty : _timeFrom.SelectedItem.ToString(); var weather = isDefaultWeather ? string.Empty : _weather.SelectedItem.ToString(); var location = isDefaultDistrict ? string.Empty : _district.SelectedItem.ToString(); var freqRepo = new FrequencyRepository(); var criterya = new FrequencyGroup { To = to, From = from, Weather = weather, Location = location }; try { var frequency = freqRepo.GetFrequencyByCriterya(criterya); if (frequency.Count > 0) { _gridViewItems = new ArrayList(frequency); ArrayAdapter adapter = new ArrayAdapter(this, Android.Resource.Layout.SimpleListItem1, _gridViewItems); _gridView.Adapter = adapter; } else { resetGridAndPopulateMsg(); } } catch { resetGridAndPopulateMsg(); } }
public UnitOfWork(ApplicationDbContext db) { _db = db; Category = new CategoryRepository(_db); Frequency = new FrequencyRepository(_db); Service = new ServiceRepository(_db); OrderHeader = new OrderHeaderRepository(_db); OrderDetails = new OrderDetailsRepository(_db); User = new UserRepository(_db); SP_Call = new StoredProcedureCal(_db); }
public FrequencyService() { _frequencyRepository = new FrequencyRepository(); }
public void GenerateTotalByDateRange() { //Arrange var databaseFactory = new DatabaseFactory(); var unitOfWork = new UnitOfWork(databaseFactory); var employeeHoursRepository = new EmployeeHoursRepository(databaseFactory); var totalEmployeeHoursRepository = new TotalEmployeeHoursRepository(databaseFactory); var employeeDepartmentRepository = new EmployeeDepartmentRepository(databaseFactory); var employeeRepository = new EmployeeRepository(databaseFactory, employeeDepartmentRepository); var attendanceRepository = new AttendanceRepository(databaseFactory); var attendanceLogRepository = new AttendanceLogRepository(databaseFactory, employeeRepository); var settingRepository = new SettingRepository(databaseFactory); var employeeWorkScheduleRepository = new EmployeeWorkScheduleRepository(databaseFactory); var employeeInfoRepository = new EmployeeInfoRepository(databaseFactory); var frequencyRepository = new FrequencyRepository(databaseFactory); var paymentFrequencyRepository = new PaymentFrequencyRepository(databaseFactory); var employeeInfoService = new EmployeeInfoService(employeeInfoRepository); var attendanceLogService = new AttendanceLogService(attendanceLogRepository); var attendanceService = new AttendanceService(unitOfWork, attendanceRepository, attendanceLogService, employeeHoursRepository); var settingService = new SettingService(settingRepository); var employeeWorkScheduleService = new EmployeeWorkScheduleService(employeeWorkScheduleRepository); var employeeHoursService = new EmployeeHoursService(unitOfWork, employeeHoursRepository, attendanceService, settingService, employeeWorkScheduleService, employeeInfoService); var totalEmployeeHoursService = new TotalEmployeeHoursService(unitOfWork, totalEmployeeHoursRepository, employeeHoursService, settingService); //Delete info employeeRepository.ExecuteSqlCommand("SET FOREIGN_KEY_CHECKS = 0"); employeeRepository.ExecuteSqlCommand("TRUNCATE TABLE frequency"); employeeRepository.ExecuteSqlCommand("TRUNCATE TABLE payment_frequency"); employeeRepository.ExecuteSqlCommand("TRUNCATE TABLE employee_hours"); employeeRepository.ExecuteSqlCommand("TRUNCATE TABLE employee_hours_total"); employeeRepository.ExecuteSqlCommand("TRUNCATE TABLE employee"); employeeRepository.ExecuteSqlCommand("SET FOREIGN_KEY_CHECKS = 1"); unitOfWork.Commit(); var employee1 = new Employee { EmployeeCode = "11001", FirstName = "Jona", LastName = "Pereira", MiddleName = "Aprecio", BirthDate = DateTime.Parse("02/02/1991"), Gender = 1, IsActive = true }; var employee2 = new Employee { EmployeeCode = "11001", FirstName = "Jona", LastName = "Pereira", MiddleName = "Aprecio", BirthDate = DateTime.Parse("02/02/1991"), Gender = 1, IsActive = true }; var frequency = new Frequency { FrequencyName = "Weekly", FrequencyType = Entities.Enums.FrequencyType.Weekly }; frequencyRepository.Add(frequency); var paymentFrequency = new PaymentFrequency { Frequency = frequency }; paymentFrequencyRepository.Add(paymentFrequency); var employeeInfo1 = new EmployeeInfo { Employee = employee1, SalaryFrequency = FrequencyType.Weekly }; var employeeInfo2 = new EmployeeInfo { Employee = employee2, SalaryFrequency = FrequencyType.Weekly }; employeeInfoRepository.Add(employeeInfo1); employeeInfoRepository.Add(employeeInfo2); /* "03/01/2016 - Employee 1 Regular Total hour 8 */ var employeeHours1 = new EmployeeHours { Date = DateTime.Parse("03/01/2016"), Employee = employee1, Hours = 4, OriginAttendanceId = 1, Type = Entities.Enums.RateType.Regular }; var employeeHours3 = new EmployeeHours { Date = DateTime.Parse("03/01/2016"), Employee = employee1, Hours = 4, OriginAttendanceId = 3, Type = Entities.Enums.RateType.Regular }; /* 03/01/2016 - Employee 1 OT Total hour 3 */ var employeeHours4 = new EmployeeHours { Date = DateTime.Parse("03/01/2016"), Employee = employee1, Hours = 3, OriginAttendanceId = 3, Type = Entities.Enums.RateType.OverTime }; /* 03/01/2016 - Employee 1 ND Total hour 1 */ var employeeHours5 = new EmployeeHours { Date = DateTime.Parse("03/01/2016"), Employee = employee1, Hours = 1, OriginAttendanceId = 3, Type = Entities.Enums.RateType.NightDifferential }; /* 03/01/2016 - Employee 2 OT Total hour 3 */ var employeeHours2 = new EmployeeHours { Date = DateTime.Parse("03/01/2016"), Employee = employee2, Hours = 3, OriginAttendanceId = 2, Type = Entities.Enums.RateType.OverTime }; /* 03/02/2016 - Employee 1 OT Total hour 1 */ var employeeHours8 = new EmployeeHours { Date = DateTime.Parse("03/02/2016"), Employee = employee1, Hours = 1, OriginAttendanceId = 5, Type = Entities.Enums.RateType.OverTime }; /* 03/02/2016 - Employee 2 Regular Total hour 4 */ var employeeHours6 = new EmployeeHours { Date = DateTime.Parse("03/02/2016"), Employee = employee2, Hours = 4, OriginAttendanceId = 4, Type = Entities.Enums.RateType.Regular }; /* 03/02/2016 - Employee 2 NightDifferential Total hour 6 */ var employeeHours7 = new EmployeeHours { Date = DateTime.Parse("03/02/2016"), Employee = employee2, Hours = 4, OriginAttendanceId = 4, Type = Entities.Enums.RateType.NightDifferential }; var employeeHours10 = new EmployeeHours { Date = DateTime.Parse("03/02/2016"), Employee = employee2, Hours = 2, OriginAttendanceId = 4, Type = Entities.Enums.RateType.NightDifferential }; /* NOT INCLUDED */ var employeeHours9 = new EmployeeHours { Date = DateTime.Parse("03/03/2016"), Employee = employee1, Hours = 10, OriginAttendanceId = 5, Type = Entities.Enums.RateType.OverTime }; employeeHoursRepository.Add(employeeHours1); employeeHoursRepository.Add(employeeHours2); employeeHoursRepository.Add(employeeHours3); employeeHoursRepository.Add(employeeHours4); employeeHoursRepository.Add(employeeHours5); employeeHoursRepository.Add(employeeHours6); employeeHoursRepository.Add(employeeHours7); employeeHoursRepository.Add(employeeHours8); employeeHoursRepository.Add(employeeHours9); employeeHoursRepository.Add(employeeHours10); unitOfWork.Commit(); DateTime dateFrom = DateTime.Parse("03/01/2016"); DateTime dateTo = DateTime.Parse("03/02/2016"); totalEmployeeHoursService.GenerateTotalByDateRange(dateFrom, dateTo); var totalEmployeeHours = totalEmployeeHoursService.GetByDateRange(dateFrom, dateTo); Assert.AreEqual(7, totalEmployeeHours.Count()); Assert.AreEqual(1, totalEmployeeHours[0].EmployeeId); Assert.AreEqual(DateTime.Parse("03/02/2016"), totalEmployeeHours[0].Date); Assert.AreEqual(Entities.Enums.RateType.OverTime, totalEmployeeHours[0].Type); Assert.AreEqual(1, totalEmployeeHours[0].Hours); Assert.AreEqual(2, totalEmployeeHours[1].EmployeeId); Assert.AreEqual(DateTime.Parse("03/02/2016"), totalEmployeeHours[1].Date); Assert.AreEqual(Entities.Enums.RateType.Regular, totalEmployeeHours[1].Type); Assert.AreEqual(4, totalEmployeeHours[1].Hours); Assert.AreEqual(2, totalEmployeeHours[2].EmployeeId); Assert.AreEqual(DateTime.Parse("03/02/2016"), totalEmployeeHours[2].Date); Assert.AreEqual(Entities.Enums.RateType.NightDifferential, totalEmployeeHours[2].Type); Assert.AreEqual(6, totalEmployeeHours[2].Hours); Assert.AreEqual(1, totalEmployeeHours[3].EmployeeId); Assert.AreEqual(DateTime.Parse("03/01/2016"), totalEmployeeHours[3].Date); Assert.AreEqual(Entities.Enums.RateType.Regular, totalEmployeeHours[3].Type); Assert.AreEqual(8, totalEmployeeHours[3].Hours); Assert.AreEqual(1, totalEmployeeHours[4].EmployeeId); Assert.AreEqual(DateTime.Parse("03/01/2016"), totalEmployeeHours[4].Date); Assert.AreEqual(Entities.Enums.RateType.OverTime, totalEmployeeHours[4].Type); Assert.AreEqual(3, totalEmployeeHours[4].Hours); Assert.AreEqual(1, totalEmployeeHours[5].EmployeeId); Assert.AreEqual(DateTime.Parse("03/01/2016"), totalEmployeeHours[5].Date); Assert.AreEqual(Entities.Enums.RateType.NightDifferential, totalEmployeeHours[5].Type); Assert.AreEqual(1, totalEmployeeHours[5].Hours); Assert.AreEqual(2, totalEmployeeHours[6].EmployeeId); Assert.AreEqual(DateTime.Parse("03/01/2016"), totalEmployeeHours[6].Date); Assert.AreEqual(Entities.Enums.RateType.OverTime, totalEmployeeHours[6].Type); Assert.AreEqual(3, totalEmployeeHours[6].Hours); Assert.AreEqual(true, employeeHours1.IsIncludedInTotal); Assert.AreEqual(true, employeeHours2.IsIncludedInTotal); Assert.AreEqual(true, employeeHours3.IsIncludedInTotal); Assert.AreEqual(true, employeeHours4.IsIncludedInTotal); Assert.AreEqual(true, employeeHours5.IsIncludedInTotal); Assert.AreEqual(true, employeeHours6.IsIncludedInTotal); Assert.AreEqual(true, employeeHours7.IsIncludedInTotal); Assert.AreEqual(true, employeeHours8.IsIncludedInTotal); Assert.AreEqual(false, employeeHours9.IsIncludedInTotal); }