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