public void updateItem(LocationClothesContent locationClothesContent)
{
connection.open();
command = new SqlCommand("update LocationClothesContent set quantity='" + locationClothesContent.getQuantity() + "' , total='" + locationClothesContent.getTotal() + "' where name='" + locationClothesContent.getName() + "' and locationClothesID='" + locationClothesContent.getLocationClothesID() + "'", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}
public SqlDataReader fillListView(LocationClothesContent locationClothesContent)
{
connection.open();
command = new SqlCommand("select * from LocationClothesContent where locationClothesID='" + locationClothesContent.getLocationClothesID() + "'", connection.getConnection());
SqlDataReader reader = command.ExecuteReader();
return(reader);
}
public void delete(LocationClothesContent locationClothesContent)
{
connection.open();
command = new SqlCommand("delete from LocationClothesContent where name='" + locationClothesContent.getName() + "' and locationClothesID='" + locationClothesContent.getLocationClothesID() + "'", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}
public void insert(LocationClothesContent locationClothesContent)
{
connection.open();
command = new SqlCommand("insert into LocationClothesContent values('" + locationClothesContent.getName() + "' , '" + locationClothesContent.getPrice() + "' , '" + locationClothesContent.getQuantity() + "' , '" + locationClothesContent.getTotal() + "' , '" + locationClothesContent.getLocationClothesID() + "')", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}