private async Task <List <dto.ProductModel> > GetProducts(string type, string category, string dollar)
{
string toCurrency = dollar;
Single price = 0;
float exchangeRate = 1;
if ((toCurrency != "") && (toCurrency.ToUpper() != "NZD"))
{
exchangeRate = CurrencyConvertor.GetExchangeRate(toCurrency);
}
if (category != null)
{
category = category.Replace("-", " ");
}
var ret = new List <dto.ProductModel>();
var cmd = this.MySqlDB.Connection.CreateCommand() as MySqlCommand;
string query = @"SELECT p.ProductId, p.ProductName, p.ProductPrice, p.ProductImage, p.ProductCode, c.CategoryID, c.categoryname from products p inner join productcategories c on p.ProductCategoryID=c.categoryid ";
if (type == "featured")
{
query += "where productID = 15 or productID = 8 or productID = 9";
}
if ((type == "category") && (category.ToLower() != "all"))
{
query += "where categoryname = '" + category + "'";
}
query += ";";
System.Diagnostics.Debug.WriteLine("Type: " + type);
System.Diagnostics.Debug.WriteLine("Category: " + category);
System.Diagnostics.Debug.WriteLine("Query: " + query);
cmd.CommandText = query;
using (var reader = await cmd.ExecuteReaderAsync())
while (await reader.ReadAsync())
{
price = reader.GetFieldValue <Single>(2);
var t = new dto.ProductModel()
{
ProductId = reader.GetFieldValue <int>(0),
ProductName = reader.GetFieldValue <string>(1).ToUpper(),
ProductPrice = price * exchangeRate,
ProductImage = reader.GetFieldValue <string>(3),
ProductCode = reader.GetFieldValue <string>(4),
CategoryID = reader.GetFieldValue <int>(5),
CategoryName = reader.GetFieldValue <string>(6)
};
ret.Add(t);
}
return(ret);
}
public async Task <IViewComponentResult> InvokeAsync()
{
var cart = SessionHelper.GetObjectFromJson <List <ShoppingCartItemModel> >(HttpContext.Session, "cart");
if (cart == null)
{
cart = new List <ShoppingCartItemModel>();
}
string culture = CultureInfo.CurrentCulture.Name.ToLower();
string currency = "";
//currency = HttpContext.Request.Query["currency"].ToString().ToUpper();
currency = MShopClass.getCurrency(culture);
//culture = MShopClass.currencyList()[currency.ToUpper()];
// culture = MShopClass.currencyList()[currency.ToUpper()];
float exchangeRate = 1;
if ((currency != "") && (currency.ToUpper() != "NZD"))
{
exchangeRate = CurrencyConvertor.GetExchangeRate(currency);
}
ViewBag.Culture = culture;
ViewBag.Currency = currency;
ViewBag.ExchangeRate = exchangeRate;
ViewBag.cart = cart;
ViewBag.total = cart.Sum(ShoppingCartItem => ShoppingCartItem.Product.ProductPrice * ShoppingCartItem.Quantity);
return(View());
}