public void Load(int iID) { CDbProjectEmployee dbDt = new CDbProjectEmployee(); string tmpDat; tmpDat = dbDt.GetByID(iID); Clear(); if (tmpDat.Length > 0) { LoadVals(tmpDat); } dbDt = null; }
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); }
public static void Delete(int projID, int empID, int deptID) { CDbProjectEmployee dbDt = new CDbProjectEmployee(); dbDt.Delete(projID, empID, deptID); }
public static void Delete(int cID) { CDbProjectEmployee dbDt = new CDbProjectEmployee(); dbDt.Delete(cID); }
public static void Swap(int projID, int empID, int deptID, int newID) { CDbProjectEmployee dbDt = new CDbProjectEmployee(); dbDt.Swap(projID, empID, deptID, newID); }
public static SqlDataReader GetListActiveWithHoursAllDept(DateTime startDate, DateTime endDate) { CDbProjectEmployee dbDt = new CDbProjectEmployee(); return(dbDt.GetListActiveWithHoursAllDept(startDate, endDate)); }
public static SqlDataReader GetListActiveWithHoursProject(int Proj_ID, DateTime startDate, DateTime endDate) { CDbProjectEmployee dbDt = new CDbProjectEmployee(); return(dbDt.GetListActiveWithHoursProject(Proj_ID, startDate, endDate)); }
public static SqlDataReader GetListActive() { CDbProjectEmployee dbDt = new CDbProjectEmployee(); return(dbDt.GetListActive()); }