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