public static string GetNextPCINumber(int deptID, int projID)
{
CDbPCIInfo dbDt = new CDbPCIInfo();
CBDepartment dept = new CBDepartment();
string nextNum = "";
int pciCnt;
dept.Load(deptID);
pciCnt = dbDt.GetCountByProjectID(projID) + 1;
//nextNum = dept.Name.Substring(0,1).ToUpper() + pciCnt.ToString("00");
nextNum = pciCnt.ToString("00"); // only use number per Mike 061608
return(nextNum);
}
public void Load(int iID)
{
CDbPCIInfo dbDt = new CDbPCIInfo();
string tmpDat;
tmpDat = dbDt.GetByID(iID);
Clear();
if (tmpDat.Length > 0)
{
LoadVals(tmpDat);
}
dbDt = null;
}
public int Save()
{
CDbPCIInfo dbDt = new CDbPCIInfo();
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 iID)
{
CDbPCIInfo dbDt = new CDbPCIInfo();
dbDt.Delete(iID);
}
public static void SetPCIComments(int pciID, string comments)
{
CDbPCIInfo db = new CDbPCIInfo();
db.SetPCIComments(pciID, comments);
}
public static void GetPCILogTotalByProjID(int projID, ref int hours, ref decimal estTIC)
{
CDbPCIInfo db = new CDbPCIInfo();
db.GetPCILogTotalByProjID(projID, ref hours, ref estTIC);
}
public static DataSet GetPCILogByProjID(int projID)
{
CDbPCIInfo dbDt = new CDbPCIInfo();
return(dbDt.GetPCILogByProjID(projID));
}
public static void CreatePCNFromPCI(int projID, int pciID)
{
CDbPCIInfo dbDt = new CDbPCIInfo();
dbDt.CreatePCNFromPCI(projID, pciID);
}
public static void SetLockOnPCI(int pciID, bool lockState)
{
CDbPCIInfo dbDt = new CDbPCIInfo();
dbDt.SetLockOnPCI(pciID, lockState);
}
public static SqlDataReader GetListByProjDept(int projID, int deptID)
{
CDbPCIInfo dbDt = new CDbPCIInfo();
return(dbDt.GetListByProjDept(projID, deptID));
}
public static SqlDataReader GetListByProjAllDepts(int projID)
{
CDbPCIInfo dbDt = new CDbPCIInfo();
return(dbDt.GetListByProjAllDepts(projID));
}
public static SqlDataReader GetList()
{
CDbPCIInfo dbDt = new CDbPCIInfo();
return(dbDt.GetList());
}