public async Task <IActionResult> SearchManager([FromQuery] PaginationParams param, ManagerParam filterParam)
{
var data = await _serviceManager.SearchWithPaginations(param, filterParam);
Response.AddPagination(data.CurrentPage, data.PageSize, data.TotalCount, data.TotalPages);
return(Ok(data));
}
public async Task <PagedList <Receive> > SearchWithPaginations(PaginationParams param, ManagerParam filterParam)
{
var receives = _repoReceive.FindAll(x => x.Status.Trim() == "1");
var departments = _repoDepartment.FindAll();
if (!String.IsNullOrEmpty(filterParam.from_Date))
{
receives = receives.Where(x => x.Register_Date >= Convert.ToDateTime(filterParam.from_Date +
" 00:00:00") &&
x.Register_Date <= Convert.ToDateTime(filterParam.from_Date + " 23:59:59.997"));
}
if (!String.IsNullOrEmpty(filterParam.receiveID))
{
receives = receives.Where(x => x.ID.Trim() == filterParam.receiveID.Trim());
}
if (!String.IsNullOrEmpty(filterParam.userID))
{
receives = receives.Where(x => x.UserID.Trim() == filterParam.userID.Trim());
}
receives = receives.OrderByDescending(x => x.Register_Date);
// var data = await (from a in receives
// select new Receive_Dto()
// {
// ID = a.ID,
// UserID = a.UserID,
// Accept_ID = a.Accept_ID,
// DepID = a.DepID,
// Register_Date = a.Register_Date,
// Accept_Date = a.Accept_Date,
// Updated_By = a.Updated_By,
// Status = a.Status.Trim(),
// Updated_Time = a.Updated_Time
// }).OrderByDescending(x => x.Register_Date).ToListAsync();
return(await PagedList <Receive> .CreateAsync(receives, param.PageNumber, param.PageSize));
}
public async Task <IActionResult> GetReceivePagination([FromQuery] PaginationParams param, ManagerParam filterParam)
{
var userCurrent = User.FindFirst(ClaimTypes.NameIdentifier).Value;
var receives = await _serviceApproval.SearchWithPaginations(param, filterParam, userCurrent);
Response.AddPagination(receives.CurrentPage, receives.PageSize, receives.TotalCount, receives.TotalPages);
return(Ok(receives));
}
public async Task <PagedList <ReceiveInformationModel> > SearchWithPaginations(PaginationParams param, ManagerParam filterParam, string userAccept)
{
var user = _repoUse.FindSingle(x => x.ID.Trim() == userAccept.Trim());
var products = _repoProduct.FindAll();
var receives = _repoReceive.FindAll(x => x.DepID.Trim() == user.DepID &&
x.Status == "0");
if (!String.IsNullOrEmpty(filterParam.from_Date))
{
receives = receives.Where(x => x.Register_Date >= Convert.ToDateTime(filterParam.from_Date +
" 00:00:00") &&
x.Register_Date <= Convert.ToDateTime(filterParam.from_Date + " 23:59:59.997"));
}
if (!String.IsNullOrEmpty(filterParam.receiveID))
{
receives = receives.Where(x => x.UserID == filterParam.receiveID.Trim());
}
var data = (from a in receives
// join b in products on a.ProductID equals b.ID
select new ReceiveInformationModel()
{
ID = a.ID,
UserID = a.UserID,
Accept_ID = a.Accept_ID,
DepID = a.DepID,
// ProductID = a.ProductID,
// ProductName = b.Name,
// Qty = a.Qty,
Register_Date = a.Register_Date,
Accept_Date = a.Accept_Date,
Status = a.Status,
Updated_By = a.Updated_By,
Updated_Time = a.Updated_Time
}).OrderByDescending(x => x.Register_Date);
return(await PagedList <ReceiveInformationModel> .CreateAsync(data, param.PageNumber, param.PageSize));
}
public async Task <PagedList <Receive> > SearchWithPaginations(PaginationParams param, ManagerParam filterParam)
{
var receives = _repoReceive.FindAll(x => x.Status.Trim() == "1");
var departments = _repoDepartment.FindAll();
if (!String.IsNullOrEmpty(filterParam.from_Date))
{
receives = receives.Where(x => x.Register_Date >= Convert.ToDateTime(filterParam.from_Date +
" 00:00:00") &&
x.Register_Date <= Convert.ToDateTime(filterParam.from_Date + " 23:59:59.997"));
}
if (!String.IsNullOrEmpty(filterParam.receiveID))
{
receives = receives.Where(x => x.ID.Trim() == filterParam.receiveID.Trim());
}
if (!String.IsNullOrEmpty(filterParam.userID))
{
receives = receives.Where(x => x.UserID.Trim() == filterParam.userID.Trim());
}
receives = receives.OrderByDescending(x => x.Register_Date);
return(await PagedList <Receive> .CreateAsync(receives, param.PageNumber, param.PageSize));
}
