public static List <Setup97_ZipCodes> getStateAndCityZip(string zipCode = "") { List <Setup97_ZipCodes> lstCityZip = new List <Setup97_ZipCodes>(); SqlDataReader zipResult = null; if (!string.IsNullOrWhiteSpace(zipCode)) { zipResult = SqlHelper.ExecuteReader(_myConnection, "spATL_CRM_Get_ZipCode", new SqlParameter("@Zipcode", zipCode)); } else { zipResult = SqlHelper.ExecuteReader(_myConnection, CommandType.Text, "Select * from Setup97_ZipCodes"); } while (zipResult.Read()) { Setup97_ZipCodes objZipCodes = new Setup97_ZipCodes(); objZipCodes.State = Convert.ToString(zipResult["State"]); objZipCodes.Town = Convert.ToString(zipResult["Town"]); objZipCodes.StateName = Convert.ToString(zipResult["StateName"]); objZipCodes.Zipcode = Convert.ToString(zipResult["Zipcode"]); lstCityZip.Add(objZipCodes); } zipResult.Close(); return(lstCityZip); }
public static List <Setup97_ZipCodes> getStatesList() { List <Setup97_ZipCodes> lstStates = new List <Setup97_ZipCodes>(); SqlDataReader StatesResult = null; StatesResult = SqlHelper.ExecuteReader(_myConnection, "spddl_State"); while (StatesResult.Read()) { Setup97_ZipCodes objStates = new Setup97_ZipCodes(); objStates.State = Convert.ToString(StatesResult["State"]); objStates.StateName = Convert.ToString(StatesResult["StateName"]); lstStates.Add(objStates); } StatesResult.Close(); return(lstStates); }