Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim ctr As Integer
Dim dta as clsData
[COLOR=green]'Set event handlers for Edit Menu events[/color]
AddHandler EditMenu1.Cancel_OnClick, AddressOf CancelClicked
[COLOR=red yellow]AddHandler EditMenu1.Save_OnClick, AddressOf SaveClicked[/color]
AddHandler EditMenu1.New_OnClick, AddressOf NewBoiler
AddHandler EditMenu1.Edit_OnClick, AddressOf EditClicked
[COLOR=green]'Reference Session data class[/color]
dta = Session("Data")
[COLOR=green]'Reference Session data class[/color]
dta = Session("Data")
[COLOR=green]'Set text field Attributes for real time formatting[/color]
txtPhone.Attributes.Add("onLoad", "FormatPhone('txtPhone');")
txtPhone.Attributes.Add("onKeyPress", "FormatPhone('txtPhone');")
txtInspDate.Attributes.Add("onchange", "FormatDate('txtInspDate');SetExpDate();")
txtCertExp.Attributes.Add("onchange", "FormatDate('txtCertExp');")
txtSafVlvTestDate.Attributes.Add("onchange", "FormatDate('txtSafVlvTestDate');")
btnPrint.Attributes.Add("onclick", "window.open('wfrmBoilerPrint.aspx','wfrmBoilerPrint','width=300,height=200,scrollbars=no,resizable=no');")
btnVPrint.Attributes.Add("onclick", "window.open('wfrmBoilerPrint.aspx','wfrmBoilerPrint','width=300,height=200,scrollbars=no,resizable=no');")
txtOwnerSearch.Attributes.Add("onkeyup", "FindOwner();")
radAir2yr.Attributes.Add("onclick", "SetExpDate();")
radAir4yr.Attributes.Add("onclick", "SetExpDate();")
ddlBoilerType.Attributes.Add("onchange", "SetFuel();")
ddlCycle.Attributes.Add("onchange", "SetExpDate();")
[COLOR=green]'Set Menu based on Security level[/color]
menu1.SetMenuView(Session("Usr.SecurityLevel"))
[COLOR=green]'Check if current record is under same Insurance Company as logged in user
'If true, Give them Edit privileges[/color]
If Session("Usr.InsCoNum") = 99 Or Session("Usr.InsCoNum") = Session("Boiler.InsCoNum") Then
If Session("Usr.SecurityLevel") < 3 Then
Session("Usr.EditMode") = True
Else
Session("Usr.EditMode") = False
End If
Else
Session("Usr.EditMode") = False
End If
[COLOR=green]'Set Menu user control to Show button Boiler as current menu[/color]
menu1.CurrentForm("btnBoiler")
Session("ReturnPage") = ""
If dta.Table_Rows("tblBoiler") > 0 Then
Session("Boiler.StateNum") = dta.Item("tblBoiler", 0, "StateNum", SqlDbType.Int)
End If
[COLOR=green]'If Owner is set in record, get owner list and set ddlOwner to saved Owner[/color]
If Session("Boiler.OwnerID") <> 0 Then
GetListData("ddlOwner")
For ctr = 1 To ddlOwner.Items.Count - 1
If ddlOwner.Items(ctr).Value = Session("Boiler.OwnerID") Then
ddlOwner.SelectedIndex = ctr
ddlOwner_SelectedIndexChanged(Me, e)
Session("Boiler.OwnerID") = 0
End If
Next
End If
If Not IsPostBack Then
xml.SetOwnerXML()
dta.ClearSearchCriteria()
[COLOR=green]'Get Boiler data for State Number saved in Session object[/color]
dta.GetBoiler(Session("Boiler.StateNum"))
[COLOR=green]'Check for Mode to show data[/color]
If Not IsNothing(Request.QueryString("Mode")) Then
[COLOR=green yellow]'I thought this might be causing the problem, but it is not firing on Save.[/color]
[COLOR=green]'Populate dropdownlists[/color]
GetListData()
Select Case Request.QueryString("Mode")
Case "View"
Session("EditMode") = "View"
ShowPanel(pnlView)
GetData()
EnableHTVButtons(True)
EnableDataEntry(False)
Case "Edit"
Session("EditMode") = "Edit"
ShowPanel(pnlEdit)
GetData()
EnableDataEntry()
EnableHTVButtons(True)
txtState.Enabled = False
Case "New"
Session("EditMode") = "New"
Session("Boiler.StateNum") = ""
Session("Violation.StateNum") = ""
Session("Transaction.StateNum") = 0
EnableDataEntry()
ShowPanel(pnlEdit)
txtLastUpdate.Text = Date.Now.ToShortDateString
txtUpdatedBy.Text = Session("Usr.Initials")
For ctr = 0 To ddlStatus.Items.Count - 1
If InStr(ddlStatus.Items(ctr).Text, "Done") > 0 Then
ddlStatus.SelectedIndex = ctr
End If
Next
txtStatusDate.Text = Date.Now.ToShortDateString
txtInspDate.Attributes.Add("onfocusout", "SetCycleCode();")
ddlInspType.Attributes.Add("onchange", "SetCycleCode();")
Me.radDelOwnNo.Checked = True
EnableHTVButtons(True)
End Select
End If
End If
End Sub
[COLOR=red yellow]Private Sub Save(Optional ByVal SaveType As String = "")[/color]
Dim paramColl As SqlClient.SqlParameterCollection
Dim param As SqlClient.SqlParameter
Dim strSQL As String
Dim strSaveType As String
Dim message As New clsMail
Dim messageBody As String
Dim statusFlag As Integer
Dim CertFlag As Integer
If CheckValidators() Then
Dim ctl As New Control
For Each ctl In pnlEdit.Controls
If ctl.GetType Is GetType(TextBox) Then
ctl = CType(ctl, TextBox)
CType(ctl, TextBox).Text = dta.FormatString(CType(ctl, TextBox).Text)
End If
Next
Try
Select Case Session("EditMode")
Case "Edit"
strSaveType = "UPDATE"
Case "New"
strSaveType = "INSERT"
End Select
dta.Param_Clear()
strSQL = "spBoiler_Save"
dta.Param_Add("@SaveType", strSaveType)
dta.Param_Add("@CYCLE", IIf(ddlCycle.SelectedIndex > 0, ddlCycle.SelectedItem.Value, ""))
dta.Param_Add("@STATENUM", IIf(txtState.Text.ToUpper <> "", txtState.Text.ToUpper, 0), SqlDbType.Int)
dta.Param_Add("@STATUSCODE", IIf(ddlStatus.SelectedIndex > 0, ddlStatus.SelectedValue.ToUpper, 0))
dta.Param_Add("@STATUSDATE", IIf(txtStatusDate.Text.ToUpper <> "", txtStatusDate.Text.ToUpper, ""))
dta.Param_Add("@STATUSFLAG", statusFlag)
dta.Param_Add("@INSPECTIONDATE", IIf(txtInspDate.Text.ToUpper <> "", txtInspDate.Text.ToUpper, "NULL"))
dta.Param_Add("@OWNER_ID", IIf(ddlOwner.SelectedIndex > 0, ddlOwner.SelectedItem.Value, 0))
dta.Param_Add("@LOCATE", IIf(txtLocName.Text.ToUpper <> "", txtLocName.Text.ToUpper, ""))
dta.Param_Add("@LADDRS1", IIf(txtLocAddr1.Text.ToUpper <> "", txtLocAddr1.Text.ToUpper, ""))
dta.Param_Add("@LADDRS2", IIf(txtLocAddr2.Text.ToUpper <> "", txtLocAddr2.Text.ToUpper, ""))
dta.Param_Add("@TYPE", IIf(ddlBoilerType.SelectedIndex > 0, ddlBoilerType.SelectedItem.Text.ToUpper, 0))
dta.Param_Add("@BUILTBY", IIf(txtBuiltBy.Text.ToUpper <> "", txtBuiltBy.Text.ToUpper, ""))
dta.Param_Add("@YEAR", IIf(txtYrBuilt.Text.ToUpper <> "", txtYrBuilt.Text.ToUpper, ""))
dta.Param_Add("@NBNUM", IIf(txtNatBoard.Text.ToUpper <> "", txtNatBoard.Text.ToUpper, ""))
dta.Param_Add("@ONUM", IIf(txtOwnerNum.Text.ToUpper <> "", txtOwnerNum.Text.ToUpper, ""))
dta.Param_Add("@MAWP1", IIf(txtMaxPressure.Text.ToUpper <> "", txtMaxPressure.Text.ToUpper, ""))
dta.Param_Add("@FUEL", IIf(ddlFuel.SelectedIndex > 0, ddlFuel.SelectedItem.Text.ToUpper, ""))
dta.Param_Add("@USE", IIf(ddlUse.SelectedIndex > 0, ddlUse.SelectedItem.Text.ToUpper, ""))
dta.Param_Add("@SVLBS", CInt(IIf(txtSafVlvPSI.Text.ToUpper <> "", txtSafVlvPSI.Text.ToUpper, 0)))
dta.Param_Add("@SVPPHBTU", CInt(IIf(txtSafVlvPPH.Text.ToUpper <> "", txtSafVlvPPH.Text.ToUpper, 0)))
dta.Param_Add("@SVINPUT", IIf(ddlSVInput.SelectedIndex > 0, ddlSVInput.SelectedItem.Value.ToUpper, 0))
dta.Param_Add("@INTERNAL", IIf(ddlInspType.SelectedIndex > 0, ddlInspType.SelectedValue.ToUpper, ""))
dta.Param_Add("@INSPNUM", ddlInspector.SelectedItem.Value)
[COLOR=green yellow]'..... At this point the SelectedIndex is 0[/color]