public static bool CreateRegion(SqlConnection conn, CarInsuranceRegion region)
{
var sql = @"INSERT INTO Configuration.dbo.CarInsuranceRegion
( ProvinceId ,
ProvinceName ,
CityId ,
CityName ,
InsurancePartnerId
)
VALUES ( @ProvinceId ,
@ProvinceName ,
@CityId ,
@CityName ,
@InsurancePartnerId
);";
var parameters = new SqlParameter[]
{
new SqlParameter("@ProvinceId", region.ProvinceId),
new SqlParameter("@ProvinceName", region.ProvinceName),
new SqlParameter("@CityId", region.CityId),
new SqlParameter("@CityName", region.CityName),
new SqlParameter("@InsurancePartnerId", region.InsurancePartnerId)
};
var count = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters);
return(count > 0);
}
private static CarInsuranceRegion GetRegionInfo(int regionId)
{
using (var client = new Service.Shop.RegionClient())
{
var result = client.GetRegionByRegionId(regionId);
if (!result.Success || result.Result == null)
{
result.ThrowIfException(true);
}
var region = new CarInsuranceRegion();
region.ProvinceId = result.Result.ProvinceId;
region.ProvinceName = result.Result.ProvinceName;
region.CityId = result.Result.CityId == 0 ? region.ProvinceId : result.Result.CityId;
region.CityName = result.Result.CityName == null ? result.Result.ProvinceName : result.Result.CityName;
return(region);
}
}
