public async Task <DataGridDto <MusteriListDto> > List(int firmaid) { return(await GenerateDataGridDto <MusteriListDto> .Store((from a in _musteriRepository.All().Where(w => w.FirmaId == firmaid) join u in _kullaniciRepository.All() on a.KullaniciId equals u.Id join ilce in _lookupListRepository.All() on u.IlceId equals ilce.Id into ilcen from ilce in ilcen.DefaultIfEmpty() join il in _lookupListRepository.All() on ilce.ParentId equals il.Id into iln from il in iln.DefaultIfEmpty() select new MusteriListDto { Id = a.Id, Cinsiyet = a.CinsiyetErkek?"Erkek":"Kadın", Eposta = u.Eposta, Il = il.Isim, Ilce = ilce.Isim, Meslek = u.Unvan, Sirket = a.SirketAd, Telefon = u.Telefon, AdSoyad = u.AdSoyad, EvTelefon = a.EvTelefon, SirketAdres = a.SirketAdres, SirketArabasi = a.SirketAraci, SirketTelefon = a.SirketTelefon, TC = a.TC } ))); }
public async Task <SayilarDto> Sayilar(int firmaid) { return(new SayilarDto { AracSayisi = await _aracRepository.All(firmaid).CountAsync(), BakimTalebi = await _bakimTalebiRepository.All(firmaid).CountAsync(), KullaniciSayisi = await _kullaniciRepository.All(firmaid).CountAsync(), MusteriSayisi = await _musteriRepository.All(firmaid).CountAsync(), }); }