Find all NUnit test assemblies recursively and run them using PowerShell

In order to grab all unit tests assemblies recursively within folder and run them using NUnit I used following PowerShell script. Here I am filtering assemblies found in obj folder.

$nunit = "C:\Program Files (x86)\NUnit 2.6.4\bin\nunit-console.exe"

$assemblies = ""

$items = Get-ChildItem  -Path .\Test  -Filter *UnitTests.dll -Recurse | Where {$_.FullName -notlike "*\obj\*"} 

foreach ($item in $items)

{

$assemblies = $assemblies + " " + $item.FullName  

}

$nunitcmd = """C:\Program Files (x86)\NUnit 2.6.4\bin\nunit-console.exe"" $assemblies /nologo /xml=c:\dump.xml"

$nunitcmd

cmd /c $nunitcmd

Execute MS SQL commands from PowerShell

In order to execute MS SQL commands from PowerShell I used following script.

$sqlquery=@"
USE [DBName]
GO
select * from table
"@

Invoke-Sqlcmd -ServerInstance "ServerName" -Query $sqlquery -Verbose

Get Substring from nAnt property

In order to get sub-string of the nAnt property, to be used in xmlpoke for nAnt I used following statement. Besides the sub-string the following statement also returns the upper case of the string. Here GIT.Commit is the nAnt property.

<xmlpoke file="my.config" xpath="//UI//application//@version" value="${Version}.${string::substring(string::to-upper(GIT.Commit),0,5)}" />

Exit Jenkins

In order to shutdown Jenkins and all ports associated with it's process on server I used following URL

http://jenkins-server-url/exit

C:\Progra~2 for C:\Program Files (x86)

Dont want to use  in your tools because there is space between Program and Files. Then use C:\Progra~2 which maps to C:\Program Files (x86). And yes if you use C:\Progra~1 it maps to C:\Program Files

Get date, add minutes and format it in PowerShell

In order to get current date and add minutes to it and format it I used following command in PowerShell

(get-date).AddMinutes(10).ToString("dd/MMMM/yyyy HH:mm")

Set control's colour pragmatically in C#

In order to set control's colour pragmatically, I used following syntax in C#

btnSearch.ForeColor = Color.FromArgb(0x444444);

Check for string if it contains positive integer in C#

In order to check if strings is positive integer I used following check in C#

        String maxRecords;

        if (maxRecords == "" || !maxRecords.All(Char.IsDigit))
        {
               // Logic to implement when string contains no valid postive integer.
        }

Wrap text for the particular column of GridView

In order to wrap particular column of GridView of ASP.NET I used following

    protected void GridViewLog_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        e.Row.Cells[7].Attributes.Add("style", "word-break:break-all;word-wrap:normal");
    }

Here column 7 of the GridView gets text wrapped.

Close Browser using C#

In Order to Kill (close) all Internet Explorer browser launched, I used following C# code

            Process[] localByName = Process.GetProcessesByName("iexplore");

            foreach (Process item in localByName)
            {
                try
                {
                    item.Kill();
                }
                catch
                {

                }
            }

CruiseControl Scheduled Trigger

In order to schedule CruiseControl build at specific time every day, I used following trigger in the project block

<triggers>
<scheduleTrigger time="22:00" buildCondition="ForceBuild" />
    </triggers>

Start and Stop IIS Website using PowerShell

In Order to stop and start website using PowerShell script I used following command

Import-Module WebAdministration

Stop-WebSite -Name 'Maintenance'

Start-Sleep -s 5

Start-WebSite -Name 'Maintenance'

Show stack trace in NUnit report in CruiseControl Dashboard

In order to have stack train in CruiseControl NUnit webdashboard report, I have added <xsl:value-of select="./failure/stack-trace"/> in webdashboard\xsl\nunitv2.xsl file. Here is the snippet

        <xsl:if test="@success != 'True' ">
      <tr bgcolor="#FF9900"><td colspan="3"><xsl:value-of select="./failure/message"/><br></br><br></br><xsl:value-of select="./failure/stack-trace"/></td></tr>
</xsl:if>

Using extra & with XMLPoke of nAnt

When using XMLPoke on nAnt I used extra amp; when String already contains &amp;

For example

<xmlpoke file="Menu.xml" xpath="//Item[Name[text()='ams']]//ArgumentExpression" value="https://www.myserver.com/Home.aspx?TID={session}&amp;cid={cid}&amp;Username={username}&amp;uiculture={uiculture}" />

I used following extra &amp; as shown below and XMLPoke worked.

<xmlpoke file="Menu.xml" xpath="//Item[Name[text()='ams']]//ArgumentExpression" value="https://www.myserver.com/Home.aspx?TID={session}&amp;amp;cid={cid}&amp;amp;Username={username}&amp;amp;uiculture={uiculture}" />
 

Get Installed .NET versions list

In order to know which .NET frameworks being installed, use following command from the Comand Promt

wmic product where "Name like 'Microsoft .Net%'" get Name, Version

Get Multiple Services using Single PowerShell Command

In order to get multiple services using single PowerShell command I used following

Get-Service | Where-Object {($_.name -like "FV*") -or ($_.name -like "QESE*")}

Clean Redis DB

In order to clean redis database, I used following commnad

redis-cli -p 1216

redis-cli> flushall

Delete all Objects (Images) from Excel Workbook

Select the workbook
Press F5
Click Special
Select Objects
Click OK
Press Delete key from Keyboard

XPATH with namespace

In order to execute XPATH on XML file with namespace, I used following syntax while using nant's xmlpoke command
 

<xmlpoke file="myfile.xml" xpath="/x:Project/x:PropertyGroup/x:ApplicationVersion" value="1234" >

<namespaces>

<namespace prefix="x" uri="http://schemas.microsoft.com/developer/msbuild/2003" />

</namespaces>

</xmlpoke>

Display batch file output on console and write to file simultaneously

In order to see output of DOS Batch file on console as well as log to file simultaneously, I used following syntax

executeme.bat > C:\log.txt && type C:\log.txt