public string Init(Users.NewUser user)
{
NewMyMeals x = new NewMyMeals();
x.id = null;
x.title = null;
x.description = null;
x.userId = user.userId;
x.userGroupId = user.userGroupId;
List <Meals.NewMeal> mm = new List <Meals.NewMeal>();
List <Foods.MealsRecommendationEnergy> ee = new List <Foods.MealsRecommendationEnergy>();
Meals.NewMeal m = new Meals.NewMeal();
m.code = "MM0";
m.title = "";
m.description = "";
m.isSelected = true;
m.isDisabled = false;
mm.Add(m);
Foods.MealsRecommendationEnergy e = new Foods.MealsRecommendationEnergy();
e.meal.code = m.code;
e.meal.energyMinPercentage = 0;
e.meal.energyMaxPercentage = 0;
ee.Add(e);
JsonFileMeals data = new JsonFileMeals();
data.meals = mm;
data.energyPerc = ee;
x.data = data;
return(JsonConvert.SerializeObject(x, Formatting.None));
}
public List <NewMyMeals> LoadMeals(string userId)
{
List <NewMyMeals> xx = new List <NewMyMeals>();
//db.CreateDataBase(userId, db.meals);
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, userDataBase))) {
connection.Open();
string sql = "SELECT id, title, description, userId, userGroupId FROM meals ORDER BY rowid DESC";
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
using (SQLiteDataReader reader = command.ExecuteReader()) {
while (reader.Read())
{
NewMyMeals x = new NewMyMeals();
x.id = reader.GetValue(0) == DBNull.Value ? "" : reader.GetString(0);
x.title = reader.GetValue(1) == DBNull.Value ? "" : reader.GetString(1);
x.description = reader.GetValue(2) == DBNull.Value ? "" : reader.GetString(2);
x.userId = reader.GetValue(3) == DBNull.Value ? "" : reader.GetString(3);
x.userGroupId = reader.GetValue(4) == DBNull.Value ? "" : reader.GetString(4);
xx.Add(x);
}
}
}
}
return(xx);
}
public string Save(string userId, NewMyMeals x)
{
SaveResponse r = new SaveResponse();
try {
//db.CreateDataBase(userId, db.meals);
db.AddColumn(userId, db.GetDataBasePath(userId, userDataBase), db.meals, MEAL_DATA, "TEXT"); //new column in recipes tbl.
if (string.IsNullOrEmpty(x.id) && Check(userId, x.title))
{
r.msg = "meals with the same name already exists";
r.isSuccess = false;
return(JsonConvert.SerializeObject(r, Formatting.None));
}
else
{
if (string.IsNullOrEmpty(x.id))
{
x.id = Convert.ToString(Guid.NewGuid());
}
Global G = new Global();
x.title = G.RemoveSingleQuotes(x.title);
x.description = G.RemoveSingleQuotes(x.description);
string sql = string.Format(@"BEGIN;
INSERT OR REPLACE INTO meals (id, title, description, userId, userGroupId, mealData)
VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}');
COMMIT;", x.id, x.title, x.description, x.userId, x.userGroupId, JsonConvert.SerializeObject(x.data, Formatting.None));
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, userDataBase))) {
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
command.ExecuteNonQuery();
}
}
/* int idx = 0;
* foreach (var m in x.data.meals) {
* m.code = string.Format("MM{0}", idx);
* x.data.energyPerc[idx].meal.code = m.code;
* idx++;
* }*/
// SaveJsonToFile(userId, x.id, JsonConvert.SerializeObject(x.data, Formatting.None));
Files F = new Files();
F.RemoveJsonFile(userId, x.id, "meals", MEAL_DATA, db, userDataBase, null); //******* Remove json file if exists (old sistem).
r.data = x;
r.isSuccess = true;
return(JsonConvert.SerializeObject(r, Formatting.None));
}
} catch (Exception e) {
L.SendErrorLog(e, x.id, userId, "MyMeals", "Save");
r.isSuccess = false;
r.msg = e.Message;
r.msg1 = e.StackTrace;
return(JsonConvert.SerializeObject(r, Formatting.None));
}
}
public string Get(string userId, string id)
{
try {
SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, dataBase));
connection.Open();
string sql = string.Format("SELECT id, title, description, userId, userGroupId FROM meals WHERE id = '{0}'", id);
SQLiteCommand command = new SQLiteCommand(sql, connection);
NewMyMeals x = new NewMyMeals();
SQLiteDataReader reader = command.ExecuteReader();
while (reader.Read())
{
x.id = reader.GetValue(0) == DBNull.Value ? "" : reader.GetString(0);
x.title = reader.GetValue(1) == DBNull.Value ? "" : reader.GetString(1);
x.description = reader.GetValue(2) == DBNull.Value ? "" : reader.GetString(2);
x.userId = reader.GetValue(3) == DBNull.Value ? "" : reader.GetString(3);
x.userGroupId = reader.GetValue(4) == DBNull.Value ? "" : reader.GetString(4);
x.data = JsonConvert.DeserializeObject <JsonFileMeals>(GetJsonFile(userId, id));
}
connection.Close();
return(JsonConvert.SerializeObject(x, Formatting.None));
} catch (Exception e) { return(e.Message); }
}
public string Save(string userId, NewMyMeals x)
{
try {
db.CreateDataBase(userId, db.meals);
if (string.IsNullOrEmpty(x.id) && Check(userId, x.title))
{
return("error");
}
else
{
if (string.IsNullOrEmpty(x.id))
{
x.id = Convert.ToString(Guid.NewGuid());
}
string sql = "";
SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, dataBase));
connection.Open();
SQLiteCommand command = new SQLiteCommand(sql, connection);
sql = string.Format(@"BEGIN;
INSERT OR REPLACE INTO meals (id, title, description, userId, userGroupId)
VALUES ('{0}', '{1}', '{2}', '{3}', '{4}');
COMMIT;", x.id, x.title, x.description, x.userId, x.userGroupId);
command = new SQLiteCommand(sql, connection);
command.ExecuteNonQuery();
connection.Close();
/* int idx = 0;
* foreach (var m in x.data.meals) {
* m.code = string.Format("MM{0}", idx);
* x.data.energyPerc[idx].meal.code = m.code;
* idx++;
* }*/
SaveJsonToFile(userId, x.id, JsonConvert.SerializeObject(x.data, Formatting.None));
return(JsonConvert.SerializeObject(x, Formatting.None));
}
} catch (Exception e) { return(e.Message); }
}
public string Get(string userId, string id)
{
try {
NewMyMeals x = new NewMyMeals();
db.AddColumn(userId, db.GetDataBasePath(userId, userDataBase), db.meals, MEAL_DATA, "TEXT"); //new column in meals tbl.
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + db.GetDataBasePath(userId, userDataBase))) {
connection.Open();
string sql = string.Format("SELECT id, title, description, userId, userGroupId, mealData FROM meals 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 ? "" : reader.GetString(0);
x.title = reader.GetValue(1) == DBNull.Value ? "" : reader.GetString(1);
x.description = reader.GetValue(2) == DBNull.Value ? "" : reader.GetString(2);
x.userId = reader.GetValue(3) == DBNull.Value ? "" : reader.GetString(3);
x.userGroupId = reader.GetValue(4) == DBNull.Value ? "" : reader.GetString(4);
//x.data = JsonConvert.DeserializeObject<JsonFileMeals>(GetJsonFile(userId, id)); // OLD
string data = reader.GetValue(5) == DBNull.Value ? null : reader.GetString(5);
if (!string.IsNullOrWhiteSpace(data))
{
x.data = JsonConvert.DeserializeObject <JsonFileMeals>(data); // new sistem: recipe saved in db
}
else
{
x.data = JsonConvert.DeserializeObject <JsonFileMeals>(GetJsonFile(userId, id)); // old sistem: recipe saved in json file
}
}
}
}
}
return(JsonConvert.SerializeObject(x, Formatting.None));
} catch (Exception e) {
L.SendErrorLog(e, id, userId, "MyMeals", "Get");
return(JsonConvert.SerializeObject(e.Message, Formatting.None));
}
}
public string Template(Users.NewUser user, string lang)
{
NewMyMeals x = new NewMyMeals();
x.id = Guid.NewGuid().ToString();
x.title = t.Tran("example", lang).ToUpper();
x.description = t.Tran("this is just an example, not a recommendation", lang);
x.userId = user.userId;
x.userGroupId = user.userGroupId;
List <Meals.NewMeal> mm = new List <Meals.NewMeal>();
List <Foods.MealsRecommendationEnergy> ee = new List <Foods.MealsRecommendationEnergy>();
string meal = t.Tran("meal", lang);
Meals.NewMeal m = new Meals.NewMeal();
m.code = "MM0";
m.title = string.Format("{0} 1", meal);
m.description = "07:00";
m.isSelected = true;
m.isDisabled = false;
mm.Add(m);
Foods.MealsRecommendationEnergy e = new Foods.MealsRecommendationEnergy();
e.meal.code = m.code;
e.meal.energyMinPercentage = 10;
e.meal.energyMaxPercentage = 15;
ee.Add(e);
m = new Meals.NewMeal();
m.code = "MM1";
m.title = string.Format("{0} 2", meal);
m.description = "9:30";
m.isSelected = true;
m.isDisabled = false;
mm.Add(m);
e = new Foods.MealsRecommendationEnergy();
e.meal.code = m.code;
e.meal.energyMinPercentage = 5;
e.meal.energyMaxPercentage = 10;
ee.Add(e);
m = new Meals.NewMeal();
m.code = "MM2";
m.title = string.Format("{0} 3", meal);
m.description = "11:00";
m.isSelected = true;
m.isDisabled = false;
mm.Add(m);
e = new Foods.MealsRecommendationEnergy();
e.meal.code = m.code;
e.meal.energyMinPercentage = 20;
e.meal.energyMaxPercentage = 25;
ee.Add(e);
m = new Meals.NewMeal();
m.code = "MM3";
m.title = string.Format("{0} 4", meal);
m.description = "13:00";
m.isSelected = true;
m.isDisabled = false;
mm.Add(m);
e = new Foods.MealsRecommendationEnergy();
e.meal.code = m.code;
e.meal.energyMinPercentage = 10;
e.meal.energyMaxPercentage = 15;
ee.Add(e);
m = new Meals.NewMeal();
m.code = "MM4";
m.title = string.Format("{0} 5", meal);
m.description = "14:30";
m.isSelected = true;
m.isDisabled = false;
mm.Add(m);
e = new Foods.MealsRecommendationEnergy();
e.meal.code = m.code;
e.meal.energyMinPercentage = 10;
e.meal.energyMaxPercentage = 15;
ee.Add(e);
m = new Meals.NewMeal();
m.code = "MM5";
m.title = string.Format("{0} 6", meal);
m.description = "17:00";
m.isSelected = true;
m.isDisabled = false;
mm.Add(m);
e = new Foods.MealsRecommendationEnergy();
e.meal.code = m.code;
e.meal.energyMinPercentage = 5;
e.meal.energyMaxPercentage = 10;
ee.Add(e);
m = new Meals.NewMeal();
m.code = "MM6";
m.title = string.Format("{0} 7", meal);
m.description = "20:00";
m.isSelected = true;
m.isDisabled = false;
mm.Add(m);
e = new Foods.MealsRecommendationEnergy();
e.meal.code = m.code;
e.meal.energyMinPercentage = 2;
e.meal.energyMaxPercentage = 5;
ee.Add(e);
JsonFileMeals data = new JsonFileMeals();
data.meals = mm;
data.energyPerc = ee;
x.data = data;
return(JsonConvert.SerializeObject(x, Formatting.None));
}
