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);
     }
 }