public ViewResult ViewDetailAndImage(int HouseID = 0)
{
tbl_House house = db.tbl_House.SingleOrDefault(n => n.houseID == HouseID);
if (house == null)
{
Response.StatusCode = 404;
return(null);
}
House h = new House();
h.house = house;
h.listImage = db.tbl_Image.Where(n => n.houseID == house.houseID).ToList();
h.areaName = db.tbl_Area.SingleOrDefault(n => n.areaID == house.areaID).areaName;
int districtID = int.Parse(db.tbl_Area.SingleOrDefault(n => n.areaID == house.areaID).districtID.ToString());
h.districtName = db.tbl_District.SingleOrDefault(n => n.districtID == districtID).districtName;
string email = house.emailAdmin;
tbl_Admin admin = db.tbl_Admin.SingleOrDefault(n => n.emailAdmin == email);
ViewBag.InfoAdmin = admin.fullname + ", " + admin.phoneNumber;
return(View(h));
}
public ActionResult GetInfoUser(FormCollection fc)
{
string fullName = fc["txtName"].ToString();
string phoneNumber = fc["txtNumerPhone"].ToString();
string email = fc["txtEmail"].ToString();
string message = fc["txtText"].ToString();
int houseID = int.Parse(fc["txtHouseID"].ToString());
tbl_House emailAdmin = db.tbl_House.SingleOrDefault(n => n.houseID == houseID);
tbl_Customer customer = new tbl_Customer
{
fullname = fullName,
phoneNumber = phoneNumber,
emailCustomer = email,
message = message,
emailAdmin = emailAdmin.emailAdmin,
readStatus = false,
date = DateTime.Now,
houseID = houseID
};
db.tbl_Customer.Add(customer);
db.SaveChanges();
ViewDetailAndImage(houseID);
return(RedirectToAction("ViewDetailAndImage", "House", new { HouseID = houseID }));
}
public ActionResult DeleteConfirmed(int id)
{
tbl_House tbl_House = db.tbl_House.Find(id);
db.tbl_House.Remove(tbl_House);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult LoadHouseToUpdate(FormCollection fc)
{
int houseID = int.Parse(fc["txtHouseID"].ToString());
House house = new House();
tbl_House h = db.tbl_House.SingleOrDefault(n => n.houseID == houseID);
house.house = h;
house.listImage = db.tbl_Image.Where(n => n.houseID == houseID).ToList();
Session["House"] = house;
return(View("UpdateHouse"));
}
// GET: Admin/House/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_House tbl_House = db.tbl_House.Find(id);
if (tbl_House == null)
{
return(HttpNotFound());
}
return(View(tbl_House));
}
// GET: Admin/House/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tbl_House HouseDetails = db.tbl_House.Find(id);
if (HouseDetails == null)
{
return(HttpNotFound());
}
return(View(HouseDetails));
}
public ActionResult Edit(tbl_House House, HttpPostedFileBase HotelImg)
{
try
{
if (HotelImg != null)
{
var filePath = Server.MapPath("~/Content/HotelImg/" + House.H_Image);
if (System.IO.File.Exists(filePath))
{
string ext = Path.GetExtension(HotelImg.FileName);
if (ext == ".jpg" || ext == "png" || ext == ".jpeg")
{
System.IO.File.Delete(filePath);
HotelImg.SaveAs(Path.Combine(Server.MapPath("~/Content/HotelImg/"), Path.GetFileName(House.H_ID + " " + HotelImg.FileName + " " + ext)));
House.H_Image = House.H_ID + " " + HotelImg.FileName + " " + ext;
db.Entry(House).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
ViewBag.Error = "Upload JPG / PNG format!";
return(View());
}
}
else
{
string ext = Path.GetExtension(HotelImg.FileName);
HotelImg.SaveAs(Path.Combine(Server.MapPath("~/Content/HotelImg/"), Path.GetFileName(House.H_ID + " " + HotelImg.FileName + " " + ext)));
House.H_Image = House.H_ID + " " + HotelImg.FileName + " " + ext;
db.Entry(House).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
else
{
House.H_Image = House.H_Image;
db.Entry(House).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ViewBag.Error = ex.Message;
return(View());
}
}
public bool changeStatusHouse(int id)
{
tbl_House house = db.tbl_House.SingleOrDefault(n => n.houseID == id);
if (house.rentStatus == true)
{
house.rentStatus = false;
db.Entry(house).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(true);
}
else
{
house.rentStatus = true;
db.Entry(house).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(false);
}
}
public ActionResult Create(tbl_House NewHouse, HttpPostedFileBase HotelImg)
{
try
{
var UserDetails = (tbl_User)Session["App"];
if (ModelState.IsValid)
{
if (HotelImg != null)
{
string ext = Path.GetExtension(HotelImg.FileName);
if (ext == ".jpg" || ext == "png" || ext == ".jpeg")
{
var fileName = Path.GetFileName(HotelImg.FileName + " " + NewHouse.H_ID + " " + ext);
string imgPath = Path.Combine(Server.MapPath("~/Content/HotelImg/"), fileName);
HotelImg.SaveAs(imgPath);
NewHouse.H_Image = fileName;
NewHouse.H_Status = true;
NewHouse.FK_UserID = UserDetails.User_Id;
db.tbl_House.Add(NewHouse);
db.SaveChanges();
ModelState.Clear();
return(RedirectToAction("Index"));
}
else
{
ViewBag.Error = "Upload JPG / PNG format!";
}
}
return(View());
}
else
{
ViewBag.Error = "Your input data is invalid!";
return(View(NewHouse));
}
}
catch (Exception ex)
{
ViewBag.Error = ex.Message;
return(View());
}
}
public ActionResult AddNewHouse(FormCollection fc)
{
string sEmail = fc["txtEmailAdmin"].ToString().Trim();
string sPrice = fc["txtPrice"].ToString().Trim();
float Price = float.Parse(sPrice);
string sRoomNumber = fc["txtRoomNumber"].ToString().Trim();
int RoomNumber = int.Parse(sRoomNumber);
string sAcreage = fc["txtAcreage"].ToString().Trim();
float Acreage = float.Parse(sAcreage);
string sFloor = fc["txtFloor"].ToString().Trim();
int Floor = int.Parse(sFloor);
string sHouseNumber = fc["txtHouseNumber"].ToString().Trim();
string sHouseStreet = fc["txtHouseStreet"].ToString().Trim();
var sFurniture = fc["cbFurniture"];
var sRentStatus = fc["cbRentStatus"];
string sOrderDetails = fc["txtOrderDetails"].ToString().Trim();
string sAreaID = fc["areaID"].ToString().Trim();
int AreaID = int.Parse(sAreaID);
string surl1 = fc["Image1"].ToString();
string surl2 = fc["Image2"].ToString();
string surl3 = fc["Image3"].ToString();
tbl_House house = new tbl_House();
house.emailAdmin = sEmail;
house.price = Price;
house.roomNumber = RoomNumber;
if (sFurniture != null)
{
house.furniture = true;
}
else
{
house.furniture = false;
}
house.acreage = Acreage;
house.floor = Floor;
if (sRentStatus != null)
{
house.rentStatus = true;
}
else
{
house.rentStatus = false;
}
house.areaID = AreaID;
house.houseNumber = sHouseNumber;
house.houseStreet = sHouseStreet;
house.otherDetails = sOrderDetails;
db.tbl_House.Add(house);
db.SaveChanges();
//lấy nhà vừa được thêm
List <tbl_House> listHouseAdded = db.tbl_House.Where(n => n.emailAdmin == house.emailAdmin &&
n.price == house.price && n.roomNumber == house.roomNumber && n.furniture == house.furniture &&
n.acreage == house.acreage && n.floor == house.floor && n.rentStatus == house.rentStatus &&
n.areaID == house.areaID && n.houseNumber == house.houseNumber && n.houseStreet == house.houseStreet &&
n.otherDetails == house.otherDetails).ToList();
tbl_House houseAdded = (tbl_House)listHouseAdded[listHouseAdded.Count - 1];
tbl_Image image = new tbl_Image();
image.houseID = houseAdded.houseID;
image.url = surl1;
db.tbl_Image.Add(image);
db.SaveChanges();
image.url = surl2;
db.tbl_Image.Add(image);
db.SaveChanges();
image.url = surl3;
db.tbl_Image.Add(image);
db.SaveChanges();
return(RedirectToAction("GetListHouseByAdmin", "Login"));
}
public ActionResult UpdateHouse(FormCollection fc)
{
string sHouseID = fc["txtHouseID"].ToString().Trim();
int HouseID = int.Parse(sHouseID);
string sPrice = fc["txtPrice"].ToString().Trim();
float Price = float.Parse(sPrice);
string sRoomNumber = fc["txtRoomNumber"].ToString().Trim();
int RoomNumber = int.Parse(sRoomNumber);
string sAcreage = fc["txtAcreage"].ToString().Trim();
float Acreage = float.Parse(sAcreage);
string sFloor = fc["txtFloor"].ToString().Trim();
int Floor = int.Parse(sFloor);
string sHouseNumber = fc["txtHouseNumber"].ToString().Trim();
string sHouseStreet = fc["txtHouseStreet"].ToString().Trim();
var sFurniture = fc["cbFurniture"];
var sRentStatus = fc["cbRentStatus"];
string sOrderDetails = fc["txtOrderDetails"].ToString().Trim();
tbl_House house = db.tbl_House.SingleOrDefault(n => n.houseID == HouseID);
house.price = Price;
house.roomNumber = RoomNumber;
house.acreage = Acreage;
house.floor = Floor;
house.houseNumber = sHouseNumber;
house.houseStreet = sHouseStreet;
if (sFurniture != null)
{
house.furniture = true;
}
else
{
house.furniture = false;
}
if (sRentStatus != null)
{
house.rentStatus = true;
}
else
{
house.rentStatus = false;
}
house.otherDetails = sOrderDetails;
db.Entry(house).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
House h = (House)Session["House"];
h.house = house;
return(View());
}
