public bool insert(Data data) { Data db = new Data(); db.open(); int result_business = db.insert("INSERT INTO business (company, owner, phone, address, email) VALUES (@company, @owner, @phone, @address, @email)", data); Object select_id = db.select("SELECT id AS business_id FROM business ORDER BY id DESC LIMIT 1", data).getValue("business_id"); data.add("business_id", select_id); int result_profile = db.insert("INSERT INTO profile(business_id) VALUES (@business_id)", data); db.close(); return true; }
public void transferTo(Data data) { Data db = new Data(); db.open(); db.insert("UPDATE account SET balance=(balance+@amount) WHERE user_id=@user_id", data); db.close(); }
public void transaction(Data data) { Data db = new Data(); db.open(); db.insert("INSERT INTO transaction (from_id, to_id, amount, time, from_name, to_name) VALUES (@from_id, @to_id, @amount, now(), @from_name, @to_name)", data); db.close(); }
public bool register_user(Data data) { Data db = new Data(); db.open(); int result = db.insert("INSERT INTO user(username, password, firstname, lastname) VALUES (@username, @password, @firstname, @lastname)", data); db.close(); return true; }
public bool insert(Data data) { Data db = new Data(); db.open(); int result = db.insert("INSERT INTO image(name, path, caption, profile_id) VALUES (@name, @path, @caption, @profile_id)", data); db.close(); return true; }
public bool insert(Data data) { Data db = new Data(); db.open(); int result = db.insert("INSERT INTO rating(value, profile_id, user_id) VALUES (@value, @profile_id, @user_id)", data); db.close(); return true; }
public bool insert(Data data) { Data db = new Data(); db.open(); int result = db.insert("INSERT INTO account(balance, user_id, date) VALUES (1000.00, @user_id, now())", data); db.close(); return true; }
public bool update(Data data) { Data db = new Data(); db.open(); int result = db.insert(@"UPDATE profile SET name=@name, trading_hour=@trading_hour, phone=@phone, address=@address, email=@email, summary=@summary, latitude=@latitude, longitude=@longitude WHERE id=@profileID", data); db.close(); return true; }
public bool insert(Data data) { Data db = new Data(); db.open(); int result = db.insert(@"INSERT INTO profile(name, trading_hour, phone, address, email, summary, latitude, longitude) VALUES (@name, @trading_hour, @phone, @address, @email, @summary, @latitude, @longitude)", data); db.close(); return true; }
public bool insert(Data data) { Data db = new Data(); db.open(); int result = db.insert(@"INSERT INTO user(username, password, name, address, phone, licence) VALUES (@username, @password, @name, @address, @phone, @licence)", data); db.close(); return true; }
public bool update(Data data) { Data db = new Data(); db.open(); int result = db.insert(@"UPDATE rating SET value=@value WHERE profile_id=@profile_id AND user_id=@user_id", data); db.close(); return true; }