public KategoriBarang GetById(int id)
{
KategoriBarang kategoribarang = null;
using (var conn = new SqlConnection(constr))
{
conn.Open();
String query = "SELECT*FROM KategoriBarang where ID=@0";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@0", id);
SqlDataReader reader = cmd.ExecuteReader();
KategoriBarang kb = null;
while (reader.Read())
{
kb = new KategoriBarang(reader);
}
}
return(kategoribarang);
}
public List <KategoriBarang> getAll()
{
List <KategoriBarang> list = new List <KategoriBarang>();
using (var conn = new SqlConnection(constr))
{
conn.Open();
string query = "SELECT*FROM Kategori";
SqlCommand cmd = new SqlCommand(query, conn);
SqlDataReader reader = cmd.ExecuteReader();
KategoriBarang KB = null;
while (reader.Read())
{
list.Add(KB);
}
conn.Close();
}
return(list);
}
