public string deleteBarang(string id) { Koneksi kon = new Koneksi(); SqlConnection sqlcon = kon.getConnection(); string msg = string.Empty; using (sqlcon){ sqlcon.Open(); string sql = "delete from barang where idbarang = @id"; SqlCommand sqlcom = new SqlCommand(sql, sqlcon); using (sqlcom){ sqlcom.Parameters.AddWithValue("@id", id); int res = sqlcom.ExecuteNonQuery(); msg = (res != 0? "Data has been deleted." : "Error !"); } sqlcon.Close(); } return(msg); }
public string insertBarang(BarangInfo data) { Koneksi con = new Koneksi(); SqlConnection sqlcon = con.getConnection(); string msg = string.Empty; using (sqlcon) { sqlcon.Open(); string sql = "insert into barang values (@id, @nama, @stok, @harga)"; SqlCommand sqlcom = new SqlCommand(sql, sqlcon); using (sqlcom) { sqlcom.Parameters.AddWithValue("@id", data.IDBarang); sqlcom.Parameters.AddWithValue("@nama", data.NamaBarang); sqlcom.Parameters.AddWithValue("@stok", data.StokBarang); sqlcom.Parameters.AddWithValue("@harga", data.HargaBarang); int res = sqlcom.ExecuteNonQuery(); msg = (res != 0 ? "Data has been saved." : "Error !"); } sqlcon.Close(); } return(msg); }