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