public async Task Init()
{
decimal Total = 0;
NarudzbaSearchRequest request = new NarudzbaSearchRequest();
if (Global.NarudzbaId != 0)
{
request.NarudzbaId = Global.NarudzbaId;
var list = await _stavke.Get <IEnumerable <NarudzbeStavke> >(request);
StavkeList.Clear();
foreach (var stavka in list)
{
Total += (decimal)stavka.Proizvod.Cijena;
StavkeList.Add(stavka);
}
if (StavkeList.Count > 0)
{
Poruka = "";
}
else
{
Poruka = "Vaša košarica je prazna!";
}
}
else
{
Poruka = "Vaša košarica je prazna!";
}
Global.NarudzbaTotal = Total;
}
public async Task LoadNarudzbe(NarudzbaSearchRequest search)
{
dgvNarudzbe.BackgroundColor = Color.White;
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.Narudzba> >(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,
Zavrsena = x.Zavrsena,
Klijent = $"{klijent.Ime} {klijent.Prezime}"
});
}
dgvNarudzbe.AutoGenerateColumns = false;
dgvNarudzbe.DataSource = lista;
}
private async void DataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
var objId = dataGridView1.Rows[e.RowIndex].Cells[0].Value;
if (dataGridView1.Columns[e.ColumnIndex].Name == "Narudzbe")
{
NarudzbaSearchRequest req = new NarudzbaSearchRequest
{
KlijentId = int.Parse(objId.ToString())
};
dataGridView2.BackgroundColor = Color.White;
dataGridView2.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView2.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dataGridView2.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
for (int i = 0; i <= dataGridView2.Columns.Count - 1; i++)
{
int colw = dataGridView2.Columns[i].Width;
dataGridView2.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dataGridView2.Columns[i].Width = colw;
}
var result = await _narudzbe.Get <List <Model.Narudzba> >(req);
dataGridView2.AutoGenerateColumns = false;
dataGridView2.DataSource = result;
groupBox2.Show();
dataGridView2.Show();
}
}
public async Task Init()
{
NarudzbeStavkeList.Clear();
NarudzbaSearchRequest search = new NarudzbaSearchRequest();
search.ClanId = Global.LogiraniClanId;
var list = await _narudzbe.Get <IEnumerable <Narudzbe> >(search);
NarudzbeList.Clear();
foreach (var narudzba in list)
{
NarudzbeList.Add(narudzba);
}
if (NarudzbeList.Count > 0)
{
for (int i = 0; i < NarudzbeList.Count; i++)
{
NarudzbaStavkaSearchRequest request = new NarudzbaStavkaSearchRequest();
request.NarudzbaId = NarudzbeList[i].NarudzbaId;
var stavkeList = await _narudzbeStavke.Get <IEnumerable <NarudzbeStavke> >(request);
foreach (var stavka in stavkeList)
{
NarudzbeStavkeList.Add(stavka);
}
}
}
}
public List <OnlineGym_Model.Narudzbe> Get(NarudzbaSearchRequest search)
{
var query = _context.Set <Database.Narudzbe>().Include(c => c.Clan).AsQueryable();
if (search?.Datum.HasValue == true)
{
DateTime date = new DateTime();
date = search.Datum.Value;
query = query.Where(x => x.Datum.Date.CompareTo(date.Date) == 0);
}
if (search?.Procesirana.HasValue == true)
{
query = query.Where(x => x.Procesirana == search.Procesirana);
}
if (search?.ClanId.HasValue == true)
{
query = query.Where(x => x.ClanId == search.ClanId);
}
if (search?.NarudzbaId.HasValue == true)
{
query = query.Where(x => x.NarudzbaId == search.NarudzbaId);
}
query = query.OrderBy(x => x.Datum);
var list = query.ToList();
return(_mapper.Map <List <OnlineGym_Model.Narudzbe> >(list));
}
public List <Model.Narudzba> Get(NarudzbaSearchRequest request)
{
var query = _context.Narudzba.AsQueryable();
if (request?.DobavljacId != 0)
{
query = query.Where(x => x.DobavljacId == request.DobavljacId);
}
query = query.Include(x => x.Dobavljac);
query = query.Include(x => x.NarudzbaStavka);
List <Database.Narudzba> list = query.ToList();
List <Model.Narudzba> modelList = _mapper.Map <List <Model.Narudzba> >(list);
foreach (var item in modelList)
{
double iznos = 0;
foreach (var stavka in item.NarudzbaStavka)
{
Database.Lijek lijek = _context.Lijek.Find(stavka.LijekId);
iznos += lijek.CijenaPoKomadu * stavka.Kolicina;
}
item.Iznos = iznos;
}
return(modelList);
}
private async void btnPrikazi_Click(object sender, EventArgs e)
{
var search = new NarudzbaSearchRequest()
{
DobavljacId = ((Model.Dobavljac)cmbDobavljaci.SelectedItem).Id
};
var list = await _apiService.Get <List <Model.Narudzba> >(search);
dgvNarudzbe.AutoGenerateColumns = false;
dgvNarudzbe.DataSource = list;
}
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;
}
NarudzbaSearchRequest search = new NarudzbaSearchRequest
{
Zavrsena = Convert.ToBoolean(_id)
};
await LoadNarudzbe(search);
}
public async Task <IActionResult> Index(int page = 1, string search = null)
{
var request = new NarudzbaSearchRequest()
{
Adresa = search
};
var paginationQuery = new PaginationQuery(page, 10);
var narudzbeResponse = await _restoranApi.GetNarudzbaAsync(request, paginationQuery);
var model = new NarudzbePrikaz()
{
Narudzbe = narudzbeResponse.Content
};
return(View(model));
}
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.Narudzba>(_id);
var klijent = await _klijent.GetById<Model.Klijenti>(narudzba.KlijentId);
MessageBox.Show("Narudzba uspjesno zavrsena", " ", MessageBoxButtons.OK, MessageBoxIcon.Information);
await _klijent.Delete(klijent.KorisnikId);
NarudzbaSearchRequest reload = new NarudzbaSearchRequest { Zavrsena = false };
await _parent.LoadNarudzbe(reload);
Close();
}
public async Task Init()
{
NarudzbaSearchRequest req = new NarudzbaSearchRequest()
{
KlijentId = Global.prijavljeniKorisnik.KorisnikId
};
var list = await _narudzbe.Get <List <Model.Narudzba> >(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);
}
}
private async void FrmNarudzbe_Load(object sender, EventArgs e)
{
NarudzbaSearchRequest search = new NarudzbaSearchRequest
{
Zavrsena = false
};
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);
}
private async Task LoadProizvodi(int tipId)
{
var NarudzbeStavkeList = new List <OnlineGym_Model.NarudzbeStavke>();
var NarudzbeList = new List <OnlineGym_Model.Narudzbe>();
if (tipId == 0)
{
NarudzbaSearchRequest search = new NarudzbaSearchRequest();
search.ClanId = _id;
var list = await _narudzbe.Get <IEnumerable <OnlineGym_Model.Narudzbe> >(search);
foreach (var narudzba in list)
{
NarudzbeList.Add(narudzba);
}
if (NarudzbeList.Count > 0)
{
for (int i = 0; i < NarudzbeList.Count; i++)
{
NarudzbaStavkaSearchRequest request = new NarudzbaStavkaSearchRequest();
request.NarudzbaId = NarudzbeList[i].NarudzbaId;
var stavkeList = await _narudzbeStavke.Get <IEnumerable <NarudzbeStavke> >(request);
foreach (var stavka in stavkeList)
{
NarudzbeStavkeList.Add(stavka);
}
}
var dgvResult = new List <OnlineGym_Model.NarudzbeStavkeRezultat>();
foreach (var cl in NarudzbeStavkeList)
{
NarudzbeStavkeRezultat temp = new NarudzbeStavkeRezultat(cl);
dgvResult.Add(temp);
temp = null;
}
dgvProizvodi.AutoGenerateColumns = false;
dgvProizvodi.DataSource = dgvResult;
}
}
else
{
NarudzbaSearchRequest search = new NarudzbaSearchRequest();
search.ClanId = _id;
var list = await _narudzbe.Get <IEnumerable <OnlineGym_Model.Narudzbe> >(search);
foreach (var narudzba in list)
{
NarudzbeList.Add(narudzba);
}
if (NarudzbeList.Count > 0)
{
for (int i = 0; i < NarudzbeList.Count; i++)
{
NarudzbaStavkaSearchRequest request = new NarudzbaStavkaSearchRequest();
request.NarudzbaId = NarudzbeList[i].NarudzbaId;
request.KategorijaId = tipId;
var stavkeList = await _narudzbeStavke.Get <IEnumerable <NarudzbeStavke> >(request);
foreach (var stavka in stavkeList)
{
NarudzbeStavkeList.Add(stavka);
}
}
var dgvResult = new List <OnlineGym_Model.NarudzbeStavkeRezultat>();
foreach (var cl in NarudzbeStavkeList)
{
NarudzbeStavkeRezultat temp = new NarudzbeStavkeRezultat(cl);
dgvResult.Add(temp);
temp = null;
}
dgvProizvodi.AutoGenerateColumns = false;
dgvProizvodi.DataSource = dgvResult;
}
}
}
public async Task PopuniVozila()
{
VozilaSearchRequest search = new VozilaSearchRequest
{
pocetna = true
};
var list = await _vozila.Get <IEnumerable <VozilaM> >(search);
VozilaList.Clear();
foreach (var item in list)
{
VozilaList.Add(item);
}
if (Global.prijavljeniKorisnik != null)
{
NarudzbaSearchRequest req = new NarudzbaSearchRequest()
{
KlijentId = Global.prijavljeniKorisnik.KorisnikId
};
var narudzbe = await _narudzbe.Get <List <Model.Narudzba> >(req);
if (narudzbe.Count > 0)
{
DetaljiNarudzbaSearchRequest requ = new DetaljiNarudzbaSearchRequest()
{
NarudzbaId = narudzbe[0].NarudzbaId
};
var detalji = await _detalji.Get <List <DetaljiNarudzbe> >(requ);
if (detalji.Count > 0)
{
var dio = await _dijeloviService.GetById <Dio>(detalji[0].DioId);
DioSearchRequest request = new DioSearchRequest()
{
ModelId = dio.ModelId
};
var lista = await _dijeloviService.Get <List <Dio> >(request);
DijeloviList.Clear();
if (lista.Count > 3)
{
for (int i = 0; i < 3; i++)
{
Kategorija y = await _kategorijeService.GetById <Kategorija>(lista[i].KategorijaId);
DioKategorija novi = new DioKategorija
{
DioId = lista[i].DioId,
Naziv = lista[i].Naziv,
Cijena = lista[i].Cijena,
Sifra = lista[i].Sifra,
KategorijaId = lista[i].KategorijaId,
ModelId = lista[i].ModelId,
Model = lista[i].Model,
Slika = y.Slika
};
DijeloviList.Add(novi);
}
}
else
{
foreach (var x in lista)
{
Kategorija y = await _kategorijeService.GetById <Kategorija>(x.KategorijaId);
DioKategorija novi = new DioKategorija
{
DioId = x.DioId,
Naziv = x.Naziv,
Cijena = x.Cijena,
Sifra = x.Sifra,
KategorijaId = x.KategorijaId,
ModelId = x.ModelId,
Model = x.Model,
Slika = y.Slika
};
DijeloviList.Add(novi);
}
}
}
}
else
{
var lista = await _dijeloviService.Get <List <Dio> >(null);
DijeloviList.Clear();
for (int i = 0; i < 3; i++)
{
Kategorija y = await _kategorijeService.GetById <Kategorija>(lista[i].KategorijaId);
DioKategorija novi = new DioKategorija
{
DioId = lista[i].DioId,
Naziv = lista[i].Naziv,
Cijena = lista[i].Cijena,
Sifra = lista[i].Sifra,
KategorijaId = lista[i].KategorijaId,
ModelId = lista[i].ModelId,
Model = lista[i].Model,
Slika = y.Slika
};
DijeloviList.Add(novi);
}
}
}
else
{
var lista = await _dijeloviService.Get <List <Dio> >(null);
DijeloviList.Clear();
for (int i = 0; i < 3; i++)
{
Kategorija y = await _kategorijeService.GetById <Kategorija>(lista[i].KategorijaId);
DioKategorija novi = new DioKategorija
{
DioId = lista[i].DioId,
Naziv = lista[i].Naziv,
Cijena = lista[i].Cijena,
Sifra = lista[i].Sifra,
KategorijaId = lista[i].KategorijaId,
ModelId = lista[i].ModelId,
Model = lista[i].Model,
Slika = y.Slika
};
DijeloviList.Add(novi);
}
}
}
private async void FrmDijeloviIzvjestaj_Load(object sender, EventArgs e)
{
double ukupno = 0;
double ukupnoTrenutniMjesec = 0;
NarudzbaSearchRequest requ = new NarudzbaSearchRequest()
{
Zavrsena = true
};
var narudzbe = await _narudzbe.Get <List <Narudzba> >(requ);
foreach (var x in narudzbe)
{
DetaljiNarudzbaSearchRequest req = new DetaljiNarudzbaSearchRequest()
{
NarudzbaId = x.NarudzbaId
};
var detalji = await _detalji.Get <List <Model.DetaljiNarudzbe> >(req);
foreach (var y in detalji)
{
ukupno += y.Cijena * y.Kolicina;
if (x.DatumNarudžbe.Month == DateTime.Now.Month)
{
ukupnoTrenutniMjesec += y.Cijena * y.Kolicina;
}
}
}
int dioBroj = 0;
var dijelovi = await _dijelovi.Get <List <Dio> >(null);
List <DioIzvjestaj> lista = new List <DioIzvjestaj>();
foreach (var x in dijelovi)
{
DetaljiNarudzbaSearchRequest req = new DetaljiNarudzbaSearchRequest()
{
DioId = x.DioId
};
var stavke = await _detalji.Get <List <Model.DetaljiNarudzbe> >(req);
if (stavke.Count > 0)
{
DioIzvjestaj diodio = new DioIzvjestaj()
{
Naziv = x.Naziv,
Cijena = x.Cijena,
Sifra = x.Sifra,
Model = x.Model,
};
var list = stavke.Where(g => g.DioId == x.DioId).Select(w => w.Kolicina);
foreach (var t in list)
{
dioBroj += t;
}
diodio.BrojProdanih = dioBroj;
lista.Add(diodio);
dioBroj = 0;
}
}
List <DioIzvjestaj> sortirana = lista.OrderByDescending(x => x.BrojProdanih).ToList();
dgvDijelovi.BackgroundColor = Color.White;
dgvDijelovi.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvDijelovi.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvDijelovi.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
for (int i = 0; i <= dgvDijelovi.Columns.Count - 1; i++)
{
int colw = dgvDijelovi.Columns[i].Width;
dgvDijelovi.Columns[i].AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
dgvDijelovi.Columns[i].Width = colw;
}
dgvDijelovi.DataSource = sortirana;
dgvNarudzbe.BackgroundColor = Color.White;
dgvNarudzbe.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvNarudzbe.Columns[1].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;
}
dgvNarudzbe.DataSource = narudzbe;
txtUkupno.Text = $"Ukupna zarada : \t{ukupno} KM";
txtUkupnoTrenutni.Text = $"Ukupna zarada tekuci mjesec: {ukupnoTrenutniMjesec} KM";
}
public List <OnlineGym_Model.Narudzbe> Get([FromQuery] NarudzbaSearchRequest request)
{
return(_service.Get(request));
}
