private void cmdGenerateExcel_Execute(object obj)
        {
            try
            {
                string folderPath = string.Empty;
                if (fromInvoiceDate > toInvoiceDate)
                {
                    UIHelper.ShowErrorMessage("From Date cannot not be greater than To Date");
                    return;
                }
                ////if ((toInvoiceDate - fromInvoiceDate).Days > 31)
                ////{
                ////    UIHelper.ShowErrorMessage("Days Difference should not be greater than 31");
                ////    return;
                ////}
                if (fromSettlementDate > toSettlementDate)
                {
                    UIHelper.ShowErrorMessage("From Settlement Date cannot not be greater than To Date");
                    return;
                }
                ////if ((toSettlementDate - fromSettlementDate).Days > 31)
                ////{
                ////    UIHelper.ShowErrorMessage("Days Difference should not be greater than 31");
                ////    return;
                ////}

                using (System.Windows.Forms.FolderBrowserDialog browse = new System.Windows.Forms.FolderBrowserDialog())
                {
                    browse.ShowDialog();
                    folderPath = browse.SelectedPath;
                }
                if (string.IsNullOrEmpty(folderPath))
                {
                    UIHelper.ShowErrorMessage("Select Path to save excel file");
                    return;
                }

                using (InvoiceServiceClient pxy = new InvoiceServiceClient())
                {
                    ObservableCollection <SettlementDetails> lstInvoiceSettlement = pxy.InvoiceSettlementPatch(fromInvoiceNo, toInvoiceNo, fromInvoiceDate, toInvoiceDate, ProductID, fromSettlementDate, toSettlementDate, Global.UserID);
                    if (lstInvoiceSettlement == null || lstInvoiceSettlement.Count == 0)
                    {
                        UIHelper.ShowMessage("Data not found");
                        return;
                    }
                    using (ReportViewer reportViewer = new ReportViewer())
                    {
                        reportViewer.LocalReport.DataSources.Clear();
                        reportViewer.LocalReport.DataSources.Add(new ReportDataSource("InvoiceSettlementDataSet", lstInvoiceSettlement));
                        reportViewer.LocalReport.ReportPath = System.Windows.Forms.Application.StartupPath + "//Views//Reports//InvoiceSettlementPatch.rdlc";
                        reportViewer.RefreshReport();
                        byte[] Bytes = reportViewer.LocalReport.Render(format: "Excel", deviceInfo: "");
                        using (FileStream stream = new FileStream(folderPath + "//InvoiceSettlementPatch.xls", FileMode.Create))
                        {
                            stream.Write(Bytes, 0, Bytes.Length);
                        }
                    }
                }
            }
            catch (FaultException ex)
            {
                UIHelper.ShowErrorMessage(ex.Message);
            }
            catch (Exception ex)
            {
                UIHelper.ShowErrorMessage(ex.Message);
            }
        }