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