public bool CurrencyRateDelete(CurrencyRate currencyrate)
        {
            return Execute<bool>(dal =>
            {
                CurrencyRate currencyrateDelete = dal.CurrencyRate.Where(x => x.CurrencyRateID == currencyrate.CurrencyRateID).FirstOrDefault();
                if (currencyrateDelete != null)
                {
                    dal.CurrencyRate.DeleteOnSubmit(currencyrateDelete);
                    dal.SubmitChanges();
                    return true;
                }
                return false;

            });
        }
        public bool CurrencyRateUpdate(CurrencyRate currencyrate)
        {
            return Execute<bool>(dal =>
               {
               CurrencyRate currencyrateUpdate = dal.CurrencyRate.Where(x => x.CurrencyRateID == currencyrate.CurrencyRateID).FirstOrDefault();
               if (currencyrateUpdate != null)
               {
                   currencyrateUpdate.CurrencyRateID = currencyrate.CurrencyRateID;
                   currencyrateUpdate.CurrencyRateDate = currencyrate.CurrencyRateDate;
                   currencyrateUpdate.FromCurrencyCode = currencyrate.FromCurrencyCode;
                   currencyrateUpdate.ToCurrencyCode = currencyrate.ToCurrencyCode;
                   currencyrateUpdate.AverageRate = currencyrate.AverageRate;
                   currencyrateUpdate.EndOfDayRate = currencyrate.EndOfDayRate;
                   currencyrateUpdate.ModifiedDate = currencyrate.ModifiedDate;

                   dal.SubmitChanges();
                   return true;
               }
               return false;

               });
        }
 partial void DeleteCurrencyRate(CurrencyRate instance);
 partial void UpdateCurrencyRate(CurrencyRate instance);
 partial void InsertCurrencyRate(CurrencyRate instance);
		private void detach_CurrencyRates1(CurrencyRate entity)
		{
			this.SendPropertyChanging();
			entity.Currency1 = null;
		}
		private void attach_CurrencyRates1(CurrencyRate entity)
		{
			this.SendPropertyChanging();
			entity.Currency1 = this;
		}
 public void CurrencyRateUpdate(CurrencyRate currencyrate)
 {
     adventureWorks_BC.CurrencyRateUpdate(currencyrate);
 }
 public void CurrencyRateAdd(CurrencyRate currencyrate)
 {
     adventureWorks_BC.CurrencyRateAdd(currencyrate);
 }