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);
}
