public static Event fromID(int ID) throws Exception {
DBWrapper db = new DBWrapper();
PreparedStatement st =
db.getPreparedStatement(
"SELECT e.ID as ID, e.Name as Name, e.Description as Description, e.CreatedBy as CreatedBy e.OwnedBy as OwnedBy, e.CreatedOn as CreatedOn, e.LastModifiedOn as LastModifiedOn, e.IsPrivate as IsPrivate, e.IsActive as IsActive, e.IsDeleted as IsDeleted FROM Event e WHERE e.ID=? LIMIT 1");
st.setInt(0, ID);
ResultSet rs = db.executeThisQuery(st);
if (rs.first()) {
Event e = new Event();
e.ID = rs.getInt("ID");
e.name = rs.getString("Name");
e.description = rs.getString("Description");
e.createdByID = rs.getInt("CreatedBy");
e.ownedByID = rs.getInt("OwnedBy");
e.createdOn = new DateTime((Date) rs.getTimestamp("CreatedOn"));
e.lastModifiedOn = new DateTime((Date) rs.getTimestamp("LastModifiedOn"));
e.isPrivate = rs.getInt("IsPrivate");
e.isActive = rs.getInt("IsActive");
e.isDeleted = rs.getInt("IsDeleted");
e.isNew = false;
return e;
}
return null;
}
public void setTableItem(String pasport, int column, String text) {
DBWrapper dbw = new DBWrapper();
Db db = dbw.openConnection();
Clients c = new Clients();
switch (column) {
case 0:
db.from(c).set(c.Surname).to(text).where(c.Passport).is(pasport).update();
break;
case 1:
db.from(c).set(c.Name).to(text).where(c.Passport).is(pasport).update();
break;
case 2:
db.from(c).set(c.Ochestvo).to(text).where(c.Passport).is(pasport).update();
break;
case 3:
db.from(c).set(c.Mphone).to(text).where(c.Passport).is(pasport).update();
break;
case 4:
db.from(c).set(c.Passport).to(text).where(c.Passport).is(pasport).update();
break;
case 5:
db.from(c).set(c.Prava).to(text).where(c.Passport).is(pasport).update();
break;
default:
}
}
@Listener("Search")
public void search() {
Query<Travel> query;
try {
query = DBWrapper.getInstance().prepareQuery(Travel.class);
} catch (SQLException e) {
showError("Error recuperando viajes");
return;
}
double maxPrice = -1;
try {
String price = view.getMaxPrice();
if (!price.isEmpty()) maxPrice = Double.valueOf(price);
} catch (NumberFormatException e) {
showError("Formato de precio inválido.");
return;
}
try {
if (maxPrice != -1) query.setMax("price", maxPrice);
view.setResults(DBWrapper.getInstance().executeQuery(query));
} catch (Exception e) {
showError("Error buscando en la base de datos.");
}
}
public static int addNullWarranty() {
DBWrapper dbw = new DBWrapper();
Db db = dbw.openConnection();
Warranty w = new Warranty();
w.Note = "неопределено";
w.Warr = "нет";
db.insert(w);
w = db.from(w).orderByDesc(w.Kodwarr).selectFirst();
return w.Kodwarr;
}
public static int addWarranty(String warr) {
DBWrapper dbw = new DBWrapper();
Db db = dbw.openConnection();
Warranty w = new Warranty();
if (warr.isEmpty()) {
w.Warr = "нет";
} else w.Warr = warr;
db.insert(w);
w = db.from(w).orderByDesc(w.Kodwarr).selectFirst();
return w.Kodwarr;
}
public boolean delete() throws Exception {
if (!isNew) {
DBWrapper db = new DBWrapper();
PreparedStatement st = db.getPreparedStatement("DELETE FROM Event WHERE ID=?");
st.setInt(0, ID);
if (st.execute()) {
isNew = true;
return true;
}
}
return false;
}
public static Map<Integer, String> getClientCarsList(int clientId) {
DBWrapper dbw = new DBWrapper();
Db db = dbw.openConnection();
Car c = new Car();
Map<Integer, String> mp = new HashMap<Integer, String>();
List<Car> ls = db.from(c).where(c.Kodclient).is(clientId).select();
Iterator<Car> it = ls.iterator();
while (it.hasNext()) {
Car temp = (Car) it.next();
mp.put(temp.Kodavto, temp.Mark);
}
return mp;
}
public static void addClient(
String phone, String name, String middleName, String passport, String prava, String Surname) {
DBWrapper dbw = new DBWrapper();
Db db = dbw.openConnection();
Clients c = new Clients();
c.Mphone = phone;
c.Name = name;
c.Ochestvo = middleName;
c.Passport = passport;
c.Prava = prava;
c.Surname = Surname;
db.insert(c);
}
public int lastInsertID() throws Exception {
DBWrapper db = new DBWrapper();
PreparedStatement st = db.getPreparedStatement("SELECT LAST_INSERT_ID() as ID");
ResultSet rs = db.executeThisQuery(st);
if (rs.first()) {
return rs.getInt("ID");
}
return -1;
}
public static Map<Integer, String> getClientsList() {
DBWrapper dbw = new DBWrapper();
Db db = dbw.openConnection();
Clients c = new Clients();
Map<Integer, String> mp = new HashMap<Integer, String>();
List<Clients> ls = db.from(c).select();
Iterator<Clients> it = ls.iterator();
while (it.hasNext()) {
Clients temp = (Clients) it.next();
mp.put(temp.Kodclient, temp.Surname + " " + temp.Name + " " + temp.Ochestvo);
}
return mp;
}
/**
* Logs the teacher in if they have previously registered for a new account
*
* @param u String username
* @param p char password
*/
public void logInTeacher(String u, String p) {
username = u;
String pWord = p;
if (dataBase.login(u, pWord)) {
TeacherView t = new TeacherView(dataBase, u);
screen.dispose();
}
}
public void fillingTable(Table table) {
DBWrapper dbw = new DBWrapper();
Db db = dbw.openConnection();
Clients c = new Clients();
List<Clients> idd = db.from(c).select();
Iterator<Clients> it1 = idd.iterator();
while (it1.hasNext()) {
Clients temp = (Clients) it1.next();
TableItem item = new TableItem(table, SWT.NONE);
item.setText(0, temp.Surname);
item.setText(1, temp.Name);
item.setText(2, temp.Ochestvo);
item.setText(3, temp.Mphone);
item.setText(4, temp.Passport);
item.setText(5, temp.Prava);
}
}
/**
* Logs a student in given a correct username and password
*
* @param u String username
* @param p char password
*/
public void logInStudent(String u, String p) {
username = u;
String pWord = p;
if (dataBase.login(u, pWord)) {
setupMainMenuUI();
} else {
System.out.println("Login Failed.");
}
}
public void submitClick(View v) {
String userid = userEmail.getText().toString();
String pass = passwd.getText().toString();
if (userid.length() > 0 && pass.length() > 0) {
Toast.makeText(this, "Correct data entered", Toast.LENGTH_LONG).show();
// Save data in Shared Preference
/*
SharedPreferences pref = getSharedPreferences("auth", MODE_PRIVATE);
SharedPreferences.Editor editor = pref.edit();
editor.putString("userid", userid);
editor.putString("password", pass);
editor.commit();
*/
DBWrapper wrapper = new DBWrapper(this);
long rowid = wrapper.addCredentials(userid, pass);
if (rowid != -1) Toast.makeText(this, "Data Saved in DB", Toast.LENGTH_LONG).show();
else Toast.makeText(this, "Error saving in DB", Toast.LENGTH_LONG).show();
} else Toast.makeText(this, "Please enter data", Toast.LENGTH_SHORT).show();
}
public boolean save() throws Exception {
DBWrapper db = new DBWrapper();
if (!isNew) {
PreparedStatement st =
db.getPreparedStatement(
"UPDATE Event SET Name=? Description=? CreatedBy=? OwnedBy=? LastModifiedOn=? IsPrivate=? IsActive=? IsDeleted=? WHERE ID=?");
st.setString(1, name);
st.setString(2, description);
st.setInt(3, createdByID);
st.setInt(4, ownedByID);
st.setTimestamp(4, new Timestamp((new DateTime()).getMillis()));
st.setInt(6, isPrivate);
st.setInt(7, isActive);
st.setInt(8, isDeleted);
st.setInt(9, ID);
return st.execute();
} else {
PreparedStatement st =
db.getPreparedStatement(
"INSERT INTO Event(Name, Description, CreatedBy, OwnedBy, CreatedOn, LastModifiedOn, IsPrivate, IsActive, IsDeleted) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)");
st.setString(1, name);
st.setString(2, description);
st.setInt(3, createdByID);
st.setInt(4, ownedByID);
st.setTimestamp(5, new Timestamp((new DateTime()).getMillis()));
st.setTimestamp(6, new Timestamp((new DateTime()).getMillis()));
st.setInt(7, isPrivate);
st.setInt(8, isActive);
st.setInt(9, isDeleted);
if (st.execute()) {
isNew = false;
return true;
}
}
return false;
}
public static void delWarranty(int id) {
DBWrapper dbw = new DBWrapper();
Db db = dbw.openConnection();
Warranty w = new Warranty();
db.from(w).where(w.Kodwarr).is(id).delete();
}
/** Function that opens the database */
public void opendb() {
wrapper = new DBWrapper();
wrapper.setup(directory);
env = wrapper.getEnvironment();
pk_index = new Indices(wrapper.getStore());
}
public void deleteTableItem(String pasport) {
DBWrapper dbw = new DBWrapper();
Db db = dbw.openConnection();
Clients cc = new Clients();
db.from(cc).where(cc.Passport).is(pasport).delete();
}
