Enterprise Framework

Change of Email on Github causes Mac Bash Permissions Connection Issue

If you change your email on Github it will cause your previously saved Github credentials on Mac to become invalid because it was cached in the Keychain Access.  When you try to connect to github, it thinks the password is valid and tries to use it for your Github access.  You'll need to delete it.

Solution:

Make sure to change your local git config global user.email

$ git config --global user.email "your.email@domain.com"

Just go to Keychain Access (Command + Space) and type Keychain Access.

Find the github.com name in the list where kind is Internet Password and delete it.  

From command again try connecting to Github and should prompt you for the updated password associated to the new email.

Angular 5 to 6 Upgrade Migration

Entity Framework Error:

Unable to resolve service for type 'Microsoft.EntityFrameworkCore.Migrations.IMigrator'. This is often because no database provider has been configured for this DbContext. A provider can be configured by overriding the DbContext.OnConfiguring method or by using AddDbContext on the application service provider. If AddDbContext is used, then also ensure that your DbContext type accepts a DbContextOptions<TContext> object in its constructor and passes it to the base constructor for DbContext.

Solution:

Verify the connectionstring in the appsettings.json file.

{
  "ConnectionStrings": {
    "CustomerDb":  "Server=(localdb)\\mssqllocaldb;Database=Customer;Trusted_Connection=True;"
  }
}

        // This method gets called by the runtime. Use this method to add services to the container.
        public void ConfigureServices(IServiceCollection services)
        {
            services.Configure<CookiePolicyOptions>(options =>
            {
                // This lambda determines whether user consent for non-essential cookies is needed for a given request.
                options.CheckConsentNeeded = context => true;
                options.MinimumSameSitePolicy = SameSiteMode.None;
            });

            services.AddDbContext<AppDbContext>(options => options.UseSqlServer(Configuration.GetConnectionString("CustomerDb")));

            services.AddMvc().SetCompatibilityVersion(CompatibilityVersion.Version_2_1);
        }

How To: Unobtrusive Javascript - Manually Add/Remove Required Rule and Message.  

<script type="text/javascript">
    $(function () {

        var addRequired = function () {
            // Manually add required fields to certain fields
            $('#scheduledLockDate').rules('add', {
                required: true,
                messages: {
                    required: "The Scheduled Lock Date is required"
                }
            });
            $('#scheduledDisposeDate').rules('add', {
                required: true,
                messages: {
                    required: "The Scheduled Dispose Date is required"
                }
            });
            $('#issueDate').rules('add', {
                required: true,
                messages: {
                    required: "The Issue Date is required"
                }
            });
        }

        // This will remove the manually required fields
        var removeRequired = function () {
            // Manually remove required fields to certain controls
            $('#scheduledLockDate').rules('remove', 'required');
            $('#scheduledDisposeDate').rules('remove', 'required');
            $('#issueDate').rules('remove', 'required');
        }

        // Handle the form submit method
        $('#workspaceForm').submit(function (e) {
            e.preventDefault();
            var form = this;

            // Trigger Form Validation
            var isValid = $('#workspaceForm').valid();

            if (!isValid) {
                // Exit out
                return false;
            }

            form.submit();
        });

        //Manually add the required fields
        addRequired();

        //Manually remvoe the required fields
        removeRequired();
    });
</script>

Goto:  https://console.developers.google.com/apis/dashboard

Choose your domain from the top navigation dropdown

Choose your domain from the top navigation dropdown

Not all these API are required, I just added few more for helpfulness

Enable the following:

• Maps Javascript API
• Maps Embed API
• Directions API
• Places API
• Geocoding API
• Geolocation API

https://github.com/loggly/log4net-loggly/#net-core-support

git reset HEAD^

MANS Stack (Mac, ASP.NET MVC, .NET Core, SQL Server 2017)

Valid as of April 18, 2018

https://www.microsoft.com/net/learn/get-started/macos

Download Visual Studio for Mac

https://www.visualstudio.com/vs/mac/

Download Docker for Mac

https://www.docker.com/docker-mac

