public ActionResult Edit(CertificationModel model)
        {
            if (ModelState.IsValid)
            {
                var cert = (from c in Context.sh_certifications where c.CertificationID == model.CertificationID select c).First();
                cert.Abbreviation = model.Abbreviation;
                cert.CareerTrack = model.CareerTrack;
                cert.Details = model.Details;
                cert.Title = model.Title;
                cert.Url = model.Url;
                cert.LevelID = model.LevelID;
                cert.ProviderID = model.ProviderID;

                Context.SubmitChanges();

                return RedirectToAction("Index");
            }

            model.Levels = (from l in Context.sh_levels
                            orderby l.LevelID
                            select new SelectListItem
                            {
                                Text = l.Name,
                                Value = l.LevelID.ToString()
                            }).ToList();
            model.Providers = (from l in Context.sh_providers
                               orderby l.Name
                               select new SelectListItem
                               {
                                   Text = l.Name,
                                   Value = l.ProviderID.ToString()
                               }).ToList();

            return View(model);
        }
 private CertificationModel getModel()
 {
     CertificationModel model = new CertificationModel();
     model.Levels = (from l in Context.sh_levels
                     orderby l.LevelID
                     select new SelectListItem
                     {
                         Text = l.Name,
                         Value = l.LevelID.ToString()
                     }).ToList();
     model.Providers = (from l in Context.sh_providers
                        orderby l.Name
                        select new SelectListItem
                        {
                            Text = l.Name,
                            Value = l.ProviderID.ToString()
                        }).ToList();
     return model;
 }