public SQLiteDatabase getDatabase(Context context) {
if (salesDB != null) {
salesDB = null;
}
salesDB = new SalesDB(context);
return salesDB.getWritableDatabase();
}
public ArrayList<Detail> retrieveDetailList(Context context, String vendorName) {
db = getDatabase(context);
Cursor cursor = salesDB.retrieveDetailList(db, vendorName);
ArrayList<Detail> mDetailList = new ArrayList<Detail>();
while (cursor.moveToNext()) {
Detail detail =
new Detail(
cursor.getString(0),
cursor.getString(1),
cursor.getString(2),
cursor.getString(3),
cursor.getString(4),
cursor.getString(5),
cursor.getString(6),
cursor.getString(7),
cursor.getString(8),
cursor.getString(9),
cursor.getString(10));
mDetailList.add(detail);
}
cursor.close();
db.close();
return mDetailList;
}
public void insertDetail(Context context, Detail detail) {
db = getDatabase(context);
db.beginTransaction();
try {
salesDB.insertDetail(db, detail);
db.setTransactionSuccessful();
Toast.makeText(context, "정상적으로 등록되었습니다.", Toast.LENGTH_LONG).show();
} catch (SQLiteConstraintException e) {
Toast.makeText(context, "거래처 명이 일치하지 않습니다.", Toast.LENGTH_LONG).show();
} catch (SQLException e) {
Toast.makeText(context, "올바른 문자인지 확인해주세요.", Toast.LENGTH_LONG).show();
e.printStackTrace();
} finally {
db.endTransaction();
db.close();
}
}
public void updateHeader(Context context, Header header) {
db = getDatabase(context);
db.beginTransaction();
try {
salesDB.updateHeader(db, header);
db.setTransactionSuccessful();
Toast.makeText(context, "정상적으로 수정되었습니다.", Toast.LENGTH_LONG).show();
} catch (SQLiteConstraintException e) {
Toast.makeText(context, "거래처 명이 중복입니다.", Toast.LENGTH_LONG).show();
} catch (SQLException e) {
Toast.makeText(context, "올바른 문자인지 확인해주세요.", Toast.LENGTH_LONG).show();
e.printStackTrace();
} finally {
db.endTransaction();
db.close();
}
}
public Header retrieveHeader(Context context, String headerID) {
db = getDatabase(context);
Cursor cursor = salesDB.retrieveHeader(db, headerID);
Header header = new Header();
while (cursor.moveToNext()) {
header.setHeaderId(cursor.getString(0));
header.setVendorName(cursor.getString(1));
header.setLocation(cursor.getString(2));
header.setPerson(cursor.getString(3));
header.setPhoneNo(cursor.getString(4));
header.setEtcHeader(cursor.getString(5));
}
cursor.close();
db.close();
return header;
}
public String[] retrieveVendorNameList(Context context) {
db = getDatabase(context);
Cursor cursor = salesDB.retrieveHeaderList(db);
ArrayList<String> mVendorNameList = new ArrayList<String>();
while (cursor.moveToNext()) {
String vendorName = cursor.getString(1);
mVendorNameList.add(vendorName);
}
cursor.close();
db.close();
String[] strVendorNameList = new String[mVendorNameList.size()];
for (int i = 0; i < mVendorNameList.size(); i++) {
strVendorNameList[i] = mVendorNameList.get(i);
}
return strVendorNameList;
}
public ArrayList<Header> retrieveHeaderList(Context context) {
db = getDatabase(context);
Cursor cursor = salesDB.retrieveHeaderList(db);
ArrayList<Header> mHeaderList = new ArrayList<Header>();
while (cursor.moveToNext()) {
Header header =
new Header(
cursor.getString(0),
cursor.getString(1),
cursor.getString(2),
cursor.getString(3),
cursor.getString(4),
cursor.getString(5));
mHeaderList.add(header);
}
cursor.close();
db.close();
return mHeaderList;
}
public Detail retrieveDetail(Context context, String detailID) {
db = getDatabase(context);
Cursor cursor = salesDB.retrieveDetail(db, detailID);
Detail detail = new Detail();
while (cursor.moveToNext()) {
detail.setDetailId(cursor.getString(0));
detail.setDetailVendorName(cursor.getString(1));
detail.setDetailDate(cursor.getString(2));
detail.setDetailFG(cursor.getString(3));
detail.setDetailMG(cursor.getString(4));
detail.setDetailKC(cursor.getString(5));
detail.setDetailFL(cursor.getString(6));
detail.setDetailFO(cursor.getString(7));
detail.setDetailDO(cursor.getString(8));
detail.setDetailEtc(cursor.getString(9));
detail.setDetailNote(cursor.getString(10));
}
cursor.close();
db.close();
return detail;
}
public void deleteDetail(Context context, String detailID) {
db = getDatabase(context);
salesDB.deleteDetail(db, detailID);
db.close();
}
public void deleteHeader(Context context, String headerID) {
db = getDatabase(context);
salesDB.deleteHeader(db, headerID);
db.close();
}
