public ActionResult SView(String SupID)
{
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 (SupID != null)
{
String DecSupID = BAL.Security.URLDecrypt(SupID);
SupplyList supplier = new SupplyList();
if ((DecSupID != "0") && (DecSupID != null))
{
supplier = BAL.SupplyModel.ViewSupply(DecSupID);
}
return View(supplier);
}
else
{ return RedirectToAction("Index", "Supplier"); }
}
else
{ return RedirectToAction("Index", "Home"); }
}
public static SupplyList ViewSupply(Int64 SupplyID)
{
SupplyList objunit = new SupplyList();
using (var context = new SycousCon())
{
try
{
objunit = (from S in context.Suppliers
join C in context.ClientMasters
on S.ClientID equals C.ClientID
join L in context.SiteMasters
on S.SiteID equals L.Id
join E in context.Energies
on S.EnergyID equals E.ID
join U in context.UnitMasters
on S.UnitID equals U.ID
where (S.IsDeleted == 0 && S.ID == SupplyID)
select new SupplyList
{
SupplierID = SqlFunctions.StringConvert((Double)S.ID),
Client = C.Name,
Site = L.SiteName,
Energy = E.EnergyName,
Unit = U.UnitCode,
Multiplier = S.Volume
}).FirstOrDefault();
if (objunit != null)
{ return objunit; }
else
{
objunit = null;
return objunit;
}
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public Object ViewRecord(Int64 SupplyID)
{
DAL.SupplyList vwSupply = new DAL.SupplyList();
try
{
vwSupply = DAL.DALSupplier.ViewSupply(Convert.ToInt64(SupplyID));
}
catch (Exception ex)
{
throw;
}
return vwSupply;
}
public static SupplyList SupplierView(String ClintID)
{
SupplyList supplyList = new SupplyList();
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = 1,
Direction = ParameterDirection.Input
};
var parClint = new SqlParameter
{
ParameterName = "ClientID",
Value = ClintID,
Direction = ParameterDirection.Input
};
//supplyList = context.ExecuteStoreQuery<SupplyList>("exec [SYCOUS].[[PropertyDetails]] @mode,@ClientID", parmode, parClint).FirstOrDefault();
supplyList = context.ExecuteStoreQuery<SupplyList>("exec [SYCOUS].[SupplierDetails] @mode,@ClientID", parmode, parClint).FirstOrDefault();
return supplyList;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}