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