public static bool InsertTestimoni(string username, string commend) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = ""; return(cmd.ExecuteNonQuery() > 0); }
public static bool UpdateWebUsername(string existUsername, string webUsername) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"UPDATE user_client SET web_username =:webUsern WHERE username =:exstUsern"; cmd.AddParameter("webUsern", OracleCmdParameterDirection.Input, webUsername); cmd.AddParameter("exstUsern", OracleCmdParameterDirection.Input, existUsername); return(cmd.ExecuteNonQuery() > 0); }
public static bool DeleteJadwal(string id) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommandElang(); cmd.Query = @"DELETE FROM JADWAL_ONLINE WHERE IDOP=@id"; cmd.AddParameter("id", OracleCmdParameterDirection.Input, id); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertUserTempError(string username, DateTime activityDate) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO user_temp_error(username, tanggal_error) VALUES(:usern, :actdate)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("actdate", OracleCmdParameterDirection.Input, activityDate); return(cmd.ExecuteNonQuery() > 0); }
public static bool DeleteUserDetailTransaction(string nop, DateTime tglTransaksi) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"DELETE FROM user_transaction_detail WHERE nop=:nop AND transaction_date=:tgl"; cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop); cmd.AddParameter("tgl", OracleCmdParameterDirection.Input, tglTransaksi); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertUserNop(string username, string nop, string jenisPajak) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO USER_NOP (USERNAME, NOP, JENIS_PAJAK) VALUES(:usern, :nop, :jnsPajak)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop); cmd.AddParameter("jnsPajak", OracleCmdParameterDirection.Input, jenisPajak); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertUserSettingColumn(string username, string nop, string colName, string colText) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO USER_SETTING_COLUMN (USERNAME, NOP, COLUMN_NAME, COLUMN_TEXT) VALUES(:usern, :nop, :colname, :coltext)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop); cmd.AddParameter("colname", OracleCmdParameterDirection.Input, colName); cmd.AddParameter("coltext", OracleCmdParameterDirection.Input, colText); return(cmd.ExecuteNonQuery() > 0); }
public static bool UpdateSerialKey(string username, string serialKey) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"UPDATE user_client SET serial_key=:ser WHERE username=:usern"; cmd.AddParameter("ser", OracleCmdParameterDirection.Input, serialKey); cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); return(cmd.ExecuteNonQuery() > 0); }
public static bool UpdateIsGenerate(string nop, DateTime tanggal) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"UPDATE USER_TRANSACTION SET IS_GENERATE=1 WHERE NOP=:nop AND trunc(tanggal) = :tgl"; cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop); cmd.AddParameter("tgl", OracleCmdParameterDirection.Input, tanggal.Date); return(cmd.ExecuteNonQuery() > 0); }
public bool InsertUser(string username, string idRole, string password, string userapp) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO M_USER (USERNAME, ID_ROLE, PASSWORD, USER_APP) VALUES(:usern, :idrole, :passw, :userapp)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("idrole", OracleCmdParameterDirection.Input, idRole); cmd.AddParameter("passw", OracleCmdParameterDirection.Input, password); cmd.AddParameter("userapp", OracleCmdParameterDirection.Input, userapp); return(cmd.ExecuteNonQuery() > 0); }
public bool ChangePassword(string username, string oldPassword, string newPassword) { string encNewPassword = POAdministrationTools.StringCipher.Encrypt(newPassword, HttpContext.Current.Session["Serial_key"].ToString()); OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"UPDATE M_USER SET password =:password WHERE Username =:uName AND Password =:oldPass"; cmd.AddParameter("password", OracleCmdParameterDirection.Input, encNewPassword); cmd.AddParameter("uName", OracleCmdParameterDirection.Input, username); cmd.AddParameter("oldPass", OracleCmdParameterDirection.Input, oldPassword); return(cmd.ExecuteNonQuery() > 0); }
public static bool UpdateUserClient(string email, string phone, string kdBank, string username) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"UPDATE user_client SET email =:email, phone =:phone, kode_bank =:kdbank WHERE username =:username"; cmd.AddParameter("email", OracleCmdParameterDirection.Input, email); cmd.AddParameter("phone", OracleCmdParameterDirection.Input, phone); cmd.AddParameter("kdbank", OracleCmdParameterDirection.Input, kdBank); cmd.AddParameter("username", OracleCmdParameterDirection.Input, username); return(cmd.ExecuteNonQuery() > 0); }
public static bool UpdatePajakUserTransaction(string username, string nop, DateTime tanggal, double pajak) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"UPDATE USER_TRANSACTION SET PAJAK_TERUTANG=:nominal WHERE USERNAME=:usern AND NOP=:nop AND trunc(TANGGAL)=:tgl AND is_adjusment=0"; cmd.AddParameter("nominal", OracleCmdParameterDirection.Input, pajak); cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop); cmd.AddParameter("tgl", OracleCmdParameterDirection.Input, tanggal.ToString("dd MMM yyyy")); return(cmd.ExecuteNonQuery() > 0); }
public static bool RegisterSerialKey(string user, string key, string serialKey) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"UPDATE USER_CLIENT SET serial_key=:serialKey WHERE username=:usern AND id_machine=:idMachine"; cmd.AddParameter("serialKey", OracleCmdParameterDirection.Input, serialKey); cmd.AddParameter("usern", OracleCmdParameterDirection.Input, user); cmd.AddParameter("idMachine", OracleCmdParameterDirection.Input, key); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertUserActivity(string username, string ipAddress, DateTime activityDate, bool status, string keterangan) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO user_activity(username, ip_address,activity_date, status_error, keterangan) VALUES(:usern, :ipaddress,:actdate, :status, :ket)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("ipaddress", OracleCmdParameterDirection.Input, ipAddress); cmd.AddParameter("actdate", OracleCmdParameterDirection.Input, activityDate); cmd.AddParameter("status", OracleCmdParameterDirection.Input, status); cmd.AddParameter("ket", OracleCmdParameterDirection.Input, keterangan); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertDetailSptpd(string idsptpd, string nop, string username, int masapajak, int tahun, double pajak) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO SPTPD_DETAIL (ID_SPTPD, NOP, USERNAME, MASAPAJAK, TAHUN, NOMINAL) VALUES (:idsptpd, :nop, :usern, :masapajak, :tahun, :pajak)"; cmd.AddParameter("idsptpd", OracleCmdParameterDirection.Input, idsptpd); cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop); cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("masapajak", OracleCmdParameterDirection.Input, masapajak); cmd.AddParameter("tahun", OracleCmdParameterDirection.Input, tahun); cmd.AddParameter("pajak", OracleCmdParameterDirection.Input, pajak); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertUserSourceDatabase(string username, string nop, string xmlSettDB, string ip, string namaDb) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO USER_SOURCE_DB (username,nop,setting_db,ip_sender,nama_db) VALUES(:usern,:nop,:settDB,:ipAdd,:nmDB)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop); cmd.AddParameter("settDB", OracleCmdParameterDirection.Input, xmlSettDB); cmd.AddParameter("ipAdd", OracleCmdParameterDirection.Input, ip); cmd.AddParameter("nmDB", OracleCmdParameterDirection.Input, namaDb); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertUserClient(string username, string idMachine, string password, string phone, string mail, int port) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO USER_CLIENT (username, id_machine, password,phone,email,port_client) VALUES(:usern, :idmachine, :password,:phone,:mail,:port)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("idmachine", OracleCmdParameterDirection.Input, idMachine); cmd.AddParameter("password", OracleCmdParameterDirection.Input, password); cmd.AddParameter("phone", OracleCmdParameterDirection.Input, phone); cmd.AddParameter("mail", OracleCmdParameterDirection.Input, mail); cmd.AddParameter("port", OracleCmdParameterDirection.Input, port); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertXmlFile(string username, string filename, string xmlContent, string fileNote, string separator) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO user_xml_file(username,filename,file_xml,file_note,separate) VALUES(:usern,:filename,:xmlFile,:fileNote,:separate)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("filename", OracleCmdParameterDirection.Input, filename); cmd.AddParameter("xmlFile", OracleCmdParameterDirection.Input, xmlContent); cmd.AddParameter("fileNote", OracleCmdParameterDirection.Input, fileNote); cmd.AddParameter("separate", OracleCmdParameterDirection.Input, separator); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertUserTransactionDetail(string username, string xmlPath, DateTime sendDate, string ipAddress, string xmlfile, int bulan, int tahun) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO USER_TRANSACTION_DETAIL (username, xml_path, transaction_date, ip_address, xml_file, bulan, tahun) VALUES(:usern, :xmlpath, :senddate, :ipaddress, :xmlfile, :bln, :thn)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("xmlpath", OracleCmdParameterDirection.Input, xmlPath); cmd.AddParameter("senddate", OracleCmdParameterDirection.Input, sendDate); cmd.AddParameter("ipaddress", OracleCmdParameterDirection.Input, ipAddress); cmd.AddParameter("xmlfile", OracleCmdParameterDirection.Input, xmlfile); cmd.AddParameter("bln", OracleCmdParameterDirection.Input, bulan); cmd.AddParameter("thn", OracleCmdParameterDirection.Input, tahun); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertSptpd(string idsptpd, string username, int masapajak, int tahun, double pajak, double sanksi, double total, string idbayar) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO SPTPD (ID_SPTPD, USERNAME, MASAPAJAK, TAHUN, PAJAK, SANKSI, TOTAL, ID_BAYAR) VALUES (:idsptpd, :usern, :masapajak, :tahun, :pajak, :sanksi, :total, :idbayar)"; cmd.AddParameter("idsptpd", OracleCmdParameterDirection.Input, idsptpd); cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("masapajak", OracleCmdParameterDirection.Input, masapajak); cmd.AddParameter("tahun", OracleCmdParameterDirection.Input, tahun); cmd.AddParameter("pajak", OracleCmdParameterDirection.Input, pajak); cmd.AddParameter("sanksi", OracleCmdParameterDirection.Input, sanksi); cmd.AddParameter("total", OracleCmdParameterDirection.Input, total); cmd.AddParameter("idbayar", OracleCmdParameterDirection.Input, idbayar); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertHistoryRegister(string username, string encryptKode) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO USER_HISTORY_REGISTER (KODE, USERNAME,STATUS) VALUES(:kode,:usern,( select (nvl(max(status),0) + 1) status from user_history_register where username=:usern) )"; cmd.AddParameter("kode", OracleCmdParameterDirection.Input, encryptKode); cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); return(cmd.ExecuteNonQuery() > 0); }
public static bool UpdateData(string kode, string username, string hwID) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = "UPDATE serial_note " + "SET taken_username=:usern," + " taken_hw_id=:hwID," + " modidate=sysdate," + " status=:status" + " WHERE kode=:kode"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, StringCipher.Encrypt(username, DataBaseHelper.SettingDB)); cmd.AddParameter("hwID", OracleCmdParameterDirection.Input, StringCipher.Encrypt(hwID, DataBaseHelper.SettingDB)); cmd.AddParameter("status", OracleCmdParameterDirection.Input, StringCipher.Encrypt("USED", DataBaseHelper.SettingDB)); cmd.AddParameter("kode", OracleCmdParameterDirection.Input, kode); return(cmd.ExecuteNonQuery() > 0); }
public static bool InserUserSettingDatabase(string username, string nop, string jenPajak, string tarif, string queryPajak, string queryDetail, string Alias) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO USER_SETTING_DATABASE (username,nop,jenispajak,tarif,query_pajak,query_detail,alias) VALUES(:usern,:nop,:jen,:tarif,:qPajak,:qDetail,:alias)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop); cmd.AddParameter("jen", OracleCmdParameterDirection.Input, jenPajak); cmd.AddParameter("tarif", OracleCmdParameterDirection.Input, tarif); cmd.AddParameter("qPajak", OracleCmdParameterDirection.Input, queryPajak); cmd.AddParameter("qDetail", OracleCmdParameterDirection.Input, queryDetail); cmd.AddParameter("alias", OracleCmdParameterDirection.Input, Alias); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertUserTransaction(string username, DateTime tglTransaction, double pajakTerutang, string keterangan, bool isAdjustment, string ipSender, string nop) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand(); cmd.Query = @"INSERT INTO user_transaction (username, tanggal, pajak_terutang, keterangan, is_adjusment, createdate, ip_sender, nop) VALUES(:usern, :tgl, :pajak, :keterangan, :isAdj, :createDate, :ipSender,:nop)"; cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username); cmd.AddParameter("tgl", OracleCmdParameterDirection.Input, tglTransaction); cmd.AddParameter("pajak", OracleCmdParameterDirection.Input, pajakTerutang); cmd.AddParameter("keterangan", OracleCmdParameterDirection.Input, keterangan); cmd.AddParameter("isAdj", OracleCmdParameterDirection.Input, isAdjustment); cmd.AddParameter("createDate", OracleCmdParameterDirection.Input, DateTime.Now); cmd.AddParameter("ipSender", OracleCmdParameterDirection.Input, ipSender); cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop); return(cmd.ExecuteNonQuery() > 0); }
public static bool UpdateJadwal(string idop, DateTime tanggal, string obyekpajak, string alamat, string vendor, string jam, string kegiatan, DateTime modidate, string status, string petugas) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommandElang(); cmd.Query = @"UPDATE JADWAL_ONLINE SET IDOP=:id, tanggal=:tgl, obyek_pajak=:op, alamat=:almt, nama_vendor=:ven, jam=:jm, kegiatan=:keg, modidate=:moddate, status=:stat, petugas=:ptg"; cmd.AddParameter("id", OracleCmdParameterDirection.Input, Guid.NewGuid().ToString()); cmd.AddParameter("tgl", OracleCmdParameterDirection.Input, tanggal); cmd.AddParameter("op", OracleCmdParameterDirection.Input, obyekpajak); cmd.AddParameter("almt", OracleCmdParameterDirection.Input, alamat); cmd.AddParameter("ven", OracleCmdParameterDirection.Input, vendor); cmd.AddParameter("jm", OracleCmdParameterDirection.Input, jam); cmd.AddParameter("keg", OracleCmdParameterDirection.Input, kegiatan); cmd.AddParameter("moddate", OracleCmdParameterDirection.Input, modidate); cmd.AddParameter("stat", OracleCmdParameterDirection.Input, status); cmd.AddParameter("ptg", OracleCmdParameterDirection.Input, petugas); return(cmd.ExecuteNonQuery() > 0); }
public static bool InsertJadwal(string idop, DateTime tanggal, string obyekpajak, string alamat, string vendor, string jam, string kegiatan, DateTime modidate, string status, string petugas) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommandElang(); cmd.Query = @"INSERT INTO JADWAL_ONLINE (IDOP, TANGGAL, OBYEK_PAJAK, ALAMAT, NAMA_VENDOR, JAM, KEGIATAN, MODIDATE, STATUS, PETUGAS) VALUES (:id, :tgl, :op, :almt, :ven, :jm, :keg, :moddate, :stat, :ptg)"; //cmd.AddParameter("id", OracleCmdParameterDirection.Input, idop); cmd.AddParameter("id", OracleCmdParameterDirection.Input, Guid.NewGuid().ToString()); cmd.AddParameter("tgl", OracleCmdParameterDirection.Input, tanggal); cmd.AddParameter("op", OracleCmdParameterDirection.Input, obyekpajak); cmd.AddParameter("almt", OracleCmdParameterDirection.Input, alamat); cmd.AddParameter("ven", OracleCmdParameterDirection.Input, vendor); cmd.AddParameter("jm", OracleCmdParameterDirection.Input, jam); cmd.AddParameter("keg", OracleCmdParameterDirection.Input, kegiatan); cmd.AddParameter("moddate", OracleCmdParameterDirection.Input, modidate); cmd.AddParameter("stat", OracleCmdParameterDirection.Input, status); cmd.AddParameter("ptg", OracleCmdParameterDirection.Input, petugas); return(cmd.ExecuteNonQuery() > 0); }