public CurrencyModel UpdateCurrency(CurrencyModel currencyModel) { Mapper.Initialize(cfg => { cfg.CreateMap <CurrencyModel, ExchangeRate>(); }); //using (AirLineEntities entities = new AirLineEntities()) //{ // ExchangeRate exchangeRate = (from c in entities.ExchangeRates // where c.ID == currencyModel.ID // select c).FirstOrDefault(); // exchangeRate = Mapper.Map<CurrencyModel, ExchangeRate>(currencyModel); // entities.Configuration.ValidateOnSaveEnabled = false; // exchangeRate.ID = currencyModel.ID; // entities.Entry(exchangeRate).State = System.Data.Entity.EntityState.Modified; // entities.SaveChanges(); // entities.Configuration.ValidateOnSaveEnabled = true; // int result = entities.SaveChanges(); // if (result == 1) // return currencyModel; //} // return currencyModel; ExchangeRate exchangeRate; using (CurrancyEntities entities = new CurrancyEntities()) { exchangeRate = (from c in entities.ExchangeRates where c.ID == currencyModel.ID select c).FirstOrDefault(); } exchangeRate = exchangeRate = Mapper.Map <CurrencyModel, ExchangeRate>(currencyModel); using (CurrancyEntities entities = new CurrancyEntities()) { entities.Configuration.ValidateOnSaveEnabled = false; entities.Entry(exchangeRate).State = System.Data.Entity.EntityState.Modified; entities.SaveChanges(); entities.Configuration.ValidateOnSaveEnabled = true; int result = entities.SaveChanges(); if (result == 1) { return(currencyModel); } } return(currencyModel); }
public bool DeleteCurrency(CurrencyModel currencyModel) { //Mapper.Initialize(cfg => //{ // cfg.CreateMap<CurrencyModel, ExchangeRate>(); //}); using (CurrancyEntities entities = new CurrancyEntities()) { ExchangeRate exchangeRate = new ExchangeRate(); entities.Configuration.ValidateOnSaveEnabled = false; exchangeRate.ID = currencyModel.ID; entities.Entry(exchangeRate).State = System.Data.Entity.EntityState.Deleted; entities.SaveChanges(); entities.Configuration.ValidateOnSaveEnabled = true; int result = entities.SaveChanges(); return(true); } }