public PrintMainWindow(ReportDataSource rs, List <ReportParameter> repParams, bool isMis) { InitializeComponent(); BillViewer.LocalReport.ReportPath = "Report2.rdlc"; BillViewer.LocalReport.DataSources.Clear(); BillViewer.LocalReport.DataSources.Add(rs); BillViewer.LocalReport.SetParameters(repParams); BillViewer.RefreshReport(); }
public PrintMainWindow(ReportDataSource rs, List <ReportParameter> repParams) { InitializeComponent(); BillViewer.LocalReport.ReportPath = "Report1.rdlc"; BillViewer.LocalReport.DataSources.Clear(); BillViewer.LocalReport.DataSources.Add(rs); BillViewer.LocalReport.SetParameters(repParams); string InvoiceName = ""; string clientName = ""; ReportParameter invName = repParams.SingleOrDefault(x => x.Name == "InvoiceNumber"); if (invName != null && invName.Values.Count > 0) { InvoiceName = invName.Values[0]; } ReportParameter ClientName = repParams.SingleOrDefault(x => x.Name == "ClientName"); if (ClientName != null && ClientName.Values.Count > 0) { clientName = ClientName.Values[0]; } BillViewer.LocalReport.DisplayName = clientName + "-" + InvoiceName; BillViewer.RefreshReport(); }
public PrintMainWindow(Invoice inv) { try { InitializeComponent(); BillingDataDataContext db = new BillingDataDataContext(); List <RuntimeData> data = UtilityClass.convertTransListToRuntimeList(db.ExecuteQuery <Transaction>(@" SELECT [ID] ,[AmountPayed] ,[AmountCharged] ,[ConnsignmentNo] ,[Weight] ,[WeightByFranchize] ,[Destination] ,[DestinationPin] ,[UserId] ,[BookingDate] ,[AddDate] ,[LastModified] ,[Type] ,[Mode] ,[DOX] ,[ServiceTax] ,[SplDisc] ,[InvoiceNo] ,[InvoiceDate] ,[CustCode] ,[TransMF_No] ,[BilledWeight] FROM [BillingDatabase].[dbo].[InvoiceView] where [BillId] = '" + inv.BillId + @"' ").ToList()); source = UtilityClass.convertToRuntimeVIew(data.OrderBy(x => x.BookingDate).ThenBy(z => z.ConsignmentNo).ToList()); rs = new ReportDataSource(); rs.Value = source; if (inv.Misc == null) { inv.Misc = 0; } if (inv.PreviousDue == null) { inv.PreviousDue = 0; } Client clc = DataSources.ClientCopy.SingleOrDefault(x => x.CLCODE == inv.ClientCode); List <ReportParameter> repParams = new List <ReportParameter>(); DateTime FromDate = data.Min(x => x.BookingDate); DateTime ToDate = data.Max(x => x.BookingDate); string dateString = FromDate.ToString("dd/MM/yyyy") + " to " + ToDate.ToString("dd/MM/yyyy"); repParams.Add(new ReportParameter("DateString", dateString)); string descriptionString = "Total Consignments: " + source.Count; repParams.Add(new ReportParameter("DescriptionString", descriptionString)); repParams.Add(new ReportParameter("MainAmountString", String.Format("{0:0.00}", inv.Basic))); repParams.Add(new ReportParameter("DiscountPString", String.Format("{0:0.00}", inv.Discount))); repParams.Add(new ReportParameter("FuelString", String.Format("{0:0.00}", inv.Fuel))); repParams.Add(new ReportParameter("FuelAmount", String.Format("{0:0.00}", inv.fuelAmount))); repParams.Add(new ReportParameter("ServiceTaxString", String.Format("{0:0.00}", inv.STax))); repParams.Add(new ReportParameter("ServiceTaxAmount", String.Format("{0:0.00}", inv.taxAmount))); repParams.Add(new ReportParameter("DiscountAmountString", String.Format("{0:0.00}", inv.discountAmount))); repParams.Add(new ReportParameter("SWC", String.Format("{0:0.00}", inv.SWC))); repParams.Add(new ReportParameter("MiscellaneousAmountString", String.Format("{0:0.00}", inv.Misc))); repParams.Add(new ReportParameter("TNC", Configs.Default.TNC)); repParams.Add(new ReportParameter("TotalAmountString", String.Format("{0:0.00}", inv.totalAmount))); repParams.Add(new ReportParameter("TotalAmountInWordString", UtilityClass.NumbersToWords((int)Math.Round(inv.totalAmount)))); if (inv.PreviousDue == 0 || inv.PreviousDue == null) { repParams.Add(new ReportParameter("PreviousDueString", "")); } else { repParams.Add(new ReportParameter("PreviousDueString", String.Format("{0:0.00}", inv.PreviousDue))); repParams.Add(new ReportParameter("PreviousDueCheck", "Previous Due .:")); } repParams.Add(new ReportParameter("CompanyName", Configs.Default.CompanyName)); repParams.Add(new ReportParameter("ComapnyPhoneNo", Configs.Default.CompanyPhone)); repParams.Add(new ReportParameter("CompanyAddress", Configs.Default.CompanyAddress)); repParams.Add(new ReportParameter("CompanyEmail", Configs.Default.CompanyEmail)); repParams.Add(new ReportParameter("CompanyFax", Configs.Default.CompanyFax)); repParams.Add(new ReportParameter("TinNumber", Configs.Default.Tin ?? "")); repParams.Add(new ReportParameter("ClientName", clc.CLNAME)); repParams.Add(new ReportParameter("ClientAddress", clc.ADDRESS)); repParams.Add(new ReportParameter("ClientPhoneNo", clc.CONTACTNO)); repParams.Add(new ReportParameter("ServiceTaxNumber", Configs.Default.ServiceTaxno ?? "")); // repParams.Add(new ReportParameter("Tinnumber", Configs.Default.Tin)); DateTime invDateTime; if (inv.BillId.Length < 14) { invDateTime = DateTime.ParseExact(inv.BillId, "yyyyMMddhhmm", CultureInfo.InvariantCulture); } else { invDateTime = DateTime.ParseExact(inv.BillId, "yyyyMMddhhmmss", CultureInfo.InvariantCulture); } repParams.Add(new ReportParameter("InvoiceDate", invDateTime.ToString("dd-MMM-yyyy"))); repParams.Add(new ReportParameter("InvoiceNumber", inv.BillId)); BillViewer.LocalReport.ReportPath = "Report1.rdlc"; BillViewer.LocalReport.DataSources.Clear(); rs.Name = "DataSet1"; BillViewer.LocalReport.DataSources.Add(rs); BillViewer.LocalReport.SetParameters(repParams); BillViewer.LocalReport.DisplayName = inv.ClientName + "-" + inv.BillId; BillViewer.RefreshReport(); } catch (Exception) { MessageBox.Show("Error opening file."); this.Close(); } }