public ActionResult Ganckhadebebi(string q = "") { var currentUser = CurrentUser; if (currentUser == null || currentUser.ROLE_NAME == "მესამე პირი") { return RedirectToAction("Dzebna"); } using (var conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["PirvelckaroebiConnectionString1"].ConnectionString)) { conn.Open(); var rez = conn.Ganckhadebebi(q) .GroupBy(x => x.Unnom) .Select(g => { dynamic o = new ExpandoObject(); o.Pirovneba = conn.BoloKargiChanaceri((int)g.Key); o.PirovnebisRekvizitebisIstoria = conn.PirovnebisRekvizitebisIstoria((int)g.Key); o.ReestrisStatusebisIstoria = conn.ReestrisStatusebisIstoria((string) o.Pirovneba.IdentPID); o.Ganckhadebebi = g.ToList(); return o; }) .ToList(); return View("ShemosuliGancxadebebi", rez); } }