public void Delete(Region item)
{
var query = (from d in _context.Regions
where d.RegionID == item.RegionID
select d).FirstOrDefault();
_context.Regions.Remove(query);
_context.SaveChanges();
}
public void ImportRegion(RegionData regionData)
{
logger.Info("Entering ImportRegion");
logger.Debug(regionData);
Random rnd = new Random();
foreach (RegionDataRegion regiondata in regionData.Region)
{
double[] coords = _geodataserviceagent.EncodeCoordinates(regiondata.Address.PostalCode, regiondata.Address.City, regiondata.Address.Street);
Region region = new Region(rnd.Next(1, 1000000000), regiondata.Key, regiondata.DisplayName, regiondata.Address.PostalCode, regiondata.Address.City, coords[0], coords[1]);
_regionrepository.Add(region);
}
logger.Info("Exiting ImportRegion");
}
public void ImportRegion(string s)
{
logger.Info("Entering ImportRegion");
logger.Debug(s);
XmlReaderSettings readerSettings = new XmlReaderSettings();
readerSettings.IgnoreWhitespace = true;
readerSettings.IgnoreComments = true;
readerSettings.ValidationType = ValidationType.Schema;
readerSettings.Schemas.Add(null, @"XmlRegionImportSchema.xsd");
readerSettings.ValidationEventHandler += ValidationCallback;
XmlReader reader = XmlReader.Create(new StringReader(s), readerSettings);
Region region = null;
try
{
while (reader.Read())
{
string key = null;
string displayname = null;
string street = null;
string postalcode = null;
string city = null;
switch (reader.Name)
{
case "Region":
if (reader.HasAttributes)
{
while (reader.MoveToNextAttribute())
{
if (reader.Name == "Key")
key = reader.Value;
}
}
break;
case "DisplayName":
displayname = reader.ReadString();
break;
case "Street":
street = reader.ReadString();
break;
case "PostalCode":
postalcode = reader.ReadString();
break;
case "City":
city = reader.ReadString();
break;
}
double[] coords = _geodataserviceagent.EncodeCoordinates(postalcode, city, street);
region = new Region(0, key, displayname, postalcode, city, coords[0], coords[1]);
_regionrepository.Add(region);
}
}
catch(Exception ex)
{
logger.Error("Parsing failed", ex);
throw new ServiceException("Parsing failed", ex);
}
reader.Close();
logger.Info("Exiting ImportRegion");
}
public void Update(Region item)
{
var query = (from d in _context.Regions
where d.RegionID == item.RegionID
select d).FirstOrDefault();
//query.RegionID = item.RegionID;
query.City = item.City;
query.DisplayName = item.DisplayName;
query.PostalCode = item.PostalCode;
query.RegionKey = item.RegionKey;
query.Street = item.Street;
query.Latitude = item.Latitude;
query.Longitude = item.Longitude;
_context.SaveChanges();
}
public void Add(Region item)
{
_context.Regions.Add(item);
_context.SaveChanges();
}
