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)); }