/// <summary> /// Ajusta el pais del dealer /// </summary> /// <param name="dealerCountry"></param> /// <returns></returns> internal String AjusCountrie(String dealerCountry) { String idCountrySystime = ConstantsSystimeDataAccess.ID_COUNTRY_UNKONOWN;//valor apra la ciudad desconocida using (DmsV1Entities dbErp = new DmsV1Entities(ParamsContract.ConectionStringErp)) { dbErp.Database.CommandTimeout = 1000; y_paises countryDealer; if (!String.IsNullOrEmpty(dealerCountry)) { if (int.TryParse(dealerCountry, out int idCityCatalogDms)) { countryDealer = dbErp.y_paises.FirstOrDefault(p => p.pais == dealerCountry); } else { countryDealer = dbErp.y_paises.FirstOrDefault(p => p.descripcion == dealerCountry); } if (!String.IsNullOrEmpty(countryDealer?.descripcion)) { using (SystimedbEntities dbSystime = new SystimedbEntities(ParamsContract.ConectionStringSystime)) { List <String> countries = dbSystime.AjustCountry(ParamsContract.Language, countryDealer.descripcion).ToList(); if (countries?.Count == 1) { idCountrySystime = countries[0]; } } } } return(idCountrySystime); } }
/// <summary> /// Metodo encargado de ajustar el jobtitle /// </summary> /// <param name="actividad_cree"></param> /// <returns></returns> internal string AjustJobTitle(string actividad_cree, Boolean isDealerRepresentative) { if (isDealerRepresentative) { return(ConstantsSystimeDataAccess.DEALER_REPRESENTATIVE_DEGAULT_JOB_TITLE); } if (!String.IsNullOrEmpty(actividad_cree)) { SystimedbEntities systimedb = new SystimedbEntities(ParamsContract.ConectionStringSystime); CatalogJobTitleByDealer jobtitle = systimedb.CatalogJobTitleByDealer.FirstOrDefault(j => j.IdJobTitle.ToUpper() == actividad_cree.ToUpper()); if (jobtitle != null) { return(jobtitle.IdJobTitle); } systimedb.Dispose(); } return(ConstantsSystimeDataAccess.ID_JOB_TITLE_DEFAULT); }