LATIHAN 35

Public Class Latihan35_36109074

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

    Private Sub Latihan35_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 KODEBARANG, UNIT, HARGA from DETAILTRANSAKSI WHERE NOTRANS= '" & no_074.Text & "'", krisna)
        K.Fill(saman)
        K.Dispose()
        dgv_074.DataSource = saman
    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 Val(unit_074.Text) = 0 Then
            MsgBox("Masukkan Harga barang")
            Exit Sub
        End If

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

        'b'
        Dim kr As DataRow
        kr = saman.NewRow
        kr("KODEBARANG") = kb_074.Text
        kr("UNIT") = unit_074.Text
        kr("HARGA") = hrgb_074.Text

        saman.Rows.Add(kr)

        'c'
        kb_074.Text = ""
        unit_074.Text = ""
        hrgb_074.Text = ""

    End Sub

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

        If tr_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", no_074.Text, 1, krisna)
        If pencari.JumlanBaris > 0 Then
            MsgBox("data tersebut sudah ada")
            Exit Sub
        End If

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

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

        'f'
        no_074.Text = ""
        tr_074.Text = ""

        'g'
        saman.Rows.Clear()


    End Sub
End Class