private async void FrmNabavke_Load(object sender, EventArgs e)
{
NabavkaSearchRequest search = new NabavkaSearchRequest
{
Zavrsena = false,
DatumNabavke = DateTime.Now
};
List <StatusNabavke> lista = new List <StatusNabavke>();
lista.Add(new StatusNabavke
{
Status = "Na cekanju",
Value = 0
});
lista.Add(new StatusNabavke
{
Status = "Zavrsene",
Value = 1
});
cmbStatus.DataSource = lista;
cmbStatus.DisplayMember = "Status";
cmbStatus.ValueMember = "Value";
await LoadNabavke(search);
}
private async void TxtDatum_ValueChanged(object sender, EventArgs e)
{
NabavkaSearchRequest search = new NabavkaSearchRequest
{
DatumNabavke = txtDatum.Value
};
await LoadNabavke(search);
}
public async Task LoadNabavke(NabavkaSearchRequest search)
{
dgvNabavke.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvNabavke.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvNabavke.Columns[2].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
dgvNabavke.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
var result = await _nabavke.Get <List <Model.Nabavke> >(search);
dgvNabavke.AutoGenerateColumns = false;
dgvNabavke.DataSource = result;
}
private async void CmbStatus_SelectedIndexChanged_1(object sender, EventArgs e)
{
int?_id = null;
var idObj = cmbStatus.SelectedValue;
if (int.TryParse(idObj.ToString(), out int id))
{
_id = id;
}
NabavkaSearchRequest search = new NabavkaSearchRequest
{
Zavrsena = Convert.ToBoolean(_id)
};
await LoadNabavke(search);
}
private async void BtnZavrsi_Click(object sender, EventArgs e)
{
NabavkeUpsertRequest req = new NabavkeUpsertRequest
{
NabavkaId = _id,
Zavrsena = true
};
await _nabavka.Update <NabavkeUpsertRequest>(_id, req);
MessageBox.Show("Narudzba uspjesno zavrsena", " ", MessageBoxButtons.OK, MessageBoxIcon.Information);
NabavkaSearchRequest reload = new NabavkaSearchRequest {
Zavrsena = false
};
await _parent.LoadNabavke(reload);
Close();
}
private async void BtnNaruci_Click(object sender, EventArgs e)
{
if (await Validacija())
{
MessageBox.Show("Unesite trazena polja");
}
else
{
NabavkaStavkeUpsertRequest model = new NabavkaStavkeUpsertRequest();
model.NabavkaId = _id;
if (int.TryParse(txtKolicina.Value.ToString(), out int kol))
{
model.Kolicina = kol;
}
var proizvod = cmbProizvod.SelectedValue;
if (int.TryParse(proizvod.ToString(), out int pid))
{
model.RobaId = pid;
}
var nesto = await _detalji.Insert <Model.NabavkaStavke>(model);
MessageBox.Show("Dodano na listu!");
Close();
NabavkaSearchRequest search = new NabavkaSearchRequest
{
Zavrsena = false
};
await _parent.LoadNabavke(search);
frmNabavkaNova form = new frmNabavkaNova(_id, _parent);
form.Show();
}
}
public override List <Model.Nabavke> Get(NabavkaSearchRequest search)
{
List <Model.Nabavke> lista = new List <Model.Nabavke>();
var nabavka = _db.Nabavka.AsQueryable();
if (search.Zavrsena)
{
nabavka = nabavka.Where(w => w.Zavrsena);
}
else
{
nabavka = nabavka.Where(w => !w.Zavrsena);
}
nabavka = nabavka.Where(w => w.DatumNabavke.Day.Equals(search.DatumNabavke.Day) && w.DatumNabavke.Month.Equals(search.DatumNabavke.Month));
foreach (var item in nabavka)
{
var cijena = 0.0;
var ns = _db.NabavkaStavke.Where(w => w.NabavkaId == item.NabavkaId).ToList();
foreach (var stavka in ns)
{
cijena += stavka.Cijena;
}
lista.Add(new Model.Nabavke
{
NabavkaId = item.NabavkaId,
UposlenikId = item.UposlenikId,
ImePrezime = _db.Korisnik.Where(w => w.KorisnikId == item.UposlenikId).Select(w => w.Ime + " " + w.Prezime).FirstOrDefault(),
Zavrsena = item.Zavrsena,
DatumNabavke = item.DatumNabavke,
Cijena = cijena
});
}
return(lista);
}
