public JsonResult GetAll2() { pi5aEntities db = new pi5aEntities(); List <KupacView> podaci = db.KupacView.ToList(); return(Json(podaci, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAll1() { pi5aEntities db = new pi5aEntities(); List <KupacVM> podaci = db.Kupac .Select(x => new KupacVM { Adresa = x.Adresa + " " + x.Grad, Ime = x.Naziv, ZadnjaFaktura = x.Faktura.OrderByDescending(o => o.Datum).FirstOrDefault().Datum, FaktureSumaUkupno = x.Faktura.Sum(s => s.Iznos), FaktureSumaTekuceGodine = 0 }).ToList(); return(Json(podaci, JsonRequestBehavior.AllowGet)); }