private void btnIdentity3_Click(object sender, EventArgs e) { var cmd = new SearchTool("调查单元图斑", this); cmd.OnCreate(axMapControl1.Object); axMapControl1.CurrentTool = cmd as ITool; }
public SearchResult Get([FromUri] SearchRequest dtoSearchRequest) { if (dtoSearchRequest == null) { HttpResponseMessage httpResponseMessage = new HttpResponseMessage(HttpStatusCode.BadRequest); throw new HttpResponseException(httpResponseMessage); } var searchRequest = new SearchTool.SearchRequest(); if (dtoSearchRequest.Brands != null) { searchRequest.Brands = dtoSearchRequest.Brands.Split(',').Select(s => s.Trim()).ToArray(); } if (dtoSearchRequest.Keywords != null) { searchRequest.Keywords = dtoSearchRequest.Keywords.Split(',').Select(s => s.Trim()).ToArray(); } if (dtoSearchRequest.Category != null) { searchRequest.Category = _context.Categories.SingleOrDefault(c => c.LinkName == dtoSearchRequest.Category); } searchRequest.Sort = dtoSearchRequest.Sort != null ? dtoSearchRequest.Sort : "a-z"; searchRequest.Page = dtoSearchRequest.Page; searchRequest.FilterPriceMin = dtoSearchRequest.FilterPriceMin; searchRequest.FilterPriceMax = dtoSearchRequest.FilterPriceMax; searchRequest.ItemPerPage = ItemPerPage; var searchTool = new SearchTool(_context); var searchResult = searchTool.Execute(searchRequest); var dtoSearchResult = new Dto.SearchResult(); dtoSearchResult.Items = searchResult.Items; dtoSearchResult.Brands = searchResult.Brands.Select(b => new SearchBrand() { Brand = b, Selected = searchRequest.Brands != null ? searchRequest.Brands.Contains(b.LinkName) : false }); dtoSearchResult.Categories = searchResult.Categories; dtoSearchResult.Page = searchRequest.Page; dtoSearchResult.PageCount = searchResult.PageCount; dtoSearchResult.ItemsCount = searchResult.ItemsCount; dtoSearchResult.ItemsCountAfterFilter = searchResult.ItemsCountAfterFilter; dtoSearchResult.ItemsPerPage = ItemPerPage; dtoSearchResult.PriceMin = searchResult.PriceMin; dtoSearchResult.PriceMax = searchResult.PriceMax; return(dtoSearchResult); }
public ProteinSpectrumMatch(string sequence, int scanNum, double mass, int charge, string protName, string protDesc, int firstResidue, int lastResidue, double score, SearchTool searchTool = SearchTool.Unknown) { Sequence = sequence; ScanNum = scanNum; Mass = mass; Charge = charge; ProteinName = protName; FirstResidue = firstResidue; LastResidue = lastResidue; SearchToolType = searchTool; Score = score; ProteinDesc = protDesc; }
public void ReadfileTest() { int maxSize = 6; string inputFilePath = @"C:\Temp\dictionary.txt"; string outputFilePath = @"C:\Temp\output.txt"; List <string> wordList = new List <string>(); Mock <IFileHandler> handler = new Mock <IFileHandler>(); handler.Setup(x => x.ReadFile(inputFilePath, maxSize)).Returns(new List <string>() { "test", "12", "saskatoon" }); ISearchTool searchTool = new SearchTool(inputFilePath, outputFilePath, maxSize, handler.Object); wordList = searchTool.ReadFile(); Assert.IsTrue(wordList.Count == 3); }
public void BuildRepositoryTest() { int maxSize = 6; string inputFilePath = @"C:\Temp\dictionary.txt"; string outputFilePath = @"C:\Temp\output.txt"; List <string> wordList = new List <string>(); Mock <IFileHandler> handler = new Mock <IFileHandler>(); handler.Setup(x => x.ReadFile(inputFilePath, maxSize)).Returns(new List <string>() { "test12", "word", "12", "reg", "ina" }); ISearchTool searchTool = new SearchTool(inputFilePath, outputFilePath, maxSize, handler.Object); wordList = searchTool.ReadFile(); List <string> matchList = searchTool.BuildWordRepository(wordList); Assert.IsTrue(matchList.Count == 3); }
public ActionResult MyRentals(MyRentalsSearchModel model) { var user = User.Identity.Name; var login = AccountService.GetLoginByEmail(user); if (TenantService.IsLoginATenant(login)) { if (String.IsNullOrWhiteSpace(model.SortOrder)) { model.SortOrder = "Latest Date"; } var data = TenantService.GetMyRentals(login.Id).AsQueryable(); switch (model.SortOrder) { case "Latest First": data = data.OrderBy(s => s.CreatedOn); break; case "Earliest First": data = data.OrderByDescending(s => s.CreatedOn); break; case "Due Date Nearest": data = data.OrderBy(s => s.NextPaymenDate); break; case "Due Date Farthest": data = data.OrderByDescending(s => s.NextPaymenDate); break; default: data = data.OrderByDescending(s => s.CreatedOn); break; } var allItems = data.ToPagedList(model.Page, 10); if (!String.IsNullOrWhiteSpace(model.SearchString)) { SearchTool searchTool = new SearchTool(); int searchType = searchTool.CheckDisplayType(model.SearchString); string formatString = searchTool.ConvertString(model.SearchString); switch (searchType) { case 1: data = data.Where(x => (x.AddressString != null && x.AddressString.ToLower().EndsWith(formatString)) || (x.Model.Landlordname != null && x.Model.Landlordname.ToLower().EndsWith(formatString)) || (x.Model.LandlordPhone != null && x.Model.LandlordPhone.ToLower().EndsWith(formatString))); break; case 2: data = data.Where(x => (x.AddressString != null && x.AddressString.ToLower().StartsWith(formatString)) || (x.Model.Landlordname != null && x.Model.Landlordname.ToLower().StartsWith(formatString)) || (x.Model.LandlordPhone != null && x.Model.LandlordPhone.ToLower().StartsWith(formatString))); break; case 3: data = data.Where(x => (x.AddressString != null && x.AddressString.ToLower().Contains(formatString)) || (x.Model.Landlordname != null && x.Model.Landlordname.ToLower().Contains(formatString)) || (x.Model.LandlordPhone != null && x.Model.LandlordPhone.ToLower().Contains(formatString))); break; } } var items = data.ToPagedList(model.Page, 10); var count = items.Count; items.ForEach(x => x.Model.MediaFiles.ForEach(y => y.InjectMediaModelViewProperties())); var result = new SearchResult { SearchCount = items.Count, Items = count == 0 ? allItems : items, NoResultFound = (count == 0) }; model.PagedInput = new PagedInput { ActionName = "MyRentals", ControllerName = "Home", PagedLinkValues = new RouteValueDictionary(new { SortOrder = model.SortOrder, SearchString = model.SearchString }) }; var rvr = new RouteValueDictionary(new { SearchString = model.SearchString }); var sortOrders = new List <SortOrderModel>(); sortOrders.Add(new SortOrderModel { SortOrder = "Latest First", ActionName = "MyRentals", RouteValues = rvr.AddRouteValue("SortOrder", "Latest First") }); sortOrders.Add(new SortOrderModel { SortOrder = "Earliest First", ActionName = "MyRentals", RouteValues = rvr.AddRouteValue("SortOrder", "Earliest First") }); sortOrders.Add(new SortOrderModel { SortOrder = "Due Date Nearest", ActionName = "MyRentals", RouteValues = rvr.AddRouteValue("SortOrder", "Due Date Nearest") }); sortOrders.Add(new SortOrderModel { SortOrder = "Due Date Farthest", ActionName = "MyRentals", RouteValues = rvr.AddRouteValue("SortOrder", "Due Date Farthest") }); model.SortOrders = sortOrders; model.SearchCount = result.SearchCount; model.NoResultFound = result.NoResultFound; if (String.IsNullOrWhiteSpace(model.SearchString)) { model.Page = 1; } model.PageCount = result.Items.PageCount; model.Items = result.Items; ViewBag.RequestTypes = RentalService.GetRequestTypes().Where(x => x.Id != 3).ToList(); TempData["CurrentLink"] = "MyRentals"; return(View(model)); } return(View("Error")); }
public ActionResult Inspections(POInspectionsSearchModel model) { var user = User.Identity.Name; var login = AccountService.GetLoginByEmail(user); model.EditUrl = "/PropertyOwners/Manage/EvaluateInspection"; model.DeleteUrl = "/PropertyOwners/Manage/DeleteInspection"; if (String.IsNullOrWhiteSpace(model.SortOrder)) { model.SortOrder = "Latest Date"; } var props = db.OwnerProperty.Where(x => x.OwnerId == login.Id && x.Property.IsActive); var propsId = props.Select(x => x.Property.Id); var data = db.Inspection.Where(x => propsId.Contains(x.PropertyId) && x.IsActive == true).Select(x => new { Model = new InspectionModel { Id = x.Id, PropertyId = x.PropertyId, StatusId = x.StatusId, Message = x.Message, Reason = x.Reason, PercentDone = x.PercentDone, RequestId = x.RequestId, IsViewed = x.IsViewed ?? false, IsUpdated = x.IsUpdated, MediaFiles = x.InspectionMedia.Select(y => new MediaModel { Id = y.Id, NewFileName = y.NewFileName, OldFileName = y.OldFileName, }).ToList(), LandlordMedia = x.PropertyRequest.PropertyRequestMedia.Select(k => new MediaModel1 { Id = k.Id, NewFileName = k.NewFileName, OldFileName = k.OldFileName, Status = "load", }).ToList() }, Address = new AddressViewModel { AddressId = x.Property.Address.AddressId, Number = x.Property.Address.Number.Replace(" ", ""), Street = x.Property.Address.Street.Trim(), City = x.Property.Address.City.Trim(), Suburb = x.Property.Address.Suburb.Trim() ?? "", PostCode = x.Property.Address.PostCode.Replace(" ", "") }, PropertyAddress = x.Property.Address.Number.Replace(" ", "") + " " + x.Property.Address.Street.Trim() + " " + x.Property.Address.City.Trim() + " " + x.Property.Address.Suburb.Trim() + " " + x.Property.Address.PostCode.Replace(" ", ""), Status = x.InspectionStatus.Name, CreatedOn = x.CreatedOn, DueDate = x.PropertyRequest.DueDate, }); var allItems = data.OrderByDescending(x => x.CreatedOn).ToPagedList(model.Page, 10); switch (model.SortOrder) { case "Highest Progress": data = data.OrderByDescending(s => s.Model.PercentDone); break; case "Lowest Progress": data = data.OrderBy(s => s.Model.PercentDone); break; case "Earliest Date": data = data.OrderBy(s => s.CreatedOn); break; case "Latest Date": data = data.OrderByDescending(s => s.CreatedOn); break; default: data = data.OrderByDescending(s => s.CreatedOn); break; } if (!String.IsNullOrWhiteSpace(model.SearchString)) { SearchTool searchTool = new SearchTool(); int searchType = searchTool.CheckDisplayType(model.SearchString); string formatString = searchTool.ConvertString(model.SearchString); switch (searchType) { case 1: data = data.Where(x => x.Model.Message.ToLower().EndsWith(formatString) || x.PropertyAddress.ToLower().EndsWith(formatString)); break; case 2: data = data.Where(x => x.Model.Message.ToLower().StartsWith(formatString) || x.PropertyAddress.ToLower().StartsWith(formatString)); break; case 3: data = data.Where(x => x.Model.Message.ToLower().Contains(formatString) || x.PropertyAddress.ToLower().Contains(formatString)); break; } } var items = data.ToPagedList(model.Page, 10); var count = items.Count; items = count == 0 ? allItems : items; items.ToList().ForEach(x => x.Model.MediaFiles.ForEach(y => y.InjectMediaModelViewProperties())); items.ToList().ForEach(x => x.Model.LandlordMedia.ForEach(y => y.InjectMediaModelViewProperties1())); var result = new SearchResult { SearchCount = items.Count, Items = count == 0 ? allItems : items }; model.PagedInput = new PagedInput { ActionName = "Inspections", ControllerName = "Manage", PagedLinkValues = new RouteValueDictionary(new { SortOrder = model.SortOrder, SearchString = model.SearchString }) }; var rvr = new RouteValueDictionary(new { SearchString = model.SearchString }); var sortOrders = new List <SortOrderModel>(); sortOrders.Add(new SortOrderModel { SortOrder = "Highest Progress", ActionName = "Inspections", RouteValues = rvr.AddRouteValue("SortOrder", "Highest Progress") }); sortOrders.Add(new SortOrderModel { SortOrder = "Lowest Progress", ActionName = "Inspections", RouteValues = rvr.AddRouteValue("SortOrder", "Lowest Progress") }); sortOrders.Add(new SortOrderModel { SortOrder = "Latest Date", ActionName = "Inspections", RouteValues = rvr.AddRouteValue("SortOrder", "Latest Date") }); sortOrders.Add(new SortOrderModel { SortOrder = "Earliest Date", ActionName = "Inspections", RouteValues = rvr.AddRouteValue("SortOrder", "Earliest Date") }); model.SortOrders = sortOrders; model.SearchCount = result.SearchCount; if (String.IsNullOrWhiteSpace(model.SearchString)) { model.Page = 1; } model.PageCount = result.Items.PageCount; model.Items = result.Items; return(View(model)); }
public ActionResult Index(POPropSearchModel model) { var user = User.Identity.Name; var login = AccountService.GetLoginByEmail(user); if (String.IsNullOrWhiteSpace(model.SortOrder)) { model.SortOrder = "Latest Date"; } var prop = db.OwnerProperty.Where(x => x.PropertyId == 2678).First(); var data = db.OwnerProperty.Where(x => x.Person.Login.UserName == User.Identity.Name && x.Property.IsActive) .Select(x => new PropViewModel { Model = new PropertyModel { Id = x.PropertyId, PropertyTypeId = x.Property.PropertyTypeId, Name = x.Property.Name, Description = x.Property.Description, Bedroom = x.Property.Bedroom, Bathroom = x.Property.Bathroom, LandSqm = x.Property.LandSqm, ParkingSpace = x.Property.ParkingSpace, FloorArea = x.Property.FloorArea, TargetRent = x.Property.TargetRent, TargetRentTypeId = x.Property.TargetRentTypeId, YearBuilt = x.Property.YearBuilt, IsOwnerOccupied = x.Property.IsOwnerOccupied, Address = new AddressViewModel { AddressId = x.Property.Address.AddressId, CountryId = x.Property.Address.CountryId, Number = x.Property.Address.Number.Replace(" ", ""), Street = x.Property.Address.Street.Trim(), City = x.Property.Address.City.Trim(), Suburb = x.Property.Address.Suburb.Trim() ?? "", PostCode = x.Property.Address.PostCode.Replace(" ", ""), Latitude = x.Property.Address.Lat, Longitude = x.Property.Address.Lng, }, MediaFiles = x.Property.PropertyMedia.Select(y => new MediaModel { Id = y.Id, NewFileName = y.NewFileName, OldFileName = y.OldFileName }).ToList() }, PropertyTypeName = x.Property.PropertyType.Name, CreatedOn = x.Property.CreatedOn, PurchasePrice = x.Property.PropertyFinance.PurchasePrice, CurrentHomeValue = x.Property.PropertyFinance.CurrentHomeValue, TenantCount = x.Property.TenantProperty.Where(y => y.IsActive ?? true).Count(), }); var allItems = data.OrderByDescending(x => x.CreatedOn).ToPagedList(model.Page, 10); switch (model.SortOrder) { case "Name": data = data.OrderBy(s => s.Model.Name); break; case "Name(Desc)": data = data.OrderByDescending(s => s.Model.Name); break; case "Latest Date": data = data.OrderByDescending(s => s.CreatedOn); break; case "Earliest Date": data = data.OrderBy(s => s.CreatedOn); break; default: data = data.OrderByDescending(s => s.CreatedOn); break; } if (!String.IsNullOrWhiteSpace(model.SearchString)) { SearchTool searchTool = new SearchTool(); int searchType = searchTool.CheckDisplayType(model.SearchString); string formatString = searchTool.ConvertString(model.SearchString); switch (searchType) { case 1: data = data.Where(x => x.Model.Name.ToLower().EndsWith(formatString) || x.Model.Address.City.ToLower().EndsWith(formatString) || x.Model.Address.Suburb.ToLower().EndsWith(formatString)); break; case 2: data = data.Where(x => x.Model.Name.ToLower().StartsWith(formatString) || x.Model.Address.City.ToLower().StartsWith(formatString) || x.Model.Address.Suburb.ToLower().StartsWith(formatString)); break; case 3: data = data.Where(x => x.Model.Name.ToLower().Contains(formatString) || x.Model.Address.City.ToLower().Contains(formatString) || x.Model.Address.Suburb.ToLower().Contains(formatString)); break; } } var items = data.ToPagedList(model.Page, 10); var count = items.Count; items = count == 0 ? allItems : items; items.ToList().ForEach(x => x.Model.MediaFiles.ForEach(y => y.InjectMediaModelViewProperties())); var result = new SearchResult { SearchCount = items.Count, Items = count == 0 ? allItems : items }; model.PagedInput = new PagedInput { ActionName = "Index", ControllerName = "Home", PagedLinkValues = new RouteValueDictionary(new { SortOrder = model.SortOrder, SearchString = model.SearchString }) }; var rvr = new RouteValueDictionary(new { SearchString = model.SearchString }); var sortOrders = new List <SortOrderModel>(); sortOrders.Add(new SortOrderModel { SortOrder = "Name", ActionName = "Index", RouteValues = rvr.AddRouteValue("SortOrder", "Name") }); sortOrders.Add(new SortOrderModel { SortOrder = "Name(Desc)", ActionName = "Index", RouteValues = rvr.AddRouteValue("SortOrder", "Name(Desc)") }); sortOrders.Add(new SortOrderModel { SortOrder = "Latest Date", ActionName = "Index", RouteValues = rvr.AddRouteValue("SortOrder", "Latest Date") }); sortOrders.Add(new SortOrderModel { SortOrder = "Earliest Date", ActionName = "Index", RouteValues = rvr.AddRouteValue("SortOrder", "Earliest Date") }); model.SortOrders = sortOrders; model.SearchCount = result.SearchCount; if (String.IsNullOrWhiteSpace(model.SearchString)) { model.Page = 1; } model.PageCount = result.Items.PageCount; model.Items = result.Items; model.EditUrl = "/PropertyOwners/Home/Edit"; model.DeleteUrl = "/PropertyOwners/Home/Delete"; model.CanListRental = allItems.Any(); ViewBag.Frequencies = PropertyOwnerService.GetAllPaymentFrequencies(); ViewBag.PropertyTypes = PropertyService.GetAllProprtyTypes(); return(View(model)); }
// GET: Users/Home public ActionResult Index(string sortOrder, string currentFilter, string searchString, int?page) { // var userContext = db.Person; var loginContext = db.Login; var personContext = db.Person; var listofRoles = db.Role; var listofRoleList = db.LoginRole; ViewBag.SearchCount = 1; ViewBag.CurrentSort = sortOrder; ViewBag.CurrentFilter = searchString; ViewBag.FirstNameSortParm = sortOrder == "Fname_asc" ? "Fname" : "Fname_asc"; ViewBag.MiddleNameSortParm = sortOrder == "Mname_asc" ? "Mname" : "Mname_asc"; ViewBag.LastNameSortParm = sortOrder == "Lname_asc" ? "Lname" : "Lname_asc"; if (searchString != null) { page = 1; } else { searchString = currentFilter; } //ViewBag.CurrentFilter = searchString; //ViewBag.CurrentFilter2 = searchString; // login table join with person table var userContextFull = from login in loginContext join p in personContext on login.Id equals p.Id where p.IsActive == true select new { Id = p.Id, // Loginrole = login.LoginRole, UserName = login.UserName, LoginId = p.LoginId, FirstName = p.FirstName, MiddleName = p.MiddleName ?? "", LastName = p.LastName, Language = p.Language, PlaceOfBirth = p.PlaceOfBirth, Occupation = p.Occupation, LinkedinUrl = p.LinkedinUrl, IsActive = p.IsActive, CreatedOn = p.CreatedOn.ToString(), ProfilePhoto = p.ProfilePhoto, //ProfilePhoto = new MediaModel //{ // OldFileName = p.ProfilePhoto //}, Address1 = new AddressViewModel { AddressId = p.PhysicalAddressId, CountryId = p.Address1.CountryId, Number = p.Address1.Number, Street = p.Address1.Street, City = p.Address1.City, Suburb = p.Address1.Suburb, PostCode = p.Address1.PostCode, }, Address = new AddressViewModel { AddressId = p.BillingAddressId, CountryId = p.Address.CountryId, Number = p.Address.Number, Street = p.Address.Street, City = p.Address.City, Suburb = p.Address.Suburb, PostCode = p.Address.PostCode, } }; var userContext = userContextFull; switch (sortOrder) { case "Fname": userContext = userContext.OrderByDescending(s => s.FirstName); break; case "Fname_asc": userContext = userContext.OrderBy(s => s.FirstName); break; case "Mname": userContext = userContext.OrderByDescending(s => s.MiddleName); break; case "Mname_asc": userContext = userContext.OrderBy(s => s.MiddleName); break; case "Lname": userContext = userContext.OrderByDescending(s => s.LastName); break; case "Lname_asc": userContext = userContext.OrderBy(s => s.LastName); break; default: userContext = userContext.OrderBy(s => s.FirstName); sortOrder = "Fname_asc"; break; } if (!String.IsNullOrWhiteSpace(searchString)) { SearchTool searchTool = new SearchTool(); int searchType = searchTool.CheckDisplayType(searchString); string formatString = searchTool.ConvertString(searchString); switch (searchType) { case 1: userContext = userContext.Where(userlist => userlist.FirstName.EndsWith(formatString) || userlist.MiddleName.EndsWith(formatString) || userlist.LastName.EndsWith(formatString) || userlist.Language.EndsWith(formatString) || userlist.Address.City.EndsWith(formatString) || userlist.Address.Suburb.EndsWith(formatString) || userlist.Address1.City.EndsWith(formatString) || userlist.Address1.Suburb.EndsWith(formatString) ); break; case 2: userContext = userContext.Where(userlist => userlist.FirstName.StartsWith(formatString) || userlist.MiddleName.StartsWith(formatString) || userlist.LastName.StartsWith(formatString) || userlist.Language.StartsWith(formatString) || userlist.Address.City.StartsWith(formatString) || userlist.Address.Suburb.StartsWith(formatString) || userlist.Address1.City.StartsWith(formatString) || userlist.Address1.Suburb.StartsWith(formatString) ); break; case 3: userContext = userContext.Where(userlist => userlist.FirstName.Contains(formatString) || userlist.MiddleName.Contains(formatString) || userlist.LastName.Contains(formatString) || userlist.Language.Contains(formatString) || userlist.Address.City.Contains(formatString) || userlist.Address.Suburb.Contains(formatString) || userlist.Address1.City.Contains(formatString) || userlist.Address1.Suburb.Contains(formatString) ); break; } } if (userContext.Count() == 0) { ViewBag.SearchCount = 0; TempData["search"] = searchString ?? ""; ViewBag.CurrentFilter = ""; //ViewBag.CurrentFilter = searchString ?? ""; userContext = userContextFull.OrderBy(q => q.FirstName); } int pageNumber = (page ?? 1); var users = userContext .Where(q => q.IsActive == true) .Select(q => new UserViewModel { Id = q.Id, LoginId = q.LoginId, UserName = q.UserName, FirstName = q.FirstName, MiddleName = q.MiddleName ?? "", LastName = q.LastName, Language = q.Language, PlaceOfBirth = q.PlaceOfBirth, Occupation = q.Occupation, Linkedin = q.LinkedinUrl, IsActive = q.IsActive, CreatedOn = q.CreatedOn.ToString(), ProfilePhoto = q.ProfilePhoto, PhysicalAddress = new AddressViewModel { AddressId = q.Address1.AddressId, CountryId = q.Address1.CountryId, Number = q.Address1.Number, Street = q.Address1.Street, City = q.Address1.City, Suburb = q.Address1.Suburb, PostCode = q.Address1.PostCode, }, BillingAddress = new AddressViewModel { AddressId = q.Address.AddressId, CountryId = q.Address.CountryId, Number = q.Address.Number, Street = q.Address.Street, City = q.Address.City, Suburb = q.Address.Suburb, PostCode = q.Address.PostCode, } }).ToList(); //.ToPagedList(pageNumber, 10); users.ForEach(x => { x.ProfilePhoto = Url.Content("~/images/" + x.ProfilePhoto); }); foreach (var item in users) { //users.ForEach(x => //{ // x.MediaFiles.ForEach(y => { // y.Data = Url.Content("~/images/" + y.NewFileName); // y.MediaType = MediaService.GetMediaType(y.NewFileName); // }); // item.ProfilePhoto = new MediaModel { Data = Url.Content("~/images/" + item.ProfilePhoto) }; //}); var singleUserRoles = from role in listofRoles from loginrole in listofRoleList.Where(q => q.PersonId == item.LoginId && (role.Id == q.RoleId)).DefaultIfEmpty() select new { Id = role.Id, //id from the role tabe RoleName = role.Name, IsActive = (bool?)loginrole.IsActive ?? false, PendingApproval = (bool?)loginrole.PendingApproval ?? false, LoginId = item.LoginId }; foreach (var userRole in singleUserRoles) { item.UserRoleList.Add(new RoleViewModel() { Id = userRole.Id, Name = userRole.RoleName, loginId = userRole.LoginId, IsActive = userRole.IsActive, PendingApproval = userRole.PendingApproval }); } } if (Request.IsAjaxRequest()) { return(PartialView("_PagedUsers", users.ToPagedList(pageNumber, 10))); } TempData["CurrentLink"] = "Admin"; return(View(users.ToPagedList(pageNumber, 10))); }
public List <MatchPalletPlanModel> GetMathPalletPlanByIce(string mathPalletCode) { var list = new List <MatchPalletPlanModel>(); try { var standardDataModel = PDAServiceIceProxy.GetMatchPalletPlan(mathPalletCode, PageModel.Page, 0, PageModel.Limit, "", (string.IsNullOrEmpty(mathPalletCode) ? "" : SearchTool.JsonSerialzable("MatchPalletCode," + mathPalletCode))); if (!standardDataModel.success) { throw new Exception(standardDataModel.msg); } PageModel.TotalCount = standardDataModel.total; PageModel.PageCount = (int)Math.Ceiling((double)PageModel.TotalCount / PageModel.Limit); list = standardDataModel.data; } catch (Exception e) { throw new Exception("出现异常,异常信息:" + e.Message); } return(list); }
public ActionResult GetJobQuotes(QuotesSearchViewModel model) { if (model.SortOrder == null) { model.SortOrder = "Latest Listing"; } var data = db.JobQuote.Where(x => x.Status.ToLower() == "opening") .Select(x => new { Model = new JobQuoteModel { Id = x.Id, JobRequestId = x.JobRequestId, Amount = x.Amount, Status = x.Status, Note = x.Note, IsViewed = x.IsViewed, MediaFiles = x.JobQuoteMedia.Select(y => new MediaModel { Id = y.Id, OldFileName = y.FileName.Substring(36), NewFileName = y.FileName, }).ToList(), }, CreatedOn = x.CreatedOn, ProviderName = x.ServiceProvider != null ? x.ServiceProvider.Person != null ? x.ServiceProvider.Person.FirstName : "" : "", CompanyName = x.ServiceProvider != null ? x.ServiceProvider.Company != null ? x.ServiceProvider.Company.Name : "" : "", }); if (model.MarketJobId.HasValue) { data = data.Where(x => x.Model.JobRequestId == model.MarketJobId); var mJob = db.TenantJobRequest.FirstOrDefault(x => x.Id == model.MarketJobId); model.MarketJob = mJob.MapTo <MarketJobModel>(); } var allItems = data.OrderByDescending(x => x.CreatedOn).ToPagedList(model.Page, 10); switch (model.SortOrder) { case "Company (A-Z)": data = data.OrderBy(s => s.CompanyName); break; case "Company (Z-A)": data = data.OrderByDescending(s => s.CompanyName); break; case "Lowest Amount": data = data.OrderBy(s => s.Model.Amount); break; case "Highest Amount": data = data.OrderByDescending(s => s.Model.Amount); break; default: data = data.OrderByDescending(s => s.Model.Amount); break; } if (!String.IsNullOrWhiteSpace(model.SearchString)) { SearchTool searchTool = new SearchTool(); int searchType = searchTool.CheckDisplayType(model.SearchString); string formatString = searchTool.ConvertString(model.SearchString); switch (searchType) { case 1: data = data.Where(x => x.Model.Amount.ToString() == formatString || x.CompanyName.ToLower().StartsWith(formatString) || x.Model.Note.ToLower().StartsWith(formatString)); break; case 2: data = data.Where(x => x.Model.Amount.ToString() == formatString || x.CompanyName.ToLower().EndsWith(formatString) || x.Model.Note.ToLower().EndsWith(formatString)); break; case 3: double number; if (Double.TryParse(formatString, out number)) { data = data.Where(y => double.Parse(y.Model.Amount.ToString().Split(',')[0]) <= double.Parse(formatString.Split(',')[0])); } else { data = data.Where(y => y.Model.Note.ToLower().Contains(formatString)); } break; } } var items = data.ToPagedList(model.Page, 10); var count = items.Count; items = count == 0 ? allItems : items; items.ToList().ForEach(x => x.Model.MediaFiles.ForEach(y => y.InjectMediaModelViewProperties())); var result = new SearchResult { SearchCount = items.Count, Items = count == 0 ? allItems : items }; model.PagedInput = new PagedInput { ActionName = "GetJobQuotes", ControllerName = "Home", PagedLinkValues = new RouteValueDictionary(new { SortOrder = model.SortOrder, SearchString = model.SearchString, MarketJobId = model.MarketJobId }) }; var formInputs = new List <SearchInput>(); formInputs.Add(new SearchInput { Name = "MarketJobId", Value = model.MarketJobId.ToString() }); model.InputValues = formInputs; var rvr = new RouteValueDictionary(new { SearchString = model.SearchString, MarketJobId = model.MarketJobId }); var sortOrders = new List <SortOrderModel>(); sortOrders.Add(new SortOrderModel { SortOrder = "Company (A-Z)", ActionName = "GetJobQuotes", RouteValues = rvr.AddRouteValue("SortOrder", "Name") }); sortOrders.Add(new SortOrderModel { SortOrder = "Company (Z-A)", ActionName = "GetJobQuotes", RouteValues = rvr.AddRouteValue("SortOrder", "Company (Z-A)") }); sortOrders.Add(new SortOrderModel { SortOrder = "Lowest Amount", ActionName = "GetJobQuotes", RouteValues = rvr.AddRouteValue("SortOrder", "Lowest Amount") }); sortOrders.Add(new SortOrderModel { SortOrder = "Highest Amount", ActionName = "GetJobQuotes", RouteValues = rvr.AddRouteValue("SortOrder", "Higest Amount") }); model.SortOrders = sortOrders; model.SearchCount = result.SearchCount; if (String.IsNullOrWhiteSpace(model.SearchString)) { model.Page = 1; } model.PageCount = result.Items.PageCount; model.Items = result.Items; var currentJob = db.TenantJobRequest.Where(x => x.Id == model.MarketJobId).FirstOrDefault(); model.Address = currentJob.Property.Address?.ToAddressString() ?? ""; return(View(model)); }