public ActionResult GetCityDistricts(String cityid)
{
List<CityDistrict> districts;
using (var context = new CommonDbContext())
{
districts = context.Districts.Where(d => d.CityId == cityid).ToList();
}
return Json(districts.Select(d=> new { id = d.ID, name = d.Name }), JsonRequestBehavior.AllowGet);
}
public ActionResult Categories(string cityid, string districtid)
{
CityViewModel model = new CityViewModel();
using (var context = new CommonDbContext())
{
model.City = context.Cities.Where(c => c.ID.Equals(cityid, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
if (model.City != null)
model.District = model.City.Districts.Where(d => d.ID.Equals(districtid, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
model.Activities = context.ActivityCategorties.ToList();
}
return View(model);
}
public ActionResult GetCityAutocompleate(string term)
{
List<City> cities;
using (var context = new CommonDbContext())
{
cities = (from c in context.Cities
where c.Name.ToLower().StartsWith(term.ToLower())
select c).ToList();
}
var result = cities.Select(c => new { id = c.ID, name = c.Name }).ToArray();
return Json(result, JsonRequestBehavior.AllowGet);
}
public ActionResult Activities(string cityid, string districtid, string categoryid, string subcategoryid)
{
SubCategoryViewModel model = new SubCategoryViewModel();
using (var context = new CommonDbContext())
{
model.City = context.Cities.Where(c => c.ID.Equals(cityid, StringComparison.InvariantCultureIgnoreCase)).FirstOrDefault();
if (model.City != null)
model.District = model.City.Districts.FirstOrDefault(d => d.ID.Equals(districtid, StringComparison.InvariantCultureIgnoreCase));
model.Category = context.ActivityCategorties.FirstOrDefault(c => c.ID.Equals(categoryid, StringComparison.InvariantCultureIgnoreCase));
model.SubCategory = context.ActivitySubCategories.FirstOrDefault(i=> i.ID.Equals(subcategoryid, StringComparison.InvariantCultureIgnoreCase) && i.ActivityCategoryId.Equals(categoryid));
model.Items = (from item in context.CategoryItems
where item.CityId.Equals(cityid) &&
item.DistrictId.Equals(districtid) &&
item.ActivityCategoryId.Equals(categoryid) &&
item.ActivitySubCategoryId.Equals(subcategoryid)
select item).ToList();
}
return View(model);
}
public JsonResult GetSubCategories(string categoryId)
{
using (var context = new CommonDbContext())
{
var subCategories = context.ActivitySubCategories.Where(sc => sc.ActivityCategoryId == categoryId).ToList();
return Json(new SelectList(subCategories, "ID", "Name"), JsonRequestBehavior.AllowGet);
}
}
public JsonResult GetDistricts(string cityId)
{
using (var context = new CommonDbContext())
{
var districts = context.Districts.Where(d => d.CityId == cityId).ToList();
return Json(new SelectList(districts, "ID", "Name"), JsonRequestBehavior.AllowGet);
}
}
public ActionResult AddBusiness(BusinessEntityViewModel model)
{
if (ModelState.IsValid)
{
return View();
}
else
{
using (var context = new CommonDbContext())
{
var cities = context.Cities.ToList();
ViewData["Cities"] = new SelectList(cities, "ID", "Name");
var categories = context.ActivityCategorties.ToList();
ViewData["Categories"] = new SelectList(categories, "ID", "Name");
}
return View();
}
}
public ActionResult AddBusiness()
{
using (var context = new CommonDbContext())
{
var cities = context.Cities.ToList();
ViewData["Cities"] = new SelectList(cities, "ID", "Name");
var categories = context.ActivityCategorties.ToList();
ViewData["Categories"] = new SelectList(categories, "ID", "Name");
}
return View();
}
