public string CreateZipCode(ZipCode zipCode)
{
Models.zip_code zip = new zip_code();
zip.zip_code1 = zipCode.Zip;
zip.city = zipCode.City;
db.zip_codes.InsertOnSubmit(zip);
try
{
db.SubmitChanges();
return "Ny zip code oprettet: "+ zip.zip_code1;
}
catch (Exception e)
{
return "Oprettelsen af ny zip mislykkedes. Kontakt IT-support med følgende fejlkode: " + e.Message;
}
}
public ZipCode PullZipCode(Company company)
{
var zip = (from z in db.zip_codes
where z.zip_code1 == company.ZipCode
select new ZipCode
{
Id = z.id,
Zip = z.zip_code1,
City = z.city
}).First();
if (zip == null)
{
ZipCode newZip = new ZipCode();
newZip.Zip = company.ZipCode;
newZip.City = company.City;
CreateZipCode(newZip);
zip = PullZipCode(company);
}
return zip;
}