private MKontak getDataKontak(long iduser, List <DataFilters> filters)
{
MKontak obj = new MKontak();
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 mkontak.*" +
" from mkontak inner join mkontakd on mkontakd.idkontak=mkontak.id where mkontakd.iduser=@iduser";
com.Parameters.AddWithValue("@iduser", iduser);
RepSqlDatabase.OperatorSQL(com, filters);
oDA.Fill(dt);
obj = (from DataRow x in dt.Rows
select new MKontak()
{
id = RepUtils.NullToLong(x["id"]),
kode = RepUtils.NullToStr(x["kode"]),
nama = RepUtils.NullToStr(x["nama"]),
alamat1 = RepUtils.NullToStr(x["alamat1"]),
alamat2 = RepUtils.NullToStr(x["alamat2"]),
alamat3 = RepUtils.NullToStr(x["alamat3"]),
hp = RepUtils.NullToStr(x["hp"]),
telpon = RepUtils.NullToStr(x["telpon"]),
iswhatsapp = RepUtils.NullToBool(x["iswhatsapp"]),
norekening = RepUtils.NullToStr(x["norekening"]),
atasnamarekening = RepUtils.NullToStr(x["atasnamarekening"]),
bank = RepUtils.NullToStr(x["bank"])
}).SingleOrDefault();
}
}
}
}
return(obj);
}
JsonResult IKontak.GetByKode(long iduser, 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
});
MKontak obj = getDataKontak(iduser, 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(long iduser, [FromBody] MKontak Kontak)
{
try
{
if (Kontak == null || Kontak.id <= 0)
{
return(BadRequest("Error while creating"));
}
else
{
Repository.RepSqlDatabase.LogConnection(_hostEnvironment, "Kontak.Delete", Newtonsoft.Json.JsonConvert.SerializeObject(Kontak));
_interface = HttpContext.RequestServices.GetService(typeof(KontakContext)) as KontakContext;
return(_interface.Delete(Kontak));
}
}
catch (Exception ex)
{
Repository.RepSqlDatabase.LogErrorQuery(_hostEnvironment, "Kontak.Delete", ex);
return(BadRequest("Error while creating"));
}
}
