public SelectLists DistinctItems() { List <string> managersList = new List <string>(); List <string> dateOfSalesList = new List <string>(); List <string> productsList = new List <string>(); var managers = Database.ManagerRepository.Distinct(x => x.LastName); foreach (var item in managers) { managersList.Add(item.LastName); } var dateOfSales = Database.SaleInfoRepository.Distinct(x => x.DateOfSale); foreach (var item in dateOfSales) { dateOfSalesList.Add(item.DateOfSale); } var products = Database.ProductRepository.Distinct(x => x.Name); foreach (var item in products) { productsList.Add(item.Name); } var distinctItems = new SelectLists(managersList, dateOfSalesList, productsList); return(distinctItems); }
public ActionResult Statistics(int?page) { int pageNumber = page ?? 1; int pageSize = 10; try { _filterView = new FilterViewModel(_service.GetSaleInfo(((pageNumber - 1) * pageSize), pageSize)); int count = _service.GetSaleInfo().Count(); List <int> pagingList = new List <int>(); for (int i = 1; i < count; i++) { pagingList.Add(i); } _filterView.ListPager = pagingList.ToPagedList(pageNumber, pageSize); SelectLists distinctItems = _service.DistinctItems(); _filterView.Managers = new SelectList(distinctItems.Managers); _filterView.DatesOfSale = new SelectList(distinctItems.DateOfSales); _filterView.Products = new SelectList(distinctItems.Products); } catch (Exception) { return(View("Error")); } return(View(_filterView)); }
// GET: Operate/Attributes public ActionResult Index() { //一级类目 GoodsClassBll bll = new GoodsClassBll(); ViewBag.GClass = new SelectList(bll.GetList(w => w.Parentid == 0), "ID", "CName"); //属性类型 SelectLists sl = new SelectLists(); ViewBag.AStatus = new SelectList(sl.GetAttrStatusN(), "Value", "Text"); return View(); }
public SelectListSe SelectList(Predicate <ElementSe> predicate) { try { return(SelectLists.Find(predicate)); } catch (Exception) { return(null); } }
public User(int userId) { using (Entity db = new Entity()) { byte languageId = IidCulture.CurrentLanguageId; t_user user = db.t_user.Find(userId); if (user == null) { throw new ArgumentException("Invalid userId: " + UserId); } v_user[] roles = db.v_user.Where(e => e.user_id == user.user_id).ToArray(); v_site site = null; if (user.site_id.HasValue) { site = db.v_site.Find(user.site_id.Value); } UserId = user.user_id; OrganizationId = user.organization_id; Email = user.email; UserStatusId = user.user_status_id; SiteId = user.site_id; SiteName = site?.get_name_translated(languageId); FirstName = user.first_name; LastName = user.last_name; FullName = user.first_name + " " + user.last_name + " (" + user.email + ")"; Phone = user.phone; Title = user.title; LastLogin = user.last_login_activity; CreatedByUserId = user.createdby_userid; CreatedDate = user.created_date; UpdatedDate = user.updated_date; UpdatedByUserId = user.updatedby_userid; UserRoleFieldIds = roles.Select(e => e.user_role_fieldid).ToArray(); UserRoleValues = roles.Select(e => e.user_role_fieldid_value).ToArray(); Active = user.active; var userAccess = db.v_user_access.Where(e => e.user_id == userId); AssignedActivities = userAccess.Where(e => e.access_level_type == "Activity").OrderBy(e => e.activity_name).ToArray(); AssignedCountries = userAccess.Where(e => e.access_level_type == "Country").OrderBy(e => e.country).ToArray(); AssignedRegions = userAccess.Where(e => e.access_level_type == "Regional").OrderBy(e => e.access_level_name).ToArray(); AssignedSites = userAccess.Where(e => e.access_level_type == "Site").OrderBy(e => e.site_name).ToArray(); // Get all active sites. If the user is assigned to an inactive site, include it, too! int inactiveSiteId = (site != null && site.active == false) ? site.site_id : 0; Expression <Func <v_site, bool> > predicate = e => e.active == true || e.site_id == inactiveSiteId; AllSites = SelectLists.GetSites(predicate, true); } }
// GET: Operate/Attributes public ActionResult Index() { //一级类目 GoodsClassBll bll = new GoodsClassBll(); ViewBag.GClass = new SelectList(bll.GetList(w => w.Parentid == 0), "ID", "CName"); //属性类型 SelectLists sl = new SelectLists(); ViewBag.AStatus = new SelectList(sl.GetAttrStatusN(), "Value", "Text"); return(View()); }
public ActionResult Operate(int id = 0) { ViewBag.gbId = id; //价格区间 ViewBag.isPrice = LoginUser.UserBasic.Enterprise.ISPrice; ViewBag.priceLower = LoginUser.UserBasic.Enterprise.PriceLower; ViewBag.priceUpper = LoginUser.UserBasic.Enterprise.PriceUpper; GoodsBasicBll bll = new GoodsBasicBll(); GoodsGroupBll ggBll = new GoodsGroupBll(); GoodsBasic list = new GoodsBasic(); ViewBag.gAttr = new List <Hashtable>(); ViewBag.pClass = 0; int gclassP; if (id != 0) { list = bll.GetModelByGBid(id, out gclassP, LoginUser.UserBasic.EnterpriseID); ViewBag.pClass = gclassP; if (list != null) { //商品属性 AttributesBll gavBll = new AttributesBll(); ViewBag.gAttr = gavBll.GetListByGBid(id); ////商品销售卖点 //SellPointBll spBll = new SellPointBll(); //list.SellPointList = spBll.GetListByGBid(id); //商品可视分组 list.GoodsGroupList = ggBll.GetListByGBid(id); } else { Response.Redirect("/Login/Index"); return(Content("此商品不存在")); } } //有货状态 SelectLists sList = new SelectLists(); ViewBag.ISNormal = new SelectList(sList.GetGBISNormal(), "value", "text", list.ISNormal); //价格模式 ViewBag.RType = new SelectList(sList.GetGBRType(), "value", "text", list.RType); //可视分组 ViewBag.gGroupList = ggBll.GetGGList(LoginUser.UserBasic.EnterpriseID); //所属品牌 BrandBll bBll = new BrandBll(); ViewBag.BrandID = new SelectList(bBll.GetEBList(LoginUser.UserBasic.EnterpriseID), "ID", "BName", list.BrandID); return(View(list)); }
public ActionResult Index(int id = 0) { //有货状态 SelectLists sList = new SelectLists(); ViewBag.isNormal = sList.GetGBISNormal(); //可视分组 GoodsGroupBll ggBll = new GoodsGroupBll(); ViewBag.gGroup = ggBll.GetGGList(LoginUser.UserBasic.EnterpriseID); //商品类目(一级) GoodsClassBll gcbll = new GoodsClassBll(); ViewBag.gClass = gcbll.GetGCList(0); ViewBag.gIsSales = id; return View(); }
public ActionResult Index(int id = 0) { //有货状态 SelectLists sList = new SelectLists(); ViewBag.isNormal = sList.GetGBISNormal(); //可视分组 GoodsGroupBll ggBll = new GoodsGroupBll(); ViewBag.gGroup = ggBll.GetGGList(LoginUser.UserBasic.EnterpriseID); //商品类目(一级) GoodsClassBll gcbll = new GoodsClassBll(); ViewBag.gClass = gcbll.GetGCList(0); ViewBag.gIsSales = id; return(View()); }
public ActionResult Operate(int id = 0) { ViewBag.gbId = id; //价格区间 ViewBag.isPrice = LoginUser.UserBasic.Enterprise.ISPrice; ViewBag.priceLower = LoginUser.UserBasic.Enterprise.PriceLower; ViewBag.priceUpper = LoginUser.UserBasic.Enterprise.PriceUpper; GoodsBasicBll bll = new GoodsBasicBll(); GoodsGroupBll ggBll = new GoodsGroupBll(); GoodsBasic list = new GoodsBasic(); ViewBag.gAttr = new List<Hashtable>(); ViewBag.pClass = 0; int gclassP; if (id != 0) { list = bll.GetModelByGBid(id, out gclassP, LoginUser.UserBasic.EnterpriseID); ViewBag.pClass = gclassP; if (list != null) { //商品属性 AttributesBll gavBll = new AttributesBll(); ViewBag.gAttr = gavBll.GetListByGBid(id); ////商品销售卖点 //SellPointBll spBll = new SellPointBll(); //list.SellPointList = spBll.GetListByGBid(id); //商品可视分组 list.GoodsGroupList = ggBll.GetListByGBid(id); } else { Response.Redirect("/Login/Index"); return Content("此商品不存在"); } } //有货状态 SelectLists sList = new SelectLists(); ViewBag.ISNormal = new SelectList(sList.GetGBISNormal(), "value", "text", list.ISNormal); //价格模式 ViewBag.RType = new SelectList(sList.GetGBRType(), "value", "text", list.RType); //可视分组 ViewBag.gGroupList = ggBll.GetGGList(LoginUser.UserBasic.EnterpriseID); //所属品牌 BrandBll bBll = new BrandBll(); ViewBag.BrandID = new SelectList(bBll.GetEBList(LoginUser.UserBasic.EnterpriseID), "ID", "BName", list.BrandID); return View(list); }
public ActionResult AreaEdit(Guid id, AreaEditViewModel m) { var area = geoSvc.GetAreaByID(id); var original = area.GetCloneWithGeo(); if (ModelState.IsValid) { area.TypeID = (byte)Enum.Parse(typeof(CfType), m.PlaceType); area.SearchSupportString = m.SearchSupportString ?? ""; area.GeoReduceThreshold = m.GeoReduceThreshold; area.Geo = SqlGeography.Parse(new SqlString(m.WKT)); area.Name = m.Name; area.NameUrlPart = m.NameUrlPart; area.NameShort = m.NameShort; area.NoIndoorConfirmed = m.NoIndoorConfirmed; area.Description = m.Description; SaveBing7MapViewFromModel(m.MapModel.ViewOptions, area.ID); geoSvc.UpdateArea(original, area); return(Redirect(area.SlugUrl)); } else { ViewBag.Area = area; var geoJsonUrl = Stgs.MapSvcRelativeUrl + "area/" + id.ToString(); var mapModel = new Bing7GeoJsonMapViewModel("climbing-map-" + id, 680, 400, geoJsonUrl); mapModel.ViewOptions = new Bing7MapViewOptionsViewModel(mappingSvc.GetBingViewByID(area.ID)); ViewBag.MapModel = mapModel; ViewBag.PlaceTypeDropDownList = SelectLists.GetAreaTypeSelectList(false); return(View(m)); } }
public User() { AllSites = SelectLists.GetSites(e => e.active == true, true); }
public AdlistPage(int countryId, int regionId, int catId, int subCatId) : base(countryId, regionId, catId, subCatId) { CountryId = countryId; RegionId = regionId; using (BaseApplicationManager Manager = new BaseApplicationManager()) { SelectLists.Add(new SelectListForm { Name = "AdType", List = new SelectList(Manager.GetAllAdTypes(), "Name", "Value", "All Ads") }); SelectLists.Add(new SelectListForm { Name = "Search Only", List = new SelectList(new List <string>() { "All Ads", "Urgent Ads" }, "All Ads") }); // Get All Categories Based on current catId Category = Categories.FirstOrDefault(x => x.Id == catId); // ======================= if (Category != null) { if (Category.Name.Equals("Jobs")) { var list = SelectLists.SingleOrDefault(x => x.Name.Equals("AdType")).List.ToList(); list.Remove(list.SingleOrDefault(x => x.Text == "TRADE")); // remove old list SelectLists.Remove(SelectLists.SingleOrDefault(x => x.Name.Equals("AdType"))); // recreate new list SelectLists.Add(new SelectListForm() { Name = "AdType", List = new SelectList(list, "Value", "Text", "All Ads") }); SelectLists.Add(new SelectListForm() { Name = "JobTypeList", List = new SelectList(new List <string>() { "Full-time", "Permanent Full-time", "Part-time", "Permanent Part-time", "Temporary", "Contract", "Internship", "Project", "Please Contact" }) }); SelectLists.Add(new SelectListForm() { Name = "SalaryInfoList", List = new SelectList(new List <string>() { "Hourly", "Daily", "Weekly", "Fortnightly", "Monthly", "Yearly" }) }); } } // ======================= if (SubCategory != null) { if (SubCategory.Name.Equals("Cars/Trucks")) { SelectLists.Add(new SelectListForm() { Name = "MakeList", List = new SelectList(Manager.GetAllMake(), "Value", "Value") }); SelectLists.Add(new SelectListForm() { Name = "BodyTypeList", List = new SelectList(Manager.BodyTypeGetAll(), "Value", "Value") }); SelectLists.Add(new SelectListForm() { Name = "TransmissionList", List = new SelectList(Manager.GetAllTransmission(), "Value", "Value") }); SelectLists.Add(new SelectListForm() { Name = "FuelTypeList", List = new SelectList(Manager.GetAllFuelType(), "Value", "Value") }); SelectLists.Add(new SelectListForm() { Name = "ConditionList", List = new SelectList(Manager.GetAllCondition(), "Value", "Value") }); SelectLists.Add(new SelectListForm() { Name = "DrivetrainList", List = new SelectList(Manager.GetAllDrivetrain(), "Value", "Value") }); } else if (SubCategory.Name.Equals("Motorcycles/ATVs")) { SelectLists.Add(new SelectListForm() { Name = "MakeList", List = new SelectList(Manager.GetAllMake(), "Value", "Value") }); SelectLists.Add(new SelectListForm() { Name = "FuelTypeList", List = new SelectList(Manager.GetAllFuelType(), "Value", "Value") }); SelectLists.Add(new SelectListForm() { Name = "ConditionList", List = new SelectList(Manager.GetAllCondition(), "Value", "Value") }); } else if (SubCategory.Name.Equals("Automotive Parts")) { SelectLists.Add(new SelectListForm() { Name = "MakeList", List = new SelectList(Manager.GetAllMake(), "Value", "Value") }); SelectLists.Add(new SelectListForm() { Name = "ConditionList", List = new SelectList(Manager.GetAllCondition(), "Value", "Value") }); } else if (SubCategory.Name.Contains("Apartments/Condos") || SubCategory.Name.Contains("House")) { SelectLists.Add(new SelectListForm() { Name = "BedroomList", List = new SelectList(new List <string>() { "Bachelor / Studio", "1 bedroom", "2 bedrooms", "3 bedrooms", "4 bedrooms", "5 or more bedrooms" }) }); SelectLists.Add(new SelectListForm() { Name = "BathroomList", List = new SelectList(new List <string>() { "1 bathroom", "2 bathrooms", "3 bathrooms", "4 bathrooms", "5 or more bathrooms" }) }); SelectLists.Add(new SelectListForm() { Name = "FurnishedList", List = new SelectList(new List <string>() { "Fully-Furnished", "Semi-Furnished", "Unfurnished" }) }); } else if (SubCategory.Name.Equals("Commercial Office Space")) { SelectLists.Add(new SelectListForm() { Name = "FurnishedList", List = new SelectList(new List <string>() { "Fully-Furnished", "Semi-Furnished", "Unfurnished" }) }); } if (SubCategory.Name.Equals("Apartments/Condos Rental") || SubCategory.Name.Equals("House Rental") || SubCategory.Name.Equals("Land Rental/Leasing")) { SelectLists.Add(new SelectListForm() { Name = "RentalType", List = new SelectList(new List <string>() { "Rental Only", "Rent To Own" }) }); } if (SubCategory.Name.Equals("Lost Pet") || SubCategory.Name.Equals("Pet Accessories") || SubCategory.Name.Equals("Pet Adoption") || SubCategory.Name.Equals("Pet Hub")) { SelectLists.Add(new SelectListForm() { Name = "SpeciesList", List = new SelectList(new List <string>() { "Bird", "Cat", "Dog", "Fish", "Other" }) }); if (SubCategory.Name.Equals("Pet Adoption") || SubCategory.Name.Equals("Pet Hub")) { SelectLists.Add(new SelectListForm() { Name = "AgeTypeList", List = new SelectList(new List <string>() { "Days", "Weeks", "Months", "Years" }) }); } if (SubCategory.Name.Equals("Lost Pet")) { var list = SelectLists.SingleOrDefault(x => x.Name.Equals("AdType")).List.ToList(); list.Remove(list.SingleOrDefault(x => x.Text == "TRADE")); list.SingleOrDefault(x => x.Text == "SELL").Value = "Found"; list.SingleOrDefault(x => x.Text == "WANT").Value = "Missing"; // remove old list SelectLists.Remove(SelectLists.SingleOrDefault(x => x.Name.Equals("AdType"))); // recreate new list SelectLists.Add(new SelectListForm() { Name = "AdType", List = new SelectList(list, "Value", "Text", "All Ads") }); } } else if (SubCategory.Name.Equals("Pet Services")) { SelectLists.Add(new SelectListForm() { Name = "SpeciesList", List = new SelectList(new List <string>() { "All", "Bird", "Cat", "Dog", "Fish", "Other" }) }); } } CountryAdList = new List <CountryAdList>(); CountryAdList = Manager.GetCountryAdLists(CountryId); } }
/// <summary> ///批量修改商品 /// </summary> /// <param name="gaid"></param> /// <param name="ptype"></param> /// <param name="price"></param> /// <param name="pMin"></param> /// <param name="pMax"></param> /// <returns></returns> public ActionResult EditBatchGoodsAgent(string ids = "", int isSale = 0) { ViewBag.gaids = ids; ViewBag.isSales = new SelectList(SelectLists.GetGBIsSales(), "Value", "Text", isSale); return(View()); }
public SelectList ContactClassifications(bool includeDeleted) { return(SelectLists.ContactClassifications(includeDeleted)); }