public async Task <PagedList <Receive> > GetWithPaginations(PaginationParams param) { var receives = _repoReceive.FindAll(x => x.Status == "1"); receives = receives.OrderByDescending(x => x.Register_Date); return(await PagedList <Receive> .CreateAsync(receives, param.PageNumber, param.PageSize)); }
public async Task <PagedList <ReceiveInformationModel> > GetWithPaginations(PaginationParams param, string userID) { var user = _repoUse.FindSingle(x => x.ID.Trim() == userID.Trim()); var products = _repoProduct.FindAll(); var receives = _repoReceive.FindAll(x => x.DepID.Trim() == user.DepID && x.Status == "0"); 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 <ReceiveInformationModel> > GetWithPaginations(PaginationParams param, string user) { var receives = _repoReceive.FindAll(x => x.Status.Trim() != "-1"); var products = _repoProduct.FindAll(); var users = _repoUser.FindAll(); var departments = _repoDepartment.FindAll(); var userLogin = _repoUser.FindSingle(x => x.ID.Trim() == user.Trim()); if (userLogin.RoleID == 0 || userLogin.RoleID == 1) { } else if (userLogin.RoleID == 2) { receives = receives.Where(x => x.DepID.Trim() == userLogin.DepID.Trim() && x.Status.Trim() != "2"); } else if (userLogin.RoleID == 3) { receives = receives.Where(x => x.UserID.Trim() == user); } var data = await(from a in receives // join b in products on a.ProductID.Trim() equals b.ID.Trim() join c in departments on a.DepID.Trim() equals c.ID.Trim() join d in users on a.UserID.Trim() equals d.ID.Trim() select new ReceiveInformationModel() { ID = a.ID, UserID = a.UserID, UserName = d.Name, Accept_ID = a.Accept_ID, DepID = a.DepID, DepName = c.Name_LL, DepName_ZW = c.Name_ZW, // ProductID = a.ProductID, // ProductName = b.Name, // Qty = a.Qty, 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(); foreach (var item in data) { if (item.Accept_ID != null) { var userAccept = _repoUser.FindSingle(x => x.ID.Trim() == item.Accept_ID.Trim()); if (userAccept != null) { item.AcceptName = userAccept.Name; } } } return(PagedList <ReceiveInformationModel> .Create(data, param.PageNumber, param.PageSize)); }
public async Task <PagedList <ReceiveInformationModel> > GetWithPaginations(PaginationParams param) { var products = _repoProduct.FindAll(); var categorys = _repoCategory.FindAll(); var receives = _repoReceive.FindAll(x => x.Status == "1"); var departments = _repoDepartment.FindAll(); var data = (from r in receives join p in products on r.ProductID.Trim() equals p.ID.Trim() join c in categorys on p.CatID equals c.ID join d in departments on r.DepID.Trim() equals d.ID.Trim() select new ReceiveInformationModel() { ID = r.ID, UserID = r.UserID, Accept_ID = r.Accept_ID, DepID = r.DepID, DepName = d.Name_LL, CategoryID = c.ID, ProductID = r.ProductID, ProductName = p.Name, Qty = r.Qty, Register_Date = r.Register_Date, Accept_Date = r.Accept_Date, Updated_Time = r.Updated_Time, Updated_By = r.Updated_By }).OrderByDescending(x => x.Register_Date); return(await PagedList <ReceiveInformationModel> .CreateAsync(data, param.PageNumber, param.PageSize)); }
public async Task <PagedList <Receive> > GetWithPaginations(PaginationParams param, string userID) { var receives = _repoReceive.FindAll(x => x.UserID.Trim() == userID && x.Status != "-1" && x.Status != "2").OrderByDescending(x => x.Updated_Time); return(await PagedList <Receive> .CreateAsync(receives, param.PageNumber, param.PageSize)); }