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 Data selectTransaction(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM transaction WHERE from_id=@user_id OR to_id=@user_id", data); db.close(); return result; }
public Data luceneSelect(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM user", data); db.close(); return result; }
public Data selectAll(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM profile ORDER BY name ASC LIMIT @page, 10", data); db.close(); return result; }
public Data getTotalRating(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT value FROM rating WHERE profile_id=@profile_id", data); db.close(); return result; }
public Data getRatingThree(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM rating WHERE value=3 AND profile_id=@profile_id", data); db.close(); return result; }
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 Data checkUserRating(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT id FROM rating WHERE profile_id=@profile_id AND user_id=@user_id", data); db.close(); return result; }
public Data selectImage(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT path, caption FROM image WHERE id=@imageId", data); db.close(); return result; }
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 Data getSearchForIndex(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM profile", data); db.close(); return result; }
public Data selectInserted(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM profile WHERE name=@name AND address=@address AND email=@email AND phone=@phone", data); db.close(); return result; }
public Data getUserID(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT id, username FROM user WHERE username=@username", data); db.close(); return result; }
public Data select(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM profile WHERE id=@id", data); db.close(); return result; }
public Data login(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT username, firstname, lastname FROM user WHERE username = @username AND password = @password", data); db.close(); return result; }
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 Data select(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM account WHERE user_id=@user_id", data); db.close(); return result; }
public Data getUser(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM user WHERE id=@user_id", data); db.close(); return result; }
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 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 Data searchAll(Data data) { rating rating = new Rating_db(); Data db = new Data(); db.open(); Data result = db.select(@"SELECT * FROM profile WHERE latitude<@eastLatitude AND latitude>@westLatitude AND longitude<@northLongitude AND longitude>@southLongitude", data); result.getString("averageRating", rating. db.close(); return result; }
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 bool checkProfile(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT * FROM profile WHERE id=@profile_id", data); db.close(); if (result.Count == 0) { return false; } else { return true; } }
public Data search(Data data, String[] item) { Data db = new Data(); string items = ""; db.open(); string query = queryType(data); for (int i = 0; i < item.Count(); i++) { int count = item.Count(); if (i == count - 1) { items = items + item[i]; } else { items = items + item[i] + ","; } } query = query.Replace("<SEARCH>", items); Data result = db.select(query, data); db.close(); return result; }
public Data selectUser(Data data, String[] item) { string items = ""; Data db = new Data(); for (int i = 0; i < item.Count(); i++) { int count = item.Count(); if (i == count - 1) { items = items + item[i]; } else { items = items + item[i] + ","; } } string query = "SELECT * FROM user WHERE id IN(<SEARCH>)"; query = query.Replace("<SEARCH>", items); db.open(); Data result = db.select(query, data); db.close(); return result; }
public Data numPerRate(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT id FROM rating WHERE profile_id=@profile_id AND value=@value", data); db.close(); return result; }
public Data totalRating(Data data) { Data db = new Data(); db.open(); Data result = db.select("SELECT sum(value) FROM rating WHERE profile_id=@profile_id", data); data.add("sum_rating", result.getString("sum(value)")); Data total = db.select("SELECT value FROM rating WHERE profile_id=@profile_id", data); db.close(); return total; }