public async Task <VirtualizeResponse <SpProductSearchResult> > ProductSearchWithPaging(ProductSearchFilter model) { var output = new VirtualizeResponse <SpProductSearchResult>(); var itemCounts = new OutputParameter <int?>(); var returnValues = new OutputParameter <int>(); var result = await CmsContext.GetProcedures().SpProductSearchAsync( model.Keyword, model.ProductCategoryId, model.ProductManufactureId, model.ProductStatusId, model.CountryId, model.LocationId, model.DepartmentManId, model.ProductBrandId, model.ProductTypeId, model.ExceptionId, model.ExceptionProductTop, model.FromPrice, model.ToPrice, model.FromDate, model.ToDate, model.Efficiency, model.Active, model.AssignBy, model.CreateBy, model.OrderBy, model.PageSize, model.CurrentPage, itemCounts, returnValues ); output.Items = result.ToList(); output.TotalSize = (int)itemCounts.Value; return(output); }
public async Task <VirtualizeResponse <UserNotifySearchResult> > GetAllNoti(int?UserNotifyTypeId, string AspNetUsersId, bool?Readed, int PageSize, int CurrentPage) { var output = new VirtualizeResponse <UserNotifySearchResult>(); var itemCounts = new OutputParameter <int?>(); var returnValues = new OutputParameter <int>(); var userId = new Guid(); if (Guid.TryParse(AspNetUsersId, out Guid _userId)) { userId = _userId; } var result = await CmsContext.GetProcedures().UserNotifySearchAsync( null, userId, Readed, PageSize, CurrentPage, itemCounts, returnValues ); output.Items = result.ToList(); output.TotalSize = (int)itemCounts.Value; return(output); }
public async Task <VirtualizeResponse <ArticleSearchResult> > ArticleSearchWithPaging(ArticleSearchFilter model) { var output = new VirtualizeResponse <ArticleSearchResult>(); var itemCounts = new OutputParameter <int?>(); var returnValues = new OutputParameter <int>(); var result = await CmsContext.GetProcedures().ArticleSearchAsync( model.Keyword, model.Tags, model.ArticleCategoryId, model.ArticleStatusId, model.ProductBrandId, model.ArticleTypeId, model.ExceptionId, model.ExceptionArticleTop, model.FromDate, model.ToDate, model.Efficiency, model.Active, model.CreateBy, model.PageSize, model.CurrentPage, itemCounts, returnValues ); output.Items = result.ToList(); output.TotalSize = (int)itemCounts.Value; return(output); }
public async Task <VirtualizeResponse <AccountSearchResult> > GetLstUsersPaging(AccountSearchFilter model) { var output = new VirtualizeResponse <AccountSearchResult>(); var itemCounts = new OutputParameter <int?>(); var returnValues = new OutputParameter <int>(); var result = await CmsContext.GetProcedures().AccountSearchAsync( model.Keyword, model.RoleId, model.Active, model.PageSize, model.CurrentPage, itemCounts, returnValues ); output.Items = result.ToList(); output.TotalSize = (int)itemCounts.Value; return(output); }
public async Task <VirtualizeResponse <SpArticleCommentStaffSearchResult> > ArticleCommentStaffSearch(ArticleCommentStaffSearchFilter model) { var output = new VirtualizeResponse <SpArticleCommentStaffSearchResult>(); var itemCounts = new OutputParameter <int?>(); var returnValues = new OutputParameter <int>(); var result = await CmsContext.GetProcedures().SpArticleCommentStaffSearchAsync( model.Keyword, model.ArticleId, model.Active, model.CreateBy, model.PageSize, model.CurrentPage, itemCounts, returnValues ); output.Items = result.ToList(); output.TotalSize = (int)itemCounts.Value; return(output); }
public async Task <List <ArticleGetByBlockIdResult> > ArticleGetByBlockId(int ArticleBlockId) { var output = new List <ArticleGetByBlockIdResult>(); ////Parameter //var pArticleBlockId = new SqlParameter("@ArticleBlockId", ArticleBlockId); //try //{ // output = await CmsContext.Set<ArticleGetByBlockIdResult>() // .FromSqlRaw($"EXECUTE dbo.ArticleGetByBlockId " // + $"@ArticleBlockId = @ArticleBlockId", pArticleBlockId) // .AsNoTracking() // .ToListAsync(); //} //catch //{ //} //output = CmsContextProcedures. var result = await CmsContext.GetProcedures().ArticleGetByBlockIdAsync(ArticleBlockId); output = result.ToList(); return(output); }