public void selectPrice(ClothesStore clothesStore)
 {
     connection.open();
     command = new SqlCommand("select price from ClothesStore where name='" + clothesStore.getName() + "'", connection.getConnection());
     clothesStore.setPrice(double.Parse(command.ExecuteScalar().ToString()));
     connection.close();
 }
    public Boolean UpdateClothe(string prevoiusName, string name, double price, double quantity, double total)
    {
        Boolean check = false;

        clothesStore   = new ClothesStore();
        clothesStoreDB = new ClothesStoreDB();

        if (prevoiusName.Equals("NOT CHANAGEE"))
        {
            clothesStore.setName(name);
        }
        else
        {
            clothesStore.setName(name);
            check = clothesStoreDB.checkCloth(clothesStore);
            clothesStore.setName(prevoiusName);
        }
        clothesStore.setPrice(price);
        clothesStore.setQuantity(quantity);
        clothesStore.setTotal(total);

        if (check == true)
        {
            return(false);
        }
        else
        {
            int ID = clothesStoreDB.selectClotheId(clothesStore);
            clothesStore.setID(ID);
            clothesStore.setName(name);
            clothesStoreDB.update(clothesStore);
            return(true);
        }
    }
 public Boolean insertClothes(string name, double price, double quantity, double total)
 {
     clothesStore   = new ClothesStore();
     clothesStoreDB = new ClothesStoreDB();
     clothesStore.setName(name);
     clothesStore.setPrice(price);
     clothesStore.setQuantity(quantity);
     clothesStore.setTotal(total);
     check = clothesStoreDB.checkCloth(clothesStore);
     if (check == true)
     {
         return(false);
     }
     else
     {
         clothesStoreDB.insert(clothesStore);
         return(true);
     }
 }