public static int GetNextRevision(int projID)
{
CDbBudget dbDt = new CDbBudget();
int lastRev = 0;
lastRev = dbDt.GetLastRevision(projID);
lastRev++;
return(lastRev);
}
public void Load(int iID)
{
CDbBudget dbDt = new CDbBudget();
string tmpDat;
tmpDat = dbDt.GetByID(iID);
Clear();
if (tmpDat.Length > 0)
{
LoadVals(tmpDat);
}
dbDt = null;
}
public int Save()
{
CDbBudget dbDt = new CDbBudget();
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 DataSet GetTravelExpenseReport(int budgetID)//*********************************Added 7/22/2015 //*******************************I will keep it
{
CDbBudget dbDt = new CDbBudget();
return(dbDt.GetTravelExpenseReport(budgetID));
}
public static void CreateBudgetInJobStat(int budID)
{
CDbBudget dbDt = new CDbBudget();
dbDt.CreateBudgetInJobStat(budID);
}
public static void CopyBudgetToProject(int budID, int newProjID, int rev)
{
CDbBudget dbDt = new CDbBudget();
dbDt.CopyBudgetToProject(budID, newProjID, rev);
}
public static DataSet GetBudgetJobstatForReport(int budgetID, string wbs)
{
CDbBudget dbDt = new CDbBudget();
return(dbDt.GetBudgetJobstatForReport(budgetID, wbs));
}
public static DataSet GetBudgetAccountingEntryForReport(int budgetID, string wbs)
{
CDbBudget dbDt = new CDbBudget();
return(dbDt.GetBudgetAccountingEntryForReport(budgetID, wbs));
}
public static decimal GetTotalBudgetExpenses(int budgetID)
{
CDbBudget dbDt = new CDbBudget();
return(dbDt.GetTotalBudgetExpenses(budgetID));
}
public static decimal GetContingencyForBudget(int budgetID)
{
CDbBudget dbDt = new CDbBudget();
return(dbDt.GetContingencyForBudget(budgetID));
}
public static void Delete(int cID)
{
CDbBudget dbDt = new CDbBudget();
dbDt.Delete(cID);
}
public static decimal GetTotalBudgetHourDollars(int budgetID, string wbs)
{
CDbBudget dbDt = new CDbBudget();
return(dbDt.GetTotalBudgetHourDollars(budgetID, wbs));
}
public static void MakeBudgetLockedUnlocked(int budID, bool isLocked)
{
CDbBudget dbDt = new CDbBudget();
dbDt.MakeBudgetLockedUnlocked(budID, isLocked);
}
public static void MakeBudgetDefault(int budID)
{
CDbBudget dbDt = new CDbBudget();
dbDt.MakeBudgetDefault(budID);
}
public static void MakeBudgetActive(int budID)
{
CDbBudget dbDt = new CDbBudget();
dbDt.MakeBudgetActive(budID);
}
public static SqlDataReader GetList()
{
CDbBudget dbDt = new CDbBudget();
return(dbDt.GetList());
}
public static SqlDataReader GetListByProject(int projID)
{
CDbBudget dbDt = new CDbBudget();
return(dbDt.GetListByProject(projID));
}