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