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); }