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