public bool create(RegionModel region) { using (RegionEntities re = new RegionEntities()) { try { Region r = new Region(); ZipCode z = new ZipCode(); r.ID = region.ID; r.Name = region.Name; z.ID = region.ID; z.Start = region.ZipCodes[0].Start; z.End = region.ZipCodes[0].End; re.Regions.Add(r); re.SaveChanges(); re.ZipCodes.Add(z); re.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool Delete(RegionModel Region) { using (RegionEntities re = new RegionEntities()) { try { Region r = re.Regions.Single(reg => reg.ID == Region.ID); ZipCode z = re.ZipCodes.Single(zip => zip.ID == Region.ID); re.Regions.Remove(r); re.ZipCodes.Remove(z); re.SaveChanges(); return(true); } catch (Exception) { return(false); } } }
public bool Edit(RegionModel Region) { using (RegionEntities re = new RegionEntities()) { try { Region r = re.Regions.Single(reg => reg.ID == Region.ID); r.ID = Region.ID; r.Name = Region.Name; ZipCode z = re.ZipCodes.Single(zip => zip.ID == Region.ID); z.Start = Region.ZipCodes[0].Start; z.End = Region.ZipCodes[0].End; re.SaveChanges(); return(true); } catch (Exception) { return(false); } } }