private void btnBasicInventoryReport_Click(object sender, EventArgs e)
{
ReportViewerForm form = new ReportViewerForm();
form.rptviewer.LocalReport.ReportPath = "BasicInventory.rdlc";
form.SetInventoryReportDataSource();
form.rptviewer.Show();
form.Show();
form.rptviewer.RefreshReport();
form.rptviewer.LocalReport.Refresh();
}
private void btnPrintReport_Click(object sender, EventArgs e)
{
using (DealershipManagerEntities context = new DealershipManagerEntities())
{
try
{
context.ExecuteStoreCommand("DELETE FROM tmpCalculation");
}
catch
{
}
finally
{
context.SaveChanges();
}
int id = 0;
foreach (DataGridViewRow row in dgvLeaseInfo.Rows)
{
try
{
TmpCalculation tmp = new TmpCalculation();
tmp.id = id;
id++;
Double balance = 0;
Double.TryParse(row.Cells["Balance"].Value.ToString().Replace("$", ""), out balance);
tmp.Balance = balance;
double cost = 0;
Double.TryParse(txtCapitalizedCost.Text, out cost);
tmp.Cost = cost;
Double gst = 0;
Double.TryParse(row.Cells["GST"].Value.ToString().Replace("$", ""), out gst);
tmp.GST = gst;
Double interest = 0;
Double.TryParse(row.Cells["Interest"].Value.ToString().Replace("$", ""), out interest);
tmp.Interest = interest;
Double interestrate = 0;
Double.TryParse(txtInterestRate.Text, out interestrate);
tmp.InterestRate = interestrate;
int numberofmonths = 0;
int.TryParse(txtNumberOfMonths.Text, out numberofmonths);
tmp.Months = numberofmonths;
Double paymentAmount = 0;
Double.TryParse(row.Cells["Payment"].Value.ToString().Replace("$", ""), out paymentAmount);
tmp.PaymentAmount = paymentAmount;
int paymentno = 0;
int.TryParse(row.Cells["Payment No."].Value.ToString().Replace("$", ""), out paymentno);
tmp.PmtNo = paymentno;
Double principle = 0;
Double.TryParse(row.Cells["Principle"].Value.ToString().Replace("$", ""), out principle);
tmp.Principle = principle;
context.TmpCalculations.AddObject(tmp);
}
catch (Exception ex)
{
string test = ex.Message;
}
finally
{
context.SaveChanges();
}
}
}
ReportViewerForm form = new ReportViewerForm();
form.rptviewer.LocalReport.ReportPath = "TempCalculationReport.rdlc";
form.SetTempCalcReportDataSource();
form.rptviewer.Show();
form.Show();
form.rptviewer.RefreshReport();
form.rptviewer.LocalReport.Refresh();
//ReportViewerForm rptv = new ReportViewerForm();
//rptv.MdiParent = this.MdiParent;
//rptv.Show();
//rptv.rptviewer.LocalReport.Refresh();
//rptv.rptviewer.Refresh();
//rptv.rptviewer.RefreshReport();
//rptv.rptviewer.Visible = true;
}
private void btnCustomerCompleteFinanceReport_Click(object sender, EventArgs e)
{
using (DealershipManagerEntities context = new DealershipManagerEntities())
{
IQueryable <Customer> customerQuery = (from customer in context.Customers
join sale in context.Sales on customer.Id equals sale.CustomerId
where customer.BandName != "" && sale.current == true
orderby customer.LastName, customer.FirstName
select customer).Distinct().OrderBy(x => x.LastName).ThenBy(y => y.FirstName);
List <FinanceReportRow> rows = new List <FinanceReportRow>();
List <Customer> customers = customerQuery.ToList();
foreach (Customer c in customerQuery)
{
FinanceReportRow frr = new FinanceReportRow();
frr.First_Name = c.FirstName;
frr.Last_Name = c.LastName;
frr.Notes = "";
Finance financeQuery = (from finance in context.Finances
join sale in context.Sales on finance.saleId equals sale.id
join customer in customerQuery on sale.CustomerId equals customer.Id
where sale.CurrentBalance > 0 && sale.current == true && customer.Id == c.Id
orderby finance.DatePaid descending
select finance).FirstOrDefault();
if (financeQuery != null)
{
frr.Current_Balance = financeQuery.Balance ?? 0;
frr.Payment_Due = financeQuery.Payment ?? 0;
rows.Add(frr);
}
}
ReportViewerForm form = new ReportViewerForm();
form.rptviewer.LocalReport.ReportPath = "CompleteFinanceReport.rdlc";
form.rptviewer.LocalReport.DataSources[0].Value = rows;
form.rptviewer.LocalReport.DataSources[0].Name = "FinanceRows";
form.rptviewer.Show();
form.Show();
form.rptviewer.RefreshReport();
form.rptviewer.LocalReport.Refresh();
//dgvReport.Columns.Add("Last_Name", "Last Name");
//dgvReport.Columns["Last_Name"].DataPropertyName = "Last_Name";
//dgvReport.Columns.Add("First_Name", "First Name");
//dgvReport.Columns["First_Name"].DataPropertyName = "First_Name";
//dgvReport.Columns.Add("Current_Balance", "Current Balance");
//dgvReport.Columns["Current_Balance"].DataPropertyName = "Current_Balance";
//dgvReport.Columns["Current_Balance"].DefaultCellStyle.Format = "C";
//dgvReport.Columns.Add("Payment_Due", "Payment Due");
//dgvReport.Columns["Payment_Due"].DataPropertyName = "Payment_Due";
//dgvReport.Columns["Payment_Due"].DefaultCellStyle.Format = "C";
//dgvReport.Columns.Add("Notes", "Notes");
//dgvReport.Columns["Notes"].DataPropertyName = "Notes";
//// Initialize the DataGridView.
//dgvReport.AutoGenerateColumns = false;
//dgvReport.AutoSize = true;
//dgvReport.DataSource = rows;
//dgvReport.Refresh();
//PrintPreviewDialog objPPdialog = new PrintPreviewDialog();
//printDocument1.DocumentName = "Payment Information";
//objPPdialog.Document = printDocument1;
//objPPdialog.ShowDialog();
}
}
