Old Version SEO page (controller)

 // ############################################# SEO page showing each template details   ####################################### //
        public ActionResult SEOpage(int templateId)
        {
            IEnumerable<DAL.fouradman.Template> model_template;
            IEnumerable<DAL.fouradman.Template_Tag> taglist;
            using (var dc = new DAL.fouradman.fouradmanDataContext())
            {
                var counter = dc.Templates.Where(c => c.Id.Equals(templateId));
                model_template = counter.ToList();

                var slot = new ADLObjectLib.ClsSlot { ConnectionString = ConfigurationManager.ConnectionStrings["AdLizard"].ConnectionString, };
                slot.OpenConnection();
                var doc = new ADLObjectLib.ClsDoc { Connection = slot.Connection };

                foreach (var t in model_template)
                {
                    doc.Retrieve(t.Id);
                    t.Thumbnail = doc.GetThumbnail();
                    t.Width = doc.Width;
                    t.Height = doc.Height;
                    t.Name = doc.Name;
                    t.User.Name = dc.Users.Where(c => c.User_Id.Equals(t.User_Id)).Select(c => c.Name).FirstOrDefault().ToString();
                    
                }

                ViewBag.model_template = model_template;

                var tags = dc.Template_Tags.Where(c => c.Template_Id.Equals(templateId));
          
                taglist = tags.ToList();
                foreach (var t in taglist)
                {
                    t.Tag.Translation = (String)dc.Tags.Where(c => c.Id.Equals(t.Tag_Id)).Select(c=>c.Translation).FirstOrDefault().ToString(); 

                  
                }
                ViewBag.taglist = taglist;

            }
            return View();
        }