public string UpdateRegion(RegionEntity re)
{
var countryId = DataContext.OPS_REGIONs.Single(d => d.ops_region_id == re.Id).COUNTRy1.CountryId;
var poolAlreadyExistsInCountry = RegionEntityCheck.DoesRegionNameExistForCountry(DataContext, re.RegionName,
countryId, re.Id);
if (poolAlreadyExistsInCountry)
{
return(RegionEntityCheck.RegionAlreadyExistsForCountry);
}
var regionDbEntry = DataContext.OPS_REGIONs.Single(d => d.ops_region_id == re.Id);
regionDbEntry.ops_region1 = re.RegionName;
regionDbEntry.isActive = re.Active;
var returned = SubmitDbChanges();
return(returned);
}
public string CreateNewRegion(RegionEntity re)
{
var regionAlreadyExistsInCountry = RegionEntityCheck.DoesRegionNameExistForCountry(DataContext, re.RegionName,
re.CountryId);
if (regionAlreadyExistsInCountry)
{
return(PoolEntityCheck.PoolAlreadyExistsForCountry);
}
var countryCode = DataContext.COUNTRies.Single(d => d.CountryId == re.CountryId).country1;
var newRegionEnitiy = new OPS_REGION
{
isActive = true,
ops_region1 = re.RegionName,
country = countryCode,
};
DataContext.OPS_REGIONs.InsertOnSubmit(newRegionEnitiy);
var returned = SubmitDbChanges();
return(returned);
}