private async void FrmNarudzbe_Load(object sender, EventArgs e) { NarudzbeSearchRequest search = new NarudzbeSearchRequest { Zavrsena = false, DatumNarudzbe = DateTime.Now }; List <StatusNarudzbe> lista = new List <StatusNarudzbe>(); lista.Add(new StatusNarudzbe { Status = "Na cekanju", Value = 0 }); lista.Add(new StatusNarudzbe { Status = "Zavrsene", Value = 1 }); cmbStatus.DataSource = lista; cmbStatus.DisplayMember = "Status"; cmbStatus.ValueMember = "Value"; await LoadNarudzbe(search); }
public async Task LoadNarudzbe(NarudzbeSearchRequest search) { dgvNarudzbe.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvNarudzbe.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells; dgvNarudzbe.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; //for (int i = 0; i <= dgvNarudzbe.Columns.Count - 1; i++) //{ // int colw = dgvNarudzbe.Columns[i].Width; // dgvNarudzbe.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.None; // dgvNarudzbe.Columns[i].Width = colw; //} var result = await _narudzbe.Get <List <Model.Narudzbe> >(search); List <NarudzbeKlijenti> lista = new List <NarudzbeKlijenti>(); foreach (var x in result) { var klijent = await _klijent.GetById <Model.Klijenti>(x.KlijentId); lista.Add(new NarudzbeKlijenti { NarudzbaId = x.NarudzbaId, DatumNarudžbe = x.DatumNarudžbe.ToString("dd.MM.yyyy - hh:mm"), Zavrsena = x.Zavrsena, Klijent = $"{klijent.Ime} {klijent.Prezime}" }); } dgvNarudzbe.AutoGenerateColumns = false; dgvNarudzbe.DataSource = lista; }
private async void TxtDatum_ValueChanged(object sender, EventArgs e) { NarudzbeSearchRequest search = new NarudzbeSearchRequest { DatumNarudzbe = txtDatum.Value }; await LoadNarudzbe(search); }
private async void BtnPrikazi_Click(object sender, EventArgs e) { var search = new NarudzbeSearchRequest() { BrojNarudzbe = txtPretraga.Text }; var result = await _service.Get <List <Model.Models.Narudzbe> >(search); dgvNarudzbe.DataSource = result; }
private async void BtnPretraga_Click(object sender, EventArgs e) { if (dtpDatumDo.Enabled == false && dtpDatumOd.Enabled == false && txtPretraga.Enabled == true) { var search = new ObavijestiSearchRequest() { Naslov = txtPretraga.Text }; var listaObavijesti = await _serviceObavijesti.Get <List <Model.Models.Obavijesti> >(search); List <Model.Models.ObavijestiIzvjestaj> result = new List <Model.Models.ObavijestiIzvjestaj>(); foreach (var item in listaObavijesti) { result.Add(new Model.Models.ObavijestiIzvjestaj { Naslov = item.Naslov, Tekst = item.Text }); } dataGridView1.DataSource = result; dataGridView1.Columns[1].Width = 400; } if (dtpDatumDo.Enabled == true && dtpDatumOd.Enabled == true && txtPretraga.Enabled == true) { var search = new NarudzbeSearchRequest() { BrojNarudzbe = txtPretraga.Text }; var listaNarudzbi = await _serviceNarudzbe.Get <List <Model.Models.Narudzbe> >(search); List <Model.Models.NarudzbeIzvjestaj> result = new List <Model.Models.NarudzbeIzvjestaj>(); foreach (var item in listaNarudzbi) { if (dtpDatumOd.Value < item.Datum && item.Datum < dtpDatumDo.Value) { result.Add(new Model.Models.NarudzbeIzvjestaj { BrojNarudzbe = item.BrojNarudzbe, Datum = item.Datum, IznosBezPdv = item.IznosBezPdv, IznosSaPdv = item.IznosSaPdv }); } } dataGridView1.DataSource = result; } }
public override List <Model.Narudzbe> Get(NarudzbeSearchRequest search) { var query = _context.Narudzbe.AsQueryable(); if (!string.IsNullOrWhiteSpace(search?.BrojNarudzbe)) { query = query.Where(x => x.BrojNarudzbe.StartsWith(search.BrojNarudzbe, StringComparison.CurrentCultureIgnoreCase)); } var narudzbe = query.ToList(); return(_mapper.Map <List <Model.Narudzbe> >(narudzbe)); }
private async void CmbStatus_SelectedIndexChanged(object sender, EventArgs e) { int?_id = null; var idObj = cmbStatus.SelectedValue; if (int.TryParse(idObj.ToString(), out int id)) { _id = id; } NarudzbeSearchRequest search = new NarudzbeSearchRequest { Zavrsena = Convert.ToBoolean(_id) }; await LoadNarudzbe(search); }
private async void BtnZavrsi_Click(object sender, EventArgs e) { NarudzbaUpsertRequest req = new NarudzbaUpsertRequest { NarudzbaId = _id, Zavrsena = true }; await _narudzba.Update <NarudzbaUpsertRequest>(_id, req); //var narudzba = await _narudzba.GetById<Model.Narudzbe>(_id); //var klijent = await _klijent.GetById<Model.Klijenti>(narudzba.KlijentId); MessageBox.Show("Narudzba uspjesno zavrsena", " ", MessageBoxButtons.OK, MessageBoxIcon.Information); NarudzbeSearchRequest reload = new NarudzbeSearchRequest { Zavrsena = false }; await _parent.LoadNarudzbe(reload); Close(); }
public async Task Init() { NarudzbeSearchRequest req = new NarudzbeSearchRequest() { KlijentId = Global.prijavljeniKorisnik.KorisnikId }; var list = await _narudzbe.Get <List <Model.Narudzbe> >(req); foreach (var x in list) { Narudzba nova = new Narudzba() { NarudzbaId = x.NarudzbaId, DatumNarudžbe = x.DatumNarudžbe, Zavrsena = x.Zavrsena, KlijentId = x.KlijentId }; Narudzbe.Add(nova); } }
public List <Narudzbe> Get(NarudzbeSearchRequest search) { var query = _context.Narudzba .Include(y => y.Klijent).Include(z => z.Korisnik).Include(p => p.Skladiste) .AsQueryable(); if (!string.IsNullOrWhiteSpace(search?.BrojNarudzbe)) { query = query.Where(x => x.BrojNarudzbe.StartsWith(search.BrojNarudzbe)); } var lista = query.ToList(); List <Narudzbe> result = new List <Narudzbe>(); foreach (var item in lista) { Narudzbe nova = new Narudzbe(); nova.BrojNarudzbe = item.BrojNarudzbe; nova.Datum = item.Datum; nova.IznosBezPdv = item.IznosBezPdv; nova.IznosSaPdv = item.IznosSaPdv; nova.KlijentId = item.KlijentId; nova.KlijentKorisnickoIme = item.Klijent.KorisnickoIme; nova.KorisnikId = item.Korisnik.KorisnikId; nova.KorisnikKorisnickoIme = item.Korisnik.KorisnickoIme; nova.NarudzbaId = item.NarudzbaId; nova.NazivSkladista = item.Skladiste.Naziv; nova.Otkazano = item.Otkazano; nova.SkladisteId = item.SkladisteId; nova.Status = item.Status; result.Add(nova); } return(result); }
public override List <Model.Narudzbe> Get(NarudzbeSearchRequest search) { List <Model.Narudzbe> lista = new List <Model.Narudzbe>(); var narudzba = _db.Narudzba.AsQueryable(); if (search.KlijentId != 0) { narudzba = narudzba.Where(w => w.KlijentId == search.KlijentId); } if (search.Zavrsena) { narudzba = narudzba.Where(w => w.Zavrsena); } else { narudzba = narudzba.Where(w => !w.Zavrsena); } narudzba = narudzba.Where(w => w.DatumNarudžbe.Day.Equals(search.DatumNarudzbe.Day) && w.DatumNarudžbe.Month.Equals(search.DatumNarudzbe.Month)); foreach (var item in narudzba) { lista.Add(new Model.Narudzbe { NarudzbaId = item.NarudzbaId, DatumNarudžbe = item.DatumNarudžbe, Zavrsena = item.Zavrsena, KlijentId = item.KlijentId, Klijent = _db.Korisnik.Where(w => w.KorisnikId == item.KlijentId).Select(w => w.Ime + " " + w.Prezime).FirstOrDefault() }); } return(lista); }
public List <Narudzbe> Get([FromQuery] NarudzbeSearchRequest search) { return(_service.Get(search)); }