WPF

private void ApplyTheme()
{
    ResourceDictionary resources = null;
    string fileName = string.Empty;

    switch (SelectedThemeName)
    {
        case "Black":
            fileName = "Theme_Black.xaml";
            break;

        case "Blue":
            fileName = "Theme_Blue.xaml";
            break;

    }

    if (fileName == string.Empty)
    {
        throw new Exception(string.Format("Resource dictionary for theme name {0} not found", SelectedThemeName));
    }

    fileName = "..\Themes\" + fileName;

    if (!File.Exists(fileName))
    {
        throw new Exception(string.Format("Theme name {0} not found", SelectedThemeName));
    }

    using (FileStream fs = new FileStream(fileName, FileMode.Open, FileAccess.Read))
    {
        resources = (ResourceDictionary)XamlReader.Load(fs);
    }
    Application.Current.Resources = resources;
}

<ListView x:Name="listviewReaders" ItemsSource="{Binding ReadersList, UpdateSourceTrigger=PropertyChanged,Mode=TwoWay}" SelectedItem="{Binding SelectedReader, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" Width="160" Margin="25,23,315,40">
       <ListView.ItemTemplate>
           <DataTemplate>
               <TextBlock Text="{Binding FullName}" />
           </DataTemplate>
       </ListView.ItemTemplate>
   </ListView>

    <Grid>
    <TextBox x:Name="txtBxFullName" HorizontalAlignment="Left" Height="23" Margin="25,27,0,0" TextWrapping="Wrap" Text="{Binding CurrentReader.FullName, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" VerticalAlignment="Top" Width="120"/>
    <TextBox x:Name="txtBxSerialNumber" HorizontalAlignment="Left" Height="23" Margin="25,55,0,0" TextWrapping="Wrap" Text="{Binding CurrentReader.SerialNumber, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" VerticalAlignment="Top" Width="120"/>
    <TextBox x:Name="txtBxIdNumber" HorizontalAlignment="Left" Height="23" Margin="25,83,0,0" TextWrapping="Wrap" Text="{Binding CurrentReader.IdNumber, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" VerticalAlignment="Top" Width="120"/>
    <TextBox x:Name="txtBxAdress" HorizontalAlignment="Left" Height="23" Margin="25,111,0,0" TextWrapping="Wrap" Text="{Binding CurrentReader.Adress, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" VerticalAlignment="Top" Width="120"/>
    <TextBox x:Name="txtBxAltContactMethods" HorizontalAlignment="Left" Height="23" Margin="25,139,0,0" TextWrapping="Wrap" Text="{Binding CurrentReader.AltContactMethods, Mode=TwoWay, UpdateSourceTrigger=PropertyChanged}" VerticalAlignment="Top" Width="120"/>
    <Button x:Name="btnAddReader" Command="{Binding AddR, UpdateSourceTrigger=PropertyChanged}" Content="Add" HorizontalAlignment="Left" Margin="25,177,0,0" VerticalAlignment="Top" Width="60"/>
    <Button x:Name="btnDeleteReader" Command="{Binding DeleteR, UpdateSourceTrigger=PropertyChanged}" Content="Delete" HorizontalAlignment="Left" Margin="155,177,0,0" VerticalAlignment="Top" Width="60"/>
    <Button x:Name="btnClearReader" Command="{Binding ClearR, UpdateSourceTrigger=PropertyChanged}" Content="Clear" HorizontalAlignment="Left" Margin="220,177,0,0" VerticalAlignment="Top" Width="60"/>
    <Button x:Name="btnEditReader" Command="{Binding EditR, UpdateSourceTrigger=PropertyChanged}" Content="Save" HorizontalAlignment="Left" Margin="90,177,0,0" VerticalAlignment="Top" Width="60"/>

</Grid>

public class HomeViewModel : ViewModelBase
{
    private Reader selectedReader;
    private Book selectedBook;
    private BookListFilter selectedFilter;


    private ObservableCollection<Book> bookList;
    private ObservableCollection<Reader> readerList;
    private IEnumerable<BookListFilter> bookLstItemSrc;

    public HomeViewModel(MainWindowViewModel _mwvm)
    {
        Mwvm = _mwvm;
        SelectedReader = new Reader();
        SelectedBook = new Book();
        SelectedFilter = BookListFilter.AllBooks;

        BookDBDataContext rdb = new BookDBDataContext();

        ReadersList = new ObservableCollection<Reader>(rdb.Readers);
        GetBookList();

        EditReaderSwitch = new DefCommand(EditReaderInfo);
        EditBookSwitch = new DefCommand(EditBookInfo);
    }

