public void deleteClothes(string clothType)
{
clothesStore = new ClothesStore();
clothesStoreDB = new ClothesStoreDB();
clothesStore.setName(clothType);
clothesStoreDB.delete(clothesStore);
}
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 double getQuantity(string itemName)
{
clothesStore = new ClothesStore();
clothesStoreDB = new ClothesStoreDB();
clothesStore.setName(itemName);
clothesStoreDB.selectQuantity(clothesStore);
return(clothesStore.getQuantity());
}
public void updateQuantityPlus(string clothesName, double quantity)
{
clothesStore = new ClothesStore();
clothesStoreDB = new ClothesStoreDB();
clothesStore.setName(clothesName);
clothesStore.setQuantity(quantity);
clothesStoreDB.updateQuantityPlus(clothesStore);
}
public double getClothePrice(string name)
{
clothesStoreDB = new ClothesStoreDB();
clothesStore = new ClothesStore();
clothesStore.setName(name);
clothesStoreDB.selectPrice(clothesStore);
return(clothesStore.getPrice());
}
public bool checkItemInStore(string itemName)
{
clothesStore = new ClothesStore();
clothesStoreDB = new ClothesStoreDB();
clothesStore.setName(itemName);
bool check = clothesStoreDB.checkCloth(clothesStore);
return(check);
}
public void fillComboboxClothesName(ComboBox combobox)
{
combobox.Items.Clear();
connection = new DBConnection();
clothesStoreDB = new ClothesStoreDB();
SqlDataReader reader = clothesStoreDB.fillComboboxClothesName();
while (reader.Read())
{
combobox.Items.Add(reader["name"]);
}
connection.close();
}
public bool checkItemQuantity(string itemName, double quantity)
{
clothesStore = new ClothesStore();
clothesStoreDB = new ClothesStoreDB();
clothesStore.setName(itemName);
clothesStoreDB.selectQuantity(clothesStore);
if (quantity > clothesStore.getQuantity())
{
return(false);
}
else
{
return(true);
}
}
public void fillListViewClothesStore(ListView listView)
{
listView.Items.Clear();
connection = new DBConnection();
clothesStoreDB = new ClothesStoreDB();
SqlDataReader reader = clothesStoreDB.fillListViewClothes();
while (reader.Read())
{
ListViewItem lvi = new ListViewItem(reader["name"].ToString());
lvi.SubItems.Add(reader["price"].ToString());
lvi.SubItems.Add(reader["quantity"].ToString());
lvi.SubItems.Add(reader["total"].ToString());
listView.Items.Add(lvi);
}
connection.close();
}
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);
}
}
