timesheet.vb

Beginning VB.NET DatabasesAll_Code.rar

Public Class TimeSheet
    Inherits System.Windows.Forms.Form

#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()

        'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    Friend WithEvents MainMenu1 As System.Windows.Forms.MainMenu
    Friend WithEvents MenuItem1 As System.Windows.Forms.MenuItem
    Friend WithEvents mnuFileNew As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem2 As System.Windows.Forms.MenuItem
    Friend WithEvents mnuFileExit As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem3 As System.Windows.Forms.MenuItem
    Friend WithEvents mnuEditUndo As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem4 As System.Windows.Forms.MenuItem
    Friend WithEvents mnuEditCut As System.Windows.Forms.MenuItem
    Friend WithEvents mnuEditCopy As System.Windows.Forms.MenuItem
    Friend WithEvents mnuEditPaste As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem6 As System.Windows.Forms.MenuItem
    Friend WithEvents mnuEditSelectAll As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem5 As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem8 As System.Windows.Forms.MenuItem
    Friend WithEvents mnuHelpAbout As System.Windows.Forms.MenuItem
    Friend WithEvents ToolBar1 As System.Windows.Forms.ToolBar
    Friend WithEvents btnNew As System.Windows.Forms.ToolBarButton
    Friend WithEvents ToolBarButton1 As System.Windows.Forms.ToolBarButton
    Friend WithEvents btnCut As System.Windows.Forms.ToolBarButton
    Friend WithEvents btnCopy As System.Windows.Forms.ToolBarButton
    Friend WithEvents btnPaste As System.Windows.Forms.ToolBarButton
    Friend WithEvents ToolBarButton2 As System.Windows.Forms.ToolBarButton
    Friend WithEvents btnUndo As System.Windows.Forms.ToolBarButton
    Friend WithEvents StatusBar1 As System.Windows.Forms.StatusBar
    Friend WithEvents pnlStatus As System.Windows.Forms.StatusBarPanel
    Friend WithEvents pnlDate As System.Windows.Forms.StatusBarPanel
    Friend WithEvents mnuViewMyTimeSheet As System.Windows.Forms.MenuItem
    Friend WithEvents mnuViewEmployeeTimeSheets As System.Windows.Forms.MenuItem
    Friend WithEvents pnlEmployee As System.Windows.Forms.Panel
    Friend WithEvents lblEmployee As System.Windows.Forms.Label
    Friend WithEvents btnSave As System.Windows.Forms.Button
    Friend WithEvents btnSubmit As System.Windows.Forms.Button
    Friend WithEvents imgStatus As System.Windows.Forms.PictureBox
    Friend WithEvents Label1 As System.Windows.Forms.Label
    Friend WithEvents cboWeekEnding As System.Windows.Forms.ComboBox
    Friend WithEvents grdTimeSheet As System.Windows.Forms.DataGrid
    Friend WithEvents pnlManager As System.Windows.Forms.Panel
    Friend WithEvents Label2 As System.Windows.Forms.Label
    Friend WithEvents cboEmployee As System.Windows.Forms.ComboBox
    Friend WithEvents Label3 As System.Windows.Forms.Label
    Friend WithEvents cboEmployeeWeekEnding As System.Windows.Forms.ComboBox
    Friend WithEvents btnApprove As System.Windows.Forms.Button
    Friend WithEvents ImageList1 As System.Windows.Forms.ImageList
    Friend WithEvents MenuItem7 As System.Windows.Forms.MenuItem
    Friend WithEvents mnuReportsTimesheetsDue As System.Windows.Forms.MenuItem
    Friend WithEvents mnuReportsTimesheetsSubmitted As System.Windows.Forms.MenuItem
    Friend WithEvents MenuItem9 As System.Windows.Forms.MenuItem
    Friend WithEvents mnuReportsTimesheetsQTD As System.Windows.Forms.MenuItem
    Friend WithEvents mnuReportsTimesheetsYTD As System.Windows.Forms.MenuItem
    Friend WithEvents mnuReportsTimesheetsMTD As System.Windows.Forms.MenuItem
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.components = New System.ComponentModel.Container
        Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(TimeSheet))
        Me.MainMenu1 = New System.Windows.Forms.MainMenu
        Me.MenuItem1 = New System.Windows.Forms.MenuItem
        Me.mnuFileNew = New System.Windows.Forms.MenuItem
        Me.MenuItem2 = New System.Windows.Forms.MenuItem
        Me.mnuFileExit = New System.Windows.Forms.MenuItem
        Me.MenuItem3 = New System.Windows.Forms.MenuItem
        Me.mnuEditUndo = New System.Windows.Forms.MenuItem
        Me.MenuItem4 = New System.Windows.Forms.MenuItem
        Me.mnuEditCut = New System.Windows.Forms.MenuItem
        Me.mnuEditCopy = New System.Windows.Forms.MenuItem
        Me.mnuEditPaste = New System.Windows.Forms.MenuItem
        Me.MenuItem6 = New System.Windows.Forms.MenuItem
        Me.mnuEditSelectAll = New System.Windows.Forms.MenuItem
        Me.MenuItem5 = New System.Windows.Forms.MenuItem
        Me.mnuViewMyTimeSheet = New System.Windows.Forms.MenuItem
        Me.mnuViewEmployeeTimeSheets = New System.Windows.Forms.MenuItem
        Me.MenuItem7 = New System.Windows.Forms.MenuItem
        Me.mnuReportsTimesheetsDue = New System.Windows.Forms.MenuItem
        Me.mnuReportsTimesheetsSubmitted = New System.Windows.Forms.MenuItem
        Me.MenuItem9 = New System.Windows.Forms.MenuItem
        Me.mnuReportsTimesheetsMTD = New System.Windows.Forms.MenuItem
        Me.mnuReportsTimesheetsQTD = New System.Windows.Forms.MenuItem
        Me.mnuReportsTimesheetsYTD = New System.Windows.Forms.MenuItem
        Me.MenuItem8 = New System.Windows.Forms.MenuItem
        Me.mnuHelpAbout = New System.Windows.Forms.MenuItem
        Me.ToolBar1 = New System.Windows.Forms.ToolBar
        Me.btnNew = New System.Windows.Forms.ToolBarButton
        Me.ToolBarButton1 = New System.Windows.Forms.ToolBarButton
        Me.btnCut = New System.Windows.Forms.ToolBarButton
        Me.btnCopy = New System.Windows.Forms.ToolBarButton
        Me.btnPaste = New System.Windows.Forms.ToolBarButton
        Me.ToolBarButton2 = New System.Windows.Forms.ToolBarButton
        Me.btnUndo = New System.Windows.Forms.ToolBarButton
        Me.ImageList1 = New System.Windows.Forms.ImageList(Me.components)
        Me.StatusBar1 = New System.Windows.Forms.StatusBar
        Me.pnlStatus = New System.Windows.Forms.StatusBarPanel
        Me.pnlDate = New System.Windows.Forms.StatusBarPanel
        Me.pnlEmployee = New System.Windows.Forms.Panel
        Me.cboWeekEnding = New System.Windows.Forms.ComboBox
        Me.Label1 = New System.Windows.Forms.Label
        Me.imgStatus = New System.Windows.Forms.PictureBox
        Me.btnSubmit = New System.Windows.Forms.Button
        Me.btnSave = New System.Windows.Forms.Button
        Me.lblEmployee = New System.Windows.Forms.Label
        Me.grdTimeSheet = New System.Windows.Forms.DataGrid
        Me.pnlManager = New System.Windows.Forms.Panel
        Me.btnApprove = New System.Windows.Forms.Button
        Me.cboEmployeeWeekEnding = New System.Windows.Forms.ComboBox
        Me.Label3 = New System.Windows.Forms.Label
        Me.cboEmployee = New System.Windows.Forms.ComboBox
        Me.Label2 = New System.Windows.Forms.Label
        CType(Me.pnlStatus, System.ComponentModel.ISupportInitialize).BeginInit()
        CType(Me.pnlDate, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.pnlEmployee.SuspendLayout()
        CType(Me.grdTimeSheet, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.pnlManager.SuspendLayout()
        Me.SuspendLayout()
        '
        'MainMenu1
        '
        Me.MainMenu1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem1, Me.MenuItem3, Me.MenuItem5, Me.MenuItem7, Me.MenuItem8})
        '
        'MenuItem1
        '
        Me.MenuItem1.Index = 0
        Me.MenuItem1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.mnuFileNew, Me.MenuItem2, Me.mnuFileExit})
        Me.MenuItem1.Text = "&File"
        '
        'mnuFileNew
        '
        Me.mnuFileNew.Index = 0
        Me.mnuFileNew.Shortcut = System.Windows.Forms.Shortcut.CtrlN
        Me.mnuFileNew.Text = "&New"
        '
        'MenuItem2
        '
        Me.MenuItem2.Index = 1
        Me.MenuItem2.Text = "-"
        '
        'mnuFileExit
        '
        Me.mnuFileExit.Index = 2
        Me.mnuFileExit.Text = "E&xit"
        '
        'MenuItem3
        '
        Me.MenuItem3.Index = 1
        Me.MenuItem3.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.mnuEditUndo, Me.MenuItem4, Me.mnuEditCut, Me.mnuEditCopy, Me.mnuEditPaste, Me.MenuItem6, Me.mnuEditSelectAll})
        Me.MenuItem3.Text = "&Edit"
        '
        'mnuEditUndo
        '
        Me.mnuEditUndo.Index = 0
        Me.mnuEditUndo.Shortcut = System.Windows.Forms.Shortcut.CtrlZ
        Me.mnuEditUndo.Text = "&Undo"
        '
        'MenuItem4
        '
        Me.MenuItem4.Index = 1
        Me.MenuItem4.Text = "-"
        '
        'mnuEditCut
        '
        Me.mnuEditCut.Index = 2
        Me.mnuEditCut.Shortcut = System.Windows.Forms.Shortcut.CtrlX
        Me.mnuEditCut.Text = "Cu&t"
        '
        'mnuEditCopy
        '
        Me.mnuEditCopy.Index = 3
        Me.mnuEditCopy.Shortcut = System.Windows.Forms.Shortcut.CtrlC
        Me.mnuEditCopy.Text = "&Copy"
        '
        'mnuEditPaste
        '
        Me.mnuEditPaste.Index = 4
        Me.mnuEditPaste.Shortcut = System.Windows.Forms.Shortcut.CtrlV
        Me.mnuEditPaste.Text = "&Paste"
        '
        'MenuItem6
        '
        Me.MenuItem6.Index = 5
        Me.MenuItem6.Text = "-"
        '
        'mnuEditSelectAll
        '
        Me.mnuEditSelectAll.Index = 6
        Me.mnuEditSelectAll.Shortcut = System.Windows.Forms.Shortcut.CtrlA
        Me.mnuEditSelectAll.Text = "Select &All"
        '
        'MenuItem5
        '
        Me.MenuItem5.Index = 2
        Me.MenuItem5.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.mnuViewMyTimeSheet, Me.mnuViewEmployeeTimeSheets})
        Me.MenuItem5.Text = "&View"
        '
        'mnuViewMyTimeSheet
        '
        Me.mnuViewMyTimeSheet.Index = 0
        Me.mnuViewMyTimeSheet.Text = "&My Time Sheet"
        '
        'mnuViewEmployeeTimeSheets
        '
        Me.mnuViewEmployeeTimeSheets.Index = 1
        Me.mnuViewEmployeeTimeSheets.Text = "&Employee Time Sheets"
        '
        'MenuItem7
        '
        Me.MenuItem7.Index = 3
        Me.MenuItem7.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.mnuReportsTimesheetsDue, Me.mnuReportsTimesheetsSubmitted, Me.MenuItem9, Me.mnuReportsTimesheetsMTD, Me.mnuReportsTimesheetsQTD, Me.mnuReportsTimesheetsYTD})
        Me.MenuItem7.Text = "&Reports"
        '
        'mnuReportsTimesheetsDue
        '
        Me.mnuReportsTimesheetsDue.Index = 0
        Me.mnuReportsTimesheetsDue.Text = "Timesheets &Due "
        '
        'mnuReportsTimesheetsSubmitted
        '
        Me.mnuReportsTimesheetsSubmitted.Index = 1
        Me.mnuReportsTimesheetsSubmitted.Text = "Timesheets &Submitted "
        '
        'MenuItem9
        '
        Me.MenuItem9.Index = 2
        Me.MenuItem9.Text = "-"
        '
        'mnuReportsTimesheetsMTD
        '
        Me.mnuReportsTimesheetsMTD.Index = 3
        Me.mnuReportsTimesheetsMTD.Text = "Timesheets &MTD"
        '
        'mnuReportsTimesheetsQTD
        '
        Me.mnuReportsTimesheetsQTD.Index = 4
        Me.mnuReportsTimesheetsQTD.Text = "Timesheets &QTD"
        '
        'mnuReportsTimesheetsYTD
        '
        Me.mnuReportsTimesheetsYTD.Index = 5
        Me.mnuReportsTimesheetsYTD.Text = "Timesheets &YTD"
        '
        'MenuItem8
        '
        Me.MenuItem8.Index = 4
        Me.MenuItem8.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.mnuHelpAbout})
        Me.MenuItem8.Text = "&Help"
        '
        'mnuHelpAbout
        '
        Me.mnuHelpAbout.Index = 0
        Me.mnuHelpAbout.Text = "&About..."
        '
        'ToolBar1
        '
        Me.ToolBar1.Appearance = System.Windows.Forms.ToolBarAppearance.Flat
        Me.ToolBar1.Buttons.AddRange(New System.Windows.Forms.ToolBarButton() {Me.btnNew, Me.ToolBarButton1, Me.btnCut, Me.btnCopy, Me.btnPaste, Me.ToolBarButton2, Me.btnUndo})
        Me.ToolBar1.ButtonSize = New System.Drawing.Size(16, 16)
        Me.ToolBar1.DropDownArrows = True
        Me.ToolBar1.ImageList = Me.ImageList1
        Me.ToolBar1.Location = New System.Drawing.Point(0, 0)
        Me.ToolBar1.Name = "ToolBar1"
        Me.ToolBar1.ShowToolTips = True
        Me.ToolBar1.Size = New System.Drawing.Size(739, 28)
        Me.ToolBar1.TabIndex = 1
        '
        'btnNew
        '
        Me.btnNew.ImageIndex = 0
        Me.btnNew.ToolTipText = "New"
        '
        'ToolBarButton1
        '
        Me.ToolBarButton1.Style = System.Windows.Forms.ToolBarButtonStyle.Separator
        '
        'btnCut
        '
        Me.btnCut.ImageIndex = 1
        Me.btnCut.Tag = "Cut"
        Me.btnCut.ToolTipText = "Cut"
        '
        'btnCopy
        '
        Me.btnCopy.ImageIndex = 2
        Me.btnCopy.Tag = "Copy"
        Me.btnCopy.ToolTipText = "Copy"
        '
        'btnPaste
        '
        Me.btnPaste.ImageIndex = 3
        Me.btnPaste.Tag = "Paste"
        Me.btnPaste.ToolTipText = "Paste"
        '
        'ToolBarButton2
        '
        Me.ToolBarButton2.Style = System.Windows.Forms.ToolBarButtonStyle.Separator
        '
        'btnUndo
        '
        Me.btnUndo.ImageIndex = 4
        Me.btnUndo.Tag = "Undo"
        Me.btnUndo.ToolTipText = "Undo"
        '
        'ImageList1
        '
        Me.ImageList1.ColorDepth = System.Windows.Forms.ColorDepth.Depth32Bit
        Me.ImageList1.ImageSize = New System.Drawing.Size(16, 16)