[HttpPost("AddStok")] //Tambah stok barang
public IActionResult Post([FromBody] DetilBarang item)
{
if (repo.AddStok(item) > 0)
{
return(Ok(okPost));
}
return(NotFound(post));
}
//-------------------//
//--- CRUD DETIL BARANG ---//
public int AddStok(DetilBarang item)
{
var temp = cnn.QueryFirstOrDefault <DetilBarang>("SELECT * FROM `detil barang` WHERE ID_Barang = " + item.ID_Barang + " AND NoSeri = '" + item.NoSeri + "'; ");
if (temp == null)
{
string sql = "INSERT INTO `detil barang` (ID_Barang, NoSeri) Values (@ID_Barang, @NoSeri);";
var affectedRows = cnn.Execute(sql, new { ID_Barang = item.ID_Barang, NoSeri = item.NoSeri });
sql = "UPDATE barang SET Stok = Stok + " + 1 + " WHERE ID = " + item.ID_Barang + ";";
affectedRows = cnn.Execute(sql);
return(affectedRows);
}
return(0);
}