public static UnOccupiedPropertyList UnOccupiedPropertyView(String UnOccupiedID)
{
UnOccupiedPropertyList List = new UnOccupiedPropertyList();
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 3,
Direction = ParameterDirection.Input
};
var pField = new SqlParameter
{
ParameterName = "Field",
Value = "",
Direction = ParameterDirection.Input
};
var pFieldValue = new SqlParameter
{
ParameterName = "FieldValue",
Value = "",
Direction = ParameterDirection.Input
};
var pID = new SqlParameter
{
ParameterName = "ID",
Value = UnOccupiedID,
Direction = ParameterDirection.Input
};
List = context.ExecuteStoreQuery<UnOccupiedPropertyList>("exec [SYCOUS].[GetUnOccupiedProperty] @mode,@Field,@FieldValue,@ID", parmode, pField, pFieldValue, pID).FirstOrDefault();
return List;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public ActionResult UView(String UnOccupiedID)
{
if (Session["Login"] != null)
{
LoginSession loginsession = (LoginSession)Session["Login"];
ViewBag.CompanyLogo = loginsession.CompanyLogo;
ViewBag.Layout1 = BAL.Common.LayoutType(loginsession.UserType);
String actionName = this.ControllerContext.RouteData.Values["action"].ToString();
String controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ViewBag.Menu = BAL.Common.GetActiveMenu(controllerName, actionName, BAL.Common.LayoutType(loginsession.UserType));
ViewBag.RoleName = loginsession.RoleName;
if (UnOccupiedID != null)
{
String DecUnOccupiedID = BAL.Security.URLDecrypt(UnOccupiedID);
UnOccupiedPropertyList UnOccupied = new UnOccupiedPropertyList();
if ((DecUnOccupiedID != "0") && (DecUnOccupiedID != null))
{
UnOccupied = BAL.UnOccupiedPropertyModel.UnOccupiedPropertyView(DecUnOccupiedID);
}
return View(UnOccupied);
}
else
{ return RedirectToAction("Index", "UnOccupied"); }
}
else
{ return RedirectToAction("Index", "Home"); }
}
public Object ViewRecord(Int64 UnOccupiedId)
{
DAL.UnOccupiedPropertyList UnOccupied = new UnOccupiedPropertyList();
try
{
UnOccupied = DAL.DALUnOccupiedProperty.UnOccupiedPropertyView(UnOccupiedId.ToString());
}
catch (Exception ex)
{
throw;
}
return UnOccupied;
}
