private void fillsuppliers(string productCategory)
        {
            ddlSupplierName.Items.Clear();
            ddlPriority.Items.Clear();
            var res = _objMasterSVC.GetSuppliersByProductCategory(productCategory);

            //for allsupplier
            // var res = _objMasterSVC.GetSupplierMasterData();
            ddlSupplierName.DataSource     = res;
            ddlSupplierName.DataValueField = "Supplier_Id";
            ddlSupplierName.DataTextField  = "Name";
            ddlSupplierName.DataBind();
            ddlSupplierName.Items.Insert(0, new ListItem {
                Text = "--All Suppliers--", Value = "0"
            });
            //for Priority
            ddlPriority.DataSource     = (from r in res orderby r.Priority select new { Priority = r.Priority }).Distinct().ToList();
            ddlPriority.DataValueField = "Priority";
            ddlPriority.DataTextField  = "Priority";
            ddlPriority.DataBind();
            ddlPriority.Items.Remove(ddlPriority.Items.FindByValue("0"));
            ddlPriority.Items.Insert(0, new ListItem {
                Text = "--All Priority--", Value = "0"
            });
        }