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