    public DefCommand EditReaderSwitch { get; private set; }
    public DefCommand EditBookSwitch { get; private set; }

    public MainWindowViewModel Mwvm { get; set; }

    //Reader List
    public ObservableCollection<Reader> ReadersList
    {
        get { return readerList; }
        set
        {
            if (readerList != value)
            {
                readerList = value;
                RaisePropertyChanged();
            }
        }
    }

public class ReaderManagingViewModel : ViewModelBase
{
    private static Reader currentReader;

    public ReaderManagingViewModel(HomeViewModel hvm)
    {
        if (CurrentReader == null)
            CurrentReader = new Reader();

        CurrentReader = hvm.SelectedReader;

        AddR = new DefCommand(AddReader);
        EditR = new DefCommand(UpdateReader);
        DeleteR = new DefCommand(DeleteReader);
        ClearR = new DefCommand(ClearReaderFields);
    }


    public Reader CurrentReader
    {
        get { return currentReader; }
        set
        {
            if (currentReader != value)
            {
                currentReader = value;
                RaisePropertyChanged();
            }
        }
    }

    public DefCommand AddR { get; private set; }
    public DefCommand EditR { get; private set; }
    public DefCommand DeleteR { get; private set; }
    public DefCommand ClearR { get; private set; }

    private void AddReader()
    {
        BookDBDataContext db = new BookDBDataContext();
        Reader rObj = new Reader();
        rObj.FullName = CurrentReader.FullName;
        rObj.SerialNumber = CurrentReader.SerialNumber;
        rObj.Id = CurrentReader.Id;
        rObj.Adress = CurrentReader.Adress;
        rObj.AltContactMethods = CurrentReader.AltContactMethods;


        try
        {
            db.Readers.InsertOnSubmit(rObj);
            db.Readers.Context.SubmitChanges();
        }
        catch (Exception e)
        {
            Console.WriteLine(e);
        }
        //Console.WriteLine("addingrrrr");
    }

    private void UpdateReader()
    {
        BookDBDataContext db = new BookDBDataContext();
        var qry = from reader in db.Readers
                  where reader.Id == CurrentReader.Id
                  select reader;
        foreach (Reader r in qry)
        {
            r.FullName = CurrentReader.FullName;
            r.SerialNumber = CurrentReader.SerialNumber;
            r.IdNumber = CurrentReader.IdNumber;
            r.Adress = CurrentReader.Adress;
            r.AltContactMethods = CurrentReader.AltContactMethods;
        }

        try
        {
            db.SubmitChanges();
        }
        catch (Exception e)
        {
            Console.WriteLine(e);
        }
        //Console.WriteLine("editinrrrrr");
    }

    private void DeleteReader()
    {
        BookDBDataContext db = new BookDBDataContext();
        var rbTbl = (from r in db.RentedBooks
                 where r.ReaderId == CurrentReader.Id
                 select r);
        var rTbl = (from r in db.Readers
                   where r.Id == CurrentReader.Id
                   select r).SingleOrDefault();
        try
        {
            foreach (var rbr in rbTbl)
            {
                db.RentedBooks.DeleteOnSubmit(rbr);
            }

            db.Readers.DeleteOnSubmit(rTbl);
            db.SubmitChanges();
        }
        catch(Exception e)
        {
            Console.WriteLine(e);
        }
        Console.WriteLine("deleting");
    }}

<UserControl.Resources>

<pre>
<ControlTemplate x:Key="myTemplate" 
                    TargetType="{x:Type ComboBox}">

    <Grid>

        <Popup x:Name="PART_Popup"
                IsOpen="{TemplateBinding IsDropDownOpen}">

            <Button Height="100"
                        Width="100"
                        Content="Hello"/>

        </Popup>

