public List <ServisModel> GetServisiList(SearchRequestServis request)
{
var query = _context.Servisi.Include("Serviser").Include("Klijent").Include("Status")
.Include("Uredjaj").Include("TipPlacanja").Include("TipDostave").AsQueryable();
if (!string.IsNullOrWhiteSpace(request?.ImeServisera))
{
query = query.Where(u => u.Serviser.Ime.Contains(request.ImeServisera));
}
if (!string.IsNullOrWhiteSpace(request?.ImeKlijenta))
{
query = query.Where(u => u.Klijent.Ime.Contains(request.ImeKlijenta));
}
if (!string.IsNullOrWhiteSpace(request?.PrezimeKlijenta))
{
query = query.Where(u => u.Klijent.Prezime.Contains(request.PrezimeKlijenta));
}
if (!string.IsNullOrWhiteSpace(request?.EmailKlijenta))
{
query = query.Where(u => u.Klijent.Email.Contains(request.EmailKlijenta));
}
if (request.KoristiDatum)
{
query = query.Where(u => u.DatumServisa.Date.Equals(request.DatumServisa.Date));
}
var list = query.ToList();
return(_mapper.Map <List <Model.ServisModel> >(list));
}
private async void btnPrikazi_Click(object sender, EventArgs e)
{
dgvServisi.AutoGenerateColumns = false;
var search = new SearchRequestServis()
{
ImeServisera = txtImeServisera.Text,
ImeKlijenta = txtImeKlijenta.Text,
PrezimeKlijenta = txtPrezimeKlijenta.Text,
EmailKlijenta = txtEmailKlijenta.Text,
KoristiDatum = checkBox.Checked,
DatumServisa = dateTimePicker1.Value
};
var result = await _apiService.GetParam <List <Model.ServisModel> >("GetServisiList", search);
dgvServisi.DataSource = result;
}
private async void btnPrikazi_Click(object sender, EventArgs e)
{
errorProvider1.SetError(listServiseri, null);
if (listServiseri.SelectedValue == null)
{
errorProvider1.SetError(listServiseri, "Izaberi servisera");
}
else
{
KorisniciModel selectedItem = (KorisniciModel)listServiseri.SelectedItem;
var search = new SearchRequestServis()
{
ImeServisera = selectedItem.Ime,
KoristiDatum = checkBox.Checked,
DatumServisa = dateTimePicker1.Value
};
var servisi = await _servisiService.GetParam <List <Model.ServisModel> >("GetServisiList", search);
ReportDataSource rds = new ReportDataSource("DataSet1", servisi);
this.reportViewer1.LocalReport.DataSources[0] = rds;
this.reportViewer1.RefreshReport();
}
}
