Esempio n. 1
0
        public int Update(List <SCREENDC> objSCREENs)
        {
            int          updatedCount  = 0;
            DBConnection objConnection = new DBConnection();
            SCREENDA     objSCREENDA   = new SCREENDA();

            try
            {
                objConnection.Open(true);
                updatedCount = objSCREENDA.Update(objConnection, objSCREENs);
                IsDirty      = objSCREENDA.IsDirty;
                if (IsDirty)
                {
                    objConnection.Rollback();
                }
                else
                {
                    objConnection.Commit();
                }
            }
            catch (Exception ex)
            {
                objConnection.Rollback();
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(updatedCount);
        }
Esempio n. 2
0
        public SCREENDC LoadByPrimaryKey(int SCREEN_ID)
        {
            DBConnection objConnection = new DBConnection();
            SCREENDA     objSCREENDA   = new SCREENDA();
            SCREENDC     objSCREENDC   = null;

            try
            {
                objConnection.Open(false);
                objSCREENDC = objSCREENDA.LoadByPrimaryKey(objConnection, SCREEN_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objSCREENDC);
        }
Esempio n. 3
0
        public List <SCREENDC> LoadAll()
        {
            DBConnection    objConnection = new DBConnection();
            SCREENDA        objSCREENDA   = new SCREENDA();
            List <SCREENDC> objSCREENDC   = null;

            try
            {
                objConnection.Open(false);
                objSCREENDC = objSCREENDA.LoadAll(objConnection);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objSCREENDC);
        }
Esempio n. 4
0
        public int Insert(List <SCREENDC> objSCREENs)
        {
            int          insertedCount = 0;
            DBConnection objConnection = new DBConnection();
            SCREENDA     objSCREENDA   = new SCREENDA();

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