private BasicFood GetBasicFoodData(string id, string lang)
{
BasicFood x = new BasicFood();
try {
Prices P = new Prices();
// TODO: loadPrices
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + Server.MapPath("~/App_Data/" + dataBase))) {
connection.Open();
string sql = string.Format("SELECT id, basicFood FROM bacisFoods WHERE id = '{0}'", id);
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
using (SQLiteDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
x.id = reader.GetValue(0) == DBNull.Value ? null : reader.GetString(0);
x.basicFood = reader.GetValue(1) == DBNull.Value ? null : t.Tran(reader.GetString(1), lang);
//if (prices != null) x.price = prices.Find(a => a.food.title == x.basicFood);
//xx.Add(x);
}
}
}
}
return(x);
} catch (Exception e) {
L.SendErrorLog(e, null, null, "ShoppingList", "GetBasicFoodData");
return(x);
}
}
private List <BasicFood> LoadBasicFoodsData(bool isDistinct, string userId, string lang)
{
List <BasicFood> xx = new List <BasicFood>();
try {
Prices P = new Prices();
var prices = P.LoadData(userId, null);
// TODO: loadPrices
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + Server.MapPath("~/App_Data/" + dataBase))) {
connection.Open();
string sql = string.Format("SELECT id, basicFood FROM bacisFoods WHERE basicFood IS NOT NULL {0}", isDistinct ? "GROUP BY basicFood" : "");
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
using (SQLiteDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
BasicFood x = new BasicFood();
x.id = reader.GetValue(0) == DBNull.Value ? null : reader.GetString(0);
if (isDistinct)
{
x.food = reader.GetValue(1) == DBNull.Value ? null : t.Tran(reader.GetString(1), lang);
}
else
{
x.basicFood = reader.GetValue(1) == DBNull.Value ? null : t.Tran(reader.GetString(1), lang);
}
if (prices != null)
{
x.price = prices.Find(a => a.food.title == x.basicFood);
}
xx.Add(x);
}
}
}
}
return(xx);
} catch (Exception e) {
L.SendErrorLog(e, null, null, "ShoppingList", "LoadBasicFoodsData");
return(xx);
}
}
