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));
}
