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