void Awake()
{
isNoAds = scr.univFunc.Int2Bool(PlayerPrefs.GetInt("NoAds"));
switch (SceneManager.GetActiveScene().buildIndex)
{
case 1:
scr.alPrScr.game = 0;
scr.alPrScr.doCh = true;
PlayerPrefs.SetInt("CanRestart", 2);
scr.buf.isPractice = false;
scr.allAw.allAwPan.SetActive(false);
scr.alPrScr.isRandGame = 0;
Time.timeScale = 1f;
_menues = Menues.mainMenu;
DestroyImmediate(GameObject.Find("ChampList"));
DestroyImmediate(GameObject.Find("ChampListImage"));
break;
case 2:
break;
}
scr.alPrScr.doCh = true;
}
public string CreateWeeklyShoppingList(string userId, List <string> menuList, int consumers, string lang, bool isNutritionStandard)
{
try {
Menues me = new Menues();
List <Foods.NewFood> x = new List <Foods.NewFood>();
foreach (string m in menuList)
{
if (!string.IsNullOrEmpty(m))
{
Menues.NewMenu wm = new Menues.NewMenu();
if (isNutritionStandard)
{
NutritionStandards NS = new NutritionStandards();
wm = NS.GetMenu(userId, m, lang);
}
else
{
wm = me.WeeklyMenu(userId, m);
}
x.AddRange(wm.data.selectedFoods);
}
}
return(JsonConvert.SerializeObject(CreateShoppingList(x, consumers, userId, lang), Formatting.None));
} catch (Exception e) {
L.SendErrorLog(e, null, userId, "ShoppingList", "CreateWeeklyShoppingList");
return(JsonConvert.SerializeObject(e.Message, Formatting.None));
}
}
public void Add(MenuItem m)
{
var x = m as SubMenu;
if (x != null)
{
Add(x);
}
else
{
Menues.Add(m);
}
}
public void MenuProfilePlayers()
{
if (!firstCallProfPl)
{
scr.objM.cP.anchoredPosition = new Vector2(
0.0f, scr.objM.cP.anchoredPosition.y);
firstCallProfPl = true;
}
scr.objM.currPrPan.SetActive(false);
scr.prMng.SetOpenedPlayersCountryText(false);
_menues = Menues.menuPlayers;
}
public void Add(SubMenu m)
{
m.NotifySectedTo(y =>
{
if (Level == 0)
{
CurrentMenu = y;
Level++;
}
else
{
CurrentChildMenu = y;
Level++;
}
});
Menues.Add(m);
}
public string CreateWeeklyShoppingList(string userId, List <string> menuList, int consumers, string lang)
{
try {
Menues me = new Menues();
List <Foods.NewFood> x = new List <Foods.NewFood>();
foreach (string m in menuList)
{
if (!string.IsNullOrEmpty(m))
{
Menues.NewMenu wm = me.WeeklyMenu(userId, m);
x.AddRange(wm.data.selectedFoods);
}
}
return(JsonConvert.SerializeObject(CreateShoppingList(x, consumers, lang), Formatting.None));
} catch (Exception e) {
return(e.Message);
}
}
private Menues.NewMenu GetData(SQLiteDataReader reader, string userId, string lang)
{
Clients.Client client = new Clients.Client();
Menues.NewMenu x = new Menues.NewMenu();
x.id = reader.GetValue(0) == DBNull.Value ? null : reader.GetString(0);
x.title = reader.GetValue(1) == DBNull.Value ? null : reader.GetString(1);
x.diet = reader.GetValue(2) == DBNull.Value ? null : reader.GetString(2);
x.date = reader.GetValue(3) == DBNull.Value ? DateTime.UtcNow.ToString() : reader.GetString(3);
x.note = reader.GetValue(4) == DBNull.Value ? null : reader.GetString(4);
x.userId = reader.GetValue(5) == DBNull.Value ? null : reader.GetString(5);
x.userId = reader.GetValue(6) == DBNull.Value ? null : reader.GetString(6);
x.userGroupId = reader.GetValue(7) == DBNull.Value ? null : reader.GetString(7);
x.nutritionStandard = new NewNutritionStandard();
x.nutritionStandard.code = reader.GetValue(8) == DBNull.Value ? null : reader.GetString(8);
x.nutritionStandard = GetNutritionStandardData(x.nutritionStandard.code, lang);
x.nutritionStandard.module = new NewModule();
x.nutritionStandard.module.code = reader.GetValue(9) == DBNull.Value ? null : reader.GetString(9);
x.nutritionStandard.module = GetModuleData(x.nutritionStandard.module.code, lang, x.nutritionStandard.age);
x.energy = reader.GetValue(10) == DBNull.Value ? 0 : Convert.ToDouble(reader.GetString(10));
x.nutritionStandard.energy = reader.GetValue(11) == DBNull.Value ? 0 : Convert.ToDouble(reader.GetString(11));
x.nutritionStandard.module.energy = reader.GetValue(12) == DBNull.Value ? 0 : Convert.ToDouble(reader.GetString(12));
string data = reader.GetValue(13) == DBNull.Value ? null : reader.GetString(13);
if (!string.IsNullOrWhiteSpace(data))
{
x.data = JsonConvert.DeserializeObject <Menues.Data>(data);
}
if (x.data.selectedFoods.Count == 0)
{
x.data.selectedFoods = new List <Foods.NewFood>();
x.data.selectedInitFoods = new List <Foods.NewFood>();
x.data.meals = GetModuleData(x.nutritionStandard.code, null, x.nutritionStandard.age).meals;
}
if (x.data != null)
{
Menues M = new Menues();
x.splitMealDesc = M.MealTitleDesc(x.data.meals);
}
x.client.clientData = new ClientsData.NewClientData();
return(x);
}
public void DependentMenuBack()
{
switch (_menues)
{
case Menues.mainMenu:
ExitGame();
break;
case Menues.menuCareer:
scr.objM.Menu_Tournaments(false);
break;
case Menues.menuPlayers:
scr.objM.Menu_Players(false);
break;
case Menues.menuUpgrades:
scr.objM.Menu_Upgrades(false);
break;
}
_menues = Menues.mainMenu;
}
public void Clear()
{
Menues.Clear();
Mru.Clear();
}
public string GetWeeklyMenusTotals(string userId, List <string> menuList)
{
try {
Foods f = new Foods();
List <Foods.Totals> xx = new List <Foods.Totals>();
List <List <Foods.MealsTotal> > lmt = new List <List <Foods.MealsTotal> >();
List <Foods.MealsTotal> mt_ = new List <Foods.MealsTotal>();
foreach (string menu in menuList)
{
if (!string.IsNullOrEmpty(menu))
{
Menues m = new Menues();
Menues.NewMenu nm = new Menues.NewMenu();
nm = m.WeeklyMenu(userId, menu);
Foods.Totals t = new Foods.Totals();
t = f.GetTotals_(nm.data.selectedFoods, nm.data.meals);
xx.Add(t);
List <Foods.MealsTotal> mt = new List <Foods.MealsTotal>();
mt = f.GetMealsTotal(nm.data.selectedFoods, nm.data.meals);
lmt.Add(mt);
}
}
foreach (List <Foods.MealsTotal> l in lmt)
{
foreach (Foods.MealsTotal o in l)
{
mt_.Add(o);
}
}
List <Foods.MealsTotal> distMeal = mt_.GroupBy(a => a.code).Select(b => b.First()).ToList();
List <Foods.MealsTotal> zz = new List <Foods.MealsTotal>();
foreach (var ii in distMeal)
{
Foods.MealsTotal z = new Foods.MealsTotal();
z.code = ii.code;
z.title = ii.title;
List <Foods.MealsTotal> fmt_energy = mt_.Where(a => a.code == ii.code).ToList();
z.energy.val = fmt_energy.Count() > 0 ? Math.Round(fmt_energy.Average(a => a.energy.val), 1) : 0;
List <Foods.MealsTotal> fmt_energyPerc = mt_.Where(a => a.code == ii.code).ToList();
z.energy.perc = fmt_energyPerc.Count() > 0 ? Math.Round(fmt_energyPerc.Average(a => a.energy.perc), 1) : 0;
List <Foods.MealsTotal> fmt_carbohydrates = mt_.Where(a => a.code == ii.code).ToList();
z.carbohydrates.val = fmt_carbohydrates.Count() > 0 ? Math.Round(fmt_carbohydrates.Average(a => a.carbohydrates.val), 1) : 0;
List <Foods.MealsTotal> fmt_carbohydratesPerc = mt_.Where(a => a.code == ii.code).ToList();
z.carbohydrates.perc = fmt_carbohydratesPerc.Count() > 0 ? Math.Round(fmt_carbohydratesPerc.Average(a => a.carbohydrates.perc), 1) : 0;
List <Foods.MealsTotal> fmt_proteins = mt_.Where(a => a.code == ii.code).ToList();
z.proteins.val = fmt_proteins.Count() > 0 ? Math.Round(fmt_proteins.Average(a => a.proteins.val), 1) : 0;
List <Foods.MealsTotal> fmt_proteinsPerc = mt_.Where(a => a.code == ii.code).ToList();
z.proteins.perc = fmt_proteinsPerc.Count() > 0 ? Math.Round(fmt_proteinsPerc.Average(a => a.proteins.perc), 1) : 0;
List <Foods.MealsTotal> fmt_fats = mt_.Where(a => a.code == ii.code).ToList();
z.fats.val = fmt_fats.Count() > 0 ? Math.Round(fmt_fats.Average(a => a.fats.val), 1) : 0;
List <Foods.MealsTotal> fmt_fatsPerc = mt_.Where(a => a.code == ii.code).ToList();
z.fats.perc = fmt_fatsPerc.Count() > 0 ? Math.Round(fmt_fatsPerc.Average(a => a.fats.perc), 1) : 0;
zz.Add(z);
}
Foods.Totals x = new Foods.Totals();
x.mass = f.SmartRound(xx.Average(a => a.mass));
x.energy = f.SmartRound(xx.Average(a => a.energy));
x.carbohydrates = f.SmartRound(xx.Average(a => a.carbohydrates));
x.carbohydratesPercentage = f.SmartRound(xx.Average(a => a.carbohydratesPercentage));
x.proteins = f.SmartRound(xx.Average(a => a.proteins));
x.proteinsPercentage = f.SmartRound(xx.Average(a => a.proteinsPercentage));
x.fats = f.SmartRound(xx.Average(a => a.fats));
x.fatsPercentage = f.SmartRound(xx.Average(a => a.fatsPercentage));
x.servings.cerealsServ = f.SmartRound(xx.Average(a => a.servings.cerealsServ));
x.servings.vegetablesServ = f.SmartRound(xx.Average(a => a.servings.vegetablesServ));
x.servings.fruitServ = f.SmartRound(xx.Average(a => a.servings.fruitServ));
x.servings.meatServ = f.SmartRound(xx.Average(a => a.servings.meatServ));
x.servings.milkServ = f.SmartRound(xx.Average(a => a.servings.milkServ));
x.servings.fatsServ = f.SmartRound(xx.Average(a => a.servings.fatsServ));
x.servings.otherFoodsServ = f.SmartRound(xx.Average(a => a.servings.otherFoodsServ));
x.servings.otherFoodsEnergy = f.SmartRound(xx.Average(a => a.servings.otherFoodsEnergy));
x.mealsTotal = zz;
x.starch = f.SmartRound(xx.Average(a => a.starch));
x.totalSugar = f.SmartRound(xx.Average(a => a.totalSugar));
x.glucose = f.SmartRound(xx.Average(a => a.glucose));
x.fructose = f.SmartRound(xx.Average(a => a.fructose));
x.saccharose = f.SmartRound(xx.Average(a => a.saccharose));
x.maltose = f.SmartRound(xx.Average(a => a.maltose));
x.lactose = f.SmartRound(xx.Average(a => a.lactose));
x.fibers = f.SmartRound(xx.Average(a => a.fibers));
x.saturatedFats = f.SmartRound(xx.Average(a => a.saturatedFats));
x.monounsaturatedFats = f.SmartRound(xx.Average(a => a.monounsaturatedFats));
x.polyunsaturatedFats = f.SmartRound(xx.Average(a => a.polyunsaturatedFats));
x.trifluoroaceticAcid = f.SmartRound(xx.Average(a => a.trifluoroaceticAcid));
x.cholesterol = f.SmartRound(xx.Average(a => a.cholesterol));
x.sodium = f.SmartRound(xx.Average(a => a.sodium));
x.potassium = f.SmartRound(xx.Average(a => a.potassium));
x.calcium = f.SmartRound(xx.Average(a => a.calcium));
x.magnesium = f.SmartRound(xx.Average(a => a.magnesium));
x.phosphorus = f.SmartRound(xx.Average(a => a.phosphorus));
x.iron = f.SmartRound(xx.Average(a => a.iron));
x.copper = f.SmartRound(xx.Average(a => a.copper));
x.zinc = f.SmartRound(xx.Average(a => a.zinc));
x.chlorine = f.SmartRound(xx.Average(a => a.chlorine));
x.manganese = f.SmartRound(xx.Average(a => a.manganese));
x.selenium = f.SmartRound(xx.Average(a => a.selenium));
x.iodine = f.SmartRound(xx.Average(a => a.iodine));
x.retinol = f.SmartRound(xx.Average(a => a.retinol));
x.carotene = f.SmartRound(xx.Average(a => a.carotene));
x.vitaminD = f.SmartRound(xx.Average(a => a.vitaminD));
x.vitaminE = f.SmartRound(xx.Average(a => a.vitaminE));
x.vitaminB1 = f.SmartRound(xx.Average(a => a.vitaminB1));
x.vitaminB2 = f.SmartRound(xx.Average(a => a.vitaminB2));
x.vitaminB3 = f.SmartRound(xx.Average(a => a.vitaminB3));
x.vitaminB6 = f.SmartRound(xx.Average(a => a.vitaminB6));
x.vitaminB12 = f.SmartRound(xx.Average(a => a.vitaminB12));
x.folate = f.SmartRound(xx.Average(a => a.folate));
x.pantothenicAcid = f.SmartRound(xx.Average(a => a.pantothenicAcid));
x.biotin = f.SmartRound(xx.Average(a => a.biotin));
x.vitaminC = f.SmartRound(xx.Average(a => a.vitaminC));
x.vitaminK = f.SmartRound(xx.Average(a => a.vitaminK));
x.price.value = Math.Round(xx.Average(a => a.price.value), 2);
return(JsonConvert.SerializeObject(x, Formatting.None));
} catch (Exception e) { return(JsonConvert.SerializeObject(e.Message, Formatting.None)); }
}
public string Save(string userId, Menues.NewMenu x, Users.NewUser user)
{
Menues.SaveResponse r = new Menues.SaveResponse();
try {
DB.CreateDataBase(userId, DB.nutritionStandards);
if (string.IsNullOrWhiteSpace(x.id) && Check(userId, x))
{
r.data = x;
r.msg = "there is already a menu with the same name";
r.isSuccess = false;
return(JsonConvert.SerializeObject(r, Formatting.None));
}
Global G = new Global();
if (!G.CheckUserPermission(user, x.userId))
{
r.data = x;
r.msg = "you can only save menus that you have created yourself";
r.isSuccess = false;
return(JsonConvert.SerializeObject(r, Formatting.None));
}
Menues M = new Menues();
x.data.meals = M.CombineTitleDesc(x);
string sql = null;
if (string.IsNullOrEmpty(x.id))
{
x.id = Guid.NewGuid().ToString();
sql = @"BEGIN;
INSERT INTO nutritionstandards (id, title, diet, date, note, userId, clientId, userGroupId, nutritionStandard, mealModule, energy, recommendedEnergy, recommendedModuleEnergy, menuData)
VALUES (@Id, @Title, @Diet, @Date, @Note, @UserId, @ClientId, @UserGroupId, @NutritionStandard, @MealModule, @Energy, @RecommendedEnergy, @RecommendedModuleEnergy, @MenuData);
COMMIT;";
}
else
{
sql = @"BEGIN;
UPDATE nutritionstandards SET
title = @Title, diet = @Diet, date = @Date, note = @Note, userId = @UserId, clientId = @ClientId, userGroupId = @UserGroupId, nutritionStandard = @NutritionStandard, mealModule = @MealModule, energy = @Energy, recommendedEnergy = @RecommendedEnergy, recommendedModuleEnergy = @RecommendedModuleEnergy, menuData = @MenuData
WHERE id = @Id;
COMMIT;";
}
using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + DB.GetDataBasePath(userId, userDataBase))) {
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(sql, connection)) {
command.Parameters.Add(new SQLiteParameter("Id", x.id));
command.Parameters.Add(new SQLiteParameter("Title", x.title));
command.Parameters.Add(new SQLiteParameter("Diet", x.diet));
command.Parameters.Add(new SQLiteParameter("Date", x.date));
command.Parameters.Add(new SQLiteParameter("Note", x.note));
command.Parameters.Add(new SQLiteParameter("UserId", user.userId));
command.Parameters.Add(new SQLiteParameter("ClientId", x.client.clientId));
command.Parameters.Add(new SQLiteParameter("UserGroupId", string.IsNullOrEmpty(x.userGroupId) ? userId : x.userGroupId));
command.Parameters.Add(new SQLiteParameter("NutritionStandard", x.nutritionStandard.code));
command.Parameters.Add(new SQLiteParameter("MealModule", x.nutritionStandard.module.code));
command.Parameters.Add(new SQLiteParameter("Energy", x.energy));
command.Parameters.Add(new SQLiteParameter("recommendedEnergy", x.nutritionStandard.energy));
command.Parameters.Add(new SQLiteParameter("recommendedModuleEnergy", x.nutritionStandard.module.energy));
command.Parameters.Add(new SQLiteParameter("MenuData", JsonConvert.SerializeObject(x.data, Formatting.None)));
command.ExecuteNonQuery();
}
}
r.data = x;
r.isSuccess = true;
return(JsonConvert.SerializeObject(r, Formatting.None));
} catch (Exception e) {
r.data = x;
r.msg = e.Message;
r.msg1 = "report a problem";
r.isSuccess = false;
L.SendErrorLog(e, x.id, userId, "Menues", "Save");
return(JsonConvert.SerializeObject(r, Formatting.None));
}
}
