public ActionResult Post(string city_name) { _cityRepository.Add(new City { Name = city_name }); return(Ok()); }
// [TAG]Save Related Data static void SaveRelatedData() { var countys = new List <County> { new County { FullName = "TP.Hạ Long", IsDelete = false, NameFormated = "TP.Hạ Long" }, new County { FullName = "Móng Cái", IsDelete = false, NameFormated = "Móng Cái" }, new County { FullName = "Cẩm Phả", IsDelete = false, NameFormated = "Cẩm Phả" }, }; var city = new City { CityCode = 8, FullName = "Quảng Ninh", IsDelete = false, NameFormated = "Quảng_Ninh_8", County = countys, }; var cityRepo = new CityRepository(); cityRepo.Add(new List <City> { city }); }
public IActionResult Create(City model) { if (HttpContext.Session.GetString("ID") == null) { return(RedirectToAction("Login", "Admin")); } else { //check validation if (ModelState.IsValid) { // check duplicate ID bool check = cityRepository.checkID(model.CityID); if (check) { cityRepository.Add(model); return(RedirectToAction("Index")); } else { ModelState.AddModelError(string.Empty, "This ID already exists."); ViewBag.list = cityRepository.listAllRegion(); return(View()); } } //forward Region list ViewBag.list = cityRepository.listAllRegion(); return(View(model)); } }
public void AddTest() { StateRepository sr = new StateRepository(); var p = sr.GetAll().GetEnumerator(); p.MoveNext(); Cidade item = new Cidade() { Nome = "Cidade01", DDD = "00", Estado = p.Current }; ICityRepository target = new CityRepository(); target.Add(item); try { // use session to try to load the product using (ISession session = NHibernateHelper.OpenSession()) { var fromDb = session.Get <Cidade>(item.Id); Assert.IsNotNull(fromDb); Assert.AreNotSame(item, fromDb); Assert.AreEqual(item.Nome, fromDb.Nome); Assert.AreEqual(item.DDD, fromDb.DDD); Assert.AreEqual(item.Estado.Id, fromDb.Estado.Id); } } finally { target.Remove(item); } }
public void GetByNameTest() { StateRepository sr = new StateRepository(); var p = sr.GetAll().GetEnumerator(); p.MoveNext(); Cidade item = new Cidade() { Nome = "Cidade01", DDD = "00", Estado = p.Current }; ICityRepository target = new CityRepository(); target.Add(item); try { var fromDb = target.GetByName(item.Nome); Assert.IsNotNull(fromDb); Assert.AreNotSame(item, fromDb); Assert.AreEqual(item.Nome, fromDb.Nome); Assert.AreEqual(item.DDD, fromDb.DDD); Assert.AreEqual(item.Estado.Id, fromDb.Estado.Id); } finally { target.Remove(item); } }
public void CadastrarCidadeDuplicada() { var repo = new CityRepository(config); var city = (City)TestContext.Properties["CidadeDuplicada"]; repo.Add(city); // Assert - Expects exception }
public void CadastrarCidade() { try { var repo = new CityRepository(config); var city = (City)TestContext.Properties["NovaCidade"]; repo.Add(city); } catch (Exception) { Assert.Fail(); } }
public bool Add(string cityName, string description, bool isActive) { var city = new THOK.Authority.DbModel.City() { CityID = Guid.NewGuid(), CityName = cityName, Description = description, IsActive = isActive }; CityRepository.Add(city); CityRepository.SaveChanges(); return(true); }
public override IEnumerable <Row> Execute(IEnumerable <Row> rows) { using (var conn = new NpgsqlConnection(conString)) { conn.Open(); foreach (var row in rows) { CityRepository.Add(conn, (string)row["OriginCityName"], (string)row["OriginState"], (string)row["OriginAirportName"], _dictCity, _dictState); CityRepository.Add(conn, (string)row["DestCityName"], (string)row["DestState"], (string)row["DestAirportName"], _dictCity, _dictState); yield return(row); } } }
public bool Add(string cityName, string description, string isActive) { var city = new THOK.Authority.DbModel.AUTH_CITY() { //CITY_ID = Guid.NewGuid().ToString(), CITY_ID = CityRepository.GetNewID("AUTH_CITY", "CITY_ID"), CITY_NAME = cityName, DESCRIPTION = description, IS_ACTIVE = isActive }; CityRepository.Add(city); CityRepository.SaveChanges(); return(true); }
public JsonResult Create(City city, string userid) { try { if (ModelState.IsValid) { ICR.Add(city, Session["userid"].ToString()); } } catch { return(Json("error")); } return(Json("success")); }
static void AddSimpleCity() { var city = new City { CityCode = 6, FullName = "Ninh Bình", IsDelete = false, NameFormated = "Ninh_Bình_6", }; var cityRepo = new CityRepository(); cityRepo.Add(new List <City> { city }); }
static void Main(string[] args) { var city = new City() { CityCode = "123", CityName = "teste" }; var repo = new CityRepository(); repo.Add(city); var all = repo.GetAll(); Console.WriteLine($"cities: {all.Count()}"); }
public void Test_Add() { var position = _fixture.Create <int>(); var russianName = _fixture.Create <string>(); var englishName = _fixture.Create <string>(); var id = _cities.Add(englishName, russianName, position); var russian = _cities.All(TwoLetterISOLanguageName.Russian).First(x => x.Id == id); var english = _cities.All(TwoLetterISOLanguageName.English).First(x => x.Id == id); russian.ShouldBeEquivalentTo(english, options => options.Excluding(x => x.Name)); russian.Name.ShouldBeEquivalentTo(russianName); english.Name.ShouldBeEquivalentTo(englishName); }
private void AddCity(Country country, int streetsCount) { int no = country.Cities.Count + 1; City city = new City { Country = country, Name = "City #" + no, Area = 50, Streets = new List <Street>() }; for (int i = 0; i < streetsCount; i++) { AddStreet(city, 1); } country.Cities.Add(city); _cityRepository.Add(city); }
public ActionResult Create(City city) { //Check Access Rights to Domain if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName)) { ViewData["Message"] = "You do not have access to this item"; return(View("Error")); } //Update Model from Form try { UpdateModel(city); } catch { string n = ""; foreach (ModelState modelState in ViewData.ModelState.Values) { foreach (ModelError error in modelState.Errors) { n += error.ErrorMessage; } } ViewData["Message"] = "ValidationError : " + n; return(View("Error")); } //Database Update try { cityRepository.Add(city); } catch (SqlException ex) { LogRepository logRepository = new LogRepository(); logRepository.LogError(ex.Message); ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details"; return(View("Error")); } return(RedirectToAction("List")); }
public async Task <City> Add(CityDTO data) { using (var client = new HttpClient()) { client.DefaultRequestHeaders.Accept.Clear(); client.DefaultRequestHeaders.Accept.Add( new MediaTypeWithQualityHeaderValue("application/json")); string baseURL = Configuration.GetSection("WeatherForecastApi:BaseURL").Value; string key = Configuration.GetSection("WeatherForecastApi:ApiKey").Value; HttpResponseMessage response = await client.GetAsync( baseURL + "/weather?" + $"APPID={key}&" + $"q={data.Name}"); response.EnsureSuccessStatusCode(); string bodyResponse = await response.Content.ReadAsStringAsync(); WeatherForecastCityDTO result = JsonConvert.DeserializeObject <WeatherForecastCityDTO>(bodyResponse); Boolean cityExists = await CityRepository.FindByApiCityCode(result.Id) != null; if (cityExists) { throw new Exception("Cidade já cadastrada!"); } var newCity = new City() { Name = data.Name, ApiCityCode = result.Id }; await CityRepository.Add(newCity); return(newCity); } }
public async Task <IActionResult> PostCity([FromBody] CityDTO cityDTO) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } var city = await cityRepository.Add(cityDTO); if (city == null) { return(BadRequest()); } CityDTO dto = new CityDTO(); dto.CityId = city.CityId; dto.Name = city.Name; dto.Latitude = city.Latitude; dto.Longitude = city.Longitude; return(CreatedAtAction("GetCity", dto)); }
public void AddData() { Console.Clear(); Console.WriteLine("Введите название страны - "); var countryName = CheckNullString(Console.ReadLine()); Console.WriteLine($"Введите название города находящегося в стране {countryName} - "); var cityName = CheckNullString(Console.ReadLine()); Console.WriteLine($"Введите название улицы находящейся в городе {cityName} - "); var streetName = CheckNullString(Console.ReadLine()); var street = new Street { Name = streetName }; var city = new City { Name = cityName, Street = street, StreetId = street.Id, }; var country = new Country { Name = countryName, City = city, CityId = city.Id }; Console.Clear(); using (var repository = new StreetRepository()) { try { repository.Add(street); } catch (Exception exception) { Console.WriteLine(exception.Message); Console.WriteLine("Нажмите Enter чтобы продолжить!"); Console.ReadKey(); return; } } using (var repository = new CityRepository()) { try { repository.Add(city); } catch (Exception exception) { Console.WriteLine(exception.Message); Console.WriteLine("Нажмите Enter чтобы продолжить!"); Console.ReadKey(); return; } } using (var repository = new CountryRepository()) { try { repository.Add(country); } catch (Exception exception) { Console.Clear(); Console.WriteLine(exception.Message); Console.WriteLine("Нажмите Enter чтобы продолжить!"); Console.ReadKey(); return; } } Console.Clear(); Console.WriteLine("Данные добавлены!"); Console.WriteLine("Нажмите Enter чтобы продолжить!"); Console.ReadKey(); }
public async Task AddTest() { int key = 0; using (DBContext db = new DBContext(settings.Database.ConnectionString, logger)) { Assert.NotNull(db); ContactRepository contactRepos = new ContactRepository(settings, logger, db); CityRepository cityRepos = new CityRepository(settings, logger, db); StateRepository stateRepos = new StateRepository(settings, logger, db); ProjectContactRepository projectContactRepos = new ProjectContactRepository(settings, logger, db); #region Add Contact Test Contact contact = new Contact() { FirstName = "New", LastName = "User", Address1 = "Address1", Address2 = "Address2", CellPhone = "8005551212", HomePhone = "8005551212", WorkPhone = "8005551212", Notes = String.Empty, ZipCode = "99999", EMail = "*****@*****.**", CityId = 1 }; ICollection <Contact> contacts = await contactRepos.FindAll(); Assert.Null(contacts.Where(c => c.LastName == contact.LastName && c.FirstName == contact.FirstName).FirstOrDefault()); key = (int)await contactRepos.Add(contact); Assert.True(key > 0); Assert.NotNull(await contactRepos.FindByPK(new PrimaryKey() { Key = key })); #endregion #region Add City Test City city = new City() { Name = "New City", StateId = "FL" }; ICollection <City> cities = await cityRepos.FindAll(); Assert.Null(cities.Where(c => c.Name == city.Name).FirstOrDefault()); key = (int)await cityRepos.Add(city); Assert.True(key > 0); Assert.NotNull(await cityRepos.FindByPK(new PrimaryKey() { Key = key })); #endregion #region Add State Test State newState = new State() { Id = "ZZ", Name = "New State" }; State state = await stateRepos.FindByPK(new PrimaryKey() { Key = newState.Id }); Assert.Null(state); key = (int)await stateRepos.Add(newState); Assert.True(key > 0); Assert.NotNull(await stateRepos.FindByPK(new PrimaryKey() { Key = newState.Id })); #endregion #region Add ProjectContact Test ProjectContact projectContact = new ProjectContact() { ProjectId = 2, ContactId = 23 }; ICollection <ProjectContact> projectContacts = await projectContactRepos.FindAll(); Assert.Null(projectContacts.Where(c => c.ProjectId == projectContact.ProjectId && c.ContactId == projectContact.ContactId).FirstOrDefault()); key = (int)await projectContactRepos.Add(projectContact); // returns number of rows added Assert.True(key > 0); Assert.NotNull(await projectContactRepos.FindByPK(new PrimaryKey() { CompositeKey = new object[] { projectContact.ProjectId, projectContact.ContactId }, IsComposite = true })); #endregion } }
public string Add(City city) { bool success = CityRepository.Add(city); return("City created with success"); }
public void AddTest() { int key = 0; string naturalKey = String.Empty; using (DBContext db = new DBContext(settings.Database.ConnectionString, logger)) { Assert.NotNull(db); ContactRepository contactRepos = new ContactRepository(settings, logger, db); CityRepository cityRepos = new CityRepository(settings, logger, db); StateRepository stateRepos = new StateRepository(settings, logger, db); #region Add Contact Test Contact contact = new Contact() { FirstName = "New", LastName = "User", Address1 = "Address1", Address2 = "Address2", CellPhone = "8005551212", HomePhone = "8005551212", WorkPhone = "8005551212", Notes = String.Empty, ZipCode = "99999", EMail = "*****@*****.**", CityId = 1 }; ICollection <Contact> contacts = contactRepos.FindAll(); Assert.Null(contacts.Where(c => c.LastName == contact.LastName && c.FirstName == contact.FirstName).FirstOrDefault()); key = (int)contactRepos.Add(contact); Assert.True(key > 0); Assert.NotNull(contactRepos.FindByPK(new PrimaryKey() { Key = key })); #endregion #region Add City Test City city = new City() { Name = "New City", StateId = "FL" }; ICollection <City> cities = cityRepos.FindAll(); Assert.Null(cities.Where(c => c.Name == city.Name).FirstOrDefault()); key = (int)cityRepos.Add(city); Assert.True(key > 0); Assert.NotNull(cityRepos.FindByPK(new PrimaryKey() { Key = key })); #endregion #region Add State Test State newState = new State() { Id = "ZZ", Name = "New State" }; State state = stateRepos.FindByPK(new PrimaryKey() { Key = newState.Id, IsIdentity = false }); Assert.Null(state); naturalKey = (string)stateRepos.Add(newState); Assert.True(naturalKey == (string)newState.PK.Key); Assert.NotNull(stateRepos.FindByPK(new PrimaryKey() { Key = newState.Id, IsIdentity = false })); #endregion } }
public bool Add(City city) { //Logic Here return(_cityRepository.Add(city)); }
public IHttpActionResult Post(MonitoredCity city) { //_cityRepository.Add(city); CityRepository.Add(city); return(Ok()); }