private void FetchInvoiceButton_Click(object sender, RoutedEventArgs e) { if (InvoiceDatagrid.SelectedItems.Count != 1) { MessageBox.Show("Please select one row to view the invoice details."); return; } Invoice inv = (Invoice)InvoiceDatagrid.SelectedItem; BillingDataDataContext db = new BillingDataDataContext(); PrintMainWindow window = new PrintMainWindow(inv); try { window.Show(); }catch (InvalidOperationException) { MessageBox.Show("Unable to open invoice"); } }
private void printMIS() { string errorMsg = ""; if (ToDate.SelectedDate == null || FromDate.SelectedDate == null || ToDate.SelectedDate < FromDate.SelectedDate) { errorMsg += "Please set the date properly. \n"; } Client selectedClient = (Client)ClientList.SelectedItem; BillingDataDataContext db = new BillingDataDataContext(); if (errorMsg != "") { MessageBox.Show(errorMsg); return; } List <MISReportView> source = db.MISReportViews.Where(x => x.CLCODE == selectedClient.CLCODE && x.BookingDate <= ToDate.SelectedDate && x.BookingDate >= FromDate.SelectedDate).ToList(); if (SubClientComboBox.Text != null && SubClientComboBox.Text != "") { source = source.Where(x => x.SubClient == SubClientComboBox.Text).ToList(); } ReportDataSource rs = new ReportDataSource(); rs.Value = source; rs.Name = "DataSet1"; List <ReportParameter> repParams = new List <ReportParameter>(); repParams.Add(new ReportParameter("ClientName", selectedClient.CLNAME + " " + SubClientComboBox.Text)); repParams.Add(new ReportParameter("ClientAddress", selectedClient.ADDRESS)); repParams.Add(new ReportParameter("ClientPhoneNo", selectedClient.CONTACTNO)); repParams.Add(new ReportParameter("FromDate", ((DateTime)(FromDate.SelectedDate)).ToString())); repParams.Add(new ReportParameter("ToDate", ((DateTime)(ToDate.SelectedDate)).ToString())); PrintMainWindow window = new PrintMainWindow(rs, repParams, true); window.Show(); }
private void printObj(Client client = null) { #region temp string errorMsg = ""; if (ToDate.SelectedDate == null || FromDate.SelectedDate == null || ToDate.SelectedDate < FromDate.SelectedDate) { errorMsg += "Please set the date properly. \n"; } if (ServiceTaxBox.Text == "") { ServiceTaxBox.Text = "0"; } double temp; if (TaxBox.Text == "") { TaxBox.Text = "0"; } if (MiscBox.Text == "") { MiscBox.Text = "0"; } if (PreviousDueTextBox.Text == "") { PreviousDueTextBox.Text = "0"; } if (double.TryParse(TaxBox.Text, out temp) == false) { errorMsg += "Please enter fuel surcharge correctly. \n"; } if (double.TryParse(ServiceTaxBox.Text, out temp) == false) { errorMsg += "Please enter service tax correctly. \n"; } if (double.TryParse(MiscBox.Text, out temp) == false) { errorMsg += "Please enter miscellenaeous charge correctly. \n"; } if (double.TryParse(PreviousDueTextBox.Text, out temp) == false) { errorMsg += "Please enter previous charge correctly. \n"; } if (double.TryParse(DiscountBox.Text, out temp) == false) { errorMsg += "Enter customer discount properly. \n"; } if (errorMsg != "") { MessageBox.Show(errorMsg); return; } #endregion invoice = new FinalUi.Invoice(); BillingDataDataContext db = new BillingDataDataContext(); source = UtilityClass.convertToRuntimeVIew(dataGridSource).Where(x => x.CustCode == ((Client)ClientList.SelectedItem).CLCODE && x.BookingDate <= ToDate.SelectedDate && x.BookingDate >= FromDate.SelectedDate).OrderBy(y => y.BookingDate).ThenBy(z => z.ConsignmentNo).ToList(); if (SubClientComboBox.Text == "") { source = source.Where(x => x.SubClient == "" || x.SubClient == null).ToList(); } else { source = source.Where(x => x.SubClient == SubClientComboBox.Text).ToList(); } rs.Value = source; Client curClient; if (client == null) { curClient = ((Client)ClientList.SelectedItem); } else { curClient = client; } invoice.Basic = (double)(source.Sum(x => x.FrAmount) ?? 0); invoice.ClientCode = curClient.CLCODE; invoice.Discount = double.Parse(DiscountBox.Text); invoice.Fuel = double.Parse(TaxBox.Text); invoice.STax = double.Parse(ServiceTaxBox.Text); List <ReportParameter> repParams = new List <ReportParameter>(); DateTime toDate = ToDate.SelectedDate ?? DateTime.Today; DateTime fromDate = FromDate.SelectedDate ?? DateTime.Today; 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}", invoice.Basic))); repParams.Add(new ReportParameter("FuelString", TaxBox.Text)); repParams.Add(new ReportParameter("ServiceTaxString", String.Format("{0:0.00}", double.Parse(ServiceTaxBox.Text)))); repParams.Add(new ReportParameter("DiscountPString", String.Format("{0:0.00}", double.Parse(DiscountBox.Text)))); repParams.Add(new ReportParameter("MiscellaneousAmountString", MiscBox.Text)); double temp2; if (double.TryParse(MiscBox.Text, out temp2)) { invoice.Misc = temp2; } repParams.Add(new ReportParameter("DiscountAmountString", String.Format("{0:0.00}", invoice.discountAmount))); repParams.Add(new ReportParameter("FuelAmount", String.Format("{0:0.00}", invoice.fuelAmount))); repParams.Add(new ReportParameter("ServiceTaxAmount", String.Format("{0:0.00}", invoice.taxAmount))); repParams.Add(new ReportParameter("SWC", String.Format("{0:0.00}", invoice.SWC))); if (PreviousDueCheck.Checked == true) { invoice.PreviousDue = double.Parse(PreviousDueTextBox.Text); } repParams.Add(new ReportParameter("TotalAmountString", String.Format("{0:0.00}", invoice.totalAmount))); string totalAmountinWordString = UtilityClass.NumbersToWords((int)Math.Round(invoice.totalAmount)); repParams.Add(new ReportParameter("TotalAmountInWordString", totalAmountinWordString)); if (PreviousDueCheck.Checked == true) { repParams.Add(new ReportParameter("PreviousDueString", PreviousDueTextBox.Text)); 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("ClientName", curClient.CLNAME + " " + SubClientComboBox.Text ?? " ")); repParams.Add(new ReportParameter("ClientAddress", curClient.ADDRESS)); repParams.Add(new ReportParameter("ClientPhoneNo", curClient.CONTACTNO)); repParams.Add(new ReportParameter("TinNumber", Configs.Default.Tin ?? "")); repParams.Add(new ReportParameter("TNC", Configs.Default.TNC)); repParams.Add(new ReportParameter("ServiceTaxNumber", Configs.Default.ServiceTaxno ?? "")); invoice.BillId = (InvoiceDate.SelectedDate ?? DateTime.Today).ToString("yyyyMMdd"); invoice.Date = InvoiceDate.SelectedDate ?? DateTime.Today; invoice.BillId = invoice.BillId + DateTime.Now.ToString("hhmmss"); invoice.Remarks = RemarkBox.Text; invoice.TotalAmount = invoice.totalAmount; repParams.Add(new ReportParameter("InvoiceNumber", invoice.BillId)); repParams.Add(new ReportParameter("InvoiceDate", (InvoiceDate.SelectedDate ?? DateTime.Today).ToString("dd-MMM-yyyy"))); PrintMainWindow win = new PrintMainWindow(rs, repParams); win.Show(); }