public void fillEngine()
        {
            ChartProperty       objclsChartProperty = new ChartProperty();
            iUserCreationClient UserCreationClient  = new iUserCreationClient();
            CustomProfile       profile             = CustomProfile.GetProfile();

            str = hfCount.Value;

            if (ddlSite.SelectedIndex == 0)
            {
                eng = str;
            }
            else
            {
                eng = str;
            }

            string p = eng;
            iEngineMasterClient    EngineClient    = new iEngineMasterClient();
            iProductMasterClient   productClient   = new iProductMasterClient();
            iPartRequisitionClient RequsitonClient = new iPartRequisitionClient();

            if (p != "")
            {
                chkEngineList.DataSource = EngineClient.GetEngineOfSite(p, profile.DBConnection._constr);
                chkEngineList.DataBind();
            }
        }
        public void fillProduct()
        {
            ChartProperty objclsChartProperty = new ChartProperty();

            objclsChartProperty.QueryParameter = "";
            iUserCreationClient UserCreationClient = new iUserCreationClient();
            CustomProfile       profile            = CustomProfile.GetProfile();

            string abc = hfEng.Value;

            str = hfCount.Value;

            if (ddlSite.SelectedIndex == 0)
            {
                eng = str;
            }
            else
            {
                eng = str;
            }

            string p = eng;

            for (int y = 0; y <= chkEngineList.Items.Count - 1; y++)
            {
                if (prd == null)
                {
                    if (chkEngineList.Items[y].Selected == true)
                    {
                        prd = prd + chkEngineList.Items[y].Value;
                    }
                }
                else
                {
                    if (chkEngineList.Items[y].Selected == true)
                    {
                        prd = prd + "," + chkEngineList.Items[y].Value;
                    }
                }
            }
            string q = prd;

            string fdt = FrmDate.Date.Value.ToString("yyyy-MM-dd");
            string tdt = ToDate.Date.Value.ToString("yyyy-MM-dd");

            iEngineMasterClient    EngineClient    = new iEngineMasterClient();
            iProductMasterClient   productClient   = new iProductMasterClient();
            iPartRequisitionClient RequsitonClient = new iPartRequisitionClient();

            if (q != null)
            {
                chkProductLst.DataSource = productClient.GetProductofEngine(fdt, tdt, p, q, profile.DBConnection._constr);
                chkProductLst.DataBind();
            }
        }