private void FillDropDownList()
{
if (mealsList == null)
{
mealsList = new List <Meal>();
}
mealsList = SQLProcedures.GetMeals();
List <string> numberList;
if (mealsList.Count > 8)
{
numberList = new List <string>(mealNumberList);
ddlBrojObroka.DataSource = numberList;
ddlBrojObroka.DataBind();
}
else
{
int availableMeals = mealsList.Count(m => m.IsValid == true);
numberList = new List <string>();
for (int i = 0; i < availableMeals + 1; i++)
{
numberList.Add(mealNumberList[i]);
}
ddlBrojObroka.DataSource = numberList;
ddlBrojObroka.DataBind();
}
}
private void FillObrociDDL()
{
mealsList = SQLProcedures.GetMeals();
for (int i = 0; i < gvCombinations.Rows.Count; i++)
{
DropDownList ddl = gvCombinations.Rows[i].FindControl("ddlObroci") as DropDownList;
HiddenField hf = gvCombinations.Rows[i].FindControl("hfIDObrok") as HiddenField;
ddl.DataSource = mealsList;
ddl.DataTextField = "Name";
ddl.DataValueField = "IDMeal";
if (string.IsNullOrEmpty(txtStartDate.Text))
{
ddl.SelectedIndex = mealsList.FindIndex(m => m.IDMeal == (i + 1));
}
else
{
ddl.SelectedIndex = mealsList.FindIndex(m => m.IDMeal == int.Parse(hf.Value));
}
ddl.DataBind();
}
}
protected void btnSpremi_Click(object sender, EventArgs e)
{
int numberOfMeals = int.Parse(ddlBrojObroka.SelectedValue);
int combID;
if (!string.IsNullOrEmpty(txtStartDate.Text))
{
lblError.Text = string.Empty;
DateTime startDate = DateTime.Parse(txtStartDate.Text);
DateTime endDate;
if (!string.IsNullOrEmpty(txtEndDate.Text))
{
endDate = DateTime.Parse(txtEndDate.Text);
if (endDate < DateTime.Now)
{
lblError.Text = "Uneseni datum isteka je već prošao";
return;
}
combID = SQLProcedures.InsertCombination(numberOfMeals, startDate, endDate);
}
else
{
combID = SQLProcedures.InsertCombination(numberOfMeals, startDate, null);
}
mealsList = SQLProcedures.GetMeals();
for (int i = 0; i < gvCombinations.Rows.Count; i++)
{
MealRatio mealRatio = new MealRatio();
DropDownList ddl = gvCombinations.Rows[i].FindControl("ddlObroci") as DropDownList;
if (mealsList.Find(m => m.Name == ddl.SelectedItem.Text).IsValid)
{
mealRatio.Meal = mealsList.Find(m => m.Name == ddl.SelectedItem.Text);
}
else
{
lblError.Text = $"Odabran obrok u {i + 1}. redu nije dozvoljen - pogledati tablicu Obroci";
SQLProcedures.DeleteCombination(combID);
return;
}
var txtFat = gvCombinations.Rows[i].FindControl("txtMasti") as TextBox;
var txtCarb = gvCombinations.Rows[i].FindControl("txtUgljikohidrati") as TextBox;
var txtProt = gvCombinations.Rows[i].FindControl("txtBjelancevine") as TextBox;
var txtTotal = gvCombinations.Rows[i].FindControl("txtUkupno") as TextBox;
if (int.TryParse(txtFat.Text, out int fat))
{
mealRatio.FatPortion = fat;
}
else
{
lblError.Text = $"Unesena vrijednost masti za obrok {mealRatio.Meal.Name} nije valjana";
SQLProcedures.DeleteCombination(combID);
return;
}
if (int.TryParse(txtCarb.Text, out int carb))
{
mealRatio.CarbPortion = carb;
}
else
{
lblError.Text = $"Unesena vrijednost ugljikohidrata za obrok {mealRatio.Meal.Name} nije valjana";
SQLProcedures.DeleteCombination(combID);
return;
}
if (int.TryParse(txtProt.Text, out int prot))
{
mealRatio.ProteinPortion = prot;
}
else
{
lblError.Text = $"Unesena vrijednost bjelancevina za obrok {mealRatio.Meal.Name} nije valjana";
SQLProcedures.DeleteCombination(combID);
return;
}
if (int.TryParse(txtTotal.Text, out int total))
{
mealRatio.TotalPortion = total;
}
else
{
lblError.Text = $"Unesena vrijednost ukupnog udjela za obrok {mealRatio.Meal.Name} nije valjana";
SQLProcedures.DeleteCombination(combID);
return;
}
newMealRatiosList.Add(mealRatio);
}
AddNewMealRatios(combID);
}
else
{
lblError.Text = "Početni datum nije definiran";
}
}