Minggu, 12 Januari 2020

UAS AUDIT IT


Tulisan ini saya buat dalam rangka memenuhi tugas UAS mata kuliah AUDIT IT

Studi Kasus Audit dengan menggunakan software ACL

1.  PT. Icoh Care Pegimana akan melakukan pemeriksaan terhadap seluruh data perusahaan. Salah satu aspek yang akan diperiksa adalah data piutang yang mereka miliki. Perusahaan ingin melihat kecocokan antara daftar piutang dengan daftar pelanggan berdasarkan nomor pelanggan. Bagaimana cara yang harus dilakukan perusahaan untuk melihat kecocokkan data apabila perusahaan menggunakan software Audit Command Language (ACL)?

Langkah – langkah :

 Lakukan SORT pada file PIUTANG.dbf berdasarkan NO_PLGN dan simpan SORT filenya dengan nama SORT_PIUTANG.


Tampilan View Default nya sebagai berikut :

Nb: File yang akan di Join adalah file yang sudah di SORT


     Lakukan SORT pada file PELANGGAN.dbf berdasarkan NO_PLGN dan simpan SORT filenya dengan nama SORT_PELANGGAN.
Tampilan View Default nya sebagai berikut :

Pilih menu Data lalu submenu JOIN.

 Pada Main pilih SORT_PIUTANG sebagai secondary filenya.

 Pada Primary Keys dan Secondary Keys pilih NO_PLGN.
  Klik checkbox Presort untuk meyakinkan Primary Key sudah terurut.
 Untuk Primary Fields dan Secondary Fields listboxnya pilih semua fields yaitu dengan     mengklik Add All.
 Kemudian klik check box Presort Secondary File untuk meyakinkan Secondary Fieldnya sudah terurut.
 Pada text box To ketik JOIN_MATCHED.

Klik tab More padaScope klik All dan pada Join Categories Matched Primary Records

    Klik Ok, maka tampilan Command Log akan muncul sebagai berikut :

Kemudian akan muncul tampilan di Jendela View seperti gambar dibawah ini

Analisis           : Berdasarkan hasil dari kecocokan antara daftar piutang dengan daftar pelanggan yang dilihat dari nomor pelanggannya, terdapat 41 records produced yang artinya ada 41 records yang memiliki kecocokan dan 29 records bypassed yang artinya ada 29 records yang memiliki ketidakcocokan

2. Mencari ketidak cocokan antara daftar piutang dengan daftar pelanggan 
 Pertama-tama, ikuti Langkah 1 s/d 9 sama sepertipada JOIN_MATCHED.

Pada text box To ketik JOIN_UNMATCHED

Klik tab More, pada Scope klik All dan pada Join Categories klik Unmatched Primary Records

Kemudian kembali ke tab Main, maka Secondary Fields akan otomatis ter-highlight

Klik Ok, maka tampilan Command Log akan muncul sebagai berikut

Lalu tampilan pada Default_View sebagai berikut

Analisis           : Berdasarkan hasil dari ketidakcocokan antara daftar piutang dengan daftar gaji pelanggan yang dilihat dari nomor pelanggannya, terdapat 29 records produced yang artinya ada 29 records yang memiliki  ketidak-cocokan  dan 41 records bypassed yang artinya ada 41 records yang memiliki kecocokan

3. Mencari data pegawai dan di minta untuk rincian jumlah karyawan yang bekerja sebagai programer yang berjenis kelamin laki-laki dan perempuan 

4. Mencari data pegawai yang memiliki hutang per periode lebih dari sama dengan Rp. 300.000

Langkah-langkah :


  Menciptakan Extract pertama:

  Aktif pada file DATA_PEGAWAI.

 Pilih perintah Extract pada menubar Data.

Pada Main, Klik radio button Fields

Klik Extract Fields, pilih fields yang dibutuhkan (Nama Pegawai, JenisKelamin, Jabatan, Hutang Per Periode danNomor Telepon) lalu klik OK
Klik If, isi kolom Expression dengan rumus: JABATAN = ‘Programmer’ AND JNS_KLMN = ‘L’ AND HTG_PER_PR>=300.000

Jika sudah, Klik Verify untuk memastikan apakah rumus yang diinput sudah benar/ valid, lalu klik Ok

Pada text box To ketik Hutang_LProgrammer, klik Ok

Maka hasil akan muncul pada Command Log dan Default_View

Analisis           : Dari data diatas diketahui bahwa extract 1 yaitu Data Hutang_LProgrammer berhasil dibuat dengan 6 file yang aktif dari 45 record yang memiliki jabatan sebagai programmer, berjenis kelamin laki-laki dan memiliki hutang per periode lebih besar sama dengan Rp 300.000

