public List <MenuMasterEn> GetMenuMasterList() { List <MenuMasterEn> loEnList = new List <MenuMasterEn>(); string sqlCmd = "SELECT * FROM UR_MenuMaster"; try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { MenuMasterEn loItem = LoadObjectMenuMaster(loReader); loEnList.Add(loItem); } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
private MenuMasterEn LoadObjectMenuMaster(IDataReader argReader) { MenuMasterEn loItem = new MenuMasterEn(); loItem.MenuID = GetValue <int>(argReader, "menuid"); loItem.MenuName = GetValue <string>(argReader, "menuname"); loItem.PageName = GetValue <string>(argReader, "pagename"); loItem.PageDescription = GetValue <string>(argReader, "pagedescription"); loItem.PageUrl = GetValue <string>(argReader, "pageurl"); loItem.ImageUrl = GetValue <string>(argReader, "imageurl"); loItem.Status = GetValue <bool>(argReader, "status"); loItem.PageOrder = GetValue <int>(argReader, "pageorder"); loItem.LastUpdatedBy = GetValue <string>(argReader, "lastupdatedby"); loItem.LastUpdatedDtTm = GetValue <DateTime>(argReader, "lastupdateddttm"); return(loItem); }
public List <MenuMasterEn> GetMenuMasterAdmin(string MenuName, int UserGroupID) { #region Declarations //Create Instances - Start MenuMasterEn MenuDetails = new MenuMasterEn(); List <MenuMasterEn> MenuList = new List <MenuMasterEn>(); //Create Instances - Stop //variable declarations string SqlStatement = null; #endregion try { SqlStatement = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_MenuMaster.PageDescription, " + " UR_MenuMaster.PageUrl, UR_MenuMaster.ImageUrl, UR_MenuMaster.Status, UR_MenuMaster.PageOrder, UR_MenuMaster.LastUpdatedBy, " + " UR_MenuMaster.LastUpdatedDtTm, UR_UserRights.IsAdd, UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, " + " UR_UserRights.IsPrint, UR_UserRights.IsPost, UR_UserRights.IsOthers FROM UR_MenuMaster INNER JOIN UR_UserRights " + " ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE UR_UserRights.UserGroupId = " + UserGroupID + " AND UR_MenuMaster.MenuName = " + clsGeneric.AddQuotes(MenuName) + " AND UR_MenuMaster.Status = 'true' " + " ORDER BY UR_MenuMaster.PageOrder"; IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, SqlStatement).CreateDataReader(); if (_IDataReader != null) { while (_IDataReader.Read()) { MenuDetails = LoadMenuObject(_IDataReader); MenuList.Add(MenuDetails); } _IDataReader.Close(); _IDataReader.Dispose(); return(MenuList); } return(null); } catch (Exception ex) { throw ex; } }
public List <MenuMasterEn> GetPreparerWorkflowList(string MenuName, int UserID, int UserGroupId) { MenuMasterEn _MenuMasterEn = new MenuMasterEn(); List <MenuMasterEn> list = new List <MenuMasterEn>(); try { string SqlStatement = @"SELECT mm.MenuID, mm.MenuName, mm.PageName, mm.PageDescription, mm.PageUrl, mm.ImageUrl, mm.Status, mm.PageOrder, mm.LastUpdatedBy, mm.LastUpdatedDtTm, ur.IsAdd, ur.IsEdit, ur.IsDelete, ur.IsView, ur.IsPrint, ur.IsPost, ur.IsOthers FROM ur_usermenu_preparer prep INNER JOIN ur_menumaster mm ON mm.menuid = prep.menuid INNER JOIN ur_userrights ur ON ur.usergroupid = (SELECT usergroupid FROM ur_users WHERE userid = prep.userid) AND prep.menuid = ur.menuid WHERE prep.userid = " + UserID + @" AND ur.usergroupid = " + UserGroupId + @" AND mm.menuname = " + clsGeneric.AddQuotes(MenuName) + @" AND mm.status = 'true' AND mm.menuid <> 114 ORDER BY mm.pageorder "; IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, SqlStatement).CreateDataReader(); if (_IDataReader != null) { while (_IDataReader.Read()) { _MenuMasterEn = LoadMenuObject(_IDataReader); list.Add(_MenuMasterEn); } _IDataReader.Close(); _IDataReader.Dispose(); return(list); } return(null); } catch (Exception ex) { throw ex; } }
/// <summary> /// Method to Load MenuMaster Entity /// </summary> /// <param name="argReader">IDataReader Object is an Input.</param> /// <returns>Returns MenuMaster Entity</returns> private MenuMasterEn LoadMenuObject(IDataReader argReader) { MenuMasterEn loItem = new MenuMasterEn(); loItem.MenuID = GetValue <int>(argReader, "MenuID"); loItem.MenuName = GetValue <string>(argReader, "MenuName"); loItem.PageName = GetValue <string>(argReader, "PageName"); loItem.PageDescription = GetValue <string>(argReader, "PageDescription"); loItem.PageUrl = GetValue <string>(argReader, "PageUrl"); loItem.ImageUrl = GetValue <string>(argReader, "ImageUrl"); loItem.Status = GetValue <bool>(argReader, "Status"); loItem.PageOrder = GetValue <int>(argReader, "PageOrder"); loItem.LastUpdatedBy = GetValue <string>(argReader, "LastUpdatedBy"); loItem.LastUpdatedDtTm = GetValue <DateTime>(argReader, "LastUpdatedDtTm"); loItem.IsAdd = GetValue <bool>(argReader, "IsAdd"); loItem.IsEdit = GetValue <bool>(argReader, "IsEdit"); loItem.IsDelete = GetValue <bool>(argReader, "IsDelete"); loItem.IsView = GetValue <bool>(argReader, "IsView"); loItem.IsPrint = GetValue <bool>(argReader, "IsPrint"); loItem.IsPost = GetValue <bool>(argReader, "IsPost"); loItem.IsOthers = GetValue <bool>(argReader, "IsOthers"); return(loItem); }
/// <summary> /// Method to Get List of All UserRights by UserID /// </summary> /// <param name="UserGroupID">UserID as an Input.</param> /// <returns>Returns List of UserRights</returns> public List <UserRightsEn> GetMenuByUser(int UserID) { List <UserRightsEn> loEnList = new List <UserRightsEn>(); string sqlCmd = null; //Create Instances - Start MenuMasterEn MenuDetails = new MenuMasterEn(); List <MenuMasterEn> MenuList = new List <MenuMasterEn>(); //Create Instances - Stop if (UserID > 0) { //sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_UserRights.IsAdd, " + //"UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, UR_UserRights.IsPost, UR_UserRights.IsPrint," + //"UR_UserRights.DefaultMode FROM UR_MenuMaster INNER JOIN " + //"UR_UserRights ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE " + //"UR_MenuMaster.Status = true AND UR_MenuMaster.MenuID <> 114 AND " + //"UR_UserRights.UserId =" + UserID + " order by UR_MenuMaster.MenuName desc"; //sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName " + sqlCmd = "SELECT UR_MenuMaster.MenuID " + "FROM UR_MenuMaster WHERE UR_MenuMaster.Status = true AND UR_MenuMaster.MenuName = 'Process' " + "AND UR_MenuMaster.MenuID IN (SELECT MenuID from ur_usermenu WHERE UserId = " + UserID + ") " + "ORDER BY UR_MenuMaster.MenuName desc, UR_MenuMaster.pageorder"; } else { sqlCmd = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName " + "FROM UR_MenuMaster WHERE UR_MenuMaster.Status = true AND UR_MenuMaster.MenuName = 'Process' " + "ORDER BY UR_MenuMaster.MenuName desc, UR_MenuMaster.pageorder"; } try { if (!FormHelp.IsBlank(sqlCmd)) { using (IDataReader loReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, sqlCmd).CreateDataReader()) { while (loReader.Read()) { if (UserID > 0) { UserRightsEn loItem = new UserRightsEn(); loItem.MenuID = GetValue <int>(loReader, "MenuID"); //loItem.MenuName = GetValue<string>(loReader, "MenuName"); //loItem.PageName = GetValue<string>(loReader, "PageName"); loEnList.Add(loItem); } else { UserRightsEn loMenuItem = LoadURMenu(loReader); loMenuItem.MenuID = GetValue <int>(loReader, "MenuID"); loMenuItem.MenuName = GetValue <string>(loReader, "MenuName"); loMenuItem.PageName = GetValue <string>(loReader, "PageName"); //loMenuItem.IsAdd = false; //loMenuItem.IsEdit = false; //loMenuItem.IsDelete = false; //loMenuItem.IsView = false; //loMenuItem.IsPrint = false; //loMenuItem.IsPost = false; //loMenuItem.IsAddModeDefault = false; loEnList.Add(loMenuItem); } } loReader.Close(); } } } catch (Exception ex) { throw ex; } return(loEnList); }
/// <summary> /// Method to Get List of Menus By UserGroups /// </summary> /// <param name="MenuName">MenuName is an Input.</param> /// <param name="UserGroupID">UserGroupID is an Input.</param> /// <returns>Returns List of Menus</returns> public List <MenuMasterEn> GetMenuByWorkflowGroup(string MenuName, int UserGroupID, int UserID) { #region Declarations //Create Instances - Start MenuMasterEn MenuDetails = new MenuMasterEn(); List <MenuMasterEn> MenuList = new List <MenuMasterEn>(); //Create Instances - Stop //variable declarations string SqlStatement = null; #endregion try { //Build Sql Statement - Start SqlStatement = "SELECT UR_MenuMaster.MenuID, UR_MenuMaster.MenuName, UR_MenuMaster.PageName, UR_MenuMaster.PageDescription, " + " UR_MenuMaster.PageUrl, UR_MenuMaster.ImageUrl, UR_MenuMaster.Status, UR_MenuMaster.PageOrder, UR_MenuMaster.LastUpdatedBy, " + " UR_MenuMaster.LastUpdatedDtTm, UR_UserRights.IsAdd, UR_UserRights.IsEdit, UR_UserRights.IsDelete, UR_UserRights.IsView, " + " UR_UserRights.IsPrint, UR_UserRights.IsPost, UR_UserRights.IsOthers FROM UR_MenuMaster INNER JOIN UR_UserRights " + " ON UR_MenuMaster.MenuID = UR_UserRights.MenuID WHERE UR_UserRights.UserGroupId = " + UserGroupID + " AND UR_MenuMaster.MenuName = " + clsGeneric.AddQuotes(MenuName) + " AND UR_MenuMaster.Status = 'true' "; if (MenuName == "Setup") { SqlStatement += " AND UR_MenuMaster.MenuID = 13"; } if (MenuName == "Process") { SqlStatement += " AND UR_MenuMaster.MenuID = 114"; //SqlStatement += " AND UR_MenuMaster.MenuID IN (SELECT MenuID from ur_usermenu WHERE userid = " + UserID + ") "; } if (MenuName == "Reports") { SqlStatement += " AND UR_MenuMaster.MenuID = 18"; } SqlStatement += " ORDER BY UR_MenuMaster.PageOrder"; //Build Sql Statement - Stop //Get User Login Details - Start IDataReader _IDataReader = _DatabaseFactory.ExecuteReader(Helper.GetDataBaseType, DataBaseConnectionString, SqlStatement).CreateDataReader(); //Get User Login Details - Stop //if user login details available - Start if (_IDataReader != null) { while (_IDataReader.Read()) { //load data to entities MenuDetails = LoadMenuObject(_IDataReader); MenuList.Add(MenuDetails); } _IDataReader.Close(); _IDataReader.Dispose(); return(MenuList); } //if user login details available - Stop return(null); } catch (Exception ex) { throw ex; } }