using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Data;

using System.Data.OleDb;



namespace latihan_datagridview

{

 class cuti

 {

 public string id_cuti

 {

 get;

 set;

 }



 public string kodePegawai

 {

 get;

 set;

 }



 public string tgl_mulai

 {

 get;

 set;

 }



 public string tgl_selesai

 {

 get;

 set;

 }



 public string keterangan

 {

 get;

 set;

 }



 public string tgl_input

 {

 get;

 set;

 }



 



 public string nomerIdCuti()

 {

 

 string ac;

 string ad;

 string abcde;

 string perintah = "select max(id_cuti) from cuti where tanggal_input=#"+this.tgl_input+"#";

 OleDbConnection conn = new OleDbConnection(Program.konek);

 conn.Open();

 OleDbCommand comm = new OleDbCommand(perintah, conn);

 DataSet ds = new DataSet();

 OleDbDataAdapter da = new OleDbDataAdapter(comm);

 da.Fill(ds,"barucuti");

 

 if (ds.Tables["barucuti"].Rows[0].ItemArray[0].ToString() != "")

 {

 ac = string.Format("{0:ddMMyy.CT}",DateTime.Now);

 ad = ds.Tables["barucuti"].Rows[0].ItemArray[0].ToString().Substring(9, 5);

 int ade = int.Parse(ad)+1;

 abcde = ac + (ade.ToString());



 }

 else

 {

 abcde = string.Format("{0:ddMMyy.CT10001}",DateTime.Now);

 }

 

 conn.Close();



 return abcde;

 }



 public void tampildataCuti2(System.Windows.Forms.DataGridView ab)

 {

 int xyz = 0;

 string perintah1 = "select id_cuti, kode_pegawai, tgl_mulai, tgl_selesai, ket from cuti";

 string perintah2 = "select count(id_cuti) from cuti";

 OleDbConnection conn = new OleDbConnection(Program.konek);

 conn.Open();

 OleDbCommand comm = new OleDbCommand(perintah2, conn);

 int jml = (int)comm.ExecuteScalar();

 conn.Close();

 ab.Rows.Clear();

 if (jml > 0)

 {

 

 ab.Rows.Add(jml);

 }

 OleDbConnection connn = new OleDbConnection(Program.konek);

 connn.Open();

 OleDbCommand commm = new OleDbCommand(perintah1, connn);

 OleDbDataReader rd = commm.ExecuteReader();

 

 while (rd.Read())

 {

 ab.Rows[xyz].Cells[0].Value = rd[0].ToString();

 ab.Rows[xyz].Cells[1].Value = rd[1].ToString();

 ab.Rows[xyz].Cells[2].Value = string.Format("{0:dd-MM-yyyy}",rd.GetDateTime(2).Date);

 ab.Rows[xyz].Cells[3].Value = string.Format("{0:dd-MM-yyyy}", rd.GetDateTime(3).Date);

 ab.Rows[xyz].Cells[4].Value = rd[4].ToString();

 xyz += 1;

 }



 connn.Close();

 

 }



 public DataSet tampildataCuti()

 {

 string perintah = "select id_cuti as [ID Cuti], kode_pegawai as [Kode Pegawai], tgl_mulai as [Tanggal Mulai Cuti], tgl_selesai as [Tanggal Selesai Cuti], ket as [Keterangan] from cuti";

 OleDbConnection conn = new OleDbConnection(Program.konek);

 conn.Open();

 OleDbCommand comm = new OleDbCommand(perintah, conn);

 DataSet ds = new DataSet();

 OleDbDataAdapter da = new OleDbDataAdapter(comm);

 da.Fill(ds, "tampil");

 

 conn.Close();

 return ds;

 }



 public void simpandataCuti()

 {

 string perintah = "insert into cuti values('"+this.id_cuti+"','"+this.kodePegawai+"',#"+this.tgl_mulai+"#,#"+this.tgl_selesai+"#,'"+this.keterangan+"',#"+this.tgl_input+"#)";

 OleDbConnection conn = new OleDbConnection(Program.konek);

 conn.Open();

 OleDbCommand comm = new OleDbCommand(perintah, conn);

 comm.ExecuteNonQuery();

 conn.Close();

 System.Windows.Forms.MessageBox.Show("Data cuti berhasil disimpan");

 }



 public void updatedataCuti()

