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