public ActionResult Index(int page = 1) { //FaturaListViewModel faturaList = new FaturaListViewModel(); //faturaList.FaturaList = db.Fatura.OrderByDescending(x => x.GonderimTarihi.Value).ToList(); ViewBag.IncelenmisDosyaSayisi = db.Fatura.Where(x => x.FaturaInceleme.Id == 2 && x.isVisible == false).Count(); ViewBag.IncelenenDosyaSayisi = db.Fatura.Where(x => x.FaturaInceleme.Id == 1 && x.isVisible == false).Count(); ViewBag.IncelenmemisDosyaSayisi = db.Fatura.Where(x => x.FaturaInceleme.Id == 0 && x.isVisible == false).Count(); ViewBag.OnaylanmisDosyaSayisi = db.Fatura.Where(x => x.OnaylandiMi == true && x.isVisible == false).Count(); ViewBag.OnaylanmamisDosyaSayisi = db.Fatura.Where(x => x.OnaylandiMi != true && x.isVisible == false).Count(); FaturaListViewModel faturaList = new FaturaListViewModel { FaturaList = db.Fatura.Where(x => x.isVisible == false).OrderBy(n => n.İncelendiMi.Value).ThenBy(x => x.GonderimTarihi.Value).ToList().Skip((page - 1) * PageSize).Take(PageSize), PagingInfo = new PagingInfo { CurrentPage = page, ItemsPerPage = PageSize, TotalItems = db.Fatura.Count() } }; faturaList.EksikBilgiList = db.EksikBilgi.ToList(); return(View(faturaList)); }
public ActionResult PersonelFaturaList(int page = 1) { var usId = (Guid)Membership.GetUser(User.Identity.Name).ProviderUserKey; FaturaListViewModel faturaList = new FaturaListViewModel { FaturaList = db.AtananPersonel.Where(x => x.Fatura.isVisible == true && x.UserId == usId).OrderBy(n => n.Fatura.İncelendiMi.Value).ThenBy(x => x.Fatura.GonderimTarihi.Value).ToList().Select(x => x.Fatura).Skip((page - 1) * PageSize).Take(PageSize), PagingInfo = new PagingInfo { CurrentPage = page, ItemsPerPage = PageSize, TotalItems = db.Fatura.Count() } }; faturaList.EksikBilgiList = db.EksikBilgi.ToList(); return(View(faturaList)); }
// [Authorize(Roles = "SatinAlma,MaliIsler")] // GET: Fatura public ActionResult Index(int page = 1) { Boolean tumFaturalariGoster = false; if (User.Identity.IsAuthenticated) { var user = User.Identity.Name; string[] roles = Roles.GetRolesForUser(user); foreach (var item in roles) { if (item == "Admin" || item == "Santral" || item == "SatinAlma" || item == "MaliIsler") { tumFaturalariGoster = true; break; } } //CREATED BY FURKAN MERT SERTÇE 09.08.2019 //FaturaListViewModel faturaList = new FaturaListViewModel(); //faturaList.FaturaList = db.Fatura.OrderByDescending(x => x.GonderimTarihi.Value).ToList(); if (tumFaturalariGoster == true) { ViewBag.IncelenmisDosyaSayisi = db.Fatura.Where(x => x.FaturaInceleme.Id == 2 && x.isVisible == true).Count(); ViewBag.IncelenenDosyaSayisi = db.Fatura.Where(x => x.FaturaInceleme.Id == 1 && x.isVisible == true).Count(); ViewBag.IncelenmemisDosyaSayisi = db.Fatura.Where(x => x.FaturaInceleme.Id == 0 && x.isVisible == true).Count(); ViewBag.OnaylanmisDosyaSayisi = db.Fatura.Where(x => x.OnaylandiMi == true && x.isVisible == true).Count(); ViewBag.OnaylanmamisDosyaSayisi = db.Fatura.Where(x => x.OnaylandiMi == false || x.OnaylandiMi == null && x.isVisible == true).Count(); FaturaListViewModel faturaList = new FaturaListViewModel { FaturaList = db.Fatura.Where(x => x.isVisible == true).OrderBy(n => n.İncelendiMi.Value).ThenBy(x => x.GonderimTarihi.Value).ToList().Skip((page - 1) * PageSize).Take(PageSize), PagingInfo = new PagingInfo { CurrentPage = page, ItemsPerPage = PageSize, TotalItems = db.Fatura.Count() } }; faturaList.EksikBilgiList = db.EksikBilgi.ToList(); return(View(faturaList)); } else { return(RedirectToAction("PersonelFaturaList")); } } else { return(RedirectToAction("Index", "Login")); } }