public static List <Country> GetCountryForAutocomplete(int?start, int?numItems, string filter, string idiomaId, ref int?totalRows) { List <Country> theList = new List <Country>(); Country theData = null; try { CountryTableAdapter localAdapter = new CountryTableAdapter(); CountryDS.CountryDataTable theTable = localAdapter.GetCountryForAutocomplete(numItems, start, filter, idiomaId, ref totalRows); if (theTable != null && theTable.Rows.Count > 0) { foreach (CountryDS.CountryRow theRow in theTable.Rows) { theData = FillRecord(theRow); theList.Add(theData); } } } catch (Exception exc) { log.Error("Ocurrió un error al obtener la lista de Departamentos de la Base de Datos", exc); throw exc; } return(theList); }
public static Country GetRecordById(string countryId, string idiomaId) { CountryTableAdapter localAdapter = new CountryTableAdapter(); if (string.IsNullOrEmpty(countryId)) { throw new ArgumentException("El identificador countryId no puede ser null o vacio"); } if (string.IsNullOrEmpty(idiomaId)) { throw new ArgumentException("El identificador idiomaId no puede ser null o vacio"); } Country theData = null; try { CountryDS.CountryDataTable theTable = localAdapter.GetCountryById(countryId, idiomaId); if (theTable != null && theTable.Rows.Count > 0) { CountryDS.CountryRow theRow = theTable[0]; theData = FillRecord(theRow); } } catch (Exception exc) { log.Error("Ocurrió un error mientras se obtenía el country de id =" + countryId, exc); throw exc; } return(theData); }