// GET: Education public ActionResult Index() { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { return(View(db.Education.ToList())); } }
private void populateWithPicture(EPopulate targetType, object param) { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { switch (targetType) { case EPopulate.Education: foreach (var education in (List <EducationViewModel>)param) { education.Pictures = db.PicturesApp.Where(x => x.EducationViewModelID == education.ID).ToList(); } break; case EPopulate.Experiences: foreach (var experience in (List <ExperiencesViewModel>)param) { experience.Pictures = db.PicturesApp.Where(x => x.ExperiencesViewModelID == experience.ID).ToList(); } break; case EPopulate.Projects: foreach (var project in (List <ProjectsViewModel>)param) { project.ProjectDetail.Pictures = db.PicturesApp.Where(x => x.ProjectDetailsViewModelID == project.ProjectDetail.ID).ToList(); } break; //case EPopulateDisplay.Skills: //foreach (var skill in (List<SkillsViewModel>)param) //{ // skill.Pictures = db.PicturesApp.Where(x => x.SkillsViewModelID == skill.ID).ToList(); //} //break; } } }
//private DBModelPortfolioContext db = new DBModelPortfolioContext(); // GET: Education public ActionResult Index() { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { return View(db.Education.ToList()); } //return Content("Education page"); }
public ActionResult Index() { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { Log.write("education list count = "+ db.Education.Count(), "WAR"); return View(db.Education.ToList()); } //return Content("Education page"); }
private void populateEducationWithPicture(List <EducationViewModel> educationList) { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { foreach (var education in educationList) { education.Pictures = db.PicturesApp.Where(x => x.EducationViewModelID == education.ID).ToList(); } } }
protected override void Dispose(bool disposing) { if (disposing) { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { db.Dispose(); } } base.Dispose(disposing); }
private void populateEducationWithPicture(List<EducationViewModel> educationList) { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { foreach (var education in educationList) { education.Pictures = db.PicturesApp.Where(x => x.EducationViewModelID == education.ID).ToList(); } } }
public ActionResult DeleteConfirmed(int id) { try { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { EducationViewModel educationViewModel = db.Education.Find(id); db.Education.Remove(educationViewModel); db.SaveChanges(); } } catch (Exception ex) { Log.write(ex.Message, "ERR"); } return(RedirectToAction("Index")); }
// GET: Education/Delete/5 public ActionResult Delete(int?id) { EducationViewModel educationViewModel; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { educationViewModel = db.Education.Find(id); } if (educationViewModel == null) { return(HttpNotFound()); } return(View(educationViewModel)); }
// GET: Education/Details/5 public ActionResult Details(int? id) { EducationViewModel educationViewModel; if (id == null) { return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { educationViewModel = db.Education.Find(id); } if (educationViewModel == null) { return HttpNotFound(); } return View(educationViewModel); //return Content("Education page"); }
public ActionResult _Index() { List <EducationViewModel> educationList = new List <EducationViewModel>(); try { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { educationList = db.Education.Include("Pictures").ToList(); populateEducationWithPicture(educationList); } } catch (Exception ex) { Log.write(ex.Message, "ERR"); return(View("Error")); } return(View(educationList.OrderByDescending(x => x.YearGraduate).ToList())); }
public ActionResult Edit([Bind(Include = "ID,SchoolName,YearGraduate,NbYearsToGraduate,link")] EducationViewModel educationViewModel) { if (ModelState.IsValid) { try { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { db.Entry(educationViewModel).State = EntityState.Modified; db.SaveChanges(); } } catch (Exception ex) { Log.write(ex.Message, "ERR"); } return(RedirectToAction("Index")); } return(View(educationViewModel)); }
public ActionResult _Index() { //using (var Ddb = new DBDisplayModelContext()) //{ // ViewBag.AvatarUrl = Ddb.DisplayWelcome.OrderByDescending(x=>x.ID).First().Path + Ddb.DisplayWelcome.OrderByDescending(x => x.ID).First().FileName; //} List<EducationViewModel> educationList = new List<EducationViewModel>(); try { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { educationList = db.Education.Include("Pictures").ToList(); populateEducationWithPicture(educationList); } } catch (Exception ex) { Log.write(ex.Message, "ERR"); return View("Error"); } //return Content("Education page"); return View(educationList.OrderByDescending(x => x.YearGraduate).ToList()); }
public void setContext(DBModelPortfolioContext dbContext) { db = dbContext; }
public void setContext(DBModelPortfolioContext dbContext) { db = dbContext; }
public ActionResult Create([Bind(Include = "ID,SchoolName,YearGraduate,NbYearsToGraduate,link,Description")] EducationViewModel educationViewModel) { if (ModelState.IsValid) { try { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { db.Education.Add(educationViewModel); db.SaveChanges(); } } catch (Exception ex) { Log.write(ex.Message, "ERR"); } return RedirectToAction("Index"); } return View(educationViewModel); //return Content("Education page"); }
protected override void Dispose(bool disposing) { if (disposing) { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { db.Dispose(); } } base.Dispose(disposing); }
public ActionResult DeleteConfirmed(int id) { try { using (DBModelPortfolioContext db = new DBModelPortfolioContext()) { EducationViewModel educationViewModel = db.Education.Find(id); db.Education.Remove(educationViewModel); db.SaveChanges(); } } catch (Exception ex) { Log.write(ex.Message, "ERR"); } return RedirectToAction("Index"); //return Content("Education page"); }