public static void DeleteHistoryEditSuratmasuk(string _filter)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from history_edit_surat " + _filter);
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void DeleteUserTKKeamanan(string _username)
{
StringBuilder sb = new StringBuilder();
sb.Append(" delete from user_tk_keamanan where `username`='" + _username + "'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void InsertUserTKKeamanan(string _username, string _tkKeamanan)
{
StringBuilder sb = new StringBuilder();
sb.Append(" insert into user_tk_keamanan(`username`,`tk_keamanan_name`) values('" + _username + "','" + _tkKeamanan + "')");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void InsertUserKategori(string _username, string _kategori)
{
StringBuilder sb = new StringBuilder();
sb.Append(" insert into user_kategori(`username`,`kategori_name`) values('" + _username + "','" + _kategori + "')");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void UpdatePassword(string _username, string _password)
{
StringBuilder sb = new StringBuilder();
sb.Append("update user set password='******' where username='******'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void DeleteTemplateData(string _nama)
{
StringBuilder sb = new StringBuilder();
sb.Append(" delete from template_data where nama='" + _nama + "' ");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void Delete(string _nomor_agenda)
{
StringBuilder sb = new StringBuilder();
sb.Append(" delete from surat_masuk ");
sb.Append(" where nomor_agenda='" + _nomor_agenda + "' ");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void UpdateSuratKeluar(string _nomor_surat, string _values)
{
StringBuilder sb = new StringBuilder();
sb.Append("update surat_keluar ");
sb.Append("set " + _values);
sb.Append("where `nomor_surat` = '" + _nomor_surat + "'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
//public static DataTable GetTemplate(string _filter)
//{
// throw new NotImplementedException();
//}
public static void UpdatetTemplateData(string _nama, string _simbol, string _keterangan, string _template_name, string _status)
{
StringBuilder sb = new StringBuilder();
sb.Append(" update template_data ");
sb.Append(" set simbol='" + _simbol + "', keterangan='" + _keterangan + "', status='" + _status + "' ");
sb.Append(" where nama='" + _nama + "' and template='" + _template_name + "'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void EditUser(string _username, string _kolom, string _data_lama, string _data_baru, string _user)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into ");
sb.Append("history_edit_user (`username`,`datetime_input`,`kolom`,`data_lama`,`data_baru`,`user`) ");
sb.Append("values('" + _username + "',Now(),'" + _kolom + "','" + _data_lama + "','" + _data_baru + "','" + _user + "')");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void UpdateHitoryLoginUser(Guid _guid)
{
StringBuilder sb = new StringBuilder();
sb.Append("update history_login_user ");
sb.Append("set datetime_logout = NOW() ");
sb.Append("where id_login='******'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void UpdateStatusUser(string _username, string _status)
{
StringBuilder sb = new StringBuilder();
sb.Append("update user ");
sb.Append("set status = '" + _status + "' ");
sb.Append("where username = '******'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void InsertTemplateData(string _nama, string _simbol, string _keterangan, string _template_name, string _status)
{
DataTable dt = new DataTable();
StringBuilder sb = new StringBuilder();
sb.Append("insert into template_data (`nama`, `simbol`, `keterangan`, `template`,`status`) ");
sb.Append("values('" + _nama + "','" + _simbol + "','" + _keterangan + "','" + _template_name + "','" + _status + "')");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void InsertHistoryDisposisi(string _nomor_agenda, DateTime _tglDisposisi, string _disposisi, string _isi_disposisi, string _user)
{
StringBuilder sb = new StringBuilder();
sb.Append(" insert into disposisi (`nomor_agenda`,`datetime_input`,`tanggal_disposisi`,`tujuan_disposisi`,`isi_disposisi`,`user`) ");
sb.Append(" values ");
sb.Append(" ('" + _nomor_agenda + "', Now(),'" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", _tglDisposisi) + "','" + _disposisi + "','" + _isi_disposisi + "','" + _user + "') ");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void Insert(string _username, string _password, string _hakAkses, string _status, string _user)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into user (`username`,`password`,`hak_akses`,`status`,`datetime_input`,`user`) ");
sb.Append("values ");
sb.Append("('" + _username + "','" + _password + "','" + _hakAkses + "','" + _status + "',NOW(),'" + _user + "')");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void InsertJenisPengirimanSurat(string _nomor_agenda, string _jenis_pengiriman, string _info_pengiriman)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into pengiriman (`nomor_agenda`,`jenis_pengiriman`,`info_pengiriman`) ");
sb.Append(" values ");
sb.Append(" ('" + _nomor_agenda + "', '" + _jenis_pengiriman + "','" + _info_pengiriman + "')");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void InsertHistoryLoginUser(string _username, Guid guid)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into history_login_user (`id_login`, `username`,`datetime_login`,`pc_name`,`ip_address`) ");
sb.Append("values('" + guid + "','" + _username + "',NOW(),'" + System.Environment.MachineName + "','"
+ Dns.GetHostAddresses(Dns.GetHostName())[1].ToString() + "')");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void InsertReferensiSuratKeluar(string _surat_keluar, string _surat_masuk)
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into referensi_surat_keluar (`nomor_surat`,`referensi_surat_masuk`) ");
sb.Append(" values ");
sb.Append(" ('" + _surat_keluar + "', '" + _surat_masuk + "')");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void UpdateLastLogout(string _username)
{
StringBuilder sb = new StringBuilder();
sb.Append("update user ");
sb.Append("set datetime_logout_terakhir = NOW() ");
sb.Append("where username='******'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void InsertHistoryPenyelesaian(string _nomor_agenda, DateTime _tglPenyelesaian, string _penyelesaian_oleh, string _penyelesaian, string _user)
{
StringBuilder sb = new StringBuilder();
sb.Append(" insert into penyelesaian (`nomor_agenda`,`datetime_input`,`tanggal_penyelesaian`, `penyelesaian_oleh`,`penyelesaian`,`user`) ");
sb.Append(" values ");
sb.Append(" ('" + _nomor_agenda + "', Now(),'" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", _tglPenyelesaian) + "','" + _penyelesaian_oleh + "','"
+ _penyelesaian + "','" + _user + "') ");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void SimpanKategoriFormat(string _nama_variable, string _value)
{
OdbcCommand cmd = new OdbcCommand();
StringBuilder sb = new StringBuilder();
sb.Append("update sett_default_application ");
sb.Append("set `value`='" + _value + "' where `name`='" + _nama_variable + "'");
cmd.Connection = T8Application.DBConnection;
cmd.CommandText = sb.ToString();
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void DeleteUser(string _username)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from history_login_user where username='******'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append("delete from user where username='******'");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void ReferensiSuratMasuk(string _act, string _nomor_agenda, string _referensi_surat_keluar)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from referensi_surat where `nomor_agenda`='" + _nomor_agenda + "'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append("insert into referensi_surat (`nomor_agenda`,`referensi_surat_keluar`) ");
sb.Append(" values ");
sb.Append(" ('" + _nomor_agenda + "', '" + _referensi_surat_keluar + "')");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void DeleteHistoryLoginUser(string _username, string _filter)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from history_login_user ");
if (!string.IsNullOrEmpty(_filter))
{
sb.Append(_filter + " and username='******'");
}
else
{
sb.Append("where username='******'");
}
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void InsertLokasiFisikSurat(string _nomor_agenda, string _lokasi_fisik, string _keterangan, string _user)
{
StringBuilder sb = new StringBuilder();
sb.Append("delete from lokasi_fisik_surat where `nomor_agenda`='" + _nomor_agenda + "'");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append("insert into lokasi_fisik_surat (`nomor_agenda`,`datetime_input`,`date`,`posisi`,`keterangan`,`user`) ");
sb.Append(" values ");
sb.Append(" ('" + _nomor_agenda + "', now(), '" + string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now) + "','" + _lokasi_fisik + "','" + _keterangan
+ "','" + _user + "')");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void HapusSuratMasuk(string _nomor_agenda)
{
StringBuilder sb = new StringBuilder();
sb.Append(" delete from surat_masuk where `nomor_agenda`='" + _nomor_agenda + "'; ");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append(" delete from pengiriman where `nomor_agenda`='" + _nomor_agenda + "'; ");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append(" delete from history_edit_surat where `nomor_agenda`='" + _nomor_agenda + "'; ");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append(" delete from penyelesaian where `nomor_agenda`='" + _nomor_agenda + "'; ");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append(" delete from referensi_surat where `nomor_agenda`='" + _nomor_agenda + "'; ");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append(" delete from lokasi_fisik_surat where `nomor_agenda`='" + _nomor_agenda + "'; ");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append(" delete from disposisi where `nomor_agenda`='" + _nomor_agenda + "'; ");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
public static void HapusSuratKeluar(string _nomor_surat)
{
StringBuilder sb = new StringBuilder();
sb.Append(" delete from surat_keluar where `nomor_surat`='" + _nomor_surat + "'; ");
OdbcCommand cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append(" delete from history_edit_surat_keluar where `nomor_surat`='" + _nomor_surat + "'; ");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append(" delete from pengiriman where `nomor_agenda`='" + _nomor_surat + "'; ");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
sb = new StringBuilder();
sb.Append(" delete from referensi_surat_keluar where `nomor_surat`='" + _nomor_surat + "'; ");
cmd = new OdbcCommand(sb.ToString(), T8Application.DBConnection);
GlobalDBExecute.ExecuteQuery(cmd);
}
