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