public int Update(List <NOTEDC> objNOTEs) { int updatedCount = 0; DBConnection objConnection = new DBConnection(); NOTEDA objNOTEDA = new NOTEDA(); try { objConnection.Open(true); updatedCount = objNOTEDA.Update(objConnection, objNOTEs); IsDirty = objNOTEDA.IsDirty; if (IsDirty) { objConnection.Rollback(); } else { objConnection.Commit(); } } catch (Exception ex) { objConnection.Rollback(); throw ex; } finally { objConnection.Close(); } return(updatedCount); }
public List <NOTEDC> LoadAll() { DBConnection objConnection = new DBConnection(); NOTEDA objNOTEDA = new NOTEDA(); List <NOTEDC> objNOTEDC = null; try { objConnection.Open(false); objNOTEDC = objNOTEDA.LoadAll(objConnection); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objNOTEDC); }
public List <NOTEDC> LoadByPrimaryKey(int SCREEN_ID, int SCREEN_RECORD_ID) { DBConnection objConnection = new DBConnection(); NOTEDA objNOTEDA = new NOTEDA(); List <NOTEDC> objNOTEDC = null; try { objConnection.Open(false); objNOTEDC = objNOTEDA.LoadByPrimaryKey(objConnection, SCREEN_ID, SCREEN_RECORD_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objNOTEDC); }
public int Delete(List <NOTEDC> objNOTEs) { int deletedCount = 0; DBConnection objConnection = new DBConnection(); NOTEDA objNOTEDA = new NOTEDA(); try { objConnection.Open(true); deletedCount = objNOTEDA.Delete(objConnection, objNOTEs); objConnection.Commit(); } catch (Exception ex) { objConnection.Rollback(); throw ex; } finally { objConnection.Close(); } return(deletedCount); }