C#

In crystal reports i have used xml file to display the data. the fields are displaying but data is not displayed and parameter filter is also not working.

private void _Toolbar1_Button13_Click(object sender, EventArgs e)
       {
           count = 0;
           DataSet ds = new DataSet();
           DataTable dt = new DataTable();
 
           SiimsReports.ReportForms.FormReportDisplay frmRpt = new FormReportDisplay();
           SiimsReports.Reports.ServiceRpt objservice = new SIIMS.SiimsReports.Reports.ServiceRpt();
 
           foreach (string cust in lstCustName .SelectedItems )
           {
               foreach (string reg in lstRegion.SelectedItems )
               {
                   {
                       foreach (string sys in lstSysName.SelectedItems )
                       {
                         string strsql = "select custname,regname ,location ,sysnames ,sysmake ,servicedate ,district,"
                           + " (pendingpoints+'.' +remarks) pendingpoints,batteryreplacedon,servicetype from Leo_ServiceOrder where custname='" + cust + "' "
                           + " and regname='" + reg + "' and  sysnames='" + sys + "' and servicedate between '" + dtpFromDt.Value.ToString("yyyy-MM-dd") + "' and "
                           + "'" + dtpToDt.Value.ToString("yyyy-MM-dd") + "'";
 
                         dt = objSO.ServiceReport(strsql);
 
                         if (dt.Rows.Count > 0)
                         {
                             for (int i = 0; i < dt.Rows.Count; i++)
                             {
                                 objSO.custname = dt.Rows[i]["custname"].ToString();
                                 objSO.regname = dt.Rows[i]["regname"].ToString();
                                 objSO.location = dt.Rows[i]["location"].ToString();
                                 objSO.sysnames = dt.Rows[i]["sysnames"].ToString();
                                 objSO.sysmake = dt.Rows[i]["sysmake"].ToString();
                                 objSO.pendingpoints = dt.Rows[i]["pendingpoints"].ToString();
                                // objSO.remarks = dt.Rows[i][""].ToString();
                                 objSO.serviceorderdate = dt.Rows[i]["servicedate"].ToString();
                                 objSO.district = dt.Rows[i]["district"].ToString();
                                 objSO.batteryreplaced = dt.Rows[i]["batteryreplacedon"].ToString();
                                 objSO.servicetype = dt.Rows[i]["servicetype"].ToString();
 
                                 objSO.InsertServiceRpt();
                             }
                         }
 
                       }
                   }
               }
 
           }
 
           string strqry = "select * from Leo_TempServiceOrder";
           ds = objSO.getServiceReport(strqry);
           string spath = Application.StartupPath;
           string newpath = "C:\\Program Files\\Default Company Name\\LeoSetup\\";
           newpath = newpath + "SiimsReports\\Reports\\ServiceReports.rpt";
 
           CrystalDecisions.CrystalReports.Engine.ReportDocument myrpt = new ReportDocument();
           myrpt.Load(newpath);
           myrpt.SetDatabaseLogon("sa", "prerana123", @"DISHU-PC\SQLEXPRESS", "LeoNew");
 
           myrpt.SetDataSource(ds);
           // myrpt.SetParameterValue("SystemName", cmbSystem.Text);
           // myrpt.SetParameterValue("region",cmbregion.Text);
           frmRpt.crViewer.ReportSource = myrpt;
           frmRpt.Show();

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.IO;
using System.Globalization;
using System.Data.SqlClient;
using System.Threading;
using System.Reflection;
using System.Diagnostics;
using System.Web;
using System.Xml;
using System.Net;



namespace GALAXY_LEAD_SERVER
{
    public partial class Form1 : Form
    {
        static int i = 0;
        static int corecamp = 0;
        static int cmpnID = 0;
        private Thread workerThread = null;
        private bool stopProcess = false;
        private delegate void UpdateStatusDelegate();
        private UpdateStatusDelegate updateStatusDelegate = null;
        CRCSMS crcsms = new CRCSMS();
        static int serverStatus = 0;
        public static string mystatus = "";
        static string AppLogFile = "SG_LeadServer";
        public static string logPath = Directory.GetCurrentDirectory() + "\\LOGS\\" + DateTime.Now.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture).Replace("/", "");
        SqlCommand cmd = new SqlCommand();
        GalaxyConfig GC = new GalaxyConfig();
        GalaxyLib GL = new GalaxyLib();
        LIBVALUE LB = new LIBVALUE();
        public Form1()
        {
            InitializeComponent();
        }
        private void Form1_Load(object sender, EventArgs e)
        {
            string version = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
            mystatus = "Load SG Lead Server " + version;
            this.updateStatusDelegate = new UpdateStatusDelegate(this.UpdateStatus);
            //this.Invoke(this.updateStatusDelegate);
            this.BeginInvoke(this.updateStatusDelegate);
            this.Text = "SPECTRUM LEAD SERVER " + version;
            if (serverStatus == 0)
            {
                ServerStatustextBox.Text = "Stopped";
                Startbutton.Text = "Start";
            }
            else
            {
                Startbutton.Text = "Stop";
                ServerStatustextBox.Text = "Running";
            }
            mystatus = "Current Status: " + ServerStatustextBox.Text;

            //this.Invoke(this.updateStatusDelegate);
            this.BeginInvoke(this.updateStatusDelegate);
        }
        //Thread t_thread1;
        //Thread t_thread2;
        class FileInfo
        {
            public int HostId { get; set; }
            public string Extension { get; set; }
            public string FolderPath { get; set; }
        }
        private void Startbutton_Click(object sender, EventArgs e)
        {
            var threads = new List<Thread>();
            string[] services = new string[2];
            services[0] = 1.ToString();
            services[1] = 2.ToString();





            if (serverStatus == 0)
            {
                AppLogFile = "SG_LeadServer";
                this.stopProcess = false;
                serverStatus = 1;
                Startbutton.Text = "Stop";
                ServerStatustextBox.Text = "Running";
                for (int i = 0; i <= services.Length - 1; i++)
                {
                    var hostID = (int)i;
                    FileInfo ff = new FileInfo();

                    var thread = new Thread(HeavyOperation)
                    {
                        Name = string.Format("myService{0}", i),
                    };
                    thread.Start(new FileInfo
                    {
                        HostId = hostID,
                    });
                    threads.Add(thread);
                    mystatus = "Added Thread: " + thread.Name.ToString();
                    //this.Invoke(this.updateStatusDelegate);
                    this.BeginInvoke(this.updateStatusDelegate);


                    threads[i].Join();
                    mystatus = "Joined Thread: " + thread.Name.ToString();
                    //this.Invoke(this.updateStatusDelegate);
                    this.BeginInvoke(this.updateStatusDelegate);

                }

                //this.workerThread = new Thread(new ThreadStart(this.HeavyOperation));
                //this.workerThread.Start();
                //this.workerThread = new Thread(new ThreadStart(this.HeavyOperation1));
                //this.workerThread.Start();

                //t_thread1 = new Thread(new ThreadStart(HeavyOperation));
                //t_thread1.Start();


                //t_thread2 = new Thread(new ThreadStart(HeavyOperation1));
                //t_thread2.Start();

            }
            else if (serverStatus == 1)
            {
                this.stopProcess = true;
                serverStatus = 0;
                LoadCampaigns();

                Startbutton.Text = "Start";
                ServerStatustextBox.Text = "Stopped";
                AppLogFile = "SG_LeadServer";
            }
            mystatus = "Current Status: " + ServerStatustextBox.Text;
            //this.Invoke(this.updateStatusDelegate);
            this.BeginInvoke(this.updateStatusDelegate);
        }
        private void timer1_Tick(object sender, EventArgs e)
        {
            TimeLabel.Text = DateTime.Now.ToString("dd-MM-yyyy hh:mm:ss");
        }
        private void HeavyOperation(object threadState)
        {
            
            for (i = 0; i <= 10; i++)
            {
                cmpnID = 8;
                Thread.Sleep(500);
                // Check if Stop button was clicked
                if (!this.stopProcess)
                {
                    // Show progress
                    if (serverStatus == 0)
                    {
                        mystatus = "Server stopped.contact administrator";
                        return;
                    }
                    LoadCampaigns();
                }
                else
                {
                    // Stop heavy operation
                    //this.workerThread.Abort();

                }
                if (i > 9) i = 0;
            }
        }
        private void HeavyOperation1()
        {
            
            //this.workerThread = new Thread(new ThreadStart(this.HeavyOperation1));
            for (i = 0; i <= 10; i++)
            {
                cmpnID = 10;
                Thread.Sleep(500);
                // Check if Stop button was clicked
                if (!this.stopProcess)
                {
                    // Show progress
                    if (serverStatus == 0)
                    {
                        mystatus = "Server stopped.contact administrator";
                        return;
                    }
                    LoadCampaigns();
                }
                else
                {
                    // Stop heavy operation
                    //this.workerThread.Abort();
                }
                if (i > 9) i = 0;
            }
        }
        private void UpdateStatus()
        {
            if (listBox1.Items.Count > 500) listBox1.Items.Clear();
            this.textBox1.Text = i.ToString();
            if (mystatus != "")
            {
                if(AppLogFile!="SG_LeadServer")
                    mystatus=LB.campaignName+"("+LB.campaignID+"): "+ mystatus;
                this.listBox1.Items.Insert(0, DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss") + " ==> "+ mystatus);
                crcsms.writeLogFile(logPath, AppLogFile, mystatus);
            }
            mystatus = "";
        }
        private void Form1_FormClosed(object sender, FormClosedEventArgs e)
        {
            mystatus = "App stop: " + ServerStatustextBox.Text;
            //this.Invoke(this.updateStatusDelegate);
            this.BeginInvoke(this.updateStatusDelegate);
            this.workerThread.Abort();
            //aaa
        }
        private void LoadCampaigns()
        {
            if (serverStatus == 1)
            {
                LB.getCampaignDetails(cmpnID);
                AppLogFile = LB.campaignName;
                DataTable dt = new DataTable();
                dt = LB.getBatchDetails(LB.campaignID);
                //this.Invoke(this.updateStatusDelegate);
                this.BeginInvoke(this.updateStatusDelegate);
                int rowindex = 0;
                cmd.Connection = GC.getcon_Galaxy();
                //this.Invoke(this.updateStatusDelegate);
                this.BeginInvoke(this.updateStatusDelegate);
                foreach (DataRow row in dt.Rows)
                {
                    string strBatch = dt.Rows[rowindex][1].ToString();
                    mystatus = "Found Active Batch for campaign(" + LB.campaignID + ")" + LB.campaignName + ":-" + strBatch;
                    //this.Invoke(this.updateStatusDelegate);
                    this.BeginInvoke(this.updateStatusDelegate);
                    GalaxyLib.getCampaignDetails GL = new GalaxyLib.getCampaignDetails();
                    GL.updateMasterInsertQueue(LB.campaignID, strBatch,LB.outBoundDBName,LB.leadMasterTableName,LB.leadQueueTableName);
                    //this.Invoke(this.updateStatusDelegate);
                    this.BeginInvoke(this.updateStatusDelegate);
                    rowindex = rowindex + 1;
                }
            }
            else//SERVER STATUS 0
            {
                //GalaxyLib.getCampaignDetails GL = new GalaxyLib.getCampaignDetails();
                //GL.updateDeleteWhileStoppingServer(LB.outBoundDBName,LB.leadMasterTableName,LB.leadQueueTableName);
                //this.Invoke(this.updateStatusDelegate);
            }                
        }
        private void Stop_service1()
        {
            LB.getCampaignDetails(8);
            GalaxyLib.getCampaignDetails GL = new GalaxyLib.getCampaignDetails();
            GL.updateDeleteWhileStoppingServer(LB.outBoundDBName, LB.leadMasterTableName, LB.leadQueueTableName);
            //this.Invoke(this.updateStatusDelegate);
            this.BeginInvoke(this.updateStatusDelegate);
            LB.getCampaignDetails(10);
            //GalaxyLib.getCampaignDetails GL = new GalaxyLib.getCampaignDetails();
            GL.updateDeleteWhileStoppingServer(LB.outBoundDBName, LB.leadMasterTableName, LB.leadQueueTableName);
            //this.Invoke(this.updateStatusDelegate);
            this.BeginInvoke(this.updateStatusDelegate);
        }

    }
}