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