public ActionResult SubDepts(int KEY)

        {
            Departments dpt = new Departments();

            dpt.KEY_GLOBAL_DEPT = KEY;

            AllMethods am = new AllMethods();

            am.ListMethodscoda   = dpt.GetcodaDepartments(Database);
            am.ListMethodsfast   = dpt.GetfastDepartments(Database);
            am.ListMethodsgems   = dpt.GetgemsDepartments(Database);
            am.ListMethodsoasis  = dpt.GetoasisDepartments(Database);
            am.ListMethodsbanner = dpt.GetbannerDepartments(Database);
            am.ListMethodsidx    = dpt.GetidxDepartments(Database);
            am.ListMethodsepic   = dpt.GetepicDepartments(Database);
            am.ListMethodssamas  = dpt.GetsamasDepartments(Database);

            return(PartialView("SubDepts", am));
        }