Displaying popup in WPF

      A Popup window is a window that float over a window.In this blog post i’m going to to explain how can we create a sexy popup window like message box using xaml.Wpf has a popup control

Syntax

<Popup></Popup>

      Popup control can have a child inside the popup tags.If we want to add more contents we can use any layout panels like grid, stackpanel etc.
In popup if we set IsOpen property to true then the popup will be displayed and If IsOpen = false then the popup will be closed. In this example we will set IsOpen = true whenever we click on validate button and we will set it to false when we clicked on OK button.

xaml

<Popup Name="myPopup" IsOpen="False" PlacementTarget="{Binding ElementName=ProjectTasks}" Placement="Center">
      <Grid Width="300" Background="Gray">
          <Grid.RowDefinitions>
              <RowDefinition Height="Auto"/>
              <RowDefinition Height="*"/>
              <RowDefinition Height="Auto"/>
         </Grid.RowDefinitions>
      <Border Grid.RowSpan="3" Background="Gray" BorderBrush="#3a3a3a" BorderThickness="1"/>
            <DockPanel  Width="300" Background="#3a3a3a" LastChildFill="True">
                <Image Source="/Images/Icons/attention.png" Width="15" Height="15" Margin="3"  DockPanel.Dock="Left"/>
<TextBlock  Padding="3" Grid.Row="0" Background="#3a3a3a" Text="Information" Foreground="White" FontWeight="Bold"/>
                </DockPanel>
              <TextBlock Width="260" Grid.Row="1" Margin="5" TextWrapping="Wrap" Foreground="white" Text="{Binding Path=ProjectValidateMessage}"></TextBlock>     

<Button Width="40" Height="20" Margin="5" Grid.Row="2" x:Name="btnPopup" Click="btnPopup_OnClick" Content="Ok" />
                        
      </Grid>
</Popup>

Code Behind:

public void btnPopup_OnClick(object Sender, RoutedEventArgs e)          

{             

    this.myPopup.IsOpen = false;         

}         

public void btnValidate_OnClick(object Sender,RoutedEventArgs e)

{             

    this.myPopup.IsOpen = true;         

}

Find current financial and Calendar Year in SQL Server

declare @d datetime
      set @d = GETDATE()
select
        DATEADD(yyyy, DATEDIFF(yyyy, 0, @d), 0) as [CalendarYear]
select
case
       when DATEPART(M, @d) >= 4 then DATEADD(mm, 3, DATEADD(yyyy, DATEDIFF(yyyy, 0, @d), 0))
        when DATEPART(M, @d) < 4 then DATEADD(mm, -9, DATEADD(yyyy, DATEDIFF(yyyy, 0, @d), 0))
end as [FinancialYear]

How to append a text field to an existing column in SQL Server

update table set fieldName = 'append string'+ fieldName where conditions

Example:

select *from AM_Invoice where DocumentTypeId = 3 and SalesInvoiceType = 2
update AM_Invoice set InvoiceNumber = 'B/'+InvoiceNumber where DocumentTypeId = 3 and SalesInvoiceType = 2
select *from AM_Invoice where DocumentTypeId = 3 and SalesInvoiceType = 2

result:

Samsung reveals Galaxy SIII

Samsung reveals their most awaited android phone Galaxy SIII in an event held at London

Knockout

                        
          In these recent days I've been started learning Knockout. Knockout is a simple light weight java script library which helps us to create a rich user interface  web applications using MVVM patterns.
Knockout has a rich documentation and Live examples.you can get more from knockoutjs.com

Headline features:

• Elegant dependency tracking - automatically updates the right parts of your UI whenever your data model changes.
• Declarative bindings - a simple and obvious way to connect parts of your UI to your data model. You can construct a complex dynamic UIs easily using arbitrarily nested binding contexts.
• Trivially extensible - implement custom behaviors as new declarative bindings for easy reuse in just a few lines of code.

Additional benefits:

• Pure JavaScript library - works with any server or client-side technology
• Can be added on top of your existing web application without requiring major architectural changes
• Compact - around 13kb after gzipping
• Works on any mainstream browser (IE 6+, Firefox 2+, Chrome, Safari, others)
• Comprehensive suite of specifications (developed BDD-style) means its correct functioning can easily be verified on new browsers and platforms.

In this blog post i'm going to share the use full tutorials and blog links to learn knockout

    knockout documentation : http://knockoutjs.com/documentation/introduction.html

    Live tutorial :  http://learn.knockoutjs.com/

    Examples : http://knockoutjs.com/examples/

    my jsfiddle samples : http://jsfiddle.net/rgopal_p/QUrQ7/

link list will updated... :)