/// <summary> /// To generate child menu based on parentid from database /// </summary> private void GenerateChildMenu(string parentMenuID) { DataView menuView = new DataView(subMenuTable); menuView.RowFilter = "PARENTMENUID = " + parentMenuID; for (int i = 0; i < menuView.Count; i++) { objPriv = new RolePrivilegesBO(); objPriv.MenuID = Convert.ToInt32(menuView[i]["CHILDMENUID"]); //sb.Clear(); //paddingCount = Convert.ToInt32(menuView[i]["CHILDLEVEL"]); //for (int j = 1; j < paddingCount; j++) //{ // if (paddingCount == 2) // sb.Append(" ------"); // else if (j < (paddingCount - 1)) // sb.Append(" "); // else // sb.Append("------"); //} objPriv.ParentMenuID = Convert.ToInt32(menuView[i]["PARENTMENUID"]); objPriv.MenuDescription = menuView[i]["MENUDESCRIPTION"].ToString(); objPriv.ChildMenuCount = Convert.ToInt32(menuView[i]["CHILDMENUCOUNT"]); objPriv.MenuLevel = Convert.ToInt32(menuView[i]["CHILDLEVEL"]); RolePrivilegesLst.Add(objPriv); GenerateChildMenu(menuView[i]["CHILDMENUID"].ToString()); } menuView = null; }
/// <summary> /// Set Grid Data source /// </summary> /// <param name="addRow"></param> /// <param name="deleteRow"></param>e private void GenerateMenuItems() { RolePrivilegesLst = new RolePrivilegesList(); RolePrivilegesBLL objRolePrivBLL = new RolePrivilegesBLL(); DataTable mainMenuTable = objRolePrivBLL.GetRolePrivileges(); subMenuTable = mainMenuTable.Copy(); DataView MainMenuView = mainMenuTable.AsDataView(); DataView SubMenuView = subMenuTable.AsDataView(); MainMenuView.RowFilter = "PARENTMENUID=0"; for (int i = 0; i < MainMenuView.Count; i++) { objPriv = new RolePrivilegesBO(); objPriv.MenuID = Convert.ToInt32(MainMenuView[i]["CHILDMENUID"]); objPriv.MenuDescription = MainMenuView[i]["MENUDESCRIPTION"].ToString(); objPriv.ChildMenuCount = Convert.ToInt32(MainMenuView[i]["CHILDMENUCOUNT"]); objPriv.MenuLevel = Convert.ToInt32(MainMenuView[i]["CHILDLEVEL"]); objPriv.ParentMenuID = Convert.ToInt32(MainMenuView[i]["PARENTMENUID"]); RolePrivilegesLst.Add(objPriv); GenerateChildMenu(MainMenuView[i]["CHILDMENUID"].ToString()); } mainMenuTable = null; rptRolePrivileges.DataSource = RolePrivilegesLst; rptRolePrivileges.DataBind(); }
/// <summary> /// To Get ROLE PRI Id /// </summary> /// <param name="UserID"></param> /// <returns></returns> public RolePrivilegesList GetROLEPRIId(int UserID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_ROLEBYUSERID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("USERID_", UserID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); RolePrivilegesBO RolePrivilegesObj = null; RolePrivilegesList RolePrivilegesList = new RolePrivilegesList(); while (dr.Read()) { RolePrivilegesObj = new RolePrivilegesBO(); if (!dr.IsDBNull(dr.GetOrdinal("USERID"))) { RolePrivilegesObj.UserID = dr.GetInt32(dr.GetOrdinal("USERID")); } if (!dr.IsDBNull(dr.GetOrdinal("MENUID"))) { RolePrivilegesObj.MenuID = dr.GetInt32(dr.GetOrdinal("MENUID")); } if (!dr.IsDBNull(dr.GetOrdinal("MENULEVEL"))) { RolePrivilegesObj.MenuLevel = dr.GetInt32(dr.GetOrdinal("MENULEVEL")); } if (!dr.IsDBNull(dr.GetOrdinal("MENUNAME"))) { RolePrivilegesObj.MenuName = dr.GetString(dr.GetOrdinal("MENUNAME")); } if (!dr.IsDBNull(dr.GetOrdinal("CANVIEW"))) { RolePrivilegesObj.CanView = dr.GetString(dr.GetOrdinal("CANVIEW")); } if (!dr.IsDBNull(dr.GetOrdinal("CANUPDATE"))) { RolePrivilegesObj.CanUpdate = dr.GetString(dr.GetOrdinal("CANUPDATE")); } if (!dr.IsDBNull(dr.GetOrdinal("CHILDMENUCOUNT"))) { RolePrivilegesObj.ChildMenuCount = dr.GetInt32(dr.GetOrdinal("CHILDMENUCOUNT")); } if (!dr.IsDBNull(dr.GetOrdinal("PROJDEPENDENT"))) { RolePrivilegesObj.ProjectDependent = dr.GetString(dr.GetOrdinal("PROJDEPENDENT")); } else { RolePrivilegesObj.ProjectDependent = "N"; } if (!dr.IsDBNull(dr.GetOrdinal("PAPDEPENDENT"))) { RolePrivilegesObj.PAPDependent = dr.GetString(dr.GetOrdinal("PAPDEPENDENT")); } else { RolePrivilegesObj.PAPDependent = "N"; } RolePrivilegesList.Add(RolePrivilegesObj); } dr.Close(); return(RolePrivilegesList); }