public Boolean UpdateDevice(string prevoiusName, string name, double price, double quantity, double total) { Boolean check = false; devicesStore = new DevicesStore(); devicesStoreDB = new DevicesStoreDB(); if (prevoiusName.Equals("NOT CHANAGEE")) { devicesStore.setName(name); } else { devicesStore.setName(name); check = devicesStoreDB.checkDevice(devicesStore); devicesStore.setName(prevoiusName); } devicesStore.setPrice(price); devicesStore.setQuantity(quantity); devicesStore.setTotal(total); if (check == true) { return(false); } else { int ID = devicesStoreDB.selectDeviceId(devicesStore); devicesStore.setID(ID); devicesStore.setName(name); devicesStoreDB.update(devicesStore); return(true); } }
public void selectPrice(DevicesStore devicesStore) { connection.open(); command = new SqlCommand("select price from EquipsStore where name='" + devicesStore.getName() + "'", connection.getConnection()); devicesStore.setPrice(double.Parse(command.ExecuteScalar().ToString())); connection.close(); }
public Boolean insertDevices(string name, double price, double quantity, double total) { devicesStore = new DevicesStore(); devicesStoreDB = new DevicesStoreDB(); devicesStore.setName(name); devicesStore.setPrice(price); devicesStore.setQuantity(quantity); devicesStore.setTotal(total); check = devicesStoreDB.checkDevice(devicesStore); if (check == true) { return(false); } else { devicesStoreDB.insert(devicesStore); return(true); } }