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