public Domain.ZipCode GetZipCode(string zipCode)
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
//var query = context.ZipCodes.Where(z => z.ZIPCode == zipCode);
var linqZip = context.ZipCodes.SingleOrDefault(z => z.ZIPCode == zipCode);
if (linqZip != null)
{
Domain.ZipCode zip = new Domain.ZipCode();
zip.ID = linqZip.ID;
zip.ZipCodeName = linqZip.ZIPCode;
zip.State = linqZip.State;
zip.City = linqZip.City;
return(zip);
}
else
{
Domain.ZipCode zip = new Domain.ZipCode();
zip.City = "Not Found";
return(zip);
}
}
}
public Domain.ZipCode GetZipCode(string zipCode)
{
using (ConnectionScope.Enter())
{
DataMapper.EntitiesDataContext context = DataMapper.DataHelper.CreateDataContext();
//var query = context.ZipCodes.Where(z => z.ZIPCode == zipCode);
var linqZip = context.ZipCodes.SingleOrDefault(z => z.ZIPCode == zipCode);
if (linqZip != null)
{
Domain.ZipCode zip = new Domain.ZipCode();
zip.ID = linqZip.ID;
zip.ZipCodeName = linqZip.ZIPCode;
zip.State = linqZip.State;
zip.City = linqZip.City;
return zip;
}
else
{
Domain.ZipCode zip = new Domain.ZipCode();
zip.City = "Not Found";
return zip;
}
}
}
