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