public void PrintJobStatList(int deptID, bool isPreview, int sortCode)
{
FPreviewAR pv;
rprtJobStat1 rprt = new rprtJobStat1();
DataSet ds;
ds = CBDrawingLog.GetJobStatListByDeptID(deptID, sortCode);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv = new FPreviewAR(); //************** Done 6/29/15
pv.ViewReport(rprt);
if (isPreview == true)
{
//pv = new FPreviewAR();
//pv.ViewReport(rprt);
pv.ShowDialog();
}
else
{
rprt.Run();
rprt.Document.Print(true, false);
}
}
public void PrintJobStat(int deptID, int projID)
{
//FPreview pv;
//rprtJobStat rprt = new rprtJobStat();
//DataSet ds;
//ds = CBDrawingLog.GetJobStatForRprt(deptID, projID);
//rprt = new rprtJobStat();
//rprt.SetDataSource(ds);
//pv = new FPreview();
//pv.ShowReport(rprt);
//pv.ShowDialog();
////rprt.PrintToPrinter(1, false, 0, 0);
FPreviewAR pv;
rprtJobStat1 rprt = new rprtJobStat1();
DataSet ds;
ds = CBDrawingLog.GetJobStatForRprt(deptID, projID);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv = new FPreviewAR();
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PrintDrawingLogList(string deptXml, string leadXml, bool isLead, bool isPreview, int sortCode, int drwgSpec)
{
FPreviewAR pv;
rprtDrawingLogTranAlt2 rprt = new rprtDrawingLogTranAlt2();
dsDrawingLog dl;
dl = CBDrawingLog.GetDrawingLogMainByLeadList(deptXml, leadXml, sortCode, drwgSpec);
string name_of_Method = "GetDrawingLogMainByLeadList"; //**************************Added 10/3/2015
rprt.DataSource = dl;
rprt.DataMember = "DrawingList";
rprt.SetTitle = GetDrawingSpecTitle(drwgSpec);
pv = new FPreviewAR(); //************** Done 6/29/15
pv.name_of_Method = name_of_Method;
pv.leadXml = leadXml;
pv.deptXml = deptXml;
pv.sortCode = sortCode;
pv.drwgSpec = drwgSpec;
pv.Title = rprt.SetTitle; //********************************12/01
pv.ViewDrawingLogWithExcel(rprt);
if (isPreview == true)
{
//pv = new FPreviewAR();
//pv.ViewDrawingLogWithExcel(rprt);
pv.ShowDialog();
}
else
{
rprt.Run();
rprt.Document.Print(true, false);
}
}
public void PrintJobStatList(string deptXml, string leadXml, bool isLead, bool isPreview, int sortCode)
{
FPreviewAR pv;
rprtJobStat1 rprt = new rprtJobStat1();
DataSet ds;
ds = CBDrawingLog.GetJobStatListByLeadList(deptXml, leadXml, sortCode);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv = new FPreviewAR(); //************** Done 6/29/15
pv.Title = "DRAWING/SPEC LOG"; //********************************12/01
pv.ViewReport(rprt);
if (isPreview == true)
{
//pv = new FPreviewAR();
//pv.ViewReport(rprt);
pv.ShowDialog();
}
else
{
rprt.Run();
rprt.Document.Print(true, false);
}
}
public void PreviewBudgetFormEntry(int budID, string wbs)
{
FPreviewAR pv = new FPreviewAR();
rprtBudgetAccounting rprt = new rprtBudgetAccounting();
DataSet ds;
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);
ds = CBBudget.GetBudgetAccountingEntryForReport(budID, wbs);
rprt.SetTitles(cust.Name + " / " + loc.City + "," + state.Abbrev, proj.Description, proj.Number, bud.GetNumber(), wbs);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv.projNumber = proj.Number; //*************************Added 6/29/15
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PrintDrawingLogList(string deptXml, string leadXml, bool isLead, bool isPreview, int sortCode)
{
FPreviewAR pv;
//rprtDrawingLog1 rprt = new rprtDrawingLog1();
rprtDrawingLogTranAlt2 rprt = new rprtDrawingLogTranAlt2();
dsDrawingLog dl;
dl = CBDrawingLog.GetDrawingLogMainByLeadList(deptXml, leadXml, sortCode, 0);
rprt.SetDrawingLogAsCustomerReport();
rprt.DataSource = dl;
rprt.DataMember = "DrawingList";
pv = new FPreviewAR(); //************** Done 6/29/15
pv.Title = "DRAWING/SPEC LOG"; //********************************12/01
pv.ViewReport(rprt);
if (isPreview == true)
{
//pv = new FPreviewAR();
//pv.ViewReport(rprt);
pv.ShowDialog();
}
else
{
rprt.Run();
rprt.Document.Print(true, false);
}
}
public void PrintJobStatList(int deptID, bool isPreview, int sortCode)
{
FPreviewAR pv;
rprtJobStat1 rprt = new rprtJobStat1();
DataSet ds;
ds = CBDrawingLog.GetJobStatListByDeptID(deptID, sortCode);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv = new FPreviewAR();
pv.ViewReport(rprt);
if (isPreview == true)
{
//pv = new FPreviewAR(); //****Took these out of If Block, so that, ViewReport() is called, and reportType is available for Save file name
//pv.ViewReport(rprt); //************** Done 6/29/15
pv.ShowDialog();
}
else
{
rprt.Run();
rprt.Document.Print(true, false);
}
}
public void PrintForecastRemainingNew(int ENGPLSPM)
{
rprtForecastRemaining r = new rprtForecastRemaining();
FPreviewAR pv = new FPreviewAR();
//if (usePipe == true)
// r.SetAsPipeline();
if (ENGPLSPM == 1) //********************Added 9/30/2015
{
pv.Title = r.SetAsEngineering();
}
if (ENGPLSPM == 3)
{
pv.Title = r.SetAsPM();
}
DataSet ds = CBProjectSummary.GetForecastRemainingNew(ENGPLSPM);
r.DataSource = ds;
r.DataMember = "Table";
pv.ViewReportWithExcel(r);
pv.ShowDialog();
}
public void PrintDrawingLog(int deptID, int projID)
{
//FPreview pv;
////rprtDrawingLog rprt = new rprtDrawingLog();
//rprtDrawingLog_Alt rprt = new rprtDrawingLog_Alt();
//dsDrawingLog ds;
//ds = CBDrawingLog.GetDrawingLogForRprt(deptID, projID);
////rprt = new rprtDrawingLog();
//rprt = new rprtDrawingLog_Alt();
//rprt.SetDataSource(ds);
//pv = new FPreview();
//pv.ShowReport(rprt);
//pv.ShowDialog();
////rprt.PrintToPrinter(1, false, 0, 0);
FPreviewAR pv;
rprtDrawingLog1 rprt = new rprtDrawingLog1();
dsDrawingLog ds;
ds = CBDrawingLog.GetDrawingLogForRprt(deptID, projID);
rprt.SetDrawingLogAsCustomerReport();
rprt.DataSource = ds;
rprt.DataMember = "DrawingList";
pv = new FPreviewAR();
pv.Title = "DRAWING/SPEC LOG"; //********************************12/01
pv.ViewReport(rprt);
pv.ShowDialog();
}
public static void ShowTestIssuance(DataSet ds)
{
rprtIssuance1 r = new rprtIssuance1();
FPreviewAR pvar = new FPreviewAR();
r.DataSource = ds;
r.DataMember = "Table";
pvar.ViewReport(r);
pvar.ShowDialog();
}
public void PreviewBudgetDetails(int budID, string wbs)
{
FPreviewAR pv = new FPreviewAR();
rprtBudgetDetail rprt = new rprtBudgetDetail();
DataSet ds;
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);
ds = CBBudget.GetBudgetDetailsForReport(budID, wbs);
if (proj.BusinessUnit() == 1)
{
rprt.MainReportTitle = "Staffing Estimate Loaded Details";
}
if (proj.BusinessUnit() == 2)
{
rprt.MainReportTitle = "Engineering Estimate Loaded Details";
}
if (proj.BusinessUnit() == 3)
{
rprt.MainReportTitle = "Pipeline Services Estimate Loaded Details";
}
if (proj.BusinessUnit() == 4)
{
rprt.MainReportTitle = "Program Management Estimate Loaded Details";
}
if (proj.BusinessUnit() == 5)
{
rprt.MainReportTitle = "EPC Estimate Loaded Details";
}
pv.projNumber = proj.Number; //***************************Added 6/25/15
// MessageBox.Show(pv.projNumber);
rprt.SetTitles(cust.Name + " / " + loc.City + "," + state.Abbrev, proj.Description, proj.Number, bud.GetNumber(), wbs);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv.Title = rprt.MainReportTitle; //************************Added 10/1/2015
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PreviewSummary(SummaryInfo si, RowsInfo ri)
{
rprtCostSummary rprt = new rprtCostSummary();
FPreviewAR pv = new FPreviewAR();
rprt.SummaryInformation = si;
rprt.RowsInfo = ri;
rprt.Run();
pv.projNumber = si.project; //*******************************Added 9/30/2015
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PrintVariance(DataSet ds, string title)
{
rprtJobVariance1 r = new rprtJobVariance1();
r.Title.Text = title;
FPreviewAR pv = new FPreviewAR();
r.DataSource = ds;
r.DataMember = "Table";
pv.ViewReport(r);
pv.Title = title; //*****************************Added 10/1/2015
pv.ShowDialog();
}
public void PreviewPCNLog(string client, string project, string hgaNum, string clientNum, string pm, DataSet pcnLog)
{
FPreviewAR pv = new FPreviewAR();
rprtPCNLog rprt = new rprtPCNLog();
rprt.SetHeaderInfo(client, project, hgaNum, clientNum, pm);
rprt.DataSource = pcnLog;
rprt.DataMember = "Table";
pv.projNumber = hgaNum; //******************************Added 6/29/15
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PreviewPCI(int pciID)
{
FPreviewAR pv = new FPreviewAR();
rprtPCIInformation rprt = new rprtPCIInformation();
CBPCIInfo info = new CBPCIInfo();
info.Load(pciID);
rprt.SetInformation(info);
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PrintDrawingLog(int deptID, int projID)
{
FPreviewAR pv;
rprtDrawingLogTranAlt2 rprt = new rprtDrawingLogTranAlt2();
dsDrawingLog ds;
ds = CBDrawingLog.GetDrawingLogForRprt(deptID, projID);
rprt.DataSource = ds;
rprt.DataMember = "DrawingList";
pv = new FPreviewAR();
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PrintForecastRemainingBHam()
{
rprtForecastRemaining r = new rprtForecastRemaining();
FPreviewAR pv = new FPreviewAR();
pv.Title = r.SetAsBHam();
DataSet ds = CBProjectSummary.GetForecastRemainingBHam();
r.DataSource = ds;
r.DataMember = "Table";
pv.ViewReportWithExcel(r);
pv.ShowDialog();
}
public void PrintJobStat(int deptID, int projID)
{
FPreviewAR pv;
rprtJobStat1 rprt = new rprtJobStat1();
DataSet ds;
ds = CBDrawingLog.GetJobStatForRprt(deptID, projID);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv = new FPreviewAR();
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void TestPM()
{
rprtPMReport1 r = new rprtPMReport1();
FPreviewAR pv = new FPreviewAR();
CBEmployee e = new CBEmployee();
e.Load(25);
DataSet ds = CBProjectSummary.GetPMReport(25);
r.ProjectManager = e.Name;
r.DataSource = ds;
r.DataMember = "Table";
pv.ViewReport(r);
pv.ShowDialog();
}
public void LoadReportsForPDF_ForAllPCN(string projNumber, int projID)
{
FPreviewAR pv = new FPreviewAR();
string pcnNumber;
int pcnID;
int prntCnt;
int indx = 0;
int copy = 1;
object o;
// this.Cursor = Cursors.WaitCursor;
GrapeCity.ActiveReports.SectionReport rprtMain = new GrapeCity.ActiveReports.SectionReport();
GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport pdfOut;
lblStatus.Visible = true;
lblStatus.Text = "Saving"; //*******************Edited 12/10
Application.DoEvents();
GrapeCity.ActiveReports.Document.Section.PagesCollection pagesPCN;
for (int j = 0; j < clstProjects.CheckedItems.Count; j++)
{
o = clstProjects.CheckedItems[j];
pcnNumber = o.ToString().Substring(0, 2);
pcnID = GetPCNID_From_PCNNumber(pcnNumber, projID);
indx++;
lblStatus.Text = "Saving - " + pcnNumber;
Application.DoEvents();
pagesPCN = CreatePagesPCN(projNumber, pcnNumber, pcnID);
for (int k = 0; k < pagesPCN.Count; k++)
{
rprtMain.Document.Pages.Add(pagesPCN[k]);
}
}
this.Close();
pv.projNumber = projNumber;
pv.ViewReportBatch(rprtMain);
pv.ShowDialog();
}
public void PrintForecastRemaining(bool usePipe)
{
rprtForecastRemaining r = new rprtForecastRemaining();
FPreviewAR pv = new FPreviewAR();
if (usePipe == true)
{
r.SetAsPipeline();
}
DataSet ds = CBProjectSummary.GetForecastRemaining(usePipe);
r.DataSource = ds;
r.DataMember = "Table";
pv.Title = "Pipeline Forecast Remaining Report"; //********************Added 9/30/2015
pv.ViewReportWithExcel(r);
pv.ShowDialog();
}
public void PreviewPCN(int pcnID)
{
FPreviewAR pv = new FPreviewAR();
rprtPCNMain rprt = new rprtPCNMain();
DataSet ds;
CBBudgetPCN pcn = new CBBudgetPCN();
ds = CBBudgetPCN.GetBudgetPCNInfoForReport(pcnID);
pcn.Load(pcnID);
rprt.SetInformation(pcn);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv.Title = pcn.PCNTitle; //************************Added 10/1/2015
//rprt.Run();
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PreviewAllBudget_New(int budID, string projNumber, string wbs) //*********************************Added 6/29
{
FPreviewAR pv = new FPreviewAR();
GrapeCity.ActiveReports.SectionReport rprtMain = new GrapeCity.ActiveReports.SectionReport();
GrapeCity.ActiveReports.Document.Section.PagesCollection pagesBudSum;
GrapeCity.ActiveReports.Document.Section.PagesCollection pagesBudDtl;
GrapeCity.ActiveReports.Document.Section.PagesCollection pagesJobStat;
GrapeCity.ActiveReports.Document.Section.PagesCollection pagesBudEntry;
pagesBudSum = CreatePagesBudgetSummary(budID, wbs);
for (int i = 0; i < pagesBudSum.Count; i++)
{
rprtMain.Document.Pages.Add(pagesBudSum[i]);
}
pagesBudDtl = CreatePagesBudgetDetails(budID, wbs);
for (int i = 0; i < pagesBudDtl.Count; i++)
{
rprtMain.Document.Pages.Add(pagesBudDtl[i]);
}
pagesJobStat = CreatePagesJobStat(budID, wbs);
for (int i = 0; i < pagesJobStat.Count; i++)
{
rprtMain.Document.Pages.Add(pagesJobStat[i]);
}
pagesBudEntry = CreatePagesBudgetFormEntry(budID, wbs);
for (int i = 0; i < pagesBudEntry.Count; i++)
{
rprtMain.Document.Pages.Add(pagesBudEntry[i]);
}
pv.projNumber = projNumber; //************************Added 6/29
pv.ViewReportNoRun(rprtMain);
pv.ShowDialog();
}
public static void PrintTransmittal(int transmittalID)
{
rprtTransmittal1 rprt = new rprtTransmittal1();
DataSet ds;
FPreviewAR pv = new FPreviewAR();
CBProject proj = new CBProject(); //***********************************Added 9/30/2015
CBTransmittal t = new CBTransmittal();
t.Load(transmittalID);
proj.Load(t.ProjectID);
pv.projNumber = proj.Number;
ds = CBTransmittal.GetTransmittalForReport(transmittalID);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv.ViewReport(rprt);
pv.ShowDialog();
}
public static void PrintTransmittalRelease(int releaseID)
{
rprtTransmittalRelease1 rprt = new rprtTransmittalRelease1();
DataSet ds;
FPreviewAR pv = new FPreviewAR();
CBProject proj = new CBProject(); //***********************************Added 9/30/2015
CBTransmittalRelease r = new CBTransmittalRelease();
r.Load(releaseID);
proj.Load(r.ProjectID);
pv.projNumber = proj.Number;
ds = CBTransmittalRelease.GetTransmittalReleaseForReport(releaseID);
rprt.DataSource = ds;
rprt.DataMember = "Table";
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PreviewPCI_New(string projNumber, int pciID) // *************************** Added 6/25/15
{
FPreviewAR pv = new FPreviewAR();
rprtPCIInformation rprt = new rprtPCIInformation();
CBPCIInfo info = new CBPCIInfo();
//CBBudget bud = new CBBudget();
//CBProject proj = new CBProject();
//bud.Load(budID);
//proj.Load(bud.ProjectID);
info.Load(pciID);
rprt.SetInformation(info);
pv.projNumber = projNumber;
// MessageBox.Show(pv.projNumber);
pv.ViewReport(rprt);
pv.ShowDialog();
}
public void PreviewBudgetSummary(int budID, string wbs, bool rate) //***********************Added 7/22/2015
{
FPreviewAR pv = new FPreviewAR();
rprtBudgetSummary1 rprt = new rprtBudgetSummary1();
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.GetBudgetSummaryForReport(budID, wbs);
//ds = CBBudget.GetBudgetSummaryForReport(budID, wbs);
if (proj.BusinessUnit() == 1)
{
rprt.MainReportTitle = "Staffing Estimate Loaded Summary";
}
if (proj.BusinessUnit() == 2)
{
rprt.MainReportTitle = "Engineering Estimate Loaded Summary";
}
if (proj.BusinessUnit() == 3)
{
rprt.MainReportTitle = "Pipeline Services Estimate Loaded Summary";
}
if (proj.BusinessUnit() == 4)
{
rprt.MainReportTitle = "Program Management Estimate Loaded Summary";
}
if (proj.BusinessUnit() == 5)
{
rprt.MainReportTitle = "EPC Estimate Loaded Summary";
}
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 **************************
if (rate == false) //************************Added 10/1/2015
{
pv.Title = rprt.MainReportTitle + "WO Rate";
}
else
{
pv.Title = rprt.MainReportTitle;
}
pv.ViewReport(rprt);
pv.ShowDialog();
}
