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