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