public async Task <ActionResult> Search(MemberSearchViewModel model) { model.Items = await _itemClient.QueryAsync(User.Identity.Name, model.Filters); model.Filters = ""; return(View(model)); }
public ActionResult Index(MemberSearchViewModel model) { SysUser user = Session[SessionKey.USER] as SysUser; model = this.memberService.searchNPagging(model, user); ViewBag.stepList = DropDownListHelper.getApplyStepListWithAll(); ViewBag.groupList = DropDownListHelper.getAppraiseGroupNameList(true); ViewBag.enrollTypeList = DropDownListHelper.getEnrollTypeList(true); ViewBag.andOrList = DropDownListHelper.getAndOrList(); return(View("Index", model)); }
public ActionResult Search(MemberSearchViewModel model) { if (string.IsNullOrEmpty(model.SearchButton) && !model.Page.HasValue) { model.Results = CreatePagedListOfMembers(this.memberService.All(), model); return(View(model)); } var searchResults = this.memberService.Search(model.Name, model.PostCode, model.Reference); model.Results = CreatePagedListOfMembers(searchResults, model); return(View(model)); }
public async Task <_ListViewModel <MemberListViewModel> > Get(int startRowIndex, int numberOfRows, string firstName, string lastName, string email, string phone, int organizationId, string catchAll , string sortColumn = "DEFAULT", string sortDirection = "ASC" , bool exactMatch = true, string clubReference = "BRIO") { var model = new _ListViewModel <MemberListViewModel>(); try { MemberSearchViewModel search = new MemberSearchViewModel() { CatchAll = catchAll, Email = email, ExactMatch = exactMatch, FistName = firstName, LastName = lastName, NumberOfRows = numberOfRows, OrganizationId = organizationId, Phone = phone, SortColumn = sortColumn, SortDirection = sortDirection, StartRowIndex = startRowIndex, ClubReference = clubReference }; model = await _context.GetMembersAsync(search); } catch (Exception ex) { if (model == null) { model = new _ListViewModel <MemberListViewModel>(); } if (model.Message.Length > 0) { model.Message += " | "; } else { model.Message = "Error: "; } model.Message += ex.Message; } return(model); }
public ActionResult DownloadReport(MemberSearchViewModel model) { SysUser user = Session[SessionKey.USER] as SysUser; MemoryStream memoryStream = new MemoryStream(); try { List <Member> memberList = this.memberService.search(model, user); MemberReport report = new MemberReport(); IWorkbook wb = report.create(memberList); wb.Write(memoryStream); } catch (Exception e) { ViewBag.ErrorMessage = e.Message; } return(File(memoryStream.ToArray(), "application/vnd.ms-excel", "會員資料.xls")); }
public ActionResult Index() { SysUser user = Session[SessionKey.USER] as SysUser; MemberSearchViewModel model = new MemberSearchViewModel(); if (user.role == 1 || user.role == 3) { model.memberTypeNo = 1; model.step = null; model.searchText = null; } else if (user.role == 2) { model.memberTypeNo = 1; model.step = 1; model.searchText = null; model.group = user.group; } return(Index(model)); }
private PagedMemberListViewModel CreatePagedListOfMembers(IEnumerable <Member> memberList, MemberSearchViewModel viewModel) { return(new PagedMemberListViewModel(memberList.ToPagedList(viewModel.Page ?? 1, DefaultPageSize), page => Url.Action("Index", new RouteValueDictionary { { "Page", page }, { "Name", viewModel.Name }, { "PostCode", viewModel.PostCode }, { "Reference", viewModel.Reference } }))); }
public MemberSearchViewModel searchNPagging(MemberSearchViewModel model, SysUser user) { IQueryable <Member> memberQuery = db.Member.Where(m => m.mrMemberTypesqno == model.memberTypeNo && m.mrIsActive == "Y" && m.mrIsFinish == "Y"); #region 經紀仲介學員 if (model.memberTypeNo == 1) { if (model.searchText != null && model.searchText.Trim().Length > 0) //只要這內容不為空就忽略其他條件 { memberQuery = queryByText(memberQuery, model.searchText, model.operate, model.searchText2); model.memberPagedList = memberQuery.OrderBy(m => m.mrNumber).ToPagedList(model.pageNumber - 1, model.pageSize); } else { memberQuery = queryProAndSkill(memberQuery, model.searchText2); if (model.step == null) // 全部階段 { model.memberPagedList = memberQuery.OrderBy(m => m.mrNumber).ToPagedList(model.pageNumber - 1, model.pageSize); } else if (model.step == 0) // 待審核 { memberQuery = queryMemberAtStep0(memberQuery); model.memberPagedList = memberQuery.OrderBy(m => m.mrNumber).ToPagedList(model.pageNumber - 1, model.pageSize); } else if (model.step == 1) // 通過資格審 { memberQuery = queryMemberAtStep1(memberQuery, user); memberQuery = queryFirstAssignGroup(memberQuery, model.group); model.memberPagedList = memberQuery.OrderBy(m => m.mrNumber).ToPagedList(model.pageNumber - 1, model.pageSize); } else if (model.step == 2) // 完成初審 { memberQuery = queryMemberAtStep2(memberQuery, user); memberQuery = queryFirstAssignGroup(memberQuery, model.group); model.memberPagedList = memberQuery .OrderByDescending(m => m.MemberGroupResult.Where(res => res.AppraiseStep == 2).Average(res => res.AppraiseScore)) // 依初審平均分數由高到低排序 .ToPagedList(model.pageNumber - 1, model.pageSize); } else if (model.step == 3) // 進行複審 { memberQuery = queryMemberAtStep3(memberQuery, user); model.memberPagedList = memberQuery .OrderByDescending(m => m.MemberGroupResult.Where(res => res.AppraiseStep == 2).Average(res => res.AppraiseScore)) // 依初審平均分數由高到低排序 .ToPagedList(model.pageNumber - 1, model.pageSize); } else if (model.step == 4) // 完成複審 { memberQuery = queryMemberAtStep4(memberQuery, user); memberQuery = queryFirstAssignGroup(memberQuery, model.group); model.memberPagedList = memberQuery .OrderByDescending(m => m.MemberGroupResult.Where(res => res.AppraiseStep == 4).Average(res => res.AppraiseScore)) // 依複審平均分數由高到低排序 .ToPagedList(model.pageNumber - 1, model.pageSize); } else if (model.step == 5) // 正/備取名單 { memberQuery = queryMemberAtStep5(memberQuery); memberQuery = queryFinalGroup(memberQuery, model.group); memberQuery = queryMemberEnrollType(memberQuery, model.enrollType); model.memberPagedList = memberQuery .OrderByDescending(m => m.MemberGroupResult.Where(res => res.AppraiseStep == 4).Average(res => res.AppraiseScore)) // 依複審平均分數由高到低排序 .ToPagedList(model.pageNumber - 1, model.pageSize); } else if (model.step == 6) //已通過 { memberQuery = queryMemberAtStep6(memberQuery); memberQuery = queryFinalGroup(memberQuery, model.group); memberQuery = queryMemberEnrollType(memberQuery, model.enrollType); model.memberPagedList = memberQuery.OrderBy(m => m.mrNumber).ToPagedList(model.pageNumber - 1, model.pageSize); } else if (model.step == 7) //未通過 { memberQuery = queryMemberAtStep7(memberQuery); model.memberPagedList = memberQuery.OrderBy(m => m.mrNumber).ToPagedList(model.pageNumber - 1, model.pageSize); } } // 重新排序各會員的歷史審查紀錄 foreach (Member m in model.memberPagedList) { m.MemberGroupResult = m.MemberGroupResult.OrderBy(r => r.AppraiseStep).ToList(); } } #endregion #region 歷屆會員 or 一般會員 else if (model.memberTypeNo == 2 || model.memberTypeNo == 3) { if (String.IsNullOrWhiteSpace(model.searchText) == false) { memberQuery = queryByText(memberQuery, model.searchText, model.operate, model.searchText2); } else { memberQuery = queryProAndSkill(memberQuery, model.searchText2); } model.memberPagedList = memberQuery.OrderBy(m => m.mrNumber).ToPagedList(model.pageNumber - 1, model.pageSize); } #endregion return(model); }
public ActionResult Search() { var model = new MemberSearchViewModel(); return(View(model)); }