Pemrograman Visual

Di susun oleh :

Brian Pattiwael (672009204)

Gilang Dwi Satyo (672008206)

Marco Liklikwatil (682008059)

Latar belakang

Dalam melakukan kegiatan operasional sehari-harinya mulai dari proses pengisisan rental,pengelolaan, pencatatan, sampai dengan pembayaran transaksi penyewaan kendaraan bermotor masi dilakukan secara. Maka dari itu system yan g kami buat dapat mendukung operasional dalm pengisian data penyewaan kendaraan ber motor. Dengan menggunakan C#.Net kami mebuat aplikasi system pendataan penyewaan kendaraan bermotor.

Penjelasan program :

Form 1 Login: jika login sudah di isi maka akan muncul Form ke 2

Gambar .Form Login

Form 2 : Form pendataan form pendataan terdiri dari Id Pelangan ,Nama,Alamat,No Tlp,Jenis sewa , Plat no,waktu sewa,mulai sewa,selesai sewa,DP kemudian ada pemilihan hasil scan KTP atau ID card lainya.. kemudian ada button input data,edit,delete,search.

Fungsi dari button.

Input : untuk menginputkan data ke data base .

Edit : digunakan untuk mengupdate data ke dalam data base . dengan cara mengklik draw header pada data great view maka data akan di tampilkan dan kemudian data akan di edit sesuai dengan kebutuhan.

Delete : digunakan untuk menghapus data dari data base.

Reset : digunakan untuk mengosongkan data pada form pengisian data

Search : Untuk mencari atau menampilkan dta yang suda di inputkan

Gambar. Form pendaftaran

Pada button search akan memunculkan form data search .search dilakukan berdasarkan 2 kategori yaitu nama dan jenis kendaraan ..

Source code :

namespace WindowsFormsApplication1

