makalah pv e aplikasi toko komputer

8/13/2019 Makalah PV E Aplikasi Toko Komputer

http://slidepdf.com/reader/full/makalah-pv-e-aplikasi-toko-komputer 1/56

TUGAS RANCANG PV

DESAIN APLIKASI TOKO KOMPUTER

OLEH :

PETER DEO S (672012152)

MICHAEL C (672012157)

VANDI ANDREAS S (672012201)

GILANG SHANDY R (702012046)

FAKULTAS TEKNOLOGI INFORMASI

UNIVERSITAS KRISTEN SATYA WACANA

SALATIGA

2013



BAB I

PENDAHULUAN

1. Latar Belakang Masalah

Di era global seperti ini, teknologi semakin canggih penggunaan

komputer merupakan kebutuhan dari setiap segi kehidupan manusia.

Setiap pekerjaan manusia pasti berhubungan dengan komputer hal tersebut

diharapkan agar suatu pekerjaan dapat menjadi lebih efisien. Sebagai

contoh system yang ada pada pertokoan baik dibagian administrasi, stok barang, penggunaan sumber daya dan lain-lain.

Disini kita membuat suatu desain yang berhubungan dengan

system toko komputer yang diharapkan dapat membatu meringankan

pekerjaan pada toko tersebut. Pada system kita mencakup system transaksi

penjualan barang, pengecekan stock barang, pegawai, supplier barang,

serta system pembukuannya.

2. Tujuan

1. Belajar membuat aplikasi toko komputer.

2. Menambah pengetahuan serta pengalaman.

3. Sebagai tugas akhir mata kuliah pemprogaman visual.



BAB II

PEMBAHASAN

1. Sistematika Pembuatan Apliksi Toko Komputer

1. Pembuatan ERD

Langkah awal sebelum kita membuat aplikasi toko komputer kita

membuat ERDnya terlebih dahulu, supaya lebih terstuktur dalam perancangan sistemnya.

Berikut ERD yang kita buat :



2. Pembuatan Data Base

1. Tabel Barang

2. Tabel Data Penjualan

3. Tabel Gudang



4. Tabel Pegawai

5. Tabel Penjualan

6. Tabel Supplier



7. Selanjutnya setelah mengisi data, maka kita sekarang akan

membuat relasi dari table ke table. Seperti pada gambar di bawah

ini.

8.

tb_baranag

tb_penjualantb_supp

tb_pegawai

tb_detpenjualan



3. Permbuatan Form dan Koneksi Data Base

1. Pembuatan Form

1. Form Utama

2. Form Barang

3. Form Detail Penjualan



4. Form Pegawai

5. Form Penjualan

6. Form Supplier

2. Koneksi Data Base

1. Class Koneksi

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;



using System.Data;

using System.Windows.Forms;

using MySql.Data;

using MySql.Data.MySqlClient;

using System.Data.SqlClient;

namespace koneksi

