private void RunSummaryByOrigin() { var clientId = int.Parse(ddlClient.SelectedValue); if (ddlClient.SelectedIndex == 0) { Response.Write("<script type='text/javascript'>alert('Please select a client!');</script>"); } else { try { using (var client = new QCAstServiceClient()) { var clientName = client.GetClientFromId(clientId).ClientName; rptViewer.LocalReport.DataSources.Add(new ReportDataSource("dsInvoiceSummary", client.GetSummaryByOrigin(clientId))); rptViewer.ProcessingMode = ProcessingMode.Local; rptViewer.LocalReport.ReportPath = @"Reports\StatementSummaryBySrc.rdlc"; var clientDescription = new ReportParameter("ClientDescription", clientName); rptViewer.LocalReport.SetParameters(new[] { clientDescription }); rptViewer.LocalReport.EnableHyperlinks = true; rptViewer.LocalReport.Refresh(); rptViewer.LocalReport.DataSources.Clear(); rptViewer.Reset(); } } catch (Exception ex) { NotifyWebmasterOfError("Billing", "Report RunTopTwentyCallsByDuration", ex.ToString()); } } }
private void RunInvoiceHistory() { lblError.Text = ""; try { int idClient = int.Parse(Session["IdClient"].ToString()); int idInvoice = int.Parse(ddlClientInvoiceHistory.SelectedValue); using (QCAstServiceClient client = new QCAstServiceClient()) { Client clientName = client.GetClientFromId(idClient); rptViewer.LocalReport.DataSources.Clear(); rptViewer.Reset(); DateTime invoiceDate = client.GetInvoiceDate(idInvoice); List <InvoiceDetail> invoiceDetails = client.GetInvoicedDetailsForClient(idClient, idInvoice); List <InvoiceSummary> invoiceSummaries = client.GetInvoicedSummaryForClient(idClient, idInvoice); if (invoiceDetails.Count == 0) { lblError.Text = string.Format("No data available for invoice date {0}", invoiceDate); } else { ReportDataSource rdInvDetail = new ReportDataSource("dsInvoiceDetail", invoiceDetails.AsEnumerable()); ReportDataSource rdInvSummary = new ReportDataSource("dsInvoiceSummary", invoiceSummaries.AsEnumerable()); rptViewer.LocalReport.DataSources.Add(rdInvDetail); rptViewer.LocalReport.DataSources.Add(rdInvSummary); rptViewer.ProcessingMode = ProcessingMode.Local; rptViewer.LocalReport.ReportPath = @"Reports\InvoiceDetail.rdlc"; string startDate = invoiceDetails.OrderByDescending(p => p.CallDate).LastOrDefault().CallDate.ToString(); string endDate = invoiceDetails.OrderByDescending(p => p.CallDate).FirstOrDefault().CallDate.ToString(); ReportParameter ClientDescription = new ReportParameter("ClientDescription", clientName.ClientName); ReportParameter ReportDescription = new ReportParameter("ReportDescription", "From : " + startDate + Environment.NewLine + "To : " + endDate); ReportParameter TotalDuration = new ReportParameter("TotalDuration", client.GetTotalDuration(idClient, invoiceDate)); rptViewer.LocalReport.SetParameters(new ReportParameter[] { ClientDescription, ReportDescription, TotalDuration }); rptViewer.LocalReport.Refresh(); } } } catch (Exception ex) { NotifyWebmasterOfError("ClientBilling", "Billing RunInvoiceHistory", ex.ToString()); lblError.Text = "The website encountered a problem retrieving the invoice detail for this report. The webmaster has been notified and will be attending to the problem."; } }
protected void lbSearchedClients_SelectedIndexChanged(object sender, EventArgs e) { int id = int.Parse(((ListBox)sender).SelectedValue); ClearListAndTextboxes(); try { using (QCAstServiceClient client = new QCAstServiceClient()) { Client fetchedClient = client.GetClientFromId(id); tbClientId.Text = fetchedClient.IdClient.ToString(); tbClientDesc.Text = fetchedClient.ClientName; tbRangeFrom.Text = fetchedClient.RangeFrom != null?fetchedClient.RangeFrom.Value.ToString() : ""; tbRangeTo.Text = fetchedClient.RangeTo != null?fetchedClient.RangeTo.Value.ToString() : ""; tbClientCode.Text = fetchedClient.ClientCode; tbAccountingCode.Text = fetchedClient.AccountingCode; tbCellular.Text = fetchedClient.CellularNumber ?? ""; tbEmail.Text = fetchedClient.Email ?? ""; ddlPrefContactMethod.SelectedIndex = ddlPrefContactMethod.Items.IndexOf( ddlPrefContactMethod.Items.FindByValue(fetchedClient.ContactMethod.ToString())); tbMaxDuration.Text = fetchedClient.MaxCallDuration != null ? fetchedClient.MaxCallDuration.Value.ToString() : ""; tbMaxIntDuration.Text = fetchedClient.MaxIntCallDuration != null ? fetchedClient.MaxIntCallDuration.Value.ToString() : ""; string maxIntPrice = fetchedClient.MaxIntCallPrice != null ? fetchedClient.MaxIntCallPrice.Value.ToString() : ""; tbMaxIntPrice.Text = maxIntPrice != "" ? maxIntPrice.Remove(maxIntPrice.Length - 4, 3) : ""; string maxPrice = fetchedClient.MaxCallPrice != null ? fetchedClient.MaxCallPrice.Value.ToString() : ""; tbMaxPrice.Text = maxPrice != "" ? maxPrice.Remove(maxPrice.Length - 4, 3) : ""; } ibEditClient.Enabled = true; ibDeleteClient.Enabled = true; } catch (Exception ex) { NotifyWebmasterOfError("Billing", "User Management SearchSelectedIndexChanged", ex.ToString()); } }