Download SQL Server 2017 Ubuntu Docker Image

https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker

NOTE:  After you pull the SQL Server 2017 Docker Image.  Run it and accept the EULA.  Exit the SQL Server 2017 Image and commit the image

$ docker ps

CONTAINER ID        IMAGE                                      COMMAN                  CREATED             STATUS              PORTS                    NAMES
cb31a41d1f1b        microsoft/mssql-server-linux:2017-latest   "/opt/mssql/bin/sqls…"   2 hours ago         Up 2 hours          0.0.0.0:1401->1433/tcp   sql1

$ docker commit cb31a41d1f1b microsoft/mssql-server-linux:2017-latest

Running the docker image without commiting will show the error:

$ docker run microsoft/mssql-server-linux:2017-latest

The SQL Server End-User License Agreement (EULA) must be accepted before SQL

Server can start. The license terms for this product can be downloaded from

http://go.microsoft.com/fwlink/?LinkId=746388.



You can accept the EULA by specifying the --accept-eula command line option,

setting the ACCEPT_EULA environment variable, or using the mssql-conf tool.

Connection String Example:

Server=127.0.0.1,1401;Database=AppDb;User Id=sa;Password=P@ssw0rd;

GraphQL - Dice Example without the GraphQL schema language:

Using GraphQL schema language, you would use root and set it to the schema.

var express = require('express')
var graphqlHTTP = require('express-graphql')
var graphql = require('graphql')
const { GraphQLInt, GraphQLList, GraphQLObjectType, GraphQLString } = require('graphql')

class RandomDie {
  constructor (numSides) {
    this.numSides = numSides;
  }

  rollOnce () {
    return 1 + Math.floor(Math.random() * this.numSides);
  }

  roll ({numRolls}) {
    var output = [];
    for (var i = 0; i < numRolls; i++) {
      output.push(this.rollOnce())
    }
    return output
  }
}

// Define the Query type
var RandomDieType = new GraphQLObjectType({
  name: 'RandomDie',
  fields: {
    numSides: { type: GraphQLInt },
    rollOnce: { type: GraphQLInt },
    otherValue: { type: GraphQLString },
    roll: {
      type: new GraphQLList(graphql.GraphQLInt),
      args: {
        numRolls: { type: graphql.GraphQLInt }
      },
      resolve: function (_, {numRolls}, context) {
        // "_" represents the parent node in this case "getDie Type".  
        // It's the result of this.fields bound to the parent nodes
        // resolve data.
        // _ = {
        //   numSides: numSides,
        //   rollOnce: randomDie.rollOnce(),
        //   randomDie: randomDie
        // }
        console.log(_)
        console.log(`hello ${_.otherValue}`)
        var randomDie = new RandomDie(6)
        return randomDie.roll({
          numRolls: numRolls
        })
      }
    }
  }
})

var getDie = new graphql.GraphQLObjectType({
  name: 'Query',
  fields: {
    getDie: {
      type: RandomDieType,
      args: {
        numSides: { type: graphql.GraphQLInt }
      },
      resolve: function (_, {numSides}, context) {
        var randomDie = new RandomDie(numSides || 6)
        // THIS INFORMATION WILL BE PASSED TO "type: RandomDieType" RESOLVE
        // WITH THE FIELDS SET TO _
        return {
          numSides: numSides,
          rollOnce: randomDie.rollOnce(),
          randomDie: randomDie
        }
      }
    }
  }
})

var schema = new graphql.GraphQLSchema(
  {
    query: getDie
  }
)

var app = express()
app.use('/graphql', graphqlHTTP({
  schema: schema,
  rootValue: root,
  graphiql: true
}))
app.listen(4000)
console.log('Running a GraphQL API server at localhost:4000/graphql')

Request
{
  getDie(numSides: 6) {
    numSides
    rollOnce
    roll(numRolls: 3)
  }
}
Outputs
{
  "data": {
    "getDie": {
      "numSides": 6,
      "rollOnce": 3,
      "roll": [
        1,
        6,
        3
      ]
    }
  }
}