// List<TempCallHistory> objTempCallHistory = new List<TempCallHistory>(); public frmCallHistory(CallerIdType_Configuration obj) { InitializeComponent(); this.objCLISettings = obj; this.Load += new EventHandler(frmCallHistory_Load); FormatGrid(); ddlCustomer.Enter += new EventHandler(ddlCustomer_Enter); // ComboFunctions.FillCustomerCombo(ddlCustomer); grdCalls.CommandCellClick += new CommandCellClickEventHandler(grdCalls_CommandCellClick); this.chkSubCompanyWise.ToggleStateChanged += ChkSubCompanyWise_ToggleStateChanged; grdCalls.ViewCellFormatting += grdLister_ViewCellFormatting; }
private void GenerateReport() { try { bool isMissed = optMissedCalls.Checked; if (dtpFromDate.Value != null && dtpFromDate.Value.Value.Year == 1753) { dtpFromDate.Value = null; } if (dtpTillDate.Value != null && dtpTillDate.Value.Value.Year == 1753) { dtpTillDate.Value = null; } DateTime?fromDate = dtpFromDate.Value.ToDateorNull(); DateTime?tillDate = dtpTillDate.Value.ToDateorNull(); string phone = txtPhone.Text.Trim(); string name = txtName.Text.Trim().ToLower(); string Line = txtLine.Text.ToStr(); string Stn = txtStn.Text.ToStr(); var list = (from a in GeneralBLL.GetQueryable <CallHistory>(null) where (fromDate == null || a.CallDateTime.Value.Date >= fromDate) && (tillDate == null || a.CallDateTime.Value.Date <= tillDate) && (name == string.Empty || a.Name.Trim().ToLower().StartsWith(name)) && (phone == string.Empty || a.PhoneNumber.Trim() == phone) && (Line == string.Empty || a.Line == Line) && (Stn == string.Empty || a.STN == Stn) && (isMissed == false || (a.IsAccepted != null && a.IsAccepted == true)) orderby a.CallDateTime descending select new { Name = a.Name, PhoneNumber = a.PhoneNumber, CallDateTime = a.CallDateTime, Line = a.Line, STN = a.STN }).ToList(); CallHistoryBindingSource.DataSource = list; Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[6]; string address = AppVars.objSubCompany.Address; string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo; param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Header", AppVars.objSubCompany.CompanyName.ToStr()); param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address); param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo); string heading = string.Empty; if (fromDate != null && tillDate != null) { heading = string.Format("{0:dd/MM/yyyy}", fromDate) + " to " + string.Format("{0:dd/MM/yyyy}", tillDate); } param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Criteria", heading); param[4] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_TotalCalls", list.Count.ToStr()); CallerIdType_Configuration obj = General.GetObject <CallerIdType_Configuration>(c => c.Id != null); string DigitalCLIType = obj.DigitalCLIType.ToStr(); param[5] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_DigitalCLIType", DigitalCLIType == "" ? "0" : DigitalCLIType); reportViewer1.LocalReport.SetParameters(param); this.reportViewer1.ZoomPercent = 100; this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.RefreshReport(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }
private void GenerateReport() { try { if (dtpFromDate.Value != null && dtpFromDate.Value.Value.Year == 1753) { dtpFromDate.Value = null; } if (dtpTillDate.Value != null && dtpTillDate.Value.Value.Year == 1753) { dtpTillDate.Value = null; } DateTime?fromDate = dtpFromDate.Value.ToDateorNull(); DateTime?tillDate = dtpTillDate.Value.ToDateorNull(); string phone = txtPhone.Text.Trim(); string name = txtName.Text.Trim().ToLower(); bool? isArrived = chkArrivalRing.Checked; string Stn = txtStn.Text.ToStr(); if (chkAll.Checked) { isArrived = null; } var list = (new TaxiDataContext()).stp_GetRingBackLog(fromDate, tillDate, name, Stn, phone, isArrived).ToList(); this.stp_GetRingBackLogResultBindingSource.DataSource = list; Microsoft.Reporting.WinForms.ReportParameter[] param = new Microsoft.Reporting.WinForms.ReportParameter[6]; string address = AppVars.objSubCompany.Address; string telNo = "Tel No. " + AppVars.objSubCompany.TelephoneNo; param[0] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Header", AppVars.objSubCompany.CompanyName.ToStr()); param[1] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Address", address); param[2] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Telephone", telNo); string heading = string.Empty; if (fromDate != null && tillDate != null) { heading = string.Format("{0:dd/MM/yyyy}", fromDate) + " to " + string.Format("{0:dd/MM/yyyy}", tillDate); } param[3] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_Criteria", heading); param[4] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_TotalCalls", list.Count.ToStr()); CallerIdType_Configuration obj = General.GetObject <CallerIdType_Configuration>(c => c.Id != null); string DigitalCLIType = obj.DigitalCLIType.ToStr(); param[5] = new Microsoft.Reporting.WinForms.ReportParameter("Report_Parameter_DigitalCLIType", DigitalCLIType == "" ? "0" : DigitalCLIType); reportViewer1.LocalReport.SetParameters(param); this.reportViewer1.ZoomPercent = 150; this.reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; this.reportViewer1.RefreshReport(); } catch (Exception ex) { ENUtils.ShowMessage(ex.Message); } }