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)); }