Esempio n. 1
0
        public void Load(int iID)
        {
            CDbProjectEmployee dbDt = new CDbProjectEmployee();
            string             tmpDat;

            tmpDat = dbDt.GetByID(iID);

            Clear();
            if (tmpDat.Length > 0)
            {
                LoadVals(tmpDat);
            }

            dbDt = null;
        }
Esempio n. 2
0
        public int Save()
        {
            CDbProjectEmployee dbDt = new CDbProjectEmployee();
            string             tmpDat;
            int retVal;

            tmpDat = GetDataString();

            if (base.ID > 0)
            {
                dbDt.SavePrev(tmpDat);
                retVal = base.ID;
            }
            else
            {
                retVal  = dbDt.SaveNew(tmpDat);
                base.ID = retVal;
            }

            dbDt = null;

            return(retVal);
        }
Esempio n. 3
0
        public static void Delete(int projID, int empID, int deptID)
        {
            CDbProjectEmployee dbDt = new CDbProjectEmployee();

            dbDt.Delete(projID, empID, deptID);
        }
Esempio n. 4
0
        public static void Delete(int cID)
        {
            CDbProjectEmployee dbDt = new CDbProjectEmployee();

            dbDt.Delete(cID);
        }
Esempio n. 5
0
        public static void Swap(int projID, int empID, int deptID, int newID)
        {
            CDbProjectEmployee dbDt = new CDbProjectEmployee();

            dbDt.Swap(projID, empID, deptID, newID);
        }
Esempio n. 6
0
        public static SqlDataReader GetListActiveWithHoursAllDept(DateTime startDate, DateTime endDate)
        {
            CDbProjectEmployee dbDt = new CDbProjectEmployee();

            return(dbDt.GetListActiveWithHoursAllDept(startDate, endDate));
        }
Esempio n. 7
0
        public static SqlDataReader GetListActiveWithHoursProject(int Proj_ID, DateTime startDate, DateTime endDate)
        {
            CDbProjectEmployee dbDt = new CDbProjectEmployee();

            return(dbDt.GetListActiveWithHoursProject(Proj_ID, startDate, endDate));
        }
Esempio n. 8
0
        public static SqlDataReader GetListActive()
        {
            CDbProjectEmployee dbDt = new CDbProjectEmployee();

            return(dbDt.GetListActive());
        }