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