{

public partial class Form3 : Form

{

String connectionSQL = "host=localhost;database=db_pv;uid=root;password=";

public Form3()

{

InitializeComponent();

MySqlConnection db = new MySqlConnection(connectionSQL);

MySqlCommand comand = db.CreateCommand();

db.Open();

dataGridView1.Columns.Clear();

MySqlDataAdapter Adapter = new MySqlDataAdapter("SELECT `id` , `Nama` , `Alamat` , `no.tlv` , `id jaminan` , `jenis_sewa` , `plat_nomor` , `waktu_sewa` , `mulai_sewa` , `selesai_sewa` , `dp`FROM `tbl_sewa`", db);

DataSet dbtr = new DataSet();

Adapter.Fill(dbtr);

dataGridView1.DataSource = dbtr.Tables[0];

}

private void Form3_Load(object sender, EventArgs e)

{

}

private void button1_Click(object sender, EventArgs e)

{

MySqlConnection db = new MySqlConnection(connectionSQL);

MySqlCommand comand = db.CreateCommand();

db.Open();

dataGridView1.Columns.Clear();

string tpd = "";

if (comboBox1.SelectedIndex == 0){

tpd = "SELECT `id` , `Nama` , `Alamat` , `no.tlv` , `id jaminan` , `jenis_sewa` , `plat_nomor` , `waktu_sewa` , `mulai_sewa` , `selesai_sewa` , `dp`FROM `tbl_sewa` WHERE `Nama` = '" + textBox1.Text + "'";

}else if(comboBox1.SelectedIndex == 1){

if(comboBox2.SelectedIndex == 0){

tpd = "SELECT `id` , `Nama` , `Alamat` , `no.tlv` , `id jaminan` , `jenis_sewa` , `plat_nomor` , `waktu_sewa` , `mulai_sewa` , `selesai_sewa` , `dp`FROM `tbl_sewa` WHERE `jenis_sewa` = 'mobil'";

}else if(comboBox2.SelectedIndex == 1){

tpd = "SELECT `id` , `Nama` , `Alamat` , `no.tlv` , `id jaminan` , `jenis_sewa` , `plat_nomor` , `waktu_sewa` , `mulai_sewa` , `selesai_sewa` , `dp`FROM `tbl_sewa` WHERE `jenis_sewa` = 'motor'";

}

MySqlDataAdapter Adapter = new MySqlDataAdapter(""+tpd+"", db);

DataSet dbtr = new DataSet();

Adapter.Fill(dbtr);

dataGridView1.DataSource = dbtr.Tables[0];

}

private void button2_Click(object sender, EventArgs e)

{

Form2 fd = new Form2();

fd.Show();

this.Visible = false;

}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)

{

if (comboBox1.SelectedIndex == 1)

{

comboBox2.Visible = true;

}

else if (comboBox1.SelectedIndex == 0)

{

comboBox2.Visible = false;

}

namespace WindowsFormsApplication1

{

public partial class Form1 : Form

{

String connectionSQL = "host=localhost;database=db_pv;uid=root;password=";

public Form1()

{

InitializeComponent();

}

private Boolean statusLogin(string nama, string pass)

{

MySqlConnection db = new MySqlConnection(connectionSQL);

db.Open();

MySqlCommand dbcmd = db.CreateCommand();

string sql = "select user,pass from user";

dbcmd.CommandText = sql;

MySqlDataReader reader = dbcmd.ExecuteReader();

// membaca data user name dan password

while (reader.Read())

{

if ((reader.GetString(0).ToString() == nama) && (reader.GetString(1).ToString() == pass))

{

return true;

//mengembalikan nilai 'true' jika benar

}

db.Close();

return false;

}

private void button1_Click(object sender, EventArgs e)

{

if (statusLogin(textBox1.Text, textBox2.Text) == true)

{

Form2 fd = new Form2();

fd.Show();

this.Visible = false;

}

else

{

MessageBox.Show("Username atau password salah");

}

namespace WindowsFormsApplication1

{

public partial class Form2 : Form

{

String connectionSQL = "host=localhost;database=db_pv;uid=root;password=";

public Form2()

{

InitializeComponent();

tpldata();

DirectoryInfo dir = null;

if (!Directory.Exists("d:\\ktp"))

{

dir = Directory.CreateDirectory("d:\\ktp");

}

pictureBox1.Image = global::WindowsFormsApplication1.Properties.Resources.id;

}

public void tpldata()

{

MySqlConnection db = new MySqlConnection(connectionSQL);

MySqlCommand comand = db.CreateCommand();

db.Open();

dataGridView1.Columns.Clear();

DataSet dbtr = new DataSet();

Adapter.Fill(dbtr);

dataGridView1.DataSource = dbtr.Tables[0];

}

private void dateTimePicker1_ValueChanged(object sender, EventArgs e)

{

}

private void Form2_Load(object sender, EventArgs e)

{

}

private void groupBox1_Enter(object sender, EventArgs e)

{

}

private void btn_pfoto_Click(object sender, EventArgs e)

{

openFileDialog1.InitialDirectory = " C:\\ ";

openFileDialog1.FilterIndex = 2;

if (openFileDialog1.ShowDialog() == DialogResult.OK)

{

pictureBox1.Image = Image.FromFile(openFileDialog1.FileName);

pictureBox1.SizeMode = PictureBoxSizeMode.Zoom;

pictureBox1.BorderStyle = BorderStyle.None;

}

private void btn_input_Click(object sender, EventArgs e)

{

MySqlConnection db = new MySqlConnection(connectionSQL);

MySqlCommand comand = db.CreateCommand();

db.Open();

string id = txt_idpinjam.Text;

string alamat = txt_alamat.Text;

string tlp = txt_notlp.Text;

string nama = txt_nama.Text;

string idjmin = textBox1.Text;

string pno = txt_platno.Text;

string lsewa = txt_lmasewa.Text;

string dp = txt_dp.Text;

string jnis = "";

string pbx = "";

string lamapinjam = "";

string mulaisewa = "";

string selesaisewa = "";

if ((txt_idpinjam.Text == "") || (txt_nama.Text == "") || (txt_alamat.Text == "") || (txt_platno.Text == "") || (txt_ms_jam.Text == "") || (txt_ms_menit.Text == ""))

{

MessageBox.Show("data belum lengkap");

}

else

{

if (cmb_JnsSewa.SelectedIndex == 0){

jnis = "mobil";

}else {

jnis = "motor";

}

if (rb_hari.Checked == true)

{

lamapinjam = "" + txt_lmasewa.Text + " hari ";

}

else {

lamapinjam = "" + txt_lmasewa + " jam ";

}

if (cmb_ms_wktu.SelectedIndex == 1)

{

mulaisewa = "" + txt_ms_jam.Text + ":" + txt_ms_menit.Text + " AM";

}

else {

mulaisewa = "" + txt_ms_jam.Text + ":" + txt_ms_menit.Text + " PM";

}

if (cmb_ls_waktu.SelectedIndex == 0)

{

selesaisewa = "" + txt_ls_jam.Text + ":" + txt_ls_menit.Text + " AM";

}

else {

selesaisewa = "" + txt_ls_jam.Text + ":" + txt_ls_menit.Text + " PM";

}

if (pictureBox1.Image == global::WindowsFormsApplication1.Properties.Resources.id)

{

pbx = "";

}

else {

pbx = "tr"+id+"";

pictureBox1.Image.Save("d:\\ktp\\"+pbx+".jpg");

}

try {

comand.CommandText = "INSERT INTO `db_pv`.`tbl_sewa` (`id` ,`Nama` ,`Alamat` ,`no.tlv` ,`id jaminan` ,`jenis_sewa` ,`plat_nomor` ,`waktu_sewa` ,`mulai_sewa` ,`selesai_sewa` ,`dp` ,`ktp`)VALUES ('" + id + "', '" + nama + "', '" + alamat + "', '" + tlp + "', '" + idjmin + "', '" + jnis + "', '" + pno + "', '" + lamapinjam + "', '" +mulaisewa +"', '" +selesaisewa+ "', '" + dp + "', '" + pbx + ".jpg');";

comand.ExecuteNonQuery();

}

catch (MySqlException m)

{

MessageBox.Show(m.Message);

}

pictureBox1.Image = global::WindowsFormsApplication1.Properties.Resources.id;

lb_ms.Text = "";

lb_ss.Text = "";

lb_ws.Text = "";

tpldata();

txt_alamat.Text = "";

txt_dp.Text = "";

txt_idpinjam.Text = "";

txt_lmasewa.Text = "";

txt_ls_jam.Text = "";

txt_ls_menit.Text = "";

txt_ms_jam.Text = "";

txt_ms_menit.Text = "";

txt_nama.Text = "";

txt_notlp.Text = "";

txt_platno.Text = "";

textBox1.Text = "";

}

private void txt_idpinjam_TextChanged(object sender, EventArgs e)

{

}

private void btn_edit_Click(object sender, EventArgs e)

{

MySqlConnection db = new MySqlConnection(connectionSQL);

MySqlCommand comand = db.CreateCommand();

db.Open();

string id = txt_idpinjam.Text;

string alamat = txt_alamat.Text;

string tlp = txt_notlp.Text;

string nama = txt_nama.Text;

string idjmin = textBox1.Text;

string pno = txt_platno.Text;

string lsewa = txt_lmasewa.Text;

string dp = txt_dp.Text;

string jnis = "";

string pbx = "";

string lamapinjam = "";

string mulaisewa = "";

string selesaisewa = "";

if ((txt_idpinjam.Text == "") || (txt_nama.Text == "") || (txt_alamat.Text == "") || (txt_platno.Text == "") || (txt_ms_jam.Text == "") || (txt_ms_menit.Text == ""))

{

MessageBox.Show("data belum lengkap");

}

else

{

if (cmb_JnsSewa.SelectedIndex == 0)

{

jnis = "mobil";

}

else

{

jnis = "motor";

}

if (rb_hari.Checked == true)

{

lamapinjam = "" + txt_lmasewa.Text + " hari ";

}

else

{

lamapinjam = "" + txt_lmasewa + " jam ";

}

if (cmb_ms_wktu.SelectedIndex == 1)

{

mulaisewa = "" + txt_ms_jam.Text + ":" + txt_ms_menit.Text + " AM";

}

else

{

mulaisewa = "" + txt_ms_jam.Text + ":" + txt_ms_menit.Text + " PM";

}

if (cmb_ls_waktu.SelectedIndex == 0)

{

selesaisewa = "" + txt_ls_jam.Text + ":" + txt_ls_menit.Text + " AM";

}

else

{

selesaisewa = "" + txt_ls_jam.Text + ":" + txt_ls_menit.Text + " PM";

}

if (pictureBox1.Image == global::WindowsFormsApplication1.Properties.Resources.id)

{

pbx = "";

}

else

{

pbx = "tr" + id + "";

pictureBox1.Image.Save("d:\\ktp\\" + pbx + ".jpg");

}

try

{

comand.CommandText = "UPDATE `db_pv`.`tbl_sewa` SET `Nama` = '"+nama+"',`Alamat` = '"+alamat+"',`no.tlv` = '"+tlp+"',`id jaminan` = '"+idjmin+"',`jenis_sewa` = '"+jnis+"',`waktu_sewa` = '"+lsewa+"',`mulai_sewa` = '"+mulaisewa+"',`selesai_sewa` = '"+selesaisewa+"',`dp` = '"+dp+"', `ktp` = '"+pbx+".jpg' WHERE ( `tbl_sewa`.`id`) = '"+id+"'";

comand.ExecuteNonQuery();

}

catch (MySqlException m)

{

MessageBox.Show(m.Message);

}

pictureBox1.Image = global::WindowsFormsApplication1.Properties.Resources.id;

lb_ms.Text = "";

lb_ss.Text = "";

lb_ws.Text = "";

tpldata();

txt_alamat.Text = "";

txt_dp.Text = "";

txt_idpinjam.Text = "";

txt_lmasewa.Text = "";

txt_ls_jam.Text = "";

txt_ls_menit.Text = "";

txt_ms_jam.Text = "";

txt_ms_menit.Text = "";

txt_nama.Text = "";

txt_notlp.Text = "";

txt_platno.Text = "";

textBox1.Text = "";

}

private void textBox1_TextChanged(object sender, EventArgs e)

{

}

private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)

{

}

private void dataGridView1_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)

{

txt_idpinjam.Enabled = false;

btn_input.Enabled = false;

txt_idpinjam.Text = dataGridView1.Rows[e.RowIndex].Cells[0].Value as string;

txt_nama.Text = dataGridView1.Rows[e.RowIndex].Cells[1].Value as string;

txt_alamat.Text = dataGridView1.Rows[e.RowIndex].Cells[2].Value as string;

txt_notlp.Text = dataGridView1.Rows[e.RowIndex].Cells[3].Value as string;

textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[4].Value as string;

txt_platno.Text = dataGridView1.Rows[e.RowIndex].Cells[6].Value as string;

lb_ws.Text = dataGridView1.Rows[e.RowIndex].Cells[7].Value as string;

lb_ms.Text = dataGridView1.Rows[e.RowIndex].Cells[8].Value as string;

lb_ss.Text = dataGridView1.Rows[e.RowIndex].Cells[9].Value as string;

txt_dp.Text = dataGridView1.Rows[e.RowIndex].Cells[10].Value as string;

if (dataGridView1.Rows[e.RowIndex].Cells[5].Value as string == "mobil")

{

cmb_JnsSewa.SelectedIndex = 0;

}

else

{

cmb_JnsSewa.SelectedIndex = 1;

}

MySqlConnection db = new MySqlConnection(connectionSQL);

db.Open();

MySqlCommand dbcmd = db.CreateCommand();

string sql = "SELECT `ktp` FROM `tbl_sewa` WHERE `id` = '" + txt_idpinjam.Text + "'";

dbcmd.CommandText = sql;

MySqlDataReader reader = dbcmd.ExecuteReader();

string ktp = "";

if (reader.Read())

{

ktp = reader.GetString(0).ToString();

}

db.Close();

if (ktp != "")

{

if (File.Exists("d:\\ktp\\" + ktp + ""))

{

pictureBox1.Image = Image.FromFile("d:\\ktp\\" + ktp + "");

}

else

{

pictureBox1.Image = global::WindowsFormsApplication1.Properties.Resources.id;

}

else

{

pictureBox1.Image = global::WindowsFormsApplication1.Properties.Resources.id;

}

private void btn_reset_Click(object sender, EventArgs e)

{

pictureBox1.Image = global::WindowsFormsApplication1.Properties.Resources.id;

lb_ms.Text = "";

lb_ss.Text = "";

lb_ws.Text = "";

btn_input.Enabled = true;

txt_idpinjam.Enabled = true;

txt_alamat.Text = "";

txt_dp.Text = "";

txt_idpinjam.Text = "";

txt_lmasewa.Text = "";

txt_ls_jam.Text = "";

txt_ls_menit.Text = "";

txt_ms_jam.Text = "";

txt_ms_menit.Text = "";

txt_nama.Text = "";

txt_notlp.Text = "";

txt_platno.Text = "";

textBox1.Text = "";

}

private void btn_dlt_Click(object sender, EventArgs e)

{

MySqlConnection db = new MySqlConnection(connectionSQL);

MySqlCommand comand = db.CreateCommand();

db.Open();

try

{

comand.CommandText = "DELETE FROM `tbl_sewa` WHERE `tbl_sewa`.`id` = '" +txt_idpinjam.Text+ "'";

comand.ExecuteNonQuery();

}

catch (MySqlException m)

{

MessageBox.Show(m.Message);

}

pictureBox1.Image = global::WindowsFormsApplication1.Properties.Resources.id;

lb_ms.Text = "";

lb_ss.Text = "";

lb_ws.Text = "";

tpldata();

btn_input.Enabled = true;

txt_idpinjam.Enabled = true;

txt_alamat.Text = "";

txt_dp.Text = "";

txt_idpinjam.Text = "";

txt_lmasewa.Text = "";

txt_ls_jam.Text = "";

txt_ls_menit.Text = "";

txt_ms_jam.Text = "";

txt_ms_menit.Text = "";

txt_nama.Text = "";

txt_notlp.Text = "";

txt_platno.Text = "";

textBox1.Text = "";

}

private void btn_search_Click(object sender, EventArgs e)

{

Form3 fs = new Form3();

fs.Show();

this.Visible = false;

}

namespace WindowsFormsApplication1

{

partial class Form1

{

/// <summary>

/// Required designer variable.

/// </summary>

private System.ComponentModel.IContainer components = null;

/// <summary>

/// Clean up any resources being used.

/// </summary>

/// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

protected override void Dispose(bool disposing)

{

if (disposing && (components != null))

{

components.Dispose();

}

base.Dispose(disposing);

}

#region Windows Form Designer generated code

/// <summary>

/// Required method for Designer support - do not modify

/// the contents of this method with the code editor.

/// </summary>

private void InitializeComponent()

{

this.button1 = new System.Windows.Forms.Button();

this.textBox1 = new System.Windows.Forms.TextBox();

this.textBox2 = new System.Windows.Forms.TextBox();

this.label1 = new System.Windows.Forms.Label();

this.label2 = new System.Windows.Forms.Label();

this.SuspendLayout();

// button1

this.button1.Location = new System.Drawing.Point(169, 89);

this.button1.Name = "button1";

this.button1.Size = new System.Drawing.Size(75, 23);

this.button1.TabIndex = 0;

this.button1.Text = "Login";

this.button1.UseVisualStyleBackColor = true;

this.button1.Click += new System.EventHandler(this.button1_Click);

// textBox1

this.textBox1.Location = new System.Drawing.Point(92, 28);

this.textBox1.Name = "textBox1";

this.textBox1.Size = new System.Drawing.Size(152, 20);

this.textBox1.TabIndex = 1;

// textBox2

this.textBox2.Location = new System.Drawing.Point(92, 63);

this.textBox2.Name = "textBox2";

this.textBox2.PasswordChar = '*';

this.textBox2.Size = new System.Drawing.Size(152, 20);

this.textBox2.TabIndex = 2;

this.textBox2.UseSystemPasswordChar = true;

// label1

this.label1.AutoSize = true;

this.label1.Location = new System.Drawing.Point(12, 31);

this.label1.Name = "label1";

this.label1.Size = new System.Drawing.Size(66, 13);

this.label1.TabIndex = 3;

this.label1.Text = "User Name :";

// label2

this.label2.AutoSize = true;

this.label2.Location = new System.Drawing.Point(13, 66);

this.label2.Name = "label2";

this.label2.Size = new System.Drawing.Size(59, 13);

this.label2.TabIndex = 4;

this.label2.Text = "Password :";

// Form1

this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);

this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

this.ClientSize = new System.Drawing.Size(264, 124);

this.Controls.Add(this.label2);

this.Controls.Add(this.label1);

this.Controls.Add(this.textBox2);

this.Controls.Add(this.textBox1);

this.Controls.Add(this.button1);

this.Name = "Form1";

this.Text = "Form1";

this.ResumeLayout(false);

this.PerformLayout();

}

#endregion

private System.Windows.Forms.Button button1;

private System.Windows.Forms.TextBox textBox1;

private System.Windows.Forms.TextBox textBox2;

private System.Windows.Forms.Label label1;

private System.Windows.Forms.Label label2;

}

Kesimpulan

Dengan aplikasi ini dapat mempermudah managemen data penyewaan yang selama in di lakukan secara manual.

Link download : http://www.mediafire.com/?8r1zgsj72x1zjze

Pemrograman Visual

Halaman

Senin, 25 Maret 2013

APLIKASI SISTEM PENYEWAAN RENTAL KENDARAAN

Enthrean

Statistika