public void Setup()
{
_vendorCollection = new Collection <IVendorProduct <IItemInstance> >(10);
_vendorCurrencies = new CurrencyCollection();
_gold = new Currency(Guid.NewGuid(), "Gold", "GOLD", 2, 999f);
_silver = new Currency(Guid.NewGuid(), "Silver", "SILVER", 2, 999f);
_vendor = new Vendor <IItemInstance>(new VendorConfig(), _vendorCollection, _vendorCurrencies);
_customerCollection = new Collection <IItemInstance>(10);
_customerCurrencies = new CurrencyCollection();
_customer = new Customer <IItemInstance>(Guid.NewGuid(), null, new CollectionGroup <IItemInstance>(new []
{
new CollectionGroup <IItemInstance> .Slot(_customerCollection),
}), new CurrencyCollectionGroup <ICurrency>(_customerCurrencies));
_item1 = new CollectionItemInstance(Guid.NewGuid(), new ItemDefinition(Guid.NewGuid())
{
maxStackSize = 5, buyPrice = new [] { new CurrencyDecorator(_gold, 1d) }, sellPrice = new [] { new CurrencyDecorator(_gold, 0.6d) }
});
_item2 = new CollectionItemInstance(Guid.NewGuid(), new ItemDefinition(Guid.NewGuid())
{
maxStackSize = 5, buyPrice = new [] { new CurrencyDecorator(_gold, 2d) }, sellPrice = new [] { new CurrencyDecorator(_gold, 1.6d) }
});
_product1 = ToProduct(_item1);
_product1_1 = ToProduct(_item1);
_product2 = ToProduct(_item2);
}
public void Setup()
{
UnityEngine.Assertions.Assert.raiseExceptions = true;
_converter = new CurrencyDoubleConverter();
_currencyCollection = new CurrencyCollection();
_gold = new Currency(Guid.NewGuid(), "Gold", "GOLD", 2, double.MaxValue);
_silver = new Currency(Guid.NewGuid(), "Silver", "SILVER", 5, double.MaxValue);
_copper = new Currency(Guid.NewGuid(), "Copper", "COPPER", 5, double.MaxValue);
_diamonds = new Currency(Guid.NewGuid(), "Diamonds", "DIAMONDS", 0, double.MaxValue);
_guildCredits = new Currency(Guid.NewGuid(), "Guild Credits", "GUILD", 0, double.MaxValue);
_gold.conversionTable = new ConversionTable <ICurrency, double>(new Dictionary <ICurrency, ConversionTable <ICurrency, double> .Row>()
{
{ _diamonds, new ConversionTable <ICurrency, double> .Row(0.01d) },
{ _silver, new ConversionTable <ICurrency, double> .Row(100d) },
});
_silver.conversionTable = new ConversionTable <ICurrency, double>(new Dictionary <ICurrency, ConversionTable <ICurrency, double> .Row>()
{
{ _gold, new ConversionTable <ICurrency, double> .Row(0.01d) },
{ _copper, new ConversionTable <ICurrency, double> .Row(100d) },
});
_copper.conversionTable = new ConversionTable <ICurrency, double>(new Dictionary <ICurrency, ConversionTable <ICurrency, double> .Row>()
{
{ _silver, new ConversionTable <ICurrency, double> .Row(0.01d) },
{ _guildCredits, new ConversionTable <ICurrency, double> .Row(2d) },
});
_currencyCollection.Add(_gold, 10);
_currencyCollection.Add(_silver, 10);
}
protected void BindCurrencyGrid()
{
CurrencyCollection currencyCollection = CurrencyManager.GetAllCurrencies();
gvCurrencies.DataSource = currencyCollection;
gvCurrencies.DataBind();
}
protected void gvLiveRates_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "ApplyLiveRate")
{
int index = Convert.ToInt32(e.CommandArgument);
GridViewRow row = gvLiveRates.Rows[index];
Label lblCurrencyCode = row.FindControl("lblCurrencyCode") as Label;
DecimalTextBox txtRate = row.FindControl("txtRate") as DecimalTextBox;
Currency currency = null;
CurrencyCollection currencies = CurrencyManager.GetAllCurrencies();
foreach (Currency currency2 in currencies)
{
if (currency2.CurrencyCode.ToLower() == lblCurrencyCode.Text.ToLower())
{
currency = currency2;
}
}
if (currency != null)
{
CurrencyManager.UpdateCurrency(currency.CurrencyId, currency.Name, currency.CurrencyCode,
txtRate.Value, currency.DisplayLocale, currency.CustomFormatting, currency.Published, currency.DisplayOrder,
currency.CreatedOn, DateTime.Now);
BindCurrencyGrid();
}
}
}
public CurrencyCollection FetchAll()
{
CurrencyCollection coll = new CurrencyCollection();
Query qry = new Query(Currency.Schema);
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
private IEnumerable <CurrencyResponseModel> CreateModel(
DateTime startDate, DateTime endDate, IReadOnlyCollection <Currency> currencies)
{
var result = new List <CurrencyResponseModel>();
while (startDate < endDate)
{
var date = new DateTime(startDate.Year, startDate.Month, 1);
var currenciesByDate = currencies.Where(e =>
date <= e.Date &&
e.Date <= date.AddDays(DateTime.DaysInMonth(date.Year, date.Month))
).ToArray();
var itemModel = new CurrencyResponseModel
{
Year = startDate.Year,
Month = startDate.Month,
WeekPeriods = CreateWeekPeriods(startDate.Year, startDate.Month)
};
foreach (var currencyWeekPeriodModel in itemModel.WeekPeriods)
{
var startWeekDate = new DateTime(
startDate.Year, startDate.Month, currencyWeekPeriodModel.StartDay);
var endWeekDate = new DateTime(
startDate.Year, startDate.Month, currencyWeekPeriodModel.EndDay);
var currenciesInPeriod = currenciesByDate
.Where(e => startWeekDate <= e.Date && e.Date <= endWeekDate)
.GroupBy(e => e.Code)
.ToDictionary(e => e.Key, v => v.ToArray());
foreach (var code in _parameters.CurrenciesCodes)
{
var currenciesByCode = currenciesInPeriod.ContainsKey(code)
? currenciesInPeriod[code]
: new Currency[0];
var collection = new CurrencyCollection();
collection.AddRange(currenciesByCode);
var model = new CurrencyResponseValueModel
{
Max = collection.Max(),
Min = collection.Min(),
Median = collection.Median(),
Code = code
};
currencyWeekPeriodModel.Currencies.Add(model);
}
}
result.Add(itemModel);
startDate = startDate.AddMonths(1);
}
return(result.OrderBy(e => e.Year).ThenBy(e => e.Month));
}
public bool CurrencyExist(string currencyId, string organizationId)
{
var predicate = Builder.Query.And(
Builder.Query <Others.Currency> .EQ(i => i.Id, currencyId),
Builder.Query <Others.Currency> .EQ(i => i.OrganizationId, organizationId));
return(CurrencyCollection.Count(predicate) > 0);
}
public void Setup()
{
UnityEngine.Assertions.Assert.raiseExceptions = true;
_currencies = new CurrencyCollection();
_gold = new Currency(Guid.NewGuid(), "Gold", "GOLD", 2, 999f);
_silver = new Currency(Guid.NewGuid(), "Silver", "SILVER", 2, 999f);
_copper = new Currency(Guid.NewGuid(), "Copper", "COPPER", 2, 999f);
}
public void Add_A_Currency_Must_Increment_Count()
{
var sut = new CurrencyCollection
{
EUR
};
sut.Count.Should().Be(1);
}
public void Removing_Null_Throws_ArgumentNullException()
{
var sut = new CurrencyCollection
{
EUR
};
Action action = () => sut.Remove(null);
action.Should().Throw <ArgumentNullException>();
}
public void test_add_currency_to_collection()
{
//Given
var twd = Currency.Create("TWD", 2);
ICurrencyLookup collection = new CurrencyCollection();
//When
collection.Add(twd);
//Then
Assert.True(collection.CurrencyList.Count() > 0);
}
public void Removing_A_Currency_That_Was_Not_Registered_Does_Not_Do_Anything()
{
var sut = new CurrencyCollection
{
EUR
};
sut.Remove(new Currency("AED"));
sut.Count.Should().Be(1);
}
public void Add_A_Currency_Multiple_Times_Will_Register_It_Only_Once()
{
var sut = new CurrencyCollection
{
EUR,
EUR,
EUR
};
sut.Count.Should().Be(1);
}
public void Removing_A_Currency_Does_Not_Depend_On_Pointer_Reference()
{
var sut = new CurrencyCollection
{
new Currency("AED")
};
sut.Remove(new Currency("AED"));
sut.Count.Should().Be(0);
}
public void Use_The_Registered_Instance_For_Currency_Resolution_By_Code()
{
var sut = new CurrencyCollection
{
EUR
};
using (new RegisterCurrencies(sut))
{
Currencies.Find("EUR").Should().NotBeNull();
}
}
private void RemoveCurrencyFromCollection()
{
CurrencyCollection.Remove(SelectedCurrencyItem);
_MyMainWindow.SelectFirstItem(); /// Selects first item after removing
_CurrencyDeleteView.Close();
_jsonDataService.SaveCurrencyData(CurrencyCollection); /// Saves currency data to the hard drive
if (CurrencyCollection.Count == 0)
{
IsRemoveBtnEnabled = false;
}
}
public void test_find_currency()
{
//Given
var twd = Currency.Create("TWD", 2);
ICurrencyLookup collection = new CurrencyCollection();
collection.Add(twd);
//When
var find = collection.Find(twd.CurrencyCode);
//Then
Assert.Equal(twd, find);
}
public void Remove_Currency_From_List()
{
var sut = new CurrencyCollection
{
EUR
};
sut.Count.Should().Be(1);
sut.Remove(EUR);
sut.Count.Should().Be(0);
}
private static CurrencyCollection DBMapping(DBCurrencyCollection dbCollection)
{
if (dbCollection == null)
return null;
CurrencyCollection collection = new CurrencyCollection();
foreach (DBCurrency dbItem in dbCollection)
{
Currency item = DBMapping(dbItem);
collection.Add(item);
}
return collection;
}
/// <summary>
/// Loads a collection of Currency objects from the database.
/// </summary>
/// <returns>A collection containing all of the Currency objects in the database.</returns>
public static CurrencyCollection LoadCollection(string spName, SqlParameter[] parms)
{
CurrencyCollection result = new CurrencyCollection();
using (SqlDataReader reader = SqlHelper.Default.ExecuteReader(spName, parms))
{
while (reader.Read())
{
Currency tmp = new Currency();
tmp.LoadFromReader(reader);
result.Add(tmp);
}
}
return(result);
}
public void MaxCurrencyTest()
{
var currencyCollection = new CurrencyCollection();
var currency1 = _currencyFactory.Create("USD", 1, 100, DateTime.Today);
var currency2 = _currencyFactory.Create("USD", 1, 200, DateTime.Today);
var currency3 = _currencyFactory.Create("USD", 1, 300, DateTime.Today);
currencyCollection.Add(currency1);
currencyCollection.Add(currency2);
currencyCollection.Add(currency3);
var max = currencyCollection.Max();
Assert.True(max == 300.0m, $"{max} <> {300.0m}");
}
public void MinCurrencyTest()
{
var currencyCollection = new CurrencyCollection();
var currency1 = _currencyFactory.Create("USD", 1, 100, DateTime.Today);
var currency2 = _currencyFactory.Create("USD", 1, 200, DateTime.Today);
var currency3 = _currencyFactory.Create("USD", 1, 300, DateTime.Today);
currencyCollection.Add(currency1);
currencyCollection.Add(currency2);
currencyCollection.Add(currency3);
var min = currencyCollection.Min();
Assert.True(min == 100.0m, $"{min} <> {100.0m}");
}
/// <summary>
/// Gets a currency by code
/// </summary>
/// <param name="currencyCode">Currency code</param>
/// <returns>Currency</returns>
public static Currency GetCurrencyByCode(string currencyCode)
{
if (String.IsNullOrEmpty(currencyCode))
{
return(null);
}
CurrencyCollection currencies = GetAllCurrencies();
foreach (Currency currency in currencies)
{
if (currency.CurrencyCode.ToLowerInvariant() == currencyCode.ToLowerInvariant())
{
return(currency);
}
}
return(null);
}
public void MedianCurrencyTest()
{
var currencyCollection = new CurrencyCollection();
var currency1 = _currencyFactory.Create("USD", 1, 100, DateTime.Today);
var currency2 = _currencyFactory.Create("USD", 1, 200, DateTime.Today);
var currency3 = _currencyFactory.Create("USD", 1, 300, DateTime.Today);
currencyCollection.Add(currency1);
currencyCollection.Add(currency2);
currencyCollection.Add(currency3);
var median = currencyCollection.Median();
Assert.True(currencyCollection.Count == 3, "CurrencyCollection len <> 3");
Assert.True(median == 200.0m, $"{median} <> {200.0m}");
}
private static CurrencyCollection DBMapping(DBCurrencyCollection dbCollection)
{
if (dbCollection == null)
{
return(null);
}
CurrencyCollection collection = new CurrencyCollection();
foreach (DBCurrency dbItem in dbCollection)
{
Currency item = DBMapping(dbItem);
collection.Add(item);
}
return(collection);
}
public static CurrencyCollection LoadForStore(int maximumRows, int startRowIndex, string sortExpression)
{
int storeId = Token.Instance.StoreId;
//CREATE THE DYNAMIC SQL TO LOAD OBJECT
StringBuilder selectQuery = new StringBuilder();
selectQuery.Append("SELECT");
if (maximumRows > 0)
{
selectQuery.Append(" TOP " + (startRowIndex + maximumRows).ToString());
}
selectQuery.Append(" " + Currency.GetColumnNames(string.Empty));
selectQuery.Append(" FROM ac_Currencies");
selectQuery.Append(" WHERE StoreId = @storeId");
if (!string.IsNullOrEmpty(sortExpression))
{
selectQuery.Append(" ORDER BY " + sortExpression);
}
Database database = Token.Instance.Database;
DbCommand selectCommand = database.GetSqlStringCommand(selectQuery.ToString());
database.AddInParameter(selectCommand, "@storeId", System.Data.DbType.Int32, storeId);
//EXECUTE THE COMMAND
CurrencyCollection results = new CurrencyCollection();
int thisIndex = 0;
int rowCount = 0;
using (IDataReader dr = database.ExecuteReader(selectCommand))
{
while (dr.Read() && ((maximumRows < 1) || (rowCount < maximumRows)))
{
if (thisIndex >= startRowIndex)
{
Currency currency = new Currency();
Currency.LoadDataReader(currency, dr);
results.Add(currency);
rowCount++;
}
thisIndex++;
}
dr.Close();
}
return(results);
}
private void AddNewCurrencyToCollection()
{
if (!string.IsNullOrEmpty(CurrencySymbolHolder) && !string.IsNullOrEmpty(CurrencyTitleHolder))
{
string NewCurrencyMade = CurrencySymbolHolder + " - " + CurrencyTitleHolder;
CurrencyCollection.Add(NewCurrencyMade);
CurrencySymbolHolder = string.Empty;
CurrencyTitleHolder = string.Empty;
AddingPropertiesVisibility = Visibility.Collapsed;
int lastItemIndex = CurrencyCollection.Count - 1;
_MyMainWindow.SelectLastAvailableItem(lastItemIndex);
IsRemoveBtnEnabled = true;
_jsonDataService.SaveCurrencyData(CurrencyCollection); /// Saves currency data to the hard drive
}
else
{
MessageBox.Show("Please, fill both boxes.");
}
}
private void FillCurrencyList()
{
cboVendorCurrency.Items.Clear();
string[] orderBy = new string[] { "CurrencyCode" };
CurrencyCollection oCnyList = Currency.LoadCollection(orderBy, true);
//cboVendorCurrency.DataSource = oCnyList;
//cboVendorCurrency.DisplayMember = "CurrencyCode";
//cboVendorCurrency.ValueMember = "CurrencyId";
if (oCnyList.Count > 0)
{
cboVendorCurrency.Items.Add(new ComboboxItem(String.Empty, String.Empty));
foreach (Currency item in oCnyList)
{
cboVendorCurrency.Items.Add(new ComboboxItem(item.CurrencyId.ToString(), item.CurrencyCode));
}
}
}
public void Insert(CurrencyCollection currencyCollection)
{
foreach (Currency currency in currencyCollection)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SP_INS_Table";
SqlParameter _param = command.Parameters.Add("@value1", System.Data.SqlDbType.VarChar);
_param.Value = "System_Currency";
SqlParameter _param2 = command.Parameters.Add("@value2", System.Data.SqlDbType.VarChar);
_param2.Value = "1";
SqlParameter _param3 = command.Parameters.Add("@value3", System.Data.SqlDbType.VarChar);
_param3.Value = currency.CurrencyID;
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
command.ExecuteNonQuery();
}
}
}
/// <summary>
/// Gets all currencies
/// </summary>
/// <returns>Currency collection</returns>
public static CurrencyCollection GetAllCurrencies()
{
bool showHidden = NopContext.Current.IsAdmin;
string key = string.Format(CURRENCIES_ALL_KEY, showHidden);
object obj2 = NopCache.Get(key);
if (CurrencyManager.CacheEnabled && (obj2 != null))
{
return((CurrencyCollection)obj2);
}
DBCurrencyCollection dbCollection = DBProviderManager <DBCurrencyProvider> .Provider.GetAllCurrencies(showHidden);
CurrencyCollection currencyCollection = DBMapping(dbCollection);
if (CurrencyManager.CacheEnabled)
{
NopCache.Max(key, currencyCollection);
}
return(currencyCollection);
}
private void BindCurrencies()
{
CurrencyCollection currencies = CurrencyManager.GetAllCurrencies();
if (currencies.Count > 1)
{
this.Visible = true;
this.ddlCurrencies.Items.Clear();
Currency customerCurrency = NopContext.Current.WorkingCurrency;
foreach (Currency currency in currencies)
{
ListItem item = new ListItem(currency.Name, currency.CurrencyID.ToString());
this.ddlCurrencies.Items.Add(item);
}
if (customerCurrency != null)
{
CommonHelper.SelectListItem(this.ddlCurrencies, customerCurrency.CurrencyID);
}
}
else
{
this.Visible = false;
}
}
public CurrencyCollection FetchByQuery(Query qry)
{
CurrencyCollection coll = new CurrencyCollection();
coll.LoadAndCloseReader(qry.ExecuteReader());
return coll;
}
public CurrencyCollection FetchByID(object CodeID)
{
CurrencyCollection coll = new CurrencyCollection().Where("codeID", CodeID).Load();
return coll;
}
private void LoadStoreSettings()
{
DataModel.Store store = StoreContext.CurrentStore;
txtStoreName.Text = store.Name;
txtOrderCompletedEmailRecipient.Text = store.GetSetting(StoreSettingNames.OrderCompletedEmailRecipient);
txtCustomerServiceEmail.Text = store.GetSetting(StoreSettingNames.CustomerServiceEmailAddress);
txtOrderNumberPrefix.Text = store.GetSetting(StoreSettingNames.OrderNumberPrefix);
ddlDefaultCountryCode.Items.Clear();
ddlDefaultCountryCode.Items.AddRange(DnnHelper.GetCountryListItems().ToArray());
ddlDefaultCountryCode.Items.Insert(0, "");
ddlDefaultCountryCode.TrySetSelectedValue(store.GetSetting(StoreSettingNames.DefaultCountryCode));
ddlCurrency.Items.Clear();
ddlCurrency.Items.AddRange(CurrencyCollection.All().Select(x => new ListItem()
{
Value = x.Code, Text = string.Format("{0} - {1}", x.Code, x.Description)
}).ToArray());
ddlCurrency.Items.Insert(0, new ListItem());
ddlCurrency.SelectedValue = store.GetSetting(StoreSettingNames.CurrencyCode);
string ccTypes = store.GetSetting(StoreSettingNames.AcceptedCreditCards) ?? string.Empty;
if (string.IsNullOrEmpty(ccTypes))
{
chklAcceptedCreditCards.SetAllSelected();
}
else
{
string[] ccTypesArray = ccTypes.Split(',');
chklAcceptedCreditCards.SetSelectedValues(ccTypesArray);
}
chkLoadJQueryUi.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.IncludeJQueryUi)).GetValueOrDefault(true);
// Store Location / Address
txtStorePhone.Text = store.GetSetting(StoreSettingNames.StorePhoneNumber);
txtStoreStreet.Text = store.GetSetting(StoreSettingNames.StoreAddressStreet);
txtStoreCity.Text = store.GetSetting(StoreSettingNames.StoreAddressCity);
txtStoreRegion.Text = store.GetSetting(StoreSettingNames.StoreAddressRegion);
txtStorePostalCode.Text = store.GetSetting(StoreSettingNames.StoreAddressPostalCode);
ddlStoreCountryCode.Items.Clear();
ddlStoreCountryCode.Items.AddRange(DnnHelper.GetCountryListItems().ToArray());
ddlStoreCountryCode.Items.Insert(0, "");
ddlStoreCountryCode.TrySetSelectedValue(store.GetSetting(StoreSettingNames.StoreAddressCountryCode));
chkCheckoutAllowAnonymous.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.CheckoutAllowAnonymous)).GetValueOrDefault(true);
chkCheckoutShowCreateAccountLink.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.CheckoutShowCreateAccountLink)).GetValueOrDefault(true);
chkTaxShipping.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.TaxShipping)).GetValueOrDefault(true);
chkSendPaymentCompleteEmail.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.SendPaymentCompleteEmail)).GetValueOrDefault(true);
chkSendOrderReceivedEmail.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.SendOrderReceivedEmail)).GetValueOrDefault(true);
chkShowShippingEstimateBox.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.ShowShippingEstimate)).GetValueOrDefault(true);
chkShowCouponBox.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.ShowCouponBox)).GetValueOrDefault(true);
chkQuantityAndPrice.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.ShowPriceAndQuantityInCatalog)).GetValueOrDefault(false);
chkShowPrices.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.ShowPrices)).GetValueOrDefault(true);
chkEnableCheckout.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.EnableCheckout)).GetValueOrDefault(true);
chkRequireOrderNotes.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.RequireOrderNotes)).GetValueOrDefault(false);
chkForceSslCheckout.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.ForceSslCheckout)).GetValueOrDefault(false);
chkDisplaySiteCredit.Checked = WA.Parser.ToBool(store.GetSetting(StoreSettingNames.DisplaySiteCredit)).GetValueOrDefault(true);
txtUrlToPostOrder.Text = store.GetSetting(StoreSettingNames.UrlToPostCompletedOrder);
}
public RegisterCurrencies(CurrencyCollection instance)
{
_instance = instance;
Currencies.SetProvider(() => _instance);
}
public CurrencyCollection Query(string currencyID)
{
CurrencyCollection collection = new CurrencyCollection();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.Connection = connection;
command.CommandText = "SP_SEL_Table";
SqlParameter _param = command.Parameters.Add("@value1", System.Data.SqlDbType.VarChar);
_param.Value = "System_Currency";
SqlParameter _param2 = command.Parameters.Add("@value2", System.Data.SqlDbType.VarChar);
_param2.Value = "1";
SqlParameter _param3 = command.Parameters.Add("@value3", System.Data.SqlDbType.VarChar);
_param3.Value = currencyID;
SqlParameter _param4 = command.Parameters.Add("@order_by1", System.Data.SqlDbType.VarChar);
_param4.Value = "";
SqlParameter _param5 = command.Parameters.Add("@order_by2", System.Data.SqlDbType.TinyInt);
_param5.Value = 0 ;
command.CommandType = System.Data.CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Currency currency = new Currency();
currency.CurrencyID = reader["Currency_ID"].ToString();
collection.Add(currency);
}
}
return collection;
}
}
