ChrisMoney

--///////////////////////////////////////////////
-- TRIAGE
--/////////////////////////////////////////////

-- Check table sizes
SELECT t.name AS TableName, SUM(p.rows) AS RowCounts
FROM sys.tables AS t
INNER JOIN sys.partitions AS p ON t.object_id = p.object_id
WHERE p.index_id IN (0,1) -- Heap or Clustered Index
GROUP BY t.name

ChrisMoney

MVC-Razor AJAX

// AJAX calls .NET MVC Core Controller
// Stores success message and fetches it to display once page is updated

    function confirmTransferAction(event) {
        // console.log("@Url.Action("UpdateAccountEmail", "CustomerProfiles")");

        var id = document.getElementById('adminId').value;
        var email = document.getElementById('newEmail').value;

ChrisMoney

USE [Database_Name] GO --
 Check if the procedure exists before renaming 
IF OBJECT_ID('dbo.AdminReportsStaples', 'P') IS NOT NULL 
BEGIN 
EXEC sp_rename 'dbo.AdminReportsStaples', 'AdminReportsRevenue' 
END 
ELSE 
BEGIN 
PRINT 'Procedure dbo.AdminReportsStaples does not exist.' 
END 

ChrisMoney

// 1) 'ref'

// ref keyword means "pass by reference" - edits
// made in this function affect the actual variable
int someNum = 5;
AddOne(ref someNum);
// someNum now = 6

void AddOne(ref int i)
{

ChrisMoney

Save the username and password globally:

git config --global user.name "fname lname"
git config --global user.email "[email protected]"
git config --global user.password "secret"
Get a specific setting,

git config --global --get user.name
git config --global --get user.email
git config --global --get user.password

ChrisMoney

using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Diagnostics;
using AdamsTaxAPI.Data;
using AdamsTaxAPI.Data.MagentoServiceCalls;
using AdamsTaxAPI.Models;
using AdamsTaxAPI.Controllers;
using Azure.Identity;
using Azure.Security.KeyVault.Secrets;
using Aczure.Extensions.AspNetCore.Configuration.Secrets;
using Reni.SshNet.Sftp;

ChrisMoney

var dapperParams = new List<KeyValuePair<object, object>>() { 
    new KeyValuePair<string, string>("FirstName", "Chris"),
    new KeyValuePair<string, string>("LastName", "Money"),
    new KeyValuePair<string, string>("Phone", "314-555-1212"),
    new KeyValuePair<string, string>("SSN", "123-45-6789"),
    new KeyValuePair<string, int>("Age", 21)
};

connection.Query<Person>(query, new {dapperParams});

ChrisMoney

UI: UI files driven by Factory methods

Helper: Wrapper methods that handle misc. functions

API: API calls envoked at the factory level

Factory/Business: Handles SQL Connections, santizes data before handing off to DAO

DAO: Handles requests to data warehouse and returns objects

ChrisMoney

(string, string, string) LookupName(long id) // tuple return type
{
    ... // retrieve first, middle and last from data storage
    return (first, middle, last); // tuple literal
}

ChrisMoney

var xhr = new XMLHttpRequest;

    xhr.open("GET", url);
    xhr.send();

// ********************************
// Return Json object from server
// ********************************
var id = 1;
var req = new XMLHttpRequest();