5. Mencari data pegawai perusahaan untuk memeriksa gaji bersih yang lebih besar sama dengan Rp. 6.000.000 dan hutang per periode lebih kecil sama dengan Rp. 5.000.000 dengan cara membuat filter
















Minggu, 15 Desember 2019

UTS Matkul Audit Dosen Pak Agus Suharto, S.Kom, M.kom

Nama : Mukhlisoh
Nim : 161011700376
kelas : 07SHIFE002


Studi Kasus

Sebuah Lembaga Pendidikan yang berdomisili di Bogor sedang mengadakan seleksi penerimaan siswa baru dengan menggunakan sebuah sistem. untuk pesertanya di targetkan dari seluruh kota yang ada di nusantara karena lembaga pendidikan ini bersifat boarding sehingga menerima peserta dari mana saja asalnya. Selain merekrut peserta dari luar kota juga terdapat peserta dari internal sehingga terdapat perbedaan biaya pendaftaran antara peserta internal dengan peserta eksternal.
dari database yang ada di minta untuk mengaudit data sesuai permintaan yang di inginkan.
studi kasus ini menggunakan tools atau software yang bernama "HeidiSQL" berikut penampakan aplikasi HeidiSql


Berikut pertanyaan atau audit yang di inginkan :

1. Ingin mengetahui data peserta dari kota gorontalo, caranya :
  •  buka atau aktifkan terlebih dahulu aplikasi heidisql dan masukan usename passwordnya :

    • setelah terbuka aplikasinya, pilih tabel mana yang mau di cari datanya, dalam hal ini kita menggunakan tabel m_csantri. dan klik menu permintaan(query)
       
    •  kemudian di dalam menu query ini masukan sintak query nya, dalam soal nomor 1 ini ingin mengetahui data peserta dari kota gorontalo, sintaks nya : select * from m_csantri where asal_daerah = "id-go"; dalam tabel ini asal daerah nya kita singkat dengan kode (id-go) untuk gorontalo, sehingga ketika di jalankan query nya akan muncul hasilnya seperti ini :
      Catatan : cara membuka aplikasi sampai dengan memilih tabel nya untuk soal berikutnya menggunakan cara yang sama.
    •  
      2. Ingin mengetahui peserta yang biaya pendaftarannya Rp. 350.000 dengan mengetikan sintaks queri : select * from m_csantri where tagihan = "Rp350000";
      3. Ingin mengetahui yang biaya biaya pendaftaranya Rp 350000 dan berasal dari kota gorontalo dengan cara mengetikan sintaks : select * from m_csantri asal_daerah = "id-go" and tagihan = "Rp3550000"; berikut hasilnya :

      4. Ingin mengetahui jumlah peserta jenjang SMP dengan cara mengetikan sintaks : select * from m_csantri where jenjang = "SMPIT"; dan berikut hasilnya dan jumlahnya ada 2725 peserta 
      5. Ingin mengetahui jumlah peserta jenjang SMA dan berjenis kelamin perempuan dengan cara mengetikan sintaks : select * from m_csantri where jenjang = "SMAIT" and jenkel = "P"; dan berikut hasilnya :
      6. Ingin mengetahui jumlah peserta yang biaya pendaftaran nya di atas Rp 350000, dengan cara mengetikan sintaks : select*from m_csantri where tagihan > "Rp350000";
      dan berikut hasilnya :
      demikian audit peserta penerimaan siswa atau santri baru pada sebuah lembaga pendidikan yang berdomisili di wilayah bogor, semoga data ini bermanfaat dan juga bisa di jadikan sebagai syarat untuk mendapatkan nilai UTS mata kuliah Audit oleh Bapak Dosen Agus Suharto, S.Kom, M.Kom
      terima kasih 
      Mukhlisoh
      NIM : 161011700376

Senin, 19 November 2018

UAS SISTEM INFORMASI LAB KOMPUTER

Tugas UAS Sistem Informasi Lab Komputer Berbasis WEB

NAMA MUKHLISOH
NIM : 161011700376


Aplilkasi Buku Tamu Pengunjung Lab Komputer

1.Analisa kebutuhan
  • Aplikasi ini berfungsi untuk memenuhi kebutuhan sistim informasi di suatu lab kumputer di salah satu sekolah:
  1. Menginput Data 
  2. Mengupdate Data
  3. Meng edit Data
  4. Menyimpan Data
  5. Menghapus Data 

 2.Perancangan (Desain)
     2.1 Perancangan Database
           1,Login User
              -User Name (Field: UserName, Teks, 50)
              -Password (Field: Password, Teks, 20, Key)
           2.tabel kunjungan
              -ID (Field: ID. Teks, 10)
              -nama (Field: nama. numerik, 50)
              -jenis kelamin (Field:jenkel. Teks, 20, Key)
              -kelas(Field: kelas. Teks, 10, Key)
              -keperluan (Field:keperluan. Teks, 100)
              -cari  (Field: cari. nimerik, 50)
             -tanggal (Field: tanggal. nimerik, 50)
             -jam (Field: jam. nimerik, 50)

   3.data_anggota
              -ID (Field: ID. Teks, 10)
              -nama (Field: nama. numerik, 50)
              -jenis kelamin (Field:jenkel. Teks, 20, Key)
              -kelas(Field: kelas. Teks, 10, Key)
             -alamat(Field: kelas. Teks, 10, Key)


