JsonResult IBase <MJenisTransaksi> .Update(MJenisTransaksi obj) { throw new NotImplementedException(); }
JsonResult IJenisTransaksi.Get(long id) { JsonResult hasil = new JsonResult { JSONResult = false, JSONMessage = "Data tidak ditemukan", JSONRows = 0, JSONValue = null }; MJenisTransaksi Obj = new MJenisTransaksi(); using (NpgsqlConnection conn = GetConnection()) { using (NpgsqlCommand com = new NpgsqlCommand()) { using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter()) { using (DataTable dt = new DataTable()) { try { conn.Open(); com.Connection = conn; com.CommandTimeout = conn.ConnectionTimeout; oDA.SelectCommand = com; com.CommandText = "select mjenistransaksi.*" + " from mjenistransaksi where id=@id"; com.Parameters.Clear(); com.Parameters.AddWithValue("@id", id); oDA.Fill(dt); Obj = (from DataRow x in dt.Rows select new MJenisTransaksi() { id = RepUtils.NullToLong(x["id"]), kode = RepUtils.NullToStr(x["kode"]), nama = RepUtils.NullToStr(x["nama"]), nourut = RepUtils.NullToInt(x["nourut"]), keterangan = RepUtils.NullToStr(x["keterangan"]), jenistransaksid = getDetil(com, oDA, RepUtils.NullToLong(x["id"])) }).SingleOrDefault(); hasil = new JsonResult { JSONMessage = "Data ditemukan", JSONResult = true, JSONRows = (Obj == null ? 0 : 1), JSONValue = Obj }; } catch (Exception ex) { hasil = new JsonResult { JSONMessage = ex.StackTrace, JSONResult = false, JSONRows = 0, JSONValue = null }; } } } } } return(hasil); }