Imports System.Web.Configuration
Imports Stock_Control.sqlDB

Partial Public Class UserList
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If Not Page.IsPostBack Then
            If WebConfigurationManager.AppSettings("strPage") = "UserDetails" Then
                gvUser.PageIndex = WebConfigurationManager.AppSettings("intListIndex")
            End If
            Try
                gvUser.PageSize = WebConfigurationManager.AppSettings("PAGESIZE")

            Catch ex As Exception

            End Try
        End If
    End Sub

    Protected Sub btnSearch_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnSearch.Click
        If Trim(strUser.Text) <> "" Then
			sdsUser.FilterExpression = "strUserName LIKE '%" & sqlDB.CleanString(strUser.Text) & "%'"
        End If
    End Sub

    Protected Sub btnAdd_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnAdd.Click
        Response.Redirect("UserDetails.aspx")
    End Sub

	Protected Sub gvUser_PreRender(ByVal sender As Object, ByVal e As EventArgs) Handles gvUser.PreRender
    If Not Page.IsPostBack Then
      For Each item As GridViewRow In gvUser.Rows
        Try
          item.Cells(4).Text = sqlDB.sqlDate(item.Cells(4).Text, "d MMM yyyy HH:mm")
          'item.Cells(3).HorizontalAlign = HorizontalAlign.Right
        Catch ex As Exception
          item.Cells(4).Text = Date.Now.ToString("d MMM yyyy HH:mm")
        End Try
      Next
    End If
	End Sub
End Class