latihan37

Public Class Latihan37_36109074

    Dim krisna As New OleDb.OleDbConnection("Provider=microsoft.ACE.OLEDB.12.0;data source=" & Application.StartupPath & "\DATAMAJEMUK.accdb")
    Dim saman As New DataTable
    Dim tati As DataRow

    Private Sub Latihan37_36109074_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim K As New OleDb.OleDbDataAdapter
        K = 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= '" & trans_074.Text & "'", krisna)
        K.Fill(saman)
        K.Dispose()

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

        dgv_074.DataSource = saman
    End Sub

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

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

        Dim Pencari As New ByIskandar.CariKeDataBaseByIskandar
        Pencari.AturPencarianDataBase("BARANG", "KODEBARANG", kb_074.Text, 1, krisna)
        If Pencari.JumlanBaris > 0 Then
            kb_074.Text = Pencari.DataTablenya.Rows(0).Item("KODEBARANG")
            nb_074.Text = Pencari.DataTablenya.Rows(0).Item("NAMABARANG")
        Else
            MsgBox("Kode barang tersebut tidak ada")
            Exit Sub
        End If
    End Sub

    Private Sub kb_074_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles kb_074.TextChanged
        nb_074.Text = ""
        unit_074.Text = ""
        hb_074.Text = ""
    End Sub

    Private Sub unit_074_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles unit_074.TextChanged, hb_074.TextChanged
        jml_074.Text = Val(unit_074.Text) * Val(hb_074.Text)
    End Sub

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

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

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

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

        'b'
        tati = saman.Rows.Find(kb_074.Text)

        If tati Is Nothing Then
            tati = saman.NewRow
            tati("KODEBARANG") = kb_074.Text
        Else
            MsgBox("Maaf kodebarang sudah ada")
            Exit Sub
        End If

        'c'
        tati = saman.NewRow
        tati("KODEBARANG") = kb_074.Text
        tati("NAMABARANG") = nb_074.Text
        tati("UNIT") = unit_074.Text
        tati("HARGA") = hb_074.Text
        tati("JUMLAH") = jml_074.Text

        saman.Rows.Add(tati)

        'd'
        kb_074.Text = ""
        nb_074.Text = ""
        unit_074.Text = ""
        hb_074.Text = ""

        'e'
        TOTALJUMLAH()
    End Sub

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

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

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

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

        'd'
        Dim KS As New OleDb.OleDbCommand
        KS = New OleDb.OleDbCommand("INSERT INTO MASTERTRANSAKSI (NOTRANS, TANGGALTRANSAKSI, JENISTRANSAKSI) VALUES ('" & trans_074.Text & "', #" & tgl_074.Value.Month & "/" & tgl_074.Value.Day & "/" & tgl_074.Value.Year & "#, '" & jentr_074.Text & "')", krisna)
        krisna.Open()
        KS.ExecuteNonQuery()
        krisna.Close()

        'e'
        For Each K As DataRow In saman.Rows
            KS = New OleDb.OleDbCommand("INSERT INTO DETAILTRANSAKSI (NOTRANS, KODEBARANG, UNIT, HARGA) VALUES ('" & trans_074.Text & "','" & K("KODEBARANG") & "'," & K("UNIT") & ", " & K("HARGA") & ")", krisna)
            krisna.Open()
            KS.ExecuteNonQuery()
            krisna.Close()
            KS.Dispose()
        Next

        'f'
        trans_074.Text = ""
        jentr_074.Text = ""
        jml_074.Text = ""
        'g'
        saman.Rows.Clear()

        'h'
        TOTALJUMLAH()
    End Sub
End Class