screenshot database 1


             

screenshot database 2


screenshot view data




screeshot form data anggota



scrennshot data kunjungan



screenshot dashboard



sourcecode form input kunjungan


Imports System.Data
Imports System.Data.OleDb


Public Class kunjungan
    Inherits System.Web.UI.Page
    Dim Koneksi As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\semester 5\pak agus\tugas_uas\silabkom\silabkom\app\labkom1.accdb"
    Dim ObjKoneksi As New OleDb.OleDbConnection(Koneksi)
    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub TextBox3_TextChanged(sender As Object, e As EventArgs) Handles TextBox3.TextChanged

    End Sub

    Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Buttonsave.Click
        ObjKoneksi.Open()
        Dim tambah As String = "INSERT INTO kunjungan values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "') "
        Dim objCmd = New OleDbCommand(tambah, ObjKoneksi)
        objCmd.ExecuteNonQuery()
        ObjKoneksi.Close()
        MsgBox("Sukses")
    End Sub

    Protected Sub Buttonclear_Click(sender As Object, e As EventArgs) Handles Buttonclear.Click
        TextBox1.Text = ""
        TextBox2.Text = ""
        TextBox3.Text = ""
        TextBox4.Text = ""
        TextBox5.Text = ""
        TextBox6.Text = ""
        TextBox7.Text = ""
        TextBox8.Text = ""
        TextBox1.Focus()
    End Sub

    Protected Sub Button2_Click(sender As Object, e As EventArgs) Handles Button2.Click
        Response.Redirect("kunjungan_harian.aspx")
    End Sub
End Class


sourcecode form input data anggota

Imports System.Data
Imports System.Data.OleDb


Public Class form_input
    Inherits System.Web.UI.Page
    Dim Koneksi As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\semester 5\pak agus\tugas_uas\silabkom\silabkom\app\labkom1.accdb"
    Dim ObjKoneksi As New OleDb.OleDbConnection(Koneksi)

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

    End Sub

    Protected Sub TextBox1_TextChanged(sender As Object, e As EventArgs) Handles TextBox1.TextChanged

    End Sub

    Protected Sub Buttonsimpan_Click(sender As Object, e As EventArgs) Handles Buttonsimpan.Click
        ObjKoneksi.Open()
        Dim tambah As String = "INSERT INTO data_anggota values('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "') "
        Dim objCmd = New OleDbCommand(tambah, ObjKoneksi)
        objCmd.ExecuteNonQuery()
        ObjKoneksi.Close()
        MsgBox("Sukses")
    End Sub

    Private Function objekKoneksi() As Object
        Throw New NotImplementedException
    End Function

    Protected Sub Buttoncari_Click(sender As Object, e As EventArgs) Handles Buttoncari.Click

    End Sub

    Protected Sub Buttonclear_Click(sender As Object, e As EventArgs) Handles Buttonclear.Click
        TextBox1.Text = ""
        TextBox2.Text = ""
        TextBox3.Text = ""
        TextBox4.Text = ""
        TextBox5.Text = ""
        TextBox1.Focus()
    End Sub

    Protected Sub Buttonview_Click(sender As Object, e As EventArgs) Handles Buttonview.Click
        Response.Redirect("data_anggota.aspx")
    End Sub
End Class


sourcecode dashboard


<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="dashboard.aspx.vb" Inherits="silabkom.dashboard" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
    <style type="text/css">
        .auto-style1 {
            width: 100%;
        }
        .auto-style2 {
            width: 375px;
            height: 23px;
        }
        #form1 {
            background-color: #FFFF00;
        }
        .auto-style3 {
            text-align: center;
        }
        .auto-style4 {
            width: 375px;
            text-align: center;
        }
        .auto-style5 {
            height: 23px;
        }
    </style>
