public List <dataBarang> GetBarangNama(string nama) { List <dataBarang> list = new List <dataBarang>(); SqlConnection con = new SqlConnection("Data Source=FESAART-DEKSTOP;Initial Catalog=WCF_Projek-Akhir;Persist Security Info=True;User ID=sa;Password=123456"); SqlCommand cmd = new SqlCommand("select * from Barang where Nama_Barang LIKE '%" + nama + "%'", con); try { con.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { dataBarang barang = new dataBarang(); barang.ID_Barang = reader.GetInt32(0); barang.Nama_Barang = reader.GetString(1); barang.Jenis_Barang = reader.GetString(2); barang.Merek = reader.GetString(3); barang.Harga = reader.GetInt32(4); barang.Stok = reader.GetInt32(5); list.Add(barang); } con.Close(); } } catch (Exception ex) { Console.WriteLine(ex.ToString()); } return(list); }
public List <dataBarang> GetSemuaBarangManual() { List <dataBarang> list = new List <dataBarang>(); SqlConnection con = new SqlConnection("Data Source=FESAART-DEKSTOP;Initial Catalog=WCF_Projek-Akhir;Persist Security Info=True;User ID=sa;Password=123456"); SqlCommand cmd = new SqlCommand("select * from Barang", con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { dataBarang barang = new dataBarang(); barang.ID_Barang = reader.GetInt32(0); barang.Nama_Barang = reader.GetString(1); barang.Jenis_Barang = reader.GetString(2); barang.Merek = reader.GetString(3); barang.Harga = reader.GetInt32(4); barang.Stok = reader.GetInt32(5); list.Add(barang); } con.Close(); } return(list); }
public void HapusTransaksiManual(string id) { string query = string.Format("DELETE FROM Transaksi WHERE ID_Transaksi=" + id); dataBarang DataBarang = new dataBarang(); SqlConnection con = new SqlConnection("Data Source=FESAART-DEKSTOP;Initial Catalog=WCF_Projek-Akhir;Persist Security Info=True;User ID=sa;Password=123456"); SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void AddTransaksi(dataTransaksi dt) { string query = string.Format("insert into Transaksi values ({0},{1},{2},{3},'{4}','{5}')", dt.ID_User, dt.ID_Barang, dt.ID_Admin, dt.Total_Harga, dt.Tanggal_Transaksi, dt.Status); dataBarang DataBarang = new dataBarang(); SqlConnection con = new SqlConnection("Data Source=FESAART-DEKSTOP;Initial Catalog=WCF_Projek-Akhir;Persist Security Info=True;User ID=sa;Password=123456"); SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void UpdateBarangNoFoto(dataBarang db) { string query = string.Format("update Barang set Nama_Barang='{1}', Jenis_Barang='{2}', Merek='{3}', Harga={4}, Stok={5} where ID_Barang={0} ", db.ID_Barang, db.Nama_Barang, db.Jenis_Barang, db.Merek, db.Harga, db.Stok); dataBarang DataBarangdpp = new dataBarang(); SqlConnection con = new SqlConnection("Data Source=FESAART-DEKSTOP;Initial Catalog=WCF_Projek-Akhir;Persist Security Info=True;User ID=sa;Password=123456"); SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public void AddBarang(dataBarang db) { string query = string.Format("insert into Barang values ('{0}', '{1}', '{2}', {3}, {4}, '{5}')", db.Nama_Barang, db.Jenis_Barang, db.Merek, db.Harga, db.Stok, db.Foto); dataBarang DataBarang = new dataBarang(); SqlConnection con = new SqlConnection("Data Source=FESAART-DEKSTOP;Initial Catalog=WCF_Projek-Akhir;Persist Security Info=True;User ID=sa;Password=123456"); SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); }
public dataBarang GetBarangID(string id) { dataBarang barang = new dataBarang(); SqlConnection con = new SqlConnection("Data Source=FESAART-DEKSTOP;Initial Catalog=WCF_Projek-Akhir;Persist Security Info=True;User ID=sa;Password=123456"); SqlCommand cmd = new SqlCommand("select * from Barang where ID_Barang=" + id, con); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { barang.ID_Barang = reader.GetInt32(0); barang.Nama_Barang = reader.GetString(1); barang.Jenis_Barang = reader.GetString(2); barang.Merek = reader.GetString(3); barang.Harga = reader.GetInt32(4); barang.Stok = reader.GetInt32(5); barang.Foto = reader.GetString(6); } con.Close(); return(barang); }