public async Task <IActionResult> DeleteTimeAndAttendanceSchedule([FromBody] TimeAndAttendanceScheduleView view)
{
TimeAndAttendanceScheduleModule invMod = new TimeAndAttendanceScheduleModule();
TimeAndAttendanceSchedule timeAndAttendanceSchedule = await invMod.Schedule.Query().MapToEntity(view);
invMod.Schedule.DeleteTimeAndAttendanceSchedule(timeAndAttendanceSchedule).Apply();
return(Ok(view));
}
public TimeAndAttendanceScheduleView(TimeAndAttendanceSchedule schedule)
{
this.ScheduleId = schedule.ScheduleId;
this.ScheduleName = schedule.ScheduleName;
this.StartDate = schedule.StartDate;
this.EndDate = schedule.EndDate;
this.ShiftId = schedule.ShiftId;
this.ShiftName = schedule.TimeAndAttendanceShift.ShiftName;
this.ShiftStartTime = schedule.TimeAndAttendanceShift.ShiftStartTime;
this.ShiftEndTime = schedule.TimeAndAttendanceShift.ShiftEndTime;
this.ScheduleGroup = schedule.ScheduleGroup;
this.StartDateTime = BuildLongDate(this.StartDate ?? DateTime.Now, this.ShiftStartTime ?? 0);
this.EndDateTime = BuildLongDate(this.EndDate ?? DateTime.Now, this.ShiftEndTime ?? 0);
}
public async Task TestAddUpdatDelete()
{
TimeAndAttendanceScheduleModule TimeAndAttendanceScheduleMod = new TimeAndAttendanceScheduleModule();
TimeAndAttendanceShift shift = await TimeAndAttendanceScheduleMod.Shift.Query().GetEntityById(1);
TimeAndAttendanceScheduleView view = new TimeAndAttendanceScheduleView()
{
ScheduleName = "Test Sched",
StartDate = DateTime.Parse("12/30/2019"),
EndDate = DateTime.Parse("1/3/2020"),
ShiftId = shift.ShiftId,
ShiftName = shift.ShiftName,
ShiftStartTime = shift.ShiftStartTime,
ShiftEndTime = shift.ShiftEndTime,
ScheduleGroup = "A",
DurationHours = shift.DurationHours,
DurationMinutes = shift.DurationMinutes,
Monday = shift.Monday,
Tuesday = shift.Tuesday,
Wednesday = shift.Wednesday,
Thursday = shift.Thursday,
Friday = shift.Friday,
Saturday = shift.Saturday,
Sunday = shift.Sunday
};
NextNumber nnNextNumber = await TimeAndAttendanceScheduleMod.Schedule.Query().GetNextNumber();
view.TimeAndAttendanceScheduleNumber = nnNextNumber.NextNumberValue;
TimeAndAttendanceSchedule timeAndAttendanceSchedule = await TimeAndAttendanceScheduleMod.Schedule.Query().MapToEntity(view);
TimeAndAttendanceScheduleMod.Schedule.AddTimeAndAttendanceSchedule(timeAndAttendanceSchedule).Apply();
TimeAndAttendanceSchedule newTimeAndAttendanceSchedule = await TimeAndAttendanceScheduleMod.Schedule.Query().GetEntityByNumber(view.TimeAndAttendanceScheduleNumber);
Assert.NotNull(newTimeAndAttendanceSchedule);
newTimeAndAttendanceSchedule.ScheduleName = "Sched Test Update";
TimeAndAttendanceScheduleMod.Schedule.UpdateTimeAndAttendanceSchedule(newTimeAndAttendanceSchedule).Apply();
TimeAndAttendanceScheduleView updateView = await TimeAndAttendanceScheduleMod.Schedule.Query().GetViewById(newTimeAndAttendanceSchedule.ScheduleId);
Assert.Same(updateView.ScheduleName, "Sched Test Update");
TimeAndAttendanceScheduleMod.Schedule.DeleteTimeAndAttendanceSchedule(newTimeAndAttendanceSchedule).Apply();
TimeAndAttendanceSchedule lookupTimeAndAttendanceSchedule = await TimeAndAttendanceScheduleMod.Schedule.Query().GetEntityById(view.ScheduleId);
Assert.Null(lookupTimeAndAttendanceSchedule);
}
public async Task <IActionResult> AddTimeAndAttendanceSchedule([FromBody] TimeAndAttendanceScheduleView view)
{
TimeAndAttendanceScheduleModule invMod = new TimeAndAttendanceScheduleModule();
NextNumber nnTimeAndAttendanceSchedule = await invMod.Schedule.Query().GetNextNumber();
view.TimeAndAttendanceScheduleNumber = nnTimeAndAttendanceSchedule.NextNumberValue;
TimeAndAttendanceSchedule timeAndAttendanceSchedule = await invMod.Schedule.Query().MapToEntity(view);
invMod.Schedule.AddTimeAndAttendanceSchedule(timeAndAttendanceSchedule).Apply();
TimeAndAttendanceScheduleView newView = await invMod.Schedule.Query().GetViewByNumber(view.TimeAndAttendanceScheduleNumber);
return(Ok(newView));
}
public async Task TestAddSchedule()
{
UnitOfWork unitOfWork = new UnitOfWork();
long shiftId = 1;
Task <TimeAndAttendanceShift> shiftTask = Task.Run(async() => await unitOfWork.timeAndAttendanceRepository.GetShiftById(shiftId));
Task.WaitAll(shiftTask);
TimeAndAttendanceScheduleView view = new TimeAndAttendanceScheduleView();
view.ScheduleName = "Schedule A";
view.StartDate = DateTime.Parse("2/18/2019");
view.EndDate = DateTime.Parse("2/22/2019");
view.ShiftId = shiftTask.Result.ShiftId;
view.ShiftName = shiftTask.Result.ShiftName;
view.ShiftStartTime = shiftTask.Result.ShiftStartTime;
view.ShiftEndTime = shiftTask.Result.ShiftEndTime;
view.DurationHours = shiftTask.Result.DurationHours;
view.DurationMinutes = shiftTask.Result.DurationMinutes;
view.Monday = shiftTask.Result.Monday;
view.Tuesday = shiftTask.Result.Tuesday;
view.Wednesday = shiftTask.Result.Wednesday;
view.Thursday = shiftTask.Result.Thursday;
view.Friday = shiftTask.Result.Friday;
view.Saturday = shiftTask.Result.Saturday;
view.Sunday = shiftTask.Result.Sunday;
view.ScheduleGroup = "A";
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendanceSchedule schedule = await taMod.Schedule.Query().MapToEntity(view);
taMod.Schedule.AddTimeAndAttendanceSchedule(schedule).Apply();
TimeAndAttendanceScheduleView scheduleView = await taMod.Schedule.Query().GetScheduleByExpression(e => e.ScheduleName == view.ScheduleName && e.StartDate == view.StartDate && e.EndDate == view.EndDate);
Assert.True(scheduleView != null);
}
public IFluentTimeAndAttendanceSchedule DeleteTimeAndAttendanceSchedule(TimeAndAttendanceSchedule deleteObject)
{
unitOfWork.timeAndAttendanceScheduleRepository.DeleteObject(deleteObject);
this.processStatus = CreateProcessStatus.Delete;
return(this as IFluentTimeAndAttendanceSchedule);
}
public IFluentTimeAndAttendanceSchedule AddTimeAndAttendanceSchedule(TimeAndAttendanceSchedule newObject)
{
unitOfWork.timeAndAttendanceScheduleRepository.AddObject(newObject);
this.processStatus = CreateProcessStatus.Insert;
return(this as IFluentTimeAndAttendanceSchedule);
}
public async Task TestAddUpdatDelete()
{
TimeAndAttendanceScheduledToWorkModule TimeAndAttendanceScheduledToWorkMod = new TimeAndAttendanceScheduledToWorkModule();
TimeAndAttendanceSchedule schedule = await TimeAndAttendanceScheduledToWorkMod.Schedule.Query().GetEntityById(4);
TimeAndAttendanceShift shift = await TimeAndAttendanceScheduledToWorkMod.Shift.Query().GetEntityById(schedule?.ShiftId);
Employee employee = await TimeAndAttendanceScheduledToWorkMod.Employee.Query().GetEntityById(1);
AddressBook addressBookEmployee = await TimeAndAttendanceScheduledToWorkMod.AddressBook.Query().GetEntityById(employee?.AddressId);
Udc udcJobCode = await TimeAndAttendanceScheduledToWorkMod.Udc.Query().GetEntityById(25);
Udc udcPayCode = await TimeAndAttendanceScheduledToWorkMod.Udc.Query().GetEntityById(16);
Udc udcWorkedJobCode = await TimeAndAttendanceScheduledToWorkMod.Udc.Query().GetEntityById(25);
string shiftStartTime = await TimeAndAttendanceScheduledToWorkMod.Shift.Query().BuildLongDate(schedule.StartDate, shift?.ShiftStartTime);
string shiftEndTime = await TimeAndAttendanceScheduledToWorkMod.Shift.Query().BuildLongDate(schedule.EndDate, shift?.ShiftEndTime);
TimeAndAttendanceScheduledToWorkView view = new TimeAndAttendanceScheduledToWorkView()
{
EmployeeId = employee.EmployeeId,
EmployeeName = addressBookEmployee?.Name,
ScheduleId = schedule.ScheduleId,
ScheduleName = schedule.ScheduleName,
ScheduleStartDate = schedule.StartDate,
ScheduleEndDate = schedule.EndDate,
ShiftId = shift?.ShiftId,
ShiftStartTime = shiftStartTime,
ShiftEndTime = shiftEndTime,
DurationHours = shift?.DurationHours ?? 0,
DurationMinutes = shift?.DurationMinutes ?? 0,
Monday = shift?.Monday,
Tuesday = shift?.Tuesday,
Wednesday = shift?.Wednesday,
Thursday = shift?.Thursday,
Friday = shift?.Friday,
Saturday = shift?.Saturday,
Sunday = shift?.Sunday,
JobCodeXrefId = udcJobCode.XrefId,
JobCode = udcJobCode?.KeyCode,
PayCodeXrefId = udcPayCode.XrefId,
PayCode = udcPayCode?.KeyCode,
WorkedJobCodeXrefId = udcWorkedJobCode.XrefId,
WorkedJobCode = udcWorkedJobCode?.KeyCode
};
NextNumber nnNextNumber = await TimeAndAttendanceScheduledToWorkMod.ScheduledToWork.Query().GetNextNumber();
view.ScheduledToWorkNumber = nnNextNumber.NextNumberValue;
TimeAndAttendanceScheduledToWork timeAndAttendanceScheduledToWork = await TimeAndAttendanceScheduledToWorkMod.ScheduledToWork.Query().MapToEntity(view);
TimeAndAttendanceScheduledToWorkMod.ScheduledToWork.AddTimeAndAttendanceScheduledToWork(timeAndAttendanceScheduledToWork).Apply();
TimeAndAttendanceScheduledToWork newTimeAndAttendanceScheduledToWork = await TimeAndAttendanceScheduledToWorkMod.ScheduledToWork.Query().GetEntityByNumber(view.ScheduledToWorkNumber);
Assert.NotNull(newTimeAndAttendanceScheduledToWork);
newTimeAndAttendanceScheduledToWork.Note = "Note Update";
TimeAndAttendanceScheduledToWorkMod.ScheduledToWork.UpdateTimeAndAttendanceScheduledToWork(newTimeAndAttendanceScheduledToWork).Apply();
TimeAndAttendanceScheduledToWorkView updateView = await TimeAndAttendanceScheduledToWorkMod.ScheduledToWork.Query().GetViewById(newTimeAndAttendanceScheduledToWork.ScheduledToWorkId);
Assert.Same(updateView.Note, "Note Update");
TimeAndAttendanceScheduledToWorkMod.ScheduledToWork.DeleteTimeAndAttendanceScheduledToWork(newTimeAndAttendanceScheduledToWork).Apply();
TimeAndAttendanceScheduledToWork lookupTimeAndAttendanceScheduledToWork = await TimeAndAttendanceScheduledToWorkMod.ScheduledToWork.Query().GetEntityById(view.ScheduledToWorkId);
Assert.Null(lookupTimeAndAttendanceScheduledToWork);
}