</head>
<body style="background-color: #FFFF00">
    <form id="form1" runat="server">
        <asp:Label ID="Label1" runat="server" BackColor="Yellow" BorderColor="Aqua" Height="50px" style="text-align: center; color: #0000FF; font-size: x-large; font-weight: 700; font-family: Cambria, Cochin, Georgia, Times, 'Times New Roman', serif" Text="SELAMAT DATANG DI LABORATORIUM KOMPUTER" Width="747px"></asp:Label>
    <div>
    
    </div>
        <asp:Label ID="Label2" runat="server" BackColor="Aqua" BorderColor="Blue" ForeColor="Black" style="border-style: inset; border-color: #0000FF; font-size: x-large; font-weight: 700; font-family: Cambria, Cochin, Georgia, Times, 'Times New Roman', serif" Text="DASHBOARD"></asp:Label>
        <table class="auto-style1" align="center">
            <tr>
                <td class="auto-style2"></td>
                <td class="auto-style5"></td>
            </tr>
            <tr>
                <td class="auto-style4">
                    <asp:Button ID="Buttondata" runat="server" style="border-style: inset; border-color: #0000FF; font-size: x-large; font-weight: 700; font-family: Cambria, Cochin, Georgia, Times, 'Times New Roman', serif; background-color: #00FFFF" Text="DATA ANGGOTA" Width="371px" />
                </td>
                <td class="auto-style3">
                    <asp:Button ID="Buttonkunjung" runat="server" style="border-style: inset; border-color: #0000FF; font-size: x-large; font-weight: 700; font-family: Cambria, Cochin, Georgia, Times, 'Times New Roman', serif; background-color: #66FFFF" Text="DATA KUNJUNGAN" Width="371px" />
                </td>
            </tr>
        </table>
    </form>
    <p>
        &nbsp;</p>
</body>
</html>



Senin, 05 November 2018

TUGAS UTS REKAYASA PERANGKAT LUNAK SISTEM INFORMASI LAB KOMPUTER



SISTEM INFORMASI LAB KOMPUTER

PROJECT SISTEM INFORMASI LAB KOMPUTER


NAMA MUKHLISOH
NIM : 161011700376


Aplilkasi Buku Tamu Pengunjung Lab Komputer

1.Analisa kebutuhan
  • Aplikasi ini berfungsi untuk memenuhi kebutuhan sistim informasi di suatu lab kumputer di salah satu sekolah:
  1. Menginput Data 
  2. Mengupdate Data
  3. Meng edit Data
  4. Menyimpan Data
  5. Menghapus Data 

 2.Perancangan (Desain)
     2.1 Perancangan Database
           1,Login User
              -User Name (Field: UserName, Teks, 50)
              -Password (Field: Password, Teks, 20, Key)
           2.tabel info
              -ID (Field: ID. Teks, 10)
              -nama (Field: nama. numerik, 50)
              -jenis kelamin (Field:jenkel. Teks, 20, Key)
              -kelas(Field: kelas. Teks, 10, Key)
              -keperluan (Field:keperluan. Teks, 100)
              -cari  (Field: cari. nimerik, 50)
             -tanggal (Field: tanggal. nimerik, 50)
             -jam (Field: jam. nimerik, 50)


         
2.Perancangan Desain form

          1. Form login

         

           2. Bukku Kunjungan 



      3. Sourcecode
            koneksi ke database dan view data

           Imports System.Data.OleDb

