Skip to content

Instantly share code, notes, and snippets.

Avatar

Brent Maxwell brentmaxwell

View GitHub Profile
@brentmaxwell
brentmaxwell / UnixTimeExtensions.cs
Created Mar 17, 2015
Extensions to convert Unix time to DateTime
View UnixTimeExtensions.cs
namespace System
{
public static class UnixTimeExtensions
{
public static long ToUnixTime(this DateTime datetime)
{
return (long)(datetime.ToUniversalTime() - new DateTime(1970, 1, 1, 0, 0, 0)).TotalSeconds;
}
public static DateTime FromUnixTime(long time)
@brentmaxwell
brentmaxwell / rowcounts.sql
Created Mar 17, 2015
Get *approximate* row counts of all tables in a db
View rowcounts.sql
SELECT
[TableName] = so.name,
[RowCount] = MAX(si.ROWS)
FROM
sysobjects so,
sysindexes si
WHERE
so.xtype = 'U' AND
si.id = OBJECT_ID(so.name)
GROUP BY so.name ORDER BY so.name
@brentmaxwell
brentmaxwell / AutoMapperConfig.cs
Last active Dec 6, 2017
Put automapper configs in model classes NOTE THIS DOES NOT WORK WITH THE LATEST VERSION OF AUTOMAPPER
View AutoMapperConfig.cs
public class AutoMapperConfig
{
/// <summary>
/// Function that is called in the Global.asax file
/// Runs through and calls each of the functions below, registering the various mappings
/// </summary>
public static void Execute()
{
RegisterOtherMaps();
RegisterMapperHelpers();
@brentmaxwell
brentmaxwell / DelimitedStringToTable.sql
Last active Apr 5, 2017
Delimited string to table
View DelimitedStringToTable.sql
CREATE FUNCTION [dbo].[DelimitedStringToTable]
(
        @String nvarchar(MAX),
        @Delimiter nvarchar(1)
)
RETURNS @Items TABLE
(
        Item nvarchar(50)
)
AS
@brentmaxwell
brentmaxwell / BinaryIPfunctions.sql
Created Mar 30, 2015
IP Address conversions in SQL
View BinaryIPfunctions.sql
CREATE FUNCTION [StringIpToBin]
(
@StringIp VARCHAR(15)
)
RETURNS BINARY(4)
AS
BEGIN
RETURN
CAST(CAST(PARSENAME(@StringIp,4) AS INT) AS BINARY(1)) +
CAST(CAST(PARSENAME(@StringIp,3) AS INT) AS BINARY(1)) +
View GpsTimeExtensions.cs
namespace System
{
public static class GpsTime
{
public static int ToGpsTimeWeekNumber(this DateTime datetime)
{
DateTime datum = new DateTime(1980, 1, 6, 0, 0, 0);
TimeSpan difference = datetime.Subtract(datum);
return (int)(difference.TotalDays / 7);
}
View keybase.md

Keybase proof

I hereby claim:

  • I am brentmaxwell on github.
  • I am brentmaxwell (https://keybase.io/brentmaxwell) on keybase.
  • I have a public key whose fingerprint is 48FC FD01 403C F2AD 5B24 2924 755D 8989 5912 D6FA

To claim this, I am signing this object:

@brentmaxwell
brentmaxwell / public-key
Last active Aug 29, 2015
OpenPGP Public Key
View public-key
-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: GnuPG v2
mQENBFV1z94BCACsc/WQ3v4OQK2zcTIS1751Pixtlielg8hafGUmu3RPYzB0Qrnu
109TQrfO4Sx+fi9Q4iLzzKbPJ83myaDRCxd0zng6pVbPMSX44fzzgLdQpE7esut6
ptEJtCGPqMoaLuJ5xieG8YmmERJ1lQjk6LWWat7b/wfM7E6NqDBH8YoG5Mb5kDdG
qF55p5/2L07f/7G4M28rLJLBCe4/6q/tjAUzuEVyJO/M0X3cb3bBmySOokHHhfpf
ls5ZgeJjuLAjzPImGDxLDLwBDpcEt4h8XHc65Ir17POV/gu7VSqjn4XuuOVdGed5
Abg0caqgL9u3TzIJur/SkO3fEXMDqDRZ0T0dABEBAAGJATcEHwEKACEFAlV3IZwX
DIABw1qv3cOYCyUeXa9P0c6JaoQB3tICBwAACgkQdV2JiVkS1vrqPwgAn6mD9UrN
@brentmaxwell
brentmaxwell / aprs.php
Created Sep 16, 2015
Simple PHP page to post to APRS-IS
View aprs.php
<?php
$aprs_php_ver = "0.1";
$aprs_is_url = "http://srvr.aprs-is.net:8080";
date_default_timezone_set('UTC');
$defaultSSID = "10";
$defaultPath = "APRS,WIDE2-2,TCPIP*";
if($_SERVER["REQUEST_METHOD"] == "POST")
{
View ObjectDumper.cs
using System;
using System.Collections;
using System.Collections.Generic;
using System.Reflection;
using System.Text;
public class ObjectDumper
{
private int _level;
private readonly int _indentSize;
You can’t perform that action at this time.