public async Task <IActionResult> Cahar(int?sayfa) { if (!User.IsInRole(SD.Musteri)) { return(RedirectToAction("Index", "Order", new { area = "Admin" })); } var query = from b in _db.Tblcahar select b; int PageSize = 350; sayfa = sayfa ?? 1; query = query.Where(a => a.CariKod == User.Identity.Name); query = query.OrderBy(a => a.Tarih); CariHareketlerViewModel cariharvm = new CariHareketlerViewModel() { Tblcahar = await PaginatedList <Tblcahar> .CreateAsync(query.AsNoTracking(), sayfa ?? 1, PageSize), Tblcasabit = await _db.Tblcasabit.Where(a => a.CariKod == User.Identity.Name).FirstOrDefaultAsync() }; return(View(cariharvm)); }
public async Task <IActionResult> Details(string carikod, string cariisim, int?sayfa) { var query = from b in _db.Tblcahar select b; int pageSize = 350; sayfa = sayfa ?? 1; query = query.Where(a => a.CariKod == carikod); query = query.OrderBy(a => a.Tarih); CariHareketlerViewModel carihareketlervm = new CariHareketlerViewModel() { Tblcahar = await PaginatedList <Tblcahar> .CreateAsync(query.AsNoTracking(), sayfa ?? 1, pageSize), Tblcasabit = await _db.Tblcasabit.Where(a => a.CariKod == carikod).FirstOrDefaultAsync() }; return(View(carihareketlervm)); }