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;
}