public static void deleteCustomer(Integer ID) {
		Database db = dbconnect();
		try {
                     String query = "UPDATE customer SET bDeleted = 1 "
                      + "WHERE CID = ?";

		db.prepare(query);
                db.bind_param(1, ID.toString());
		db.executeUpdate();
		db.close();
			
		} catch(SQLException e){
		   Error_Frame.Error(e.toString());
		}  
          }