public static List <CompanyJsonModel> GetCompanyList(int nCtype, string strCompanyName)
        {
            List <CompanyJsonModel> lstcjModel = new List <CompanyJsonModel>();
            CompanyJsonModel        cjModel    = null;
            //string strSql = "SELECT COMPANYID,COMPANYNAME FROM USER_APP_COMPANY WHERE COMPANYNAME LIKE :COMPANYNAME ";
            //if (nCtype == int.Parse(ShareEnum.CompanyType.YgCompany.ToString("d")))
            //{
            string strSql = "SELECT COMPANYID,GROUPIDN,COMPNAME AS COMPANYNAME  FROM USER_WEB_YGCOMPANY WHERE COMPNAME LIKE :COMPANYNAME AND DELETED=0 ";
            //}
            ParamList param = new ParamList();

            param["COMPANYNAME"] = "%" + strCompanyName + "%";
            DataTable dtCompany = StaticConnectionProvider.ExecuteDataTable(strSql, param, GlobalConsts.DB_46PLAT);

            if (dtCompany != null)
            {
                foreach (DataRow dr in dtCompany.Rows)
                {
                    cjModel             = new CompanyJsonModel();
                    cjModel.CompanyId   = ValidatorHelper.ToInt(dr["COMPANYID"], 0);
                    cjModel.CompanyName = CommonMethod.FinalString(dr["COMPANYNAME"]);
                    cjModel.GroupIdn    = CommonMethod.FinalString(dr["GROUPIDN"]);
                    lstcjModel.Add(cjModel);
                }
            }
            return(lstcjModel);
        }
Beispiel #2
0
        public CompanyModel GetCompanyById(string id)
        {
            using (var client = new HttpClient())
            {
                client.Timeout = TimeSpan.FromMinutes(1);
                client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
                try
                {
                    var company = new CompanyJsonModel();
                    switch (NipRegonValidator.IsValid(id))
                    {
                    case (int)NumberType.nip:
                        company = GetByNipAsync(client, id);
                        break;

                    case (int)NumberType.krs:
                        company = GetByRegonAsync(client, id);
                        break;

                    case (int)NumberType.regon:
                        company = GetByKrsAsync(client, id);
                        break;
                    }
                    return(Mapper.Map <CompanyModel>(company));
                }
                catch (HttpRequestException e)
                {
                    throw e;
                }
            }
        }