Helper Class - Windows

Public Enum ActionType Add = 1

Modify Delete End Enum

Public Class Helper

Public Shared ReadOnly Property ConnectionString() As String Get

Return ConfigurationManager.ConnectionStrings("EmpDB").ToString() End Get

End Property End Class

DB Class

Imports System.Data

Imports System.Data.SqlClient Public Class EmpDB

Public Shared Function ManageEmp(ByVal trans As SqlTransaction, ByVal objEmp As Emp,

ByVal ActionType As ActionType) As Object Dim spName As String = "spManageEmp"

Dim pActionType As New SqlParameter("@ActionType", SqlDbType.TinyInt)

Dim pPKEmpId As SqlParameter = New SqlParameter("@PKEmpId", SqlDbType.BigInt) Dim pEmpName As SqlParameter = New SqlParameter("@EmpName", SqlDbType.VarChar, 50) Dim pEmpSalary As SqlParameter = New SqlParameter("@EmpSalary", SqlDbType.Money) Dim pDateOfBirth As SqlParameter = New SqlParameter("@DateOfBirth", SqlDbType.DateTime) Dim pIsActive As SqlParameter = New SqlParameter("@IsActive", SqlDbType.Bit)

If ActionType = ActionType.Add Then pActionType.Value = ActionType.Add

pPKEmpId.Direction = ParameterDirection.Output ElseIf ActionType = ActionType.Modify Then pActionType.Value = ActionType.Modify pPKEmpId.Value = objEmp.PKEmpId ElseIf ActionType = ActionType.Delete Then pActionType.Value = ActionType.Delete pPKEmpId.Value = objEmp.PKEmpId End If

If ActionType = ActionType.Add OrElse ActionType = ActionType.Modify Then pEmpName.Value = objEmp.EmpName

pEmpSalary.Value = objEmp.EmpSalary pDateOfBirth.Value = objEmp.DateOfBirth pIsActive.Value = objEmp.IsActive End If

Dim AffectedRows As Integer = 0 If trans Is Nothing Then

AffectedRows = SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure,

Deccansoft Software Services – MS.NET n-Tier Arch

spName, pActionType, pPKEmpId, pEmpName, pEmpSalary, pDateOfBirth, pIsActive) Else

AffectedRows = SqlHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure,

spName, pActionType, pPKEmpId, pEmpName, pEmpSalary, pDateOfBirth, pIsActive) End If

If ActionType = ActionType.Add Then Return CType(pPKEmpId.Value, Int64) Else

Return AffectedRows End If

End Function

Public Shared Function GetAllEmps(ByVal sortExpression As String) As DataSet Dim spName As String = "spGetAllEmps"

Dim psortExpression As New SqlParameter("@sortExpression", SqlDbType.VarChar, 260) Dim pPKID As New SqlParameter("@PKId", SqlDbType.BigInt)

psortExpression.Value = sortExpression

pPKID.Value = -1 'this is needed because we use that for GetByPKID

Return SqlHelper.ExecuteDataset(Helper.ConnectionString, CommandType.StoredProcedure,

spName, psortExpression, pPKID) End Function

Public Shared Function GetEmpByPKID(ByVal PKID As Int64) As Emp Dim spName As String = "spGetAllEmps"

Dim psortExpression As New SqlParameter("@sortExpression", SqlDbType.VarChar, 260) Dim pPKID As New SqlParameter("@PKID", SqlDbType.BigInt)

psortExpression.Value = ""

pPKID.Value = PKID

Dim drRow As SqlDataReader = SqlHelper.ExecuteReader(Helper.ConnectionString, CommandType.StoredProcedure, spName, psortExpression, pPKID) Dim objEmp As Emp = Nothing

If drRow.HasRows Then drRow.Read()

objEmp = New Emp(CType(drRow("PKEmpId"), Int64), CType(drRow("EmpName"), String),

CType(drRow("EmpSalary"), Decimal), CType(drRow("DateOfBirth"), Date), CType(drRow("IsActive"), Boolean)) End If

