public CityDto GetCityDetails(int?id) { CityModel cityModel = _iCityRepository.GetById(id); CityDto cityDto = ObjectConverter <CityModel, CityDto> .Convert(cityModel); return(cityDto); }
// GET: City public ActionResult search(String cityname) { var city = new CityModel(); try { Debug.WriteLine("http://api.openweathermap.org/data/2.5/weather?q=" + cityname + "&appid=8e94e5994470528d16441624dba1e2c4"); WebRequest request = WebRequest.Create("http://api.openweathermap.org/data/2.5/weather?q=" + cityname + "&appid=8e94e5994470528d16441624dba1e2c4"); WebResponse response = request.GetResponse(); Stream dataStream = response.GetResponseStream(); StreamReader reader = new StreamReader(dataStream); // Read the content. string citydata = reader.ReadToEnd(); var dataobject = JObject.Parse(citydata); Debug.WriteLine(dataobject.ToString()); city.Country = dataobject["sys"]["country"].ToString(); city.Lat = dataobject["coord"]["lat"].ToString(); city.Lng = dataobject["coord"]["lon"].ToString(); city.Humidity = dataobject["main"]["humidity"].ToString(); city.Description = dataobject["weather"][0]["description"].ToString(); Debug.WriteLine("City h " + city.Humidity + " " + dataobject["main"]["humidity"].ToString()); } catch (Exception e) { Debug.WriteLine(e.ToString()); ViewBag.Title = "Error"; } return(View(city)); }
/// <summary> /// 选择景点列表中的节点之后,设置信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) { if (!_isSelect) { _isSelect = true; return; } var node = this.treeView1.SelectedNode; var tag = node.Tag; ProvinceModel pro = tag as ProvinceModel; if (pro != null) { this.webBrowser1.Document.InvokeScript("SetCity", new object[] { pro.Name }); return; } CityModel city = tag as CityModel; if (city != null) { this.webBrowser1.Document.InvokeScript("SetCity", new object[] { city.Name }); return; } AttractionModel attra = tag as AttractionModel; if (attra != null) { SetAttraction(attra); return; } }
private static void OnCreateStudentss(int count) { Students = new List <StudentModel>(count); var rnd = new Random(); int percent = 2 + (count * 10 / 100); for (int i = 1; i <= count; i++) { string name = "Name" + i; int? cityId = GetNullableId(rnd, percent, 1, 100); CityModel cityModel = null; if (cityId != null) { cityModel = Cities.FirstOrDefault(p => p.Id == cityId); } var item = new StudentModel { Id = i, Name = name, Family = "Family" + i, Email = name + "@mail.com", City = cityId, Createdate = DateTime.Now.AddDays(rnd.Next(-366, 366)), CityModel = cityModel }; Students.Add(item); } }
public async Task TestHttpClientPost() { using (var client = new HttpClient()) { client.BaseAddress = new Uri("http://localhost:3956/"); client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json")); string date = DateTime.UtcNow.ToString("u"); client.DefaultRequestHeaders.Add("Timestamp", date); //string token=CreateToken() // HTTP GET string uri = "/api/Values/PostCity"; string methodType = "POST"; string querystring = ""; string message = string.Join("\n", methodType, date, uri.ToLower(), querystring); string token = VerifyTransactionSN.ComputeHash(SecurityConfig.Password, message); Console.WriteLine(token); client.DefaultRequestHeaders.Add("Authentication", string.Format("{0}:{1}", SecurityConfig.Password, token)); string routingUrl = uri + "?" + querystring; var postmodel = new CityModel { CityShortName = "文山", IcaoCode = "ZPPP" }; var response = await client.PostAsJsonAsync(uri, postmodel); Assert.True(response.IsSuccessStatusCode); }; }
public ActionResult View(Int64 ID) { try { CityModel city = new CityModel(); StateModel state = new StateModel(); CountryModel country = new CountryModel(); var Countrie = db.Countries.ToList(); ViewBag.Countrie_Name = Countrie; var State = db.States.Where(i => i.Country_ID == 0).ToList(); ViewBag.State_Name = State; var Citi = db.Cities.Where(i => i.State_ID == 0).ToList(); ViewBag.City_Name = Citi; var Details = db.Branches.Where(b => b.ID == ID).FirstOrDefault(); if (Details != null) { var Branch = Mapper.Map <BranchModel>(Details); return(View(Branch)); } else { return(View()); } } catch (Exception ex) { return(RedirectToAction("Contact", "Home")); } }
public static List <CityModel> GetCity() { var cityModelsList = new List <CityModel>(); var sessionFactory = SessionFactory.CreateSessionFactory(); using (var session = sessionFactory.OpenSession()) { using (session.BeginTransaction()) { var CityCreate = session.CreateCriteria(typeof(City)) .List <City>(); foreach (var cit in CityCreate) { var temp = new CityModel() { Id = cit.Id, Name = cit.Name, Population = cit.Population, CountryModel = new CountryModel { Id = cit.Country.Id, } }; cityModelsList.Add(temp); } return(cityModelsList); } } }
public int addCity(CityModel obj) { try { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _utils.Connection_string; string sqlText = "insert into tblCity(CityName,Country)values(@cityname,@country)"; SqlCommand sqlCmd = new SqlCommand(sqlText, conn); sqlCmd.Parameters.AddWithValue("@cityname", obj.CityName); sqlCmd.Parameters.AddWithValue("@country", obj.Country); if (conn.State == ConnectionState.Closed) { conn.Open(); } int i = sqlCmd.ExecuteNonQuery(); conn.Close(); return(i); } } catch (Exception ex) { throw ex; } }
public List <CityModel> getCityList() { try { using (SqlConnection conn = new SqlConnection()) { conn.ConnectionString = _utils.Connection_string; string sqlText = "Select * from tblCity"; SqlCommand sqlCmd = new SqlCommand(sqlText, conn); if (conn.State == ConnectionState.Closed) { conn.Open(); } DataTable dt = new DataTable(); SqlDataAdapter oda = new SqlDataAdapter(sqlCmd); oda.Fill(dt); List <CityModel> cityList = new List <CityModel>(); for (int i = 0; i < dt.Rows.Count; i++) { CityModel city = new CityModel(); city.cityId = Convert.ToInt32(dt.Rows[i]["cityId"]); city.CityName = dt.Rows[i]["CityName"].ToString(); city.Country = dt.Rows[i]["Country"].ToString(); cityList.Add(city); } conn.Close(); return(cityList); } } catch (Exception ex) { throw ex; } }
public dynamic deleteCity(dynamic data) { dynamic objdata = new ExpandoObject(); string serializedObject = string.Empty; try { UserLogin objUser = new UserLogin(); objUser.Email = Request.Headers["Email"]; objUser.Password = Request.Headers["Password"]; var objVal = _user.CheckloginUser(objUser); if (objVal.success == true) { serializedObject = JsonSerializer.Serialize(data); CityModel rootobj = JsonSerializer.Deserialize <CityModel>(serializedObject); return(Ok(_city.deleteCity(rootobj))); } return(Ok(objVal)); } catch (Exception ex) { objdata.success = false; objdata.message = ex.Message.ToString(); throw; } }
public JsonResult SaveCity(CityModel model) { var resultado = "OK"; var mensagens = new List <string>(); var idSalvo = string.Empty; if (!ModelState.IsValid) { resultado = "AVISO"; mensagens = ModelState.Values.SelectMany(x => x.Errors).Select(x => x.ErrorMessage).ToList(); } else { try { var id = model.Save(); if (id > 0) { idSalvo = id.ToString(); } else { resultado = "ERRO"; } } catch (Exception) { resultado = "ERRO"; } } return(Json(new { Resultado = resultado, Mensagens = mensagens, IdSalvo = idSalvo })); }
public bool InsertCity(CityModel cityModel) { try { tblCity entity = new tblCity(); entity = _unitOfWork.CityRepository.Get(filter: prop => prop.CityName.Equals(cityModel.CityName)).FirstOrDefault(); Guid newGuid = Guid.NewGuid(); if (entity == null) { tblCity city = new tblCity() { CityID = newGuid, CityName = cityModel.CityName, StateID = cityModel.StateID }; _unitOfWork.CityRepository.Insert(city); _unitOfWork.Save(); return(true); } else { return(false); } } catch (Exception e) { string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName(); ErrorLogger.LogException(e, currentFile); return(false); } }
public override bool IsValid(object value) { int cityID; City city; if (value == null) { this.ErrorMessage = "CityID es requerido"; return(false); } if (!int.TryParse(value.ToString(), out cityID)) { this.ErrorMessage = "CityID contiene formato inválido"; return(false); } if (cityID == 0 || CityModel.IsNull(new CityBLL().GetCityByCityID(cityID), out city)) { this.ErrorMessage = "CityID no existente"; return(false); } HttpContext.Current.Items["city"] = city; return(true); }
public List <CityModel> GetAllCities() { try { IEnumerable <tblCity> lstCities = _unitOfWork.CityRepository.Get(); List <CityModel> citiesList = new List <CityModel>(); foreach (var singleCity in lstCities) { CityModel city = new CityModel() { CityID = singleCity.CityID, CityName = singleCity.CityName, StateID = singleCity.StateID }; citiesList.Add(city); } return(citiesList); } catch (Exception e) { string currentFile = new System.Diagnostics.StackTrace(true).GetFrame(0).GetFileName(); ErrorLogger.LogException(e, currentFile); List <CityModel> citiesList = new List <CityModel>(); return(citiesList); } }
public List <object> GetDeviceTree(String city, String factory) { using (var connection = new SqlConnection(Constant.getDatabaseConnectionString())) { CityModel c = connection.Query <CityModel>("select * from city where cityName=@cn", new { cn = city }) .FirstOrDefault(); FactoryModel fac = connection .Query <FactoryModel>("select * from factory where factoryName=@fn and city=@cid", new { fn = factory, cid = c.Id }) .FirstOrDefault(); List <WorkshopModel> workshops = connection.Query <WorkshopModel>("select * from workshop where factory=@fid", new{ fid = fac.Id }) .ToList(); List <object> result = new List <object>(); foreach (WorkshopModel w in workshops) { List <DeviceModel> devices = connection .Query <DeviceModel>("select * from device where workshop=@wid", new { wid = w.Id }) .ToList(); List <object> deviceResult = new List <object>(); foreach (DeviceModel d in devices) { deviceResult.Add(new { label = d.DeviceName, id = d.Id }); } result.Add(new { label = w.WorkshopName, children = deviceResult }); } return(result); } }
public CityResponseModel Citys() { // Store Customer Seleted Garage in session //Session["NewServiceGarageId"] = id; CityResponseModel model = new CityResponseModel(); try { var cityList = _db.Database.SqlQuery <CityModel>("exec dbo.GetAllAvailableGaragesCitiesList").ToList(); CityModel cityModel = null; foreach (var item in cityList) { cityModel = new CityModel(); cityModel.Id = item.Id; cityModel.CityName = item.CityName; model.Citys.Add(cityModel); } model.Result = true; } catch (Exception ex) { } //return Ok(model); return(model); }
public PartialViewResult AjaxPost(string postType, string Command, string SaveAddress, PersonalDetail objPersonalDetail, AddressDetail objAddressDetail) { switch (postType) { case "Address": using (CityModel objCity = new CityModel()) { objAddressDetail.cityList = objCity.GetCityList().OrderBy(o => o.CityName).ToList(); } using (StateModel objState = new StateModel()) { objAddressDetail.stateList = objState.GetStateList().OrderBy(s => s.StateName).ToList(); } using (CountryModel objCountry = new CountryModel()) { objAddressDetail.countryList = objCountry.GetCountryList().OrderBy(o => o.Country).ToList(); } return(PartialView("~/Views/ProfileManage/_DetailAddress.cshtml", objAddressDetail)); default: //Personal using (SalutationModel objSalutation = new SalutationModel()) { objPersonalDetail.salutationList = objSalutation.GetSalutationList().OrderBy(o => o.Salutation).ToList(); } return(PartialView("~/Views/ProfileManage/_DetailPersonal.cshtml", objPersonalDetail)); //return RedirectToAction("Index", "ProfileManage"); } }
protected void FillSearchFields() { ViewBag.Genres = new SelectList(new[] { new { Text = "", Key = "" }, new { Text = "Male", Key = "M" }, new { Text = "Female", Key = "F" } }, "Key", "Text"); var cities = new CityModel().GetAllCities(); ViewBag.Cities = new SelectList(cities, "CityId", "CityName"); var region = new RegionModel().GetAllRegions(); ViewBag.Regions = new SelectList(region, "RegionId", "RegionName"); var classifications = new ClassificationModel().GetAllClassifications(); ViewBag.Classifications = new SelectList(classifications, "ClassificationId", "ClassificationName"); var users = new UserModel().GetAllUsers(); ViewBag.Users = new SelectList(users, "UserId", "Name"); SetIsAdmin(); }
public ActionResult AddCity(CityModel model) { return Json(new { result = Helper.Helper.AddCityHelper(model), content = model }); }
public ActionResult CityList(DataSourceRequest command,CityModel model,string CityName,int StateID,int CountryId) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageCountries)) return AccessDeniedView(); var cities = _cityService.GetCity(true); if (CountryId != 0) { cities = cities.Where(x => x.StateProvince.CountryId == CountryId).ToList(); } if (StateID != 0) { cities = cities.Where(x => x.StateID == StateID).ToList(); } if (CityName != null && CityName != "") { cities = cities.Where(x => x.CityName == CityName).ToList(); } //var city = cities.Select(x => x.ToModel()); //foreach(var c in city){ //c.StateName =_stateProvinceService.GetStateProvinceById(c.StateID).Name; //} var gridModel = new DataSourceResult { Data = cities.Select(PrepareCityModelForList), Total = cities.Count }; return Json(gridModel); }
protected virtual void PrepareCityModel(CityModel model, City country, bool excludeProperties) { if (model == null) throw new ArgumentNullException("model"); //model.AvailableStores = _storeService // .GetAllStores() // .Select(s => s.ToModel()) // .ToList(); if (!excludeProperties) { if (country != null) { //model.SelectedStoreIds = _storeMappingService.GetStoresIdsWithAccess(country); } } }
protected virtual void UpdateLocales(City city, CityModel model) { foreach (var localized in model.Locales) { _localizedEntityService.SaveLocalizedValue(city, x => x.CityName, localized.Name, localized.LanguageId); } }
public ActionResult CreateCity(CityModel model, bool continueEditing) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageCountries)) return AccessDeniedView(); var cityname = _cityService.GetCity().Where(x => x.CityName == model.CityName).FirstOrDefault(); if (cityname == null) { if (ModelState.IsValid) { var city = model.ToEntity(); city.StateProvince = _stateProvinceService.GetStateProvinceById(city.StateID); city.IsActive = true; city.IsDeleted = false; _cityService.InsertCity(city); //locales UpdateLocales(city, model); //zipcodes string[] r = model.zipcodesbulk.Split(','); foreach (string s in r) { if (s != "") { Zipcodes zip = new Zipcodes(); zip.StateID = model.StateID; zip.CityID = city.CityID; zip.IsActive = true; zip.IsDeleted = false; zip.ZipcodeNumber = s; _zipcodeService.InsertzipCodes(zip); } } //Stores //SaveStoreMappings(city, model); SuccessNotification(_localizationService.GetResource("Admin.Configuration.Zipcode.Added")); return continueEditing ? RedirectToAction("EditCity", new { id = city.Id }) : RedirectToAction("CityList"); } } //If we got this far, something failed, redisplay form //Stores //PrepareStoresMappingModel(model, null, true); model.Countries.Add(new SelectListItem { Text = _localizationService.GetResource("Admin.Address.SelectCountry"), Value = "0" }); foreach (var c in _countryService.GetAllCountries(false)) model.Countries.Add(new SelectListItem { Text = c.Name, Value = c.Id.ToString(), Selected = (c.Id == model.CountryId) }); model.States.Add(new SelectListItem { Text = _localizationService.GetResource("Admin.Address.SelectState"), Value = "0" }); foreach (var c in _stateProvinceService.GetStateProvincesByCountryId(model.CountryId, true)) model.States.Add(new SelectListItem { Text = c.Name, Value = c.Id.ToString(), Selected = (c.Id == model.StateID) }); return View(model); }
public ActionResult CityList() { if (!_permissionService.Authorize(StandardPermissionProvider.ManageCountries)) return AccessDeniedView(); CityModel model = new CityModel(); model.Countries.Add(new SelectListItem { Text = _localizationService.GetResource("Admin.Address.SelectCountry"), Value = "0" }); foreach (var c in _countryService.GetAllCountries(false)) model.Countries.Add(new SelectListItem { Text = c.Name, Value = c.Id.ToString(), Selected = (c.Id == model.CountryId) }); model.States.Add(new SelectListItem { Text = _localizationService.GetResource("Admin.Address.SelectState"), Value = "0" }); foreach (var c in _stateProvinceService.GetStateProvincesByCountryId(model.CountryId, true)) model.States.Add(new SelectListItem { Text = c.Name, Value = c.Id.ToString(), Selected = (c.Id == model.StateID) }); return View(model); }
public ActionResult AddCity() { CityModel cmodel = new CityModel(); PrepareState(cmodel); return View(cmodel); }
public ActionResult CreateCity() { if (!_permissionService.Authorize(StandardPermissionProvider.ManageCountries)) return AccessDeniedView(); var model = new CityModel(); //locales AddLocales(_languageService, model.Locales); //Stores //PrepareCityModel(model, null, false); //default values model.Countries.Add(new SelectListItem { Text = _localizationService.GetResource("Admin.Address.SelectCountry"), Value = "0" }); foreach (var c in _countryService.GetAllCountries(false)) model.Countries.Add(new SelectListItem { Text = c.Name, Value = c.Id.ToString(), Selected = (c.Id == model.CountryId) }); model.States.Add(new SelectListItem { Text = _localizationService.GetResource("Admin.Address.SelectState"), Value = "0" }); foreach (var c in _stateProvinceService.GetStateProvincesByCountryId(model.CountryId,true)) model.States.Add(new SelectListItem { Text = c.Name, Value = c.Id.ToString(), Selected = (c.Id == model.StateID) }); model.IsActive = true; model.IsDeleted = false; return View(model); }
public ActionResult AddCity(CityModel ctmodel) { try { HolidayPlanner.DAL.City city = new HolidayPlanner.DAL.City() { CityId = ctmodel.CityId, CityName = ctmodel.CityName, StateId = ctmodel.StateId }; context.Cities.InsertOnSubmit(city); context.SubmitChanges(); return RedirectToAction("Index"); } catch { return View(ctmodel); } }
public ActionResult EditCity(CityModel model, bool continueEditing) { if (!_permissionService.Authorize(StandardPermissionProvider.ManageCountries)) return AccessDeniedView(); var cityname = _cityService.GetCity().Where(x => x.CityName == model.CityName && x.CityID!=model.CityID).FirstOrDefault(); if (cityname == null) { if (ModelState.IsValid) { var city = model.ToEntity(); city.StateProvince = _stateProvinceService.GetStateProvinceById(city.StateID); city.IsActive = true; city.IsDeleted = false; _cityService.UpdateCity(city); //locales UpdateLocales(city, model); var zipcodess = _zipcodeService.GetZipcodesByCityId(model.CityID).ToList(); foreach (var z in zipcodess) { _zipcodeService.DeleteZipcode(z); } //zipcodes string[] r = model.zipcodesbulk.Split(','); foreach (string s in r) { if (s != "") { Zipcodes zip = new Zipcodes(); zip.StateID = model.StateID; zip.CityID = city.CityID; zip.IsActive = true; zip.IsDeleted = false; zip.ZipcodeNumber = s; _zipcodeService.InsertzipCodes(zip); } } //Stores //SaveStoreMappings(city, model); SuccessNotification(_localizationService.GetResource("Admin.Configuration.Zipcode.Added")); return continueEditing ? RedirectToAction("EditCity", new { id = city.CityID }) : RedirectToAction("CityList"); //if (continueEditing) //{ // //selected tab // SaveSelectedTabIndex(); // return RedirectToAction("Edit", new { id = country.Id }); //} //return RedirectToAction("List"); } } //If we got this far, something failed, redisplay form //Stores return View(model); }
private void PrepareState(CityModel model) { model.States = context.States.AsQueryable<HolidayPlanner.DAL.State>().Select(x => new SelectListItem() { Text = x.StateName, Value = x.StateId.ToString() }); }