public DetailBarang getByIdDetail(int id)
{
string query = "SELECT * FROM detail_barang WHERE ID_DETAIL_BARANG = '" + id + "';";
OpenConnection();
DetailBarang hasil = myConn.QuerySingle <DetailBarang>(query);
closeConnection();
return(hasil);
}
public IActionResult PutDetailBarang(string id, [FromBody] DetailBarang value)
{
RepositoryDetailBarang RP = new RepositoryDetailBarang();
try
{
RP.updateData(id, value);
return(Ok());
}
catch (Exception)
{
return(BadRequest());
}
}
public IActionResult PostDetailBarang([FromBody] DetailBarang value)
{
RepositoryDetailBarang RP = new RepositoryDetailBarang();
try
{
RP.insertData(value);
return(Created("", value));
}
catch (Exception e)
{
return(BadRequest(e));
}
}
public void updateData(string Id, DetailBarang dtl)
{
int _id_detail_barang = dtl.Id_detail_barang;
string _id_barang = dtl.Id_barang;
string _nomor_seri_detail = dtl.Nomor_seri_detail;
string _status_detail = dtl.Status_detail;
string _keterangan_detail = dtl.Keterangan_detail;
string query = "UPDATE detail_barang SET ID_BARANG = '" + _id_barang + "', NOMOR_SERI_DETAIL = '" + _nomor_seri_detail + "', STATUS_DETAIL = '" + _status_detail + "', KETERANGAN_DETAIL = '" + _keterangan_detail + "' WHERE ID_DETAIL_BARANG = " + _id_detail_barang + ";";
OpenConnection();
var hasil = myConn.Execute(query);
closeConnection();
}
public void insertData(DetailBarang dtl)
{
int _id_detail_barang = dtl.Id_detail_barang;
string _id_barang = dtl.Id_barang;
string _nomor_seri_detail = dtl.Nomor_seri_detail;
string _status_detail = dtl.Status_detail;
string _keterangan_detail = dtl.Keterangan_detail;
string query = "INSERT INTO detail_barang VALUES (null, '" + _id_barang + "', '" + _nomor_seri_detail + "', '" + _status_detail + "', '" + _keterangan_detail + "');";
OpenConnection();
var hasil = myConn.Execute(query);
closeConnection();
}