public static UnitList ViewUnit(Int32 UnitID)
{
UnitList objunit = new UnitList();
using (var context = new SycousCon())
{
try
{
objunit = (from p in context.UnitMasters.Where(c => c.IsDeleted == 0 && c.ID == UnitID)
orderby p.CreateDate descending
select new UnitList()
{
ID = SqlFunctions.StringConvert((Double)p.ID),
UnitCode = p.UnitCode,
UnitName = p.UnitName,
Multiplier = p.Volume
}).FirstOrDefault();
if (objunit != null)
{ return objunit; }
else
{
objunit = null;
return objunit;
}
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public ActionResult SView(String UnitID)
{
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 (UnitID != null)
{
String DecUnitID = BAL.Security.URLDecrypt(UnitID);
DAL.UnitList list = new UnitList();
if ((DecUnitID != "0") && (DecUnitID != null))
{
list = BAL.UnitModel.ViewUnit(DecUnitID);
}
return View(list);
}
else
{ return RedirectToAction("Index", "Unit"); }
}
else
{ return RedirectToAction("Index", "Home"); }
}
public static UnitList UnitView(String ClintID)
{
UnitList unitList = new UnitList();
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
};
unitList = context.ExecuteStoreQuery<UnitList>("exec [SYCOUS].[UnitDetails] @mode,@ClientID", parmode, parClint).FirstOrDefault();
return unitList;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public Object ViewRecord(Int64 unitID)
{
DAL.UnitList vwunit = new DAL.UnitList();
try
{
vwunit = DAL.DALUnit.ViewUnit(Convert.ToInt32(unitID));
}
catch (Exception ex)
{
throw;
}
return vwunit;
}
