public int Update(List <PERMIT_ATTACHMENTDC> objPERMIT_ATTACHMENTs)
        {
            int                 updatedCount           = 0;
            DBConnection        objConnection          = new DBConnection();
            PERMIT_ATTACHMENTDA objPERMIT_ATTACHMENTDA = new PERMIT_ATTACHMENTDA();

            try
            {
                objConnection.Open(true);
                updatedCount = objPERMIT_ATTACHMENTDA.Update(objConnection, objPERMIT_ATTACHMENTs);
                IsDirty      = objPERMIT_ATTACHMENTDA.IsDirty;
                if (IsDirty)
                {
                    objConnection.Rollback();
                }
                else
                {
                    objConnection.Commit();
                }
            }
            catch (Exception ex)
            {
                objConnection.Rollback();
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(updatedCount);
        }
        public PERMIT_ATTACHMENTDC LoadByPrimaryKey(int PERMIT_ID, int ATTACHMENT_ID)
        {
            DBConnection        objConnection          = new DBConnection();
            PERMIT_ATTACHMENTDA objPERMIT_ATTACHMENTDA = new PERMIT_ATTACHMENTDA();
            PERMIT_ATTACHMENTDC objPERMIT_ATTACHMENTDC = null;

            try
            {
                objConnection.Open(false);
                objPERMIT_ATTACHMENTDC = objPERMIT_ATTACHMENTDA.LoadByPrimaryKey(objConnection, PERMIT_ID, ATTACHMENT_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objPERMIT_ATTACHMENTDC);
        }
        public List <PERMIT_ATTACHMENTDC> LoadAll()
        {
            DBConnection               objConnection          = new DBConnection();
            PERMIT_ATTACHMENTDA        objPERMIT_ATTACHMENTDA = new PERMIT_ATTACHMENTDA();
            List <PERMIT_ATTACHMENTDC> objPERMIT_ATTACHMENTDC = null;

            try
            {
                objConnection.Open(false);
                objPERMIT_ATTACHMENTDC = objPERMIT_ATTACHMENTDA.LoadAll(objConnection);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objPERMIT_ATTACHMENTDC);
        }
        public int Insert(List <PERMIT_ATTACHMENTDC> objPERMIT_ATTACHMENTs)
        {
            int                 insertedCount          = 0;
            DBConnection        objConnection          = new DBConnection();
            PERMIT_ATTACHMENTDA objPERMIT_ATTACHMENTDA = new PERMIT_ATTACHMENTDA();

            try
            {
                objConnection.Open(true);
                insertedCount = objPERMIT_ATTACHMENTDA.Insert(objConnection, objPERMIT_ATTACHMENTs);
                objConnection.Commit();
            }
            catch (Exception ex)
            {
                objConnection.Rollback();
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(insertedCount);
        }