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