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());
}