public void GetCompany()
        {
            DataSet               ds;
            CustomProfile         profile       = CustomProfile.GetProfile();
            iProductMasterClient  productClient = new iProductMasterClient();
            iUCCommonFilterClient objService    = new iUCCommonFilterClient();

            try
            {
                ds = productClient.GetCompanyname(profile.DBConnection._constr);
                List <mCompany> CompanyLst = new List <mCompany>();
                long            UID        = profile.Personal.UserID;
                string          UserType   = profile.Personal.UserType.ToString();
                if (UserType == "Admin")
                {
                    CompanyLst = objService.GetUserCompanyNameNEW(UID, profile.DBConnection._constr).ToList();
                }
                else
                {
                    CompanyLst = objService.GetCompanyName(profile.DBConnection._constr).ToList();
                }
                //ddlcompany.DataSource = ds;
                ddlcompany.DataSource     = CompanyLst;
                ddlcompany.DataTextField  = "Name";
                ddlcompany.DataValueField = "ID";
                ddlcompany.DataBind();
                ListItem lst = new ListItem {
                    Text = "-Select-", Value = "0"
                };
                ddlcompany.Items.Insert(0, lst);
            }
            catch { }
            finally { productClient.Close(); }
        }