public ActionResult LandmarkDelete(long id) { // Storing temporary to reload the model Models.PropertyLandmarkModel plm = new Models.PropertyLandmarkModel(); CLayer.Landmarks data = BLayer.Landmarks.Get(id); // // Delete BLayer.Landmarks.Delete(id); // #region LoadPropertyLandmarkModel if (data != null) { plm = new Models.PropertyLandmarkModel() { Landmark = new Models.LandmarkModel() { LandmarkId = 0, PropertyId = data.PropertyId, LandmarkTitleId = 0, Landmark = "", Range = 0 }, Landmarks = BLayer.Landmarks.GetOnProperty(data.PropertyId), PropertyId = data.PropertyId }; } #endregion return(PartialView("_Landmarks", plm)); }
public ActionResult LandmarkSave(Models.PropertyLandmarkModel data) { try { if (ModelState.IsValid) { CLayer.Landmarks landmark = new CLayer.Landmarks() { LandmarkId = data.Landmark.LandmarkId, LandmarkTitleId = data.Landmark.LandmarkTitleId, Range = data.Landmark.Range, PropertyId = data.PropertyId }; if (data.Landmark.Landmark != null && data.Landmark.Landmark != "") { landmark.Landmark = data.Landmark.Landmark; } else { landmark.Landmark = ""; } BLayer.Landmarks.Save(landmark); } return(RedirectToAction("Index", new { id = data.PropertyId })); } catch (Exception ex) { Common.LogHandler.HandleError(ex); return(Redirect("~/ErrorPage")); } }
public long Save(CLayer.Landmarks data) { List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pLandmarkId", DataPlug.DataType._BigInt, data.LandmarkId)); param.Add(Connection.GetParameter("pPropertyId", DataPlug.DataType._BigInt, data.PropertyId)); param.Add(Connection.GetParameter("pLandmarkTitleId", DataPlug.DataType._Int, data.LandmarkTitleId)); param.Add(Connection.GetParameter("pLandmark", DataPlug.DataType._Varchar, data.Landmark)); param.Add(Connection.GetParameter("pRange", DataPlug.DataType._Varchar, data.Range)); object result = Connection.ExecuteQueryScalar("landmarks_Save", param); return(Connection.ToInteger(result)); }
public CLayer.Landmarks Get(long landmarkId) { CLayer.Landmarks landmark = null; List <DataPlug.Parameter> param = new List <DataPlug.Parameter>(); param.Add(Connection.GetParameter("pLandmarkId", DataPlug.DataType._BigInt, landmarkId)); DataTable dt = Connection.GetTable("landmarks_Get", param); if (dt.Rows.Count > 0) { landmark = new CLayer.Landmarks() { LandmarkId = Connection.ToLong(dt.Rows[0]["LandmarkId"]), PropertyId = Connection.ToLong(dt.Rows[0]["PropertyId"]), LandmarkTitleId = Connection.ToInteger(dt.Rows[0]["LandmarkTitleId"]), Landmark = Connection.ToString(dt.Rows[0]["Landmark"]), Range = Connection.ToDecimal(dt.Rows[0]["Range"]) }; } return(landmark); }
public ActionResult LandmarkEdit(long id) { Models.PropertyLandmarkModel plm = new Models.PropertyLandmarkModel(); CLayer.Landmarks data = BLayer.Landmarks.Get(id); if (data != null) { plm = new Models.PropertyLandmarkModel() { Landmark = new Models.LandmarkModel() { LandmarkId = data.LandmarkId, PropertyId = data.PropertyId, LandmarkTitleId = data.LandmarkTitleId, Landmark = data.Landmark, Range = data.Range }, Landmarks = BLayer.Landmarks.GetOnProperty(data.PropertyId), PropertyId = data.PropertyId }; } return(PartialView("_Landmarks", plm)); }
public static long Save(CLayer.Landmarks data) { DataLayer.Landmarks landmark = new DataLayer.Landmarks(); data.Validate(); return(landmark.Save(data)); }