private async void btnTraži_Click(object sender, EventArgs e)
{
PretplateSearchRequest search = null;
if (cmbVrsta.SelectedIndex > 0)
{
search = new PretplateSearchRequest()
{
VrstaPutovanjaId = int.Parse(cmbVrsta.SelectedValue.ToString())
};
}
var list = await _pretplate.Get <List <Model.Pretplate> >(search);
dataGridView1.AutoGenerateColumns = false;
dataGridView1.DataSource = list;
if (list.Count == 0)
{
txtBroj.Text = 0.ToString();
}
else
{
txtBroj.Text = list.Count.ToString();
}
}
private async void btnPrikazi_Click(object sender, EventArgs e)
{
PretplateSearchRequest request = new PretplateSearchRequest()
{
KorisnickoIme = txtKupac.Text
};
var objKategorijeVozila = cmbKategorijeVozila.SelectedValue;
request.KategorijaVozilaId = int.Parse(objKategorijeVozila?.ToString() ?? "0");
var result = await _pretplateService.Get <List <Model.Pretplate> >(request);
dgvPretplate.AutoGenerateColumns = false;
dgvPretplate.DataSource = result;
}
private async void cmbZanrovi_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmbZanrovi.SelectedIndex > 0)
{
PretplateSearchRequest request = new PretplateSearchRequest()
{
ZanrId = int.Parse(cmbZanrovi.SelectedValue.ToString())
};
var result = await _pretplate.Get <List <Model.Pretplate> >(request);
foreach (var item in result)
{
if (item.Otkazana)
{
item.OtkazanaString = "DA";
}
else
{
item.OtkazanaString = "NE";
}
}
dgvPretplate.DataSource = result;
txtBrojPretplacenih.Text = dgvPretplate.Rows.Count.ToString();
}
else
{
var result = await _pretplate.Get <List <Model.Pretplate> >(null);
foreach (var item in result)
{
if (item.Otkazana)
{
item.OtkazanaString = "DA";
}
else
{
item.OtkazanaString = "NE";
}
}
dgvPretplate.DataSource = result;
txtBrojPretplacenih.Text = " ";
}
}
public List <Model.Pretplate> Get(PretplateSearchRequest request)
{
var query = _context.Pretplate.AsQueryable();
if (request?.KategorijaId != 0)
{
query = query.Where(x => x.KategorijaId == request.KategorijaId);
}
if (request?.KorisnikId != 0)
{
query = query.Where(x => x.KorisnikId == request.KorisnikId);
}
query = query.Include(x => x.Kategorija);
query = query.Include(x => x.Korisnik);
var list = query.ToList();
return(_mapper.Map <List <Model.Pretplate> >(list));
}
