public override ProductPriceInfoList GetProductPricesExact(long productid, string iso_currency, string culture)
{
if (iso_currency == null)
throw new ArgumentNullException("iso_currency");
string workCulture = "nl-NL";
if (!string.IsNullOrEmpty(culture))
workCulture = culture;
string isoCurrency = "EUR";
string isoCountry = "NL";
if (!string.IsNullOrEmpty(iso_currency))
isoCurrency = iso_currency;
if (!string.IsNullOrEmpty(culture))
{
isoCountry = culture.Length == 2 ? culture : culture.Substring(3);
}
ProductPriceInfoList res = new ProductPriceInfoList();
using (MySqlConnection conn = new MySqlConnection(GetConnectionString()))
{
using (MySqlCommand cmd = new MySqlCommand(QRY_GET_PRODUCTPRICE_BY_PRODUCT_ID_CURRENCY_COUNTRY_EXACT, conn))
{
cmd.Parameters.Add("@product_id", MySqlDbType.Int64).Value = productid;
cmd.Parameters.Add("@iso_currency", MySqlDbType.VarChar, 10).Value = isoCurrency;
cmd.Parameters.Add("@iso2_country", MySqlDbType.VarChar, 2).Value = isoCountry;
DataTable tbl = new DataTable("productprice");
using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
{
conn.Open();
try
{
da.Fill(tbl);
foreach (DataRow row in tbl.Rows)
{
long productPriceId = Convert.ToInt64(row["productprice_id"]);
decimal price = Convert.ToDecimal(row["price"]);
string isoCurreny = Convert.ToString(row["iso_currency"]);
string iso2Country = Convert.ToString(row["iso2_country"]);
long productId = Convert.ToInt64(row["product_id"]);
ProductPriceInfo ppi = new ProductPriceInfo(productPriceId, price, isoCurreny, iso2Country, productId);
res.Add(ppi);
}
}
catch (Exception ex)
{
Logger.Instance.Write(LogLevel.Error, ex, "GetProductPricesExact<Exception>");
}
finally
{
conn.Close();
}
}
}
}
return res;
}
public override ProductPriceInfoList GetProductPricesWild(long productid, string isoCurrency, string culture)
{
ProductPriceInfoList res = new ProductPriceInfoList();
using (MySqlConnection conn = new MySqlConnection(GetConnectionString()))
{
using (MySqlCommand cmd = new MySqlCommand(QRY_GET_PRODUCTPRICE_BY_PRODUCT_ID_CURRENCY_COUNTRY_WILD, conn))
{
cmd.Parameters.Add("@product_id", MySqlDbType.Int64).Value = productid;
cmd.Parameters.Add("@iso_currency", MySqlDbType.VarChar, 10).Value = isoCurrency;
//cmd.Parameters.Add("@iso2_country", MySqlDbType.VarChar, 2).Value = culture.Substring(3);
cmd.Parameters.Add("@iso2_country", MySqlDbType.VarChar, 2).Value = culture.Substring(3);
DataTable tbl = new DataTable("productprice");
using (MySqlDataAdapter da = new MySqlDataAdapter(cmd))
{
try
{
conn.Open();
da.Fill(tbl);
foreach (DataRow row in tbl.Rows)
{
long productPriceId = Convert.ToInt64(row["productprice_id"]);
decimal price = Convert.ToDecimal(row["price"]);
string isoCurreny = Convert.ToString(row["iso_currency"]);
string iso2Country = Convert.ToString(row["iso2_country"]);
long productId = Convert.ToInt64(row["product_id"]);
ProductPriceInfo ppi = new ProductPriceInfo(productPriceId, price, isoCurreny, iso2Country, productId);
res.Add(ppi);
}
}
catch (Exception ex)
{
Logger.Instance.Write(LogLevel.Error, ex, "GetProductPricesWild<Exception>");
}
finally
{
conn.Close();
}
}
}
}
return res;
}
public ProductPriceInfoList GetProductPrices(int productid)
{
ProductPriceInfoList res = new ProductPriceInfoList();
using (NpgsqlConnection conn = new NpgsqlConnection(GetConnectionString()))
{
string query = string.Format(
QRY_GET_PRODUCTPRICES_BY_PRODUCT_ID,
productid);
using (NpgsqlCommand cmd = new NpgsqlCommand(query, conn))
{
DataTable tbl = new DataTable("productprice");
using (NpgsqlDataAdapter da = new NpgsqlDataAdapter(cmd))
{
try
{
da.Fill(tbl);
foreach (DataRow row in tbl.Rows)
{
int productPriceId = Convert.ToInt32(row["productprice_id"]);
decimal price = Convert.ToDecimal(row["price"]);
string isoCurreny = Convert.ToString (row["iso_currency"]);
string iso2Country = Convert.ToString (row["iso2_country"]);
int productId = Convert.ToInt32(row["product_id"]);
ProductPriceInfo ppi = new ProductPriceInfo(productPriceId, price, isoCurreny, iso2Country, productId);
res.Add(ppi);
}
}
catch (Exception ex)
{
Logger.Instance.Write(TrackProtect.Logging.LogLevel.Error, ex, "GetProductPrices<Exception>");
}
finally
{
conn.Close();
}
}
}
}
return res;
}
