public static decimal CurrencyExchangeGetRate
(int MoneyFrom,
int MoneyTo,
int Year)
{
ProveedoresOnLine.Company.Models.Util.CurrencyExchangeModel oCurrency = null;
if (MoneyFrom != MoneyTo)
{
//get rate
List <ProveedoresOnLine.Company.Models.Util.CurrencyExchangeModel> olstCurrency =
ProveedoresOnLine.Company.Controller.Company.CurrencyExchangeGetByMoneyType
(MoneyFrom, MoneyTo, null);
if (olstCurrency != null && olstCurrency.Count > 0)
{
//get rate for year or current year
oCurrency = olstCurrency.Any(x => x.IssueDate.Year == Year) ?
olstCurrency.Where(x => x.IssueDate.Year == Year).FirstOrDefault() :
olstCurrency.OrderByDescending(x => x.IssueDate.Year).FirstOrDefault();
}
}
if (oCurrency == null)
{
//rate not found
oCurrency = new ProveedoresOnLine.Company.Models.Util.CurrencyExchangeModel()
{
Rate = 1,
};
}
return(oCurrency.Rate);
}
public AdminCategoryViewModel(ProveedoresOnLine.Company.Models.Util.CurrencyExchangeModel oCurrency)
{
C_CurrentExchangeId = oCurrency.CurrencyExchangeId.ToString();
C_IssueDate = oCurrency.IssueDate.
ToString(BackOffice.Models.General.InternalSettings.Instance[BackOffice.Models.General.Constants.C_Settings_DateFormat_Server].Value);
C_MoneyTypeFromId = oCurrency.MoneyTypeFrom.ItemId.ToString();
C_MoneyTypeFromName = oCurrency.MoneyTypeFrom.ItemName.ToString();
C_MoneyTypeToId = oCurrency.MoneyTypeTo.ItemId.ToString();
C_MoneyTypeToName = oCurrency.MoneyTypeTo.ItemName.ToString();
C_Rate = oCurrency.Rate.ToString(System.Globalization.CultureInfo.CreateSpecificCulture("EN-us"));
C_CreateDate = oCurrency.CreateDate.ToString();
C_LastModify = oCurrency.LastModify.ToString();
}
public static int CurrencyExchangeInsert(ProveedoresOnLine.Company.Models.Util.CurrencyExchangeModel CurrencyExchange)
{
return(DAL.Controller.CompanyDataController.Instance.CurrencyExchangeInsert(CurrencyExchange.IssueDate, CurrencyExchange.MoneyTypeFrom.ItemId, CurrencyExchange.MoneyTypeTo.ItemId, CurrencyExchange.Rate));
}
