public static DataTable RetrieveUserDetailTransactionByDateTransaction(string nop, DateTime tglTransaksi)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT username, xml_path, transaction_date, ip_address, xml_file, bulan, tahun, nop, create_date
FROM user_transaction_detail
WHERE nop=:nop AND (transaction_date BETWEEN to_date(:tglAwal,'MM/DD/YYYY') AND to_date(:tglAkhir,'MM/DD/YYYY HH24:MI:SS'))
order by create_date desc";
cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop);
string tglAwal = tglTransaksi.ToString("MM/dd/yyyy", new System.Globalization.CultureInfo("en-US"));
string tglAkhir = tglTransaksi.ToString("MM/dd/yyyy", new System.Globalization.CultureInfo("en-US")) + " 23:59:59";
cmd.AddParameter("tglAwal", OracleCmdParameterDirection.Input, tglAwal);
cmd.AddParameter("tglAkhir", OracleCmdParameterDirection.Input, tglAkhir);
return(cmd.GetTableFirstRowOnly());
}