{

public class Command

{

public MySqlConnection conn = null;

public MySqlDataAdapter adapter = null;

public MySqlCommand cmd = null;

public DataSet DS = null;

public MySqlDataReader reader = null;

public Boolean ins;

public void bukaKoneksi()

{

string connStr =

"server=localhost;user=root;database=db_toko;password=;"

;

conn = new MySqlConnection(connStr);

try

{

conn.Open();}

catch (Exception ex)

{

MessageBox.Show("Koneksi gagal ; " +

ex.Message);

Application.Exit();

}

}

public void tutupKoneksi()

{ conn.Close();

}

public DataTable GetItem(String query)

{

bukaKoneksi();

DS = new DataSet();

try

{

adapter = new MySqlDataAdapter(query, conn);

adapter.Fill(DS);



}


{

MessageBox.Show("Error : " + ex);

}tutupKoneksi();

return DS.Tables[0];

}

public void Insert(String query)

{

bukaKoneksi();

try

{

MySqlCommand cmdsql = new

MySqlCommand(query, conn);int result = cmdsql.ExecuteNonQuery();

MessageBox.Show("Data Berhasil Diinput",

"Simpan", MessageBoxButtons.OK,

MessageBoxIcon.Information);

}


{


}

tutupKoneksi();}

public void Update(String query)

{

bukaKoneksi();

try

{

MySqlCommand cmdsql = new

MySqlCommand(query, conn);

int result = cmdsql.ExecuteNonQuery();

conn.Close();MessageBox.Show("Data Berhasil Diedit",

"Edit", MessageBoxButtons.OK,


}


{


}

tutupKoneksi();

}



public void Delete(String query)

{

bukaKoneksi();

try

{MySqlCommand cmdsql = new

MySqlCommand(query, conn);

int result = cmdsql.ExecuteNonQuery();

conn.Close();

MessageBox.Show("Data Berhasil Dihapus",

"Delete", MessageBoxButtons.OK,


}


{

MessageBox.Show("Error : " + ex);}

tutupKoneksi();

}

public int count(String query)

{

bukaKoneksi();

MySqlDataReader recordset = null;

int jumlah = 0;

try{

cmd = new MySqlCommand(query, conn);

recordset = cmd.ExecuteReader();

if (recordset.Read())

{

jumlah = 1;

}

}


{


tutupKoneksi();

return jumlah;

}

public List<string> loadData(String query)

{

bukaKoneksi();

List<string> list = new List<string>();

try

{



cmd = new MySqlCommand(query, conn);

reader = cmd.ExecuteReader();

reader.Read();

for (int i = 0; i < reader.FieldCount; i++)

{list.Add(reader[i] + "");

}

}


{


}

tutupKoneksi();

return list;

}

}}

2. Class Barang

using System;


using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;using System.Text;



namespace frmutama

{

public partial class frmbrg : Form

{

string MyConnect ="server=localhost;user=root;database=db_toko;password=;"

;

Class comd = new Class();

List<string> list;

public frmbrg()

{

InitializeComponent();

load();

loadCombo();

}



public void load()

{

MySqlConnection connection = new

MySqlConnection(MyConnect);connection.Open();

try

{

MySqlCommand per =

connection.CreateCommand();

per.CommandText = "select * from tb_brg";

MySqlDataAdapter adp = new

MySqlDataAdapter(per);

DataSet data = new DataSet();

adp.Fill(data);dgv3.DataSource = data.Tables[0].DefaultView;

}

catch (Exception)

{

throw;

}

finally

{if (connection.State == ConnectionState.Open)

{

connection.Clone();

}

}

}

public void loadCombo()

{

MySqlCommand perintah = null;

MySqlConnection koneksi = new

MySqlConnection(MyConnect);

koneksi.Open();

perintah = new MySqlCommand();

perintah.Connection = koneksi;

perintah.CommandType = CommandType.Text;

perintah.CommandText = "select kode_supp from

tb_supp";

MySqlDataReader reader =

perintah.ExecuteReader();



while (reader.Read())

{

cmbsupp.Items.Add(reader.GetString(0).ToString());

}

koneksi.Close();

}

private void btnkeluar_Click(object sender, EventArgs

e)

{

DialogResult result = MessageBox.Show("Apa andayakin ingin keluar?", ".::Konfirmasi::.",

MessageBoxButtons.YesNo, MessageBoxIcon.Question); ;

if (result == DialogResult.Yes)

{

this.Dispose();

}

}

private void btnubah_Click(object sender, EventArgse)

{

if (dgv3.RowCount != 0)

{

String kdbrg =

dgv3.Rows[dgv3.CurrentCell.RowIndex].Cells[0].Value.To

String();

list = new List<string>();

list = comd.loadData("SELECT * FROM tb_brg

WHERE kode_brg='" + kdbrg + "'");

//Masukkan ke field2

txtkdbrg.Text = list[0];

txnmtbrg.Text = list[1];

txtharga.Text = list[2];

txtstock.Text = list[3];

cmbsupp.Text = list[4];

btnsimpan.Text = "UPDATE";

}

}



private void btnreset_Click(object sender, EventArgs

e)

{

txtharga.Text = "";

txtkdbrg.Text = "";cmbsupp.Text = "";

txtstock.Text = "";

txtkdbrg.Focus();

}

private void txtharga_KeyPress(object sender,

KeyPressEventArgs e)

{

char ch = e.KeyChar;

if (!Char.IsDigit(ch) && ch != 45 && ch != 8)

{e.Handled = true;

MessageBox.Show("Hanya Bisa Input Angka!",

"Peringatan!", MessageBoxButtons.OK,

MessageBoxIcon.Warning);

}

}

private void txtstock_KeyPress(object sender,


{char ch = e.KeyChar;


{

e.Handled = true;




}

}

private void txtkdsupp_KeyPress(object sender,KeyPressEventArgs e)

{



{

e.Handled = true;




}

}



private void btnhapus_Click(object sender, EventArgs

e)

{

string message = "Apa Anda Yakin InginMnghaspus Data Ini?";

string title = "Hapus";

MessageBoxButtons buttons =

MessageBoxButtons.YesNo;

DialogResult result = MessageBox.Show(message,

title, buttons, MessageBoxIcon.Question);


{


{string brg =


String();

comd.Delete("DELETE FROM tb_brg

WHERE kode_brg='" + brg + "'");

load();

}

}

else

{// Do something

}

}

private void btnsimpan_Click(object sender,

EventArgs e)

{

if (btnsimpan.Text == "UPDATE"){

string kodebrg = txtkdbrg.Text;

string nmabrg = txnmtbrg.Text;

string harga = txtharga.Text;

string stok = txtstock.Text;

string kdsupp = cmbsupp.Text;

if (kodebrg.Trim() == "" || nmabrg.Trim() == "" ||

harga.Trim() == "" || stok.Trim() == "" || kdsupp.Trim() ==

"")

{



MessageBox.Show("Semua Field Harus Di Isi

!!");

}

else{

//Cek di tabel apakah kode sudah digunakan

int cek = comd.count("SELECT * FROM

tb_brg WHERE kode_brg='" + txtkdbrg.Text + "'");

if (cek == 1 && txtkdbrg.Text != list[0])

{

MessageBox.Show("Kode Barang sudah

digunakan", "Simpan", MessageBoxButtons.OK,


}

else{

try

{

String query = "UPDATE tb_brg SET

nama_brg='" + txnmtbrg.Text + "', harga='" + txtharga.Text

+ "', stok='" + txtstock.Text + "', kode_supplier='" +

cmbsupp.Text + "'" + "WHERE kode_brg ='" + kodebrg +

"'";

comd.Update(query);

load(); btnsimpan.Text = "SIMPAN";

txtharga.Text = "";

txtkdbrg.Text = "";

cmbsupp.Text = "";

txtstock.Text = "";

txnmtbrg.Text = "";

txtkdbrg.Focus();

}


{


}

}

}

else

{

//proteksi kosong

string kodebrg = txtkdbrg.Text;

string nmabrg = txnmtbrg.Text;


string stok = txtstock.Text;



string kdsupp = cmbsupp.Text;

if (kodebrg.Trim() == "" || nmabrg.Trim() == "" ||

harga.Trim() == "" || stok.Trim() == "" || kdsupp.Trim() ==

""){


!!");

}

else

{



tb_brg WHERE kode_brg='" + txtkdbrg.Text + "'");if (cek == 1)

{

MessageBox.Show("Kode Barang sudah



}

else

{

//proteksi jika kode sama


try

{



koneksi.Open();



perintah.CommandType =

CommandType.Text;

perintah.CommandText = "select * fromtb_brg";



int i = 0;


{

i++;

if ((reader.GetString(0).ToString() ==

txtkdbrg.Text))

{



MessageBox.Show("Kode Barang

Yang Anda Masukan Sudah Terdaftar");

}

else

{

MySqlConnection con = new


MySqlCommand cmd;

con.Open();

try

{

cmd = con.CreateCommand();cmd.CommandText = "insert into

tb_brg(kode_brg,nama_brg,harga,stok,kode_supplier)

values (@kodebrg,@nmabrg,@harga,@stok,@kdsupp)";

cmd.Parameters.AddWithValue("@kodebrg",

txtkdbrg.Text);

cmd.Parameters.AddWithValue("@nmabrg",

txnmtbrg.Text);

cmd.Parameters.AddWithValue("@harga",

int.Parse(txtharga.Text));

cmd.Parameters.AddWithValue("@stok",

int.Parse(txtstock.Text));

cmd.Parameters.AddWithValue("@kdsupp",

int.Parse(cmbsupp.Text));

int rows =

cmd.ExecuteNonQuery();DialogResult result =

MessageBox.Show("Data Berhasil Di Inputkan!",

".::Informasi::.", MessageBoxButtons.OK,

MessageBoxIcon.Information); ;

txtharga.Text = "";

txtkdbrg.Text = "";

cmbsupp.Text = "";

txtstock.Text = "";

txnmtbrg.Text = "";

txtkdbrg.Focus();

}



catch (Exception)

{

throw;

}

finally{

if (con.State ==

ConnectionState.Open)

{

con.Close();

load();

}

}

}

}if (i == 0)

{



MySqlCommand cmd;

con.Open();

try

{

cmd = con.CreateCommand();cmd.CommandText = "insert into

tb_brg(kode_brg,nama_brg,harga,stok,kode_supplier)

values (@kodebrg,@nmabrg,@harga,@stok,@kdsupp)";

cmd.Parameters.AddWithValue("@kodebrg",

txtkdbrg.Text);

cmd.Parameters.AddWithValue("@nmabrg",

txnmtbrg.Text);



cmd.Parameters.AddWithValue("@stok",

int.Parse(txtstock.Text));

cmd.Parameters.AddWithValue("@kdsupp",

int.Parse(cmbsupp.Text));

int rows = cmd.ExecuteNonQuery();



DialogResult result =




txtharga.Text = "";txtkdbrg.Text = "";

cmbsupp.Text = "";

txtstock.Text = "";

txnmtbrg.Text = "";

txtkdbrg.Focus();

}

catch (Exception)

{

throw;

}finally

{

if (con.State ==


{

con.Close();

load();

}

}

}

}

catch (Exception) { }

}

}

}

}

private void frmbrg_Load(object sender, EventArgs e)

{

}

private void cmbsupp_SelectedIndexChanged(object

sender, EventArgs e)

{

}

}

}



3. Class Detail Penjualan

using System;


using System.ComponentModel;using System.Data;


using System.Linq;

using System.Text;



namespace frmutama

{

public partial class frmdetailpenjualan : Form

{string MyConnect =


;


List<string> list;

public frmdetailpenjualan()

{


load();loadCombo();

loadcmbnota();

}

public void load()

{



connection.Open();

try{

MySqlCommand per =


per.CommandText = "select * from

tb_detpenjualan";




adp.Fill(data);

dgv4.DataSource = data.Tables[0].DefaultView;



}

catch (Exception)

{

throw;}

finally

{

if (connection.State == ConnectionState.Open)

{

connection.Clone();

}

}

}

public void loadcmbnota(){




koneksi.Open();




perintah.CommandText = "select no_nota fromtb_penjualan";




{

cmbnota.Items.Add(reader.GetString(0).ToString());

}koneksi.Close();

}

public void loadCombo()

{




koneksi.Open();






perintah.CommandText = "select kode_brg from

tb_brg";




{

cmbkde.Items.Add(reader.GetString(0).ToString());

}

koneksi.Close();

}


e)

{

DialogResult result = MessageBox.Show("Apa anda

yakin ingin keluar?", ".::Konfirmasi::.",



{

this.Dispose();

}

}


e)

{

txtharga.Text = "0";

txtjml.Text = "0";

cmbkde.Text = "";cmbnota.Text = "";

txtsubtot.Text = "";

cmbnota.Focus();

}


EventArgs e)

{

if (btnsimpan.Text == "UPDATE")

{

string nonota = cmbnota.Text;



string kdbrg = cmbkde.Text;


string jumlah = txtjml.Text;

string subtotal = txtsubtot.Text;

if (nonota.Trim() == "" || kdbrg.Trim() == "" ||

harga.Trim() == "" || jumlah.Trim() == "" || subtotal.Trim()

== "")

{


!!");

}

else

{

//Cek di tabel apakah kode sudah digunakanint cek = comd.count("SELECT * FROM

tb_detpenjualan WHERE no_nota='" + cmbnota.Text +

"'");

if (cek == 1 && cmbnota.Text != list[0])

{

MessageBox.Show("No Nota sudah



}

else{

try

{

String query = "UPDATE tb_detpenjualan

SET kode_brg='" + cmbkde.Text + "', hrg_jual='" +

txtharga.Text + "', jumlah_jual='" + txtjml.Text + "',

subtotal='" + txtsubtot.Text + "'" + "WHERE no_nota='" +

nonota + "'";

comd.Update(query);

load();

btnsimpan.Text = "SIMPAN";txtharga.Text = "0";

txtjml.Text = "0";

cmbkde.Text = "";

cmbnota.Text = "";

txtsubtot.Text = "";

cmbnota.Focus();

}


{


}



}

}

}

else

{//proteksi kosong

string nonota = cmbnota.Text;

string kdbrg = cmbkde.Text;


string jumlah = txtjml.Text;

string subtotal = txtsubtot.Text;

if (nonota.Trim() == "" || kdbrg.Trim() == "" ||

harga.Trim() == "" || jumlah.Trim() == "" || subtotal.Trim()

== "")

{MessageBox.Show("Semua Field Harus Di Isi

!!");

}

else

{



tb_detpenjualan WHERE no_nota='" + cmbnota.Text +"'");

if (cek == 1)

{




}

else

{



try

{



koneksi.Open();




CommandType.Text;



perintah.CommandText = "select * from

tb_detpenjualan";



int i = 0;


{

i++;


cmbnota.Text))

{

MessageBox.Show("No Nota Yang

Anda Masukan Sudah Terdaftar");

}

else{



MySqlCommand cmd;

con.Open();

try{

cmd = con.CreateCommand();

cmd.CommandText = "insert into

tb_detpenjualan(no_nota,kode_brg,hrg_jual,jumlah_jual,su

btotal) values

(@nonota,@kdbrg,@harga,@jumlah,@subtotal)";

cmd.Parameters.AddWithValue("@nonota",

int.Parse(cmbnota.Text));

cmd.Parameters.AddWithValue("@kdbrg", cmbkde.Text);



cmd.Parameters.AddWithValue("@jumlah",

int.Parse(txtjml.Text));

cmd.Parameters.AddWithValue("@subtotal",

int.Parse(txtsubtot.Text));



int rows =

cmd.ExecuteNonQuery();



".::Informasi::.", MessageBoxButtons.OK,MessageBoxIcon.Information); ;

String jum1, jum2;

list = comd.loadData("Select

jumlah from tb_brg WHERE kode_brg ='" + kdbrg + "'");

jum1 = list[0];

}

catch (Exception){

throw;

}

finally

{

if (con.State ==


{

con.Close();

load();}

}

}

}

if (i == 0)

{



MySqlCommand cmd;

con.Open();

try

{



tb_detpenjualan(no_nota,kode_brg,hrg_jual,jumlah_jual,su

btotal) values

(@nonota,@kdbrg,@harga,@jumlah,@subtotal)";




int.Parse(cmbnota.Text));

cmd.Parameters.AddWithValue("@kdbrg", cmbkde.Text);



cmd.Parameters.AddWithValue("@jumlah",

int.Parse(txtjml.Text));

cmd.Parameters.AddWithValue("@subtotal",

int.Parse(txtsubtot.Text));

int rows = cmd.ExecuteNonQuery();DialogResult result =




}

catch (Exception)

{

throw;

}

finally{

if (con.State ==


{

con.Close();

load();

}

}

}

}catch (Exception) { }

}

}

}

}

private void txtnota_KeyPress(object sender,


{





{

e.Handled = true;



MessageBoxIcon.Warning);}

}

private void txtharga_TextChanged(object sender,

EventArgs e)

{

}

private void txtharga_KeyPress(object sender,

KeyPressEventArgs e){



{

e.Handled = true;




}

}

private void txtjml_KeyPress(object sender,


{



{

e.Handled = true;




}

private void txtjml_TextChanged(object sender,

EventArgs e)

{

Double total, jumlah, harga;

harga = Double.Parse(this.txtharga.Text);

if (txtjml.Text == "")

{

txtjml.Text = "0";



}

jumlah = Double.Parse(this.txtjml.Text);

total = harga * jumlah;

this.txtsubtot.Text = total.ToString();

}

private void txtsubtot_TextChanged(object sender,

EventArgs e)

{

}

private void btnubah_Click(object sender, EventArgs

e)

{

if (dgv4.RowCount != 0){

String nonota =


String();


list = comd.loadData("SELECT * FROM

tb_detpenjualan WHERE no_nota='" + nonota + "'");


cmbnota.Text = list[0];cmbkde.Text = list[1];


txtjml.Text = list[3];

txtsubtot.Text = list[4];


}

}


e)

{

string message = "Apa Anda Yakin Ingin

Mnghaspus Data Ini?";







{




{

string nonota =


String();comd.Delete("DELETE FROM

tb_detpenjualan WHERE no_nota='" + nonota + "'");

load();

}

}

else {

}

}

private void frmdetailpenjualan_Load(object sender,EventArgs e)

{

}

private void cmbkde_TextChanged(object sender,

EventArgs e)

{

String kdbrg = cmbkde.Text;list = comd.loadData("Select harga from tb_brg

WHERE kode_brg ='"+ kdbrg +"'");


}

}

}

4.

Class Pegawai

using System;



using System.Data;


using System.Linq;

using System.Text;





namespace frmutama

{

public partial class frmpegawai : Form

{


;


List<string> list;

public frmpegawai()

{


load();

}

public void load()

{



connection.Open();

try

{

MySqlCommand per =

connection.CreateCommand(); per.CommandText = "select * from tb_pegawai";




adp.Fill(data);


}

catch (Exception)

{ throw;

}

finally

{


{

connection.Clone();

}

}

}



private void frmpegawai_Load(object sender,

EventArgs e)

{

}


e)

{





{

this.Dispose();}

}


e)

{

txtalamat.Text = "";

txtkdpgw.Text = "";

txtkdsupp.Text = "";

txtnama.Text = "";txtkdpgw.Focus();

cmbjk.Text = "";

}


EventArgs e)

{


{

string kodepgw = txtkdpgw.Text;

string nma = txtnama.Text;string almt = txtalamat.Text;

string jeniskel = cmbjk.Text;

if (kodepgw.Trim() == "" || nma.Trim() == "" ||

almt.Trim() == "" || jeniskel.Trim() == "")

{


!!");

}

else



{



tb_pegawai WHERE kode_pegawai='" + txtkdpgw.Text +

"'");if (cek == 1 && txtkdpgw.Text != list[0])

{

MessageBox.Show("Kode Pegawai sudah



}

else

{

try

{

String query = "UPDATE tb_pegawaiSET nama_pegawai ='" + txtnama.Text + "', alamat='" +

txtalamat.Text + "', jenis_kelamin='" + cmbjk.Text + "'" +

"WHERE kode_pegawai ='" + kodepgw + "'";

comd.Update(query);

load();


txtkdpgw.Text = "";


txtnama.Text = "";

txtkdpgw.Focus();cmbjk.Text = "";

}


{


}

}

}

}

else

{ //proteksi kosong

string kodepgw = txtkdpgw.Text;

string nma = txtnama.Text;

string almt = txtalamat.Text;

string jeniskel = cmbjk.Text;

if (kodepgw.Trim() == "" || nma.Trim() == "" ||

almt.Trim() == "" || jeniskel.Trim() == "")

{


!!");



}

else

{



tb_pegawai WHERE kode_pegawai='" + txtkdpgw.Text +

"'");

if (cek == 1)

{

MessageBox.Show("Kode Pegawai sudah



}

else{



try

{



koneksi.Open();

perintah = new MySqlCommand(); perintah.Connection = koneksi;


CommandType.Text;


tb_pegawai";



int i = 0;


{ i++;


txtkdpgw.Text))

{

MessageBox.Show("Kode Pegawai


}

else

{





MySqlCommand cmd;

con.Open();

try

{



tb_pegawai(kode_pegawai,nama_pegawai,alamat,jenis_kel

amin) values (@kodepgw,@nma,@almt,@jeniskel)";

cmd.Parameters.AddWithValue("@kodepgw",int.Parse(txtkdpgw.Text));

cmd.Parameters.AddWithValue("@nma", txtnama.Text);

cmd.Parameters.AddWithValue("@almt", txtalamat.Text);

cmd.Parameters.AddWithValue("@jeniskel",cmbjk.Text);

int rows =

cmd.ExecuteNonQuery();DialogResult result =





txtkdpgw.Text = "";


txtnama.Text = "";

txtkdpgw.Focus();

cmbjk.Text = "";

}catch (Exception)

{

throw;

}

finally

{

if (con.State ==


{

con.Close();

load();



}

}

}

}if (i == 0)

{



MySqlCommand cmd;

con.Open();

try

{


cmd.CommandText = "insert intotb_pegawai(kode_pegawai,nama_pegawai,alamat,jenis_kel

amin) values (@kodepgw,@nma,@almt,@jeniskel)";

cmd.Parameters.AddWithValue("@kodepgw",

int.Parse(txtkdpgw.Text));

cmd.Parameters.AddWithValue("@nma", txtnama.Text);

cmd.Parameters.AddWithValue("@almt", txtalamat.Text);

cmd.Parameters.AddWithValue("@jeniskel", cmbjk.Text);







txtkdpgw.Text = "";txtkdsupp.Text = "";

txtnama.Text = "";

txtkdpgw.Focus();

cmbjk.Text = "";

}

catch (Exception)

{

throw;

}

finally



{

if (con.State ==


{

con.Close();load();

}

}

}

}


}

}

}}


e)

{









{


{

string pgw =


String();

comd.Delete("DELETE FROM tb_pegawaiWHERE kode_pegawai='" + pgw + "'");

load();

}

}

else

{

// Do something

}

}



private void txtkdpgw_KeyPress(object sender,


{


if (!Char.IsDigit(ch) && ch != 45 && ch != 8){

e.Handled = true;




}

}


e)

{if (dgv5.RowCount != 0)

{

String pgw =


String();



tb_pegawai WHERE kode_pegawai='" + pgw + "'");

//Masukkan ke field2txtkdpgw.Text = list[0];

txtnama.Text = list[1];

txtalamat.Text = list[2];

cmbjk.Text = list[3];


}

}

}

}

5. Class Penjualanusing System;



using System.Data;


using System.Linq;

using System.Text;





namespace frmutama

{

public partial class frmpenjualan : Form

{


;


List<string> list;

public frmpenjualan()

{


load();

}

public void load()

{



connection.Open();

try

{

MySqlCommand per =

connection.CreateCommand(); per.CommandText = "select * from

tb_penjualan";




adp.Fill(data);


}

catch (Exception){

throw;

}

finally

{


{

connection.Clone();

}

}

}




e)

{

DialogResult result = MessageBox.Show("Apa andayakin ingin keluar?", ".::Konfirmasi::.",



{

this.Dispose();

}

}


EventArgs e){


{

string nonota = txtnota.Text;

string total = txttot.Text;

string tgl = dtime.Text;

if (nonota.Trim() == "" || total.Trim() == "" ||

tgl.Trim() == "")

{MessageBox.Show("Semua Field Harus Di Isi

!!");

}

else

{



tb_penjualan WHERE no_nota='" + txtnota.Text + "'");

if (cek == 1 && txtnota.Text != list[0])

{ MessageBox.Show("No Nota sudah



}

else

{

try

{

String query = "UPDATE tb_penjualan

SET tgl='" + dtime.Value + "', total ='" + txttot.Text + "'" +

"WHERE no_nota ='" + nonota + "'";



comd.Update(query);

load();

btnsimpan.Text = "SIMPAN";

}catch (Exception ex)

{


}

}

}

}

else

{

//proteksi kosong

string nonota = txtnota.Text;string total = txttot.Text;

string tgl = dtime.Text;

if (nonota.Trim() == "" || total.Trim() == "" ||

tgl.Trim() == "")

{


!!");

}else

{



tb_penjualan WHERE no_nota='" + txtnota.Text + "'");

if (cek == 1)

{




else

{



try

{



koneksi.Open();






CommandType.Text;

perintah.CommandText = "select * fromtb_penjualan";



int i = 0;


{

i++;


txtnota.Text))

{MessageBox.Show("No Nota Yang

Anda Masukan Sudah Terdaftar");

}

else

{


MySqlConnection(MyConnect);MySqlCommand cmd;

con.Open();

try

{



tb_penjualan(no_nota,tgl,total) values

(@nonota,@tgl,@total)";


int.Parse(txtnota.Text));

cmd.Parameters.AddWithValue("@tgl", dtime.Value);

cmd.Parameters.AddWithValue("@total",

int.Parse(txttot.Text));

int rows =








txtnota.Text = "";txttot.Text = "";

txtnota.Focus();

}

catch (Exception)

{

throw;

}

finally

{

if (con.State ==ConnectionState.Open)

{

con.Close();

load();

}

}

}

}

if (i == 0){



MySqlCommand cmd;

con.Open();

try

{



tb_penjualan(no_nota,tgl,total) values(@nonota,@tgl,@total)";


int.Parse(txtnota.Text));

cmd.Parameters.AddWithValue("@tgl", dtime.Value);

cmd.Parameters.AddWithValue("@total",

int.Parse(txttot.Text));







MessageBoxIcon.Information); ;txtnota.Text = "";

txttot.Text = "";

txtnota.Focus();

}

catch (Exception)

{

throw;

}

finally{

if (con.State ==


{

con.Close();

load();

}

}}

}


}

}

}

}


e)

{ txtnota.Text = "";

txttot.Text = "";

txtnota.Focus();

}


e)

{








DialogResult result = MessageBox.Show(message,title, buttons, MessageBoxIcon.Question);


{


{

string nonota =


String();

comd.Delete("DELETE FROM tb_penjualan

WHERE no_nota ='" + nonota + "'");

load();}

}

else

{

// Do something

}

}


e){


{

String nonota =


String();



tb_penjualan WHERE no_nota='" + nonota + "'");

//Masukkan ke field2txtnota.Text = list[0];

dtime.Text = list[1];

txttot.Text = list[2];


}

}

private void txttot_KeyPress(object sender,


{





{

e.Handled = true;

MessageBox.Show("Hanya Bisa Input Angka!","Peringatan!", MessageBoxButtons.OK,


}

}

private void txtnota_KeyPress(object sender,


{



{e.Handled = true;




}

}

}

}

6. Class Supplier

using System;



using System.Data;


using System.Linq;

using System.Text;



namespace frmutama

{

public partial class frmsupplier : Form

{

string MyConnect =


;


List<string> list;



public frmsupplier()

{


load();

}

private void frmsupplier_Load(object sender,

EventArgs e)

{

}

public void load()

{


MySqlConnection(MyConnect);connection.Open();

try

{

MySqlCommand per =


per.CommandText = "select * from tb_supp";



DataSet data = new DataSet();adp.Fill(data);


}

catch (Exception)

{

throw;

}

finally

{ if (connection.State == ConnectionState.Open)

{

connection.Clone();

}

}

}


e)

{







{

this.Dispose();

}

}


e)

{



txtnama.Text = "";txttlp.Text = "";

txtkdsupp.Focus();

}

private void txttlp_KeyPress(object sender,


{



{e.Handled = true;




}

}


e)

{

string message = "Apa Anda Yakin InginMnghaspus Data Ini?";







{


{



string kodesup =


String();

comd.Delete("DELETE FROM tb_supp

WHERE kode_supp='" + kodesup + "'");load();

}

}

else

{

}

}


e){


{

String kodesup =


String();


list = comd.loadData("SELECT * FROM tb_supp

WHERE kode_supp='" + kodesup + "'");


txtkdsupp.Text = list[0];

txtnama.Text = list[1];

txtalamat.Text = list[2];

txttlp.Text = list[3];


}

}

private void txtkdsupp_KeyPress(object sender,KeyPressEventArgs e)

{



{

e.Handled = true;




}

}




EventArgs e)

{

if (btnsimpan.Text == "UPDATE"){

string kodesupp = txtkdsupp.Text;

string nama = txtnama.Text;

string alamat = txtalamat.Text;

string telp = txttlp.Text;

if (kodesupp.Trim() == "" || nama.Trim() == "" ||

alamat.Trim() == "" || telp.Trim() == "")

{

MessageBox.Show("Semua Field Harus Di Isi!!");

}

else

{



tb_supp WHERE kode_supp='" + txtkdsupp.Text + "'");

if (cek == 1 && txtkdsupp.Text != list[0])

{MessageBox.Show("Kode Supplier sudah



}

else

{

try

{

String query = "UPDATE tb_supp SET

nama_supp='" + txtnama.Text + "', alamat='" +

txtalamat.Text + "', telp='" + txttlp.Text + "WHEREkode_supp='" + kodesupp + "'";

comd.Update(query);

load();

btnsimpan.Text = "SIMPAN";



txtnama.Text = "";

txttlp.Text = "";

txtkdsupp.Focus();

}




{


}

}

}}

else

{

//proteksi kosong

string kodepgw = txtkdsupp.Text;

string nama = txtnama.Text;

string alamat = txtalamat.Text;

string telp = txttlp.Text;

if (kodepgw.Trim() == "" || nama.Trim() == "" ||

alamat.Trim() == "" || telp.Trim() == ""){


!!");

}

else

{


int cek = comd.count("SELECT * FROMtb_supp WHERE kode_supp='" + txtkdsupp.Text + "'");

if (cek == 1)

{

MessageBox.Show("Kode Supplier sudah



}

else

{



try

{



koneksi.Open();




CommandType.Text;




tb_supp";



int i = 0;


{

i++;


txtkdsupp.Text))

{

MessageBox.Show("Kode Supplier


}

else{



MySqlCommand cmd;

con.Open();

try{



tb_supp(kode_supp,nama_supp,alamat,telp) values

(@kodesupp,@nama,@alamat,@telp)";

cmd.Parameters.AddWithValue("@kodesupp",

int.Parse(txtkdsupp.Text));

cmd.Parameters.AddWithValue("@nama", txtnama.Text);

cmd.Parameters.AddWithValue("@alamat",

txtalamat.Text);

cmd.Parameters.AddWithValue("@telp", txttlp.Text);

int rows =








}

catch (Exception)

{throw;

}

finally

{

if (con.State ==


{

con.Close();

load();

}

}

}

}

if (i == 0)

{



MySqlCommand cmd;

con.Open();

try

{



tb_supp(kode_supp,nama_supp,alamat,telp) values

(@kodesupp,@nama,@alamat,@telp)";

cmd.Parameters.AddWithValue("@kodesupp",

int.Parse(txtkdsupp.Text));

cmd.Parameters.AddWithValue("@nama", txtnama.Text);

cmd.Parameters.AddWithValue("@alamat",

txtalamat.Text);

cmd.Parameters.AddWithValue("@telp", txttlp.Text);








}

catch (Exception)

{throw;

}

finally

{

if (con.State ==


{

con.Close();

load();

}

}

}

}


}

}

}

}

}

}

makalah pv e aplikasi toko komputer

Documents