public double getClothePrice(string name)
{
clothesStoreDB = new ClothesStoreDB();
clothesStore = new ClothesStore();
clothesStore.setName(name);
clothesStoreDB.selectPrice(clothesStore);
return(clothesStore.getPrice());
}
public void update(ClothesStore clothesStore)
{
connection.open();
command = new SqlCommand("update ClothesStore set name='" + clothesStore.getName() + "',price='" + clothesStore.getPrice() + "',quantity='" + clothesStore.getQuantity() + "' ,total='" + clothesStore.getTotal() + "' where ID='" + clothesStore.getID() + "'", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}
public void insert(ClothesStore clothesStore)
{
connection.open();
command = new SqlCommand("insert into ClothesStore values('" + clothesStore.getName() + "' , '" + clothesStore.getPrice() + "' , '" + clothesStore.getQuantity() + "','" + clothesStore.getTotal() + "')", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}