public void Class_Curriculum(List <NewCurriculums> cur) { var dbTransection = db.Database.BeginTransaction(); try { foreach (var item in cur) { AspNetSubject_Curriculum curriculum = new AspNetSubject_Curriculum(); curriculum.SubjectID = item.SubjectID; curriculum.WeightageValue = item.WeightageValue; curriculum.CurriculumID = item.CurriculumID; var check = db.AspNetSubject_Curriculum.Any(x => x.CurriculumID == curriculum.CurriculumID && x.SubjectID == curriculum.SubjectID && x.CurriculumID == curriculum.CurriculumID); if (check) { AspNetSubject_Curriculum curric = (from x in db.AspNetSubject_Curriculum where x.CurriculumID == curriculum.CurriculumID && x.SubjectID == curriculum.SubjectID && x.CurriculumID == curriculum.CurriculumID select x).First(); curric.WeightageValue = curriculum.WeightageValue; curric.CurriculumID = curriculum.CurriculumID; curric.SubjectID = curriculum.SubjectID; } else { db.AspNetSubject_Curriculum.Add(curriculum); } db.SaveChanges(); } dbTransection.Commit(); } catch (Exception) { dbTransection.Dispose(); } }
public ActionResult DeleteConfirmed(int id) { AspNetSubject_Curriculum aspNetSubject_Curriculum = db.AspNetSubject_Curriculum.Find(id); db.AspNetSubject_Curriculum.Remove(aspNetSubject_Curriculum); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "Id,WeightageValue,CurriculumID,SubjectID")] AspNetSubject_Curriculum aspNetSubject_Curriculum) { if (ModelState.IsValid) { db.Entry(aspNetSubject_Curriculum).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CurriculumID = new SelectList(db.AspNetCurriculums, "Id", "CurriculumName", aspNetSubject_Curriculum.CurriculumID); ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetSubject_Curriculum.SubjectID); return(View(aspNetSubject_Curriculum)); }
// GET: AspNetSubject_Curriculum/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetSubject_Curriculum aspNetSubject_Curriculum = db.AspNetSubject_Curriculum.Find(id); if (aspNetSubject_Curriculum == null) { return(HttpNotFound()); } return(View(aspNetSubject_Curriculum)); }
// GET: AspNetSubject_Curriculum/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } AspNetSubject_Curriculum aspNetSubject_Curriculum = db.AspNetSubject_Curriculum.Find(id); if (aspNetSubject_Curriculum == null) { return(HttpNotFound()); } ViewBag.CurriculumID = new SelectList(db.AspNetCurriculums, "Id", "CurriculumName", aspNetSubject_Curriculum.CurriculumID); ViewBag.SubjectID = new SelectList(db.AspNetSubjects, "Id", "SubjectName", aspNetSubject_Curriculum.SubjectID); return(View(aspNetSubject_Curriculum)); }
public ActionResult CurriculumAdd(int RecWeightage, int RecCurric, int RecSubject) { AspNetSubject_Curriculum curricObjRem = db.AspNetSubject_Curriculum.FirstOrDefault(x => x.SubjectID == RecSubject && x.CurriculumID == RecCurric); if (curricObjRem != null) { curricObjRem.WeightageValue = RecWeightage; } if (curricObjRem == null) { AspNetSubject_Curriculum curricObj = new AspNetSubject_Curriculum(); curricObj.WeightageValue = RecWeightage; curricObj.SubjectID = RecSubject; curricObj.CurriculumID = RecCurric; db.AspNetSubject_Curriculum.Add(curricObj); } db.SaveChanges(); return(RedirectToAction("Index")); }