public static void Do() { var countries = CountryRecord.Retrieve(); using (var context = new ClimateContext()) { context.Countries.RemoveRange(context.Countries.ToList()); foreach (var country in countries.OrderByDescending(x => x.population)) { var dbCountry = new Domain.Country { Name = country.name, Population = country.population }; context.Countries.Add(dbCountry); var capital = new Domain.City { IsCapital = true, Country = dbCountry, Name = country.capital }; context.Cities.Add(capital); Console.WriteLine("{0} - done", country.name); } context.SaveChanges(); } }
public ActionResult NewRegistrationfromSocialPage(UserProfile userProfile) { Guid cityGuid = Guid.Empty; UserDomainLogic userdomainLogic = new UserDomainLogic(); userProfile.UserAddresses = new List <UserAddress>(); UserAddress usrAddress = new UserAddress(); usrAddress.Address = Convert.ToString(HttpContext.Request.Form["BillingAddress.Address"]); usrAddress.PostCode = Convert.ToString(HttpContext.Request.Form["BillingAddress.PostCode"]); Guid.TryParse(HttpContext.Request.Form["BillingAddress_CityGuid"], out cityGuid); usrAddress.CityGuid = cityGuid; var billingCityName = Convert.ToString(HttpContext.Request.Form["BillingAddress.CityName"]); var shippingCityName = Convert.ToString(HttpContext.Request.Form["ShippingAddress.CityName"]); CommonDomainLogic commonDomainLogic = new CommonDomainLogic(); if (!string.IsNullOrEmpty(billingCityName) && usrAddress.CityGuid == Guid.Empty) { Bringly.Domain.City city = new Domain.City { CityGuid = Guid.NewGuid(), CityName = billingCityName, CityUrlName = billingCityName }; commonDomainLogic.AddCity(city); usrAddress.CityGuid = city.CityGuid; } usrAddress.AddressType = Bringly.Domain.Enums.User.UserAddressType.Billing.ToString(); userProfile.UserAddresses.Add(usrAddress); usrAddress = new UserAddress(); usrAddress.Address = Convert.ToString(HttpContext.Request.Form["ShippingAddress.Address"]); usrAddress.PostCode = Convert.ToString(HttpContext.Request.Form["ShippingAddress.PostCode"]); Guid.TryParse(HttpContext.Request.Form["ShippingAddress_CityGuid"], out cityGuid); usrAddress.CityGuid = cityGuid; if (!string.IsNullOrEmpty(shippingCityName) && usrAddress.CityGuid == Guid.Empty && !billingCityName.Equals(shippingCityName)) { Bringly.Domain.City city = new Domain.City { CityGuid = Guid.NewGuid(), CityName = shippingCityName, CityUrlName = shippingCityName }; commonDomainLogic.AddCity(city); usrAddress.CityGuid = city.CityGuid; } usrAddress.AddressType = Bringly.Domain.Enums.User.UserAddressType.Shipping.ToString(); userProfile.UserAddresses.Add(usrAddress); userdomainLogic.UpdateUserProfile(userProfile); Success("Saved successfully"); userProfile.Cities = commonDomainLogic.GetCities(); return(RedirectToAction("Dashboard", "User")); }
public async Task <AddCityPayload> AddCityAsync(AddCityInput input, [ScopedService] GeoDbContext context) { var city = new Domain.City { Name = input.Name, CountryId = input.CountryId }; context.Cities.Add(city); await context.SaveChangesAsync(); return(new AddCityPayload(city)); }
public ActionResult UpdateLocation(BusinessObject BusinessObject) { BusinessDomainLogic businessDomainLogic = new BusinessDomainLogic(); CommonDomainLogic commonDomainLogic = new CommonDomainLogic(); if (!string.IsNullOrEmpty(BusinessObject.CityName) && BusinessObject.CityGuid == Guid.Empty) { Bringly.Domain.City city = new Domain.City { CityGuid = Guid.NewGuid(), CityName = BusinessObject.CityName, CityUrlName = BusinessObject.CityName }; BusinessObject.CityGuid = commonDomainLogic.AddCity(city); } return(Json(businessDomainLogic.UpdateLocation(BusinessObject), JsonRequestBehavior.AllowGet)); }
public ActionResult UserRegistration(UserRegistration userRegistration) { UserDomainLogic userdomainLogic = new UserDomainLogic(); userRegistration.UserAddresses = new List <UserAddress>(); UserAddress usrAddress = new UserAddress(); usrAddress.Address = Convert.ToString(HttpContext.Request.Form["BillingAddress.Address"]); usrAddress.PostCode = Convert.ToString(HttpContext.Request.Form["BillingAddress.PostCode"]); usrAddress.CityGuid = userRegistration.BillingAddress.CityGuid; usrAddress.Country = userRegistration.BillingAddress.Country; usrAddress.Latitude = userRegistration.BillingAddress.Latitude; usrAddress.Longitude = userRegistration.BillingAddress.Longitude; usrAddress.PlaceId = userRegistration.BillingAddress.PlaceId; usrAddress.AddressType = Bringly.Domain.Enums.User.UserAddressType.Billing.ToString(); var cityName = Convert.ToString(HttpContext.Request.Form["BillingAddress.CityName"]); if (!string.IsNullOrEmpty(cityName) && usrAddress.CityGuid == Guid.Empty) { Bringly.Domain.City city = new Domain.City { CityGuid = Guid.NewGuid(), CityName = cityName, CityUrlName = cityName }; CommonDomainLogic commonDomainLogic = new CommonDomainLogic(); usrAddress.CityGuid = commonDomainLogic.AddCity(city); } userRegistration.UserAddresses.Add(usrAddress); bool result = userdomainLogic.AddUserProfile(userRegistration); if (result) { return(RedirectToAction("thankregistration", "home")); } return(RedirectToAction("userregistration", "home")); }
public void Handle(AddCityCommand command) { var repository = this.contextFactory(); var city = new Domain.City( command.CityId , command.Name , command.StateRegionId , command.Coordinates , command.PostCode , command.Active , command.InsertedDate , command.PhoneCode ); repository.Save(city); }
public ActionResult AddLocation(BusinessObject businessObject) { BusinessDomainLogic businessDomainLogic = new BusinessDomainLogic(); if (!string.IsNullOrEmpty(businessObject.CityName) && businessObject.CityGuid == Guid.Empty) { CommonDomainLogic commonDomainLogic = new CommonDomainLogic(); Bringly.Domain.City city = new Domain.City { CityGuid = Guid.NewGuid(), CityName = businessObject.CityName, CityUrlName = businessObject.CityName }; businessObject.CityGuid = commonDomainLogic.AddCity(city); } businessDomainLogic.AddLocation(businessObject); TempData["Success"] = "Saved successfully"; return(RedirectToAction("LocationList", "Business")); //return Json(businessDomainLogic.AddLocation(businessObject), JsonRequestBehavior.AllowGet); }