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(),
});
}
public async Task <DataGridDto <BakimTalebiListDto> > List(int firmaid)
{
return(await GenerateDataGridDto <BakimTalebiListDto> .Store((from a in _bakimTalebiRepository.All().Where(w => w.FirmaId == firmaid)
join arac in _aracRepository.All() on a.AracId equals arac.Id
join marka in _lookupListRepository.All() on arac.MarkaId equals marka.Id into markad
from marka in markad.DefaultIfEmpty()
join kullanici in _kullaniciRepository.All() on a.KullaniciId equals kullanici.Id
join d in _lookupListRepository.All() on a.DurumId equals d.Id
select new BakimTalebiListDto
{
Id = a.Id,
Marka = marka.Isim,
Model = arac.Model,
Plaka = arac.Plaka,
Tarih = a.BakimTarihi,
Telefon = kullanici.Telefon,
AdSoyad = kullanici.AdSoyad,
EnSonBakimYetkiliServis = arac.EnSonBakimYetkiliServis,
Durum = d.Isim
}
)));
}