public IHttpActionResult addone([FromBody] LitCountryView viewToAdd) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } LitCountry entityToAdd = new LitCountry(); entityToAdd.Iso3 = viewToAdd.Iso3; entityToAdd.Iso2 = viewToAdd.Iso2; entityToAdd.CountryName = viewToAdd.CountryName; db.LitCountryDbSet.Add(entityToAdd); db.SaveChanges(); LitCountryView result = db.LitCountryDbSet .Where(p => p.Iso3 == entityToAdd.Iso3) .Where(p => p.Iso2 == entityToAdd.Iso2) .Select(itm => new LitCountryView() { Iso3 = itm.Iso3, Iso2 = itm.Iso2, CountryName = itm.CountryName }).FirstOrDefault(); if (result == null) { return(NotFound()); } return(Ok(result)); }
public IHttpActionResult deleteone([FromUri] System.String iso3 , [FromUri] System.String iso2 ) { LitCountryView result = db.LitCountryDbSet .Where(p => p.Iso3 == iso3) .Where(p => p.Iso2 == iso2) .Select(itm => new LitCountryView() { Iso3 = itm.Iso3, Iso2 = itm.Iso2, CountryName = itm.CountryName }).FirstOrDefault(); if (result == null) { return(NotFound()); } LitCountry entityToDelete = db.LitCountryDbSet .Where(p => p.Iso3 == result.Iso3) .Where(p => p.Iso2 == result.Iso2) .FirstOrDefault(); if (entityToDelete == null) { return(Ok(result)); } db.LitCountryDbSet.Remove(entityToDelete); db.SaveChanges(); return(Ok(result)); }
public IHttpActionResult updateone([FromBody] LitCountryView viewToUpdate) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } LitCountry resultEntity = db.LitCountryDbSet .Where(p => p.Iso3 == viewToUpdate.Iso3) .Where(p => p.Iso2 == viewToUpdate.Iso2) .FirstOrDefault(); if (resultEntity == null) { return(NotFound()); } resultEntity.CountryName = viewToUpdate.CountryName; db.Entry(resultEntity).State = EntityState.Modified; db.SaveChanges(); LitCountryView result = db.LitCountryDbSet .Where(p => p.Iso3 == viewToUpdate.Iso3) .Where(p => p.Iso2 == viewToUpdate.Iso2) .Select(itm => new LitCountryView() { Iso3 = itm.Iso3, Iso2 = itm.Iso2, CountryName = itm.CountryName }).FirstOrDefault(); if (result == null) { return(NotFound()); } return(Ok(result)); }
public static void PopulateCounties(this LitDbContext db) { CultureInfo[] cultureInfos = CultureInfo.GetCultures(CultureTypes.AllCultures & CultureTypes.SpecificCultures); foreach (CultureInfo cultureInfo in cultureInfos) { if (string.IsNullOrEmpty(cultureInfo.Name)) { continue; } RegionInfo regionInfo = new RegionInfo(cultureInfo.Name); if (!db.LitCountryDbSet.Any(c => (c.Iso3 == regionInfo.ThreeLetterISORegionName) && (c.Iso2 == regionInfo.TwoLetterISORegionName))) { LitCountry сountry = new LitCountry() { Iso3 = regionInfo.ThreeLetterISORegionName, Iso2 = regionInfo.TwoLetterISORegionName, CountryName = regionInfo.EnglishName }; db.LitCountryDbSet.Add(сountry); db.SaveChanges(); db.Entry(сountry).State = System.Data.Entity.EntityState.Detached; } } }