0

Laporan dan Aplikasi rental menggunakan C sharp/ C# (7)

Posted by Jujur Sitanggang on 3:29 PM

Psoude-Code


Form rental

===============
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace index
{
   public partial class rental : Form
   {
       private string sql=null;
       private DataTable tauto = new DataTable();
       private kon koneksi = new kon();
       private DataTable trental = new DataTable();
       private double grand;
       private string op;
       private Boolean kontrol;
       public rental( string x, string y)
       {
           InitializeComponent();
           op = y;
      }
       private string tambah0(string x){
           if(int.Parse(x) < 10){
               x="0"+x;
           }
       return x;
       }
       private void kode_otomatis()
       {
           string tahun = DateTimeOffset.Now.Year.ToString();
           string bulan = tambah0(DateTimeOffset.Now.Month.ToString());
           string tanggal = tambah0(DateTimeOffset.Now.Day.ToString());
           string kode = "rent-" + tanggal + "-" + bulan + "-" + tahun;
           string temp;
           int naik;
           sql = "select no_sewa from rental order by no_sewa desc";
           trental = koneksi.tampil_data(sql);
           if (trental.Rows.Count == 0)
           {
               kode = kode + "-0001";
           }
           else
           {
               sql = "select no_sewa from rental where tanggal like'%"+tahun+"-"+bulan+"-"+tanggal+"%' order  by no_sewa desc";
               trental = koneksi.tampil_data(sql);
               if (trental.Rows.Count==0)
                   {
                       kode = kode + "-0001";
                   }else{
                       temp = trental.Rows[0].ItemArray.GetValue(0).ToString();
                       naik = int.Parse(temp.Substring(16, 4));
                       naik++;
                       if (naik < 10)
                       {
                           kode = kode + "-000" + naik;
                       }
                       else if (naik < 100)
                       {
                           kode = kode + "-00" + naik;
                       }
                       else if (naik < 1000)
                       {
                           kode = kode + "-0" + naik;
                       }
                       else
                       {
                           kode = kode + "-" + naik;
                       }
                   }
           }
           kode_rental.Text = kode;
           kode_rental.Enabled = false;
           trental = null;
       }
       private void isi_cb()
       {
           sql = "select * from mobil where status ='Tersedia'";
           trental = koneksi.tampil_data(sql);
           int pos = 0;
           while (pos < trental.Rows.Count)
           {
               cbmobil.Items.Add(trental.Rows[pos].ItemArray.GetValue(0).ToString());
               pos++;
           }
           trental = null;
           sql = "select*from sopir where status='Tersedia'";
           trental = koneksi.tampil_data(sql);
           pos = 0;
           while (pos < trental.Rows.Count)
           {
               cbsopir.Items.Add(trental.Rows[pos].ItemArray.GetValue(1).ToString());
               pos++;
           }

       }
       private void auto()
       {
           if (txtpelanggan.Text == "")
           {
               dgautocomplete.Visible = false;
           }
           else
           {
               sql = "select idplg,nama from pelanggan where idplg like'%" + txtpelanggan.Text + "%'";
               tauto = koneksi.tampil_data(sql);
               if (tauto.Rows.Count == 0)
               {
                   dgautocomplete.Visible = false;
               }
               else
               {
                   dgautocomplete.Visible = true;
                   dgautocomplete.DataSource = tauto;
                   dgautocomplete.Columns[1].Width = 180;
               }
           }
       }
       public void inisialisasi()
       {
           cbmobil.Text = "";
           cbsopir.Text = "";
           txtharga.Text = "";
           txtharga.Enabled = false;
           txtpelanggan.Text = "";
           txtlamasewa.Text = "";
           txtpelanggan.Enabled = true;
           cbsopir.Items.Clear();
           cbmobil.Items.Clear();
           namapelanggan.Text = "";
           merk.Text = "";
           kontrol = false;
           grand_total_string.Text = "Rp. 0";
           grand = 0;
           dgautocomplete.Visible = false;
           kode_otomatis();
           isi_cb();

       }
       private void rental_Load(object sender, EventArgs e)
       {
           inisialisasi();
       }

       private void reset_Click(object sender, EventArgs e)
       {
           inisialisasi();
       }

       private void txtpelanggan_KeyUp(object sender, KeyEventArgs e)
       {
           auto();
       }

       private void dgautocomplete_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
       {
           txtpelanggan.Text = dgautocomplete.SelectedCells[0].Value.ToString();
           namapelanggan.Text = dgautocomplete.SelectedCells[1].Value.ToString();
           txtpelanggan.Enabled = false;
           dgautocomplete.Visible = false;
       }

       private void proses_Click(object sender, EventArgs e)
       {
           if (txtpelanggan.Text == "")
           {
               MessageBox.Show("Id pelanggan belum terisi", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
           }
           else
           {
               if (namapelanggan.Text == "")
               {
                   MessageBox.Show("Nama Pelanggan belum terisi", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
               }
               else
               {
                   sql = "select*from mobil where id='" + cbmobil.Text + "'";
                   if (cbmobil.Text == ""||koneksi.tampil_data(sql).Rows.Count ==0)
                   {
                       MessageBox.Show("Pilih Mobil yang ingin di rental terlebih dahulu", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
                   }
                   else
                   {
                       if (txtlamasewa.Text == "")
                       {
                           MessageBox.Show("Lama penyewan belum terisi", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
                       }
                       else
                       {
                           string [] pelanggan= new String[6];
                           int lama;
                           Double[] harga = new Double[2];
                           pelanggan[0] = txtpelanggan.Text;
                           pelanggan[1] = namapelanggan.Text;
                           pelanggan[2] = cbmobil.Text;
                           pelanggan[3] = cbsopir.Text;
                           pelanggan[4] = kode_rental.Text;
                           pelanggan[5] = op;
                           harga[0] = double.Parse(txtharga.Text);
                           harga[1] = grand;
                           lama = int.Parse(txtlamasewa.Text);
                           pembayaran fpembayaran = new pembayaran(pelanggan, harga, lama);
                           fpembayaran.init = this;
                           fpembayaran.ShowDialog();


                       }
                   }
               }
           }
       }

       private void txtlamasewa_KeyUp(object sender, KeyEventArgs e)
       {
           double x;
           int y;
           if (txtlamasewa.Text != ""&& txtharga.Text!="")
           {
               x = double.Parse(txtharga.Text);
               y = int.Parse(txtlamasewa.Text);
               if (!kontrol)
               {
                   grand = x * y;
               }
               else
               {
                   sql = "select nama from sopir where nama ='" + cbsopir.Text + "'";
                   trental = koneksi.tampil_data(sql);
                   if (trental.Rows.Count != 0)
                   {
                       grand = ((x * y) + (y * 100000));
                       kontrol = true;
                   }
                   else
                   {
                       grand = x * y;
                   }

               }
               grand_total_string.Text = "Rp. " + grand.ToString("###,###");
           }
           else
           {
               grand_total_string.Text = "Rp. 0";
           }
       }

       private void cbmobil_TextChanged(object sender, EventArgs e)
       {
           string temp;
           sql = "select*from mobil where id ='" + cbmobil.Text + "'";
           trental =koneksi.tampil_data(sql);
           if (trental.Rows.Count != 0)
           {
               temp = trental.Rows[0].ItemArray.GetValue(4).ToString();
               merk.Text = trental.Rows[0].ItemArray.GetValue(1).ToString();
               sql = "select *from harga_sewa where golongan='" + temp + "'";
               txtharga.Text = koneksi.tampil_data(sql).Rows[0].ItemArray.GetValue(2).ToString();
               txtharga.Enabled = false;
               double x;
               int y;
               if (txtlamasewa.Text != "")
               {
                   x = double.Parse(txtharga.Text);
                   y = int.Parse(txtlamasewa.Text);
                   if (!kontrol)
                   {
                       grand = x * y;
                   }
                   else
                   {
                       sql = "select nama from sopir where nama ='" + cbsopir.Text + "'";
                       trental = koneksi.tampil_data(sql);
                       if (trental.Rows.Count != 0)
                       {
                           grand = ((x * y) + (y * 100000));
                           kontrol = true;
                       }
                       else
                       {
                           grand = x * y;
                       }

                   }
                   grand_total_string.Text = "Rp. " + grand.ToString("###,###");
               }
               else
               {
                   grand_total_string.Text = "Rp. 0";
               }
           }
           else
           {
               merk.Text = "";
               txtharga.Text = "";
               grand_total_string.Text = "Rp.0";
           }
       }

       private void cbsopir_TextChanged(object sender, EventArgs e)
       {
           if (!kontrol)
           {
               if (txtlamasewa.Text != "")
               {
                   sql = "select nama from sopir where nama ='" + cbsopir.Text + "'";
                   trental = koneksi.tampil_data(sql);
                   if (trental.Rows.Count != 0)
                   {
                       grand = grand + (100000 * int.Parse(txtlamasewa.Text));
                       grand_total_string.Text = "Rp. " + grand.ToString("###,###");
                       kontrol = true;
                   }
               }
               else
               {
                   kontrol = true;
               }
           }
           if ((kontrol)&&(cbsopir.Text == "")&&(txtlamasewa.Text !=""))
           {
               grand = grand - (100000 * int.Parse(txtlamasewa.Text));
               grand_total_string.Text = "Rp. " + grand.ToString("###,###");
               kontrol = false;
           }

       }
  }
}

Form pengembalian

=====================
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace index
{
   public partial class pengembalian : Form
   {
       private String sql,harus_kembali = null;
       private kon koneksi = new kon();
       private DataTable trental = new DataTable();
       private Double denda, pembayaran, sosok, uang_muka, harga_sewa,grand_total,sisa;
       private int lama;
       public pengembalian()
       {
           InitializeComponent();
       }
       private void inisialisasi()
       {
           lbl_denda.Text = "";
           lbl_harga.Text = "";
           lbl_id.Text = "";
           lbl_lama.Text = "";
           lbl_nama.Text = "";
           lbl_sosok.Text = "Rp.0";
           lbl_sisa.Text = "Rp.0";
           txt_bayar.Text = "";
           denda = 0;
           pembayaran = 0;
           sosok = 0;
           uang_muka = 0;
           txt_bayar.Enabled = true;
           harga_sewa = 0;
           grand_total = 0;
           lbl_plat.Text = "";
           lbl_sopir.Text = "";
           lbl_uangmuka.Text = "";
           lbl_tanggal.Text = "";
           cbfaktur.Text = "Pilih No Faktur";
           cbfaktur.Items.Clear();
           isi_faktur();
       }

       private void isi_faktur()
       {
           sql = "select*from rental where back='N' order by no_sewa asc";
           trental = koneksi.tampil_data(sql);
           int pos = 0;
           while (pos < trental.Rows.Count)
           {
               cbfaktur.Items.Add(trental.Rows[pos].ItemArray.GetValue(0).ToString());
               pos++;
           }
           trental = null;
       }

       private void pengembalian_Load(object sender, EventArgs e)
       {
           inisialisasi();
       }
       private int jumlah_tanggal(int x,int y){
           int z;
            if(x < 8){
                if(x==2){
                    if( y % 4==0){
                        z = 29;
                    }else{
                        z= 28;
                        }
                }else if(x % 2 ==0 && x!=2){
                    z =30;
                }else{
                    z= 31;
                }
            }else{
                if(x % 2 ==0){
                    z =31;
                }else{
                    z=30;
                }
            }
           return z;
       }
            
                    
       private void Panjang_denda(string x)
       {
           int jarak_tahun, jarak_bulan, jarak_tanggal,total_jarak;
           jarak_tahun =  int.Parse(x.Substring(6, 4));
           jarak_tahun = DateTimeOffset.Now.Year - jarak_tahun;
           if (jarak_tahun > 0)
           {
               jarak_tahun = int.Parse(x.Substring(6, 4));
               jarak_bulan = int.Parse(x.Substring(0, 2)) ;
               jarak_tanggal = int.Parse(x.Substring(3, 2));
               total_jarak = jumlah_tanggal(jarak_bulan, jarak_tahun) - jarak_tanggal;
               jarak_bulan++;
               while (jarak_tahun <= DateTimeOffset.Now.Year)
               {
                   while (jarak_bulan <= 12)
                   {
                       total_jarak = total_jarak + jumlah_tanggal(jarak_bulan, jarak_tahun);
                       jarak_bulan++;
                   }
                   jarak_bulan = 1;
                   jarak_tahun = jarak_tahun + 1;
                   while (jarak_bulan <= DateTimeOffset.Now.Month)
                   {
                       if (jarak_bulan == DateTimeOffset.Now.Month)
                       {
                           total_jarak = total_jarak + DateTimeOffset.Now.Day;
                           jarak_bulan++;
                       }
                       else
                       {
                           total_jarak = total_jarak + jumlah_tanggal(jarak_bulan, jarak_tahun);
                           jarak_bulan++;
                       }
                   }
                   jarak_tahun++;
               }
           }
           else if (DateTimeOffset.Now.Month - int.Parse(x.Substring(0, 2)) > 0)
           {
               jarak_tanggal = int.Parse(x.Substring(3, 2));
               jarak_bulan = int.Parse(x.Substring(0, 2));
               jarak_tahun = int.Parse(x.Substring(6, 4));
               if (jarak_tahun - DateTimeOffset.Now.Year > 0)
               {
                   total_jarak = 0;
               }
               else
               {
                   total_jarak = jumlah_tanggal(jarak_bulan, jarak_tahun) - jarak_tanggal;
                   jarak_bulan++;
                   while (jarak_bulan <= DateTimeOffset.Now.Month)
                   {
                       if (jarak_bulan == DateTimeOffset.Now.Month)
                       {
                           total_jarak = total_jarak + DateTimeOffset.Now.Day;
                           jarak_bulan++;
                       }
                       else
                       {
                           total_jarak = total_jarak + jumlah_tanggal(jarak_bulan, jarak_tahun);
                           jarak_bulan++;
                       }
                   }
               }
           }
           else if (DateTimeOffset.Now.Day - int.Parse(x.Substring(3, 2)) > 0)
           {
               jarak_tanggal = int.Parse(x.Substring(3, 2));
               jarak_bulan = int.Parse(x.Substring(0, 2));
               jarak_tahun = int.Parse(x.Substring(6, 4));
               if (jarak_bulan - DateTimeOffset.Now.Month > 0)
               {
                   total_jarak = 0;
               }
               else
               {
                   total_jarak = DateTimeOffset.Now.Day - jarak_tanggal;
               }
           }
           else
           {
               total_jarak = 0;
           }
           denda = total_jarak;
      }
       private string bulan_indo(string x){
           string bulan = "";
           switch(x){
               case "1"    : bulan = "Januari";
                             break;
               case "2"    : bulan = "Februari";
                             break;
               case "3"    : bulan = "Maret";
                             break;
               case "4"    : bulan = "April";
                             break;
               case "5"    : bulan ="Mei";
                             break;
               case "6"    : bulan ="Juni";
                             break;
               case "7"    : bulan ="Juli";
                             break;
               case "8"    : bulan = "Agustus";
                             break;
               case "9"    : bulan = "September";
                             break;
               case "10"   : bulan = "Oktober";
                             break;
               case "11"   : bulan = "November";
                             break;
               case "12"   : bulan = "Desember";
                             break;
           }
           return bulan;
       }

       private void cbfaktur_TextChanged(object sender, EventArgs e)
       {
           if (cbfaktur.Text != "")
           {
               sql = "select*from rental where no_sewa ='" + cbfaktur.Text + "'";
               trental = koneksi.tampil_data(sql);
               if (trental.Rows.Count != 0)
               {
                   String tempbulan, temptanggal, temptahun, tampung;
                   Double temp = 0;
                   int pos = 0;
                   int next = 0;
                   lbl_tanggal.Text = trental.Rows[0].ItemArray.GetValue(1).ToString();
                   next = lbl_tanggal.Text.IndexOf("/", pos);
                   tempbulan = lbl_tanggal.Text.Substring(pos, next - pos);
                   pos = next + 1;
                   next = lbl_tanggal.Text.IndexOf("/", pos);
                   temptanggal = lbl_tanggal.Text.Substring(pos, next - pos);
                   temptahun = lbl_tanggal.Text.Substring(next + 1, 4);
                   lbl_tanggal.Text = temptanggal + " " + bulan_indo(tempbulan) + " " + temptahun;
                   lbl_plat.Text = trental.Rows[0].ItemArray.GetValue(4).ToString();
                   lbl_sopir.Text = trental.Rows[0].ItemArray.GetValue(2).ToString();
                   lbl_lama.Text = trental.Rows[0].ItemArray.GetValue(6).ToString();
                   lama = int.Parse(lbl_lama.Text);
                   lbl_harga.Text = trental.Rows[0].ItemArray.GetValue(8).ToString();
                   lbl_uangmuka.Text = trental.Rows[0].ItemArray.GetValue(7).ToString();
                   uang_muka = double.Parse(trental.Rows[0].ItemArray.GetValue(7).ToString());
                   harga_sewa = double.Parse(trental.Rows[0].ItemArray.GetValue(8).ToString());
                   harus_kembali = trental.Rows[0].ItemArray.GetValue(10).ToString();
                   pos = 0;
                   next = harus_kembali.IndexOf("/", pos);
                   tempbulan = harus_kembali.Substring(pos, next - pos);
                   pos = next + 1;
                   next = harus_kembali.IndexOf("/", pos);
                   temptanggal = harus_kembali.Substring(pos, next - pos);
                   temptahun = harus_kembali.Substring(next + 1, 4);
                   if (int.Parse(tempbulan) < 10)
                   {
                       tempbulan = "0" + tempbulan;
                   }
                   if (int.Parse(temptanggal) < 10)
                   {
                       temptanggal = "0" + temptanggal;
                   }
                   harus_kembali = tempbulan + "-" + temptanggal + "-" + temptahun;
                   Panjang_denda(harus_kembali);
                   sql = "select kode_mobil from mobil where id='" + lbl_plat.Text + "'";
                   tampung = koneksi.tampil_data(sql).Rows[0].ItemArray.GetValue(0).ToString();
                   sql = "select harga from harga_sewa where golongan='" + tampung + "'";
                   temp = double.Parse(koneksi.tampil_data(sql).Rows[0].ItemArray.GetValue(0).ToString());
                   if (lbl_sopir.Text != "-")
                   {
                       denda = (denda * temp) + (denda * 100000);
                       lbl_denda.Text = denda.ToString("###,###");
                   }
                   else
                   {
                       denda = denda * temp;
                       lbl_denda.Text = denda.ToString("###,###");
                   }
                    sisa= (harga_sewa-uang_muka) + denda;
                   if (sisa > 0)
                   {
                       lbl_sisa.Text = "Rp. " +sisa.ToString("###,###");
                   }
                   else
                   {
                       lbl_sisa.Text = "Rp.0";
                   }
                   lbl_nama.Text = trental.Rows[0].ItemArray.GetValue(5).ToString();
                   sql = "Select idplg from pelanggan where nama='" + lbl_nama.Text + "'";
                   lbl_id.Text = koneksi.tampil_data(sql).Rows[0].ItemArray.GetValue(0).ToString();
                   grand_total = double.Parse(trental.Rows[0].ItemArray.GetValue(8).ToString()) + denda;
                   if (denda == 0 && sisa == 0)
                   {
                       txt_bayar.Text = "0";
                       txt_bayar.Enabled = false;
                   }
                   else
                   {
                       txt_bayar.Text = "";
                       txt_bayar.Enabled = true;
                   }
                   cbfaktur.Enabled = false;
               }
               else
               {
                   inisialisasi();
               }
           }
           else
           {
               inisialisasi();
           }
       }

       private void reset_Click(object sender, EventArgs e)
       {
           inisialisasi();
           cbfaktur.Enabled = true;
       }

       private void proses_Click(object sender, EventArgs e)
       {
           if ((cbfaktur.Text == "Pilih No Faktur") || (lbl_id.Text==""))
           {
               MessageBox.Show("Anda belum memilih Faktur sewa", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
           }
           else if (txt_bayar.Text == "")
           {
               MessageBox.Show("Anda belum menginputkan Pembayaran pelanggan", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
           }
           else if (sosok < 0)
           {
               MessageBox.Show("Pembayaran tidak mencukupi", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
           }
           else
           {
               pembayaran = (pembayaran - sosok) + uang_muka;
               sql = "Update mobil set status='Tersedia' where id='" + lbl_plat.Text + "'";
               koneksi.dml(sql);
               sql = "update sopir set status='Tersedia' where nama='" + lbl_sopir.Text + "'";
               koneksi.dml(sql);
               sql = "Update rental set denda='" + denda + "',uang_muka='" + pembayaran + "', sisa_bayar='0',back='Y' where no_sewa ='" + cbfaktur.Text + "'";
               koneksi.dml(sql);
               MessageBox.Show("Proses pengembalian telah selesai", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
               inisialisasi();
               cbfaktur.Enabled = true;
           }
       }

       private void txt_bayar_KeyPress(object sender, KeyPressEventArgs e)
       {
           if (!char.IsNumber(e.KeyChar) && e.KeyChar != (char)8)
           {
               e.Handled = true;
           }
       }

       private void txt_bayar_KeyUp(object sender, KeyEventArgs e)
       {
           if (txt_bayar.Text != "")
           {
               double temp;
               pembayaran = double.Parse(txt_bayar.Text);
               temp = sisa - pembayaran;
               sosok = pembayaran - sisa;
               if (sosok > 0)
               {
                   lbl_sosok.Text = "Rp. " + sosok.ToString("###,###");
               }
               else
               {
                   lbl_sosok.Text = "Rp. 0";
               }
               if (temp > 0)
               {
                   lbl_sisa.Text = "Rp. " + temp.ToString("###,###");
               }
               else
               {
                   lbl_sisa.Text = "Rp. 0";
               }
               txt_bayar.Text = pembayaran.ToString("###,###");
               txt_bayar.SelectionStart = txt_bayar.Text.Length + 1;
           }
           else
           {
               lbl_sisa.Text = "Rp. " + sisa.ToString("###,###");
           }
       }

       private void lbl_uangmuka_TextChanged(object sender, EventArgs e)
       {
           if (lbl_uangmuka.Text != "")
           {
               double temp;
               temp = double.Parse(lbl_uangmuka.Text);
               lbl_uangmuka.Text = temp.ToString("###,###");
           }
       }

       private void lbl_denda_TextChanged(object sender, EventArgs e)
       {
           if (lbl_denda.Text != "")
           {
               double temp;
               temp = double.Parse(lbl_denda.Text);
               lbl_denda.Text = temp.ToString("###,###");
           }
       }

       private void lbl_harga_TextChanged(object sender, EventArgs e)
       {
           if (lbl_harga.Text != "")
           {
               double temp;
               temp = double.Parse(lbl_harga.Text);
               lbl_harga.Text = temp.ToString("###,###");
           }
       }
   }
}


Form pembayaran

===================
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace index
{
   public partial class pembayaran : Form
   {
       private String[] pelanggan = new String[6];
       private Double[] Harga = new Double[2];
       private int lama;
       private Double uang_muka,sisa_bayar;
       private String sql = null;
       private kon koneksi = new kon();
       private String tanggal,bulan,tahun;
       public rental init;

       public pembayaran(String[] x, Double[] y, int z)
       {
           InitializeComponent();
           pelanggan = x;
           Harga = y;
           lama = z;
       }

       private void inisialisasi()
       {
           grandtotal.Text = Harga[1].ToString("###,###");
           uangmuka.Text = "";
           sisa.Text = "0";
           atur_tanggal();
      }

       private void atur_tanggal()
       {
           int temp,tempbul,temhun;
           if (DateTimeOffset.Now.Month < 8)
           {
               if (DateTimeOffset.Now.Month == 2)
               {
                   if (DateTimeOffset.Now.Year % 4 == 0)
                   {
                       if (DateTimeOffset.Now.Day + lama > 29)
                       {
                           temp = lama - (29 - DateTimeOffset.Now.Day);
                           tempbul = DateTimeOffset.Now.Month + 1;
                           temhun = DateTimeOffset.Now.Year;
                       }
                       else
                       {
                           temp = DateTimeOffset.Now.Day + lama;
                           tempbul = DateTimeOffset.Now.Month;
                           temhun = DateTimeOffset.Now.Year;
                       }
                   }
                   else
                   {
                       if (DateTimeOffset.Now.Day + lama > 28)
                       {
                           temp = lama - (28 - DateTimeOffset.Now.Day);
                           tempbul = DateTimeOffset.Now.Month + 1;
                           temhun = DateTimeOffset.Now.Year;
                       }
                       else
                       {
                           temp = DateTimeOffset.Now.Day + lama;
                           tempbul = DateTimeOffset.Now.Month;
                           temhun = DateTimeOffset.Now.Year;
                       }
                   }
               }
               else if ((DateTimeOffset.Now.Month % 2 == 0) && (DateTimeOffset.Now.Month != 2))
               {
                   if (DateTimeOffset.Now.Day + lama > 30)
                   {
                       temp = lama - (30 - DateTimeOffset.Now.Day);
                       tempbul = DateTimeOffset.Now.Month + 1;
                       temhun = DateTimeOffset.Now.Year;
                   }
                   else
                   {
                       temp = DateTimeOffset.Now.Day + lama;
                       tempbul = DateTimeOffset.Now.Month;
                       temhun = DateTimeOffset.Now.Year;
                   }
               }
               else
               {
                   if (DateTimeOffset.Now.Day + lama > 31)
                   {
                       temp = lama - (31 - DateTimeOffset.Now.Day);
                       tempbul = DateTimeOffset.Now.Month + 1;
                       temhun = DateTimeOffset.Now.Year;
                   }
                   else
                   {
                       temp = DateTimeOffset.Now.Day + lama;
                       tempbul = DateTimeOffset.Now.Month;
                       temhun = DateTimeOffset.Now.Year;
                   }
               }
           }
           else
           {
               if (DateTimeOffset.Now.Month == 12)
               {
                   if (DateTimeOffset.Now.Day + lama > 31)
                   {
                       temp = lama - (31 - DateTimeOffset.Now.Day);
                       tempbul = 1;
                       temhun = DateTimeOffset.Now.Year+1;

                   }
                   else
                   {
                       temp = DateTimeOffset.Now.Day + lama;
                       tempbul = DateTimeOffset.Now.Month;
                       temhun = DateTimeOffset.Now.Year;
                   }
               }else if ((DateTimeOffset.Now.Month % 2 == 0)&& (DateTimeOffset.Now.Month !=12))
               {
                   if (DateTimeOffset.Now.Day + lama > 31)
                   {
                       temp = lama - (31 - DateTimeOffset.Now.Day);
                       tempbul = DateTimeOffset.Now.Month + 1;
                       temhun = DateTimeOffset.Now.Year;
                   }
                   else
                   {
                       temp = DateTimeOffset.Now.Day + lama;
                       tempbul = DateTimeOffset.Now.Month;
                       temhun = DateTimeOffset.Now.Year;
                   }
               }
               else
               {
                   if (DateTimeOffset.Now.Day + lama > 30)
                   {
                       temp = lama - (30 - DateTimeOffset.Now.Day);
                       tempbul = DateTimeOffset.Now.Month + 1;
                       temhun = DateTimeOffset.Now.Year;
                   }
                   else
                   {
                       temp = DateTimeOffset.Now.Day + lama;
                       tempbul = DateTimeOffset.Now.Month + 1;
                       temhun = DateTimeOffset.Now.Year;
                   }
               }
           }
           if (temp < 10)
           {
               tanggal = "0" + temp;
           }
           else
           {
               tanggal = temp.ToString();
           }
           if (tempbul < 10)
           {
               bulan = "0" + tempbul;
           }
           else
           {
               bulan = tempbul.ToString();
           }
           tahun = temhun.ToString();
       }
       private void pembayaran_Load(object sender, EventArgs e)
       {
           inisialisasi();
       }

       private void uangmuka_KeyPress(object sender, KeyPressEventArgs e)
       {
           if (!char.IsNumber(e.KeyChar) && e.KeyChar != (char)8)
                   {
                       e.Handled = true;
                   }
       }

       private void uangmuka_KeyUp(object sender, KeyEventArgs e)
       {

           if (uangmuka.Text != "")
           {
               uang_muka = double.Parse(uangmuka.Text);
               uangmuka.Text = uang_muka.ToString("###,###");
               uangmuka.SelectionStart = uangmuka.Text.Length + 1;
               sisa_bayar = Harga[1] - uang_muka;
               if (sisa_bayar < 0)
               {
                   sisa.Text = "0";
                   sisa_bayar = 0;
               }
               else
               {
                   sisa.Text = sisa_bayar.ToString("###,###");
               }
           }
       }

       private void selesai_Click(object sender, EventArgs e)
       {
           string harus_kembali = tahun+"-"+bulan+"-"+tanggal;
           string sekarang = DateTimeOffset.Now.Year + "-" + DateTimeOffset.Now.Month + "-" + DateTimeOffset.Now.Day;
           string ganti_sop;
           double sosok;
           if (pelanggan[3] == "")
           {
               ganti_sop = "-";
           }
           else
           {
               ganti_sop = pelanggan[3];
           }
           if (uangmuka.Text == "")
           {
               MessageBox.Show("Uang muka belum di inputkan ", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
           }
           else
           {
               sql = "update mobil set status='Order' where id='" + pelanggan[2] + "'";
               koneksi.dml(sql);
               if (pelanggan[3] != "")
               {
                   sql = " update sopir set status ='Ordered' where nama ='" + pelanggan[3] + "'";
                   koneksi.dml(sql);
               }
               sql = " select * from pelanggan where idplg ='" + pelanggan[0] + "'";
                   if (koneksi.tampil_data(sql).Rows.Count == 0)
                   {
                       sql = " insert into pelanggan (idplg, nama) values('" + pelanggan[0] + "','" + pelanggan[1] + "')";
                       koneksi.dml(sql);
                   }
                   else
                   {
                       sql = "update pelanggan set  nama='" + pelanggan[1] + "' where idplg='" + pelanggan[0] + "'";
                       koneksi.dml(sql);
                   }
               sql = " insert into rental (no_sewa, tanggal, sopir,operator, id_mobil, pelanggan, lama_rental, uang_muka, harga_sewa, sisa_bayar, kembali, denda, back) Values('" + pelanggan[4] + "','" + sekarang + "','" + ganti_sop + "','" + pelanggan[5] + "','" + pelanggan[2] + "','" + pelanggan[1] + "','" + lama + "','" + uang_muka + "','" +Harga[1] + "','" + sisa_bayar + "','" + harus_kembali + "','0','N')";
               koneksi.dml(sql);
               if (Harga[1] - uang_muka < 0)
               {
                   sosok = uang_muka - Harga[1];
                   MessageBox.Show("Proses telah selesai, Kembalian ke pelanggan sebesarRp."+sosok.ToString("###,###"),"Information",MessageBoxButtons.OK,MessageBoxIcon.Information);
                   init.inisialisasi();
                   this.Close();
               }else{
               MessageBox.Show("Proses telah selesai", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
               init.inisialisasi();
                this.Close();
               }
           }
                   
       }
   }
}

Form ubah_pass

==================
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace index
{
   public partial class ubah_pass : Form
   {
       private kon koneksi = new kon();
       private String sql = null;
       private kripto encript = new kripto();
       public ubah_pass(string x)
       {
           InitializeComponent();
           username.Text = x;

       }

       private void inisialisasi()
       {
           oldpass.Text = "";
           newpass.Text = "";
           ulangpass.Text = "";
           oldpass.Focus();
       }
       private void ubah_pass_Load(object sender, EventArgs e)
       {
           inisialisasi();
       }

       private void button1_Click(object sender, EventArgs e)
       {
           if (oldpass.Text == "")
           {
               MessageBox.Show("Password lama belum di inputkan", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
               oldpass.Focus();
           }
           else if (newpass.Text == "")
           {
               MessageBox.Show("Password baru belum di inputkan", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
               newpass.Focus();
           }
           else if (ulangpass.Text == "")
           {
               MessageBox.Show("Ulang password belum di inputkan", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
               ulangpass.Focus();
           }
           else if (newpass.Text != ulangpass.Text)
           {
               MessageBox.Show("Password baru dengan ulang password tidak sama silahkan ulangi", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
               ulangpass.Text = "";
               ulangpass.Focus();
           }
           else
           {
               sql = "select * from operator where id ='" + username.Text + "' and password ='" + encript.enkripsi(oldpass.Text) + "'";
               if (koneksi.tampil_data(sql).Rows.Count == 0)
               {
                   MessageBox.Show("Update Gagal, password lama tidak cocok", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                   inisialisasi();
               }
               else
               {
                   sql = "update operator set password='" + encript.enkripsi(newpass.Text) + "' where id='" + username.Text + "'";
                   koneksi.dml(sql);
                   MessageBox.Show("Password telah di perbaharui", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
                   this.Close();
               }
           }
       }

       private void ulangpass_KeyDown(object sender, KeyEventArgs e)
       {
           if(e.KeyCode == Keys.Enter){
               button1_Click(sender, e);
           }
       }

      

   }
}

Form report

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace index
{
   public partial class report : Form
   {
       public report()
       {
           InitializeComponent();
       }

       private void report_Load(object sender, EventArgs e)
       {
           this.rentalTableAdapter.Fill(this.rentreport.rental);

           this.reportViewer1.RefreshReport();
       }

       private void report_FormClosing(object sender, FormClosingEventArgs e)
       {
           reportViewer1.LocalReport.ReleaseSandboxAppDomain();
       }
   }
}


Next untuk melihat tampilan

0 Comments

Copyright Jujur Soaloon Sitangang Lipan All rights reserved. Theme by Sitanggang. | Bloggerized by Soalparna.