コード例 #1
0
ファイル: ScreenDAL.cs プロジェクト: anushkaD/AnushkaPrivate
        public List<ScreenBO> LoadGrantedScreensByRoleID(int roleId)
        {
            DBEgine dbEgine = new DBEgine();

            List<ScreenBO> screenList = new List<ScreenBO>();

            try
            {
                dbEgine.DBOpen();

                SqlParameter[] parms = new SqlParameter[1];

                SqlParameter p1 = new SqlParameter();
                p1.ParameterName = "@RoleId";
                p1.SqlDbType = SqlDbType.Int;
                p1.Direction = ParameterDirection.Input;
                p1.Value = roleId;
                parms[0] = p1;

                SqlDataReader drScreenList = dbEgine.ExecuteReader("UserManagement.UM_LoadGrantedScreensByRoleID", parms);

                while (drScreenList.Read())
                {
                    ScreenBO objscreen = new ScreenBO();

                    objscreen.ScreenId = drScreenList.GetInt32(drScreenList.GetOrdinal("ScreenId"));
                    objscreen.ScreenName = drScreenList.GetValue(drScreenList.GetOrdinal("Screen")).ToString();
                    objscreen.Url = drScreenList.GetValue(drScreenList.GetOrdinal("URL")).ToString();
                    objscreen.ScreenParentId = drScreenList.GetInt32(drScreenList.GetOrdinal("ScreenParentId"));
                    objscreen.IsMenu = drScreenList.GetBoolean(drScreenList.GetOrdinal("IsMenu"));
                    objscreen.IsEnable = drScreenList.GetBoolean(drScreenList.GetOrdinal("IsEnable"));
                    objscreen.ScreenOrderId = drScreenList.GetInt32(drScreenList.GetOrdinal("ScreenOrderId"));

                    List<ScreenFunctionsBO> listScreenFuntions = new ScreenFunctionsDAL().LoadScreenFunctions(objscreen.ScreenId, roleId);

                    objscreen.ScreenFunctions = new List<ScreenFunctionsBO>();

                    if (listScreenFuntions != null && listScreenFuntions.Count > 0)
                    {
                        objscreen.ScreenFunctions = listScreenFuntions;
                    }

                    screenList.Add(objscreen);

                }
                dbEgine.DBClose();

                return screenList;
            }
            catch
            {
                throw;
            }

            finally
            {
                dbEgine.DBClose();
            }
        }
コード例 #2
0
ファイル: ScreenDAL.cs プロジェクト: anushkaD/AnushkaPrivate
        public List<ScreenBO> LoadScreensbyUserName(string userName)
        {
            DBEgine dbEgine = new DBEgine();

            List<ScreenBO> screenList = new List<ScreenBO>();

            try
            {
                dbEgine.DBOpen();

                SqlParameter[] parms = null;

                SqlDataReader drScreenList = dbEgine.ExecuteReader("UserManagement.UM_LoadScreens", parms);

                while (drScreenList.Read())
                {
                    ScreenBO objscreen = new ScreenBO();

                    objscreen.ScreenId = drScreenList.GetInt32(drScreenList.GetOrdinal("ScreenId"));
                    objscreen.ScreenName = drScreenList.GetValue(drScreenList.GetOrdinal("Screen")).ToString();
                    objscreen.Url = drScreenList.GetValue(drScreenList.GetOrdinal("URL")).ToString();
                    objscreen.ScreenParentId = drScreenList.GetInt32(drScreenList.GetOrdinal("ScreenParentId"));
                    objscreen.IsMenu = drScreenList.GetBoolean(drScreenList.GetOrdinal("IsMenu"));
                    objscreen.ShowOnMenu = drScreenList.GetBoolean(drScreenList.GetOrdinal("ShowOnMenu"));
                    objscreen.IsEnable = drScreenList.GetBoolean(drScreenList.GetOrdinal("IsEnable"));
                    objscreen.ScreenOrderId = drScreenList.GetInt32(drScreenList.GetOrdinal("ScreenOrderId"));

                    List<ScreenFunctionsBO> listScreenFuntions = new ScreenFunctionsDAL().LoadGrantedScreenFunctionsbyScreenIDandUserName(objscreen.ScreenId, userName);

                    objscreen.ScreenFunctions = new List<ScreenFunctionsBO>();
                    if (listScreenFuntions != null && listScreenFuntions.Count > 0)
                    {
                        objscreen.ScreenFunctions = listScreenFuntions;
                    }

                    screenList.Add(objscreen);

                }
                dbEgine.DBClose();

                return screenList;
            }
            catch
            {
                throw;
            }

            finally
            {
                dbEgine.DBClose();
            }
        }