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