    </Grid>

</ControlTemplate>

<ComboBox Grid.Row="0" 
            Grid.Column="3"
            Background="Red"
            x:Name="comboBox"
            Width="150"
            Template="{Binding StringFormat=myTemplate}">

public enum SpanType
{
    Minutes,
    Hours,
    Days,
    Weeks,
    Months,
    Years
}

public static readonly DependencyProperty TimelineSpanTypeProperty =
            DependencyProperty.Register("TimelineSpanType",
            typeof(SpanType),
            typeof(TimeSpanTimeline),
            new PropertyMetadata(SpanType.Days, new PropertyChangedCallback(OnTimelineSpanTypeChanged)));

public SpanType TimelineSpanType
{
    get { return (SpanType)GetValue(TimelineSpanTypeProperty); }
    set { SetValue(TimelineSpanTypeProperty, value); }
}

private static void OnTimelineSpanTypeChanged(DependencyObject d, DependencyPropertyChangedEventArgs e)
{
    TimeSpanTimeline control = (TimeSpanTimeline)d;
    if (!control._internalControl)
    {
        control.DrawControl();
    }
}

<Window x:Class="Test_WpfGrid.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
        xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
        xmlns:local="clr-namespace:Test_WpfGrid"
        Title="MainWindow" Height="350" Width="525">
    <Window.Resources>
        <local:CBrushConverter x:Key="BrushConverter"/>
    </Window.Resources>
    <Grid>
        <DataGrid x:Name="grdPeople" Margin="5,5,5,5" AutoGenerateColumns="False" SelectionMode="Single" SelectionUnit="FullRow">
            <DataGrid.Columns>
                <DataGridTextColumn Width="150"  Binding="{Binding FName}" Header="First Name">
                    <DataGridTextColumn.ElementStyle>
                        <Style TargetType="{x:Type TextBlock}">
                            <Setter Property="Background" Value="{Binding Age, Converter={StaticResource BrushConverter}}" />
                        </Style>
                    </DataGridTextColumn.ElementStyle>
                </DataGridTextColumn>
                <DataGridTextColumn Width="150"  Binding="{Binding LName}" Header="Last Name">
                    <DataGridTextColumn.ElementStyle>
                        <Style TargetType="{x:Type TextBlock}">
                            <Setter Property="Background" Value="{Binding Age, Converter={StaticResource BrushConverter}}" />
                        </Style>
                    </DataGridTextColumn.ElementStyle>
                </DataGridTextColumn>
                <DataGridTextColumn Width="50"  Binding="{Binding Age}" Header="Age" />
                <DataGridTextColumn Width="50"  Binding="{Binding DisplState}" Header="State" />
            </DataGrid.Columns>
        </DataGrid>
    </Grid>
</Window>

namespace Test_WpfGrid
{
    public partial class MainWindow : Window
    {
        public MainWindow()
        {
            InitializeComponent();
            List<CPerson> People = new List<CPerson>();
            People.Add(new CPerson("John",  "Doe",   25, 2));
            People.Add(new CPerson("Jane",  "Doe",   52, 4));
            People.Add(new CPerson("Jenny", "Doe",   14, 0));
            People.Add(new CPerson("Sammy", "Doe",   24, 3));
            People.Add(new CPerson("Paul",  "Smith", 10, 3));
            grdPeople.ItemsSource = People;
        }
    }
}

namespace Test_WpfGrid
{
    public class CPerson
    {
        public string FName { get; set; }
        public string LName { get; set; }
        public int Age { get; set; }
        public int State { get; set; }

        public string DisplState
        {
            get { return (this.State > 0) ? this.State.ToString() : "undef"; }
        }

        public CPerson(string FName, string LName, int Age, int State)
        {
            this.FName = FName;
            this.LName = LName;
            this.Age = Age;
            this.State = State;
        }
    }
}

namespace Test_WpfGrid
{
    public class CBrushConverter : IValueConverter
    {
        private Color[] mBGColors = { Color.FromArgb(255, 224, 224, 224),   // grey
                                      Color.FromArgb(255, 255, 155, 155),   // red
                                      Color.FromArgb(255, 200, 240, 200)    // green
                                    };

        public object Convert(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            int Age = (int)value;
            System.Windows.Media.Brush Brush = new SolidColorBrush(this.mBGColors[(Age >= 18) ? 2 : ((Age >= 12) ? 1 : 0)]);
            return Brush;
        }

