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