public List <RegionEntity> GetAll() { try { // List <RegionEntity> regionEntities = new List <RegionEntity>(); CondominiumManagementSystemDBEntities entity = new CondominiumManagementSystemDBEntities(); List <tblRegion> regions = entity.tblRegions.ToList(); foreach (tblRegion region in regions) { RegionEntity regionEntity = new RegionEntity(); regionEntity.ID = region.ID; regionEntity.TItle = region.TItle; regionEntities.Add(regionEntity); } return(regionEntities); } catch (Exception ex) { return(null); } }
protected void MasterPage_YesClickHandler(object sender, EventArgs e) { if (ViewState["Delete"] != null) { try { RegionEntity entity = new RegionEntity(); entity.OperationId = (int)OperationType.Delete; entity.RegionId = Utility.GetLong(ViewState["RegionId"]); OperationStatusEntity c = new ConfigrationRepository(SessionContext).UpdateRegion(entity); if (c.StatusResult == true) { ShowInfoMessage(c.InfoMessage); ClearPageControl(); FillGrid(); } else { ShowErrorMessage(c.InfoMessage); } } catch (BaseException bex) { ShowErrorMessage(bex.Message); } } }
/// <summary> /// Handles the RowCommand event of the theGrid control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.Web.UI.WebControls.GridViewCommandEventArgs"/> instance containing the event data.</param> protected void theGrid_RowCommand(object sender, GridViewCommandEventArgs e) { switch (e.CommandName) { case "EditExisting": case "ViewExisting": break; default: // apparently another command, return return; } int index = Convert.ToInt32(e.CommandArgument); RegionEntity selectedEntity = (RegionEntity)_RegionDS.EntityCollection[index]; StringBuilder pkFieldsAndValues = new StringBuilder(); pkFieldsAndValues.AppendFormat("&RegionId={0}", selectedEntity.RegionId); switch (e.CommandName) { case "EditExisting": Response.Redirect("~/EditExisting.aspx?EntityType=" + (int)EntityType.RegionEntity + pkFieldsAndValues.ToString()); break; case "ViewExisting": Response.Redirect("~/ViewExisting.aspx?EntityType=" + (int)EntityType.RegionEntity + pkFieldsAndValues.ToString()); break; } }
/// <summary> /// 增加一条记录,返回新的ID号。需要有一个单一主键,并且开启有标识符属性(异步方式) /// </summary> /// <param name="entity">实体模型</param> /// <returns></returns> public virtual async Task <int> InsertAsync(RegionEntity entity) { Dictionary <string, object> dict = new Dictionary <string, object>(); GetParameters(entity, dict); string strSQL = "insert into Region (" + "Country," + "Province," + "City," + "Area," + "Area1," + "Area2," + "PostCode," + "AreaCode) " + "values(" + "@Country," + "@Province," + "@City," + "@Area," + "@Area1," + "@Area2," + "@PostCode," + "@AreaCode)"; return(await Task.Run(() => _DB.ReturnID(strSQL, dict))); }
/// <summary> /// 增加一条记录 /// </summary> /// <param name="entity">实体模型</param> /// <returns></returns> public virtual bool Add(RegionEntity entity) { Dictionary <string, object> dict = new Dictionary <string, object>(); GetParameters(entity, dict); string strSQL = "insert into Region (" + "Country," + "Province," + "City," + "Area," + "Area1," + "Area2," + "PostCode," + "AreaCode) " + "values(" + "@Country," + "@Province," + "@City," + "@Area," + "@Area1," + "@Area2," + "@PostCode," + "@AreaCode)"; return(_DB.ExeSQLResult(strSQL, dict)); }
private void SaveDataToDataBase(RegionEntity re) { string message; if (re.Id == 0) { re.CountryId = int.Parse(ddlCountry.SelectedValue); using (var dataAccess = new MappingDeleteAndCreate()) { message = dataAccess.CreateNewRegion(re); } } else { using (var dataAccess = new MappingSingleUpdate()) { message = dataAccess.UpdateRegion(re); } } ProcessDatabaseReply(message, UpdateRegionSuccess, AdminMappingEnum.OpsRegion, lblMessage); if (message == string.Empty) { ToggleEnableForValidators(false); } }
public static Region ToDto(this RegionEntity entity, Hashtable seenObjects, Hashtable parents) { OnBeforeEntityToDto(entity, seenObjects, parents); var dto = new Region(); if (entity != null) { if (seenObjects == null) { seenObjects = new Hashtable(); } seenObjects[entity] = dto; parents = new Hashtable(parents) { { entity, null } }; // Map dto properties dto.RegionId = entity.RegionId; dto.RegionDescription = entity.RegionDescription; // Map dto associations // 1:n Territories association of Territory entities if (entity.Territories != null && entity.Territories.Any()) { dto.Territories = new TerritoryCollection(entity.Territories.RelatedArray(seenObjects, parents)); } } OnAfterEntityToDto(entity, seenObjects, parents, dto); return(dto); }
public static Task <bool> CanDeleteMembershipsAsync( this IUserAuthorizationService userAuthorizationService, RegionEntity regionEntity, string regionRoleId, string userEmail) => userAuthorizationService.IsAuthorizedAsync( regionEntity, RegionOperationRequirement.DeleteMemberships(regionRoleId, userEmail));
public async Task <RegionEntity> Add(RegionEntity element) { await _dbContext.Regions.AddAsync(element); await _dbContext.SaveChangeAsync(); return(element); }
/// <summary>Creates a new, empty RegionEntity object.</summary> /// <returns>A new, empty RegionEntity object.</returns> public override IEntity Create() { IEntity toReturn = new RegionEntity(); // __LLBLGENPRO_USER_CODE_REGION_START CreateNewRegion // __LLBLGENPRO_USER_CODE_REGION_END return(toReturn); }
public OperationStatusEntity UpdateRegion(RegionEntity param) { var parameters = new object[] { param.OperationId, param.RegionId, param.RegionName }; return(EntityBase.FillObject <OperationStatusEntity>("RegionManage", parameters)); }
public static Region ToCore(this RegionEntity data) { if (data == null) { return(null); } var locations = JsonConvert.DeserializeObject <ICollection <PointLatLng> >(data.PointsJson); return(new Region(data.Id, data.Name, data.ColorHex, locations)); }
private void FindAndPlaceInSubregion(RegionEntity regionEntity) { foreach (var region in _subRegions) { if (region.ContainsPoint(regionEntity.position)) { region.AddRegionEntity(regionEntity); break; } } }
public bool HasPermission( ClaimsPrincipal user, RegionEntity region, RegionPermission permission, IEnumerable <RegionRoleEntity> regionRoles) { var regionRolesById = regionRoles.ToDictionary(r => r.Id); var regionMembershipsByRegionId = user.GetRegionMembershipRoles().ToLookup(r => r.RegionId); return(HasPermission(permission, region, regionRolesById, regionMembershipsByRegionId, isParentOfTargetRegion: false)); }
public async Task <RegionEntity> Find(int id) { RegionEntity Region = new RegionEntity(); findRegionResponse Response = await this.Service.findRegionAsync(id); Region.Id_Region = (int)[email protected]; Region.Nombre_Region = [email protected]; Region.Pais = await this.PaisService.Find([email protected]); return(Region); }
protected void bnSavePopup_Click(object sender, EventArgs e) { var re = new RegionEntity { Id = int.Parse(hfRegionId.Value), RegionName = tbRegionName.Text, Active = cbActive.Checked }; SaveDataToDataBase(re); }
private RegionDTO ToDTO(RegionEntity region) { RegionDTO dto = new RegionDTO(); dto.CityId = region.CityId; dto.CityName = region.City.Name; dto.CreateDateTime = region.CreateDateTime; dto.Id = region.Id; dto.Name = region.Name; return(dto); }
private RegionDTO ToDTO(RegionEntity entity) { RegionDTO dto = new RegionDTO(); dto.CityName = entity.City.Name; dto.Id = entity.Id; dto.CityId = entity.Id; dto.CreateDateTime = entity.CreateDateTime; dto.Name = entity.Name; return(dto); }
public RegionDTO Entity2DTO(RegionEntity regionEntity) { return(new RegionDTO() { Id = regionEntity.Id, CityId = regionEntity.CityId, CityName = regionEntity.City.Name, CreateDateTime = regionEntity.CreateDateTime, Name = regionEntity.Name }); }
public void AddNew(string name, long cityId) { using (ZSZDbContext ctx = new ZSZDbContext()) { RegionEntity region = new RegionEntity(); region.CityId = cityId; region.Name = name; ctx.Regions.Add(region); ctx.SaveChanges(); } }
private RegionDTO ToDTO(RegionEntity regionEntity) { RegionDTO regionDto = new RegionDTO(); regionDto.CityName = regionEntity.CityEntity.Name; regionDto.CityId = regionEntity.CityId; regionDto.Name = regionEntity.Name; regionDto.Id = regionEntity.Id; regionDto.CreateDateTime = regionEntity.CreateDateTime; return(regionDto); }
/// <summary> /// 把实体类转换成键/值对集合 /// </summary> /// <param name="entity"></param> /// <param name="dict"></param> private static void GetParameters(RegionEntity entity, Dictionary <string, object> dict) { dict.Add("RegionID", entity.RegionID); dict.Add("Country", entity.Country); dict.Add("Province", entity.Province); dict.Add("City", entity.City); dict.Add("Area", entity.Area); dict.Add("Area1", entity.Area1); dict.Add("Area2", entity.Area2); dict.Add("PostCode", entity.PostCode); dict.Add("AreaCode", entity.AreaCode); }
public long Add(string name, long cityId) { using (ZSZDbContext ctx = new ZSZDbContext()) { RegionEntity regionEntity = new RegionEntity(); regionEntity.Name = name; regionEntity.CityId = cityId; ctx.Regions.Add(regionEntity); ctx.SaveChanges(); return(regionEntity.Id); } }
public int CreateRegion(RegionEntity regionEntity) { var region = new Region { Name = regionEntity.Name }; _unitOfWork.RegionRepository.Insert(region); _unitOfWork.Save(); return(region.RegionId); }
protected async Task <bool> IsAuthorizedAsync(RegionEntity region, IAuthorizationRequirement requirement) { var identity = new ClaimsIdentity(); identity.AddClaim(new Claim("sub", Guid.NewGuid().ToString())); identity.AddClaim(new Claim("email", Email)); _regionMembershipRoleClaimValues.ForEach(rm => identity.AddRegionMembershipRole(rm)); var principal = new ClaimsPrincipal(identity); return((await _authorizationService.AuthorizeAsync(principal, region, requirement)).Succeeded); }
public async Task <ActionResult> RegionEdit(int id = 0, RegionEntity model = null, IFormCollection collection = null) { if (string.IsNullOrEmpty(model.Country)) { ModelState.AddModelError(string.Empty, "国家名称不能为空"); return(View(model)); } if (string.IsNullOrEmpty(model.Province)) { ModelState.AddModelError(string.Empty, "省份名称不能为空"); return(View(model)); } if (string.IsNullOrEmpty(model.City)) { ModelState.AddModelError(string.Empty, "城市名称不能为空"); return(View(model)); } if (string.IsNullOrEmpty(model.PostCode)) { ModelState.AddModelError(string.Empty, "邮政编码不能为空"); return(View(model)); } if (string.IsNullOrEmpty(model.AreaCode)) { ModelState.AddModelError(string.Empty, "区号不能为空"); return(View(model)); } if (id <= 0) { #region 添加 if (!await _RegionServiceApp.AddAsync(model)) { ModelState.AddModelError(string.Empty, "添加失败"); return(View(model)); } id = model.RegionID; #endregion } else { #region 修改 model.RegionID = id; if (!await _RegionServiceApp.UpdateAsync(model)) { ModelState.AddModelError(string.Empty, "修改失败"); return(View(model)); } #endregion } Utility.WriteMessage("操作成功", "mRefresh"); return(View(model)); }
public RegionDTO GetDTO(RegionEntity entity) { RegionDTO region = new RegionDTO() { CityId = entity.CityId, CityName = entity.City.Name, Name = entity.Name, CreateDateTime = entity.CreateDateTime, Id = entity.Id }; return(region); }
public int SaveRegion(Region region) { NorthwindEntities context = new NorthwindEntities(); RegionEntity r = new RegionEntity() { RegionID = region.RegionID, RegionDescription = region.RegionDescription }; context.RegionEntities.Add(r); return(context.SaveChanges()); }
public void Save(Region region) { using (var db = GetDbContext()) { RegionEntity dbRegion; var timeStamp = DateTime.UtcNow; if (region.Id != Guid.Empty) { dbRegion = db.Regions.SingleOrDefault(g => g.Id == region.Id); if (dbRegion == null) { throw new Exception("Region could not be found"); } dbRegion.Locations.Clear(); } else { dbRegion = new RegionEntity { Id = Guid.NewGuid(), CreatedBy = region.CreatedBy, CreatedOn = timeStamp, Locations = new Collection <LocationEntity>() }; region.Id = dbRegion.Id; region.CreatedOn = dbRegion.CreatedOn; db.Regions.Add(dbRegion); } dbRegion.Name = region.Name; dbRegion.UpdatedBy = region.UpdatedBy; dbRegion.UpdatedOn = timeStamp; region.UpdatedOn = dbRegion.UpdatedOn; // Add relations foreach (var location in region.Locations) { var dbLocation = db.Locations.SingleOrDefault(l => l.Id == location.Id); if (dbLocation != null) { dbRegion.Locations.Add(dbLocation); } } db.SaveChanges(); } }
/// <summary> /// Creates a region entity with a random Id and name /// </summary> /// <returns>region entity</returns> public static RegionEntity FakeRegionEntity() { RegionEntity region = new RegionEntity() { Id = Guid.NewGuid().ToString(), RegionName = Guid.NewGuid().ToString(), ObaBaseUrl = string.Empty, RecordType = RecordType.Region.ToString(), RowState = DataRowState.Default.ToString(), RawContent = string.Empty }; return(region); }