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