public string UpdateArea(AreaEntity ae)
{
var areaAlreadyExistsInRegion =
AreaEntityCheck.DoesAreaNameExistForRegion(DataContext, ae.AreaName,
ae.RegionId, ae.Id);
if (areaAlreadyExistsInRegion)
{
return(AreaEntityCheck.AreaAlreadyExistsForCountry);
}
var areaDbEntry =
DataContext.OPS_AREAs.Single(d => d.ops_area_id == ae.Id);
areaDbEntry.ops_region_id = ae.RegionId;
areaDbEntry.ops_area1 = ae.AreaName;
areaDbEntry.isActive = ae.Active;
var returned = SubmitDbChanges();
return(returned);
}
public string CreateNewArea(AreaEntity ae)
{
var areaAlreadyExistsInRegion =
AreaEntityCheck.DoesAreaNameExistForRegion(DataContext, ae.AreaName,
ae.RegionId);
if (areaAlreadyExistsInRegion)
{
return(AreaEntityCheck.AreaAlreadyExistsForCountry);
}
var newAreaEntity = new OPS_AREA
{
isActive = true,
ops_area1 = ae.AreaName,
ops_region_id = ae.RegionId,
};
DataContext.OPS_AREAs.InsertOnSubmit(newAreaEntity);
var returned = SubmitDbChanges();
return(returned);
}
