private void frmIzlaz_Load(object sender, EventArgs e) { comboBoxNarudžba.DataSource = DBNarudzbe.SelectAktivne().ToList(); comboBoxNarudžba.ValueMember = "NarudzbaID"; comboBoxNarudžba.DisplayMember = "BrojNarudzbe"; dateTimePickerDatum.Visible = false; }
protected void proizvodiGrid_ItemCommand(object source, DataGridCommandEventArgs e) { if (e.CommandName == "dodajUKorpu") { int igraID = Convert.ToInt32(proizvodiGrid.DataKeys[e.Item.ItemIndex]); IgraID = igraID; if (narudzba == null) { narudzba = new Services.Data.Narudzbe(); var max = DBNarudzbe.GetZadnjaNarudza(); narudzba.NarudzbaID = max + 1; int broj = Convert.ToInt32(max + 1); narudzba.BrojNarudzbe = broj + "" + DateTime.Now.Year; iznosRacuna = 0; narudzba.Datum = DateTime.Now; narudzba.Otkazano = false; narudzba.Status = true; } foreach (NarudzbeStavke s in narudzba.NarudzbeStavke) { if (s.IgraID == igraID) { s.Kolicina = s.Kolicina + 1; iznosRacuna = iznosRacuna + s.Igre.Cijena; return; } } NarudzbeStavke stavka = new NarudzbeStavke(); stavka.IgraID = igraID; stavka.Igre = Services.Data.DBProizvodi.IgreSelectByID(igraID); stavka.Kolicina = 1; narudzba.NarudzbeStavke.Add(stavka); iznosRacuna = iznosRacuna + stavka.Igre.Cijena; HyperLink korpalink = (HyperLink)this.Master.FindControl("korpalink"); korpalink.Text = string.Format("Moja Korpa({0})", narudzba.NarudzbeStavke.Count); } }
protected void Button1_Click(object sender, EventArgs e) { DBNarudzbe.InsertNarudzba(narudzba, User.Identity.Name); narudzba = null; iznosRacuna = 0; racun.Text = "0"; narudzbeGrid.DataBind(); HyperLink cartLink = (HyperLink)this.Master.FindControl("korpalink"); cartLink.Text = "Moja Korpa"; Button1.Enabled = false; }
protected void btnDodajUKorpu_Click(object sender, EventArgs e) { int igraID = Convert.ToInt32(Request.QueryString["id"]); if (narudzba == null) { narudzba = new Services.Data.Narudzbe(); var max = DBNarudzbe.GetZadnjaNarudza(); narudzba.NarudzbaID = max + 1; int broj = Convert.ToInt32(max + 1); narudzba.BrojNarudzbe = broj + "" + DateTime.Now.Year; iznosRacuna = 0; narudzba.Datum = DateTime.Now; narudzba.Otkazano = false; narudzba.Status = true; } foreach (NarudzbeStavke s in narudzba.NarudzbeStavke) { if (s.IgraID == igraID) { s.Kolicina = s.Kolicina + 1; iznosRacuna = iznosRacuna + s.Igre.Cijena; return; } } NarudzbeStavke stavka = new NarudzbeStavke(); stavka.IgraID = igraID; stavka.Igre = Services.Data.DBProizvodi.IgreSelectByID(igraID); stavka.Kolicina = 1; narudzba.NarudzbeStavke.Add(stavka); iznosRacuna = iznosRacuna + stavka.Igre.Cijena; HyperLink korpalink = (HyperLink)this.Master.FindControl("korpalink"); korpalink.Text = string.Format("Moja Korpa({0})", narudzba.NarudzbeStavke.Count); }
private void bindgrid() { int id = DBKupci.SelectIDByKorisnickoIme(User.Identity.Name); List <SELECTNARUDZBABYKUPAC_Result> Sve = DBNarudzbe.SelectAllNarudzbe(id); Sve = Sve.GroupBy(x => x.NarudzbaID).Select(x => x.First()).ToList(); DropDownListHistory.DataSource = Sve; DropDownListHistory.DataValueField = "NarudzbaID"; DropDownListHistory.DataTextField = "Datum"; DropDownListHistory.DataBind(); }