TUGAS RANCANG PEMOGRAMAN VISUAL
JUDUL PROGRAM
PENJUALAN DEVICES KOMPUTER
Disusun Oleh :
AG. Rully Tyas Kurnia W. (672008305)
Jenly R.H Ulus (672011135)
Wahyu Widi L. (672010071)
Wahyu Widi L. (672010071)
Latar Belakang :
Kelompok kami membuat program ini untuk menunjang penjualan suatu device computer agar panjualan tesebut dapat terdistribusi dengan baik dan dengan menggunakan program ini semua penjualan mengenani devices komputer dapat berjalan sesuai system yang tepat. Dan juga semua data-data mengenai devices komputer tersimpan rapih dalam suatu system database yang telah dibuat sehingga memudahkan pengelola (Administrator) dalam mengelola semua devices komputer yang dijual serta mempermudah juga bagi client (Pembeli/User) dalam memilih devices komputer yang akan dibeli.
Isi :
1. Berikut ini adalah tampilan Login untuk masuk kedalan Home. Untuk bisa masuk kita harus mengisi username dan Password, dan Passwordnya sama dengan Username yang ada.
Berikut ini adalah coding dari form login :
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using Toko_Komputer.Model;
namespace Toko_Komputer.Dao
{
public class LoginDao
{
private OleDbCommand Comm;
private OleDbConnection Coon;
private OleDbDataReader DataReader;
public LoginDao() {
this.Coon = new Connection().GetConnection();
}
public List<LoginModel> GetAllDataTblLogin() {
List<LoginModel> data = new List<LoginModel>();
this.Coon.Open();
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "select * from tbl_login";
this.DataReader = this.Comm.ExecuteReader();
while (this.DataReader.Read()) {
LoginModel lm = new LoginModel();
lm.UserName = this.DataReader.GetString(0);
lm.Password = this.DataReader.GetString(1);
data.Add(lm);
}
this.Coon.Close();
return data;
}
}
}
Setelah mengisi username dan password, selanjutnya akan masuk kedalam tampilan awal (Home). Dan berikut ini adalah tampilan awalnya :
Dan berikut ini adalah coding dari Tampilan awal :
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Toko_Komputer.Model;
using Toko_Komputer.View.Barang;
using Toko_Komputer.View.Transaksi;
using Toko_Komputer.View.Login;
namespace Toko_Komputer.Master
{
public partial class Home : Form
{
public Home()
{
InitializeComponent();
}
private void barangToolStripMenuItem_Click(object sender, EventArgs e)
{
DataBarang db = new DataBarang();
db.MdiParent = this;
db.Show();
}
private void exitToolStripMenuItem_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show(this,"Apakah Anda Ingin Keluar Dari Aplikasi Ini","Konfirmasi",MessageBoxButtons.YesNo,MessageBoxIcon.Question);
if (dialog == DialogResult.Yes) {
this.Close();
}
}
private void dataTransaksiToolStripMenuItem_Click(object sender, EventArgs e)
{
DataTransaksi dt = new DataTransaksi();
dt.MdiParent = this;
dt.Show();
}
private void transaksiToolStripMenuItem_Click(object sender, EventArgs e)
{
FormTransaksi ft = new FormTransaksi();
ft.MdiParent = this;
ft.Show();
}
private void tileHorizontalToolStripMenuItem_Click(object sender, EventArgs e)
{
this.LayoutMdi(MdiLayout.TileHorizontal);
}
private void tileVerticalToolStripMenuItem_Click(object sender, EventArgs e)
{
this.LayoutMdi(MdiLayout.TileVertical);
}
private void cascadeToolStripMenuItem_Click(object sender, EventArgs e)
{
this.LayoutMdi(MdiLayout.Cascade);
}
private void arrangeIconsToolStripMenuItem_Click(object sender, EventArgs e)
{
this.LayoutMdi(MdiLayout.ArrangeIcons);
}
private void closeAllToolStripMenuItem_Click(object sender, EventArgs e)
{
Form[] mdichild = this.MdiChildren;
for (int i = 0; i <mdichild.Length; i++ )
{
mdichild[i].Close();
}
}
private void laporanTransaksiPenuToolStripMenuItem_Click(object sender, EventArgs e)
{
TransaksiPenjualan tp = new TransaksiPenjualan();
tp.MdiParent = this;
tp.Show();
}
private void Home_Load(object sender, EventArgs e)
{
FormLogin fl = new FormLogin(this);
fl.MdiParent = this;
fl.Show();
}
private void authorToolStripMenuItem_Click(object sender, EventArgs e)
{
Author a = new Author();
a.MdiParent = this;
a.Show();
}
}
}
Setelah itu, kita masuk dalam transaksi pembelian. disitu admin akan mengisi nama barang, harga barang, jumlah barang yang akan dibeli serta data dari pembeli.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Toko_Komputer.Model;
using Toko_Komputer.Dao;
namespace Toko_Komputer.View.Transaksi
{
public partial class FormTransaksi : Form
{
private BarangDao bd = new BarangDao();
private TransaksiDao td = new TransaksiDao();
private BarangPembelianDao bpd = new BarangPembelianDao();
public FormTransaksi()
{
InitializeComponent();
}
private void LoadAllDataBrg() {
CmbBoxTypeBrg.Items.Clear();
foreach ( BarangModel bm in bd.GetAllData()){
if (! (CmbBoxTypeBrg.Items.Contains(bm.tipeBarang))) {
CmbBoxTypeBrg.Items.Add(bm.tipeBarang);
}
}
}
private void FormTransaksi_Load(object sender, EventArgs e)
{
this.LoadAllDataBrg();
}
private bool CheckKeyInput(char typeKey){
bool result = false;
if (typeKey == '1' || typeKey == '2'||
typeKey == '3' || typeKey == '4'||
typeKey == '5' || typeKey == '6'||
typeKey == '7' || typeKey == '8'||
typeKey == '0' || typeKey == '9')
{
result = true;
}
return result;
}
private void CmbBoxTypeBrg_SelectedIndexChanged(object sender, EventArgs e)
{
foreach ( BarangModel bm in bd.GetType_CodeBrg()) {
if (CmbBoxTypeBrg.SelectedItem.ToString().Equals(bm.tipeBarang)) {
txtCodeBrg.Text = bm.kodeBarang;
}
}
this.CmbBoxNameBrg.Items.Clear();
foreach (BarangModel bm in bd.GetAllData())
{
if (txtCodeBrg.Text.Equals(bm.kodeBarang))
{
CmbBoxNameBrg.Items.Add(bm.namaBarang);
}
}
}
private void CmbBoxNameBrg_SelectedIndexChanged(object sender, EventArgs e)
{
foreach ( BarangModel bm in bd.GetAllData()) {
if (CmbBoxNameBrg.SelectedItem.ToString().Equals(bm.namaBarang)) {
txtPriceBrg.Text = bm.hargaBarang.ToString();
}
}
}
private void UpdateNumberRows() {
int numinc = 1;
for (int i = 0; i < dataGridViewBrg.Rows.Count; i++)
{
if (numinc <=9)
{
dataGridViewBrg.Rows[i].Cells[0].Value = "00" + (numinc++);
}
else if (numinc >= 10 && numinc < 100)
{
dataGridViewBrg.Rows[i].Cells[0].Value = "0" + (numinc++);
}
else {
dataGridViewBrg.Rows[i].Cells[0].Value = numinc++;
}
}
}
private void UpdateCountTotalPriceBrg() {
int CountTotalPrice = 0;
for (int i = 0; i < dataGridViewBrg.Rows.Count; i++)
{
int harga = Convert.ToInt32(dataGridViewBrg.Rows[i].Cells[6].Value.ToString());
CountTotalPrice += harga;
}
this.txtCountTotalPriceBrg.Text = "Rp. " + CountTotalPrice;
}
private void UpdateCountTotalOrderBrg() {
int CountTotalOrder = 0;
for (int i = 0; i < dataGridViewBrg.Rows.Count; i++ )
{
int countOrder = Convert.ToInt32(dataGridViewBrg.Rows[i].Cells[4].Value.ToString());
CountTotalOrder += countOrder;
}
this.txtCountTotalOrderBrg.Text = CountTotalOrder.ToString();
}
private bool CheckNameBrg(string nameBrg) {
bool result = false;
for (int i = 0; i < this.dataGridViewBrg.Rows.Count;i++ )
{
if (this.dataGridViewBrg.Rows[i].Cells[3].Value.ToString().Equals(nameBrg)) {
result = true;
}
}
return result;
}
private void BtnInputBrg_Click(object sender, EventArgs e)
{
try
{
if (txtCountOrder.Text.Length == 0)
{
MessageBox.Show(this, "Kolom Jumlah Pesanan Belum Disi", "Pesan",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (bd.CheckStockByNameBrg(CmbBoxNameBrg.SelectedItem.ToString()) < (Convert.ToInt32(txtCountOrder.Text)))
{
MessageBox.Show(this, "Pesan Melebih Stok Yang Ada\n" +
"Jumlah Stok yang ada : " + (bd.CheckStockByNameBrg(CmbBoxNameBrg.SelectedItem.ToString())), "Pesan",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (this.CheckNameBrg(this.CmbBoxNameBrg.SelectedItem.ToString()))
{
MessageBox.Show(this, "Barang Telah DiPesan\n" +
"Hapus Lalu Tambahkan Ulang", "Pesan",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
int totalharga = Convert.ToInt32(txtCountOrder.Text) * Convert.ToInt32(txtPriceBrg.Text);
dataGridViewBrg.Rows.Add("",
CmbBoxTypeBrg.SelectedItem.ToString(),
txtCodeBrg.Text,
CmbBoxNameBrg.SelectedItem.ToString(),
txtCountOrder.Text,
txtPriceBrg.Text,
totalharga);
this.UpdateNumberRows();
this.UpdateCountTotalPriceBrg();
this.UpdateCountTotalOrderBrg();
}
}catch (Exception ex) {
MessageBox.Show(this,ex.ToString(), "Pesan",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void ChkHutang_CheckedChanged(object sender, EventArgs e)
{
if (this.ChkHutang.Checked == true)
{
this.groupBoxHutang.Enabled = true;
}
else {
this.groupBoxHutang.Enabled = false;
}
try
{
this.txtTotalHargaPembelian.Text = txtCountTotalPriceBrg.Text.Substring(4);
}catch (Exception ex) {
}
this.tabControlTypeTransaction.SelectedIndex =0;
this.ChkPrepayment.Checked = false;
this.ChkBayarTunai.Checked = false;
}
private void ChkBayarTunai_CheckedChanged(object sender, EventArgs e)
{
if (this.ChkBayarTunai.Checked == true) {
this.groupBoxBayarTunai.Enabled=true;
}else {
this.groupBoxBayarTunai.Enabled = false;
}
this.tabControlTypeTransaction.SelectedIndex = 1;
this.ChkHutang.Checked = false;
this.ChkPrepayment.Checked = false;
}
private void ChkPrepayment_CheckedChanged(object sender, EventArgs e)
{
if (this.ChkPrepayment.Checked == true)
{
this.groupBoxPrepayment.Enabled = true;
}
else {
this.groupBoxPrepayment.Enabled =false;
}
this.tabControlTypeTransaction.SelectedIndex = 2;
this.ChkHutang.Checked = false;
this.ChkBayarTunai.Checked = false;
}
private void txtCountOrder_KeyPress(object sender, KeyPressEventArgs e)
{
if (this.CheckKeyInput(e.KeyChar))
{
e.Handled = false;
}
else if (e.KeyChar == 8)
{
e.Handled = false;
}
else {
e.Handled = true;
}
}
private void BtnDeleteAll_Click(object sender, EventArgs e)
{
this.dataGridViewBrg.Rows.Clear();
this.UpdateCountTotalPriceBrg();
}
private int SelectedCount() {
int count=0;
for (int i = 0; i < dataGridViewBrg.Rows.Count; i++ )
{
if (Convert.ToBoolean(dataGridViewBrg.Rows[i].Cells[7].Value)==true) {
++count;
}
}
return count;
}
private void BtnDelete_Click(object sender, EventArgs e)
{
if (this.SelectedCount() == 0)
{
MessageBox.Show(this, "Pilih Terlebih Dahulu Barang Yang Ingin DiHapus", "Pesan",
MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else {
DialogResult dialog = MessageBox.Show(this, "Apakah Anda Yakin Untuk Hapus", "Pesan",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (dialog == DialogResult.Yes) {
for (int i = dataGridViewBrg.Rows.Count-1; i >=0; i--)
{
if (Convert.ToBoolean(dataGridViewBrg.Rows[i].Cells[7].Value) == true)
{
dataGridViewBrg.Rows.RemoveAt(i);
}
}
this.UpdateNumberRows();
}
this.UpdateCountTotalPriceBrg();
this.UpdateCountTotalOrderBrg();
}
}
private void BtnClear_Click(object sender, EventArgs e)
{
this.txtCodeBrg.Clear();
this.txtPriceBrg.Clear();
this.txtCountOrder.Clear();
}
private void ChkPhnHouse_CheckedChanged(object sender, EventArgs e)
{
if (this.ChkPhnHouse.Checked == true)
{
txtPhnhouseBuyer.Enabled = true;
}
else {
txtPhnhouseBuyer.Enabled = false;
}
}
private void chkHP_CheckedChanged(object sender, EventArgs e)
{
if (this.chkHP.Checked == true)
{
txtHPBuyer.Enabled = true;
}
else {
txtHPBuyer.Enabled = false;
}
}
private void InsertBarangPembelian() {
for (int i = 0; i < dataGridViewBrg.Rows.Count; i++)
{
BarangPembelianModel bpm = new BarangPembelianModel();
bpm.NamaPembeli = txtNameBuyer.Text;
bpm.TipeBarang = dataGridViewBrg.Rows[i].Cells[1].Value.ToString();
bpm.KodeBarang = dataGridViewBrg.Rows[i].Cells[2].Value.ToString();
bpm.NamaBarang = dataGridViewBrg.Rows[i].Cells[3].Value.ToString();
bpm.JumlahPesan = Convert.ToInt32(dataGridViewBrg.Rows[i].Cells[4].Value.ToString());
bpm.HargaSatuan = Convert.ToInt32(dataGridViewBrg.Rows[i].Cells[5].Value.ToString());
bpm.TotalHarga = Convert.ToInt32(dataGridViewBrg.Rows[i].Cells[6].Value.ToString());
bpd.InsertDataToTblBrgPembelian(bpm);
}
}
private void InsertDataTransaksi() {
TransaksiModel tm = new TransaksiModel();
tm.Nama = txtNameBuyer.Text;
tm.TotalJumlahBarang = Convert.ToInt32(txtCountTotalOrderBrg.Text);
tm.TotalHarga = Convert.ToInt32(txtCountTotalPriceBrg.Text.Substring(4));
if (this.ChkHutang.Checked==true) {
tm.JenisPembayaran = this.ChkHutang.Text;
}
else if (this.ChkPrepayment.Checked == true)
{
tm.JenisPembayaran = this.ChkPrepayment.Text;
}
else if (this.ChkBayarTunai.Checked==true) {
tm.JenisPembayaran = this.ChkBayarTunai.Text;
}
tm.TanggalTransaksi = DateTime.Now+"";
td.InsertToTblTransaksi(tm);
}
private void BtnPrintTransaction_Click(object sender, EventArgs e)
{
if (this.txtNameBuyer.Text.Length == 0)
{
MessageBox.Show(this, "Kolom Nama Pembeli Masih Kosong", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.tabControlTransaction.SelectedIndex = 1;
}else if (this.txtAddressBuyer.Text.Length == 0)
{
MessageBox.Show(this, "Kolom Alamat Pembeli Masih Kosong", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.tabControlTransaction.SelectedIndex = 1;
} else if (RBtnFemale.Checked == false && RBtnMale.Checked==false) {
MessageBox.Show(this, "Jenis Kelamin Belum DiPilih", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.tabControlTransaction.SelectedIndex = 1;
} else if (this.ChkPhnHouse.Checked == true && this.txtPhnhouseBuyer.Text.Length == 0)
{
MessageBox.Show(this, "Kolom Telepon Rumah Harus DiIsi", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.tabControlTransaction.SelectedIndex = 1;
}
else if (this.chkHP.Checked == true && this.txtHPBuyer.Text.Length == 0)
{
MessageBox.Show(this, "Kolom Handphone Harus DiIsi", "Pesan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.tabControlTransaction.SelectedIndex = 1;
}
else if (this.ChkBayarTunai.Checked==true) {
if (Convert.ToInt32(this.txtTotalUangPembayaran.Text) < Convert.ToInt32(txtCountTotalPriceBrg.Text.Substring(4)))
{
MessageBox.Show(this,"Uang Pembayaran kurang dari total harga barang","Pesan",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
else {
this.InsertBarangPembelian();
this.InsertDataTransaksi();
TransaksiModel tm = new TransaksiModel();
tm.Nama = txtNameBuyer.Text;
tm.Alamat = txtAddressBuyer.Text;
if (this.chkHP.Checked == true)
{
tm.NoTelepon = txtHPBuyer.Text;
}
else if (this.ChkPhnHouse.Checked == true)
{
tm.NoTelepon = txtPhnhouseBuyer.Text;
}
if (this.RBtnMale.Checked == true)
{
tm.JenisKelamin = this.RBtnMale.Text;
}
else
{
tm.JenisKelamin = this.RBtnFemale.Text;
}
tm.TotalJumlahBarang = Convert.ToInt32(this.txtCountTotalOrderBrg.Text);
tm.TotalHarga = Convert.ToInt32(this.txtCountTotalPriceBrg.Text.Substring(4));
tm.TanggalBayar = this.DTPickerHutang.Text;
tm.UangPembayaran = Convert.ToInt32(this.txtTotalUangPembayaran.Text);
tm.UangKembalian = Convert.ToInt32(this.txtTotalUangPembayaran.Text) - Convert.ToInt32(txtCountTotalPriceBrg.Text.Substring(4));
td.InsertDataToTblBayarTunai(tm);
}
}else if (this.ChkPrepayment.Checked==true ) {
this.InsertBarangPembelian();
this.InsertDataTransaksi();
TransaksiModel tm = new TransaksiModel();
tm.Nama = txtNameBuyer.Text;
tm.Alamat = txtAddressBuyer.Text;
if (this.chkHP.Checked == true)
{
tm.NoTelepon = txtHPBuyer.Text;
}
else if (this.ChkPhnHouse.Checked == true)
{
tm.NoTelepon = txtPhnhouseBuyer.Text;
}
if (this.RBtnMale.Checked == true)
{
tm.JenisKelamin = this.RBtnMale.Text;
}
else
{
tm.JenisKelamin = this.RBtnFemale.Text;
}
tm.TotalJumlahBarang = Convert.ToInt32(this.txtCountTotalOrderBrg.Text);
tm.TotalHarga = Convert.ToInt32(this.txtCountTotalPriceBrg.Text.Substring(4));
tm.UangMuka = Convert.ToInt32(this.txtUangMuka.Text);
tm.JatuhTempoPembayaran = DTPJatuhTempoPrepayment.Text;
td.InsertDataToTblPrepayment(tm);
}
else if (this.ChkHutang.Checked == true)
{
this.InsertBarangPembelian();
this.InsertDataTransaksi();
TransaksiModel tm = new TransaksiModel();
tm.Nama = txtNameBuyer.Text;
tm.Alamat = txtAddressBuyer.Text;
if (this.chkHP.Checked == true)
{
tm.NoTelepon = txtHPBuyer.Text;
}
else if (this.ChkPhnHouse.Checked == true)
{
tm.NoTelepon = txtPhnhouseBuyer.Text;
}
if (this.RBtnMale.Checked == true)
{
tm.JenisKelamin = this.RBtnMale.Text;
}
else
{
tm.JenisKelamin = this.RBtnFemale.Text;
}
tm.TotalJumlahBarang = Convert.ToInt32(this.txtCountTotalOrderBrg.Text);
tm.TotalHarga = Convert.ToInt32(this.txtTotalHargaPembelian.Text);
tm.JatuhTempoPembayaran = DTPickerHutang.Text;
td.InsertDataToTblHutang(tm);
}
else {
MessageBox.Show(this,"Anda Belum memilih Jenis Transaksi","Pesan",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
private void txtTotalHargaPembelian_KeyPress(object sender, KeyPressEventArgs e)
{
if (this.CheckKeyInput(e.KeyChar)) {
e.Handled = false;
}
else if (e.KeyChar == 8)
{
e.Handled = false;
}
else {
e.Handled = true;
}
}
private void txtTotalUangPembayaran_KeyPress(object sender, KeyPressEventArgs e)
{
if (this.CheckKeyInput(e.KeyChar))
{
e.Handled = false;
}
else if (e.KeyChar == 8)
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}
private void txtPhnhouseBuyer_KeyPress(object sender, KeyPressEventArgs e)
{
if (this.CheckKeyInput(e.KeyChar))
{
e.Handled = false;
}
else if (e.KeyChar == 8 || e.KeyChar == 45 || e.KeyChar ==32)
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}
private void txtHPBuyer_KeyPress(object sender, KeyPressEventArgs e)
{
if (this.CheckKeyInput(e.KeyChar))
{
e.Handled = false;
}
else if (e.KeyChar == 8)
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}
private void txtUangMuka_KeyPress(object sender, KeyPressEventArgs e)
{
if (this.CheckKeyInput(e.KeyChar))
{
e.Handled = false;
}
else if (e.KeyChar == 8)
{
e.Handled = false;
}
else
{
e.Handled = true;
}
}
}
}
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using Toko_Komputer.Model;
using System.Windows.Forms;
namespace Toko_Komputer.Dao
{
public class TransaksiDao
{
private OleDbCommand Comm;
private OleDbConnection Coon;
private OleDbDataReader DataReader;
public TransaksiDao() {
this.Coon = new Connection().GetConnection();
}
public List<TransaksiModel> getAllDataTblDataTransaksi()
{
List<TransaksiModel> data = new List<TransaksiModel>();
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "select * from tbl_datatransaksi";
this.DataReader = this.Comm.ExecuteReader();
while (this.DataReader.Read())
{
TransaksiModel tm = new TransaksiModel();
tm.Nama = this.DataReader.GetString(0);
tm.TotalJumlahBarang = this.DataReader.GetInt32(1);
tm.TotalHarga = this.DataReader.GetInt32(2);
tm.JenisPembayaran = this.DataReader.GetString(3);
tm.TanggalTransaksi = this.DataReader.GetString(4);
data.Add(tm);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
this.Coon.Close();
return data;
}
public List<TransaksiModel> getAllDataTblHutang() {
List<TransaksiModel> data = new List<TransaksiModel>();
this.Coon.Open();
try {
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "select * from tbl_hutang";
this.DataReader = this.Comm.ExecuteReader();
while (this.DataReader.Read()) {
TransaksiModel tm = new TransaksiModel();
tm.Nama = this.DataReader.GetString(0);
tm.Alamat = this.DataReader.GetString(1);
tm.JenisKelamin = this.DataReader.GetString(2);
tm.NoTelepon = this.DataReader.GetString(3);
tm.TotalJumlahBarang = this.DataReader.GetInt32(4);
tm.TotalHarga = this.DataReader.GetInt32(5);
tm.JatuhTempoPembayaran = this.DataReader.GetString(6);
data.Add(tm);
}
}catch (Exception ex) {
MessageBox.Show(ex.ToString());
}
this.Coon.Close();
return data;
}
public List<TransaksiModel> getAllDataTblBayarTunai()
{
List<TransaksiModel> data = new List<TransaksiModel>();
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "select * from tbl_bayartunai";
this.DataReader = this.Comm.ExecuteReader();
while (this.DataReader.Read())
{
TransaksiModel tm = new TransaksiModel();
tm.Nama = this.DataReader.GetString(0);
tm.Alamat = this.DataReader.GetString(1);
tm.JenisKelamin = this.DataReader.GetString(2);
tm.NoTelepon = this.DataReader.GetString(3);
tm.TotalJumlahBarang = this.DataReader.GetInt32(4);
tm.TotalHarga = this.DataReader.GetInt32(5);
tm.TanggalBayar = this.DataReader.GetString(6);
tm.UangPembayaran = this.DataReader.GetInt32(7);
tm.UangKembalian = this.DataReader.GetInt32(8);
data.Add(tm);
}
}
catch (Exception ex)
{
MessageBox.Show("Tabel Bayar Tunai : "+ex.ToString());
}
this.Coon.Close();
return data;
}
public List<TransaksiModel> getAllDataTblPrepayment()
{
List<TransaksiModel> data = new List<TransaksiModel>();
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "select * from tbl_prepayment";
this.DataReader = this.Comm.ExecuteReader();
while (this.DataReader.Read())
{
TransaksiModel tm = new TransaksiModel();
tm.Nama = this.DataReader.GetString(0);
tm.Alamat = this.DataReader.GetString(1);
tm.JenisKelamin = this.DataReader.GetString(2);
tm.NoTelepon = this.DataReader.GetString(3);
tm.TotalJumlahBarang = this.DataReader.GetInt32(4);
tm.TotalHarga = this.DataReader.GetInt32(5);
tm.JatuhTempoPembayaran = this.DataReader.GetString(6);
tm.UangMuka = this.DataReader.GetInt32(7);
data.Add(tm);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
this.Coon.Close();
return data;
}
public bool InsertToTblTransaksi(TransaksiModel tm) {
bool result = false;
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "insert into tbl_datatransaksi values (@nama,@totaljlmhbrg,@totalpembayaran,@jenispembayaran,@tanggaltransaksi)";
this.Comm.Parameters.AddWithValue("@nama", tm.Nama);
this.Comm.Parameters.AddWithValue("@totaljlmhbrg", tm.TotalJumlahBarang);
this.Comm.Parameters.AddWithValue("@totalpembayaran", tm.TotalHarga);
this.Comm.Parameters.AddWithValue("@jenispembayaran", tm.JenisPembayaran);
this.Comm.Parameters.AddWithValue("@tanggaltransaksi", tm.TanggalTransaksi);
this.Comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
MessageBox.Show("Tabel Transaksi "+ex.ToString());
}
this.Coon.Close();
return result;
}
public bool InsertDataToTblHutang(TransaksiModel tm) {
bool result = false;
this.Coon.Open();
try {
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "insert into tbl_hutang values (@nama,@alamat,@jeniskelamin,@notlpn"+
",@totaljlmhbrg,@totalharga,@jatuhtempopembayaran)";
this.Comm.Parameters.AddWithValue("@nama",tm.Nama);
this.Comm.Parameters.AddWithValue("@alamat", tm.Alamat);
this.Comm.Parameters.AddWithValue("@jeniskelamin", tm.JenisKelamin);
this.Comm.Parameters.AddWithValue("@notlpn", tm.NoTelepon);
this.Comm.Parameters.AddWithValue("@totaljlmhbrg", tm.TotalJumlahBarang);
this.Comm.Parameters.AddWithValue("@totalharga", tm.TotalHarga);
this.Comm.Parameters.AddWithValue("@jatuhtempopembayaran", tm.JatuhTempoPembayaran);
this.Comm.ExecuteNonQuery();
result = true;
}catch (Exception ex) {
}
this.Coon.Close();
return result;
}
public bool InsertDataToTblPrepayment(TransaksiModel tm)
{
bool result = false;
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "insert into tbl_prepayment values (@nama,@alamat,@jeniskelamin,@notlpn" +
",@totaljlmhbrg,@totalpembayaran,@jatuhtempopembayaran,@uangmuka)";
this.Comm.Parameters.AddWithValue("@nama", tm.Nama);
this.Comm.Parameters.AddWithValue("@alamat", tm.Alamat);
this.Comm.Parameters.AddWithValue("@jeniskelamin", tm.JenisKelamin);
this.Comm.Parameters.AddWithValue("@notlpn", tm.NoTelepon);
this.Comm.Parameters.AddWithValue("@totaljlmhbrg", tm.TotalJumlahBarang);
this.Comm.Parameters.AddWithValue("@totalharga", tm.TotalHarga);
this.Comm.Parameters.AddWithValue("@jatuhtempopembayaran", tm.JatuhTempoPembayaran);
this.Comm.Parameters.AddWithValue("@uangmuka", tm.UangMuka);
this.Comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
}
this.Coon.Close();
return result;
}
public bool UpdateDataToTblPrepayment(TransaksiModel tm,string code)
{
bool result = false;
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "update tbl_prepayment nama=@nama,alamat=@alamat,jenis_kelamin=@jeniskelamin,"+
"no_telepon=@notlpn,total_jumlah_barang=@totaljlmhbrg,total_pembayaran@=totalpembayaran,"+
"jatuh_tempo_pembayaran=@jatuhtempopembayaran,uang_muka@uangmuka where nama=@namaLama";
this.Comm.Parameters.AddWithValue("@nama", tm.Nama);
this.Comm.Parameters.AddWithValue("@alamat", tm.Alamat);
this.Comm.Parameters.AddWithValue("@jeniskelamin", tm.JenisKelamin);
this.Comm.Parameters.AddWithValue("@notlpn", tm.NoTelepon);
this.Comm.Parameters.AddWithValue("@totaljlmhbrg", tm.TotalJumlahBarang);
this.Comm.Parameters.AddWithValue("@totalharga", tm.TotalHarga);
this.Comm.Parameters.AddWithValue("@jatuhtempopembayaran", tm.JatuhTempoPembayaran);
this.Comm.Parameters.AddWithValue("@uangmuka", tm.UangMuka);
this.Comm.Parameters.AddWithValue("@namaLama",code);
this.Comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
}
this.Coon.Close();
return result;
}
public bool DeleteDataTblPrepayment(string code)
{
bool result = false;
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "delete from tbl_prepayment where nama like '"+code+"'";
this.Comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
}
this.Coon.Close();
return result;
}
public bool DeleteDataTblHutang(string code)
{
bool result = false;
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "delete from tbl_hutang where nama like '"+code+"'";
this.Comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
}
this.Coon.Close();
return result;
}
public bool UpdateDataToTblHutang(TransaksiModel tm, string code)
{
bool result = false;
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "update tbl_hutang set nama=@nama,alamat=@alamat,jenis_kelamin=@jeniskelamin,"+
"no_telepon=@notlpn,total_jumlah_brg=@totaljlmhbrg,total_harga=@totalharga,"+
"jatuh_tempo_pembayaran=@jatuhtempopembayaran where nama=@namalama";
this.Comm.Parameters.AddWithValue("@nama", tm.Nama);
this.Comm.Parameters.AddWithValue("@alamat", tm.Alamat);
this.Comm.Parameters.AddWithValue("@jeniskelamin", tm.JenisKelamin);
this.Comm.Parameters.AddWithValue("@notlpn", tm.NoTelepon);
this.Comm.Parameters.AddWithValue("@totaljlmhbrg", tm.TotalJumlahBarang);
this.Comm.Parameters.AddWithValue("@totalharga", tm.TotalHarga);
this.Comm.Parameters.AddWithValue("@jatuhtempopembayaran", tm.JatuhTempoPembayaran);
this.Comm.Parameters.AddWithValue("@namalama",code);
this.Comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
}
this.Coon.Close();
return result;
}
public bool InsertDataToTblBayarTunai(TransaksiModel tm)
{
bool result = false;
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "insert into tbl_bayarTunai values (@nama,@alamat,@jeniskelamin,@notlpn" +
",@totaljlmhbrg,@totalpembayaran,@tanggalbayar,@uangpembayaran,@uangkembalian)";
this.Comm.Parameters.AddWithValue("@nama", tm.Nama);
this.Comm.Parameters.AddWithValue("@alamat", tm.Alamat);
this.Comm.Parameters.AddWithValue("@jeniskelamin", tm.JenisKelamin);
this.Comm.Parameters.AddWithValue("@notlpn", tm.NoTelepon);
this.Comm.Parameters.AddWithValue("@totaljlmhbrg", tm.TotalJumlahBarang);
this.Comm.Parameters.AddWithValue("@totalpembayaran", tm.TotalHarga);
this.Comm.Parameters.AddWithValue("@tanggalbayar", tm.TanggalBayar);
this.Comm.Parameters.AddWithValue("@uangpembayaran", tm.UangPembayaran);
this.Comm.Parameters.AddWithValue("@uangkembalian", tm.UangKembalian);
this.Comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
MessageBox.Show("Tabel Bayar Tunai : "+ex.ToString());
}
this.Coon.Close();
return result;
}
public bool UpdateDataToTblBayarTunai(TransaksiModel tm, string code)
{
bool result = false;
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "update tbl_bayarTunai set nama=@nama,alamat=@alamat,jenis_kelamin=@jeniskelamin," +
"no_telepon=@notlpn,total_jumlah_brg=@totaljlmhbrg," +
"total_pembayaran=@totalpembayaran,tanggal_bayar=@tanggalbayar where nama=@namaLama";
this.Comm.Parameters.AddWithValue("@nama", tm.Nama);
this.Comm.Parameters.AddWithValue("@alamat", tm.Alamat);
this.Comm.Parameters.AddWithValue("@jeniskelamin", tm.JenisKelamin);
this.Comm.Parameters.AddWithValue("@notlpn", tm.NoTelepon);
this.Comm.Parameters.AddWithValue("@totaljlmhbrg", tm.TotalJumlahBarang);
this.Comm.Parameters.AddWithValue("@totalpembayaran", tm.TotalHarga);
this.Comm.Parameters.AddWithValue("@tanggalbayar", tm.TanggalBayar);
this.Comm.Parameters.AddWithValue("@namaLama",code);
this.Comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
}
this.Coon.Close();
return result;
}
public bool DeleteDataTblBayarTunai(string code)
{
bool result = false;
this.Coon.Open();
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "delete from tbl_bayarTunai where nama like '" + code + "'";
this.Comm.ExecuteNonQuery();
result = true;
}
catch (Exception ex)
{
}
this.Coon.Close();
return result;
}
}
}
Setelah mengisi nama,harga, dan jumlah barang yang akan dibeli serta data dari pembeli maka selanjutnya kita klik cetak transaksi, maka akan muncul data dari transaksi tersebut.
Kita juga bisa menghapus data dari seorang pembeli beserta dengan barang yang akan dibeli. Caranya adalah kita masuk dalam daftar transaksi, kemudian centang data pembeli yang akan dihapus pada kolom hapus kemudian klik hapus.
Kita juga bisa melihat daftar stok barang yang ada. disitu kita juga bisa menambah barang/stok baru, serta kita juga bisa menghapus serta mengupdate stok barang yang ada.
Menambah Stok Barang
Update Barang
Setelah itu kita dapat melihat barang yang sudah ditambahkan dan barang yang sudah diupdate
di data barang.
dan berikut ini source codenya :
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.OleDb;
using Toko_Komputer.Model;
using System.Windows.Forms;
namespace Toko_Komputer.Dao//project dari Toko_Komputer.Dao
{
public class BarangDao//class BarangDao
{
private OleDbCommand Comm;
private OleDbConnection Coon;
private OleDbDataReader DataReader;
public BarangDao() {
this.Coon = new Connection().GetConnection();
}
public List<BarangModel> GetAllData() {
List<BarangModel> data = new List<BarangModel>();
this.Coon.Open();
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "select * from tbl_brng";
this.DataReader = Comm.ExecuteReader();
while (DataReader.Read()) {
BarangModel bm = new BarangModel();
bm.kodeBarang = DataReader.GetString(0);
bm.tipeBarang = DataReader.GetString(1);
bm.namaBarang = DataReader.GetString(2);
bm.hargaBarang = DataReader.GetInt32(3);
bm.stokBarang = DataReader.GetInt32(4);
data.Add(bm);
}
this.DataReader.Close();
this.Coon.Close();
return data;
}
public List<BarangModel> GetType_CodeBrg() {
List<BarangModel> data = new List<BarangModel>();
this.Coon.Open();
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "select * from tbl_tipebrng";
this.DataReader = Comm.ExecuteReader();
while (DataReader.Read()) {
BarangModel bm = new BarangModel();
bm.tipeBarang = DataReader.GetString(0);
bm.kodeBarang = DataReader.GetString(1);
data.Add(bm);
}
this.Coon.Close();
return data;
}
public bool InsertDataBrg(BarangModel bm) {
try
{
this.Coon.Open();
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "insert into tbl_brng values (@kode,@tipe,@nama,@harga,@stok) ";
this.Comm.Parameters.AddWithValue("kode", bm.kodeBarang);
this.Comm.Parameters.AddWithValue("tipe", bm.tipeBarang);
this.Comm.Parameters.AddWithValue("nama", bm.namaBarang);
this.Comm.Parameters.AddWithValue("harga", bm.hargaBarang);
this.Comm.Parameters.AddWithValue("stok", bm.stokBarang);
this.Comm.ExecuteNonQuery();
this.Coon.Close();
return true;
}catch (OleDbException ex) {
MessageBox.Show(ex.ToString());
this.Coon.Close();
return false;
}
}
public bool DeleteDataBrg(BarangModel bm)
{
try
{
this.Coon.Open();
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "delete from tbl_brng where nama ='"+bm.namaBarang+"'";
this.Comm.ExecuteNonQuery();
this.Coon.Close();
return true;
}
catch (OleDbException ex)
{
return false;
}
}
public bool UpdateDataBrg(BarangModel bm,string namaBrg)
{
this.Coon.Open();
bool result = false;
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "update tbl_brng Set kode=@kode,tipe=@tipe,nama=@nama,harga=@harga,stok=@stok where nama = @namaBrg";
this.Comm.Parameters.AddWithValue("kode", bm.kodeBarang);
this.Comm.Parameters.AddWithValue("tipe", bm.tipeBarang);
this.Comm.Parameters.AddWithValue("nama", bm.namaBarang);
this.Comm.Parameters.AddWithValue("harga", bm.hargaBarang);
this.Comm.Parameters.AddWithValue("stok", bm.stokBarang);
this.Comm.Parameters.AddWithValue("namaBrg",namaBrg);
this.Comm.ExecuteNonQuery();
result = true;
}catch (Exception ex) {
result = false;
}
this.Coon.Close();
return result;
}
public int CheckStockByNameBrg(string nameBrg) {
this.Coon.Open();
int result = 0;
try
{
this.Comm = this.Coon.CreateCommand();
this.Comm.CommandText = "select stok from tbl_brng where nama like '" + nameBrg + "'";
this.DataReader = this.Comm.ExecuteReader();
if (DataReader.Read()) {
result = DataReader.GetInt32(0);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
this.Coon.Close();
return result;
}
public bool DeleteTypeBrg(BarangModel bm)
{
bool result = false;
this.Coon.Open();
this.Comm = this.Coon.CreateCommand();
try
{
Comm.CommandText = "delete from tbl_tipebrng where tipe ='"+bm.tipeBarang+"'";
Comm.ExecuteNonQuery();
result = true;
}
catch (OleDbException ex)
{
result = false;
MessageBox.Show(ex.ToString());
}
this.Coon.Close();
return result;
}
public bool InsertTypeBrg(BarangModel bm) {
bool result = false;
this.Coon.Open();
this.Comm = this.Coon.CreateCommand();
try
{
Comm.CommandText = "insert into tbl_tipebrng values(@tipe,@kode) ";
Comm.Parameters.AddWithValue("@tipe", bm.tipeBarang);
Comm.Parameters.AddWithValue("@kode", bm.kodeBarang);
Comm.ExecuteNonQuery();
result = true;
}catch (OleDbException ex) {
result = false;
MessageBox.Show(ex.ToString());
}
this.Coon.Close();
return result;
}
public bool UpdateTypeBrg(BarangModel bm,string TypeOldBrg)
{
bool result = false;
this.Coon.Open();
this.Comm = this.Coon.CreateCommand();
try
{
Comm.CommandText = "update tbl_tipebrng Set tipe=@tipe,kode=@kode where tipe=@typeoldbrg";
Comm.Parameters.AddWithValue("@tipe", bm.tipeBarang);
Comm.Parameters.AddWithValue("@kode", bm.kodeBarang);
Comm.Parameters.AddWithValue("@typeoldbrg",TypeOldBrg);
Comm.ExecuteNonQuery();
result = true;
}
catch (OleDbException ex)
{
result = false;
MessageBox.Show(ex.ToString());
}
this.Coon.Close();
return result;
}
}
}
KESIMPULAN :
Melalui Aplikasi penjualan toko konputer ini, semua transaksi dapat dilakukan dengan perhitungan real dan tanpa memanipulasi harga devices komputer karena semua harga devices komputer telah tertera di database nya dan dapat memudahkan bagi penjual dan pembeli dalam melakukan proses transaksi.
LINK DOWNLOAD
http://www.mediafire.com/?rhb2p4zxvftwspv
Harrah's Cherokee Casinos & Gaming - Mapyro
BalasHapusMapYRO Realtime Gaming 아산 출장마사지 Internet Gaming 안양 출장마사지 Realtime Gaming 여수 출장샵 (RTG) Realtime 충주 출장샵 Gaming Internet Gaming Realtime 안성 출장샵 Gaming (RTG) Realtime Gaming (RTG) Realtime Gaming (RTG) Realtime