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