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