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