public static AttachmentsInfo getPdfFormsByfilename1(String name) { try { // List<AttachmentsInfo> lst = FieldworkApplication.Connection().find( // AttachmentsInfo.class, // CamelNotationHelper // .toSQLName("attached_pdf_form_file_name") + "=?", // new String[] { name }); // if (lst != null && lst.size() > 0) { // return lst.get(0); // } List<AttachmentsInfo> lst = FieldworkApplication.Connection().findAll(AttachmentsInfo.class); if (lst != null && lst.size() > 0) { for (AttachmentsInfo a : lst) { if (a.attached_pdf_form_file_name.equalsIgnoreCase(name)) { return a; } } } } catch (ActiveRecordException e) { e.printStackTrace(); } return null; }
public static String getValueByName(String name) { String value = ""; try { List<StatusInfo> lst = FieldworkApplication.Connection().findAll(StatusInfo.class); for (StatusInfo s : lst) { if (s.statusName.equalsIgnoreCase(name)) { value = s.statusValue; } } } catch (ActiveRecordException e) { e.printStackTrace(); } return value; }
public static AttachmentsInfo getPdfFormsByID(int attach_id) { try { List<AttachmentsInfo> lst = FieldworkApplication.Connection().findAll(AttachmentsInfo.class); if (lst != null && lst.size() > 0) { for (AttachmentsInfo a : lst) { if (a.id == attach_id) { return a; } } } } catch (ActiveRecordException e) { e.printStackTrace(); } return null; }
public static AttachmentsInfo getPdfFormsByfilename(String name) { try { List<AttachmentsInfo> lst = FieldworkApplication.Connection() .find( AttachmentsInfo.class, CamelNotationHelper.toSQLName("attached_pdf_form_file_name") + "=?", new String[] {name}); if (lst != null && lst.size() > 0) { return lst.get(0); } } catch (ActiveRecordException e) { e.printStackTrace(); } return null; }
public static ArrayList<AttachmentsInfo> getPdfFormsByWorkerId(int w_id) { ArrayList<AttachmentsInfo> m_list = new ArrayList<AttachmentsInfo>(); try { List<AttachmentsInfo> lst = FieldworkApplication.Connection() .find( AttachmentsInfo.class, CamelNotationHelper.toSQLName("WorkOrderId") + "=?", new String[] {String.valueOf(w_id)}); if (lst != null && lst.size() > 0) { m_list = new ArrayList<AttachmentsInfo>(lst); } } catch (ActiveRecordException e) { e.printStackTrace(); } return m_list; }