// GET: HouseProperty/Details/5 public ActionResult Details(int?id) { UserModels userModels = new UserModels(); if (Session["userid"] != null) { userModels = db.User.Find(Session["userid"]); ViewBag.userModels = userModels; } else { return(RedirectToAction("Login", "User")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else if (!userFun.isUsersHP(userModels, id)) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HousePropertyModels housePropertyModels = db.HousePropertyModels.Find(id); if (housePropertyModels == null) { return(HttpNotFound()); } CitiesModels citiesModels = db.Cities.Where(m => m.cityid == housePropertyModels.area.cityid).FirstOrDefault(); ProvincesModels provincesModels = db.Provinces.Where(m => m.provinceid == citiesModels.provinceid).FirstOrDefault(); housePropertyModels.adress = provincesModels.province + citiesModels.city + housePropertyModels.area.area + housePropertyModels.adress; return(View(housePropertyModels)); }
public ActionResult Edit([Bind(Include = "id,adress,prize,detial")] HousePropertyModels housePropertyModels) { UserModels userModels = new UserModels(); if (Session["userid"] != null) { userModels = db.User.Find(Session["userid"]); ViewBag.userModels = userModels; } else { return(RedirectToAction("Login", "User")); } housePropertyModels.propertyUrl1 = Request["propertyUrl1"]; housePropertyModels.propertyUrl2 = Request["propertyUrl2"]; housePropertyModels.propertyUrl3 = Request["propertyUrl3"]; int oareaid = int.Parse(Request["oareaid"]); if (ModelState.IsValid) { if (Request["areaid"] != null) { int areaid = int.Parse(Request["areaid"]); db.Entry(housePropertyModels).State = EntityState.Modified; db.SaveChanges(); db.Database.ExecuteSqlCommand("update HousePropertyModels set area_id=" + areaid + " where id=" + housePropertyModels.id); return(RedirectToAction("userPropertyList")); } else { ModelState.AddModelError("areaid", "地址未选全!"); } } int aid = 0; if (Request["areaid"] == null) { aid = int.Parse(Request["oareaid"]); } else { aid = int.Parse(Request["areaid"]); } List <ProvincesModels> provincesModelsList = db.Provinces.ToList(); ViewBag.provincesModelsList = provincesModelsList; AreasModels areasModels = db.Areas.Find(aid); CitiesModels citiesModels = db.Cities.Where(m => m.cityid == areasModels.cityid).FirstOrDefault(); ProvincesModels provincesModels = db.Provinces.Where(m => m.provinceid == citiesModels.provinceid).FirstOrDefault(); List <CitiesModels> citiesModelsList = db.Cities.Where(m => m.provinceid == provincesModels.provinceid).ToList(); List <AreasModels> areasModelsList = db.Areas.Where(m => m.cityid == citiesModels.cityid).ToList(); ViewBag.citiesModelsList = citiesModelsList; ViewBag.areasModelsList = areasModelsList; ViewBag.citiesModels = citiesModels; ViewBag.provincesModels = provincesModels; housePropertyModels.area = areasModels; housePropertyModels.owner = userModels; return(View(housePropertyModels)); }
public ActionResult showUserInfo() { List <MenuItem> menuList = menu.getUserMenu(); foreach (MenuItem item in menuList) { if (item.url.Equals("/User/showUserInfo")) { item.active = true; } } ViewBag.menuList = menuList; if (Session["userid"] != null) { UserModels userModels = db.User.Find(Session["userid"]); CitiesModels cm = db.Cities.Where(m => m.cityid.Equals(userModels.area.cityid)).FirstOrDefault(); ProvincesModels pm = db.Provinces.Where(m => m.provinceid.Equals(cm.provinceid)).FirstOrDefault(); userModels.adress = pm.province + cm.city + userModels.area.area + userModels.adress; ViewBag.userModels = userModels; } else { return(RedirectToAction("Login")); } return(View()); }
public ActionResult PropertyDetails(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <MenuItem> menuList = menu.getAdminMenu(); foreach (MenuItem item in menuList) { if (item.url.Equals("/Admin/PropertyManage")) { item.active = true; } } ViewBag.menuList = menuList; if (Session["adminid"] != null) { AdminModels adminModels = db.Admin.Find(Session["adminid"]); ViewBag.adminModels = adminModels; } else { return(RedirectToAction("Login")); } HousePropertyModels housePropertyModels = db.HousePropertyModels.Find(id); CitiesModels citiesModels = db.Cities.Where(m => m.cityid == housePropertyModels.area.cityid).FirstOrDefault(); ProvincesModels provincesModels = db.Provinces.Where(m => m.provinceid == citiesModels.provinceid).FirstOrDefault(); housePropertyModels.adress = provincesModels.province + citiesModels.city + housePropertyModels.area.area + housePropertyModels.adress; return(View(housePropertyModels)); }
public ActionResult PropertyManage() { List <MenuItem> menuList = menu.getAdminMenu(); foreach (MenuItem item in menuList) { if (item.url.Equals("/Admin/PropertyManage")) { item.active = true; } } ViewBag.menuList = menuList; if (Session["adminid"] != null) { AdminModels adminModels = db.Admin.Find(Session["adminid"]); ViewBag.adminModels = adminModels; } else { return(RedirectToAction("Login")); } List <HousePropertyModels> housePropertyList = db.HousePropertyModels.ToList(); foreach (HousePropertyModels hm in housePropertyList) { CitiesModels cm = db.Cities.Where(m => m.cityid.Equals(hm.area.cityid)).FirstOrDefault(); ProvincesModels pm = db.Provinces.Where(m => m.provinceid.Equals(cm.provinceid)).FirstOrDefault(); hm.adress = pm.province + cm.city + hm.area.area + hm.adress; } ViewBag.housePropertyList = housePropertyList; return(View()); }
public ActionResult UserEdit(UserModels userInfo) { List <MenuItem> menuList = menu.getAdminMenu(); foreach (MenuItem item in menuList) { if (item.url.Equals("/Admin/UserManage")) { item.active = true; } } ViewBag.menuList = menuList; if (Session["adminid"] != null) { AdminModels adminModels = db.Admin.Find(Session["adminid"]); ViewBag.adminModels = adminModels; } else { return(RedirectToAction("Login")); } if (ModelState.IsValid) { if (Request["areaid"] != null) { int areaid = int.Parse(Request["areaid"]); db.Entry(userInfo).State = EntityState.Modified; db.Database.ExecuteSqlCommand("update UserModels set area_id=" + areaid + " where id=" + userInfo.id); db.SaveChanges(); return(RedirectToAction("UserManage")); } } int aid = 0; if (Request["areaid"] == null) { aid = int.Parse(Request["oareaid"]); } else { aid = int.Parse(Request["areaid"]); } List <ProvincesModels> provincesModelsList = db.Provinces.ToList(); ViewBag.provincesModelsList = provincesModelsList; AreasModels areasModels = db.Areas.Find(aid); CitiesModels citiesModels = db.Cities.Where(m => m.cityid == areasModels.cityid).FirstOrDefault(); ProvincesModels provincesModels = db.Provinces.Where(m => m.provinceid == citiesModels.provinceid).FirstOrDefault(); List <CitiesModels> citiesModelsList = db.Cities.Where(m => m.provinceid == provincesModels.provinceid).ToList(); List <AreasModels> areasModelsList = db.Areas.Where(m => m.cityid == citiesModels.cityid).ToList(); ViewBag.citiesModelsList = citiesModelsList; ViewBag.areasModelsList = areasModelsList; ViewBag.citiesModels = citiesModels; ViewBag.provincesModels = provincesModels; userInfo.area = areasModels; return(View(userInfo)); }
public ActionResult editUserInfo(UserModels userModels) { List <MenuItem> menuList = menu.getUserMenu(); foreach (MenuItem item in menuList) { if (item.url.Equals("/User/showUserInfo")) { item.active = true; } } ViewBag.menuList = menuList; ViewBag.userModels = userModels; if (ModelState.IsValid) { if (Request["areaid"] != null) { int areaid = int.Parse(Request["areaid"]); db.Entry(userModels).State = EntityState.Modified; db.Database.ExecuteSqlCommand("update UserModels set area_id=" + areaid + " where id=" + userModels.id); db.SaveChanges(); return(RedirectToAction("showUserInfo")); } else { ModelState.AddModelError("areaid", "地址未选全!"); } } int aid = 0; if (Request["areaid"] == null) { aid = int.Parse(Request["oareaid"]); } else { aid = int.Parse(Request["areaid"]); } List <ProvincesModels> provincesModelsList = db.Provinces.ToList(); ViewBag.provincesModelsList = provincesModelsList; AreasModels areasModels = db.Areas.Find(aid); CitiesModels citiesModels = db.Cities.Where(m => m.cityid == areasModels.cityid).FirstOrDefault(); ProvincesModels provincesModels = db.Provinces.Where(m => m.provinceid == citiesModels.provinceid).FirstOrDefault(); List <CitiesModels> citiesModelsList = db.Cities.Where(m => m.provinceid == provincesModels.provinceid).ToList(); List <AreasModels> areasModelsList = db.Areas.Where(m => m.cityid == citiesModels.cityid).ToList(); ViewBag.citiesModelsList = citiesModelsList; ViewBag.areasModelsList = areasModelsList; ViewBag.citiesModels = citiesModels; ViewBag.provincesModels = provincesModels; userModels.area = areasModels; return(View(userModels)); }
// GET: HouseProperty/Edit/5 public ActionResult Edit(int?id) { UserModels userModels = new UserModels(); if (Session["userid"] != null) { userModels = db.User.Find(Session["userid"]); ViewBag.userModels = userModels; } else { return(RedirectToAction("Login", "User")); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else if (!userFun.isUsersHP(userModels, id)) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HousePropertyModels housePropertyModels = db.HousePropertyModels.Find(id); if (housePropertyModels == null) { return(HttpNotFound()); } List <ProvincesModels> provincesModelsList = db.Provinces.ToList(); ViewBag.provincesModelsList = provincesModelsList; AreasModels areasModels = db.Areas.Find(housePropertyModels.area.id); CitiesModels citiesModels = db.Cities.Where(m => m.cityid == areasModels.cityid).FirstOrDefault(); ProvincesModels provincesModels = db.Provinces.Where(m => m.provinceid == citiesModels.provinceid).FirstOrDefault(); List <CitiesModels> citiesModelsList = db.Cities.Where(m => m.provinceid == provincesModels.provinceid).ToList(); List <AreasModels> areasModelsList = db.Areas.Where(m => m.cityid == citiesModels.cityid).ToList(); ViewBag.citiesModelsList = citiesModelsList; ViewBag.areasModelsList = areasModelsList; ViewBag.citiesModels = citiesModels; ViewBag.provincesModels = provincesModels; return(View(housePropertyModels)); }
public ActionResult Index() { string id = Request["id"]; int num = Request["num"] == null?0:int.Parse(Request["num"]); List <HousePropertyModels> housePropertyList = null; if (Session["adminid"] != null) { AdminModels adminModels = db.Admin.Find(Session["adminid"]); ViewBag.adminModels = adminModels; } else if (Session["userid"] != null) { UserModels userModels = db.User.Find(Session["userid"]); ViewBag.userModels = userModels; } if (num == 0) { housePropertyList = db.HousePropertyModels.Where(m => m.status == 2).ToList(); } else if (num == 1) { var array = db.Cities.Where(m => m.provinceid.Equals(id)).Select(value => value.cityid).ToArray(); housePropertyList = db.HousePropertyModels.Where(m => m.status == 2).Where(m => array.Contains(m.area.cityid)).ToList(); } else if (num == 2) { housePropertyList = db.HousePropertyModels.Where(m => m.status == 2).Where(m => m.area.cityid.Equals(id)).ToList(); } else if (num == 3) { housePropertyList = db.HousePropertyModels.Where(m => m.status == 2).Where(m => m.area.areaid.Equals(id)).ToList(); } foreach (HousePropertyModels hm in housePropertyList) { CitiesModels cm = db.Cities.Where(m => m.cityid.Equals(hm.area.cityid)).FirstOrDefault(); ProvincesModels pm = db.Provinces.Where(m => m.provinceid.Equals(cm.provinceid)).FirstOrDefault(); hm.adress = pm.province + cm.city + hm.area.area + hm.adress; } ViewBag.housePropertyList = housePropertyList; return(View()); }
public ActionResult UserEdit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } List <MenuItem> menuList = menu.getAdminMenu(); foreach (MenuItem item in menuList) { if (item.url.Equals("/Admin/UserManage")) { item.active = true; } } ViewBag.menuList = menuList; if (Session["adminid"] != null) { AdminModels adminModels = db.Admin.Find(Session["adminid"]); ViewBag.adminModels = adminModels; } else { return(RedirectToAction("Login")); } UserModels userInfo = db.User.Find(id); List <ProvincesModels> provincesModelsList = db.Provinces.ToList(); ViewBag.provincesModelsList = provincesModelsList; AreasModels areasModels = db.Areas.Find(userInfo.area.id); CitiesModels citiesModels = db.Cities.Where(m => m.cityid == areasModels.cityid).FirstOrDefault(); ProvincesModels provincesModels = db.Provinces.Where(m => m.provinceid == citiesModels.provinceid).FirstOrDefault(); List <CitiesModels> citiesModelsList = db.Cities.Where(m => m.provinceid == provincesModels.provinceid).ToList(); List <AreasModels> areasModelsList = db.Areas.Where(m => m.cityid == citiesModels.cityid).ToList(); ViewBag.citiesModelsList = citiesModelsList; ViewBag.areasModelsList = areasModelsList; ViewBag.citiesModels = citiesModels; ViewBag.provincesModels = provincesModels; return(View(userInfo)); }
public ActionResult userPropertyList() { UserModels userModels = new UserModels(); if (Session["userid"] != null) { userModels = db.User.Find(Session["userid"]); ViewBag.userModels = userModels; } else { return(RedirectToAction("Login", "User")); } foreach (HousePropertyModels hm in userModels.houseProperty) { CitiesModels cm = db.Cities.Where(m => m.cityid.Equals(hm.area.cityid)).FirstOrDefault(); ProvincesModels pm = db.Provinces.Where(m => m.provinceid.Equals(cm.provinceid)).FirstOrDefault(); hm.adress = pm.province + cm.city + hm.area.area + hm.adress; } return(View(userModels.houseProperty)); }
public ActionResult editUserInfo() { List <MenuItem> menuList = menu.getUserMenu(); foreach (MenuItem item in menuList) { if (item.url.Equals("/User/showUserInfo")) { item.active = true; } } ViewBag.menuList = menuList; UserModels userModels = new UserModels(); if (Session["userid"] != null) { userModels = db.User.Find(Session["userid"]); ViewBag.userModels = userModels; } else { return(RedirectToAction("Login")); } List <ProvincesModels> provincesModelsList = db.Provinces.ToList(); ViewBag.provincesModelsList = provincesModelsList; AreasModels areasModels = db.Areas.Find(userModels.area.id); CitiesModels citiesModels = db.Cities.Where(m => m.cityid == areasModels.cityid).FirstOrDefault(); ProvincesModels provincesModels = db.Provinces.Where(m => m.provinceid == citiesModels.provinceid).FirstOrDefault(); List <CitiesModels> citiesModelsList = db.Cities.Where(m => m.provinceid == provincesModels.provinceid).ToList(); List <AreasModels> areasModelsList = db.Areas.Where(m => m.cityid == citiesModels.cityid).ToList(); ViewBag.citiesModelsList = citiesModelsList; ViewBag.areasModelsList = areasModelsList; ViewBag.citiesModels = citiesModels; ViewBag.provincesModels = provincesModels; return(View(userModels)); }
public ActionResult PropertyDetial(int?id) { if (Session["adminid"] != null) { AdminModels adminModels = db.Admin.Find(Session["adminid"]); ViewBag.adminModels = adminModels; } else if (Session["userid"] != null) { UserModels userModels = db.User.Find(Session["userid"]); ViewBag.userModels = userModels; /*if(userFun.isUsersHP(userModels,id)) * { * return new HttpStatusCodeResult(HttpStatusCode.BadRequest); * }*/ } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } HousePropertyModels hm = db.HousePropertyModels.Find(id); if (hm == null) { return(HttpNotFound()); } if (hm.status != 2) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } CitiesModels cm = db.Cities.Where(m => m.cityid.Equals(hm.area.cityid)).FirstOrDefault(); ProvincesModels pm = db.Provinces.Where(m => m.provinceid.Equals(cm.provinceid)).FirstOrDefault(); hm.adress = pm.province + cm.city + hm.area.area + hm.adress; return(View(hm)); }
public ActionResult Index() { List <HousePropertyModels> housePropertyList = null; if (Session["adminid"] != null) { AdminModels adminModels = db.Admin.Find(Session["adminid"]); ViewBag.adminModels = adminModels; } else if (Session["userid"] != null) { UserModels userModels = db.User.Find(Session["userid"]); ViewBag.userModels = userModels; } housePropertyList = db.HousePropertyModels.Where(m => m.status == 2).ToList(); foreach (HousePropertyModels hm in housePropertyList) { CitiesModels cm = db.Cities.Where(m => m.cityid.Equals(hm.area.cityid)).FirstOrDefault(); ProvincesModels pm = db.Provinces.Where(m => m.provinceid.Equals(cm.provinceid)).FirstOrDefault(); hm.adress = pm.province + cm.city + hm.area.area + hm.adress; } ViewBag.housePropertyList = housePropertyList; return(View()); }