private async Task LoadGradovi(int?id)
{
GradoviSearchRequest request = new GradoviSearchRequest()
{
Naziv = null
};
if (id.HasValue)
{
request.DrzavaId = id;
}
else
{
request.DrzavaId = 0;
}
var result = await _gradovi.Get <List <Models.Grad> >(request);
result.Insert(0, new Models.Grad()
{
Naziv = "---"
});
cmbGrad.DisplayMember = "Naziv";
cmbGrad.ValueMember = "Id";
cmbGrad.DataSource = result;
cmbGrad.SelectedValue = 0;
}
async Task LoadGradovi(int?id)
{
//GradoviSearchRequest request = new GradoviSearchRequest()
//{
// Naziv = null,
// DrzavaId = null
//};
//if (id.HasValue)
//{
// request.DrzavaId = id;
//}
//else
//{
// request.DrzavaId = 0;
//}
GradoviSearchRequest request = new GradoviSearchRequest()
{
Naziv = null,
DrzavaId = id
};
var result = await _gradovi.Get <List <Models.Grad> >(request);
//result.Insert(0, new Models.Grad());
cmbGrad.DisplayMember = "Naziv";
cmbGrad.ValueMember = "Id";
cmbGrad.DataSource = result;
cmbGrad.SelectedIndex = 0;
}
public async Task Init()
{
if (regijeList.Count == 0)
{
var listRegije = await regijeService.Get <IEnumerable <Regije> >(null);
foreach (var x in listRegije)
{
regijeList.Add(x);
}
}
if (SelectedRegija != null)
{
GradoviSearchRequest searchRequest = new GradoviSearchRequest();
searchRequest.RegijaId = SelectedRegija.RegijaId;
var listGradovi = await _gradoviService.Get <IEnumerable <Gradovi> >(searchRequest);
gradoviList.Clear();
foreach (var x in listGradovi)
{
gradoviList.Add(x);
}
}
}
public async Task InitialLoad()
{
if (ListaDrzava.Count == 0)
{
DrzavaSearchRequest request = new DrzavaSearchRequest()
{
Naziv = null,
KontinentId = 0
};
var lista = await _drzave.Get <IEnumerable <Drzava> >(request);
ListaDrzava.Clear();
foreach (var x in lista)
{
ListaDrzava.Add(x);
}
}
if (GradoviList.Count == 0)
{
GradoviSearchRequest gradsearch = new GradoviSearchRequest()
{
Naziv = null,
DrzavaId = 0
};
var lista = await _gradovi.Get <IEnumerable <Grad> >(gradsearch);
GradoviList.Clear();
foreach (var x in lista)
{
GradoviList.Add(x);
}
}
}
private async void txtPretragaNaziv_TextChanged(object sender, EventArgs e)
{
var search = new GradoviSearchRequest()
{
NazivGrada = txtPretragaNaziv.Text,
};
var result = await _apiService.Get <List <Model.Gradovi> >(search);
dataGridView1.DataSource = result;
}
private async void BtnPretrazi_Click(object sender, EventArgs e)
{
var search = new GradoviSearchRequest()
{
Naziv = txtPretraga.Text
};
var result = await _apiService.Get <dynamic>(search);
dgvGradovi.AutoGenerateColumns = false;
dgvGradovi.DataSource = result;
}
public List <Model.Gradovi> Get(GradoviSearchRequest search)
{
var query = _context.Gradovi.Include(x => x.Drzava).AsQueryable();
if (search.DrzavaId != 0 && search.DrzavaId.HasValue)
{
query = query.Where(x => x.DrzavaId == search.DrzavaId);
}
var list = query.OrderBy(x => x.Drzava.Naziv).ToList();
return(_mapper.Map <List <Model.Gradovi> >(list));
}
private async Task UcitajGradove()
{
var odabranaDrzavaId = int.Parse(DrzavaComboBox.SelectedValue.ToString());
var request = new GradoviSearchRequest
{
DrzavaId = odabranaDrzavaId == 0 ? (int?)null : odabranaDrzavaId,
Naziv = NazivTextBox.Text,
};
var gradovi = await _gradoviService.Get <List <Model.Gradovi> >(request);
GradoviDGV.DataSource = gradovi;
}
private async void btnPretraga_Click(object sender, EventArgs e)
{
if (this.ValidateChildren())
{
var search = new GradoviSearchRequest()
{
Naziv = txtNaziv.Text,
DrzavaId = int.Parse(cmbDrzava.SelectedValue.ToString())
};
var result = await _gradovi.Get <List <Models.Grad> >(search);
dgvGradovi.AutoGenerateColumns = false;
dgvGradovi.DataSource = result;
}
}
private async Task LoadGradovi(int?id)
{
GradoviSearchRequest request = new GradoviSearchRequest()
{
Naziv = null,
DrzavaId = id
};
var result = await _gradovi.Get <List <Models.Grad> >(request);
//result.Insert(0, new Models.Grad());
cmbGrad.DisplayMember = "Naziv";
cmbGrad.ValueMember = "Id";
cmbGrad.DataSource = result;
cmbGrad.SelectedIndex = 0;
}
private async Task RefreshGradovi()
{
Model.Drzave Drzava = cmbDrzave.SelectedItem as Model.Drzave;
if (Drzava == null)
{
return;
}
var request = new GradoviSearchRequest
{
DrzavaId = Drzava.DrzavaId
};
var listGradovi = await _serviceGradovi.Get <List <Model.Gradovi> >(request);
cmbGradovi.DataSource = listGradovi;
}
public List <Model.Gradovi> Get(GradoviSearchRequest request)
{
var query = _context.Gradovi.AsQueryable();
if (!string.IsNullOrWhiteSpace(request?.Naziv))
{
query = query.Where(x => x.Naziv.ToLower().Contains(request.Naziv.ToLower()));
}
if (request?.DrzavaId != 0)
{
query = query.Where(x => x.DrzavaId == request.DrzavaId);
}
query = query.Include(x => x.Drzava);
var list = query.ToList();
return(_mapper.Map <List <Model.Gradovi> >(list));
}
public async Task LoadGradoviDestinacije()
{
if (SelectedDrzava != null)
{
GradoviSearchRequest request = new GradoviSearchRequest()
{
Naziv = null,
DrzavaId = SelectedDrzava.Id
};
var gradovilist = await _gradoviservice.Get <IEnumerable <Grad> >(request);
GradoviList.Clear();
foreach (var grad in gradovilist)
{
GradoviList.Add(grad);
}
}
if (SelectedGrad != null)
{
DestinacijaSearchRequest search = new DestinacijaSearchRequest()
{
GradId = SelectedGrad.Id,
Naziv = SelectedGrad.Naziv
};
var list = await _service.Get <IEnumerable <Destinacija> >(search);
DestinacijeList.Clear();
foreach (var destinacija in list)
{
DestinacijeList.Add(destinacija);
}
}
}
public override List <Grad> Get(GradoviSearchRequest search)
{
var q = _context.Set <Database.Gradovi>().AsQueryable();
if (!string.IsNullOrEmpty(search?.Naziv) && search?.DrzavaID.HasValue == true)
{
q = q.Where(s => s.Naziv.Equals(search.Naziv) && s.DrzavaID == search.DrzavaID);
}
else
{
if (!string.IsNullOrEmpty(search?.Naziv))
{
q = q.Where(s => s.Naziv.StartsWith(search.Naziv));
}
if (search?.DrzavaID.HasValue == true)
{
q = q.Where(s => s.DrzavaID == search.DrzavaID);
}
}
var list = q.ToList();
return(_mapper.Map <List <Grad> >(list));
}
public async Task LoadGradoviDrzave()
{
if (SelectedDrzava != null)
{
GradoviSearchRequest gradsearch = new GradoviSearchRequest()
{
Naziv = null,
DrzavaId = SelectedDrzava.Id
};
var lista = await _gradovi.Get <IEnumerable <Grad> >(gradsearch);
GradoviList.Clear();
foreach (var x in lista)
{
GradoviList.Add(x);
}
}
//if(SelectedGrad!=null)
//{
// DestinacijaSearchRequest destinacijasearch = new DestinacijaSearchRequest()
// {
// Naziv=SelectedGrad.Naziv,
// GradId=SelectedGrad.Id
// };
// var lista = await _destinacije.Get<IEnumerable<Destinacija>>(destinacijasearch);
// ListaDestinacija.Clear();
// foreach(var x in lista)
// {
// ListaDestinacija.Add(x);
// }
//}
}
public async Task Init()
{
if (DrzaveList.Count == 0)
{
DrzavaSearchRequest request = new DrzavaSearchRequest()
{
Naziv = null,
KontinentId = 0
};
var drzavelist = await _drzaveservice.Get <IEnumerable <Drzava> >(request);
DrzaveList.Clear();
foreach (var drzava in drzavelist)
{
DrzaveList.Add(drzava);
}
}
if (SelectedDrzava != null)
{
//if (GradoviList.Count == 0)
//{
GradoviSearchRequest request = new GradoviSearchRequest()
{
Naziv = null,
DrzavaId = SelectedDrzava.Id
};
//var gradovilist = await _gradoviservice.Get<IEnumerable<Grad>>(request);
var gradovilist = new List <Grad>();
foreach (var grad in gradovilist)
{
GradoviList.Add(grad);
}
}
if (SelectedGrad != null)
{
DestinacijaSearchRequest search = new DestinacijaSearchRequest()
{
GradId = SelectedGrad.Id,
Naziv = SelectedGrad.Naziv
};
var list = await _service.Get <IEnumerable <Destinacija> >(search);
DestinacijeList.Clear();
foreach (var destinacija in list)
{
DestinacijeList.Add(destinacija);
}
}
}
public ActionResult <List <Grad> > Get([FromQuery] GradoviSearchRequest req)
{
return(_service.Get(req));
}
public List <Model.Gradovi> Get([FromQuery] GradoviSearchRequest request)
{
return(_service.Get(request));
}
