public List <GetClanUplataResponseModel> Get(SearchUplataResponseModel search = null) { var dbUplate = _Context.Uplate.AsQueryable(); var Uplate = _Mapper.Map <List <GetClanUplataResponseModel> >(dbUplate); ////AutoMapper used for lazy loading of the class Clan so I could populate properties (Ime,Prezime) for dto GetClanUplataResponseModel // var configuration = new MapperConfiguration(cfg => // cfg.CreateMap<Clan, GetClanUplataResponseModel>() // .ForMember(dto => dto.Ime, conf => conf.MapFrom(ol => ol.Ime)) // .ForMember(dto => dto.Prezime, conf => conf.MapFrom(ol => ol.Prezime))); foreach (var item in Uplate) { var ClanId = item.ClanId; var Clanovi = _Context.Clanovi.ToList(); var Clan = _Context.Clanovi.FirstOrDefault(x => x.Id == ClanId); item.Ime = Clan.Ime; item.Prezime = Clan.Prezime; } if ((search == null) || ((search?.ClanId == 0) && (search?.MjesecUplate == 0) && (search?.GodinaUplate == 0))) { return(new List <GetClanUplataResponseModel>()); } else { if (search?.ClanId != 0) { Uplate = Uplate.Where(c => c.ClanId == search.ClanId) .OrderBy(du => du._DatumIstekaKartice) .ToList(); } if ((search?.MjesecUplate > 0) && (search?.MjesecUplate <= 12)) { Uplate = Uplate.Where(m => m._DatumIstekaKartice.Month == search.MjesecUplate) .OrderBy(du => du._DatumIstekaKartice) .ToList(); } if (search?.GodinaUplate != 0) { if (search?.GodinaUplate >= 2020) { Uplate = Uplate.Where(y => y._DatumIstekaKartice.Year == search.GodinaUplate) .OrderBy(du => du._DatumIstekaKartice) .ToList(); } if ((search?.GodinaUplate <= DateTime.Now.Year)) { Uplate = Uplate.Where(y => y._DatumIstekaKartice.Year == search.GodinaUplate) .OrderBy(du => du._DatumIstekaKartice) .ToList(); } return(Uplate); } return(Uplate); } }
public async Task <T> GetUplate <T>(SearchUplataResponseModel search = null) { if (search != null) { var result = await $"{Properties.Settings.Default.ApiUrl}{_ApiRoute}?ClanId={search.ClanId}&MjesecUplate={search.MjesecUplate}&GodinaUplate={search.GodinaUplate}" .WithOAuthBearerToken("eyJhbGciOiJIUzUxMiIsInR5cCI6IkpXVCJ9.eyJuYW1laWQiOiIxIiwidW5pcXVlX25hbWUiOiJ1bWFfbG92ZSIsIm5iZiI6MTYxMDY1OTQ5MSwiZXhwIjoxNjQyMTk1NDg5LCJpYXQiOjE2MTA2NTk0OTF9._jHrgQkCHjJsp3vbSeIdP7LYGYrlg0FM_4TbFPNyMAymF5FkK_zAkxltei9QRB-Hk5p2UXs68JHjgU2b7VjO8g") .GetJsonAsync <T>(); return(result); } else { return(await $"{Properties.Settings.Default.ApiUrl}{_ApiRoute}".GetJsonAsync <T>()); } }
private async void Btn_Filtriraj_Click(object sender, EventArgs e) { var clanovi = await _ClanService.Get <List <GetClanResponseModel> >(); clanovi.Insert(0, new GetClanResponseModel() { Ime = "-Odaberite ", Prezime = "člana-" }); CBox_Clanovi.DataSource = clanovi; CBox_Clanovi.DisplayMember = "ImePrezime"; var search = new SearchUplataResponseModel { ClanId = SelectedClanId, MjesecUplate = MjesecUplate, GodinaUplate = GodinaUplate }; var uplate = await _UplateService.GetUplate <List <GetClanUplataResponseModel> >(search); Dgv_Uplate.DataSource = uplate; TBox_Godina.Text = "0"; }
public List <GetClanUplataResponseModel> Get([FromQuery] SearchUplataResponseModel search = null) { return(UplataService.Get(search)); }