Skip to content

Instantly share code, notes, and snippets.

View xavierzwirtz's full-sized avatar

Xavier Zwirtz xavierzwirtz

  • BirdDog Software
  • Oklahoma City
View GitHub Profile
@xavierzwirtz
xavierzwirtz / gist:c9fdb25d048b92a8fb5c9cf6973ca0f8
Created January 28, 2020 23:40
SET deadlock_priority low
UPDATE bdtriggerauditiminvloc_sql
SET syncflag = 1
WHERE ( auditid IN ( '7caa0b66-c3ec-4e33-9706-71c98ed01a30',
'fd6d2c24-8eb2-4dde-9a47-71c9bbc7f9d6'
,
'9d693302-dad5-4f3d-a33e-71c9c28d4bc1'
,
'4f8567c3-054f-4f77-b4ad-71ca16a18d89'
@xavierzwirtz
xavierzwirtz / gist:8ad3ff131ec390c4270cbca002526b5f
Created January 27, 2020 01:38
success
these derivations will be built:
/nix/store/24lw3dnbif9p6r11mq5nk6z3rgr209cb-bulk-layers.drv
/nix/store/3lgbww299v2mka7p9by84yxdd341wwzx-nginx-config.json.drv
/nix/store/8xsaixzaafay1vrbiif69as8l69jyh9i-nginx-customisation-layer.drv
/nix/store/ycwgfi9bgpq0dnxx8fc7732h1gjz9r8x-closure.drv
/nix/store/vgcij363wdayqvxhh5d7g0db6p1qvvrc-closure-paths.drv
/nix/store/zlbpl3x8s1siq093g34li4f0cxrq8r8n-store-path-to-layer.sh.drv
/nix/store/rasm8f1pr0miss2w0v9p2gb29w5jcwra-nginx-granular-docker-layers.drv
/nix/store/98a62c975gx89jmpy3knx0z276yh036y-docker-image-nginx.tar.gz.drv
/nix/store/ppdf7hillsy84h2l2qb30q1in698lwss-kubenix-generated.json.drv
@xavierzwirtz
xavierzwirtz / gist:c9494c3eb4960cceafeee25f02d9ce6d
Created January 27, 2020 01:37
hung2
these derivations will be built:
/nix/store/24lw3dnbif9p6r11mq5nk6z3rgr209cb-bulk-layers.drv
/nix/store/3lgbww299v2mka7p9by84yxdd341wwzx-nginx-config.json.drv
/nix/store/8xsaixzaafay1vrbiif69as8l69jyh9i-nginx-customisation-layer.drv
/nix/store/ycwgfi9bgpq0dnxx8fc7732h1gjz9r8x-closure.drv
/nix/store/vgcij363wdayqvxhh5d7g0db6p1qvvrc-closure-paths.drv
/nix/store/zlbpl3x8s1siq093g34li4f0cxrq8r8n-store-path-to-layer.sh.drv
/nix/store/rasm8f1pr0miss2w0v9p2gb29w5jcwra-nginx-granular-docker-layers.drv
/nix/store/98a62c975gx89jmpy3knx0z276yh036y-docker-image-nginx.tar.gz.drv
/nix/store/ppdf7hillsy84h2l2qb30q1in698lwss-kubenix-generated.json.drv
@xavierzwirtz
xavierzwirtz / gist:04c47d8e89efea05265ba7d71e4e0dec
Created January 27, 2020 01:36
hung1
these derivations will be built:
/nix/store/24lw3dnbif9p6r11mq5nk6z3rgr209cb-bulk-layers.drv
/nix/store/3lgbww299v2mka7p9by84yxdd341wwzx-nginx-config.json.drv
/nix/store/8xsaixzaafay1vrbiif69as8l69jyh9i-nginx-customisation-layer.drv
/nix/store/ycwgfi9bgpq0dnxx8fc7732h1gjz9r8x-closure.drv
/nix/store/vgcij363wdayqvxhh5d7g0db6p1qvvrc-closure-paths.drv
/nix/store/zlbpl3x8s1siq093g34li4f0cxrq8r8n-store-path-to-layer.sh.drv
/nix/store/rasm8f1pr0miss2w0v9p2gb29w5jcwra-nginx-granular-docker-layers.drv
/nix/store/98a62c975gx89jmpy3knx0z276yh036y-docker-image-nginx.tar.gz.drv
/nix/store/ppdf7hillsy84h2l2qb30q1in698lwss-kubenix-generated.json.drv
@xavierzwirtz
xavierzwirtz / gist:0dca81bc6d38f45496a93176f23609b1
Created January 23, 2020 20:21
DECLARE @p0 NVARCHAR(20) = 'ItemAndItemLocations'
DECLARE @p1 NVARCHAR(2) = 't1'
DECLARE @p2 UNIQUEIDENTIFIER = 'a343151a-03e8-4d79-9c59-3ccbab4fe73d'
DECLARE @p3 NVARCHAR(20) = 'ItemAndItemLocations'
DECLARE @p4 NVARCHAR(3) = 'ct0'
DECLARE @p5 UNIQUEIDENTIFIER = 'a343151a-03e8-4d79-9c59-3ccbab4fe73d'
SELECT [t1].[data_item_no],
CASE
WHEN [t1].[audit_bd_version] IS NULL THEN 0x0000000000000000
@xavierzwirtz
xavierzwirtz / gist:a51ae572e3b2514e289d27811db120e9
Created January 15, 2020 20:35
Imports BirdDogSoftware.Interfaces
Namespace Events
Public Class MagentoEvents
Public Shared Function GetItemQtyOnHand(
Connection As MagentoConnector.Connection,
Connector As IConnectorAccount,
Item As IItem
) as Maybe(Of Double)
@xavierzwirtz
xavierzwirtz / gist:10772ad482bca9e493de14f674351fd9
Created January 13, 2020 21:38
Imports System
Imports System.Collections
Imports System.Collections.Generic
Imports BirdDogSoftware
Imports BirdDogSoftware.Utilities
Imports BirdDogSoftware.Utilities.Http
Imports BirdDogSoftware.Framework
Imports BirdDogSoftware.Interfaces
Imports Newtonsoft.Json.Linq
Imports Chessie.ErrorHandling.CSharp
@xavierzwirtz
xavierzwirtz / gist:3975e4a071696bbf72329c3abb74eb74
Created October 30, 2019 19:47
diff -r 7df128438c47 BirdDogFrameworkLayer/BirdDogSoftware.FrameWork/Connectors/Connectors/ServiceProConnector.vb
--- a/BirdDogFrameworkLayer/BirdDogSoftware.FrameWork/Connectors/Connectors/ServiceProConnector.vb Mon Oct 28 16:45:24 2019 -0500
+++ b/BirdDogFrameworkLayer/BirdDogSoftware.FrameWork/Connectors/Connectors/ServiceProConnector.vb Wed Oct 30 14:46:46 2019 -0500
@@ -2429,12 +2429,13 @@
ElseIf inspectionId.HasValue Then
Dim inspectionItemNo = lineData.Item("ItemNumber").ToObject(Of String)
- Return Tuple.Create(Choice.Choice2(Of Integer, String)(inspectionItemNo), IItem.ServiceProTypes.Inspection)
+ If ItemNoExists(inspectionItemNo) Then
+ Return Tuple.Create(Choice.Choice2(Of Integer, String)(inspectionItemNo), IItem.ServiceProTypes.Inspection)
@xavierzwirtz
xavierzwirtz / gist:347ca3b790ea29222f1882ecf8864c6e
Created October 28, 2019 21:29
$.post(
'https://acecontrols.leadmethod.com/submitLeads/5d9e4a1d7c2a4378a4f79f2e',
<% (New JObject() From {
{"Address", LastCart.Bill_To_Addr_1},
{"Address 2", LastCart.Bill_To_Addr_2},
{"City", LastCart.Bill_To_City},
{"State", LastCart.Bill_To_State},
{"Zip Code", LastCart.Bill_To_Zip},
{"Country", LastCart.Bill_To_Country},
{"Comments", LastCart.Ord_No},
@xavierzwirtz
xavierzwirtz / gist:9a5f621058bb6a45bb8c907150685ffa
Created September 19, 2019 02:06
<?xml version="1.0"?>
<appSettings>
<add key="ServiceProUrl" value="https://spxtest.net"/>
<add key="ServiceProAPIKey" value="{APIKey}"/>
<add key="ServiceProSK" value="{SK}">
<add key="ViewpointSqlServer" value="viewpointvista.birddogsw.local"/>
<add key="ViewpointSqlDatabase" value="ViewpointDev"/>
<add key="ViewpointSqlUser" value="sa"/>
<add key="ViewpointSqlPassword" value="vistapass"/>
<add key="ViewpointDefaultTaxCode" value="EXEMPT"/>