public async Task <ActionResult <TblCountries> > PostTblCountries(TblCountries tblCountries) { _context.TblCountries.Add(tblCountries); await _context.SaveChangesAsync(); return(CreatedAtAction("GetTblCountries", new { id = tblCountries.Countryid }, tblCountries)); }
public async Task <IActionResult> PutTblCountries(int id, TblCountries tblCountries) { if (id != tblCountries.Countryid) { return(BadRequest()); } _context.Entry(tblCountries).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!TblCountriesExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public virtual async Task <int> AddAsync(TblCountries record) { _dbContext.Countries.Add(record); await _dbContext.SaveChangesAsync(); ClearCache(); _eventPublisher.EntityInserted(record); return(record.Id); }
public virtual async Task UpdateAsync(TblCountries record) { var oldRecord = await FindByIdAsync(record.Id); _dbContext.Countries.AddOrUpdate(record); await _dbContext.SaveChangesAsync(); ClearCache(); _eventPublisher.EntityUpdated(record, oldRecord); }
public virtual async Task <CountryModel> PrepareCountryModelAsync(TblCountries country) { CountryModel result; if (country == null) { result = new CountryModel(); } else { result = country.Adapt <CountryModel>(); await country.LoadAllLocalizedStringsToModelAsync(result); } return(result); }
public virtual void Initialize(AppDbContext db) { //Default Currency TblCurrencies usDollar = null, irRial = null; if (!db.Currencies.Any(p => p.IsMainCurrency)) { usDollar = new TblCurrencies() { IsoCode = "USD", DisplayOrder = 0, IsMainCurrency = true, Published = true, CurrencyName = "USD (US Dollar)", ExchangeRate = 0, DisplayFormat = "${0:N2}", ShortName = "USD" }; irRial = new TblCurrencies() { IsoCode = "IRR", DisplayOrder = 1, IsMainCurrency = false, Published = true, CurrencyName = "IRR (Iranian Rial)", ExchangeRate = 38000, DisplayFormat = "{0:#,###} ریال", ShortName = "Rial" }; db.Currencies.AddOrUpdate(usDollar); db.Currencies.AddOrUpdate(irRial); db.SaveChanges(); } else { usDollar = db.Currencies.FirstOrDefault(p => p.IsoCode.ToUpper().Trim() == "USD"); irRial = db.Currencies.FirstOrDefault(p => p.IsoCode.ToUpper().Trim() == "IRR"); } //Default Language TblLanguages enLang, faLang; if (!db.Languages.Any(p => p.IsDefault)) { using (var stream = new MemoryStream()) { Resources.English_16px.Save(stream, System.Drawing.Imaging.ImageFormat.Png); enLang = new TblLanguages() { IsoCode = "en", IsRtl = false, DisplayOrder = 0, IsDefault = true, LanguageName = "English", Published = true, Icon = stream.ToArray(), DefaultCurrency = usDollar, DefaultCurrencyId = usDollar?.Id }; stream.Seek(0, SeekOrigin.Begin); Resources.Iran_16px.Save(stream, System.Drawing.Imaging.ImageFormat.Png); faLang = new TblLanguages() { IsoCode = "fa", IsRtl = true, DisplayOrder = 1, IsDefault = false, LanguageName = "فارسی", Published = true, Icon = stream.ToArray(), DefaultCurrency = irRial, DefaultCurrencyId = irRial?.Id }; } db.Languages.AddOrUpdate(enLang); db.Languages.AddOrUpdate(faLang); db.SaveChanges(); if (irRial != null) { db.LocalizedProperty.AddOrUpdate(new TblLocalizedProperty() { EntityId = irRial.Id, LocaleKey = "CurrencyName", LocaleKeyGroup = "Tbl_Currencies", LocaleValue = "ریال ایران", LanguageId = faLang.Id }); db.LocalizedProperty.AddOrUpdate(new TblLocalizedProperty() { EntityId = irRial.Id, LocaleKey = "ShortName", LocaleKeyGroup = "Tbl_Currencies", LocaleValue = "ریال", LanguageId = faLang.Id }); db.SaveChanges(); } if (usDollar != null) { db.LocalizedProperty.AddOrUpdate(new TblLocalizedProperty() { EntityId = usDollar.Id, LocaleKey = "CurrencyName", LocaleKeyGroup = "Tbl_Currencies", LocaleValue = "دلار آمریکا", LanguageId = faLang.Id }); db.LocalizedProperty.AddOrUpdate(new TblLocalizedProperty() { EntityId = usDollar.Id, LocaleKey = "ShortName", LocaleKeyGroup = "Tbl_Currencies", LocaleValue = "دلار", LanguageId = faLang.Id }); db.SaveChanges(); } } else { faLang = db.Languages.FirstOrDefault(p => p.IsoCode.Trim() == "fa"); } //Countries List if (!db.Countries.Any()) { foreach (var country in Countries) { var dbCountry = new TblCountries() { CountryName = country.Key }; db.Countries.AddOrUpdate(dbCountry); db.SaveChanges(); if (faLang != null) { db.LocalizedProperty.AddOrUpdate(new TblLocalizedProperty() { EntityId = dbCountry.Id, LanguageId = faLang.Id, LocaleKeyGroup = "Tbl_Countries", LocaleKey = "CountryName", LocaleValue = country.Value }); } } } db.SaveChanges(); ImportLocalizedStrings(db); }