//public static System.Data.DataTable RetrieveUserInformationTransactionByMonth(string username, string nop, int monthTransaction, int year)
//{
// OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
// cmd.Query = @"SELECT username, tanggal, pajak_terutang, keterangan, is_adjusment, createdate, ip_sender,nop, file_adjustment
// FROM user_transaction WHERE IS_ADJUSMENT = 0 AND to_char(tanggal,'MM')=:monTrans AND TO_CHAR(tanggal,'YYYY')=:year";
// cmd.AddParameter("monTrans", OracleCmdParameterDirection.Input, monthTransaction.ToString("00"));
// cmd.AddParameter("year", OracleCmdParameterDirection.Input, year);
// if (!string.IsNullOrEmpty(username))
// {
// cmd.Query += @" AND username=:usern ";
// cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username);
// }
// if (!string.IsNullOrEmpty(nop))
// {
// cmd.Query += @" AND nop=:nop ";
// cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop);
// }
// cmd.Query += @" ORDER BY createdate DESC ";
// return cmd.GetTable();
//}
public static System.Data.DataTable RetrieveUserTransactionByMonth(string username, string nop, int monthTransaction, int year)
{
OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommand();
cmd.Query = @"SELECT username, tanggal, pajak_terutang, keterangan, is_adjusment, createdate, ip_sender,nop, file_adjustment
FROM user_transaction WHERE to_char(tanggal,'MM')=:monTrans AND TO_CHAR(tanggal,'YYYY')=:year";
cmd.AddParameter("monTrans", OracleCmdParameterDirection.Input, monthTransaction.ToString("00"));
cmd.AddParameter("year", OracleCmdParameterDirection.Input, year);
if (!string.IsNullOrEmpty(username))
{
cmd.Query += @" username=:usern ";
cmd.AddParameter("usern", OracleCmdParameterDirection.Input, username);
}
if (!string.IsNullOrEmpty(nop))
{
cmd.Query += @" AND nop=:nop ";
cmd.AddParameter("nop", OracleCmdParameterDirection.Input, nop);
}
return(cmd.GetTable());
}