 {

 string perintah = "update cuti set kode_pegawai='" + this.kodePegawai + "', tgl_mulai=#" + this.tgl_mulai + "#, tgl_selesai=#" + this.tgl_selesai + "#, ket='" + this.keterangan + "' where id_cuti='" + this.id_cuti + "' ";

 OleDbConnection conn = new OleDbConnection(Program.konek);

 conn.Open();

 OleDbCommand comm = new OleDbCommand(perintah, conn);

 comm.ExecuteNonQuery();

 conn.Close();

 }



 public void hapusdataCuti()

 {

 string perintah = "delete from cuti where id_cuti='" + this.id_cuti + "' ";

 OleDbConnection conn = new OleDbConnection(Program.konek);

 conn.Open();

 OleDbCommand comm = new OleDbCommand(perintah, conn);

 comm.ExecuteNonQuery();

 conn.Close();

 }

 }

}

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 latihan_datagridview

{

 public partial class cutiijinsakit : Form

 {

 cuti ct;

 public cutiijinsakit()

 {

 InitializeComponent();

 }



 private void cutiijinsakit_Load(object sender, EventArgs e)

 {

 ct = new cuti();

 ct.tampildataCuti2(dataGridView1);

 /*dataGridView1.DataSource = ct.tampildataCuti().Tables["tampil"];

 dataGridView1.Columns[2].DefaultCellStyle.Format = "dd-MM-yyyy";

 dataGridView1.Columns[3].DefaultCellStyle.Format = "dd-MM-yyyy";*/

 

 ct.tgl_input = string.Format("{0:dd-MM-yyyy}", DateTime.Now);

 txtidcuti.Text=ct.nomerIdCuti();

 }



 private void btnsimpan_Click(object sender, EventArgs e)

 {

 ct = new cuti();

 ct.id_cuti = txtidcuti.Text;

 ct.kodePegawai = txtkodepeg.Text;

 ct.tgl_mulai = txttglmulai.Text;

 ct.tgl_selesai = txttglselesai.Text;

 ct.keterangan = txtket.Text;

 ct.tgl_input = string.Format("{0:dd-MM-yyyy}",DateTime.Now);

 

 ct.simpandataCuti();

 txtidcuti.Text = ct.nomerIdCuti();

 ct.tampildataCuti2(dataGridView1);

 /*dataGridView1.DataSource = ct.tampildataCuti().Tables["tampil"];

 dataGridView1.Columns[2].DefaultCellStyle.Format = "dd-MM-yyyy";

 dataGridView1.Columns[3].DefaultCellStyle.Format = "dd-MM-yyyy";*/

 }



 private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)

 {

 if (e.RowIndex > -1)

 {

 if (e.ColumnIndex == dataGridView1.Columns["Column6"].Index)

 {

 if (MessageBox.Show("Apa anda yakin ingin menghapus data ini ?", "Peringatan", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes)

 {

 ct = new cuti();

 ct.id_cuti = dataGridView1[0,e.RowIndex].Value.ToString();

 

 

 ct.hapusdataCuti();

 MessageBox.Show("Berhasil dihapus");

 ct.tampildataCuti2(dataGridView1);

 /*dataGridView1.DataSource = ct.tampildataCuti().Tables["tampil"];

 dataGridView1.Columns[2].DefaultCellStyle.Format = "dd-MM-yyyy";

 dataGridView1.Columns[3].DefaultCellStyle.Format = "dd-MM-yyyy";*/

 }

 }



 if (e.ColumnIndex == dataGridView1.Columns["Column7"].Index)

 {

 Boolean hidup = true;

 if (hidup)

 {

 dataGridView1.Columns["Column7"].HeaderText = "Save";

 hidup = false;

 }

 else 

 {

 ct = new cuti();

 ct.id_cuti = dataGridView1[0, e.RowIndex].Value.ToString();

 ct.kodePegawai = dataGridView1[1, e.RowIndex].Value.ToString();

 ct.tgl_mulai=dataGridView1[2,e.RowIndex].Value.ToString();

 ct.tgl_selesai = dataGridView1[3, e.RowIndex].Value.ToString();

 ct.keterangan = dataGridView1[4, e.RowIndex].Value.ToString();

 MessageBox.Show("Berhasil diupdate");

 dataGridView1.Columns["Column7"].HeaderText = "Edit";

 hidup = true;

 }

 }

 }

 }



 

 }

}