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 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 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 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 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 luceneSelect(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM user", 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 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 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 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 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 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 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 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 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 getSearchForIndex(Data data)
{
Data db = new Data();
db.open();
Data result = db.select("SELECT * FROM profile", 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 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 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_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 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 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 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;
}
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;
}
