public static DisConnectedSupplyList DisConnectedSupplyView(String DisConnectedID) { DisConnectedSupplyList List = new DisConnectedSupplyList(); 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 = DisConnectedID, Direction = ParameterDirection.Input }; List = context.ExecuteStoreQuery<DisConnectedSupplyList>("exec [SYCOUS].[GetDisConnectedSupply] @mode,@Field,@FieldValue,@ID", parmode, pField, pFieldValue, pID).FirstOrDefault(); return List; } catch (Exception ex) { context.Dispose(); throw; } } }
public ActionResult DView(String DisConnectedID) { 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 (DisConnectedID != null) { String DecDisConnectedID = BAL.Security.URLDecrypt(DisConnectedID); DisConnectedSupplyList DisConnected = new DisConnectedSupplyList(); if ((DecDisConnectedID != "0") && (DecDisConnectedID != null)) { DisConnected = BAL.DisConnectedSupplyModel.DisConnectedSupplyView(DecDisConnectedID); } return View(DisConnected); } else { return RedirectToAction("Index", "Disconnected"); } } else { return RedirectToAction("Index", "Home"); } }
public Object ViewRecord(Int64 DisConnectedId) { DAL.DisConnectedSupplyList UnOccupied = new DisConnectedSupplyList(); try { UnOccupied = DAL.DALDisConnectedSupply.DisConnectedSupplyView(DisConnectedId.ToString()); } catch (Exception ex) { throw; } return UnOccupied; }