drRow.Close() Return objEmp End Function

Public Shared Function GetEmpCount() As Integer Dim spName As String = "spGetEmpCount"

Return CInt(SqlHelper.ExecuteScalar(Helper.ConnectionString, CommandType.StoredProcedure, spName)) End Function

Public Shared Sub DeleteEmpByPKIDs(ByVal PKIDs As String) Dim spName As String = "spDeleteEmpByPKIDs"

Dim pPKIDs As New SqlParameter("@PKIDs", SqlDbType.Text) pPKIDs.Value = PKIDs

SqlHelper.ExecuteNonQuery(Helper.ConnectionString, CommandType.StoredProcedure, spName, pPKIDs) End Sub

End Class

BO Class

Public Class EmpBO

Public Function InsertEmp(ByVal objEmp As Emp) As Integer

Deccansoft Software Services – MS.NET n-Tier Arch

Return EmpDB.ManageEmp(nothing, objEmp, ActionType.Add) End Function

Public Sub UpdateEmp(ByVal objEmp As Emp)

EmpDB.ManageEmp(nothing, objEmp, ActionType.Modify) End Sub

Public Sub DeleteEmp(ByVal objEmp As Emp)

EmpDB.ManageEmp(Nothing, objEmp, ActionType.Delete) End Sub

Public Function GetAllEmps(ByVal sortExpression As String) As DataSet return EmpDB.GetAllEmps(sortExpression)

End Function

Public Function GetEmpByPKID(ByVal PKID As Long) As Emp Dim objEmp As Emp = EmpDB.GetEmpByPKID(PKID) Return objEmp

End Function

Public Sub DeleteEmpByPKIDs(ByVal PKIDs As String) EmpDB.DeleteEmpByPKIDs(PKIDs)

End Sub End Class App.config

<add name="EmpDB" connectionString="server=.\sqlexpress;database=EmpDB;integrated security=true" />

</connectionStrings>

</configuration>

EmpForm

Private Sub BindDataToGrid() Dim ds As DataSet

Dim objEmpBo As New EmpBO ds = objEmpBo.GetAllEmps("") gvEmp.DataSource = ds gvEmp.DataMember = "Table"

End Sub

Private Sub EmpForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load gvEmp.SelectionMode = DataGridViewSelectionMode.FullRowSelect

gvEmp.AutoGenerateColumns = False gvEmp.ReadOnly = True

BindDataToGrid() End Sub

Private Sub btnNew_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNew.Click Dim dlgEmp As New EmpDialog

Deccansoft Software Services – MS.NET n-Tier Arch

If (dlgEmp.ShowDialog = Windows.Forms.DialogResult.OK) Then

Dim objEmp As New Emp(-1, dlgEmp.EmpName, dlgEmp.EmpSalary, dlgEmp.DateOfBirth, dlgEmp.IsActive) Dim objEmpBO As New EmpBO

objEmp.EmpId = objEmpBO.InsertEmp(objEmp) BindDataToGrid()

End If End Sub

Private Sub btnModify_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnModify.Click Dim empId As Integer

empId = CInt(gvEmp.SelectedRows(0).Cells(0).Value) Dim dlgEmp As New EmpDialog

Dim objEmpBO As New EmpBO

Dim objEmp As Emp = objEmpBO.GetEmpByPKID(empId) dlgEmp.EmpName = objEmp.EmpName

dlgEmp.EmpSalary = objEmp.EmpSalary dlgEmp.IsActive = objEmp.IsActive dlgEmp.DateOfBirth = objEmp.DateOfBirth

If (dlgEmp.ShowDialog = Windows.Forms.DialogResult.OK) Then objEmp.EmpName = dlgEmp.EmpName

objEmp.EmpSalary = dlgEmp.EmpSalary objEmp.IsActive = dlgEmp.IsActive objEmp.DateOfBirth = dlgEmp.DateOfBirth objEmpBO.UpdateEmp(objEmp)

BindDataToGrid() End If

End Sub

Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click Dim empId As Integer

