public void PreviewGetTravelExpenseReport(int budID, string wbs, bool rate) //***********************Added 7/22/2015 //*******************************I have to work on it
{
FPreviewAR pv = new FPreviewAR();
//rprtBudgetSummary1 rprt = new rprtBudgetSummary1();
rprtTravelExpenseDetail rprt = new rprtTravelExpenseDetail();
DataSet ds;
//int totalHours;
//decimal totalHourDollars;
//decimal totalExpenses;
//decimal contingency;
CBBudget bud = new CBBudget();
CBProject proj = new CBProject();
CBCustomer cust = new CBCustomer();
CBLocation loc = new CBLocation();
CBState state = new CBState();
bud.Load(budID);
proj.Load(bud.ProjectID);
cust.Load(proj.CustomerID);
loc.Load(proj.LocationID);
state.Load(loc.StateID);
//totalHours = CBBudget.GetTotalBudgetHours(budID, wbs);
//totalHourDollars = CBBudget.GetTotalBudgetHourDollars(budID, wbs);
//totalExpenses = CBBudget.GetTotalBudgetExpenses(budID);
//contingency = CBBudget.GetContingencyForBudget(budID);
ds = CBBudget.GetTravelExpenseReport(budID);
// ds = CBBudget.GetBudgetDetailsForReport(budID, wbs);
if (proj.BusinessUnit() == 1)
{
rprt.MainReportTitle = "Staffing Estimate Travel Expense Report";
}
if (proj.BusinessUnit() == 2)
{
rprt.MainReportTitle = "Engineering Estimate Travel Expense Report";
}
if (proj.BusinessUnit() == 3)
{
rprt.MainReportTitle = "Pipeline Services Estimate Travel Expense Report";
}
if (proj.BusinessUnit() == 4)
{
rprt.MainReportTitle = "Program Management Estimate Travel Expense Report";
}
if (proj.BusinessUnit() == 5)
{
rprt.MainReportTitle = "EPC Estimate Travel Expense Report";
}
rprt.SetTitles(proj.Number, proj.Description, bud.GetNumber(), cust.Name, loc.City + "," + state.Abbrev, wbs);
//rprt.TotalHours = totalHours;
//rprt.TotalHourDollars = totalHourDollars;
//rprt.TotalExpenses = totalExpenses;
// rprt.Contingency = contingency;
// rprt.Rate = rate;
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv.projNumber = proj.Number; // **************************Added 6/29/2015 **************************
pv.ViewReport(rprt);
pv.ShowDialog();
}