private void radButton2_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ddJenisPengiriman.Text))
{
try
{
if (this.frmDetailSurat != null)
{
SuratBusiness.InsertJenisPengiriman(nomor_agenda, GlobalFunction.SqlCharChecker(ddJenisPengiriman.Text), GlobalFunction.SqlCharChecker(txtInfoPengiriman.Text));
MessageBox.Show(this, "Data pengiriman sudah diubah.", "Data disimpan", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.frmDetailSurat.BindingJenis();
this.Close();
}
else
{
SuratBusiness.InsertJenisPengiriman(nomor_agenda, GlobalFunction.SqlCharChecker(ddJenisPengiriman.Text), GlobalFunction.SqlCharChecker(txtInfoPengiriman.Text));
MessageBox.Show(this, "Data pengiriman sudah diubah.", "Data disimpan", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.frmDetailSuratKeluar.BindingJenis();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(this, "\"Jenis Pengiriman\" tidak boleh kosong.", "Data Belum lengkap.", MessageBoxButtons.OK, MessageBoxIcon.Stop);
ddJenisPengiriman.Focus();
return;
}
}
private void GenerateDataHistory(object obj)
{
dt = SuratBusiness.SelectHistoryDisposisi(this.filter);//...SelectHistoryLoginUser(this.filter);
Thread.Sleep(50);
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
if (this.gvSejarahDisposisi.InvokeRequired)
{
this.gvSejarahDisposisi.Invoke(new addRowDelegate(this.addRow), GetDataRow(dt, i));
}
else
{
this.gvSejarahDisposisi.Rows.Insert(0, GetDataRow(dt, i));
}
Thread.Sleep(50);
}
Thread.Sleep(50);
if (frmLoading.InvokeRequired)
{
this.frmLoading.Invoke(new frmLoadingDelegate(this.closeFrmLoading), true);
}
else
{
closeFrmLoading(true);
}
}
private string InsertSurat(string _resetValue)
{
return(SuratBusiness.Insert(AppDefaultSetting.surat_masuk_format_day, AppDefaultSetting.surat_masuk_format_month, AppDefaultSetting.surat_masuk_format_year, AppDefaultSetting.surat_masuk_format_nomor_agenda,
AppDefaultSetting.surat_masuk_reset_role, _resetValue, AppDefaultSetting.surat_masuk_index_id, AppDefaultSetting.surat_masuk_concat_nomor_agenda, AppDefaultSetting.surat_masuk_minimum_id_lenght,
GlobalFunction.SqlCharChecker(dropDownTipe.Text), dtTanggalMasuk.Value, GlobalFunction.SqlCharChecker(txtNomorSurat.Text), dtTanggalSurat.Value,
GlobalFunction.SqlCharChecker(txtAsalSurat.Text), GlobalFunction.SqlCharChecker(txtPerihalSurat.Text),
GlobalFunction.SqlCharChecker(dropDownTingkatKeamanan.Text), GlobalFunction.SqlCharChecker(txtRingkasanIsi.Text),
GlobalFunction.SqlCharChecker(txtLampiran.Text), T8UserLoginInfo.Username, this.start_index,
SuratBusiness.GetSimbol(GlobalFunction.SqlCharChecker(dropDownTipe.Text), "kategori_surat"),
SuratBusiness.GetSimbol(GlobalFunction.SqlCharChecker(dropDownTingkatKeamanan.Text), "tingkat_keamanan")));
}
private void btnSimpan_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(lblNomorAgenda.Text.Replace("\0", "")))
{
MessageBox.Show(this, "\"Nomor Agenda\" tidak boleh kosong.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
lblNomorAgenda.Focus();
return;
}
if (!SuratQuery.IsSuratMasuk(lblNomorAgenda.Text.Replace("\0", "")))
{
MessageBox.Show(this, "Data surat tidak ditemukan.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
lblNomorAgenda.Focus();
return;
}
if (string.IsNullOrEmpty(txtPenyelesaianOleh.Text))
{
MessageBox.Show(this, "Penyelesaian oleh tidak boleh kosong.", "Data tidak lengkap", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtPenyelesaianOleh.Focus();
return;
}
if (string.IsNullOrEmpty(txtPenyelesaian.Text))
{
MessageBox.Show(this, "Penyelesaian tidak boleh kosong.", "Data tidak lengkap", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtPenyelesaian.Focus();
return;
}
if (MessageBox.Show(this, "Apakah Anda yakin akan melakukan penyelesaian pada surat ini?", "Konfirmasi", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)
== System.Windows.Forms.DialogResult.No)
{
return;
}
SuratBusiness.InsertHistoryPenyelesaian
(lblNomorAgenda.Text.Replace("\0", ""), dtTanggalPenyelesaian.Value, GlobalFunction.SqlCharChecker(txtPenyelesaianOleh.Text),
GlobalFunction.SqlCharChecker(txtPenyelesaian.Text), T8UserLoginInfo.Username);
MessageBox.Show(this, "Data penyelesaian sudah disimpan.", "Simpan Disposisi", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
if (chkOtomatisCetakLembarDisposisi.Checked)
{
PrintAgenda();
}
clearInput();//this.Close();
}
public void BindingLokasi()
{
DataTable dtLokasi = SuratBusiness.GetLokasi(this.lblNomorAgenda.Text);
if (dtLokasi.Rows.Count == 0)
{
lblLokasi.Text = "{data kosong}";
lblLokasi.Font = new Font("MS Reference Sans Serif", (float)9.75, FontStyle.Italic);
lblInfoLokasi.Text = "{data kosong}";
lblInfoLokasi.Font = new Font("MS Reference Sans Serif", (float)9.75, FontStyle.Italic);
}
else
{
lblLokasi.Text = dtLokasi.Rows[0][0].ToString();
lblLokasi.Font = new Font("MS Reference Sans Serif", (float)9.75, FontStyle.Regular);
lblInfoLokasi.Text = dtLokasi.Rows[0][1].ToString();
lblInfoLokasi.Font = new Font("MS Reference Sans Serif", (float)9.75, FontStyle.Regular);
}
}
public void BindingJenis()
{
DataTable dtJenisPengiriman = SuratBusiness.getJenisPengiriman(this.lblNomorAgenda.Text);
if (dtJenisPengiriman.Rows.Count == 0)
{
lblJenisPengiriman.Text = "{data kosong}";
lblJenisPengiriman.Font = new Font("MS Reference Sans Serif", (float)9.75, FontStyle.Italic);
lblInfoPengiriman.Text = "{data kosong}";
lblInfoPengiriman.Font = new Font("MS Reference Sans Serif", (float)9.75, FontStyle.Italic);
}
else
{
lblJenisPengiriman.Text = dtJenisPengiriman.Rows[0][0].ToString();
lblJenisPengiriman.Font = new Font("MS Reference Sans Serif", (float)9.75, FontStyle.Regular);
lblInfoPengiriman.Text = dtJenisPengiriman.Rows[0][1].ToString();
lblInfoPengiriman.Font = new Font("MS Reference Sans Serif", (float)9.75, FontStyle.Regular);
}
}
//private void GenerateDataSuratkeluar()
//{
// DataTable dt = Data.SuratQuery.GetNomorAgendaSK("", 0, 0);
// for (int i = 0; i < dt.Rows.Count; i++)
// {
// txtReferensiSurat.Items.Add(dt.Rows[i][0].ToString());
// }
//}
private void radButton2_Click(object sender, EventArgs e)
{
if (MessageBox.Show(this, "Anda yakin akan mengubah data referensi surat?", "Konfirmasi", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == System.Windows.Forms.DialogResult.Yes)
{
try
{
if (!SuratQuery.IsSuratKeluar(GlobalFunction.SqlCharChecker(txtReferensiSurat.Text.Replace("\0", ""))))
{
MessageBox.Show(this, "Data surat referensi tidak ditemukan, silahkan cek kembali.", "Data Salah", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
SuratBusiness.ReferensiSuratMasuk(this.act, lblNomorAgenda.Text, GlobalFunction.SqlCharChecker(txtReferensiSurat.Text.Replace("\0", "")));
this.frmInfoSuratKeluar.lblReferensiSurat.Text = txtReferensiSurat.Text;
this.frmInfoSuratKeluar.lblReferensiSurat.Font = new Font("MS Reference Sans Serif", (float)9.75, FontStyle.Regular);
MessageBox.Show(this, "Data sudah disimpan.", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
catch (Exception ex)
{ }
}
}
private void radButton2_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(ddLokasiFisikSurat.Text))
{
try
{
SuratBusiness.InsertLokasiFisikSurat(this.nomor_agenda, GlobalFunction.SqlCharChecker(ddLokasiFisikSurat.Text),
GlobalFunction.SqlCharChecker(txtKeteranganLokasi.Text), T8UserLoginInfo.Username);
MessageBox.Show(this, "Data lokasi surat sudah diubah.", "Data disimpan", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.frmDetailSurat.BindingLokasi();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(this, ex.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
MessageBox.Show(this, "\"Lokasi Surat\" tidak boleh kosong.", "Data Belum lengkap.", MessageBoxButtons.OK, MessageBoxIcon.Stop);
ddLokasiFisikSurat.Focus();
return;
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(lblNomorAgenda.Text.Replace("\0", "")))
{
MessageBox.Show(this, "\"Nomor Agenda\" tidak boleh kosong.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
lblNomorAgenda.Focus();
return;
}
if (!SuratQuery.IsSuratKeluar(lblNomorAgenda.Text.Replace("\0", "")))
{
MessageBox.Show(this, "Data surat tidak ditemukan.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
lblNomorAgenda.Focus();
return;
}
string values = "";
if (MessageBox.Show(this, "Anda yakin akan melakukan perubahan pada data surat ini?", "Konfirmasi", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)
== System.Windows.Forms.DialogResult.No)
{
return;
}
if (string.Format("{0:yyyy-MM-dd}", dtTanggalKirim.Value) != string.Format("{0:yyyy-MM-dd}", (DateTime)drAsli[3]))
{
SuratBusiness.EditSuratKeluar(this.nomor_agenda.Replace("\0", ""), "tanggal_kirim", string.Format("{0:yyyy-MM-dd}", (DateTime)drAsli[3]),
string.Format("{0:yyyy-MM-dd}", dtTanggalKirim.Value), T8UserLoginInfo.Username);
if (values != "")
{
values = values + ",";
}
values = values + " tanggal_kirim = '" + string.Format("{0:yyyy-MM-dd}", dtTanggalKirim.Value) + "' ";
}
if (txtTujuan.Text != drAsli[4].ToString())
{
SuratBusiness.EditSuratKeluar
(this.nomor_agenda, "tujuan", GlobalFunction.SqlCharChecker(drAsli[4].ToString()), GlobalFunction.SqlCharChecker(txtTujuan.Text),
T8UserLoginInfo.Username);
if (values != "")
{
values = values + ",";
}
values = values + " tujuan = '" + GlobalFunction.SqlCharChecker(txtTujuan.Text) + "' ";
}
if (txtPerihalSurat.Text != drAsli[5].ToString())
{
SuratBusiness.EditSuratKeluar
(this.nomor_agenda, "perihal", GlobalFunction.SqlCharChecker(drAsli[5].ToString()), GlobalFunction.SqlCharChecker(txtPerihalSurat.Text),
T8UserLoginInfo.Username);
if (values != "")
{
values = values + ",";
}
values = values + " perihal = '" + GlobalFunction.SqlCharChecker(txtPerihalSurat.Text) + "' ";
}
if (dropDownTingkatKeamanan.Text != drAsli[6].ToString())
{
SuratBusiness.EditSuratKeluar
(this.nomor_agenda, "tingkat_keamanan", GlobalFunction.SqlCharChecker(drAsli[6].ToString()), GlobalFunction.SqlCharChecker(dropDownTingkatKeamanan.Text),
T8UserLoginInfo.Username);
if (values != "")
{
values = values + ",";
}
values = values + " tk_keamanan = '" + GlobalFunction.SqlCharChecker(dropDownTingkatKeamanan.Text) + "' ";
}
if (txtRingkasanIsi.Text != drAsli[7].ToString())
{
SuratBusiness.EditSuratKeluar
(this.nomor_agenda, "ringkasan_isi", GlobalFunction.SqlCharChecker(drAsli[7].ToString()), GlobalFunction.SqlCharChecker(txtRingkasanIsi.Text),
T8UserLoginInfo.Username);
if (values != "")
{
values = values + ",";
}
values = values + " ringkasan_isi = '" + GlobalFunction.SqlCharChecker(txtRingkasanIsi.Text) + "' ";
}
if (txtLampiran.Text != drAsli[8].ToString())
{
SuratBusiness.EditSuratKeluar
(this.nomor_agenda, "lampiran", drAsli[8].ToString(), txtLampiran.Text, T8UserLoginInfo.Username);
if (values != "")
{
values = values + ",";
}
values = values + " lampiran = '" + GlobalFunction.SqlCharChecker(txtLampiran.Text) + "' ";
}
if (values == "")
{
return;
}
SuratBusiness.UpdateKeluar(this.nomor_agenda, values);
this.frmMain.UpdateSuratKeluar(this, this.nomor_agenda.Replace("\0", ""));
MessageBox.Show(this, "Data surat sudah di ubah.", "Update Sukses", MessageBoxButtons.OK, MessageBoxIcon.Information);
clearInput();//(); // this.Close();
}
private void GenerateData(object obj)
{
dt = SuratBusiness.SelectTemplate(this.filter);
Thread.Sleep(50);
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
if (tbTemplate.SelectedPage == radPageViewPage1)
{
if (this.gvTemplateKategori.InvokeRequired)
{
this.gvTemplateKategori.Invoke(new addRowDelegate(this.addRow), GetDataRow(dt, i));
}
else
{
this.gvTemplateKategori.Rows.Insert(0, GetDataRow(dt, i));
}
}
if (tbTemplate.SelectedPage == radPageViewPage2)
{
if (this.gvAsalSurat.InvokeRequired)
{
this.gvAsalSurat.Invoke(new addRowDelegate(this.addRow), GetDataRow(dt, i));
}
else
{
this.gvAsalSurat.Rows.Insert(0, GetDataRow(dt, i));
}
}
if (tbTemplate.SelectedPage == radPageViewPage3)
{
if (this.gvPenerima.InvokeRequired)
{
this.gvPenerima.Invoke(new addRowDelegate(this.addRow), GetDataRow(dt, i));
}
else
{
this.gvPenerima.Rows.Insert(0, GetDataRow(dt, i));
}
}
if (tbTemplate.SelectedPage == radPageViewPage4)
{
if (this.gvTkKeamanan.InvokeRequired)
{
this.gvTkKeamanan.Invoke(new addRowDelegate(this.addRow), GetDataRow(dt, i));
}
else
{
this.gvTkKeamanan.Rows.Insert(0, GetDataRow(dt, i));
}
}
if (tbTemplate.SelectedPage == radPageViewPage5)
{
if (this.gvLokasi.InvokeRequired)
{
this.gvLokasi.Invoke(new addRowDelegate(this.addRow), GetDataRow(dt, i));
}
else
{
this.gvLokasi.Rows.Insert(0, GetDataRow(dt, i));
}
}
if (tbTemplate.SelectedPage == radPageViewPage6)
{
if (this.gvJenisPengiriman.InvokeRequired)
{
this.gvJenisPengiriman.Invoke(new addRowDelegate(this.addRow), GetDataRow(dt, i));
}
else
{
this.gvJenisPengiriman.Rows.Insert(0, GetDataRow(dt, i));
}
}
Thread.Sleep(50);
}
Thread.Sleep(50);
if (frmLoading.InvokeRequired)
{
this.frmLoading.Invoke(new frmLoadingDelegate(this.closeFrmLoading), true);
}
else
{
closeFrmLoading(true);
}
}
private void btnSimpan_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(dropDownTipe.Text))
{
MessageBox.Show(this, "\"Kategori surat\" tidak boleh kosong.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
dropDownTipe.Focus();
return;
}
if (string.IsNullOrEmpty(txtNomorSurat.Text))
{
MessageBox.Show(this, "\"Nomor surat\" tidak boleh kosong.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtNomorSurat.Focus();
return;
}
if (string.IsNullOrEmpty(txtAsalSurat.Text))
{
MessageBox.Show(this, "\"Asal surat\" tidak boleh kosong.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtAsalSurat.Focus();
return;
}
if (string.IsNullOrEmpty(txtPerihalSurat.Text))
{
MessageBox.Show(this, "\"Perihal surat\" tidak boleh kosong.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
txtPerihalSurat.Focus();
return;
}
if (string.IsNullOrEmpty(dropDownTingkatKeamanan.Text))
{
MessageBox.Show(this, "\"Tingkat Keamanan\" tidak boleh kosong.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
dropDownTingkatKeamanan.Focus();
return;
}
if (chkOtomatisCetakLembarDisposisi.Checked)
{
if (string.IsNullOrEmpty(txtTujuanDisposisi.Text))
{
MessageBox.Show(this, "\"Tujuan Disposisi\" tidak boleh kosong.", "Input Kosong", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
}
if (MessageBox.Show(this, "Anda yakin akan menginputkan data surat?", "Konfirmasi", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2)
== System.Windows.Forms.DialogResult.Yes)
{
try
{
string resetValue = "";
string reset_id = "";
if (AppDefaultSetting.surat_masuk_reset_role.ToLower() == "kategori".ToLower())
{
resetValue = dropDownTipe.Text;
}
else if (AppDefaultSetting.surat_masuk_reset_role.ToLower() == "tkkeamanan".ToLower())
{
resetValue = dropDownTingkatKeamanan.Text;
}
if (AppDefaultSetting.surat_masuk_reset_role.ToLower() == "kategori".ToLower())
{
reset_id = AppDefaultSetting.surat_masuk_reset_role;
}
else if (AppDefaultSetting.surat_masuk_reset_role.ToLower() == "tkkeamanan".ToLower())
{
reset_id = AppDefaultSetting.surat_masuk_reset_role;
}
else if (AppDefaultSetting.surat_masuk_reset_role.ToLower() == "daily".ToLower())
{
reset_id = string.Format("{0:yyyy-MM-dd}", dtTanggalMasuk.Value);
}
else if (AppDefaultSetting.surat_masuk_reset_role.ToLower() == "monthly".ToLower())
{
reset_id = string.Format("{0:yyyy-MM-dd}", dtTanggalMasuk.Value);
}
else if (AppDefaultSetting.surat_masuk_reset_role.ToLower() == "yearly".ToLower())
{
reset_id = string.Format("{0:yyyy-MM-dd}", dtTanggalMasuk.Value);
}
else
{
reset_id = "";
}
start_index = 1;
if (JumlahSurat(reset_id, resetValue) == 0)
{
if (AppDefaultSetting.surat_masuk_index_start.ToString().ToLower() != "Flat (Value = 1)".ToLower())
{
Surat.FrmStartIndex frmStartIndex = new Surat.FrmStartIndex(this);
frmStartIndex.ShowDialog();
}
}
if (this.start_index == 0)
{
return;
}
nomor_agenda = InsertSurat(resetValue);
if (!string.IsNullOrEmpty(txtReferensiSurat.Text))
{
if (SuratQuery.IsSuratKeluar(GlobalFunction.SqlCharChecker(txtReferensiSurat.Text.Replace("\0", ""))))
{
SuratBusiness.InsertReferensiSurat(nomor_agenda, GlobalFunction.SqlCharChecker(txtReferensiSurat.Text.Replace("\0", "")));
}
}
if (!string.IsNullOrEmpty(txtTujuanDisposisi.Text))
{
SuratBusiness.InsertDisposisi(nomor_agenda, dtTanggalDisposisi.Value, GlobalFunction.SqlCharChecker(txtTujuanDisposisi.Text),
GlobalFunction.SqlCharChecker(txtIsisDisposisi.Text), T8UserLoginInfo.Username);
}
if (!string.IsNullOrEmpty(ddJenisPengiriman.Text))
{
SuratBusiness.InsertJenisPengiriman(nomor_agenda, GlobalFunction.SqlCharChecker(ddJenisPengiriman.Text),
GlobalFunction.SqlCharChecker(txtInfoPengiriman.Text));
}
if (!string.IsNullOrEmpty(ddLokasiFisikSurat.Text))
{
SuratBusiness.InsertLokasiFisikSurat(nomor_agenda, GlobalFunction.SqlCharChecker(ddLokasiFisikSurat.Text),
GlobalFunction.SqlCharChecker(txtKeteranganLokasi.Text), T8UserLoginInfo.Username);
}
MessageBox.Show(this, "Nomor agenda surat: " + nomor_agenda, "Data Disimpan", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.frmMain.insertSingleSurat(this);
MessageBox.Show(this, "Data surat sudah disimpan di database.", "Input sukses", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
if (chkOtomatisCetakLembarDisposisi.Checked)
{
PrintAgenda();
}
clearInput();
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
T8CoreEnginee.T8Application.DBConnection.Close();
}
}
}
