public async Task <ActionResult <PagedList <DtoClient> > > GetAll([FromQuery] DtoFilterPagedList pagedListParams)
{
PagedList <DtoClient> listUsers = await _clientService.GetAllClients(pagedListParams);
if (listUsers == null || !listUsers.Any())
{
return(NotFound());
}
return(Ok(listUsers));
}
public async Task <Response <PagedList <OrderResource> > > Handle(GetCurrentUserOrdersQuery request, CancellationToken cancellationToken)
{
PagedList <Order> pagedOrder = await orderRepo.GetOrderPerPageAsync(request as OrderPaginationParams);
if (pagedOrder.Any())
{
PagedList <OrderResource> poagedOrderResource = pagedConvertor.orderPagedToResource(pagedOrder);
return(Response.Ok <PagedList <OrderResource> >(poagedOrderResource));
}
return(Response.Fail <PagedList <OrderResource> >("سفارشی یافت نشد", StatusCodeEnum.NOTFUOUND));
}
public async Task <Response <PagedList <CommentResource> > > Handle(GetCurrentUserCommentsQuery request, CancellationToken cancellationToken)
{
PagedList <Comment> pagedComment = await commentRepo.GetCommentPerPage(request as CommentPaginationParams);
if (pagedComment.Any())
{
PagedList <CommentResource> pagedCommentResource = pagedConvertor.CommentPagedToResource(pagedComment);
return(Response.Ok <PagedList <CommentResource> >(pagedCommentResource));
}
return(Response.Fail <PagedList <CommentResource> >("هیچ کامنتی وجود ندارد", StatusCodeEnum.NOTFUOUND));
}
public async Task <Response <PagedList <BookResource> > > Handle(GetBooksPerPageQuery request, CancellationToken cancellationToken)
{
PagedList <Book> pagedBook = await bookRepo.GetBooksPerPage(request as BookPaginationParams);
if (pagedBook.Any())
{
PagedList <BookResource> pagedBookResource = pagedConvertor.bookPagedToResource(pagedBook);
return(Response.Ok <PagedList <BookResource> >(pagedBookResource));
}
else
{
return(Response.Fail <PagedList <BookResource> >("هیچ کتابی با این مشخصات وجود ندارد", StatusCodeEnum.NOTFUOUND));
}
}
public HttpResponseMessage GetGroupList(TechnicianApiViewModel data)
{
try
{
var user = ((PtcIdentity)this.User.Identity).currentUser;
var con = new Conditions <DataBase.TTechnicianGroup>(data.pageSize, data.page);
con.Include(x => x.TTechnicianGroupClaims
.Select(y => y.TVenderTechnician));
con.And(x => x.VendorCd == user.VenderCd &&
x.CompCd == user.CompCd);
if (!string.IsNullOrEmpty(data.keyword))
{
con.And(x => x.GroupName.Contains(data.keyword));
}
PagedList <TtechnicianGroup> list = _technicianGroupRepo.GetList(con);
if (!list.Any())
{
return(Request.CreateResponse(
HttpStatusCode.OK, new JsonResult <List <TechnicianGPResultApiViewModel> >()
{
isSuccess = true,
element = new List <TechnicianGPResultApiViewModel>(),
message = "無資料",
totalCount = 0,
}));
}
IEnumerable <TechnicianGPResultApiViewModel> result = list.Select(x => new TechnicianGPResultApiViewModel(x));
return(Request.CreateResponse(
HttpStatusCode.OK,
new JsonResult <IEnumerable <TechnicianGPResultApiViewModel> >(result, "[廠商]廠商技師群組查詢成功", con.TotalCount, true)));
}
catch (Exception ex)
{
_logger.Error(ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest,
$"{ ex.GetType().Name}:Message:{ex.Message}"));
}
}
static void AssertCheckResults(PagedList <User> users, UserParams userParams, bool useExpectedCount = false, int expectedCount = 0)
{
Console.WriteLine();
Console.WriteLine($"Test Number: {++TestCount}");
foreach (var user in users)
{
Console.WriteLine($"user.Id: {user.Id}");
}
if (useExpectedCount) // use expected count if there is a likee/liker filter
{
Console.WriteLine($"users.Count: {users.Count}, expectedCount: {expectedCount}");
Assert.IsTrue(users.Count == expectedCount); // should be x users found based on parameters
}
else
{
Console.WriteLine($"users.Count: {users.Count}, userParams.PageSize: {userParams.PageSize}");
Assert.IsTrue(users.Count == userParams.PageSize); // should be x users found based on parameters
}
Assert.IsFalse(users.Any(u => u.Id == userParams.UserId)); // should not include self in results
}
private void FetchAndIncludeReplies(CommentDbContext dbContext, PagedList <Comment> parentComments, CommentSearchCondition commentSearchCondition, bool fetchCountOnly)
{
if (parentComments == null || !parentComments.Any())
{
return;
}
var parentCommentIds = parentComments.Select(x => x.Id).ToArray();
var childComments = dbContext.Comments.Where(x => parentCommentIds.Contains(x.ParentId));
foreach (var parent in parentComments)
{
if (fetchCountOnly)
{
parent.Replies = childComments.Where(child => child.ParentId == parent.Id).OrderByDescending(p => p.CreatedOn).ToPagedList(true);
}
else
{
parent.Replies = childComments.Where(child => child.ParentId == parent.Id).OrderByDescending(p => p.CreatedOn).ToPagedList(commentSearchCondition.PageNumber, commentSearchCondition.PageSize);
FetchAndIncludeReplies(dbContext, parent.Replies, commentSearchCondition, true);
}
}
}
/// <summary>
/// 二手房的联络列表
/// </summary>
/// <param name="queryDto"></param>
/// <returns></returns>
public ContactByResaleHouseDto SearchByResaleHouseId(ContactByResaleHouseQueryDto queryDto)
{
var userQuery = db.GetUserQuery();
var query = from contact in db.MlsContactRecordLogQuery
join user in userQuery on contact.UserId equals user.UserId
where contact.ResourcesId == queryDto.HouseId && contact.Type == (int)EnumHosueCommonType.ResaleHouse
orderby contact.CreateTime descending
select new ResaleHouseContactListDto
{
UserInfo = user,
OperationType = (ContactEnum)contact.OperationType,
CreateTime = contact.CreateTime,
//HowTimes = 10,
Id = contact.Id
};
PagedList <ResaleHouseContactListDto> list = query.GetPagedList(queryDto.PageIndex, queryDto.PageSize);
if (list.Any())
{
var sqlList = new List <string>();
foreach (var item in list)
{
sqlList.Add($"SELECT CONVERT(bigint,{item.Id}) AS ID ,COUNT(0) AS Value,NULL AS Code FROM MlsContactRecordLog WHERE Id<={item.Id} AND UserId={item.UserInfo.UserId} AND OperationType={(int)item.OperationType}");
}
var sql = string.Join(" UNION ALL ", sqlList);
foreach (var item in this.db.IDValueDto.FromSqlRaw(sql))
{
list.Where(c => c.Id == (int)item.ID).First().HowTimes = item.Value;
}
}
var data = new PagedList <ResaleHouseContactListDto>(list.CurrentPageIndex, list.PageSize, list.TotalItemCount);
data.AddRange(list);
var res = new ContactByResaleHouseDto()
{
ContactPage = data
};
res.HouseInfo = (from housenew in db.ChineseHouseNewQuery
join communities in db.ChineseCommunitiesQuery on housenew.CommunityId equals communities.Id
where housenew.Id == queryDto.HouseId
select new HouseByContactDto
{
Id = housenew.Id,
Areas = housenew.Areas,
RentPrice = housenew.RentPrice,
TotalPrice = housenew.TotalPrice,
ResaleHouseCommodityType = (EnumResaleHouseCommodityType)housenew.HouseSource,
CommissionPartnerType = housenew.CommissionPartnerType.GetValueOrDefault(0),
CommissionPartner = housenew.CommissionPartner.GetValueOrDefault(0),
CommissionPartnerPercent = housenew.CommissionPartnerPercent.GetValueOrDefault(0),
BedRoomsCount = housenew.BedRoomsCount.GetValueOrDefault(0),
BathRoomsCount = housenew.BathRoomsCount.GetValueOrDefault(0),
MainPhotoUrl = housenew.MainPhoto,
CommunityName = housenew.CommunityName,
AreaName = communities.AreaName,
CityName = communities.CityName,
IsMls = housenew.ShareToFdb == 2
}).First();
return(res);
}
private void FetchAndIncludeReplies(CommentDbContext dbContext, PagedList<Comment> parentComments, CommentSearchCondition commentSearchCondition, bool fetchCountOnly)
{
if (parentComments == null || !parentComments.Any()) return;
var parentCommentIds = parentComments.Select(x => x.Id).ToArray();
var childComments = dbContext.Comments.Where(x => parentCommentIds.Contains(x.ParentId));
foreach (var parent in parentComments)
{
if (fetchCountOnly)
{
parent.Replies = childComments.Where(child => child.ParentId == parent.Id).OrderByDescending(p => p.CreatedOn).ToPagedList(true);
}
else
{
parent.Replies = childComments.Where(child => child.ParentId == parent.Id).OrderByDescending(p => p.CreatedOn).ToPagedList(commentSearchCondition.PageNumber, commentSearchCondition.PageSize);
FetchAndIncludeReplies(dbContext, parent.Replies, commentSearchCondition, true);
}
}
}
public static IHtmlString BuildFormTable(this HtmlHelper htmlHelper, PagedList <SQLDynamicRow> sQLDynamicRow, int page, string code)
{
if (!sQLDynamicRow.Any())
{
return(htmlHelper.BuildByKey("formEmpty"));
}
var dynamicDataservices = Common.Injection.Core.IoC.Container.Resolve <IDynamicDataservices>();
var field = dynamicDataservices.GetDyncFieldByFormCode(code);
var row = sQLDynamicRow.FirstOrDefault().Row.ToList();
var head = new List <string>();
for (int i = 0; i < row.Count(); i++)
{
if (row[i].Name == "Id")
{
continue;
}
var item = field.Where(t => t.Name == row[i].Name).FirstOrDefault();
if (item.IsNull())
{
continue;
}
head.Add(item.Lbl);
}
var tuple = new List <Tuple <IList <string>, Func <string> > >();
for (int i = 0; i < sQLDynamicRow.Count; i++)
{
var content = new List <string>();
var item = sQLDynamicRow[i].Row.ToList();
var id = string.Empty;
for (int j = 0; j < item.Count(); j++)
{
if (item[j].Name == "Id")
{
id = item[j].Value;
continue;
}
var v = field.Where(t => t.Name == item[j].Name).FirstOrDefault();
if (v.IsNull())
{
continue;
}
if (v.SourceValue.IsNotNullOrEmpty() && (v.Type == "radio" || v.Type == "checkbox"))
{
content.Add(GetLabel(v, item[j]));
}
else
{
content.Add(item[j].Value);
}
}
tuple.Add(new Tuple <IList <string>, Func <string> >(content, () =>
{
return(FormTemp.GetTempByKey("formInfoLink", id, code, page.ToString()));
}));
}
return(htmlHelper.BuildByTable(new Tuple <IList <string>, IList <Tuple <IList <string>, Func <string> > >, bool>(head,
tuple, true)));
}
