this.Principal = new Mock<IPrincipal>(); List<Claim> claims = new List<Claim>{ new Claim("http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name", username), new Claim("http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier", userid) }; var fakeIdentity = new GenericIdentity(username); //fakeIdentity.RemoveClaim(new Claim("http://schemas.xmlsoap.org/ws/2005/05/identity/claims/name", "")); fakeIdentity.AddClaims(claims); var fakePrincipal = new GenericPrincipal(fakeIdentity, roles); Principal.Setup(n => n.Identity).Returns(fakeIdentity); Http.Setup(x => x.User).Returns(fakePrincipal); Http.Setup(x => x.User.Identity.Name).Returns(username); Http.Setup(x => x.User.Identity).Returns(fakeIdentity);
SELECT b.name, c.name FROM sys.schemas a JOIN sys.all_objects b ON b.schema_id = a.schema_id JOIN sys.columns c ON c.object_id = b.object_id WHERE c.NAME LIKE '%Find Field%'
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 |
/* * Get a list of reports in a specific path/folder */ ;WITH ItemContentBinaries AS ( SELECT ItemID ,Name ,[Type] ,CASE [Type] WHEN 2 THEN 'Report' WHEN 5 THEN 'Data Source' WHEN 7 THEN 'Report Part' WHEN 8 THEN 'Shared Dataset' ELSE 'Other' END AS TypeDescription ,CONVERT(varbinary(max),Content) AS Content FROM ReportServer.dbo.[Catalog] with (nolock) WHERE [PATH] LIKE '/Department Level/%' ) ---ADD WORDS, USED IN FIELDS, TO SEARCH FOR ,WordSearchCTE AS ( SELECT 'SSN' AS Word UNION ALL SELECT 'AGE' UNION ALL SELECT 'DOB' UNION ALL SELECT 'EPMP' UNION ALL SELECT 'PAY' UNION ALL SELECT 'COMP' ) --This CTE strips off the BOM if it exists... ,ItemContentNoBOM AS ( SELECT ItemID ,Name ,[Type] ,TypeDescription ,CASE WHEN LEFT(Content,3) = 0xEFBBBF THEN CONVERT(varbinary(max),SUBSTRING(Content,4,LEN(Content))) ELSE Content END AS Content FROM ItemContentBinaries ) --The old outer query is now a CTE to get the content in its xml form only... ,ItemContentXML AS ( SELECT ItemID,Name,[Type],TypeDescription ,CONVERT(xml,Content) AS ContentXML FROM ItemContentNoBOM ) --now use the XML data type to extract the queries, and their command types and text.... --and only select from those that contain the search terms SELECT * FROM ( SELECT ItemID,Name,[Type],TypeDescription,ContentXML ,ISNULL(Query.value('(./*:CommandType/text())[1]','nvarchar(1024)'),'Query') AS CommandType ,Query.value('(./*:CommandText/text())[1]','nvarchar(max)') AS CommandText FROM ItemContentXML --Get all the Query elements (The "*:" ignores any xml namespaces) CROSS APPLY ItemContentXML.ContentXML.nodes('//*:Query') Queries(Query) )x JOIN ( select '%'+Word+'%' as pattern from WordSearchCTE ) w on CommandText like w.pattern |
1)Setup your profile for powershell:
2)Open up the profile:Notepad $profile 3)Cut and paste resize into notepad and save: ##
## Author : Roman Kuzmin
## Synopsis : Resize console window/buffer using arrow keys
##
function Size($w, $h)
{
New-Object System.Management.Automation.Host.Size($w, $h)
}
function resize()
{
Write-Host '[Arrows] resize [Esc] exit ...'
$ErrorActionPreference = 'SilentlyContinue'
for($ui = $Host.UI.RawUI;;) {
$b = $ui.BufferSize
$w = $ui.WindowSize
switch($ui.ReadKey(6).VirtualKeyCode) {
37 {
$w = Size ($w.width - 1) $w.height
$ui.WindowSize = $w
$ui.BufferSize = Size $w.width $b.height
break
}
39 {
$w = Size ($w.width + 1) $w.height
$ui.BufferSize = Size $w.width $b.height
$ui.WindowSize = $w
break
}
38 {
$ui.WindowSize = Size $w.width ($w.height - 1)
break
}
40 {
$w = Size $w.width ($w.height + 1)
if ($w.height -gt $b.height) {
$ui.BufferSize = Size $b.width $w.height
}
$ui.WindowSize = $w
break
}
27 {
return
}
}
}
} 4) Change policy for the profile, exit powershell and open a new version "Run as Administrator":Set-ExecutionPolicy bypass -Scope CurrentUser
5) Close powershell and open a new version, type resize.
If need be, you can just create a chart with the name and color/marker sparkline and move your legend anywhere you want. [HttpPost]
[ValidateAntiForgeryToken]
public async Task<ActionResult> ChangeUserName(ManageUsernameViewModel model)
{
bool hasPassword = HasPassword();
if (hasPassword)
{
if (ModelState.IsValid)
{
//Get UserID
var userID = User.Identity.GetUserId();
var currentUserName = User.Identity.GetUserName();
var newUserName = model.NewUserName;
//Check if new username already exisits
if (UserManager.FindByName(model.NewUserName) != null)
{
ModelState.AddModelError(string.Empty, "That username already exist.");
return RedirectToAction("Manage", new { Message = ManageMessageId.DuplicateUserName });
}
var user = UserManager.Find(model.OldUserName, model.Password);
if (user != null)
{
//Change username
if (DataAccess.userDataAccess.updateUserName(model.NewUserName, userID))
{
AuthenticationManager.SignOut();
await SignInAsync(user, false);
var identity = new ClaimsIdentity(User.Identity);
identity.RemoveClaim(identity.FindFirst(identity.NameClaimType));
identity.AddClaim(new Claim(identity.NameClaimType, model.NewUserName));
AuthenticationManager.AuthenticationResponseGrant = new AuthenticationResponseGrant(new ClaimsPrincipal(identity), new AuthenticationProperties { IsPersistent = false });
return RedirectToAction("Manage", new { message = ManageMessageId.ChangeUserNameSuccess });
}
else
{
AddErrors(new IdentityResult("Failed updating your username."));
}
}
else
{
ModelState.AddModelError("", "Invalid username and password.");
}
}
}
// If we got this far, something failed, redisplay form
return View();
}