• To create a sub class,
• add ' : <classname>' to the class statement
• add :' base()' to the constructor
•  

Base Class WITHOUT Arguments

• If Base Class accepts NO arguments, the subclass doesn't need to include the 'base class constructor'

    class BaseClass
    {
        public BaseClass()

• Constructor doesn't need an explicit reference to the base class

    class Base_SubClass : BaseClass
    {
       public Base_SubClass()

• This is also valid & probably preferred

    class Base_SubClass : BaseClass
    {
       public Base_SubClass() : BaseClass() {}

Base Class WITH Arguments

• If Base Class constructor TAKES arguments, the subclass constructor must include them explicitly

C# MySQL Connections

• VisualStudio makes it easy to create a webform application with buttons for DB connection & queries

Create New Project DatabaseFormApp

Add Reference for MySql.Data package

• Source: https://www.youtube.com/watch?v=11iGyrvBhzc

Add New Project

• IISExpress works great locally out of the box, but for remote connections, more config is needed
• https://stackoverflow.com/questions/5442551/iisexpress-returns-a-503-error-from-remote-machines

Simple Answer

• See video: https://youtu.be/plRPBT3h3S8

Create Project

• Add New Project > WCF Service Application

ProtoService

Project Layout

Add WebService

• Add New Item > Web Service ( ASMX )

TemperatureConverter.asmx

• Update [WebService(Namespace = "https:www.yourhostname.com/")]
• A Class file of the same name is created

• https://www.petri.com/configure_tcp_ip_from_cmd

Dos Shell Script

@echo off
echo This script must be ran as ADMIN
set ipAddr=192.168.0.81
set subMask=255.255.255.0
set gwAddr=192.168.0.1
set dns=dhcp
set dnsAddr=208.180.42.68

echo %COMPUTERNAME% - %ipAddr% - %subMask% - %gwAddr% - %dnsAddr%
echo Setting inferace values now... CTRL-C to cancel
pause
netsh interface ip set address name="Local Area Connection" static %ipAddr% %subMask% %gwAddr%
netsh interface ip set dns "Local Area Connection" source=dhcp

netsh Commands

Show if config

netsh interface ip show config

Set if to static

netsh interface ip set address name="Local Area Connection" static 192.168.0.81 255.255.255.0 192.168.0.1

Set DNS for DHCP

netsh interface ip set dns "Local Area Connection" source=dhcp

Set DNS to static value

• Getting started with SpecFlow begins with setting up the environment & getting proof of concept working
• Install VS2017, SpecFlow IDE Extension
• Add Project
• Install NuGet Packages for SpecFlow, NUnit & NUnit3 Test Adapter
• Add SpecFlow Feature File
• Generate Test Definitions
• Replace method statement stubs with Console.Writeln() statements
• Build project & Run Test
• Ensure Test Passed & produced output

VisualStudio Setup

Install Visual Studio 2017 & Dependencies

SpecFlow IDE Plugin

Tools > Extensions and Updates

Search for SpecFlow & Install

SpecFlow NuGet

References > Manage NuGet Packages

Search for SpecFlow & Install

NUnit NuGet

References > Manage NuGet Packages

Search for NUnit & Install

Common Selector Strategies

• used some help from: https://automationpanda.com/2018/06/15/web-element-clicks-with-selenium-webdriver/

Page Title

return driver.getTitle();

findElement(By.id

element = driver.findElement(By.id("edit-field-tags-target-id"));
return element;

findElement(By.xpath

element = driver.findElement(By.xpath("//iframe[@title='Rich Text Editor, Body field']"));

Explicit Waits

int timeoutSec = 15;
WebDriverWait wait = new WebDriverWait(driver, timeoutSec);
wait.until((driver) -> driver.findElements(By.xpath("//a[@href='/uc/user/login']")).size()>0);
wait.until((driver) -> driver.findElement(By.xpath("//a[@href='/uc/user/login']")).isDisplayed());

Basic Gherkin Feature Model

Feature: User can create an article

Scenario: user logs in
Given user is on HomePage
When user navigates to LoginPage
And user enters UserName and Password
Then message displayed Login Successful

Scenario: user creates a new article
Given user is logged in and on HomePage
When user clicks CreateArticleLink
And user enters ArticleTitle
And user enters ArticleBody
And user neters ArticleTags
And user clicks NewArticleSubmitButton
Then message is displayed Article Created Successfully
And NewArticlePage title is MyNewArticle

Feature Keyword

• Defines the functionality the test targets
• Multiple scenarios can be created to cover this functionality

Feature: User can create an article

Feature: User can create an article

This feature will ensure a user can login and the product handles invalid credentials correctly

Feature: User can create an