Skip to content

Instantly share code, notes, and snippets.

View BryanWilhite's full-sized avatar
😐

Bryan Wilhite BryanWilhite

😐
View GitHub Profile
@BryanWilhite
BryanWilhite / EFFirstOrDefault.sql
Created November 13, 2014 00:23
tSQL, EF: SQL from IQueryable<T>.FirstOrDefault()
SELECT
[Project5].[OrderStatusID] AS [OrderStatusID],
[Project5].[OrderId] AS [OrderId],
[Project5].[OrderNumber] AS [OrderNumber],
[Project5].[PONumber] AS [PONumber],
[Project5].[DepartmentName] AS [DepartmentName],
[Project5].[CustomerName] AS [CustomerName],
[Project5].[CreatedDt] AS [CreatedDt],
[Project5].[PriorityFl] AS [PriorityFl],
[Project5].[StatusDescription] AS [StatusDescription],
@BryanWilhite
BryanWilhite / TriggerSample.sql
Created November 13, 2014 00:24
tSQL: UPDATE Trigger Example
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ScTriggerLog]') AND type in (N'U'))
BEGIN
DROP TABLE [dbo].[ScTriggerLog]
END
GO
CREATE TABLE
[dbo].[ScTriggerLog]
(
[ScTriggerLogId] INT IDENTITY (1, 1) NOT NULL
@BryanWilhite
BryanWilhite / RiaPartialMethods.cs
Created November 13, 2014 00:25
C#: RIA Services, EF and Partial Methods
using System.ServiceModel.DomainServices.Client;
using GalaSoft.MvvmLight.Messaging;
namespace My.Entities
{
using My.Entities.Extensions;
using My.Silverlight.Models;
public sealed partial class MyEntity : Entity
{
@BryanWilhite
BryanWilhite / RadDataFormTextLookupField.cs
Created November 13, 2014 00:27
C#, Silverlight/Telerik: RadDataFormTextLookupField
using System.Windows.Controls;
using GalaSoft.MvvmLight.Messaging;
using Telerik.Windows.Controls;
namespace Fox.Xavier.Client.Views
{
using Fox.Silverlight.Models;
using Fox.Xavier.Client.Models;
public class RadDataFormTextLookupField : DataFormDataField
@BryanWilhite
BryanWilhite / RadGridViewEditCommandsColumn.cs
Last active August 29, 2015 14:09
C#: Silverlight/Telerik: RadGridViewEditCommandsColumn
using System;
using System.Windows;
using My.Client.Views.Administration;
using Telerik.Windows.Controls;
using Telerik.Windows.Controls.GridView;
namespace My.Client.Views
{
using My.Silverlight.Extensions;
@BryanWilhite
BryanWilhite / RadMultiSelectDropDownColumn.cs
Created November 13, 2014 00:30
C#, Silverlight/Telerik: RadMultiSelectDropDownColumn
using System.Windows;
using GalaSoft.MvvmLight.Messaging;
using Telerik.Windows.Controls;
using Telerik.Windows.Controls.GridView;
namespace Fox.Xavier.Client.Views
{
using Fox.Silverlight.Controls;
using Fox.Silverlight.Models;
@BryanWilhite
BryanWilhite / RadMultiSelectDropDownDataField.cs
Created November 13, 2014 00:57
C#, Silverlight/Telerik: RadMultiSelectDropDownDataField
using System;
using System.Windows.Controls;
using GalaSoft.MvvmLight.Messaging;
using Telerik.Windows.Controls;
namespace Fox.Xavier.Client.Views
{
using Fox.Silverlight.Controls;
using Fox.Silverlight.Models;
@BryanWilhite
BryanWilhite / MvvmLightMessagingForMultiSelectDropDown.cs
Last active August 29, 2015 14:09
C#, Silverlight/Telerik: Messaging for MultiSelectDropDown
class Sample
{
public Sample()
{
Messenger.Default.Register<LightMessage<LightContentForFrameworkElement<MultiSelectDropDown>>>(this,
message =>
{
if (!message.IsExpectedMessage(LightMessageSource.ViewAddedChildren, "UoMLookupDataField")) return;
var dropdown = message.Content.Element;
@BryanWilhite
BryanWilhite / RiaOperationForAdminUomDepartments.cs
Last active August 29, 2015 14:09
C#, Silverlight/Telerik: RiaOperationForAdminUomDepartments
class Sample
{
#region AdminUomDepartments:
void DoRiaOperationForAdminUomDepartments(ReadOnlyCollection<Entity> added,
ReadOnlyCollection<Entity> modified, ReadOnlyCollection<Entity> removed)
{
if (added.OfType<UOM>().Count() > 0)
{
this.DoRiaOperationForAdminUomDepartmentsAdded(added.OfType<UOM>());
@BryanWilhite
BryanWilhite / HandleUserRoleControl.cs
Last active August 29, 2015 14:09
C#, Silverlight/Telerik: HandleUserRoleControl
class Sample
{
void HandleUserRoleControl(LightMessage<LightContentForFrameworkElement<UserRoleControl>> message)
{
var control = message.Content.Element;
var data = message.Content.DataOfContext as SystemUser;
Action loadGridView = () =>
{
if (control.GridView.HasItems) control.GridView.Items.Clear();
var set = this._usersRoles.Where(i => i.UserId == data.UserId);