private void projectForecastingReportPipelinesToolStripMenuItem_Click(object sender, EventArgs e) //***********************Added 12/8
{
RSMPS.FCRMain crm = new FCRMain();
crm.IsForPipeline = true;
crm.ShowDialog();
}
private void PrintSelectedProjects(string printer)
{
string proj;
int prntCnt;
int indx = 0;
int copy = 1;
prntCnt = clstProjects.CheckedItems.Count;
lblStatus.Visible = true;
lblStatus.Text = "Printing";
copy = Convert.ToInt32(numPrint.Value);
progressBar1.Minimum = 0;
progressBar1.Maximum = copy;
progressBar1.Value = 0;
Application.DoEvents();
object o;
for (int i = 0; i < copy; i++)
{
for (int j = clstProjects.CheckedItems.Count; j > 0; j--)
{
o = clstProjects.CheckedItems[j - 1];
proj = o.ToString();
indx++;
lblStatus.Text = "Printing - " + proj;
progressBar1.Value = i;
Application.DoEvents();
LoadReportforBatchPrint(proj, FCRMain.GetRprtCase(proj), printer, 1);
}
// roll up forecast
for (int j = chkRollups.CheckedItems.Count; j > 0; j--)
{
o = chkRollups.CheckedItems[j - 1];
proj = o.ToString();
indx++;
lblStatus.Text = "Printing - " + proj;
Application.DoEvents();
LoadReportRollupforBatchPrint(proj, FCRMain.GetRprtCase(proj), printer, 1);
}
}
this.Close();
}
private void LoadReportsForPDF(string pdfLoc)
{
string proj;
this.Cursor = Cursors.WaitCursor;
GrapeCity.ActiveReports.SectionReport rprtMain = new GrapeCity.ActiveReports.SectionReport();
GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport pdfOut;
lblStatus.Text = "Saving - ";
Application.DoEvents();
GrapeCity.ActiveReports.Document.Section.PagesCollection pagesForecast;
SqlDataReader dr;
dr = GetListbyBillType(BillID);
while (dr.Read())
{
proj = dr["number"].ToString();
lblStatus.Text = "Saving - " + proj;
Application.DoEvents();
pagesForecast = CreatePagesForecast(proj, FCRMain.GetRprtCase(proj));
for (int k = 0; k < pagesForecast.Count; k++)
{
rprtMain.Document.Pages.Add(pagesForecast[k]);
}
}
pdfOut = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport();
pdfOut.Export(rprtMain.Document, pdfLoc);
this.Cursor = Cursors.Default;
MessageBox.Show("Reports created");
this.Close();
}
private void PrintSelectedProjects(string printer, int billType)
{
string proj;
// MessageBox.Show(printer + "selected");
SqlDataReader dr;
lblStatus.Text = "Printing - ";
Application.DoEvents();
dr = GetListbyBillType(billType);
while (dr.Read())
{
proj = dr["number"].ToString();
lblStatus.Text = "Printing - " + proj;
Application.DoEvents();
LoadReportforBatchPrint(proj, FCRMain.GetRprtCase(proj), printer, 1);
}
this.Close();
}
private GrapeCity.ActiveReports.Document.Section.PagesCollection CreatePagesForecastForRollup(string project)
{
string currDate;
this.Cursor = Cursors.WaitCursor;
currDate = DateTime.Now.ToShortDateString();
DSForecastRprt rprtDs;
CRolllups ru = new CRolllups();
rprtDs = ru.LoadReportForProjectRollup(project, FCRMain.GetRprtCase(project));
rprtCostReport1 rprt = new rprtCostReport1();
rprt.CutoffDate = currDate;
rprt.IsRollup = true;
rprt.DataSource = rprtDs;
rprt.DataMember = "EngrInfo";
rprt.Run(false);
return(rprt.Document.Pages);
}
private void projectForecastingToolStripMenuItem_Click(object sender, EventArgs e)
{
RSMPS.FCRMain crm = new FCRMain();
crm.ShowDialog();
}
private void costReportsToolStripMenuItem_Click(object sender, EventArgs e)
{
RSMPS.FCRMain crm = new FCRMain();
crm.ShowDialog();
}
public bool UseNewCodes(string project)
{
return(FCRMain.UseNewCodes(project));
}
private void bttUpdate_Click(object sender, EventArgs e)
{
RevSol.RSConnection cnn;
SqlCommand cmd;
SqlParameter prm;
int forecastID;
int specGrp = 0;
CBProject proj = new CBProject();
proj.Load(msCurrProj);
cnn = new RevSol.RSConnection("CR");
cmd = new SqlCommand("spForecastUpdate_Insert", cnn.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
prm = cmd.Parameters.Add("@ForecastID", SqlDbType.Int);
prm.Direction = ParameterDirection.Output;
prm = cmd.Parameters.Add("@Project", SqlDbType.VarChar, 50);
prm.Value = msCurrProj;
cmd.ExecuteNonQuery();
forecastID = Convert.ToInt32(cmd.Parameters["@ForecastID"].Value);
specGrp = 0;
if (proj.UseAllGroups() == true)
{
specGrp = 0;
}
string acct;
decimal hrs, amnt;
foreach (DataRow dr in mdsForecast.Tables["Forecast"].Rows)
{
acct = dr["AcctGroup"].ToString();
hrs = Convert.ToDecimal(dr["FTCHrs"]);
amnt = Convert.ToDecimal(dr["FTCRate"]);
cmd = new SqlCommand("spForecastToComplete_Insert2_Vision", cnn.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
prm = cmd.Parameters.Add("@ForecastID", SqlDbType.Int);
prm.Value = forecastID;
prm = cmd.Parameters.Add("@AccountGroup", SqlDbType.VarChar, 50);
prm.Value = acct.Replace("E", "");
prm = cmd.Parameters.Add("@ForecastHrs", SqlDbType.Money);
prm.Value = hrs;
prm = cmd.Parameters.Add("@ForecastRate", SqlDbType.Money);
prm.Value = amnt;
prm = cmd.Parameters.Add("@SpecialGroup", SqlDbType.Int);
prm.Value = specGrp;
cmd.ExecuteNonQuery();
}
cnn.CloseConnection();
LoadCurrentGroups();
bttUpdate.Enabled = false;
bttSetForecast.Enabled = false;
LoadReportForProject(FCRMain.GetRprtCase(msCurrProj));
}
private void LoadReportsForPDF(string pdfLoc)
{
string proj;
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;
prntCnt = clstProjects.CheckedItems.Count;
lblStatus.Visible = true;
// lblStatus.Text = "Printing";
lblStatus.Text = "Saving"; //*******************Edited 12/10
copy = Convert.ToInt32(numPrint.Value);
Application.DoEvents();
GrapeCity.ActiveReports.Document.Section.PagesCollection pagesForecast;
for (int j = clstProjects.CheckedItems.Count; j > 0; j--)
{
o = clstProjects.CheckedItems[j - 1];
proj = o.ToString();
indx++;
// lblStatus.Text = "Printing - " + proj;
lblStatus.Text = "Saving - " + proj; //*******************Edited 12/10
Application.DoEvents();
pagesForecast = CreatePagesForecast(proj, FCRMain.GetRprtCase(proj));
for (int k = 0; k < pagesForecast.Count; k++)
{
rprtMain.Document.Pages.Add(pagesForecast[k]);
}
}
for (int j = chkRollups.CheckedItems.Count; j > 0; j--)
{
o = chkRollups.CheckedItems[j - 1];
proj = o.ToString();
indx++;
// lblStatus.Text = "Printing - " + proj;
lblStatus.Text = "Saving - " + proj; //*******************Edited 12/10
Application.DoEvents();
pagesForecast = CreatePagesForecastForRollup(proj);
for (int k = 0; k < pagesForecast.Count; k++)
{
rprtMain.Document.Pages.Add(pagesForecast[k]);
}
}
pdfOut = new GrapeCity.ActiveReports.Export.Pdf.Section.PdfExport();
pdfOut.Export(rprtMain.Document, pdfLoc);
this.Cursor = Cursors.Default;
MessageBox.Show("Reports created");
}
