public COMPTA_ExchangeRate CreateExchangeRate(COMPTA_ExchangeRate exchangeRateToAdd)
{
using(SUPERPEntities context = new SUPERPEntities(false))
{
var exchangeRate = context.COMPTA_ExchangeRate.Add(exchangeRateToAdd);
context.SaveChanges();
return exchangeRate;
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public COMPTA_ExchangeRate GetLastExchangeRate()
{
var result = comptabilityDal.GetLastExchangeRate();
if ( result == null || DateTime.Now - result.updatedDate > new TimeSpan(1, 0, 0, 0, 0) )
{
// Call Update WebService for ExchangeRate Update =)
//comptabilityDal.
// ReGet the value updated
CurrencyConvertor.CurrencyConvertorSoapClient client = new CurrencyConvertor.CurrencyConvertorSoapClient("CurrencyConvertorSoap",new System.ServiceModel.EndpointAddress("http://www.webservicex.net/CurrencyConvertor.asmx"));
try
{
COMPTA_ExchangeRate exchangeRate = new COMPTA_ExchangeRate();
exchangeRate.EURO_AUD = client.ConversionRate(Currency.EUR, Currency.AUD);
exchangeRate.EURO_GBP = client.ConversionRate(Currency.EUR, Currency.GBP);
exchangeRate.EURO_USD = client.ConversionRate(Currency.EUR, Currency.USD);
exchangeRate.EURO_ZAR = client.ConversionRate(Currency.EUR, Currency.ZAR);
exchangeRate.USD_EURO = client.ConversionRate(Currency.USD, Currency.EUR);
exchangeRate.updatedDate = DateTime.Now;
comptabilityDal.CreateExchangeRate(exchangeRate);
result = comptabilityDal.GetLastExchangeRate();
}
catch (Exception e)
{
}
}
return result;
}
public COMPTA_ExchangeRate EditExchangeRate(COMPTA_ExchangeRate exchangeRateToEdit)
{
using(SUPERPEntities context = new SUPERPEntities(false))
{
var exchangeRate = context.COMPTA_ExchangeRate.Find(exchangeRateToEdit.id);
if (exchangeRate == null)
return null;
exchangeRate = exchangeRateToEdit;
context.SaveChanges();
return exchangeRate;
}
}