Latihan 38

Public Class Latihan38
Dim A As New OleDb.OleDbConnection("Provider=microsoft.ACE.OLEDB.12.0;data source=" & Application.StartupPath & "\DATAMAJEMUK.accdb")
Dim dt As New DataTable
Dim dr As DataRow

Private Sub Latihan38_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim X As New OleDb.OleDbDataAdapter
X = New OleDb.OleDbDataAdapter("Select BARANG.KODEBARANG, BARANG.NAMABARANG, DETAILTRANSAKSI.UNIT, DETAILTRANSAKSI.HARGA, DETAILTRANSAKSI.UNIT*DETAILTRANSAKSI.HARGA AS JUMLAH from DETAILTRANSAKSI INNER JOIN BARANG ON DETAILTRANSAKSI.KODEBARANG=BARANG.KODEBARANG WHERE NOTRANS= '" & NOTRANS.Text & "'", A)
X.Fill(dt)
X.Dispose()

Dim dataPrimary(1) As DataColumn
dataPrimary(0) = dt.Columns("KODEBARANG")
dt.PrimaryKey = dataPrimary

DGV38.DataSource = dt
End Sub

Private Sub TOTALJUMLAH()
Dim TOT As Double = 0
For Each x As DataRow In dt.Rows
TOT = TOT + x("JUMLAH")
Next
TOTAL.Text = TOT

End Sub

Private Sub KB_Leave(ByVal sender As Object, ByVal e As System.EventArgs) Handles KB.Leave
If KB.Text.Length = 0 Then
Exit Sub
End If

Dim Pencari As New ByIskandar.CariKeDataBaseByIskandar
Pencari.AturPencarianDataBase("BARANG", "KODEBARANG", KB.Text, 1, A)
If Pencari.JumlanBaris > 0 Then
KB.Text = Pencari.DataTablenya.Rows(0).Item("KODEBARANG")
NB.Text = Pencari.DataTablenya.Rows(0).Item("NAMABARANG")
Else
MsgBox("Kode barang tersebut tidak ada")
If Latihan383940.ShowDialog = Windows.Forms.DialogResult.OK Then
KB.Text = Latihan383940.DGV38.CurrentRow.Cells("KodeBarang").Value
NB.Text = Latihan383940.DGV38.CurrentRow.Cells("NamaBarang").Value
Else
KB.Text = ""
End If
End If
End Sub

Private Sub KB_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles KB.TextChanged
NB.Text = ""
UNIT.Text = ""
HB.Text = ""
End Sub

Private Sub UNIT_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles UNIT.TextChanged, HB.TextChanged
JUM.Text = Val(UNIT.Text) * Val(HB.Text)
End Sub

Private Sub Tambah_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Tambah.Click
'a'
If KB.Text.Length = 0 Then
MsgBox("Kode barang sudah ada")
Exit Sub
End If

If NB.Text.Length = 0 Then
MsgBox("Nama barang sudah ada")
End If

If Val(UNIT.Text) = 0 Then
MsgBox("Masukkan unit barang")
Exit Sub
End If

If Val(HB.Text) = 0 Then
MsgBox("Masukkan harga barang barang")
Exit Sub
End If

'b'
dr = dt.Rows.Find(KB.Text)

If dr Is Nothing Then
dr = dt.NewRow
dr("KODEBARANG") = KB.Text
Else
MsgBox("Maaf kodebarang sudah ada")
Exit Sub
End If

'c'
dr = dt.NewRow
dr("KODEBARANG") = KB.Text
dr("NAMABARANG") = NB.Text
dr("UNIT") = UNIT.Text
dr("HARGA") = HB.Text
dr("JUMLAH") = JUM.Text

dt.Rows.Add(dr)

'd'
KB.Text = ""
NB.Text = ""
UNIT.Text = ""
HB.Text = ""

'e'
TOTALJUMLAH()
End Sub

Private Sub Simpan_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Simpan.Click
'a'
If NOTRANS.Text.Length = 0 Then
MsgBox("No. transaksi sudah ada")
Exit Sub
End If

If JT.Text.Length = 0 Then
MsgBox("Jenis transaksi sudah ada")
Exit Sub
End If

'b'
If dt.Rows.Count = 0 Then
MsgBox("Jumlah baris tidak terisi")
Exit Sub
End If

'c'
Dim pencari As New ByIskandar.CariKeDataBaseByIskandar
pencari.AturPencarianDataBase("MASTERTRANSAKSI", "NOTRANS", NOTRANS.Text, 1, A)
If pencari.JumlanBaris > 0 Then
MsgBox("data tersebut sudah ada")
Exit Sub
End If

'd'
Dim CM As New OleDb.OleDbCommand
CM = New OleDb.OleDbCommand("INSERT INTO MASTERTRANSAKSI (NOTRANS, TANGGALTRANSAKSI, JENISTRANSAKSI) VALUES ('" & NOTRANS.Text & "', #" & DTP.Value.Month & "/" & DTP.Value.Day & "/" & DTP.Value.Year & "#, '" & JT.Text & "')", A)
A.Open()
CM.ExecuteNonQuery()
A.Close()

'e'
For Each X As DataRow In dt.Rows
CM = New OleDb.OleDbCommand("INSERT INTO DETAILTRANSAKSI (NOTRANS, KODEBARANG, UNIT, HARGA) VALUES ('" & NOTRANS.Text & "','" & X("KODEBARANG") & "'," & X("UNIT") & ", " & X("HARGA") & ")", A)
A.Open()
CM.ExecuteNonQuery()
A.Close()
CM.Dispose()
Next

'f'
NOTRANS.Text = ""
JT.Text = ""
JUM.Text = ""

'g'
dt.Rows.Clear()

'h'
TOTALJUMLAH()
End Sub
End Class