public int Update(List <JOB_ATTACHMENTDC> objJOB_ATTACHMENTs) { int updatedCount = 0; DBConnection objConnection = new DBConnection(); JOB_ATTACHMENTDA objJOB_ATTACHMENTDA = new JOB_ATTACHMENTDA(); try { objConnection.Open(true); updatedCount = objJOB_ATTACHMENTDA.Update(objConnection, objJOB_ATTACHMENTs); IsDirty = objJOB_ATTACHMENTDA.IsDirty; if (IsDirty) { objConnection.Rollback(); } else { objConnection.Commit(); } } catch (Exception ex) { objConnection.Rollback(); throw ex; } finally { objConnection.Close(); } return(updatedCount); }
public JOB_ATTACHMENTDC LoadByPrimaryKey(int JOB_ID, int ATTACHMENT_ID) { DBConnection objConnection = new DBConnection(); JOB_ATTACHMENTDA objJOB_ATTACHMENTDA = new JOB_ATTACHMENTDA(); JOB_ATTACHMENTDC objJOB_ATTACHMENTDC = null; try { objConnection.Open(false); objJOB_ATTACHMENTDC = objJOB_ATTACHMENTDA.LoadByPrimaryKey(objConnection, JOB_ID, ATTACHMENT_ID); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objJOB_ATTACHMENTDC); }
public List <JOB_ATTACHMENTDC> LoadAll() { DBConnection objConnection = new DBConnection(); JOB_ATTACHMENTDA objJOB_ATTACHMENTDA = new JOB_ATTACHMENTDA(); List <JOB_ATTACHMENTDC> objJOB_ATTACHMENTDC = null; try { objConnection.Open(false); objJOB_ATTACHMENTDC = objJOB_ATTACHMENTDA.LoadAll(objConnection); } catch (Exception ex) { throw ex; } finally { objConnection.Close(); } return(objJOB_ATTACHMENTDC); }
public int Insert(List <JOB_ATTACHMENTDC> objJOB_ATTACHMENTs) { int insertedCount = 0; DBConnection objConnection = new DBConnection(); JOB_ATTACHMENTDA objJOB_ATTACHMENTDA = new JOB_ATTACHMENTDA(); try { objConnection.Open(true); insertedCount = objJOB_ATTACHMENTDA.Insert(objConnection, objJOB_ATTACHMENTs); objConnection.Commit(); } catch (Exception ex) { objConnection.Rollback(); throw ex; } finally { objConnection.Close(); } return(insertedCount); }