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