xavierzwirtz

<?xml version="1.0" encoding="utf-8"?>
<!--
  For more information on how to configure your ASP.NET application, please visit
  https://go.microsoft.com/fwlink/?LinkId=301879
  -->  
<configuration> 
  <appSettings>
    <add key="webpages:Version" value="3.0.0.0" />
    <add key="webpages:Enabled" value="false" />
    <add key="ClientValidationEnabled" value="true" />

xavierzwirtz

create database SearchTest
GO
use SearchTest
GO

CREATE TABLE Content (
	ID UNIQUEIDENTIFIER NOT NULL DEFAULT newid()
	,Text NVARCHAR(MAX) NOT NULL
	,Text_Search NVARCHAR(MAX) NULL
	,CONSTRAINT PK_ID PRIMARY KEY (ID)

xavierzwirtz

Imports BirdDogSoftware.Interfaces
Imports BirdDogSoftware.Web
Imports System.Linq
Imports System.Collections.Generic

Namespace Events
    Public Class OrderEvents

        Public Shared Sub Line_Add(
                Order As IOrder,

xavierzwirtz

Imports BirdDogSoftware.Interfaces
Imports BirdDogSoftware.Web
Imports System.Linq
Imports System.Collections.Generic

Namespace Events
    Public Class OrderEvents

        Public Shared Sub Line_Add(
                Order As IOrder,

xavierzwirtz

omlPayCommission on SalesOrderLines

omdDeliveryType, omdCreatedDate on SalesOrderDeliveries.

xavierzwirtz

SELECT Field_Web_Site_Status, Field_Micro_site_needs_rebuild, Field_Web_Site_Status_Published, Field_Status
FROM BDUsers
WHERE (
		(
			(
				Field_Web_Site_Status = 'New'
				OR Field_Web_Site_Status IS NULL
				)
			AND (
				(Field_Micro_site_needs_rebuild = 'true' or Field_Micro_site_needs_rebuild is null)

xavierzwirtz

Keybase proof

I hereby claim:

• I am xavierzwirtz on github.
• I am xavierzwirtz (https://keybase.io/xavierzwirtz) on keybase.
• I have a public key ASBG94zUZpzLNbbw5IhWfFrsX-rKvi37_semCUcz2Ykmgwo

To claim this, I am signing this object:

xavierzwirtz

choco install cygwin -y
$cygPath = (Join-Path $Env:ChocolateyToolsLocation "cygwin\bin\");

$oldPath=(Get-ItemProperty -Path 'Registry::HKEY_LOCAL_MACHINE\System\CurrentControlSet\Control\Session Manager\Environment' -Name PATH).Path
if(-Not ($oldPath.Contains($cygPath))) {
  Write-Host "Adding cygwin to path"
  $newPath=$oldPath

  if(-Not ($oldPath.EndsWith(";"))) {
    $newPath=$newPath + ’;’

xavierzwirtz

update BDUsers set 
	  Field_Web_Site_Status = 'Publish Complete' 
	, Field_Company_Published = Company
	, Field_School_Art_Name_Published = Field_School_Art_Name
	, Field_ID_Number_Published = Field_ID_Number
	, Field_Mascot_Number_Published = Field_Mascot_Number
	, Field_Mascot_Name_Published = Field_Mascot_Name
	, Field_Team_Color_1_Published = Field_Team_Color_1
	, Field_Team_Color_2_Published = Field_Team_Color_2
where UserID = @schoolId

xavierzwirtz

--Creates an initial database for BirdDog Software's BDEngine database layout.
--Create a blank database in Microsoft SQL and then run this script against it.
--Before running find *DATABASENAME* and replace with your database name