public static MenuMasterAuthentication GetMenuMasterAuthentication(MenuMaster MenuMaster) { MenuMasterAuthentication result = new MenuMasterAuthentication(); result._MenuMaster = MenuMaster; MenuMasterPermissionCollection MenuMasterPermissionList = MenuMasterPermissionCollection.GetMenuMasterPermissionCollection(); foreach (MenuMasterPermission item in MenuMasterPermissionList) { result._listAuthentication.Add(item, new List <Role>()); } RoleCollection roleList = RoleCollection.GetRoleCollection(); Database database = new Database("PSCPortalConnectionString"); using (DbConnection connection = database.GetConnection()) { DbCommand command = database.GetCommand(connection); #region MenuMasterId DbParameter prMenuMasterId = database.GetParameter(System.Data.DbType.Guid, "@MenuMasterId", MenuMaster.Id); command.Parameters.Add(prMenuMasterId); #endregion command.CommandText = "MenuMasterAuthentication_GetAllByMenuMasterId"; command.CommandType = System.Data.CommandType.StoredProcedure; connection.Open(); DbDataReader reader = command.ExecuteReader(); int idtptemp; Guid idrtemp; MenuMasterPermission tptemp; Role rtemp; while (reader.Read()) { idtptemp = (int)reader["MenuMasterPermissionId"]; idrtemp = (Guid)reader["RoleId"]; tptemp = MenuMasterPermissionList.Where(tp => tp.Id == idtptemp).Single(); rtemp = roleList.Where(r => r.Id == idrtemp).Single(); result._listAuthentication[tptemp].Add(rtemp); } } return(result); }
public static MenuMasterPermissionCollection GetMenuMasterPermissionCollection() { MenuMasterPermissionCollection result = new MenuMasterPermissionCollection(); Database database = new Database("PSCPortalConnectionString"); using (DbConnection connection = database.GetConnection()) { DbCommand command = database.GetCommand(connection); command.CommandText = "MenuMasterPermission_GetAll"; command.CommandType = System.Data.CommandType.StoredProcedure; connection.Open(); using (DbDataReader reader = command.ExecuteReader()) { while (reader.Read()) { result.Add(new MenuMasterPermission(reader)); } } } return(result); }