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 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 getone([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());
}
return(Ok(result));
} // the end of public GetOne()-method
