public void UpdateUnits(UnitEnergy newUnitEnergy)
{
SqlHelper.ExecuteNonQuery(cs, "UpdateUnitOfMesurement",
newUnitEnergy.Id,
newUnitEnergy.Value,
newUnitEnergy.Unit.Id,
newUnitEnergy.Kcal);
}
public void InsertUnitEnergy(UnitEnergy unit, int ingID)
{
SqlHelper.ExecuteNonQuery(cs, "insertUnitOfMesurementForIngredient",
unit.Value,
ingID,
unit.Unit.Id,
unit.Kcal
);
}
void Start()
{
TurnManager.Instance.NewTurnEvent += OnNewTurn;
UsesLeft = UsesPerBattle;
myUnit = GetComponent <UnitScript>();
myEnergy = GetComponent <UnitEnergy>();
AbilitySource = gameObject.AddComponent <AudioSource>();
OnStart();
}
void FillTheBar()
{
UnitEnergy unit = MouseManager.Instance.SelectedUnit.GetComponent <UnitEnergy>();
EnergyBar.SetActive(unit.MaxEnergy > 0);
float velocity = 0;
fillOfABar.fillAmount = Mathf.SmoothDamp(fillOfABar.fillAmount, ((float)unit.CurrentEnergy / (float)unit.MaxEnergy), ref velocity, barAnimationTime);
amount.text = "Energy: " + unit.CurrentEnergy.ToString() + "/" + unit.MaxEnergy.ToString();
}
public MenuViewModel GetMenu(DateTime date, int userId)
{
ds = SqlHelper.ExecuteDataset(cs, "getMealsForMenu", userId, date);
MenuViewModel menu = new MenuViewModel();
menu.ForDay = date;
foreach (DataRow row in ds.Tables[0].Rows)
{
Meal meal = new Meal();
meal.Id = (int)row["IDMeal"];
meal.Name = row["Name"].ToString();
meal.MealNameId = (int)row["MealNameID"];
DataSet ings = SqlHelper.ExecuteDataset(cs, "getIngredientsForMeal", meal.Id);
foreach (DataRow ingRow in ings.Tables[0].Rows)
{
IngredientViewModel ingVM = new IngredientViewModel();
var tmpIng = new Ingredient
{
Id = (int)ingRow["IDIngredient"],
Name = ingRow["Name"].ToString(),
TypeId = (int)ingRow["IDIngredientType"],
};
ingVM.BindIngredient(tmpIng);
DataSet units = SqlHelper.ExecuteDataset(cs, "getCalculatedEnergy", ingVM.Id, meal.Id);
foreach (DataRow unit in units.Tables[0].Rows)
{
UnitEnergy ue = new UnitEnergy();
ue.Value = float.Parse(unit["CalculatedValue"].ToString());
ue.Unit = new UnitOfMesurement
{
Id = (int)unit["UnitOfMesurementID"],
Type = unit["Type"].ToString()
};
ingVM.CalculatedUnitEnergy.Add(ue);
}
meal.Ingredients.Add(ingVM);
}
menu.Meals.Add(meal);
}
return(menu);
}