Public Class frmMain

    Dim dbconn As New OleDbConnection
    Dim adt As New OleDbDataAdapter
    Dim ds As New DataSet

    Dim datatable As New DataTable
    Dim cmd As New OleDbCommand

    Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        dbconn.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=..\db_project321.mdb"
        showData() 'show database values in datagridview
        customColumnWidth() ' set custom column width
    End Sub

    'Set customColumnWidth
    Private Sub customColumnWidth() ' set custom column width
        'datagridName.Columns(columnNumber or columnName)
        Dim columnID As DataGridViewColumn = dgvInfo.Columns(0)
        columnID.Width = 40 'set columnwidth
        Dim columnSurname As DataGridViewColumn = dgvInfo.Columns(1)
        columnSurname.Width = 100 'set columnwidth
    End Sub

    Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click        
        'Confirm dialogBox
        Dim dr As DialogResult
        dr = MessageBox.Show("Save information?", "Save", MessageBoxButtons.YesNo)
        If dr = DialogResult.No Then
            'NO CONDITION GOES HERE
        Else
            'YES CONDITION GOES HERE
            'Form restriction and validation
            If Len(Trim(txtjenkel.Text)) = 0 Then
                MessageBox.Show("Please enter Surname", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtjenkel.Focus()
            ElseIf Len(Trim(txtkelas.Text)) = 0 Then
                MessageBox.Show("Please enter Email", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtkelas.Focus()
            ElseIf Len(Trim(txtperlu.Text)) = 0 Then
                MessageBox.Show("Please enter Address", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtperlu.Focus()
            ElseIf Len(Trim(txtcari.Text)) = 0 Then
                MessageBox.Show("Please enter Contact No", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtcari.Focus()
            Else
                adt = New OleDbDataAdapter("insert into tbl_info (nama, jenkel, kelas, keperluan, cari, tanggal, jam) values ('" & Textnama.Text & "','" & txtjenkel.Text & "', '" & txtkelas.Text & "', '" & txtperlu.Text & "', '" & txtcari.Text & "', '" & Texttanggal.Text & "', '" & Textjam.Text & "')", dbconn)
                adt.Fill(ds)
                ds = New DataSet
                showData() ' refresh data in datagridview
                MsgBox("Saved")
                clearText() 'clear all text
            End If
        End If
    End Sub

    Private Sub showData()
        Dim dbcommand As String
        dbcommand = "SELECT * FROM tbl_info"
        adt = New OleDbDataAdapter(dbcommand, dbconn)
        datatable = New DataTable
        adt.Fill(datatable)
        dgvInfo.DataSource = datatable
    End Sub

    Private Sub btnFind_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
        Try
            Dim sql = "select * from tbl_info where id like " & txtid.Text & " "
            adt = New OleDbDataAdapter(sql, dbconn)
            cmd = New OleDbCommand(sql)
            adt.Fill(ds, "tbl_info")
            'ds.tables(tableName).rows(rowNumber)(columnNumber).tostring
            txtjenkel.Text = ds.Tables("tbl_info").Rows(0)(1).ToString
            txtkelas.Text = ds.Tables("tbl_info").Rows(0)(2).ToString
            txtperlu.Text = ds.Tables("tbl_info").Rows(0)(3).ToString
            txtcari.Text = ds.Tables("tbl_info").Rows(0)(4).ToString
            ds = New DataSet
        Catch ex As Exception
            MsgBox("No items match your search", MsgBoxStyle.Exclamation)
        End Try
    End Sub

    Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
        'Confirm dialogBox
        Dim dr As DialogResult
        dr = MessageBox.Show("Update information?", "Update", MessageBoxButtons.YesNo)
        If dr = DialogResult.No Then
            'NO CONDITION GOES HERE
        Else
            'YES CONDITION GOES HERE
            'Form restriction and validation
            If Len(Trim(txtjenkel.Text)) = 0 Then
                MessageBox.Show("Please enter Surname", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtjenkel.Focus()
            ElseIf Len(Trim(txtkelas.Text)) = 0 Then
                MessageBox.Show("Please enter Email", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtkelas.Focus()
            ElseIf Len(Trim(txtperlu.Text)) = 0 Then
                MessageBox.Show("Please enter Address", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtperlu.Focus()
            ElseIf Len(Trim(txtcari.Text)) = 0 Then
                MessageBox.Show("Please enter Contact No", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtcari.Focus()
            Else
                adt = New OleDbDataAdapter("update tbl_info set surname='" & txtjenkel.Text & "', email='" & txtkelas.Text & "', address='" & txtperlu.Text & "', contact_no='" & txtcari.Text & "'where id=" & txtid.Text & "", dbconn)
                adt.Fill(ds)
                ds = New DataSet
                showData() ' refresh data in datagridview
                MsgBox("Updated")
                clearText() 'clear all text
            End If
        End If
    End Sub

    Private Sub dgvInfo_CellClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgvInfo.CellClick
        Dim i As Integer
        i = dgvInfo.CurrentRow.Index
        'txtName = datagridName.Item(columnName or columnNumber, rowNumber).value.tostring
        txtid.Text = dgvInfo.Item(0, i).Value.ToString
        txtjenkel.Text = dgvInfo.Item(1, i).Value.ToString
        txtkelas.Text = dgvInfo.Item(2, i).Value.ToString
        txtperlu.Text = dgvInfo.Item(3, i).Value.ToString
        txtcari.Text = dgvInfo.Item(4, i).Value.ToString
    End Sub



    Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
        'Confirm dialogBox
        Dim dr As DialogResult
        dr = MessageBox.Show("Delete information?", "Delete", MessageBoxButtons.YesNo)
        If dr = DialogResult.No Then
            'NO CONDITION GOES HERE
        Else
            'YES CONDITION GOES HERE
            'Form restriction and validation
            If Len(Trim(txtjenkel.Text)) = 0 Then
                MessageBox.Show("Please enter Surname", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtjenkel.Focus()
            ElseIf Len(Trim(txtkelas.Text)) = 0 Then
                MessageBox.Show("Please enter Email", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtkelas.Focus()
            ElseIf Len(Trim(txtperlu.Text)) = 0 Then
                MessageBox.Show("Please enter Address", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtperlu.Focus()
            ElseIf Len(Trim(txtcari.Text)) = 0 Then
                MessageBox.Show("Please enter Contact No", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtcari.Focus()
            Else
                adt = New OleDbDataAdapter("delete surname='" & txtjenkel.Text & "', email='" & txtkelas.Text & "', address='" & txtperlu.Text & "', contact_no='" & txtcari.Text & "' from tbl_info where  id=" & txtid.Text & "", dbconn)
                adt.Fill(ds)
                ds = New DataSet
                showData() ' refresh data in datagridview
                MsgBox("Deleted")
                clearText() 'clear all text
            End If
        End If
    End Sub

    Sub clearText() 'clear all text
        txtid.Text = ""
        txtjenkel.Text = ""
        txtkelas.Text = ""
        txtperlu.Text = ""
        txtcari.Text = ""
        Texttanggal.Text = ""
        Textjam.Text = ""
    End Sub

    Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click
        'Confirm dialogBox
        Dim dr As DialogResult
        dr = MessageBox.Show("Clear text?", "Clear", MessageBoxButtons.YesNo)
        If dr = DialogResult.No Then
            'NO CONDITION GOES HERE
        Else
            'YES CONDITION GOES HERE
            clearText() 'clear all text
        End If
    End Sub

    Private Sub txtContact_no_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) 
        If (e.KeyChar < Chr(48) Or e.KeyChar > Chr(57)) And e.KeyChar <> Chr(8) Then
            e.Handled = True
        End If
    End Sub

    Private Sub txtID_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) 
        If (e.KeyChar < Chr(48) Or e.KeyChar > Chr(57)) And e.KeyChar <> Chr(8) Then
            e.Handled = True
        End If
    End Sub
    'copyright © 2017 ITGeekSolutions

    Private Sub txtID_TextChanged(sender As Object, e As EventArgs) Handles txtid.TextChanged

    End Sub

    Private Sub txtSurname_TextChanged(sender As Object, e As EventArgs) Handles txtjenkel.TextChanged

    End Sub

    Private Sub Label7_Click(sender As Object, e As EventArgs) Handles Label7.Click

    End Sub

    Private Sub GroupBox2_Enter(sender As Object, e As EventArgs) Handles GroupBox2.Enter

    End Sub

    Private Sub dgvInfo_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles dgvInfo.CellContentClick

    End Sub
    
    Private Sub Label6_Click(sender As Object, e As EventArgs) Handles Label6.Click

    End Sub


    Private Sub txtkelas_TextChanged(sender As Object, e As EventArgs) Handles txtkelas.TextChanged

    End Sub

    Private Sub TextBox1_TextChanged(sender As Object, e As EventArgs) Handles Textnama.TextChanged

    End Sub
End Class



form login :


Imports System.Data.OleDb

Public Class frmLogin

    Private Sub loginUser()
        If Len(Trim(txtUsername.Text)) = 0 Then
            MessageBox.Show("Please enter user name", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
            txtUsername.Focus()
            Exit Sub
        End If
        If Len(Trim(txtPassword.Text)) = 0 Then
            MessageBox.Show("Please enter password", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
            txtPassword.Focus()
            Exit Sub
        End If
        Try
            Dim myConnection As OleDbConnection
            myConnection = New OleDbConnection("Provider=Microsoft.JET.OLEDB.4.0;Data Source=..\db_project321.mdb;Persist Security Info=false;")

            Dim myCommand As OleDbCommand

            myCommand = New OleDbCommand("SELECT user_name,pass_word FROM tbl_user WHERE user_name = @user_name AND pass_word = @pass_word", myConnection)

            Dim uName As New OleDbParameter("@user_name", SqlDbType.VarChar)

            Dim uPassword As New OleDbParameter("@pass_word", SqlDbType.VarChar)

            uName.Value = txtUsername.Text

            uPassword.Value = txtPassword.Text

            myCommand.Parameters.Add(uName)

            myCommand.Parameters.Add(uPassword)

            myCommand.Connection.Open()

            Dim myReader As OleDbDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

            Dim Login As Object = 0

            If myReader.HasRows Then

                myReader.Read()

                Login = myReader(Login)

            End If

            If Login = Nothing Then

                MsgBox("Login is Failed...Try again !", MsgBoxStyle.Critical, "Login Denied")
                txtUsername.Clear()
                txtPassword.Clear()
                txtUsername.Focus()

            Else
                MsgBox("Successfully Login", MsgBoxStyle.Information)
                txtUsername.Text = ""
                txtPassword.Text = ""
                Me.Hide()
                frmMain.Show()

            End If

            myCommand.Dispose()
            myConnection.Close()

        Catch ex As Exception
            MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
        End Try
    End Sub

    Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click
        loginUser()
    End Sub

    Private Sub txtUsername_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtUsername.KeyPress
        If Asc(e.KeyChar) = 13 Then
            loginUser() ' or form2.show whatever you form name is
        End If
    End Sub

    Private Sub txtPassword_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtPassword.KeyPress
        If Asc(e.KeyChar) = 13 Then
            loginUser() ' or form2.show whatever you form name is
        End If
    End Sub
    'copyright © 2017 ITGeekSolutions

    Private Sub frmLogin_Load(sender As Object, e As EventArgs) Handles MyBase.Load

    End Sub
End Class


form main :

Imports System.Data.OleDb

Public Class frmMain

    Dim dbconn As New OleDbConnection
    Dim adt As New OleDbDataAdapter
    Dim ds As New DataSet

    Dim datatable As New DataTable
    Dim cmd As New OleDbCommand

    Private Sub frmMain_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        dbconn.ConnectionString = "provider=microsoft.jet.oledb.4.0;data source=..\db_project321.mdb"
        showData() 'show database values in datagridview
        customColumnWidth() ' set custom column width
    End Sub

    'Set customColumnWidth
    Private Sub customColumnWidth() ' set custom column width
        'datagridName.Columns(columnNumber or columnName)
        Dim columnID As DataGridViewColumn = dgvInfo.Columns(0)
        columnID.Width = 40 'set columnwidth
        Dim columnSurname As DataGridViewColumn = dgvInfo.Columns(1)
        columnSurname.Width = 100 'set columnwidth
    End Sub

    Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click        
        'Confirm dialogBox
        Dim dr As DialogResult
        dr = MessageBox.Show("Save information?", "Save", MessageBoxButtons.YesNo)
        If dr = DialogResult.No Then
            'NO CONDITION GOES HERE
        Else
            'YES CONDITION GOES HERE
            'Form restriction and validation
            If Len(Trim(txtjenkel.Text)) = 0 Then
                MessageBox.Show("Please enter Surname", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtjenkel.Focus()
            ElseIf Len(Trim(txtkelas.Text)) = 0 Then
                MessageBox.Show("Please enter Email", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtkelas.Focus()
            ElseIf Len(Trim(txtperlu.Text)) = 0 Then
                MessageBox.Show("Please enter Address", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtperlu.Focus()
            ElseIf Len(Trim(txtcari.Text)) = 0 Then
                MessageBox.Show("Please enter Contact No", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtcari.Focus()
            Else
                adt = New OleDbDataAdapter("insert into tbl_info (nama, jenkel, kelas, keperluan, cari, tanggal, jam) values ('" & Textnama.Text & "','" & txtjenkel.Text & "', '" & txtkelas.Text & "', '" & txtperlu.Text & "', '" & txtcari.Text & "', '" & Texttanggal.Text & "', '" & Textjam.Text & "')", dbconn)
                adt.Fill(ds)
                ds = New DataSet
                showData() ' refresh data in datagridview
                MsgBox("Saved")
                clearText() 'clear all text
            End If
        End If
    End Sub

    Private Sub showData()
        Dim dbcommand As String
        dbcommand = "SELECT * FROM tbl_info"
        adt = New OleDbDataAdapter(dbcommand, dbconn)
        datatable = New DataTable
        adt.Fill(datatable)
        dgvInfo.DataSource = datatable
    End Sub

    Private Sub btnFind_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
        Try
            Dim sql = "select * from tbl_info where id like " & txtid.Text & " "
            adt = New OleDbDataAdapter(sql, dbconn)
            cmd = New OleDbCommand(sql)
            adt.Fill(ds, "tbl_info")
            'ds.tables(tableName).rows(rowNumber)(columnNumber).tostring
            txtjenkel.Text = ds.Tables("tbl_info").Rows(0)(1).ToString
            txtkelas.Text = ds.Tables("tbl_info").Rows(0)(2).ToString
            txtperlu.Text = ds.Tables("tbl_info").Rows(0)(3).ToString
            txtcari.Text = ds.Tables("tbl_info").Rows(0)(4).ToString
            ds = New DataSet
        Catch ex As Exception
            MsgBox("No items match your search", MsgBoxStyle.Exclamation)
        End Try
    End Sub

    Private Sub btnUpdate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnUpdate.Click
        'Confirm dialogBox
        Dim dr As DialogResult
        dr = MessageBox.Show("Update information?", "Update", MessageBoxButtons.YesNo)
        If dr = DialogResult.No Then
            'NO CONDITION GOES HERE
        Else
            'YES CONDITION GOES HERE
            'Form restriction and validation
            If Len(Trim(txtjenkel.Text)) = 0 Then
                MessageBox.Show("Please enter Surname", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtjenkel.Focus()
            ElseIf Len(Trim(txtkelas.Text)) = 0 Then
                MessageBox.Show("Please enter Email", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtkelas.Focus()
            ElseIf Len(Trim(txtperlu.Text)) = 0 Then
                MessageBox.Show("Please enter Address", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtperlu.Focus()
            ElseIf Len(Trim(txtcari.Text)) = 0 Then
                MessageBox.Show("Please enter Contact No", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtcari.Focus()
            Else
                adt = New OleDbDataAdapter("update tbl_info set surname='" & txtjenkel.Text & "', email='" & txtkelas.Text & "', address='" & txtperlu.Text & "', contact_no='" & txtcari.Text & "'where id=" & txtid.Text & "", dbconn)
                adt.Fill(ds)
                ds = New DataSet
                showData() ' refresh data in datagridview
                MsgBox("Updated")
                clearText() 'clear all text
            End If
        End If
    End Sub

    Private Sub dgvInfo_CellClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dgvInfo.CellClick
        Dim i As Integer
        i = dgvInfo.CurrentRow.Index
        'txtName = datagridName.Item(columnName or columnNumber, rowNumber).value.tostring
        txtid.Text = dgvInfo.Item(0, i).Value.ToString
        txtjenkel.Text = dgvInfo.Item(1, i).Value.ToString
        txtkelas.Text = dgvInfo.Item(2, i).Value.ToString
        txtperlu.Text = dgvInfo.Item(3, i).Value.ToString
        txtcari.Text = dgvInfo.Item(4, i).Value.ToString
    End Sub



    Private Sub btnDelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDelete.Click
        'Confirm dialogBox
        Dim dr As DialogResult
        dr = MessageBox.Show("Delete information?", "Delete", MessageBoxButtons.YesNo)
        If dr = DialogResult.No Then
            'NO CONDITION GOES HERE
        Else
            'YES CONDITION GOES HERE
            'Form restriction and validation
            If Len(Trim(txtjenkel.Text)) = 0 Then
                MessageBox.Show("Please enter Surname", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtjenkel.Focus()
            ElseIf Len(Trim(txtkelas.Text)) = 0 Then
                MessageBox.Show("Please enter Email", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtkelas.Focus()
            ElseIf Len(Trim(txtperlu.Text)) = 0 Then
                MessageBox.Show("Please enter Address", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtperlu.Focus()
            ElseIf Len(Trim(txtcari.Text)) = 0 Then
                MessageBox.Show("Please enter Contact No", "Input Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
                txtcari.Focus()
            Else
                adt = New OleDbDataAdapter("delete surname='" & txtjenkel.Text & "', email='" & txtkelas.Text & "', address='" & txtperlu.Text & "', contact_no='" & txtcari.Text & "' from tbl_info where  id=" & txtid.Text & "", dbconn)
                adt.Fill(ds)
                ds = New DataSet
                showData() ' refresh data in datagridview
                MsgBox("Deleted")
                clearText() 'clear all text
            End If
        End If
    End Sub

    Sub clearText() 'clear all text
        txtid.Text = ""
        txtjenkel.Text = ""
        txtkelas.Text = ""
        txtperlu.Text = ""
        txtcari.Text = ""
        Texttanggal.Text = ""
        Textjam.Text = ""
    End Sub

    Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click
        'Confirm dialogBox
        Dim dr As DialogResult
        dr = MessageBox.Show("Clear text?", "Clear", MessageBoxButtons.YesNo)
        If dr = DialogResult.No Then
            'NO CONDITION GOES HERE
        Else
            'YES CONDITION GOES HERE
            clearText() 'clear all text
        End If
    End Sub

    Private Sub txtContact_no_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) 
        If (e.KeyChar < Chr(48) Or e.KeyChar > Chr(57)) And e.KeyChar <> Chr(8) Then
            e.Handled = True
        End If
    End Sub

    Private Sub txtID_KeyPress(ByVal sender As System.Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) 
        If (e.KeyChar < Chr(48) Or e.KeyChar > Chr(57)) And e.KeyChar <> Chr(8) Then
            e.Handled = True
        End If
    End Sub
    'copyright © 2017 ITGeekSolutions

    Private Sub txtID_TextChanged(sender As Object, e As EventArgs) Handles txtid.TextChanged

    End Sub

    Private Sub txtSurname_TextChanged(sender As Object, e As EventArgs) Handles txtjenkel.TextChanged

    End Sub

    Private Sub Label7_Click(sender As Object, e As EventArgs) Handles Label7.Click

    End Sub

    Private Sub GroupBox2_Enter(sender As Object, e As EventArgs) Handles GroupBox2.Enter

    End Sub

    Private Sub dgvInfo_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles dgvInfo.CellContentClick

    End Sub
    
    Private Sub Label6_Click(sender As Object, e As EventArgs) Handles Label6.Click

    End Sub


    Private Sub txtkelas_TextChanged(sender As Object, e As EventArgs) Handles txtkelas.TextChanged

    End Sub

    Private Sub TextBox1_TextChanged(sender As Object, e As EventArgs) Handles Textnama.TextChanged

    End Sub

    Private Sub GroupBox1_Enter(sender As Object, e As EventArgs) Handles GroupBox1.Enter

    End Sub
End Class


Berikut tugas rekayasa perangkat lunak ini saya upload semoga mendapat nilai A dan semoga bermanfaat Terimakasih





    


Share