public IHttpActionResult deleteone([FromUri] System.String iso3
, [FromUri] System.String iso2
)
{
LitLanguageView result = db.LitLanguageDbSet
.Where(p => p.Iso3 == iso3)
.Where(p => p.Iso2 == iso2)
.Select(itm => new LitLanguageView()
{
Iso3 = itm.Iso3,
Iso2 = itm.Iso2,
LanguageName = itm.LanguageName
}).FirstOrDefault();
if (result == null)
{
return(NotFound());
}
LitLanguage entityToDelete = db.LitLanguageDbSet
.Where(p => p.Iso3 == result.Iso3)
.Where(p => p.Iso2 == result.Iso2)
.FirstOrDefault();
if (entityToDelete == null)
{
return(Ok(result));
}
db.LitLanguageDbSet.Remove(entityToDelete);
db.SaveChanges();
return(Ok(result));
}
public IHttpActionResult updateone([FromBody] LitLanguageView viewToUpdate)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
LitLanguage resultEntity = db.LitLanguageDbSet
.Where(p => p.Iso3 == viewToUpdate.Iso3)
.Where(p => p.Iso2 == viewToUpdate.Iso2)
.FirstOrDefault();
if (resultEntity == null)
{
return(NotFound());
}
resultEntity.LanguageName = viewToUpdate.LanguageName;
db.Entry(resultEntity).State = EntityState.Modified;
db.SaveChanges();
LitLanguageView result = db.LitLanguageDbSet
.Where(p => p.Iso3 == viewToUpdate.Iso3)
.Where(p => p.Iso2 == viewToUpdate.Iso2)
.Select(itm => new LitLanguageView()
{
Iso3 = itm.Iso3,
Iso2 = itm.Iso2,
LanguageName = itm.LanguageName
}).FirstOrDefault();
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
public IHttpActionResult addone([FromBody] LitLanguageView viewToAdd)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
LitLanguage entityToAdd = new LitLanguage();
entityToAdd.Iso3 = viewToAdd.Iso3;
entityToAdd.Iso2 = viewToAdd.Iso2;
entityToAdd.LanguageName = viewToAdd.LanguageName;
db.LitLanguageDbSet.Add(entityToAdd);
db.SaveChanges();
LitLanguageView result = db.LitLanguageDbSet
.Where(p => p.Iso3 == entityToAdd.Iso3)
.Where(p => p.Iso2 == entityToAdd.Iso2)
.Select(itm => new LitLanguageView()
{
Iso3 = itm.Iso3,
Iso2 = itm.Iso2,
LanguageName = itm.LanguageName
}).FirstOrDefault();
if (result == null)
{
return(NotFound());
}
return(Ok(result));
}
public IHttpActionResult getone([FromUri] System.String iso3
, [FromUri] System.String iso2
)
{
LitLanguageView result = db.LitLanguageDbSet
.Where(p => p.Iso3 == iso3)
.Where(p => p.Iso2 == iso2)
.Select(itm => new LitLanguageView()
{
Iso3 = itm.Iso3,
Iso2 = itm.Iso2,
LanguageName = itm.LanguageName
}).FirstOrDefault();
if (result == null)
{
return(NotFound());
}
return(Ok(result));
} // the end of public GetOne()-method
