public async Task <TypedResult <CityDTO> > Update(UpdateRegionCity regionCity) { try { if (regionCity.Id.Equals(Guid.Empty)) { throw new InvalidOperationException(ErrorMessages.ID_IS_REQUIRED); } RegionCity existsRecord = await regionCityRepo.FindById(regionCity.Id); if (existsRecord == null) { throw new InvalidOperationException(ErrorMessages.THIS_RECORD_DOES_NOT_EXISTS); } existsRecord.RegionStateId = regionCity.StateId; existsRecord.Title = regionCity.Title; RegionCity result = await regionCityRepo.Update(existsRecord); return(new TypedResult <CityDTO>(_mapper.Map <CityDTO>(result))); } catch (Exception ex) { return(new TypedResult <CityDTO>(ex)); } }
public bool AddOrUpdate(RegionCity regionCity, WTCCeresEntities db) { bool isSaved = true; try { db.RegionCity.AddOrUpdate(regionCity); db.SaveChanges(); } catch (Exception e) { isSaved = false; } return(isSaved); }
public void PopulateInfo(int CompanyAddressId) { isCompany = isCompany; LoadForm(); using (var db = new WTCCeresEntities()) { cp = CompanyAddressService.GetById(CompanyAddressId, db); rc = cp.RegionCity; country1ComboBox1.SelectedValue = rc.CountryRegion.CountryId; cboCity.SelectedValue = rc.RegionCityId; address1TextBox2.Text = cp.StreetAddress; locationDescription1TextBox1.Text = cp.AddressDescription; postal1TextBox1.Text = cp.ZipCode; phone1TextBox.Text = cp.Phone; fax1TextBox.Text = cp.Fax; } }
public async Task <TypedResult <bool> > Remove(Guid Id) { try { RegionCity existsRecord = await regionCityRepo.FindById(Id); if (existsRecord == null) { throw new InvalidOperationException(ErrorMessages.THIS_RECORD_DOES_NOT_EXISTS); } Boolean result = await regionCityRepo.Delete(Id); return(new TypedResult <Boolean>(result)); } catch (Exception ex) { return(new TypedResult <Boolean>(ex)); } }
public async Task <TypedResult <CityDTO> > Add(InsertRegionCity regionCity) { try { ICollection <RegionCity> existsRecords = await regionCityRepo .GetList(condition : x => x.RegionStateId == regionCity.StateId && x.Title.Equals(regionCity.Title)); if (existsRecords.Any()) { throw new InvalidOperationException(ErrorMessages.THIS_RECORD_ALREADY_EXISTS); } RegionCity entity = _mapper.Map <RegionCity>(regionCity); RegionCity result = await regionCityRepo.Add(entity); return(new TypedResult <CityDTO>(_mapper.Map <CityDTO>(result))); } catch (Exception ex) { return(new TypedResult <CityDTO>(ex)); } }
public void PopulateInfo(VW_RegionCity vw, bool isNewRecord) { using (var db = new WTCCeresEntities()) { { var withBlock = cboRegionCode; withBlock.DataSource = CountryRegionService.GetByCountryId(vw.CountryId, db); withBlock.DisplayMember = "RegionCode"; withBlock.ValueMember = "CountryRegionId"; } } if (isNewRecord) { tbCityCode.Text = ""; tbCityName.Text = ""; cboRegionCode.SelectedIndex = 0; lblCountry.Text = vw.CountryName; cr = new CountryRegion(); rc = new RegionCity(); cr.CountryId = vw.CountryId; } else { using (var db = new WTCCeresEntities()) { cr = CountryRegionService.GetById(vw.CountryRegionId, db); rc = new RegionCity(); rc = RegionCityService.GetById(vw.RegionCityId, db); cboRegionCode.SelectedValue = vw.CountryRegionId; tbCityCode.Text = vw.CityCode; lblCountry.Text = vw.CountryName; tbCityName.Text = vw.CityName; } } }
public bool AddOrUpdate(RegionCity regionCity, WTCCeresEntities db) { return(repository.AddOrUpdate(regionCity, db)); }