public static List <DistrictDto> GetDistricts(int state) { Query query = new Query(); Criterion criteriaState = new Criterion("st.StateId", state, CriteriaOperator.Equal); query.Add(criteriaState); query.AddAlias(new Alias("st", "StateOfDistrict")); DistrictServiceReference.IDistrictService client = new DistrictServiceClient(); var districts = client.FindByQuery(query); List <DistrictDto> districtList = new List <DistrictDto>(); districtList = districts.Entities.ToList(); districtList.Insert(0, new DistrictDto { DistrictId = 0, DistrictName = "[Select]" }); return(districtList); }
private bool CheckIfDistrictBelongsToTheGivenState(int StateId, int DistrictId) { bool isPresent = false; Query query = new Query(); Criterion criteriaState = new Criterion("st.StateId", StateId, CriteriaOperator.Equal); Criterion criteriaDistrict = new Criterion("DistrictId", DistrictId, CriteriaOperator.Equal); query.Add(criteriaState); query.Add(criteriaDistrict); query.AddAlias(new Alias("st", "StateOfDistrict")); DistrictServiceReference.IDistrictService client = new DistrictServiceClient(); var districts = client.FindByQuery(query); if (districts.TotalRecords > 0) { isPresent = true; } return(isPresent); }
public ActionResult AddNewCity() { CityVillageServiceReference.ICityVillageService client = new CityVillageServiceClient(); DistrictServiceReference.IDistrictService dclient = new DistrictServiceClient(); UserDto currentUserDto = (UserDto)Session[Constants.SKCURRENTUSER]; CityVillageDto cityVillageDto = new CityVillageDto(); cityVillageDto.Name = Request.Params["ppPlace"].ToString(); cityVillageDto.STDCode = Request.Params["ppSTDCode"].ToString(); if (string.Equals(Request.Params["ppCityVillage"].ToString(), "City")) { cityVillageDto.CityOrVillage = CityVillageType.City; } else { cityVillageDto.CityOrVillage = CityVillageType.Village; } int DistrictId = Convert.ToInt32(Request.Params["ppdistrictId"]); cityVillageDto.DistrictOfCityVillage = dclient.GetById(DistrictId); cityVillageDto = client.Create(cityVillageDto, currentUserDto.UserName); if (cityVillageDto.Response.HasWarning) { ViewData["Error"] = ErrorAndValidationMessages.BRCityVillageNameValidation; } else { TempData["StateSaved"] = "City / Village Saved"; } string controlPrefix = Request.Params["CommonControlPrefix"]; Cams.Web.MVCRazor.Models.Shared.StateDistrictCityControlNamesModel model = new Cams.Web.MVCRazor.Models.Shared.StateDistrictCityControlNamesModel(controlPrefix); model.HiddenFieldForCityVillageValue = cityVillageDto.CityVillageId; model.HiddenFieldForDistrictValue = cityVillageDto.DistrictOfCityVillage.DistrictId; return(PartialView("CallBackPopupAddCity", model)); }