public Invoice(string invoiceNumber)
{
InitializeComponent();
CenterToScreen();
var adapter = new DataSet1TableAdapters.DataTable1TableAdapter();
adapter.Connection.ConnectionString = ConfigurationManager.ConnectionStrings["SyncDB"].ToString();
var table = new DataSet1.DataTable1DataTable();
adapter.FillByInvoiceNumber(table, invoiceNumber);
var newDataSource = new ReportDataSource("DataSet1", (DataTable)table);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(newDataSource);
ReportParameter[] parameters = new ReportParameter[13];
using (var context = new ManagementDbEntities())
{
double totalAmount;
totalAmount = 0;
var StockOutRecords = context.StockOutRecords.Where(r => r.InvoiceNumber == invoiceNumber).ToList();
foreach (var record in StockOutRecords)
{
totalAmount += record.ProductTotalAmount.GetValueOrDefault();
}
var firstRecord = StockOutRecords.FirstOrDefault();
var currentUser = context.Users.FirstOrDefault();
parameters[0] = new ReportParameter("CustomerName", firstRecord.CustomerName);
parameters[1] = new ReportParameter("CustomerContactPerson", firstRecord.CustomerContactPerson);
parameters[2] = new ReportParameter("CustomerContactNumber", firstRecord.CustomerContact);
parameters[3] = new ReportParameter("CustomerAddress", firstRecord.CustomerAddress);
parameters[4] = new ReportParameter("InvoiceDate", firstRecord.Date.GetValueOrDefault().ToString("yyyy-MM-dd"));
parameters[5] = new ReportParameter("Amount", totalAmount.ToString());
parameters[6] = new ReportParameter("InvoiceNumber", firstRecord.InvoiceNumber);
parameters[7] = new ReportParameter("CapitalAmount", GetCapitalAmount(totalAmount));
parameters[8] = new ReportParameter("CompanyName", currentUser.CompanyName);
parameters[9] = new ReportParameter("CompanyAddress", currentUser.CompanyAddress);
parameters[10] = new ReportParameter("CompanyTel", currentUser.CompanyContact);
parameters[11] = new ReportParameter("CompanyFax", currentUser.CompanyFax);
parameters[12] = new ReportParameter("MadeBy", currentUser.InvoiceCreator);
}
this.reportViewer1.LocalReport.SetParameters(parameters);
this.reportViewer1.LocalReport.Refresh();
this.reportViewer1.RefreshReport();
}
