Beispiel #1
0
        public int Insert(DBConnection objConnection, LABORDC objLABOR_VALUs)
        {
            int     insertedCount   = 0;
            LABORDA objLABOR_VALUDA = new LABORDA();

            insertedCount = objLABOR_VALUDA.Insert(objConnection, objLABOR_VALUs);
            return(insertedCount);
        }
Beispiel #2
0
        public int Update(DBConnection objConnection, LABORDC objLABOR_VALUs)
        {
            int     updatedCount    = 0;
            LABORDA objLABOR_VALUDA = new LABORDA();

            updatedCount = objLABOR_VALUDA.Update(objConnection, objLABOR_VALUs);
            return(updatedCount);
        }
Beispiel #3
0
        public List <LABORDC> GetLaborFromManPower(int DAILY_ID, int DAILY_TYPE)
        {
            DBConnection   objConnection   = new DBConnection();
            LABORDA        objLABOR_VALUDA = new LABORDA();
            List <LABORDC> objLABOR_VALUDC = null;

            try
            {
                objConnection.Open(false);
                objLABOR_VALUDC = objLABOR_VALUDA.GetLaborFromManPower(objConnection, DAILY_ID, DAILY_TYPE);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objLABOR_VALUDC);
        }
Beispiel #4
0
        public List <LABORDC> LoadByDailyIDAndType(int DAILY_ID, int DAILY_TYPE)
        {
            DBConnection   objConnection   = new DBConnection();
            LABORDA        objLABOR_VALUDA = new LABORDA();
            List <LABORDC> objLABOR_VALUDC = null;

            try
            {
                objConnection.Open(false);
                objLABOR_VALUDC = objLABOR_VALUDA.LoadByDailyIDAndType(objConnection, DAILY_ID, DAILY_TYPE);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objLABOR_VALUDC);
        }
Beispiel #5
0
        public LABORDC LoadByPrimaryKey(int LABOR_VALUE_ID)
        {
            DBConnection objConnection   = new DBConnection();
            LABORDA      objLABOR_VALUDA = new LABORDA();
            LABORDC      objLABOR_VALUDC = null;

            try
            {
                objConnection.Open(false);
                objLABOR_VALUDC = objLABOR_VALUDA.LoadByPrimaryKey(objConnection, LABOR_VALUE_ID);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objLABOR_VALUDC);
        }
Beispiel #6
0
        public List <LABORDC> LoadAll()
        {
            DBConnection   objConnection   = new DBConnection();
            LABORDA        objLABOR_VALUDA = new LABORDA();
            List <LABORDC> objLABOR_VALUDC = null;

            try
            {
                objConnection.Open(false);
                objLABOR_VALUDC = objLABOR_VALUDA.LoadAll(objConnection);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(objLABOR_VALUDC);
        }
Beispiel #7
0
        public int Delete(List <LABORDC> objLABOR_VALUs)
        {
            int          deletedCount    = 0;
            DBConnection objConnection   = new DBConnection();
            LABORDA      objLABOR_VALUDA = new LABORDA();

            try
            {
                objConnection.Open(true);
                deletedCount = objLABOR_VALUDA.Delete(objConnection, objLABOR_VALUs);
                objConnection.Commit();
            }
            catch (Exception ex)
            {
                objConnection.Rollback();
                throw ex;
            }
            finally
            {
                objConnection.Close();
            }
            return(deletedCount);
        }