        public object ConvertBack(object value, Type targetType, object parameter, System.Globalization.CultureInfo culture)
        {
            throw new NotSupportedException();
        }
    }
}

<pre>namespace MBM3._0
{
    public partial class MainWindow : Window
    {                
        //StockValues _StockContext = new StockValues();
        StockValues src = new StockValues();

        public MainWindow()
        {
            InitializeComponent();
            Loaded += MainWindow_Loaded;
            this.DataContext = src;
        }

        public void MainWindow_Loaded(object sender, RoutedEventArgs e)
        {                                            
            textBoxStockSymbol.Text = "AEA";
            textBoxDateFrom.Text = "2000-01-03";
            textBoxDateTo.Text = "2010-02-08";
            textBoxSPOpenFrom.Text = "0";
            textBoxSPOpenTo.Text = "50";
            textBoxSPCloseFrom.Text = "50";
            textBoxSPCloseTo.Text = "50";
            textBoxSPACloseFrom.Text = "50";
            textBoxSPACTo.Text = "50";
            textBoxSPHighFrom.Text = "50";
            textBoxSPHighTo.Text = "50";
            textBoxSPLowFrom.Text = "50";
            textBoxSPLowTo.Text = "50";
            textBoxSVolumeFrom.Text = "50";
            textBoxSVolumeTo.Text = "50";                                           
        }

        private void dataGrid_Loaded(object sender, RoutedEventArgs e)
        {  

        }

        private void buttonFind_Click(object sender, RoutedEventArgs e)
        {
            try
            {                
                DataTable MSQ = DataLayer.Stock.MSQ("WPFDemo App");
                dataGrid.ItemsSource = MSQ.DefaultView;
            }
            catch (SqlException sqlex)
            {
                MessageBox.Show("Error: " + sqlex.Message, "Exception Sample", MessageBoxButton.OK, MessageBoxImage.Warning);
            }
        }

        private void textBoxStockSymbol_TextChanged(object sender, TextChangedEventArgs e)
        {

        }
    }
}

<pre>namespace DataLayer
{
    public class Stock
    {
        /// <summary>
        /// Returns query to datatable, which can be loaded into Datagrid.
        /// </summary>
        /// <param name="appName"></param>
        /// <returns></returns>
        public static DataTable MSQ(string appName)
        {
            DataTable table1 = new DataTable();
            SqlDataAdapter da1 = new SqlDataAdapter();
            StockValues sv = new StockValues();

            using (SqlConnection conn = Database.GetSqlConnection())
            {
                //using (SqlCommand cmd = conn.CreateCommand())
                //{
                SqlCommand cmd = new SqlCommand("SELECT date, stock_symbol, stock_price_open, stock_price_close, stock_price_lo, stock_price_high, stock_price_adj_close, stock_volume FROM NYSE WHERE date BETWEEN @date_from AND @date_to AND stock_symbol LIKE @stock_symbol AND stock_price_open BETWEEN @stock_price_open_from AND @stock_price_open_to AND stock_price_close BETWEEN @stock_price_close_from AND @stock_price_adj_close_to AND stock_price_lo BETWEEN @stock_price_lo_from AND @stock_price_lo_to AND stock_price_high BETWEEN @stock_price_high_from AND @stock_price_high_to AND stock_price_adj_close BETWEEN @stock_price_adj_close_from AND @stock_price_adj_close_to AND stock_volume BETWEEN @stock_volume_from AND @stock_volume_to", conn);
                cmd.Parameters.Add(new SqlParameter("date_from", System.Data.SqlDbType.Date));
                cmd.Parameters.Add(new SqlParameter("date_to", System.Data.SqlDbType.Date));
                cmd.Parameters.Add(new SqlParameter("stock_symbol", System.Data.SqlDbType.VarChar));
                cmd.Parameters.Add(new SqlParameter("stock_price_open_from", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_price_open_to", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_price_close_from", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_price_close_to", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_price_lo_from", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_price_lo_to", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_price_high_from", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_price_high_to", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_price_adj_close_from", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_price_adj_close_to", System.Data.SqlDbType.Float));
                cmd.Parameters.Add(new SqlParameter("stock_volume_from", System.Data.SqlDbType.Int));
                cmd.Parameters.Add(new SqlParameter("stock_volume_to", System.Data.SqlDbType.Int));
                cmd.Parameters["date_from"].Value = "2000-01-03";
                cmd.Parameters["date_to"].Value = "2010-02-08";
                cmd.Parameters["stock_symbol"].Value = "%";
                cmd.Parameters["stock_price_open_from"].Value = "50";
                cmd.Parameters["stock_price_open_to"].Value = "50";
                cmd.Parameters["stock_price_close_from"].Value = "0";
                cmd.Parameters["stock_price_close_to"].Value = "500";
                cmd.Parameters["stock_price_lo_from"].Value = "0";
                cmd.Parameters["stock_price_lo_to"].Value = "500";
                cmd.Parameters["stock_price_high_from"].Value = "0";
                cmd.Parameters["stock_price_high_to"].Value = "500";
                cmd.Parameters["stock_price_adj_close_from"].Value = "0";
                cmd.Parameters["stock_price_adj_close_to"].Value = "500";
                cmd.Parameters["stock_volume_from"].Value = "0";
                cmd.Parameters["stock_volume_to"].Value = "1000000000";
                
                //SqlCommand cmd = new SqlCommand("EXEC MasterStockQuery1 @date_from, @,'%',50,50,0,500,0,500,0,500,0,500,0,1000000000", conn);
                
                //cmd.CommandText = @"MasterStockQuery1";
                //cmd.CommandType = System.Data.CommandType.StoredProcedure;
                //SqlParameter p1 = new SqlParameter("@date_from", SqlDbType.Date);
                //p1.Value = date_from;
                //cmd.Parameters.Add(p1);
                //SqlParameter p2 = new SqlParameter("@date_to", SqlDbType.Date);
                //p2.Value = sv.date_to;
                //cmd.Parameters.Add(p2);
                //SqlParameter p3 = new SqlParameter("@stock_symbol", SqlDbType.VarChar);
                //p3.Value = sv.stock_symbol;
                //cmd.Parameters.Add(p3);
                //SqlParameter p4 = new SqlParameter("@stock_price_open_from", SqlDbType.Float);
                //p4.Value = sv.stock_price_open_from;
                //cmd.Parameters.Add(p4);
                //SqlParameter p5 = new SqlParameter("@stock_price_open_to", SqlDbType.Float);
                //p5.Value = sv.stock_price_open_to;
                //cmd.Parameters.Add(p5);
                //SqlParameter p6 = new SqlParameter("@stock_price_close_from", SqlDbType.Float);
                //p6.Value = sv.stock_price_close_from;
                //cmd.Parameters.Add(p6);
                //SqlParameter p7 = new SqlParameter("@stock_price_close_to", SqlDbType.Float);
                //p7.Value = sv.stock_price_close_to;
                //cmd.Parameters.Add(p7);
                //SqlParameter p8 = new SqlParameter("@stock_price_lo_from", SqlDbType.Float);
                //p8.Value = sv.stock_price_lo_from;
                //cmd.Parameters.Add(p8);
                //SqlParameter p9 = new SqlParameter("@stock_price_lo_to", SqlDbType.Float);
                //p9.Value = sv.stock_price_lo_to;
                //cmd.Parameters.Add(p9);
                //SqlParameter p10 = new SqlParameter("@stock_price_high_from", SqlDbType.Float);
                //p10.Value = sv.stock_price_high_from;
                //cmd.Parameters.Add(p10);
                //SqlParameter p11 = new SqlParameter("@stock_price_high_to", SqlDbType.Float);
                //p11.Value = sv.stock_price_high_to;
                //cmd.Parameters.Add(p11);
                //SqlParameter p12 = new SqlParameter("@stock_price_adj_close_from", SqlDbType.Float);
                //p12.Value = sv.stock_price_adj_close_from;
                //cmd.Parameters.Add(p12);
                //SqlParameter p13 = new SqlParameter("@stock_price_adj_close_to", SqlDbType.Float);
                //p13.Value = sv.stock_price_adj_close_to;
                //cmd.Parameters.Add(p13);
                //SqlParameter p14 = new SqlParameter("@stock_volume_from", SqlDbType.Int);
                //p14.Value = sv.stock_volume_from;
                //cmd.Parameters.Add(p14);
                //SqlParameter p15 = new SqlParameter("@stock_volume_to", SqlDbType.Int);
                //p15.Value = sv.stock_volume_to;
                //cmd.Parameters.Add(p15);

                da1 = new SqlDataAdapter(cmd);
                    
                    da1.Fill(table1);
                    //}
                }
                return table1;
            }
        }
        
}

public class StockValues
{
    public DateTime date_from { get; set; }
    public DateTime date_to { get; set; }
    public string stock_symbol { get; set; }
    public float stock_price_open_from { get; set; }
    public float stock_price_open_to { get; set; }
    public float stock_price_close_from { get; set; }
    public float stock_price_close_to { get; set; }
    public float stock_price_lo_from { get; set; }
    public float stock_price_lo_to { get; set; }
    public float stock_price_high_from { get; set; }
    public float stock_price_high_to { get; set; }
    public float stock_price_adj_close_from { get; set; }
    public float stock_price_adj_close_to { get; set; }
    public int stock_volume_from { get; set; }
    public int stock_volume_to { get; set; }
}