epswing fucked around with this message at 21:10 on Oct 5, 2010

epswing fucked around with this message at 15:07 on Oct 25, 2010

epswing fucked around with this message at 21:21 on Oct 26, 2010

<DataGrid Name="grdUsers" SelectionChanged="grdUsers_SelectionChanged">
	<DataGrid.Columns>
		<DataGridTextColumn Binding="{Binding Path=Username}" Header="Username" Width="*" />
		<DataGridTextColumn Binding="{Binding Path=Email}" Header="Email" />
	</DataGrid.Columns>
</DataGrid>
<StackPanel Name="editPanel">
	<TextBlock Text="Username" />
	<TextBox Name="txtUsername" Text="{Binding Path=Username}" />
	<TextBlock Text="Email" />
	<TextBox Name="txtEmail" Text="{Binding Path=Email}" />
</StackPanel>

private void grdUsers_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
	user = (User)e.AddedItems[0];
	editPanel.DataContext = user;
}

<DataGrid Name="grdUsers">
	<DataGrid.Columns>
		<DataGridTextColumn Binding="{Binding Path=Username}" Header="Username" Width="*" />
		<DataGridTextColumn Binding="{Binding Path=Email}" Header="Email" />
	</DataGrid.Columns>
</DataGrid>
<StackPanel Name="editPanel" DataContext="{Binding Path=SelectedValue, ElementName=grdUsers}">
	<TextBlock Text="Username" />
	<TextBox Name="txtUsername" Text="{Binding Path=Username}" />
	<TextBlock Text="Email" />
	<TextBox Name="txtEmail" Text="{Binding Path=Email}" />
</StackPanel>

epswing fucked around with this message at 22:08 on Nov 4, 2010

<TextBox Name="txtUsername"/>
<TextBox Name="txtEmail"/>

User user = GetUserFromSomewhere();
txtUsername = user.Username;
txtEmail = user.Email;

<StackPanel Name="panel">
  <TextBox Text="{Binding Path=Username}" />
  <TextBox Text="{Binding Path=Email}" />
</StackPanel>

User user = new User() { Username = "test", Email = "test@test.com" };
panel.DataContext = user;
user.Username = "hey I can see this";

epswing fucked around with this message at 17:25 on Nov 6, 2010

<Style x:Key="PropertyChangedStyle" TargetType="Button">
	<Style.Triggers>
		<DataTrigger Binding="{Binding Source=WhatGoesHere? Path=ThisIsDirty}" Value="True">
			<Setter Property="Background" Value="Red" />
		</DataTrigger>
	</Style.Triggers>
</Style>

<Button Style="{StaticResource PropertyChangedStyle}" ... />

epswing fucked around with this message at 21:06 on Nov 12, 2010

epswing fucked around with this message at 18:14 on Nov 15, 2010

public abstract class Rule
{
    public abstract bool Validate();
}

public class CustomRule : Rule
{
    // this is the function signature i need
    public delegate bool CustomRuleFunction(params object[] args);
    
    public CustomRuleFunction TheFunction { get; private set; }
    public object[] TheArgs { get; private set; }

    public CustomRule(CustomRuleFunction function, params object[] args)
    {
        TheFunction = function;
        TheArgs = args;
    }

    public override bool Validate()
    {
        return TheFunction(TheArgs);
    }
}

public void SaveUser()
{
    string somePassword = GetThePasswordFromSomeInput();
    
                         // function...     args...
    Rule r = new CustomRule(IsGoodPassword, somePassword);
    
    call r.Validate() somewhere here
}

// this matches the delegate above
private static bool IsGoodPassword(params object[] args)
{
    string candidatePassword = (string)args[0];
    
    if (the password is good enough by my standards) {
        return true;
    } else {
        return false;
    }
}

epswing fucked around with this message at 00:29 on Nov 16, 2010

public void SaveEmployee(Employee employee)
{
	using (var db = new DbDataContext())
	{
		employee.CheckValid();
		db.Employees.Attach(employee);
		db.Refresh(System.Data.Linq.RefreshMode.KeepChanges, employee);
		db.SubmitChanges();
	}
}

public List<Employee> GetAllEmployees()
{
	using (var db = new DbDataContext())
	{
		DataLoadOptions opts = new DataLoadOptions();
		opts.LoadWith<Employee>(x => x.Address);
		db.LoadOptions = opts;
		
		return (from x in db.Employee
				orderby x.Name
				select x).ToList();
	}
}

public EmployeeEditor(EmployeeService employeeService)
{
	Employees = new ObservableCollection<Employee>(employeeService.GetAllEmployees());
	DataContext = Employees;
	lstEmployees.ItemsSource = Employees; // a listbox
}

<TextBox Text="{Binding Path=Name}" />
<TextBox Text="{Binding Path=Address.Street}" />
<TextBox Text="{Binding Path=Address.City}" />

epswing fucked around with this message at 22:08 on Nov 18, 2010

epswing fucked around with this message at 16:47 on Nov 19, 2010

epswing fucked around with this message at 18:37 on Nov 19, 2010

epswing fucked around with this message at 04:22 on Nov 20, 2010

epswing fucked around with this message at 04:36 on Dec 3, 2010

using (var db = new DbDataContext())
{
	try
	{
		db.Connection.Open();
		db.Transaction = db.Connection.BeginTransaction(IsolationLevel.Serializable);
		
		using (var command = db.Connection.CreateCommand())
		{
			command.Transaction = db.Transaction;
			command.CommandText = File.ReadAllText("/path/to/file.sql");
			command.ExecuteNonQuery();
		}
		
		db.Transaction.Commit();
	}
	catch (Exception e)
	{
		db.Transaction.Rollback();
		throw e;
	}
	finally
	{
		db.Connection.Close();
	}
}

SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
IF EXISTS (SELECT * FROM tempdb..sysobjects WHERE id=OBJECT_ID('tempdb..#tmpErrors')) DROP TABLE #tmpErrors
GO
CREATE TABLE #tmpErrors (Error int)
GO
SET XACT_ABORT ON
GO
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
GO
BEGIN TRANSACTION
GO

PRINT N'Creating [dbo].[Plants]'
GO
CREATE TABLE [dbo].[Plants]
(
[Id] [int] NOT NULL IDENTITY(1, 1),
[AddressId] [int] NULL,
[Name] [varchar] (50) COLLATE Latin1_General_CI_AS NOT NULL
)
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating primary key [PK_Plants] on [dbo].[Plants]'
GO
ALTER TABLE [dbo].[Plants] ADD CONSTRAINT [PK_Plants] PRIMARY KEY CLUSTERED  ([Id])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO
PRINT N'Creating index [IX_PlantName] on [dbo].[Plants]'
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_PlantName] ON [dbo].[Plants] ([Name])
GO
IF @@ERROR<>0 AND @@TRANCOUNT>0 ROLLBACK TRANSACTION
GO
IF @@TRANCOUNT=0 BEGIN INSERT INTO #tmpErrors (Error) SELECT 1 BEGIN TRANSACTION END
GO

PRINT N'Creating [dbo].[Drivers]'
...

epswing fucked around with this message at 17:56 on Dec 17, 2010