protected void grdUser_ItemCommand(object source, DataGridCommandEventArgs e)
{
string strCA = e.CommandArgument.ToString();
switch (e.CommandName)
{
case "Edit":
Insert = false;
Id = strCA;
List <CityInfo> ListCity = CityService.CityInfo_GetByAll();
List <DistrictInfo> Listdistric = DistrictService.DistrictInfo_GetById(Id);
txtDistrictID.Text = Listdistric[0].DistrictID;
//ddlCity.SelectedIndex = ListCity[0].
txtDistrictName.Text = Listdistric[0].DistrictName;
pnView.Visible = false;
pnUpdate.Visible = true;
break;
case "Delete":
DistrictService.DistrictInfo_Delete(strCA);
BindGrid();
break;
}
}
static void Main(string[] args)
{
Console.OutputEncoding = Encoding.UTF8;
var db = new RealEstateDbContext();
db.Database.Migrate();
// Top districts by AvgPrice
IDistrictsService districtsService = new DistrictService(db);
var districts = districtsService.GetTopDistrictsByAveragePrice();
foreach (var district in districts)
{
Console.WriteLine($"{district.Name} => Average price: {district.AveragePrice:0.00} ({district.MinPrice} - {district.MaxPrice}) => {district.PropertiesCount} properties.");
}
// Search by price
IPropertiesService propertiesService = new PropertyService(db);
Console.Write("Enter min price: ");
int minPrice = int.Parse(Console.ReadLine());
Console.Write("Enter max price: ");
int maxPrice = int.Parse(Console.ReadLine());
var properties = propertiesService.SearchByPrice(minPrice, maxPrice);
foreach (var property in properties)
{
Console.WriteLine($"{property.District}, Тип имот: {property.PropertyType}, Строеж: {property.BuildingType}, Етаж: {property.Floor}, Размер: {property.Size}m2, Година: {property.Year}г., Цена: {property.Price}лв.");
}
}
public async Task <ActionResult <List <Contract_DistrictDTO> > > SingleListDistrict([FromBody] Contract_DistrictFilterDTO Contract_DistrictFilterDTO)
{
if (UnAuthorization)
{
return(Forbid());
}
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
DistrictFilter DistrictFilter = new DistrictFilter();
DistrictFilter.Skip = 0;
DistrictFilter.Take = 20;
DistrictFilter.OrderBy = DistrictOrder.Id;
DistrictFilter.OrderType = OrderType.ASC;
DistrictFilter.Selects = DistrictSelect.ALL;
DistrictFilter.Id = Contract_DistrictFilterDTO.Id;
DistrictFilter.Code = Contract_DistrictFilterDTO.Code;
DistrictFilter.Name = Contract_DistrictFilterDTO.Name;
DistrictFilter.Priority = Contract_DistrictFilterDTO.Priority;
DistrictFilter.ProvinceId = Contract_DistrictFilterDTO.ProvinceId;
DistrictFilter.StatusId = new IdFilter {
Equal = StatusEnum.ACTIVE.Id
};
List <District> Districts = await DistrictService.List(DistrictFilter);
List <Contract_DistrictDTO> Contract_DistrictDTOs = Districts
.Select(x => new Contract_DistrictDTO(x)).ToList();
return(Contract_DistrictDTOs);
}
public void GetDistrictsPaged_Success_Test()
{
// Arrange
string searchTerm = "";
int pageIndex = 0;
int pageSize = 10;
// list
IList <R_District> list = new List <R_District>();
for (int i = 1; i <= pageSize; i++)
{
list.Add(SampleDistrict(i));
}
// create mock for repository
var mock = new Mock <IDistrictRepository>();
mock.Setup(s => s.GetDistricts(Moq.It.IsAny <string>(), Moq.It.IsAny <int>(), Moq.It.IsAny <int>())).Returns(list);
// service
DistrictService districtService = new DistrictService();
DistrictService.Repository = mock.Object;
// Act
var resultList = districtService.GetDistricts(searchTerm, pageIndex, pageSize);
DistrictDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.DistrictId);
Assert.AreEqual(10, resultList.Count);
}
void BindDistrictReporter()
{
ddlDistrictReporter.Items.Clear();
IList <District> list = new List <District>();
if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_District_All))
{
list = new DistrictService().FindAll();
AspNetCache.SetCache(Constants.Cache_ReportFuel_District_All, list);
}
else
{
list = (IList <District>)AspNetCache.GetCache(Constants.Cache_ReportFuel_District_All);
}
if (ddlProvinceReporter.SelectedIndex > 0)
{
var listSearch = from o in list where o.ProvinceId == Convert.ToInt32(ddlProvinceReporter.SelectedValue) orderby o.DistrictName ascending select o;
ddlDistrictReporter.DataSource = listSearch;
ddlDistrictReporter.DataTextField = "DistrictName";
ddlDistrictReporter.DataValueField = "Id";
ddlDistrictReporter.DataBind();
ddlDistrictReporter.Items.Insert(0, new ListItem("---Chọn Quận/Huyện---", ""));
}
else
{
ddlDistrictReporter.Items.Insert(0, new ListItem("---Chọn Quận/Huyện---", ""));
}
}
public void GetDistricts_Success_Test()
{
// Arrange
R_District district = SampleDistrict(1);
IList <R_District> list = new List <R_District>();
list.Add(district);
// create mock for repository
var mock = new Mock <IDistrictRepository>();
mock.Setup(s => s.GetDistricts()).Returns(list);
// service
DistrictService districtService = new DistrictService();
DistrictService.Repository = mock.Object;
// Act
var resultList = districtService.GetDistricts();
DistrictDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.DistrictId);
}
public async Task <IActionResult> PutDistrict(int id, District district)
{
var _districtService = new DistrictService(_context);
if (id != district.Id)
{
return(BadRequest());
}
var districtValidator = new DistrictValidator();
var validresult = districtValidator.Validate(district);
if (!validresult.IsValid)
{
return(BadRequest(validresult.Errors));
}
var result = await _districtService.PutDistrict(id, district);
if (result)
{
return(Ok());
}
return(NoContent());
}
public async Task <List <Store_DistrictDTO> > FilterListDistrict([FromBody] Store_DistrictFilterDTO Store_DistrictFilterDTO)
{
if (!ModelState.IsValid)
{
throw new BindException(ModelState);
}
DistrictFilter DistrictFilter = new DistrictFilter();
DistrictFilter.Skip = 0;
DistrictFilter.Take = 20;
DistrictFilter.OrderBy = DistrictOrder.Id;
DistrictFilter.OrderType = OrderType.ASC;
DistrictFilter.Selects = DistrictSelect.ALL;
DistrictFilter.Id = Store_DistrictFilterDTO.Id;
DistrictFilter.Code = Store_DistrictFilterDTO.Code;
DistrictFilter.Name = Store_DistrictFilterDTO.Name;
DistrictFilter.Priority = Store_DistrictFilterDTO.Priority;
DistrictFilter.ProvinceId = Store_DistrictFilterDTO.ProvinceId;
DistrictFilter.StatusId = Store_DistrictFilterDTO.StatusId;
List <District> Districts = await DistrictService.List(DistrictFilter);
List <Store_DistrictDTO> Store_DistrictDTOs = Districts
.Select(x => new Store_DistrictDTO(x)).ToList();
return(Store_DistrictDTOs);
}
void BindDistrict()
{
ddlDistrict.Items.Clear();
if (m_UserValidation.OrgId > 0)
{
Organization org = new OrganizationService().FindByKey(m_UserValidation.OrgId);
if (org != null)
{
IList <District> list = new List <District>();
if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_District_All))
{
list = new DistrictService().FindAll();
AspNetCache.SetCache(Constants.Cache_ReportFuel_District_All, list);
}
else
{
list = (IList <District>)AspNetCache.GetCache(Constants.Cache_ReportFuel_District_All);
}
var listSearch = from o in list where o.ProvinceId == org.ProvinceId orderby o.DistrictName ascending select o;
ddlDistrict.DataSource = listSearch;
ddlDistrict.DataTextField = "DistrictName";
ddlDistrict.DataValueField = "Id";
ddlDistrict.DataBind();
ddlDistrict.Items.Insert(0, new ListItem("---Tất cả---", ""));
}
}
}
public async Task <IHttpActionResult> GetDistrict(DistrictModel district)
{
if (district == null)
{
return(BadRequest("Please provide valid inputs!"));
}
if (string.IsNullOrEmpty(district.Location))
{
return(BadRequest("Please provide valid location!"));
}
if (await AuthService.ValidateUserAndToken(district.Token, district.UserID, district.Email, district.Location))
{
var districts = await DistrictService.GetDistrict(district);
if (districts.Count > 0)
{
return(Ok(districts));
}
else
{
return(BadRequest("No Such District Exists!"));
}
}
else
{
return(Unauthorized());
}
}
private void initControl(int Id)
{
if (Id > 0)
{
btn_add.Visible = false;
btn_edit.Visible = true;
DistrictService objlogic = new DistrictService();
District obj = new District();
obj = objlogic.FindByKey(Id);
if (obj != null)
{
txtTitle.Text = obj.DistrictName;
txtCode.Text = obj.DistrictCode;
if (obj.ProvinceId > 0)
{
ddlParent.SelectedValue = obj.ProvinceId.ToString();
}
txtSorOrder.Text = obj.SortOrder.ToString();
//if (obj.GroupArea > 0)
// ddlLinhVuc.SelectedValue = obj.GroupArea.ToString();
}
}
else
{
btn_add.Visible = true;
btn_edit.Visible = false;
}
}
/// <summary>
/// Setup the test
/// </summary>
public DistrictApiUnitTest()
{
DbContextOptions <DbAppContext> options = new DbContextOptions <DbAppContext>();
Mock <DbAppContext> dbAppContext = new Mock <DbAppContext>(null, options);
DistrictService _service = new DistrictService(dbAppContext.Object);
_DistrictApi = new DistrictController(_service);
}
public AddressController(ProvinceServiceImpl provinceService, DistrictServiceImpl districtService
, WardServiceImpl wardService, AddressServiceImpl addressService)
{
_provinceService = provinceService;
_districtService = districtService;
_wardService = wardService;
_addressService = addressService;
}
public VillageController()
{
_villageService = new VillageService();
_mandalService = new MandalService();
_stateService = new StateService();
_districtservice = new DistrictService();
_clusterService = new ClusterService();
}
public DistrictModel Post([FromBody] DistrictModel district)
{
Response.StatusCode = 201;
string result = DistrictService.CreateDistrict(district, dbConn);
district.Id = Convert.ToInt32(result);
return(district);
}
protected async Task DistrictsProvidersToExcel()
{
var kerszolg = $"{DistrictName} szolgáltatói szerződései {Period} időszakban";
var excelBytes = DistrictService.DistrictsProvidersToExcel(kerszolg, DistrictSummaryByProviderVMs);
await Js.InvokeVoidAsync("saveAsFile", $"Szolgáltatók {DateTime.Now:yyyyMMdd_HHmmss}.xlsx", Convert.ToBase64String(excelBytes));
await InvokeAsync(StateHasChanged);
}
public AdvertisementController()
{
_appUserService = new AppUserService();
_cityService = new CityService();
_districtService = new DistrictService();
_pettypeService = new PettypeService();
_raceService = new RaceService();
_advertisementService = new AdvertisementService();
}
public ActionResult ViewDistrict(int id)
{
if (id > 0)
{
var model = new DistrictService().GetDistrict(id);
return(View(model));
}
return(View());
}
protected override async Task OnInitializedAsync()
{
nfi = (NumberFormatInfo)CultureInfo.InvariantCulture.NumberFormat.Clone();
nfi.NumberGroupSeparator = " ";
var districtId = Convert.ToInt32(DistrictId);
DistrictName = (await DistrictService.GetAsync(x => x.Id == districtId)).FirstOrDefault().Name;
DistrictSummaryByProviderVMs = await DistrictService.GetDistrictSummaryByProvider(Period, districtId);
}
public override IServiceLocatorSchool SchoolServiceLocator(Guid districtId, int?schoolId)
{
var district = DistrictService.GetByIdOrNull(districtId);
Context.SwitchSchool(district.Id, district.Name, district.TimeZone, null, district.ServerUrl, null);
var serviceLocator = new ImportServiceLocatorSchool(this);
return(serviceLocator);
}
private void BindGrid()
{
grdUser.DataSource = DistrictService.DistrictInfo_GetByAll();
grdUser.DataBind();
if (grdUser.PageCount <= 1)
{
grdUser.PagerStyle.Visible = false;
}
}
public ClusterController()
{
_mandalService = new MandalService();
_stateService = new StateService();
_districtService = new DistrictService();
_branchService = new BranchService();
_employeeService = new EmployeeService();
_clusterService = new ClusterService();
}
public PanchayatController()
{
_PanchayatService = new PanchayatService();
_stateservice = new StateService();
_clusterService = new ClusterService();
_mandalService = new MandalService();
_villageService = new VillageService();
_CommonService = new CommonService();
_DistrictService = new DistrictService();
}
private static void MostExpensiveDistricts(ApplicationDbContext context)
{
IDistrictsService districtsService = new DistrictService(context);
var districts = districtsService.GetMostExpensiveDistricts(10);
foreach (var district in districts)
{
Console.WriteLine($"{district.Name} => {district.AveragePricePerSquareMeter}€/m^2 ({district.PropertiesCount})");
}
}
protected override void LoadData()
{
if (!NetUtil.CheckNetWork(CurrActivity))
{
ToastUtil.ShowWarningToast(CurrActivity, "网络未连接！");
return;
}
//年级数据
if (BaseApplication.GetInstance().gradeList == null)
{
BaseApplication.GetInstance().gradeList = RenewService.GetGradeList(CurrUserInfo.SchoolId);
}
if (BaseApplication.GetInstance().gradeList != null && BaseApplication.GetInstance().gradeList.Any())
{
gradeList = new List <string>(BaseApplication.GetInstance().gradeList.Select(i => i.GradeName).ToArray());
}
//默认年级全选
if (searchGradeList != null && searchGradeList.Any())
{
var selectedgrade = "全部年级";
if (searchGradeList.Count > 0 && searchGradeList.Count != gradeList.Count)
{
selectedgrade = string.Join(",", searchGradeList.ToArray());
}
tv_grade.Text = selectedgrade;
}
else
{
searchGradeList = new List <string>(gradeList.ToArray());
}
//科目数据
if (BaseApplication.GetInstance().courseList == null)
{
BaseApplication.GetInstance().courseList = DistrictService.GetCourseList(CurrUserInfo.SchoolId);
}
if (BaseApplication.GetInstance().courseList != null && BaseApplication.GetInstance().courseList.Any())
{
courseList = new List <string>(BaseApplication.GetInstance().courseList.Select(t => t.CourseName).ToArray());
}
//默认科目
if (!string.IsNullOrEmpty(searchCourse))
{
tv_course.Text = searchCourse;
}
else
{
searchCourse = BaseApplication.GetInstance().courseList[0].CourseName;
tv_course.Text = searchCourse;
}
BindData();
}
public void GetDistrictListAdvancedSearch_Success_Test()
{
// Arrange
int? countryId = null;
string name = null;
string code = null;
double?latitude = null;
double?longitude = null;
bool? active = null;
//int pageIndex = 0;
int pageSize = 10;
// list
IList <R_District> list = new List <R_District>();
for (int i = 1; i <= pageSize; i++)
{
list.Add(SampleDistrict(i));
}
// create mock for repository
var mock = new Mock <IDistrictRepository>();
mock.Setup(s => s.GetDistrictListAdvancedSearch(
Moq.It.IsAny <int?>() // countryId
, Moq.It.IsAny <string>() // name
, Moq.It.IsAny <string>() // code
, Moq.It.IsAny <double?>() // latitude
, Moq.It.IsAny <double?>() // longitude
, Moq.It.IsAny <bool?>() // active
)).Returns(list);
// service
DistrictService districtService = new DistrictService();
DistrictService.Repository = mock.Object;
// Act
var resultList = districtService.GetDistrictListAdvancedSearch(
countryId
, name
, code
, latitude
, longitude
, active
);
DistrictDTO result = resultList.FirstOrDefault();
// Assert
Assert.IsNotNull(result);
Assert.AreEqual(1, result.DistrictId);
}
public string DeleteDistrict(string districtId)
{
try
{
return(DistrictService.DeleteDistrict(new Guid(districtId)) ? "OK" : "Error");
}
catch (Exception ex)
{
return(ex.Message);
}
}
private static void MostExpensiveDistrict(ApplicationDbContext db)
{
Console.WriteLine("District count:");
int districtCount = int.Parse(Console.ReadLine());
IDistrictService service = new DistrictService(db);
var districts = service.GetMostExpensiveDistricts(districtCount);
foreach (var district in districts)
{
Console.WriteLine($"{district.Name} - {district.AveragePricePerSqareMetre:0.00}€/m² ({district.PropertiesCount})");
}
}
public DivisionsController(IOptions <ApplicationSettings> appSettings,
IHttpContextAccessor httpContextAccessor,
IHostingEnvironment environment,
DistrictService districtSerice,
DivisionService divisionService)
{
_appSettings = appSettings;
_session = httpContextAccessor.HttpContext.Session;
_environment = environment;
_districtSerice = districtSerice;
_divisionService = divisionService;
}
private static void PrintTopDistrictsByAveragePrice(RealEstateDbContext db)
{
IDistrictService districtService = new DistrictService(db);
var districts = districtService.GetTopDistrictsByAveragePPrice();
foreach (var district in districts)
{
var propertyCount = district.PropertiesCount == 1 ? "property" : "properties";
Console.WriteLine(
$"{district.Name} => Price: {district.AveragePrice:f2} € ({district.MinPrice} € <-> {district.MaxPrice} €) => {district.PropertiesCount} {propertyCount}");
}
}
