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);
}