empId = CInt(gvEmp.SelectedRows(0).Cells(0).Value) Dim objEmpBO As New EmpBO

objEmpBO.DeleteEmp(empId) BindDataToGrid()

End Sub EmpDialog

Public Property EmpName() As String Get

Return txtName.Text End Get

Set(ByVal value As String) txtName.Text = value End Set

End Property

Public Property EmpSalary() As Decimal Get

Return Decimal.Parse(txtSalary.Text) End Get

Set(ByVal value As Decimal) txtSalary.Text = value.ToString End Set

End Property

Public Property DateOfBirth() As Date Get

Return dtpDOB.Value End Get

Set(ByVal value As Date) dtpDOB.Value = value

Deccansoft Software Services – MS.NET n-Tier Arch

End Set End Property

Public Property IsActive() As Boolean Get

Return chkIsActive.Checked End Get

Set(ByVal value As Boolean) chkIsActive.Checked = value End Set

End Property

Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click 'Validate data in controls

Me.DialogResult = Windows.Forms.DialogResult.OK End Sub

Private Sub btnCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCancel.Click Me.DialogResult = Windows.Forms.DialogResult.Cancel

End Sub

Window3.xml

<Window xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation" xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"

x:Class="WPFApplication1.Window3" Title="Window3" Height="383" Width="423" Background="#cccccc">

<Window.Resources>

</LinearGradientBrush>

</LinearGradientBrush>

</Style>

</Style>

<Border.LayoutTransform>

</Border.LayoutTransform>

</Border>

</DataTemplate>

</Window.Resources>

<Grid.Resources>

<Style.Triggers>

<Setter.Value>

</Setter.Value>

</Setter>

</Trigger>

<TextBox.LayoutTransform>

</Grid.Resources>

<Grid.ColumnDefinitions>

</Grid.ColumnDefinitions>

<Grid.RowDefinitions>

</Grid.RowDefinitions>

<Border.LayoutTransform>

</Border.LayoutTransform>

</Border>

This is my First WPF Demo</TextBlock>

<ScrollViewer Grid.Row="1" VerticalAlignment="Top" HorizontalAlignment="Stretch" HorizontalScrollBarVisibility="Auto"

VerticalScrollBarVisibility="Auto" Margin="0,94,0,0">

</ScrollViewer>

<TextBlock Style="{StaticResource body}" Grid.Row="1" Grid.Column="1" >PlaceHolder for text</TextBlock>

<TabControl Grid.Row="1" Grid.Column="1" Margin="0,30,0,0" Name="tabControl1" Foreground="#FFFFFFFF"

BorderBrush="#FF00FFFF" BorderThickness="3,3,3,3" Background="{x:Null}">

<TabItem.Background>

</LinearGradientBrush>

</TabItem.Background>

<Grid>

<Grid.RowDefinitions>

</Grid.RowDefinitions>

</TextBox.LayoutTransform>

</TextBox>

<TextBox.LayoutTransform>

</TextBox.LayoutTransform>

</TextBox>

</StackPanel>

<Button x:Name="btnAdd" Click="Button_Click" Height="23" Grid.Row="1" VerticalAlignment="Top"

RenderTransformOrigin="0.524,3.768" Foreground="#FF54E407" Content="Add">

<Button.Background>

</LinearGradientBrush>

</Button.Background>

</Button>

<Button x:Name="btnSub" Click="Button_Click" VerticalAlignment="Top" Height="23" Margin="0,24,0,0" Grid.Row="1"

Content="Sub"/>

<Canvas RenderTransformOrigin="0.5,0.5" x:Name="MyButton" Canvas.Left="28" Canvas.Top="108" Background="#FF000000"

Margin="75.0824266355116,90.2766666666666,63.0824266355116,54.5833333333334" Grid.Row="1">

<Canvas.Triggers>

<DoubleAnimationUsingKeyFrames BeginTime="00:00:00" Storyboard.TargetName="MyButton"

Storyboard.TargetProperty="(UIElement.RenderTransform).(TransformGroup.Children)[2].(RotateTransform.Angle)">