public void removeEmployeeContext(Employee employee, SkillContext context) { open(); ContentValues cv = new ContentValues(); cv.put(EMPLOYEE_ID, employee.getId()); cv.put(CONTEXT_ID, context.getId()); myDatabase.delete( EMPLOYEE_CONTEXT_TABLE, EMPLOYEE_ID + " =? AND " + CONTEXT_ID + " =?", new String[] {Integer.toString(employee.getId()), Integer.toString(context.getId())}); close(); }
public void removeEmployeeMaterial(Employee employee, Material material) { open(); ContentValues cv = new ContentValues(); cv.put(EMPLOYEE_ID, employee.getId()); cv.put(MATERIAL_ID, material.getId()); myDatabase.delete( EMPLOYEE_MATERIAL_TABLE, EMPLOYEE_ID + " =? AND " + MATERIAL_ID + " =?", new String[] {Integer.toString(employee.getId()), Integer.toString(material.getId())}); close(); }
public void removeEmployeeSkill(Employee employee, Skill skill) { open(); ContentValues cv = new ContentValues(); cv.put(EMPLOYEE_ID, employee.getId()); cv.put(SKILL_ID, skill.getId()); myDatabase.delete( EMPLOYEE_SKILL_TABLE, EMPLOYEE_ID + " =? AND " + SKILL_ID + " =?", new String[] {Integer.toString(employee.getId()), Integer.toString(skill.getId())}); close(); }
public void addEmployeeContext(Employee employee, SkillContext context) { open(); ContentValues cv = new ContentValues(); cv.put(EMPLOYEE_ID, employee.getId()); cv.put(CONTEXT_ID, context.getId()); myDatabase.insert(EMPLOYEE_CONTEXT_TABLE, null, cv); close(); }
public void addEmployeeMaterial(Employee employee, Material material) { open(); ContentValues cv = new ContentValues(); cv.put(EMPLOYEE_ID, employee.getId()); cv.put(MATERIAL_ID, material.getId()); myDatabase.insert(EMPLOYEE_MATERIAL_TABLE, null, cv); close(); }
public void addEmployeeSkill(Employee employee, Skill skill) { open(); ContentValues cv = new ContentValues(); cv.put(EMPLOYEE_ID, employee.getId()); cv.put(SKILL_ID, skill.getId()); myDatabase.insert(EMPLOYEE_SKILL_TABLE, null, cv); close(); }
public int createEmployee(Employee employee, List<Skill> selectedSkills) { open(); employee.setId((int) createBasicEmployee(employee)); for (Skill skill : selectedSkills) { addEmployeeSkill(employee, skill); } close(); return employee.getId(); }
/** * Update the employee with a new list of selected items * * @param employee * @param selectedItems */ public void updateEmployee(Employee employee, List<? extends DatabaseObject> selectedItems) { open(); updateEmployeeName(employee); int employeeId = employee.getId(); if (selectedItems.get(0) instanceof Skill) { List<Skill> employeeSkills = getEmployeeSkills(employeeId); for (Skill skill : employeeSkills) { if (!alreadyInList(skill, selectedItems)) { removeEmployeeSkill(employee, skill); } } for (Object skill : selectedItems) { if (!alreadyInList(skill, employeeSkills)) { addEmployeeSkill(employee, (Skill) skill); } } } else if (selectedItems.get(0) instanceof Material) { List<Material> employeeMaterials = getEmployeeMaterials(employeeId); for (Material material : employeeMaterials) { if (!alreadyInList(material, selectedItems)) { removeEmployeeMaterial(employee, material); } } for (Object material : selectedItems) { if (!alreadyInList(material, employeeMaterials)) { addEmployeeMaterial(employee, (Material) material); } } } else if (selectedItems.get(0) instanceof SkillContext) { List<SkillContext> employeeContexts = getEmployeeContexts(employeeId); for (SkillContext context : employeeContexts) { if (!alreadyInList(context, selectedItems)) { removeEmployeeContext(employee, context); } } for (Object context : selectedItems) { if (!alreadyInList(context, employeeContexts)) { addEmployeeContext(employee, (SkillContext) context); } } } close(); }
private void updateEmployeeName(Employee e) { ContentValues cv = new ContentValues(); cv.put(EMPLOYEE_NAME, e.getName()); myDatabase.update( EMPLOYEE_TABLE, cv, EMPLOYEE_ID + "= ?", new String[] {String.valueOf(e.getId())}); }