public static List <MenuItems> GetMenus() { using (var context = new ERPProjectDataContext()) { return(context.MenuItem.ToList()); } }
public static List <MenuItems> GetParentMenus(int userid) { using (var dbcontext = new ERPProjectDataContext()) { var SQLQuery = @"select MM.* from RoleCapabilities RC INNER JOIN Capabilities CC on RC.CapabilityId=CC.Id INNER JOIN MenuItems MM on CC.MenuItemId=MM.Id INNER JOIN AccUserRoles AC on RC.RoleId=AC.RoleId and AC.UserId = @p0 WHERE MM.ParentMenuItemId IS NULL" ; return(dbcontext.Database.SqlQuery <MenuItems>(SQLQuery, userid).ToList()); } }
public static List <MenuItems> GetSubMenu(int userid, int parentmenuid) { using (var dbContext = new ERPProjectDataContext()) { var SQLQuery = @"SELECT M.* FROM RoleCapabilities RR INNER join Capabilities CC on RR.CapabilityId=CC.Id INNER JOIN MenuItems M on CC.MenuItemId =M.Id INNER join AccUserRoles AR on AR.RoleId=RR.RoleId and ar.userid=@p0 WHERE M.ParentMenuItemId=@p1 and RR.Accessflag = 1" ; var data = dbContext.Database.SqlQuery <MenuItems>(SQLQuery, userid, parentmenuid).ToList(); return(data); } }
public ActionResult Index() { using (ERPProjectDataContext db = new ERPProjectDataContext()) { //var user = new AccUser(); //user.FirstName = "Inder"; //user.LastName = "Singh"; //user.Password = "******"; //user.UserName = "******"; //db.AccUsers.Add(user); //db.SaveChanges(); } return(View()); }
public ItemManager() { db = new ERPProjectDataContext(); }
public AccountsManager() { db = new ERPProjectDataContext(); }
public SaleController() { db = new ERPProjectDataContext(); itemManager = new ItemManager(); accountsmanager = new AccountsManager(); }
public AccountController() { db = new ERPProjectDataContext(); }
public AccountMasterController() { this.db = new ERPProjectDataContext(); }