public static string RetrieveIdMachineByUsername(string username)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT id_machine FROM USER_CLIENT
WHERE USERNAME=:usern";
cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username);
string id = cmd.ExecuteScalar() == null ? string.Empty : cmd.ExecuteScalar().ToString();
return(id);
}
public static string RetrieveApiUrl()
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT URL_API from USER_API_URL";
return(cmd.ExecuteScalar().ToString());
}
public static string GetUrlApi()
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT url_api FROM user_api_url";
return(cmd.ExecuteScalar().ToString());
}
public static string GetNamaOPSptpd(string kdValidasi)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommandBonang();
cmd.Query = @"SELECT namaop FROM sptpd_baru WHERE id_sptpd=:ids";
cmd.AddParameter("ids", OracleCmdParameterDirection.Input, kdValidasi);
return(cmd.ExecuteScalar().ToString());
}
public static bool GetSerialKey(string serialKey)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT COUNT(*)
FROM USER_CLIENT WHERE SERIAL_KEY=:serial";
cmd.AddParameter("serial", OracleCmdParameterDirection.Input, serialKey);
return(System.Convert.ToInt32(cmd.ExecuteScalar()) > 0);
}
public static bool isUserNopExist(string username, string nop)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT count(*) FROM USER_NOP WHERE username=:usern AND nop=:nop AND IS_DELETED = 0";
cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username);
cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop);
return(Convert.ToInt32(cmd.ExecuteScalar()) > 0);
}
public static bool IsUserUsingDatabase(string username)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT COUNT(*)
FROM user_xml_file
WHERE username=:usern AND file_note='DATABASE'";
cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username);
return(Convert.ToInt32(cmd.ExecuteScalar()) > 0);
}
public static string GetSerialKey(string username)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT KODE
FROM USER_HISTORY_REGISTER
WHERE ROWNUM <= 1 AND USERNAME=:usern
ORDER BY STATUS DESC";
cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username);
return(cmd.ExecuteScalar().ToString());
}
public static bool IsCodeExist2(string kode, string username, string cpuId)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT COUNT(*)
FROM USER_CLIENT
WHERE SERIAL_KEY=:kodeSerial AND USERNAME=:usern AND ID_MACHINE=:cpuid";
cmd.AddParameter("kodeSerial", OracleCmdParameterDirection.Input, kode);
cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username);
cmd.AddParameter("cpuid", OracleCmdParameterDirection.Input, cpuId);
return(Convert.ToInt32(cmd.ExecuteScalar()) > 0);
}
public static bool isSptpdDetailByNop(string nop, int masapajak, int tahun)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT count(*) FROM SPTPD_DETAIL WHERE NOP=:nop AND MASAPAJAK=:mp AND TAHUN=:thn";
cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop);
cmd.AddParameter("mp", OracleCmdParameterDirection.Input, masapajak);
cmd.AddParameter("thn", OracleCmdParameterDirection.Input, tahun);
int jml = 0;
try
{
jml = Convert.ToInt32(cmd.ExecuteScalar());
}
catch (Exception)
{
}
return(jml > 0);
}
