public List<admin_basket> get_last_baskets(int iLimit, string sShopId)
{
StringBuilder sb = new StringBuilder();
List<admin_basket> basketList = new List<admin_basket>();
string sSql = "select id, basket_id, basket_total_sum,basket_total_discount,confirmed_by_shop,timestamp from consumer_basket cb where shop_id = " + sShopId + " order by id desc limit " + iLimit.ToString();
GLOBAL_SQL_CONN conn = new GLOBAL_SQL_CONN(this);
try
{
GLOBAL_SQL_COMMAND command = new GLOBAL_SQL_COMMAND(sSql, conn);
GLOBAL_SQL_READER reader = new GLOBAL_SQL_READER(command);
while (reader.Read())
{
admin_basket basket = new admin_basket();
basket.iId = (int)reader.c("id");
basket.sBasketId = reader.c("basket_id").ToString();
basket.sTotalSum = reader.c("basket_total_sum").ToString();
basket.sTotalDiscount = reader.c("basket_total_discount").ToString();
basket.sConfirmedByShop = reader.c("confirmed_by_shop").ToString();
if (basket.sConfirmedByShop.ToUpper() == "TRUE") basket.sConfirmedByShop = "Ja";
else if (basket.sConfirmedByShop.ToUpper() == "FALSE") basket.sConfirmedByShop = "Nei";
else basket.sConfirmedByShop = "?";
basket.sTimestamp = reader.c("timestamp").ToString();
basketList.Add(basket);
}
} catch (Exception e)
{
basketList = null;
} finally
{
conn.Close();
}
return basketList;
}
public admin_basket get_basket(string sBasketRowId)
{
admin_basket basket = null;
List<admin_basket> basketList = new List<admin_basket>();
string sSql = "select id, basket_id, basket_a, basket_b, basket_total_sum,basket_total_discount,confirmed_by_shop,timestamp from consumer_basket where id = " + sBasketRowId;
GLOBAL_SQL_CONN conn = new GLOBAL_SQL_CONN(this);
try
{
GLOBAL_SQL_COMMAND command = new GLOBAL_SQL_COMMAND(sSql, conn);
GLOBAL_SQL_READER reader = new GLOBAL_SQL_READER(command);
if (reader.Read())
{
basket = new admin_basket();
basket.iId = (int)reader.c("id");
basket.sBasketId = reader.c("basket_id").ToString();
basket.sBasket_A = reader.c("basket_a").ToString();
basket.sBasket_B = reader.c("basket_b").ToString();
basket.sTotalSum = reader.c("basket_total_sum").ToString();
basket.sTotalDiscount = reader.c("basket_total_discount").ToString();
basket.sConfirmedByShop = reader.c("confirmed_by_shop").ToString();
if (basket.sConfirmedByShop.ToUpper() == "TRUE") basket.sConfirmedByShop = "Ja";
else if (basket.sConfirmedByShop.ToUpper() == "FALSE") basket.sConfirmedByShop = "Nei";
else basket.sConfirmedByShop = "?";
basket.sTimestamp = reader.c("timestamp").ToString();
}
} catch (Exception e)
{
basket = null;
} finally
{
conn.Close();
}
return basket;
}
