public string GetNextPCNNumber(int projID)
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
int currCount;
string newNum;
currCount = dbDt.GetCountByProject(projID);
currCount++;
newNum = Convert.ToDecimal(currCount).ToString("00");
return(newNum);
}
public void Load(int iID)
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
string tmpDat;
tmpDat = dbDt.GetByID(iID);
Clear();
if (tmpDat.Length > 0)
{
LoadVals(tmpDat);
}
dbDt = null;
}
public int InitialCopySave()
{
//Saves the new line it can now be edited
CDbBudgetPCN dbDt = new CDbBudgetPCN();
string tmpDat;
int retVal;
tmpDat = GetDataString();
retVal = dbDt.SaveNew(tmpDat);
base.ID = retVal;
dbDt = null;
return(retVal);
}
public int Save()
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
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 int GetBudgetsWithPCN(int pcnID)
{
CDbBudgetPCN db = new CDbBudgetPCN();
return(db.GetBudgetsWithPCN(pcnID));
}
public static void SetCurrentStatus(int pcnID, int statusID)
{
CDbBudgetPCN db = new CDbBudgetPCN();
db.SetCurrentStatus(pcnID, statusID);
}
public static void GetPCILogTotalByProjID(int projID, ref int hours, ref decimal estTIC, ref int mhAdd, ref decimal dlrAdd, ref decimal trend)
{
CDbBudgetPCN db = new CDbBudgetPCN();
db.GetPCILogTotalByProjID(projID, ref hours, ref estTIC, ref mhAdd, ref dlrAdd, ref trend);
}
public static void SetClientDate(int pcnID, DateTime clientSubmitted, DateTime clientReceived, string comments)
{
CDbBudgetPCN db = new CDbBudgetPCN();
db.SetClientDate(pcnID, clientSubmitted, clientReceived, comments);
}
public static DataSet GetPCNLogByProjID(int projID)
{
CDbBudgetPCN db = new CDbBudgetPCN();
return(db.GetPCNLogByProjID(projID));
}
public static DataSet GetBudgetPCNInfoForReport(int pcnID)
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
return(dbDt.GetBudgetPCNInfoForReport(pcnID));
}
public static SqlDataReader GetListByProject(int projID)
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
return(dbDt.GetListByProject(projID));
}
public static SqlDataReader GetList()
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
return(dbDt.GetList());
}
public void LoadWithData(int iID)
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
string tmpDat;
tmpDat = dbDt.GetByID(iID);
Clear();
if (tmpDat.Length > 0)
{
LoadVals(tmpDat);
}
dbDt = null;
base.PCNData = new dsPCN();
SqlDataReader dr;
DataRow d;
dr = CBBudgetPCNHour.GetListByPCN(iID);
while (dr.Read())
{
d = base.PCNData.Tables["PCNHours"].NewRow();
d["ID"] = dr["ID"];
d["PCNID"] = dr["PCNID"];
d["Code"] = dr["Code"];
d["WBS"] = dr["WBS"];
d["Description"] = dr["Description"];
d["Quantity"] = dr["Quantity"];
d["HoursPerItem"] = dr["HoursPerItem"];
d["Rate"] = dr["Rate"];
d["SubtotalHrs"] = dr["SubtotalHrs"];
d["SubtotalDlrs"] = dr["SubtotalDlrs"];
base.PCNData.Tables["PCNHours"].Rows.Add(d);
}
dr.Close();
dr = CBBudgetPCNExpense.GetListByPCN(iID);
while (dr.Read())
{
d = base.PCNData.Tables["PCNExpenses"].NewRow();
d["ID"] = dr["ID"];
d["PCNID"] = dr["PCNID"];
d["Code"] = dr["Code"];
d["Description"] = dr["Description"];
d["DeptGroup"] = dr["DeptGroup"]; //****************************Added 9/22/2015
d["DlrsPerItem"] = dr["DlrsPerItem"];
d["NumItems"] = dr["NumItems"];
d["MUPerc"] = dr["MUPerc"];
d["MarkUp"] = dr["MarkUp"];
d["TotalCost"] = dr["TotalCost"];
base.PCNData.Tables["PCNExpenses"].Rows.Add(d);
}
dr.Close();
}
public static void Delete(int iID)
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
dbDt.Delete(iID);
}
public static decimal TotalDollars(int pcnID)
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
return(dbDt.GetBudgetPCNDollars(pcnID));
}
public static int TotalHours(int pcnID)
{
CDbBudgetPCN dbDt = new CDbBudgetPCN();
return(dbDt.GetBudgetPCNHours(pcnID));
}
