private MAkun getDataAkun(List <DataFilters> filters)
{
MAkun obj = new MAkun();
using (NpgsqlConnection conn = GetConnection())
{
using (NpgsqlCommand com = new NpgsqlCommand())
{
using (NpgsqlDataAdapter oDA = new NpgsqlDataAdapter())
{
using (DataTable dt = new DataTable())
{
conn.Open();
com.Connection = conn;
com.CommandTimeout = conn.ConnectionTimeout;
oDA.SelectCommand = com;
com.CommandText = "select makun.*" +
" from makun where 1=1";
RepSqlDatabase.OperatorSQL(com, filters);
oDA.Fill(dt);
obj = (from DataRow x in dt.Rows
select new MAkun()
{
id = RepUtils.NullToLong(x["id"]),
kode = RepUtils.NullToStr(x["kode"]),
nama = RepUtils.NullToStr(x["nama"]),
idparent = RepUtils.NullToLong(x["idparent"]),
iddepartemen = RepUtils.NullToInt(x["iddepartemen"]),
keterangan = RepUtils.NullToStr(x["keterangan"]),
idtype = RepUtils.NullToInt(x["idtype"]),
isdebet = RepUtils.NullToBool(x["isdebet"]),
iskasbank = RepUtils.NullToBool(x["iskasbank"]),
norekening = RepUtils.NullToStr(x["norekening"]),
atasnamarekening = RepUtils.NullToStr(x["atasnamarekening"]),
idtypebank = RepUtils.NullToInt(x["idtypebank"]),
isneraca = RepUtils.NullToBool(x["isneraca"])
}).SingleOrDefault();
}
}
}
}
return(obj);
}
JsonResult IAkun.GetByKode(string kode)
{
JsonResult hasil = new JsonResult
{
JSONResult = false,
JSONMessage = "Data tidak ditemukan",
JSONRows = 0,
JSONValue = null
};
List <DataFilters> filters = new List <DataFilters>();
filters.Add(new DataFilters
{
FieldName = "upper(kode)",
FieldValue = kode.ToUpper(),
Operator = DataFilters.OperatorQuery.SamaDengan,
Separator = DataFilters.SeparatorQuery.And
});
MAkun obj = getDataAkun(filters);
if (obj == null)
{
hasil = new JsonResult
{
JSONMessage = "Data tidak ditemukan",
JSONResult = false,
JSONRows = 0,
JSONValue = null
};
}
else
{
hasil = new JsonResult
{
JSONMessage = "Data ditemukan",
JSONResult = true,
JSONRows = 1,
JSONValue = obj
};
}
return(hasil);
}
public ActionResult <Models.JsonResult> Delete([FromBody] MAkun akun)
{
try
{
if (akun == null || akun.id <= 0)
{
return(BadRequest("Error while creating"));
}
else
{
Repository.RepSqlDatabase.LogConnection(_hostEnvironment, "Akun.Delete", Newtonsoft.Json.JsonConvert.SerializeObject(akun));
_interface = HttpContext.RequestServices.GetService(typeof(AkunContext)) as AkunContext;
return(_interface.Delete(akun));
}
}
catch (Exception ex)
{
Repository.RepSqlDatabase.LogErrorQuery(_hostEnvironment, "Akun.Delete", ex);
return(BadRequest("Error while creating"));
}
}
