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 void updateQuantityMinus(ClothesStore clothesStore)
{
connection.open();
command = new SqlCommand("update ClothesStore set quantity=quantity-'" + clothesStore.getQuantity() + "' where name='" + clothesStore.getName() + "'", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}
public void update(ClothesStore clothesStore)
{
connection.open();
command = new SqlCommand("update ClothesStore set name='" + clothesStore.getName() + "',price='" + clothesStore.getPrice() + "',quantity='" + clothesStore.getQuantity() + "' ,total='" + clothesStore.getTotal() + "' where ID='" + clothesStore.getID() + "'", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}
public void delete(ClothesStore clothesStore)
{
connection.open();
command = new SqlCommand("delete from ClothesStore where name='" + clothesStore.getName() + "'", connection.getConnection());
command.ExecuteNonQuery();
connection.close();
}
public void deleteClothes(string clothType)
{
clothesStore = new ClothesStore();
clothesStoreDB = new ClothesStoreDB();
clothesStore.setName(clothType);
clothesStoreDB.delete(clothesStore);
}
public void insert(ClothesStore clothesStore)
{
connection.open();
command = new SqlCommand("insert into ClothesStore values('" + clothesStore.getName() + "' , '" + clothesStore.getPrice() + "' , '" + clothesStore.getQuantity() + "','" + clothesStore.getTotal() + "')", connection.getConnection());
command.ExecuteNonQuery();
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 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 int selectClotheId(ClothesStore clothesStore)
{
connection.open();
command = new SqlCommand("select ID from ClothesStore where name='" + clothesStore.getName() + "'", connection.getConnection());
int ID = (int)command.ExecuteScalar();
connection.close();
return(ID);
}
public bool checkItemInStore(string itemName)
{
clothesStore = new ClothesStore();
clothesStoreDB = new ClothesStoreDB();
clothesStore.setName(itemName);
bool check = clothesStoreDB.checkCloth(clothesStore);
return(check);
}
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 Boolean checkCloth(ClothesStore clothesStore)
{
connection.open();
command = new SqlCommand("select count(*) from ClothesStore where name='" + clothesStore.getName() + "'", connection.getConnection());
int PriceCount = (int)command.ExecuteScalar();
connection.close();
if (PriceCount > 0)
{
return(true); // exiting item.
}
else
{
return(false); // new item.
}
}
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);
}
}
