public static DataTable GetJadwal() { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommandElang(); cmd.Query = @"SELECT tanggal, obyek_pajak, alamat, nama_vendor, jam, kegiatan, status, petugas from JADWAL_ONLINE where status1 not in '0'"; return(cmd.GetTable()); }
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 DataTable RetrieveNopBaru(string Nop) { OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommandElang(); //OracleCmdBuilder cmd = DataBaseHelper.CreateOracleCommandBonang(); cmd.Query = @"select NOP, NAMAOP, ALAMAT, NPWPD, KODEREKENING, JENISUSAHA from vw_nop_baru where NOP=:nop"; cmd.AddParameter("nop", OracleCmdParameterDirection.Input, Nop); return(cmd.GetTable()); }
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); }