public async Task <IActionResult> GetTimeAndAttendanceByPage(long employeeId, int pageNumber, int pageSize)
{
DataService ds = new DataService(this._baseUrl);
PageListViewContainer <TimeAndAttendancePunchInView> container = await ds.GetAsync <PageListViewContainer <TimeAndAttendancePunchInView> >("api/TimeAndAttendance/TAPunchPage/" + employeeId.ToString() + "/" + pageNumber.ToString() + "/" + pageSize.ToString());
return(Ok(container));
}
public async Task <PageListViewContainer <GeneralLedgerView> > GetViewsByPage(Expression <Func <GeneralLedger, bool> > predicate, Expression <Func <GeneralLedger, object> > order, int pageSize, int pageNumber)
{
try
{
var query = _unitOfWork.generalLedgerRepository.GetEntitiesByExpression(predicate);
query = query.OrderByDescending(order).Select(e => e);
IPagedList <GeneralLedger> list = await query.ToPagedListAsync(pageNumber, pageSize);
PageListViewContainer <GeneralLedgerView> container = new PageListViewContainer <GeneralLedgerView>();
container.PageNumber = pageNumber;
container.PageSize = pageSize;
container.TotalItemCount = list.TotalItemCount;
foreach (var item in list)
{
GeneralLedgerView view = await MapToView(item);
container.Items.Add(view);
}
return(container);
}
catch (Exception ex)
{
throw new Exception(GetMyMethodName(), ex);
}
}
public async Task TestSalesOrderPaging()
{
SalesOrderModule salesOrderMod = new SalesOrderModule();
long? salesOrderId = 69;
PageListViewContainer <SalesOrderView> container = await salesOrderMod.SalesOrder.Query().GetViewsByPage(predicate: e => e.SalesOrderId == salesOrderId, order: e => e.SalesOrderId, pageSize: 1, pageNumber: 1);
Assert.True(container.TotalItemCount > 0);
}
public async Task TestGeneralLedgerPaging()
{
long generalLedgerId = 1;
GeneralLedgerModule glMod = new GeneralLedgerModule();
PageListViewContainer <GeneralLedgerView> container = await glMod.GeneralLedger.Query().GetViewsByPage(predicate: e => e.GeneralLedgerId == generalLedgerId, order: e => e.GeneralLedgerId, pageSize: 1, pageNumber: 1);
Assert.True(container.TotalItemCount > 0);
}
public async Task TestAddressBookPaging()
{
long addressId = 1;
AddressBookModule abMod = new AddressBookModule();
PageListViewContainer <AddressBookView> container = await abMod.AddressBook.Query().GetViewsByPage(predicate: e => e.AddressId == addressId, order: e => e.AddressId, pageSize: 1, pageNumber: 1);
Assert.True(container.TotalItemCount > 0);
}
public async Task <PageListViewContainer <ShipmentView> > GetViewsByPage(Expression <Func <Shipment, bool> > predicate, Expression <Func <Shipment, object> > order, int pageSize, int pageNumber)
{
try
{
//IEnumerable<SalesOrder> query = _dbContext.SalesOrder.Where(predicate).OrderByDescending(order).Select(e => e);
//var query = _dbContext.Shipment.Where(predicate).OrderByDescending(order).Select(e => e);
//
var query = _unitOfWork.shipmentRepository.GetEntitiesByExpression(predicate);
query = query.OrderByDescending(order).Select(e => e);
IPagedList <Shipment> list = await query.ToPagedListAsync(pageNumber, pageSize);
PageListViewContainer <ShipmentView> container = new PageListViewContainer <ShipmentView>();
container.PageNumber = pageNumber;
container.PageSize = pageSize;
container.TotalItemCount = list.TotalItemCount;
ShipmentView view;
foreach (var item in list)
{
view = await MapToView(item);
IList <ShipmentDetail> listDetails = await _unitOfWork.shipmentDetailRepository.GetEntitiesByShipmentId(item.ShipmentId);
foreach (var item2 in listDetails)
{
view.ShipmentDetailViews.Add(await MapToDetailView(item2));
}
container.Items.Add(view);
}
await Task.Yield();
//await Task.Yield();
return(container);
}
catch (Exception ex)
{
throw new Exception(GetMyMethodName(), ex);
}
}
//[ProducesResponseType(typeof(TimeAndAttendanceViewContainer), StatusCodes.Status200OK)]
//public async Task<IActionResult> GetTimeAndAttendanceByPage(long employeeId,int pageNumber,int pageSize)
public async Task <PageListViewContainer <TimeAndAttendancePunchInView> > GetTimeAndAttendanceByPage(long employeeId, int pageNumber, int pageSize)
{
//int pageSize = 1;
//int pageNumber = 1;
//int employeeId = 3;
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
Expression <Func <TimeAndAttendancePunchIn, bool> > predicate = e => e.EmployeeId == employeeId;
Expression <Func <TimeAndAttendancePunchIn, object> > order = e => e.PunchinDateTime;
PageListViewContainer <TimeAndAttendancePunchInView> container = await taMod.TimeAndAttendance.Query().GetViewsByPage(predicate, order, pageSize, pageNumber);
return(container);
//return Ok(container);
}
public async Task TestMoveTo()
{
int pageSize = 1;
int pageNumber = 1;
int employeeId = 3;
TimeAndAttendanceModule taMod = new TimeAndAttendanceModule();
Expression <Func <TimeAndAttendancePunchIn, bool> > predicate = e => e.EmployeeId == employeeId && e.PunchinDate == DateTime.Parse("6/23/2018");
Expression <Func <TimeAndAttendancePunchIn, object> > order = e => e.PunchinDateTime;
PageListViewContainer <TimeAndAttendancePunchInView> container = await taMod.TimeAndAttendance.Query().GetViewsByPage(predicate, order, pageSize, pageNumber);
foreach (var item in container.Items)
{
output.WriteLine($"{item.EmployeeId} Date: {item.PunchinDateTime} Duration: {item.DurationInMinutes}");
}
Assert.True(container.TotalItemCount > 0);
}
public async Task <PageListViewContainer <TimeAndAttendanceScheduleView> > GetViewsByPage(Expression <Func <TimeAndAttendanceSchedule, bool> > predicate, Expression <Func <TimeAndAttendanceSchedule, object> > order, int pageSize, int pageNumber)
{
var query = _unitOfWork.timeAndAttendanceScheduleRepository.GetEntitiesByExpression(predicate);
query = query.OrderByDescending(order).Select(e => e);
IPagedList <TimeAndAttendanceSchedule> list = await query.ToPagedListAsync(pageNumber, pageSize);
PageListViewContainer <TimeAndAttendanceScheduleView> container = new PageListViewContainer <TimeAndAttendanceScheduleView>();
container.PageNumber = pageNumber;
container.PageSize = pageSize;
container.TotalItemCount = list.TotalItemCount;
foreach (var item in list)
{
TimeAndAttendanceScheduleView view = await MapToView(item);
container.Items.Add(view);
}
//await Task.Yield();
return(container);
}
