public JsonResult InsertOrUpdateHouse(HouseVM _obj)
{
try
{
_obj.createdBy = Convert.ToInt32(Session["userId"]);
int result = _da.InsertOrUpdateHouse(_obj);
if (_obj.houseId == 0)
{
return(Json(new { success = true, message = "Data Saved" }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = true, message = "Data Updated" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
if (ex.Message.Contains("Violation of UNIQUE KEY"))
{
return(Json(new { success = false, message = "This house Name Under this Project!!" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
// GET: Houses/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HouseVM house = db.Houses.Where(x => x.HouseID == id).Select(x => new HouseVM()
{
HouseID = x.HouseID,
CityID = x.CityID,
CountryID = x.City.State.CountryID,
HouseAddress = x.HouseAddress,
HouseDescription = x.HouseDescription,
HouseFeatures = x.HouseFeatures.ToList(),
HouseImage = x.HouseImage,
HouseName = x.HouseName,
HousePrice = x.HousePrice,
HouseTypeID = x.HouseTypeID,
StateID = x.City.StateID
}).FirstOrDefault();
if (house == null)
{
return(HttpNotFound());
}
ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName", house.CountryID);
ViewBag.StateID = new SelectList(db.States, "StateID", "StateName", house.StateID);
ViewBag.CityID = new SelectList(db.Cities, "CityID", "CityName", house.CityID);
ViewBag.HouseTypeID = new SelectList(db.HouseTypes, "HouseTypeID", "HouseTypeName", house.HouseTypeID);
return(View(house));
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
var houseVM = new HouseVM();
this.DataContext = null;
this.DataContext = houseVM;
}
public JsonResult GetHousesById(int id)
{
try
{
HouseVM _obj = _da.GetHouseListByProjectIdAndId(projectId: 0, houseId: id).FirstOrDefault() ?? new HouseVM();
return(Json(new { success = true, data = _obj }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult Create(HouseVM houseVM, int?FeatureID1, int?FeatureID2, int?FeatureID3)
{
ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "CountryName");
ViewBag.StateID = new SelectList(db.States, "StateID", "StateName");
ViewBag.CityID = new SelectList(db.Cities, "CityID", "CityName");
ViewBag.HouseTypeID = new SelectList(db.HouseTypes, "HouseTypeID", "HouseTypeName");
ViewBag.Features = db.Features.ToList();
House house = new House();
house.HouseName = houseVM.HouseName;
house.HousePrice = houseVM.HousePrice;
house.CityID = houseVM.CityID;
house.HouseTypeID = houseVM.HouseTypeID;
house.HostID = GetUserID();
house.HouseAddress = houseVM.HouseAddress;
house.HouseDescription = houseVM.HouseDescription;
house.CreatedBy = User.Identity.Name;
house.CreatedOn = DateTime.Now;
house.Status = true;
if (houseVM.House_Image != null)
{
string HouseImage = UploadPostedFile(houseVM.House_Image, "~/Content/Uploads/Images/Houses/");
if (!string.IsNullOrWhiteSpace(HouseImage))
{
house.HouseImage = HouseImage;
db.Houses.Add(house);
db.SaveChanges();
AddFeture(1, house.HouseID, FeatureID1.ToString());
AddFeture(2, house.HouseID, FeatureID2.ToString());
AddFeture(3, house.HouseID, FeatureID3.ToString());
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Error Save HouseImage");
}
}
else
{
ModelState.AddModelError("", "Error Save HouseImage");
}
return(View(houseVM));
}
public IActionResult AddHouse(HouseVM house)
{
if (!ModelState.IsValid)
{
Response.StatusCode = (int)HttpStatusCode.BadRequest;
return(BadRequest(new { success = false, errors = ModelState.Errors() }));
}
try
{
var newHouse = _mapper.Map <HouseVM, House>(house);
_unitOfWork.Houses.Add(newHouse);
_unitOfWork.SaveChanges();
return(Ok(new { success = true, message = "Доб успешно добавлен." }));
}
catch (Exception ex)
{
ModelState.AddModelError("", $"Произошла ошибка, обратитесь за помощью к администратору. {ex.Message}");
return(BadRequest(new { success = false, errors = ModelState.Errors() }));
}
}
public int InsertOrUpdateHouse(HouseVM _obj)
{
int result = 0;
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("isp_house", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@houseId", _obj.houseId);
cmd.Parameters.AddWithValue("@projectId", _obj.projectId);
cmd.Parameters.AddWithValue("@houseName", _obj.houseName);
cmd.Parameters.AddWithValue("@houseType", _obj.houseType);
cmd.Parameters.AddWithValue("@description", _obj.description);
cmd.Parameters.AddWithValue("@monthlyRent", _obj.monthlyRent);
cmd.Parameters.AddWithValue("@createdBy", _obj.createdBy);
result = 1;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
return(result);
}
public IActionResult Post(HouseVM house)
{
//TODO: implement post house to database.
return(Ok(house));
}
