// 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");
}
