protected void btnKreirajObrok_Click(object sender, EventArgs e)
{
List <NamirniceModel> kolekcija = new List <NamirniceModel>();
ObrokModel o = new ObrokModel();
o.NazivObroka = ddlObrok.SelectedValue;
o.DatumIzrade = DateTime.Parse(txtDatum.Text);
foreach (GridViewRow row in gvPopisNamirnica.Rows)
{
CheckBox cb = (CheckBox)row.FindControl("cbOdaberi");
//Label lblNaziv = (Label)row.FindControl("lblNaziv");
//Label lblEnergija_kJ = (Label)row.FindControl("lblEnergija_kJ");
//Label lblEnergija_kcal = (Label)row.FindControl("lblEnergija_kcal");
TextBox txtGrami = (TextBox)row.FindControl("lblGrami");
TextBox txtKomad = (TextBox)row.FindControl("lblKomad");
TextBox txtZlica = (TextBox)row.FindControl("lblZlica");
TextBox txtSalica = (TextBox)row.FindControl("lblSalica");
//Label lblTipNamirnice = (Label)row.FindControl("lblTipNamirnice");
if (cb != null && cb.Checked)
{
var id = (int)gvPopisNamirnica.DataKeys[row.RowIndex]["IDNamirnice"];
NamirniceModel n = new NamirniceModel();
n.IDNamirnice = id;
n.Grami = !string.IsNullOrWhiteSpace(txtGrami.Text) ? int.Parse(txtGrami.Text) : 0;
n.Komad = !string.IsNullOrWhiteSpace(txtKomad.Text) ? int.Parse(txtKomad.Text) : 0;
n.Zlica = !string.IsNullOrWhiteSpace(txtZlica.Text) ? int.Parse(txtZlica.Text) : 0;
n.Salica = !string.IsNullOrWhiteSpace(txtSalica.Text) ? int.Parse(txtSalica.Text) : 0;
kolekcija.Add(n);
}
}
if (kolekcija != null && kolekcija.Count > 0)
{
var idMeal = (int)repo.InsertMeal(o);
foreach (var item in kolekcija)
{
var KolicinaID = (int)repoNamirnica.InsertMeasurementForIngredient(item);
repo.InsertIntoMealIngredients(idMeal, item.IDNamirnice, KolicinaID);
}
//Session.Clear();
Session.Remove("listaNamirnica");
}
Response.Redirect("CreateMealPage.aspx");
}
public List <ObrokModel> GetMealList()
{
ds = SqlHelper.ExecuteDataset(cs, "GetMeal");
List <ObrokModel> kolekcija = new List <ObrokModel>();
foreach (DataRow row in ds.Tables[0].Rows)
{
ObrokModel o = new ObrokModel();
o.IDObrok = (int)row["IDObrok"];
o.NazivObroka = (string)row["NazivObroka"];
o.DatumIzrade = (DateTime)row["DatumIzrade"];
kolekcija.Add(o);
}
return(kolekcija);
}
private void CreateElement(ObrokModel item)
{
Table tbl = new Table();
tbl.ID = $"tbl{item.IDObrok}";
tbl.CssClass = "table table-stripped border border-secondary";
TableCell nazivObrokaHeader = new TableCell();
nazivObrokaHeader.CssClass = "font-weight-bold";
TableCell namirniceCellHeader = new TableCell();
namirniceCellHeader.CssClass = "font-weight-bold";
TableCell gramiCellHeader = new TableCell();
gramiCellHeader.CssClass = "font-weight-bold";
TableCell komadCellHeader = new TableCell();
komadCellHeader.CssClass = "font-weight-bold";
TableCell zlicaCellHeader = new TableCell();
zlicaCellHeader.CssClass = "font-weight-bold";
TableCell salicaCellHeader = new TableCell();
salicaCellHeader.CssClass = "font-weight-bold";
TableCell tipNamirniceCellHeader = new TableCell();
tipNamirniceCellHeader.CssClass = "font-weight-bold";
TableCell btnCellHeader = new TableCell(); //?? za button
nazivObrokaHeader.Text = "Obrok";
namirniceCellHeader.Text = "Namirnice";
gramiCellHeader.Text = "Grami";
komadCellHeader.Text = "Komad";
zlicaCellHeader.Text = "Žlica";
salicaCellHeader.Text = "Šalica";
tipNamirniceCellHeader.Text = "Tip namirnice";
//header
TableHeaderRow tblHeaderRow = new TableHeaderRow();
tblHeaderRow.CssClass = "bg-secondary text-white";
tblHeaderRow.Cells.Add(nazivObrokaHeader);
tblHeaderRow.Cells.Add(namirniceCellHeader);
tblHeaderRow.Cells.Add(gramiCellHeader);
tblHeaderRow.Cells.Add(komadCellHeader);
tblHeaderRow.Cells.Add(zlicaCellHeader);
tblHeaderRow.Cells.Add(salicaCellHeader);
tblHeaderRow.Cells.Add(tipNamirniceCellHeader);
tbl.Controls.Add(tblHeaderRow);
//1. row
TableRow row = new TableRow();
TableCell obrokCell = new TableCell();
obrokCell.VerticalAlign = VerticalAlign.Middle;
obrokCell.Text = item.NazivObroka;
TableCell namirnicaCell = CreateCells(item.IDObrok, CreateCellByType.namirnice);
namirnicaCell.Width = 250;
TableCell gramiCell = CreateCells(item.IDObrok, CreateCellByType.grami);
TableCell komadCell = CreateCells(item.IDObrok, CreateCellByType.komad);
TableCell zlicaCell = CreateCells(item.IDObrok, CreateCellByType.zlica);
TableCell salicaCell = CreateCells(item.IDObrok, CreateCellByType.salica);
TableCell tipNamirniceCell = CreateCells(item.IDObrok, CreateCellByType.tipNamirnice);
row.Cells.Add(obrokCell);
row.Cells.Add(namirnicaCell);
row.Cells.Add(gramiCell);
row.Cells.Add(komadCell);
row.Cells.Add(zlicaCell);
row.Cells.Add(salicaCell);
row.Cells.Add(tipNamirniceCell);
tbl.Controls.Add(row);
//row2
TableRow rowButton = new TableRow();
var id = item.IDObrok;
TableCell emptyCell = new TableCell();
emptyCell.ColumnSpan = 6;
TableCell btnObrisi = CreateButton(id);
rowButton.Cells.Add(emptyCell);
rowButton.Cells.Add(btnObrisi);
tbl.Controls.Add(rowButton);
phcontainer.Controls.Add(tbl);
}
public decimal InsertMeal(ObrokModel o)
{
return((decimal)SqlHelper.ExecuteScalar(cs, "InsertMeal", o.NazivObroka, o.DatumIzrade));
}
