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