/// <summary> /// Check if demographic record exists for given full name and zip code. /// </summary> /// <param name="FullName">Full name (first and last name)</param> /// <param name="ZipCode">Zip Code (12345 or 12345-1234)</param> /// <returns></returns> public bool IsExists(string FullName, string ZipCode) { bool exists = false; int recordCount = 0; try { recordCount = (from demo in m_dcNamesAndZipCodes.Demographics where (FullName.Trim() == "" || (FullName.Trim().ToLower() != "" && demo.FirstName.Trim().ToLower() + " " + demo.LastName.Trim().ToLower() == FullName.ToLower())) && (ZipCode.Trim() == "" || (ZipCode.Trim() != "" && ZipCode.IndexOf('-') < 1 && DemographicUtils.Get5DigitZipCode(demo.ZipCode.Trim()) == ZipCode.Trim()) || (ZipCode.Trim() != "" && ZipCode.IndexOf('-') > 0 && demo.ZipCode.Trim() == ZipCode.Trim())) select GetDemographicDataEntity(demo)).ToList().Count(); if (recordCount > 0) { exists = true; } else { exists = false; } return(exists); } catch (Exception) { throw; } }
/// <summary> /// Get Demographics by zip code. /// </summary> /// <param name="ZipCode">Zip Code (12345 or 12345-1234)</param> /// <returns></returns> public List <string> GetDemographicsbyZipCode(string ZipCode) { try { //returns a list of demographic entities data, tries to use 5 digit //zip code comparison if parameter value does not contain a '-'. return((from demo in m_dcNamesAndZipCodes.Demographics where ZipCode.Trim() == "" || (ZipCode.Trim() != "" && ZipCode.IndexOf('-') < 1 && DemographicUtils.Get5DigitZipCode(demo.ZipCode.Trim()) == ZipCode.Trim()) || (ZipCode.Trim() != "" && ZipCode.IndexOf('-') > 0 && demo.ZipCode.Trim() == ZipCode.Trim()) select demo.FirstName + " " + demo.LastName).Distinct().ToList()); } catch (Exception) { throw; } }