public async Task <APIResult> GetRegion(int regionId)
{
return(new APIResult()
{
Result = 0,
Data = await regionQueries.Get(regionId)
});
}
public override async Task <int> HandleCommand(UpdateCommand request, CancellationToken cancellationToken)
{
if (request.Province == null || request.Province.Id == 0)
{
throw new BusinessException("Region.NotExisted");
}
var province = await provinceQueries.Get(request.Province.Id);
if (province == null)
{
throw new BusinessException("Province.NotExisted");
}
var checkingProvince = (await provinceQueries.Gets($"p.code = '{request.Province.Code}' and p.id <> {province.Id} and p.is_deleted = 0")).FirstOrDefault();
if (checkingProvince != null)
{
throw new BusinessException("Province.ExistedCode");
}
var country = await countryQueries.Get(request.Province.CountryId);
if (country == null)
{
throw new BusinessException("Country.NotExisted");
}
if (request.Province.RegionId != null)
{
var region = await regionQueries.Get(request.Province.RegionId.Value);
if (region == null || region.CountryId != request.Province.CountryId)
{
throw new BusinessException("Region.NotExisted");
}
}
province = UpdateBuild(province, request.LoginSession);
province.Code = request.Province.Code;
province.Name = request.Province.Name;
province.PhoneCode = request.Province.PhoneCode;
province.CountryId = request.Province.CountryId;
province.RegionId = request.Province.RegionId;
province.IsUsed = request.Province.IsUsed;
var rs = await provinceRepository.Update(province);
return(rs);
}
public override async Task <int> HandleCommand(UpdateCommand request, CancellationToken cancellationToken)
{
if (request.Region == null || request.Region.Id == 0)
{
throw new BusinessException("Region.NotExisted");
}
var region = await regionQueries.Get(request.Region.Id);
if (region == null)
{
throw new BusinessException("Region.NotExisted");
}
var checkingRegion = (await regionQueries.Gets($"r.code = '{request.Region.Code}' and r.id <> {region.Id} and r.is_deleted = 0")).FirstOrDefault();
if (checkingRegion != null)
{
throw new BusinessException("Region.ExistedCode");
}
var country = await countryQueries.Get(request.Region.CountryId);
if (country == null)
{
throw new BusinessException("Country.NotExisted");
}
region = UpdateBuild(region, request.LoginSession);
region.Code = request.Region.Code;
region.Name = request.Region.Name;
region.CountryId = request.Region.CountryId;
region.IsUsed = request.Region.IsUsed;
var rs = await regionRepository.Update(region);
return(rs);
}
public override async Task <int> HandleCommand(AddCommand request, CancellationToken cancellationToken)
{
if (request.Province == null || string.IsNullOrEmpty(request.Province.Code))
{
throw new BusinessException("AddWrongInformation");
}
var province = (await provinceQueries.Gets($"p.code = '{request.Province.Code}' and p.is_deleted = 0")).FirstOrDefault();
if (province != null)
{
throw new BusinessException("Province.ExistedCode");
}
var country = await countryQueries.Get(request.Province.CountryId);
if (country == null)
{
throw new BusinessException("Country.NotExisted");
}
if (request.Province.RegionId != null)
{
var region = await regionQueries.Get(request.Province.RegionId.Value);
if (region == null || region.CountryId != request.Province.CountryId)
{
throw new BusinessException("Region.NotExisted");
}
}
request.Province = CreateBuild(request.Province, request.LoginSession);
var rs = await provinceRepository.Add(request.Province);
return(rs == 0 ? -1 : 0);
}
