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); }
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; } } }