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 static void PopulateLanguages(this LitDbContext db)
{
CultureInfo[] cultureInfos = CultureInfo.GetCultures(CultureTypes.NeutralCultures);
foreach (CultureInfo cultureInfo in cultureInfos)
{
if (string.IsNullOrEmpty(cultureInfo.Name))
{
continue;
}
if (!db.LitLanguageDbSet.Any(l => (l.Iso3 == cultureInfo.ThreeLetterISOLanguageName) && (l.Iso2 == cultureInfo.TwoLetterISOLanguageName)))
{
LitLanguage lang = new LitLanguage()
{
Iso3 = cultureInfo.ThreeLetterISOLanguageName,
Iso2 = cultureInfo.TwoLetterISOLanguageName,
LanguageName = cultureInfo.EnglishName
};
db.LitLanguageDbSet.Add(lang);
db.SaveChanges();
db.Entry(lang).State = System.Data.Entity.EntityState.Detached;
}
}
}
