public TimeAndAttendancePunchInView(TimeAndAttendancePunchIn taPunchin)
{
this.TimePunchinId = taPunchin.TimePunchinId;
this.PunchinDate = taPunchin.PunchinDate;
this.PunchinDateTime = taPunchin.PunchinDateTime;
this.PunchoutDateTime = taPunchin.PunchoutDateTime;
this.JobCodeXrefId = taPunchin.JobCodeXrefId;
//this.JobCode = taPunchin.
this.Approved = taPunchin.Approved;
this.EmployeeId = taPunchin.EmployeeId;
this.EmployeeName = taPunchin.Employee.AddressBook.Name;
this.SupervisorId = taPunchin.SupervisorId;
this.SupervisorName = taPunchin.Supervisor.AddressBook.Name;
this.ProcessedDate = taPunchin.ProcessedDate;
this.Note = taPunchin.Note;
this.ShiftId = taPunchin.ShiftId;
this.ScheduledToWork = taPunchin.ScheduledToWork;
this.TypeOfTimeUdcXrefId = taPunchin.TypeOfTimeUdcXrefId;
this.TypeOfTime = taPunchin.UDC.Value;
this.ApprovingAddressId = taPunchin.ApprovingAddressId;
this.PayCodeXrefId = taPunchin.PayCodeXrefId;
//this.PayCode = taPunchin.
this.ScheduleId = taPunchin.ScheduleId;
this.DurationInMinutes = taPunchin.DurationInMinutes;
this.MealDurationInMinutes = taPunchin.MealDurationInMinutes;
}
public async Task TestAddbyElapsedTime()
{
long employeeId = 1;
UnitOfWork unitOfWork = new UnitOfWork();
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendancePunchIn taPunchin = null;
DateTime asOfDate = DateTime.Now;
string account = "1200.215";
int mealDeduction = 30;
int manual_elapsedHours = 12;
int manual_elapsedMinutes = 30;
TimeAndAttendancePunchIn openTA = await taMod.TimeAndAttendance.Query().IsPunchOpen(employeeId, asOfDate);
if (openTA == null)
{
taPunchin = await taMod.TimeAndAttendance.Query().BuildPunchin(employeeId, account, asOfDate);
taMod.TimeAndAttendance.AddPunchIn(taPunchin).Apply();
}
//taPunchin = await taMod.TimeAndAttendance.Query().GetPunchOpen(employeeId);
taMod.TimeAndAttendance.UpdatePunchIn(taPunchin, mealDeduction, manual_elapsedHours, manual_elapsedMinutes).Apply();
taPunchin = await taMod.TimeAndAttendance.Query().GetEntityById(taPunchin.TimePunchinId);
Assert.NotNull(taPunchin.PunchinDate);
}
public async Task TestTimeAndAttendanceExecuteAsync()
{
try
{
UnitOfWork unitOfWork = new UnitOfWork();
long id = 7;
TimeAndAttendancePunchIn item2 = await unitOfWork.timeAndAttendanceRepository._dbContext.TimeAndAttendancePunchIn.FindAsync(id);
List <TimeAndAttendancePunchIn> list = await unitOfWork.timeAndAttendanceRepository._dbContext.TimeAndAttendancePunchIn.Where(e => e.EmployeeId == 3).ToListAsync <TimeAndAttendancePunchIn>();
//no getawaiter
// var item =(await unitOfWork.timeAndAttendanceRepository._dbContext.TimeAndAttendancePunchIn.Where(e => e.EmployeeId == 3).ExecuteAsync()).FirstOrDefault();
var item = await Task.FromResult(unitOfWork.timeAndAttendanceRepository._dbContext.TimeAndAttendancePunchIn.Where(e => e.EmployeeId == 3).FirstOrDefault <TimeAndAttendancePunchIn>());
var item3 = await unitOfWork.timeAndAttendanceRepository._dbContext.TimeAndAttendancePunchIn.Where(e => e.EmployeeId == 3).FirstOrDefaultAsync <TimeAndAttendancePunchIn>();
//foreach (var item in query)
//{
output.WriteLine($"{item.EmployeeId} vDate: {item.PunchinDateTime} Duration: {item.DurationInMinutes}");
//}
}
catch (Exception ex)
{
output.WriteLine($"{ex.InnerException}");
}
}
public TimeAndAttendancePunchIn GetPunchInByExpression(Expression <Func <TimeAndAttendancePunchIn, bool> > predicate)
{
var query = _unitOfWork.timeAndAttendanceRepository.GetObjectsQueryable(predicate) as IQueryable <TimeAndAttendancePunchIn>;
TimeAndAttendancePunchIn retItem = null;
foreach (var item in query)
{
retItem = item;
break;
}
return(retItem);
}
public IFluentTimeAndAttendance DeletePunchIn(TimeAndAttendancePunchIn taPunchin)
{
try
{
CreateProcessStatus statusResult = unitOfWork.timeAndAttendanceRepository.DeletePunchin(taPunchin);
processStatus = statusResult;
return(this as IFluentTimeAndAttendance);
}
catch (Exception ex)
{
throw new Exception(GetMyMethodName(), ex);
}
}
public ITimeAndAttendance UpdatePunchIn(TimeAndAttendancePunchIn taPunchin)
{
try
{
unitOfWork.timeAndAttendanceRepository.UpdateObject(taPunchin);
processStatus = CreateProcessStatus.Update;
return(this as ITimeAndAttendance);
}
catch (Exception ex)
{
throw new Exception(GetMyMethodName(), ex);
}
}
public IFluentTimeAndAttendance UpdatePunchIn(TimeAndAttendancePunchIn taPunchin, int mealDeduction, int manualElapsedHours = 0, int manualElapsedMinutes = 0)
{
try
{
Task <CreateProcessStatus> statusTask = Task.Run(async() => await unitOfWork.timeAndAttendanceRepository.UpdatePunchin(taPunchin, mealDeduction, manualElapsedHours, manualElapsedMinutes));
Task.WaitAll(statusTask);
processStatus = statusTask.Result;
return(this as IFluentTimeAndAttendance);
}
catch (Exception ex)
{
processStatus = CreateProcessStatus.Failed;
throw new Exception(GetMyMethodName(), ex);
}
}
public IFluentTimeAndAttendance AddPunchIn(TimeAndAttendancePunchIn taPunchin)
{
try
{
Task <CreateProcessStatus> statusTask = Task.Run(async() => await unitOfWork.timeAndAttendanceRepository.AddPunchin(taPunchin));
Task.WaitAll(statusTask);
processStatus = statusTask.Result;
return(this as IFluentTimeAndAttendance);
}
catch (Exception ex)
{
throw new Exception(GetMyMethodName(), ex);
}
}
public void TestUpdateTAPunchin()
{
long timePunchinId = 3;
//UnitOfWork unitOfWork = new UnitOfWork();
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendancePunchIn taPunchinLookUp = taMod.TimeAndAttendance.Query().GetPunchInById(timePunchinId);
taPunchinLookUp.DurationInMinutes = 480;
taPunchinLookUp.MealDurationInMinutes = 30;
taMod.TimeAndAttendance.UpdatePunchIn(taPunchinLookUp).Apply();
Assert.True(true);
}
public async Task TestUpdateTAPunchin()
{
long?timePunchinId = 3;
//UnitOfWork unitOfWork = new UnitOfWork();
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendancePunchIn taPunchinLookUp = await taMod.TimeAndAttendance.Query().GetEntityById(timePunchinId);
taPunchinLookUp.DurationInMinutes = 480;
taPunchinLookUp.MealDurationInMinutes = 30;
int mealDeduction = 0;
taMod.TimeAndAttendance.UpdatePunchIn(taPunchinLookUp, mealDeduction).Apply();
Assert.True(true);
}
public async Task <IActionResult> CreatePunchin([FromBody] TimeAndAttendanceParam param)
{
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendancePunchIn taPunchin = null;
TimeAndAttendanceTimeView currentTime = await taMod.TimeAndAttendance.Query().GetUTCAdjustedTime();
DateTime asOfDate = currentTime.PunchDate;
taPunchin = await taMod.TimeAndAttendance.Query().BuildPunchin(param.EmployeeId, param.Account, asOfDate);
taMod.TimeAndAttendance.AddPunchIn(taPunchin).Apply();
TimeAndAttendancePunchInView view = null;
view = await taMod.TimeAndAttendance.Query().GetPunchOpenView(param.EmployeeId);
return(Ok(view));
}
public void TestAddTAPunchin()
{
//UnitOfWork unitOfWork = new UnitOfWork();
DateTime punchinDate = DateTime.Parse("6/24/2018 08:01:02");
int employeeId = 3;
int jobCodeXrefId = 31;
int supervisorId = 1;
int typeOfTimeUdcXrefId = 11;
int approvingAddressId = 1;
int payCodeXrefId = 16;
int scheduleId = 1;
TimeAndAttendancePunchIn taPunchin = new TimeAndAttendancePunchIn();
taPunchin.PunchinDate = punchinDate;
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
string punchinDateTime = taMod.TimeAndAttendance.FormatPunchDateTime(taPunchin.PunchinDate);
taPunchin.PunchinDateTime = punchinDateTime;
taPunchin.EmployeeId = employeeId;
taPunchin.JobCodeXrefId = jobCodeXrefId;
taPunchin.SupervisorId = supervisorId;
taPunchin.TypeOfTimeUdcXrefId = typeOfTimeUdcXrefId;
taPunchin.ApprovingAddressId = approvingAddressId;
taPunchin.PayCodeXrefId = payCodeXrefId;
taPunchin.ScheduleId = scheduleId;
taMod.TimeAndAttendance.AddPunchIn(taPunchin).Apply();
//TODO Get the new created punchin
TimeAndAttendancePunchIn taPunchinLookUp = taMod.TimeAndAttendance.Query().GetPunchInByExpression(e => e.PunchinDateTime == punchinDateTime && e.EmployeeId == employeeId);
//TimeAndAttendancePunchIn taPunchinLookUp= taMod.Query().GetPunchInById(timePunchinId);
taMod.TimeAndAttendance.DeletePunchIn(taPunchinLookUp).Apply();
Assert.True(true);
}
public async Task <IActionResult> UpdatePunch([FromBody] TimeAndAttendanceParam param)
{
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendancePunchIn taPunchin = null;
TimeAndAttendanceTimeView currentTime = await taMod.TimeAndAttendance.Query().GetUTCAdjustedTime();
DateTime asOfDate = currentTime.PunchDate;
taPunchin = await taMod.TimeAndAttendance.Query().GetPunchOpen(param.EmployeeId);
taMod.TimeAndAttendance.UpdatePunchIn(taPunchin, param.MealDeduction).Apply();
TimeAndAttendancePunchInView view = null;
//view = await taMod.TimeAndAttendance.Query().GetPunchOpenView(param.employeeId);
view = await taMod.TimeAndAttendance.Query().GetViewById(taPunchin.TimePunchinId);
return(Ok(view));
}
public async Task TestScheduledToWorkPunchin()
{
long employeeId = 1;
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
//DateTime asOfDate = DateTime.Now;
TimeAndAttendanceTimeView currentTime = await taMod.TimeAndAttendance.Query().GetUTCAdjustedTime();
string account = "1200.215";
TimeAndAttendancePunchIn openTA = await taMod.TimeAndAttendance.Query().IsPunchOpen(employeeId, currentTime.PunchDate);
if (openTA == null)
{
TimeAndAttendancePunchIn taPunchin = await taMod.TimeAndAttendance.Query().BuildPunchin(employeeId, account, currentTime.PunchDate);
taMod.TimeAndAttendance.AddPunchIn(taPunchin).Apply();
}
}
public async Task TestAddTimeByDuration()
{
//No UTC lookup time
long employeeId = 1;
int hours = 9;
int minutes = 0;
int mealDurationInMinutes = 0;
DateTime workDay = DateTime.Now;
string account = "1200.215";
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendancePunchIn openTA = await taMod.TimeAndAttendance.Query().IsPunchOpen(employeeId, workDay);
if (openTA != null)
{
TimeAndAttendancePunchIn taPunchin = await taMod.TimeAndAttendance.Query().BuildByTimeDuration(employeeId, hours, minutes, mealDurationInMinutes, workDay, account);
taMod.TimeAndAttendance.AddPunchIn(taPunchin).Apply();
}
}
public async Task TestPunchOut()
{
long employeeId = 1;
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendancePunchIn taPunchin = null;
DateTime asOfDate = DateTime.Now;
string account = "1200.215";
int mealDeduction = 0;
TimeAndAttendancePunchIn openTA = await taMod.TimeAndAttendance.Query().IsPunchOpen(employeeId, asOfDate);
if (openTA == null)
{
taPunchin = await taMod.TimeAndAttendance.Query().BuildPunchin(employeeId, account, asOfDate);
taMod.TimeAndAttendance.AddPunchIn(taPunchin).Apply();
Thread.Sleep(60000);
taMod.TimeAndAttendance.UpdatePunchIn(taPunchin, mealDeduction).Apply();
}
else
{
Thread.Sleep(60000);
taMod.TimeAndAttendance.UpdatePunchIn(openTA, mealDeduction).Apply();
}
//taPunchin = await taMod.TimeAndAttendance.Query().GetPunchOpen(employeeId);
taPunchin = await taMod.TimeAndAttendance.Query().GetEntityById(taPunchin.TimePunchinId);
Assert.NotNull(taPunchin.PunchinDate);
// taMod.TimeAndAttendance.DeletePunchIn(taPunchin).Apply();
}
public async Task <IActionResult> ManualPunchOut(TimeAndAttendanceParam param)
{
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendancePunchIn taPunchin = null;
TimeAndAttendancePunchInView view = null;
//long employeeId=1;
//string account = "1200.215";
//int mealDeduction = 30;
//int manual_elapsedHours = 12;
//int manual_elapsedMinutes = 30;
TimeAndAttendancePunchIn openTA = await taMod.TimeAndAttendance.Query().IsPunchOpen(param.EmployeeId, param.AsOfDate);
if (openTA != null)
{
taMod.TimeAndAttendance.UpdatePunchIn(openTA, param.MealDeduction, param.Manual_ElapsedHours, param.Manual_ElapsedMinutes).Apply();
taPunchin = await taMod.TimeAndAttendance.Query().GetEntityById(openTA.TimePunchinId);
view = await taMod.TimeAndAttendance.Query().MapToView(taPunchin);
}
else
{
taPunchin = await taMod.TimeAndAttendance.Query().BuildPunchin(param.EmployeeId, param.Account, param.AsOfDate);
taMod.TimeAndAttendance.AddPunchIn(taPunchin).Apply();
taPunchin = await taMod.TimeAndAttendance.Query().GetPunchOpen(param.EmployeeId);
taMod.TimeAndAttendance.UpdatePunchIn(taPunchin, param.MealDeduction, param.Manual_ElapsedHours, param.Manual_ElapsedMinutes).Apply();
taPunchin = await taMod.TimeAndAttendance.Query().GetEntityById(taPunchin.TimePunchinId);
view = await taMod.TimeAndAttendance.Query().MapToView(taPunchin);
}
return(Ok(view));
//Assert.NotNull(taPunchin.PunchinDate);
}
public async Task TestGetPunchOpenView()
{
long employeeId = 1;
DateTime asOfDate = DateTime.Now;
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
TimeAndAttendancePunchInView view = null;
string account = "1200.215";
TimeAndAttendancePunchIn taPunchin = null;
taPunchin = await taMod.TimeAndAttendance.Query().BuildPunchin(employeeId, account, asOfDate);
taMod.TimeAndAttendance.AddPunchIn(taPunchin).Apply();
view = await taMod.TimeAndAttendance.Query().GetPunchOpenView(employeeId);
taPunchin = await taMod.TimeAndAttendance.Query().GetEntityById(view.TimePunchinId ?? 0);
taMod.TimeAndAttendance.DeletePunchIn(taPunchin).Apply();
Assert.True(view != null);
}
