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