PEMANFAATAN KONTROL DEVEXPRESS PADA ASP.NET (STUDI KASUS APLIKASI WEB GAGAPAN BALIKOE)
TUGAS AKHIR
Disusun sebagai salah satu syarat kelulusan Program Studi Strata 1
oleh : I MADE ARDI SISKAYANA NRP : 11.304.0274
PROGRAM STUDI TEKNIK INFORMATIKA FAKULTAS TEKNIK UNIVERSITAS PASUNDAN BANDUNG 2014
KATA PENGANTAR
Om Swastiastu, Puji syukur atas kehadirat Tuhan Yang Maha Esa yang telah melimpahkan Anugrah dan karunia-Nya sehingga penulis dapat menyelesaikan Tugas Akhir dengan judul “Eksplorasi Kontrol Devexpress Pada ASP.NET (Studi Kasus Aplikasi Web Gagapan Balikoe)” sebagai persyaratan kelulusan meraih gelar Strata 1 pada jurusan Teknik Informatika Fakultas Teknik Universitas Pasundan Bandung. Tidak kurang hambatan dan keraguan serta suka dan duka yang dialami selama proses pembangunan dan penyusunan laporan ini. Namun hambatan dan keraguan itu pada akhirnya dapat dijalani tanpa suatu halangan apapun, atas ridha dan izin-Nya, sehingga dapat terselesaikan pada waktunya. Dalam pembangunan dan penyusunan laporan ini penulis yakin bahwa laporan ini tidak akan selesai tanpa do’a, bimbingan, petunjuk dan dorongan dari semua pihak. Maka dengan kerendahan hati perkenankanlah penulis menyampaikan rasa terima kasih kepada : 1. Orang tua dan keluarga yang telah membantu dengan doa dan dukungannya secara moril maupun materi. 2. Ibu Hj. Ir. Ririn Dwi Agustin, MT., selaku Ketua Jurusan Teknik Informatika. 3. Ibu Ayi Purbasari S.T., selaku Pembimbing I dan Bapak Hendra Komara S.T., selaku Pembimbing II yang telah banyak membantu dan mengarahkan penulis dalam menyelesaikan tugas akhir ini. 4. Bapak Sali Alas Majapahit, S.ST., sebagai Koordinator Pelaksana Tugas Akhir. 5. Seluruh dosen dan staf Teknik Informatika Universitas Pasundan Bandung. 6. Teman-teman Jurusan Teknik Informatika dan semua pihak yang tidak bisa disebutkan satu persatu yang telah memberikan dukungan dan bantuan berupa saran dan ide-ide, doa, motivasi. Semoga Tuhan Yang Maha Esa selalu memberikan Anugrah dan Pelindungnya kepada kita semua. Penulis menyadari sepenuhnya bahwa pembangunan dan penyusunan laporan ini masih jauh dari sempurna karena keterbatasan pengetahuan, oleh karena itu dengan segala kerendahan hati penulis mengharapkan saran dan kritik yang memabangun untuk kemajuan dari semua pihak. Semoga laporan ini dapat bermanfaat bagi penulis maupun bagi para pembaca.
Bandung,
ii
Agustus 2014
DAFTAR ISI
Abstrak .....................................................................................................................................
i
Kata Pengantar ........................................................................................................................
ii
Daftar Isi ..................................................................................................................................
iii
Daftar Gambar .........................................................................................................................
v
Daftar Tabel .............................................................................................................................
vii
Daftar Simbol ..........................................................................................................................
ix
BAB I PENDAHULUAN ........................................................................................................
I-1
1.1 Latar Belakang ..............................................................................................................
I-1
1.2 Identifikasi Masalah ......................................................................................................
I-2
1.3 Tujuan ...........................................................................................................................
I-3
1.4 Batasan Masalah............................................................................................................
I-3
1.5 Metodologi Penelitian ..................................................................................................
I-3
1.6 Sistematika Penulisan....................................................................................................
I-5
BAB II LANDASAN TEORI…………………………...........................................................
II-1
2.1 ASP.NET ………………………………… ..................................................................
II-1
2.1.1 Versi ASP.NET ...................................................................................................
II-1
2.1.2 ASP.NET Kontrol ...............................................................................................
II-1
2.1.3 Siklus Hidup ASP.NET .......................................................................................
II-2
2.1.4 ASP.NET AJAX .................................................................................................
II-2
2.2 Third Party ....................................................................................................................
II-2
2.3 DevExpress ...................................................................................................................
II-4
2.3.1 Keunggulan DevExpress .....................................................................................
II-4
2.3.2 Persyaratan Instalasi DevExpress ........................................................................
II-4
2.3.3 Konsep Dasar DevExpress pada ASP.NET .........................................................
II-5
2.4 CRUD ...........................................................................................................................
II-8
iii
BAB III ANALISIS KEBUTUHAN KONTROL DAN PERBANDINGAN ...................... .
III-1
3.1 Tinjauan Perangkat dan Kontrol ...................................................................................
III-1
3.1.1 Tinjauan Perangkat ..............................................................................................
III-1
3.1.1 Tinjauan Kontrol .................................................................................................
III-2
3.2 Instalasi DevExpress .....................................................................................................
III-3
3.2.1 Register DevExpress pada ASP.NET ...................................................................
III-4
3.3.Kebutuhan Kontrol Perbandingan ................................................................................
III-5
3.4 Proses Perbandingan .....................................................................................................
III-11
3.5 Hasil Perbandingan .......................................................................................................
III-11
BAB IV STUDI KASUS ..........................................................................................................
IV-1
4.1 Analisis Perangkat Lunak .............................................................................................
IV-1
4.1.1 Fungsi Utama Perangkat Lunak ..........................................................................
IV-1
4.1.2 Diagram Use Case ...............................................................................................
IV-3
4.1.2.1 Skenario Use Case ..................................................................................
IV-4
4.1.3 Diagram Kelas .....................................................................................................
IV-8
4.2 Rancangan Database .....................................................................................................
IV-9
4.3 Perancangan Antarmuka ...............................................................................................
IV-11
4.4 Implementasi DevExpress Kontrol ...............................................................................
IV-17
4.4.1 Pustaka DevExpress Kontrol ...............................................................................
IV-17
4.5 Implementasi Antarmuka ..............................................................................................
IV-19
BAB V KESIMPULAN DAN SARAN ..................................................................................
V-1
5.1 Kesimpulan ...................................................................................................................
V-1
5.2 Saran .............................................................................................................................
V-2
DAFTAR PUSTAKA
iv
DAFTAR GAMBAR
Gambar 1.2 Diagram Penyusunan Tugas Akhir ........................................................................
I-4
Gambar 3.1 DevExpress pada IDE Visual Basic 2010 .............................................................
III-3
Gambar 3.2 Kontrol DevExpress pada toolbox IDE Visual basic 2010 ....................................
III-4
Gambar 3.3 tambah pustaka .dll DevExpress di reference ........................................................
III-4
Gambar 3.4 tampilan button control .........................................................................................
III-6
Gambar 3.5 jenis TextBox ........................................................................................................
III-6
Gambar 3.6 tampilan DropDownList kontrol ...........................................................................
III-7
Gambar 3.7 tampilan CheckBox Kontrol ..................................................................................
III-7
Gambar 3.8 Tampilan radio button kontrol ...............................................................................
III-7
Gambar 3.9 Tampilan NumericUpDown kontroL ....................................................................
III-7
Gambar 3.10 Variasi RequireField Validasi .............................................................................
III-8
Gambar 3.11 Calendar Extender ...............................................................................................
III-8
Gambar 3.12 GridView shorting dan paging .............................................................................
III-9
Gambar 3.13 GridView dengan filtering ...................................................................................
III-9
Gambar 3.14 Edit Form di gridview .........................................................................................
III-10
Gambar 3.15 Kolom Chart ........................................................................................................
III-10
Gambar 3.16 Menu Chart Task ASP.NET .................................................................................
III-29
Gambar 3.17 Menu WebChartControl Task ..............................................................................
III-29
Gambar 3.18 Menu Run Wizard Chart DevExpress ..................................................................
III-30
Gambar 3.19 Kelas Convert ke file .xls (GridViewExportUtil.cs) ............................................
III-30
Gambar 3.20 Tampilan form untuk convert data ke dokument .xls ...........................................
III-31
Gambar 3.21 Hasil Eksport .xls (microsoft Excel). ...................................................................
III-31
Gambar 3.22 Instalaer kelas dan .dll NPOI ................................................................................
III-31
Gambar 3.23 Kode Kontrol Report viewer DevExpress ............................................................
III-32
Gambar 3.24 Tampilan Form report dengan Kontrol DevExpress Reportviewer......................
III-32
Gambar 3.25 Hasil Eksport .xls (microsoft Excel) dari DevExpress .........................................
III-32
Gambar 4.1 Use Case Diagram Inventori .................................................................................
IV-3
v
Gambar 4.2 Diagram Kelas Inventori Gagapan Balikoe ............................................................
IV-8
Gambar 4.3 Rancangan Tabel tb_master_barang ......................................................................
IV-9
Gambar 4.3 Rancangan Tabel tb_master_jenisbrg ....................................................................
IV-9
Gambar 4.4 Rancangan Tabel tb_master_brgsupplier ..............................................................
IV-9
Gambar 4.5 Rancangan Tabel tb_master_jenis_kelamin ..........................................................
IV-9
Gambar 4.6 Rancangan Tabel tb_master_karyawan .................................................................
IV-10
Gambar 4.7 Rancangan Tabel tb_master_supplier ....................................................................
IV-10
Gambar 4.8 Rancangan Tabel tb_order_barang ........................................................................
IV-10
Gambar 4.9 Rancangan Interface Kelola Data Master Barang .................................................
IV-11
Gambar 4.10 Rancangan Interface Kelola Data Jenis Barang ..................................................
IV-12
Gambar 4.11 Rancangan Interface Kelola Data Master Barang Supplier .................................
IV-12
Gambar 4.12 Rancangan Interface Kelola Data Master Supplier .............................................
IV-13
Gambar 4.13 Rancangan Interface Kelola Data Master Karyawan ..........................................
IV-14
Gambar 4.14 Rancangan Interface Kelola Data Order Barang .................................................
IV-15
Gambar 4.15 Rancangan Interface Kelola Data Barang Masuk.................................................
IV-16
Gambar 4.16 Alur implementasi Kelola Data Barang Masuk....................................................
IV-17
Gambar 4.17 Pustaka reference DevExpress pada Gagapan Balikoe ........................................
IV-18
Gambar 4.18 Daftar Kontrol DevExpress Aplikasi Gagapan Balikoe .......................................
IV-18
Gambar 4.19 Tampilan Antar Muka Kelola Data Jenis Barang .................................................
IV-19
Gambar 4.20 Tampilan Antar Muka Kelola Data Master Barang..............................................
IV-19
Gambar 4.21 Tampilan Antar Muka Kelola Data Master Supplier............................................
IV-20
Gambar 4.22 Tampilan Antar Muka Kelola Data Barang Supplier ...........................................
IV-20
Gambar 4.23 Tampilan Antar Muka Kelola Order Barang ........................................................
IV-21
Gambar 4.24 Tampilan Antar Muka Kelola Barang Masuk ......................................................
IV-21
Gambar 4.25 Tampilan Antar Muka Kelola Data Master Karyawan .........................................
IV-22
vi
DAFTAR TABEL
Tabel 2.1 siklus hidup ASP.NET ....................................................................................
II-2
Tabel 2.2 pemetaan CRUD pada SQL dan HTTP ...........................................................
II-8
Table 3.1 Hasil Perbandingan Tampilan Kontrol Button ...............................................
III-11
Tabel 3.2 Perbandingan Kode Kontrol Button ................................................................
III-12
Tabel 3.3 Perbandingan Tahap Konstruksi Kontrol Button ............................................
III-12
Table 3.4 Hasil Perbandingan Tampilan Kontrol TextBox .............................................
III-13
Tabel 3.5 Perbandingan Kode Kontrol Textbox .............................................................
III-14
Tabel 3.6 Perbandingan Tahap Konstruksi Kontrol Textbox ..........................................
III-14
Table 3.7 Hasil Perbandingan Tampilan Kontrol CheckBox ..........................................
III-15
Tabel 3.8 Perbandingan Kode Kontrol CheckBox ..........................................................
III-15
Tabel 3.9 Perbandingan Tahap Konstruksi Kontrol Checkbox .......................................
III-15
Table 3.10 Perbandingan Tampilan Kontrol Radio Button ............................................
III-16
Tabel 3.11 Perbandingan Kode Kontrol Radio Button ...................................................
III-16
Tabel 3.12 Perbandingan Tahap Konstruksi Kontrol Radio Button ................................
III-17
Table 3.13 Perbandingan Tampilan Kontrol Calendar Extender ....................................
III-17
Tabel 3.14 Perbandingan Kode Kontrol Calendar Extender ...........................................
III-18
Tabel 3.15 Perbandingan tahap konstruksi kontrol Calendar Extender ..........................
III-18
Table 3.16 Perbandingan Kontrol Require Field Validasi ..............................................
III-19
Tabel 3.17 Perbandingan Kode Kontrol Require Field Validasi .....................................
III-19
Tabel 3.18 Perbandingan tahap konstruksi kontrol Require Field Validasi ....................
III-20
Table 3.19 Perbandingan Tampilan Kontrol Numeric Up Down ....................................
III-20
Tabel 3.20 Perbandingan Kode Kontrol Numeric Up Down ..........................................
III-21
Tabel 3.21 Perbandingan tahap konstruksi kontrol Numeric Up Down .........................
III-21
Table 3.22 Hasil Perbandingan Tampilan Kontrol ComboBox ......................................
III-22
Tabel 3.23 Perbandingan Kode Kontrol ComboBox .......................................................
III-22
Tabel 3.24 Perbandingan tahap konstruksi kontrol ComboBox .......................................
III-23
Table 3.25 Hasil Perbandingan Tampilan Kontrol Gridview Paging Shorting ...............
III-23
vii
Tabel 3.26 Perbandingan kode Gridview Paging Shorting .............................................
III-24
Tabel 3.27 Perbandingan tahap konstruksi kontrol Gridview Paging Shorting ..............
III-25
Table 3.28 Hasil Perbandingan Tampilan Kontrol Gridview Filtering ...........................
III-25
Tabel 3.29 Perbandingan kode Gridview Filtering .........................................................
III-26
Tabel 3.30 Perbandingan tahap konstruksi kontrol Gridview Filtering ..........................
III-26
Table 3.31 Perbandingan tampilan Edit data dalam Grid ...............................................
III-27
Tabel 3.32 Perbandingan kode Edit data dalam Grid ......................................................
III-27
Tabel 3.33 Perbandingan tahap konstruksi kontrol Gridview Edit data dalam Grid........
III-28
Tabel 4.1 Definisi Use Case ............................................................................................
IV-4
Table 4.2 Skenario Use Case Kelolad Data Karyawan ....................................................
IV-4
Table 4.3 Skenario Use Case Kelola Order Barang ........................................................
IV-5
Table 4.4 Skenario Use Case Kelola Data Barang ..........................................................
IV-5
Table 4.5 Skenario Use Case Kelola Data Supplier ........................................................
IV-6
Table 4.6 Skenario Use Case Kelola Data Jenis Barang .................................................
IV-6
Table 4.7 Skenario Use Case Kelola Data Barang Supplier ...........................................
IV-7
Table 4.8 Skenario Use Case Kelola Data Barang Masuk ..............................................
IV-7
Tabel 4.9 Kontrol DevExpress Form Kelola Master Data Barang ...................................
IV-11
Tabel 4.10 Kontrol DevExpress Form Kelola Master Data Jenis Barang ........................
IV-12
Tabel 4.11 Kontrol DevExpress Form Kelola Data Barang Supplier ..............................
IV-13
Tabel 4.12 Kontrol DevExpress Form Kelola Data Barang Supplier ..............................
IV-13
Tabel 4.13 Kontrol DevExpress Form Kelola Data Master Karyawan ............................
IV-14
Tabel 4.14 Kontrol DevExpress Form Kelola Data Order Barang ..................................
IV-15
Tabel 4.15 Kontrol DevExpress Form Kelola Data Barang Masuk .................................
IV-16
viii
DAFTAR SIMBOL
NO
SIMBOL
KETERANGAN
1.
Proses yang dilakukan dengan bantuan komputer Process
2
Penghubung antar simbol Connector
3
Simbol untuk referensi dari step sebelumnya
4.
Simbol untuk menyatakan aktor
System
Kelola Barang Masuk
5
user gudang
Simbol untuk mentakan usecase
UseCase
Kelola Order Barang
6
Simbol untuk menyatakan classKelola Karyawan Class
Kelola jenis Barang
Kelola Data supplier user Pengadaan Kelola Data Barang
Kelola Barang Supplier
ix
admin
