public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CRpt_InvoiceCustomer rpt = new CRpt_InvoiceCustomer();
rpt.Site = this.Site;
return(rpt);
}
void UpdateReport()
{
CRpt_InvoiceCustomer theReportDocument = new CRpt_InvoiceCustomer();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["InvoiceDate"]).Text = INVOICE_DATE.ToShortDateString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["CurrentDate"]).Text = DateTime.Now.ToShortDateString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["CustomerName"]).Text = CUSTOMER_NAME;
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["CustomerPhone"]).Text = CUSTOMER_PHONE;
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["CustomerAddress"]).Text = REGION_NAME + ", " + STREET_NAME + ", " + BUILDING_NAME;
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["CustomerFloor"]).Text = FLOOR.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["CustomerID"]).Text = CUSTOMER_ID.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["CounterType"]).Text = AMPERE_VALUE.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["BoxID"]).Text = BOX_ID.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["BoxAddress"]).Text = BOX_NAME;
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["Month1"]).Text = getArabicMonth(int.Parse(DateTime.Today.AddMonths(-1).ToString("MM")));
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["Month2"]).Text = getArabicMonth(int.Parse(DateTime.Today.ToString("MM")));
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["Month1Usage"]).Text = PREVIOUS_USAGE.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["Month2Usage"]).Text = CURRENT_USAGE.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["CurrentUsage"]).Text = TOTAL_USAGE.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["PricePerKWatt"]).Text = VALUE_PER_KWATT.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["TotalPrice"]).Text = (TOTAL_USAGE * VALUE_PER_KWATT).ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["MonthlyCost"]).Text = MONTHYL_COST.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["NetTotal"]).Text = (MONTHYL_COST + (TOTAL_USAGE * VALUE_PER_KWATT)).ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["StaticCutHours"]).Text = CUT_HOURS.ToString();
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["StaticCompanyName"]).Text = COMPANY_NAME;
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["StaticPhone1"]).Text = PHONE1;
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["StaticPhone2"]).Text = PHONE2;
((CrystalDecisions.CrystalReports.Engine.TextObject)theReportDocument.Section3.ReportObjects["StaticPhone3"]).Text = PHONE3;
CRptV_Invoice.ReportSource = theReportDocument;
CRptV_Invoice.RefreshReport();
}
void Main_OnLoad(object sender, EventArgs e)
{
OpenConnection();
rpt = new CRpt_InvoiceCustomer();
rpt.DataSourceConnections[0].SetConnection(getDBFile(), "", "Admin", "");
//((CrystalDecisions.CrystalReports.Engine.TextObject)rpt.Section3.ReportObjects["Customer_Name"]).Text = "Some Really Long Customer Name";
rpt.Refresh();
//DataBackup();
}
