private void textBoxCariSuratMasuk_TextChanged(object sender, EventArgs e)
{
cari = textBoxCariSuratMasuk.Text;
suratMasuk surat_masuk = new suratMasuk();
setDataTable(surat_masuk.cariSuratMasuk(kriteria, cari));
}
private void FormSuratMasuk_Load(object sender, EventArgs e)
{
suratMasuk surat_masuk = new suratMasuk();
setDataTable(surat_masuk.getAllSuratMasuk());
kriteria = "nomor_surat_masuk";
}
private void dateTimeInput1_MonthCalendar_DateChanged(object sender, EventArgs e)
{
cari = dateTimeInputTanggalSurat.Value.Date.ToString("yyyy-MM-dd");
suratMasuk surat_masuk = new suratMasuk();
setDataTable(surat_masuk.cariSuratMasuk(kriteria, cari));
}
private void radioButtonInstansiPengirim_CheckedChanged(object sender, EventArgs e)
{
kriteria = "pengirim";
textBoxCariSuratMasuk.BringToFront();
suratMasuk surat_masuk = new suratMasuk();
setDataTable(surat_masuk.getAllSuratMasuk());
}
private void radioButtonTanggalTerima_CheckedChanged(object sender, EventArgs e)
{
kriteria = "tanggal_terima";
textBoxCariSuratMasuk.SendToBack();
dateTimeInputTanggalSurat.BringToFront();
suratMasuk surat_masuk = new suratMasuk();
setDataTable(surat_masuk.getAllSuratMasuk());
}
private void dataGridViewSuratMasuk_SelectionChanged(object sender, EventArgs e)
{
suratMasuk surat_masuk = new suratMasuk();
foreach (DataGridViewRow row in dataGridViewSuratMasuk.SelectedRows)
{
nomor_surat = row.Cells[1].Value.ToString();
}
}
private void buttonGambarSuratMasuk_Click(object sender, EventArgs e)
{
suratMasuk surat_masuk = new suratMasuk();
OpenFileDialog dialog = new OpenFileDialog();
dialog.Filter = "Image Files(*.jpg; *.jpeg; *.gif; *.bmp)|*.jpg; *.jpeg; *.gif; *.bmp";
if (dialog.ShowDialog() == DialogResult.OK)
{
lokasi_gambar = dialog.FileName;
setGambar(Path.GetFileName(dialog.FileName));
pictureBoxGambarSuratMasuk.Image = new Bitmap(dialog.FileName);
}
}
private void buttonHapusSuratMasuk_Click(object sender, EventArgs e)
{
suratMasuk surat_masuk = new suratMasuk();
string title = "Konfirmasi Penghapusan Data";
string konten = "Apakah Anda yakin ingin menghapus data?";
DialogResult result = MessageBox.Show(konten, title, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == System.Windows.Forms.DialogResult.Yes)
{
surat_masuk.deleteTembusanSuratMasuk(nomor_surat);
surat_masuk.deleteLampiranSuratMasuk(nomor_surat);
surat_masuk.deleteDistribusiSuratMasuk(nomor_surat);
surat_masuk.deleteSuratMasuk(nomor_surat);
setDataTable(surat_masuk.getAllSuratMasuk());
}
}
private void buttonEditSuratMasuk_Click(object sender, EventArgs e)
{
suratMasuk surat_masuk = new suratMasuk();
string lokasi_tujuan;
surat_masuk.nomor_surat = textBoxNomorSuratMasuk.Text;
surat_masuk.tgl_surat = dateTimeInputTanggalSuratMasuk.Value.Date.ToString("dd-MM-yyyy");
surat_masuk.tgl_terima = dateTimeInputTanggalTerimaSuratMasuk.Value.Date.ToString("dd-MM-yyyy");
surat_masuk.jenis_surat = comboBoxJenisSuratMasuk.Text;
surat_masuk.sifat_surat = comboBoxSifatSuratMasuk.Text;
surat_masuk.perihal_surat = textBoxPerihalSuratMasuk.Text;
surat_masuk.keterangan_surat = textBoxKeteranganSuratMasuk.Text;
surat_masuk.isi_surat = textBoxIsiSuratMasuk.Text;
surat_masuk.pengirim = textBoxInstansiPengirimSuratMasuk.Text;
surat_masuk.alamat_pengirim = textBoxAlamatPengirimSuratMasuk.Text;
surat_masuk.penerima = textBoxPenerimaSuratMasuk.Text;
//jabatan_tertanda = textBoxJabatanTertandaSuratMasuk.Text;
//tertanda = textBoxTertandaPengirimSuratMasuk.Text;
surat_masuk.tanggal_distribusi = dateTimeInputTanggalDistribusiSuratMasuk.Value.Date.ToString("dd-MM-yyyy");
lokasi_tujuan = "";
surat_masuk.gambar = getGambar();
if (cekValid())
{
return;
}
else
{
if (pictureBoxGambarSuratMasuk.Image != null)
{
lokasi_tujuan = Application.StartupPath + "\\image_surat_masuk";
if (!Directory.Exists(lokasi_tujuan))
{
Directory.CreateDirectory(lokasi_tujuan);
}
if (!File.Exists(Application.StartupPath + "\\image_surat_masuk\\" + getGambar()))
{
File.Copy(lokasi_gambar, lokasi_tujuan + "\\" + getGambar(), true);
}
}
surat_masuk.editSuratMasuk();
}
frm1.setDataTable(surat_masuk.getAllSuratMasuk());
Close();
}
public void setDataTable(MySqlDataReader reader)
{
DataTable jenis_surat = new DataTable();
suratMasuk surat_masuk = new suratMasuk();
jenis_surat.Load(reader);
jenis_surat.Columns[0].ColumnName = "Nomor Urut";
jenis_surat.Columns[1].ColumnName = "Nomor Surat";
jenis_surat.Columns[2].ColumnName = "Tanggal Surat";
jenis_surat.Columns[3].ColumnName = "Tanggal Terima";
jenis_surat.Columns[4].ColumnName = "Perihal";
jenis_surat.Columns[5].ColumnName = "Pengirim";
jenis_surat.Columns[6].ColumnName = "Sifat Surat";
jenis_surat.Columns[7].ColumnName = "Jenis Surat";
dataGridViewSuratMasuk.ClearSelection();
dataGridViewSuratMasuk.DataSource = jenis_surat;
dataGridViewSuratMasuk.AutoResizeColumns();
labelJumlahSurat.Text = "Jumlah Surat Masuk : " + dataGridViewSuratMasuk.RowCount.ToString();
}
