public async Task <IActionResult> AylikPuantaj()
{
ViewBag.Hesaplamalar = await hesaplamaRepository.GetAllAsync();
ViewBag.Unvanlar = await unvanRepository.GetAllAsync();
ViewBag.Secenekler = await secenekListesiRepository.GetAllAsync();
return(View());
}
public async Task <IActionResult> TopluPersonelEkle(IFormFile excel)
{
var unvanlar = await unvanRepository.GetAllAsync();
var personeller = personellerExcelOku(excel.OpenReadStream(), unvanlar);
foreach (var personel in personeller)
{
var p = personelRepository.FindOneByTcNoAsync(personel.TcNo);
if (p == null)
{
await personelRepository.AddAsync(personel);
}
}
await unitOfWork.CompleteAsync();
return(Redirect("/Personel/Liste"));
}
public async Task <List <Tuple <string, int> > > GorevOzetleriGetir(int year, int month, string filter = "current")
{
var collectionQuery = await GetsByQuery(null, year, month, filter);
var list = new List <Tuple <string, int> >();
var unvanlar = await unvanRepository.GetAllAsync();
foreach (var unvan in unvanlar)
{
var toplamSayi = collectionQuery.Items.Where(p => p.GorevId == unvan.Id).Count();
list.Add(new Tuple <string, int>(unvan.UnvanAdi, toplamSayi));
}
return(list);
}
