public ActionResult DeleteCourse(int id /*, Course objCourse*/)
{
if (Session["UserId"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "User"));
}
try
{
// TODO: Add delete logic here
SubjectInCourse subjectInCourse = new SubjectInCourse();
subjectInCourse = db.SubjectsInCourses.Where(x => x.CourseId == id).FirstOrDefault();
Course objCourse = new Course();
objCourse = db.Courses.Where(x => x.CourseId == id).FirstOrDefault();
db.Courses.Remove(objCourse);
db.SubjectsInCourses.Remove(subjectInCourse);
db.SaveChanges();
return(RedirectToAction("CourseList"));
}
catch
{
return(View());
}
}
public ActionResult MapCourseAndSubject(MapCourseAndSubjectViewModel objMapCourseAndSubjectViewModel)
{
using (var dbTransaction = db.Database.BeginTransaction())
{
SubjectInCourse subjectInCourse = db.SubjectInCourses.Create();
try
{
if (ModelState.IsValid)
{
subjectInCourse.CourseId = objMapCourseAndSubjectViewModel.CourseId;
subjectInCourse.SubjectId = objMapCourseAndSubjectViewModel.SubjectId;
db.SubjectInCourses.Add(subjectInCourse);
db.SaveChanges();
dbTransaction.Commit();
return(RedirectToAction("Dashboard"));
}
return(View(objMapCourseAndSubjectViewModel));
}
catch (Exception ex)
{
Console.WriteLine("Exception source: {0} user is failed to register", ex.Message);
dbTransaction.Rollback();
}
}
return(RedirectToAction("Dashboard", "SuperAdmin"));
}
public ActionResult DeleteConfirmed(int id)
{
SubjectInCourse subjectInCourse = db.SubjectInCourse.Find(id);
db.SubjectInCourse.Remove(subjectInCourse);
db.SaveChanges();
return(RedirectToAction("GetMapCourseSubject"));
}
public ActionResult CreateSubjectInCourse([Bind(Include = "Id,SubjectId,CourseId")] SubjectInCourse subjectInCourse)
{
if (ModelState.IsValid)
{
db.SubjectInCourse.Add(subjectInCourse);
db.SaveChanges();
return(RedirectToAction("GetMapCourseSubject"));
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName", subjectInCourse.CourseId);
ViewBag.SubjectId = new SelectList(db.Subjects, "SubjectId", "SubjectName", subjectInCourse.SubjectId);
return(View(subjectInCourse));
}
public ActionResult DeleteConfirmed(int id)
{
if (Session["UserId"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "UserView", new { area = "" }));
}
SubjectInCourse subjectInCourse = db.SubjectInCourses.Find(id);
db.SubjectInCourses.Remove(subjectInCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,SubjectId,CourseId")] SubjectInCourse subjectInCourse)
{
if (ModelState.IsValid)
{
db.Entry(subjectInCourse).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName", subjectInCourse.CourseId);
ViewBag.SubjectId = new SelectList(db.Subjects, "SubjectId", "SubjectName", subjectInCourse.SubjectId);
return(View(subjectInCourse));
}
/// <summary>
/// Get method for delete
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Delete(int id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectInCourse subjectInCourse = db.SubjectInCourse.Find(id);
if (subjectInCourse == null)
{
return(HttpNotFound());
}
return(View(subjectInCourse));
}
/// <summary>
/// Update method for mapping
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult EditSubjectInCourse(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectInCourse subjectInCourse = db.SubjectInCourse.Find(id);
if (subjectInCourse == null)
{
return(HttpNotFound());
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName", subjectInCourse.CourseId);
ViewBag.SubjectId = new SelectList(db.Subjects, "SubjectId", "SubjectName", subjectInCourse.SubjectId);
return(View(subjectInCourse));
}
public ActionResult EditSubject([Bind(Include = "Id,SubjectId,CourseId")] SubjectInCourse subjectInCourse)
{
if (Session["UserId"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "UserView", new { area = "" }));
}
if (ModelState.IsValid)
{
db.Entry(subjectInCourse).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.IsActive == true), "CourseId", "CourseName", subjectInCourse.CourseId);
ViewBag.SubjectId = new SelectList(db.Subjects.Where(x => x.IsActive == true), "Id", "Name", subjectInCourse.SubjectId);
return(View(subjectInCourse));
}
public ActionResult CreateSubject([Bind(Include = "Id,SubjectId,CourseId")] SubjectInCourse subjectInCourse)
{
if (Session["UserId"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "UserView", new { area = "" }));
}
if (ModelState.IsValid)
{
db.SubjectInCourses.Add(subjectInCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseId = new SelectList(db.Courses, "CourseId", "CourseName", subjectInCourse.CourseId);
ViewBag.SubjectId = new SelectList(db.Subjects, "Id", "Name", subjectInCourse.SubjectId);
return(View(subjectInCourse));
}
/// <summary>
/// To show details of each Course and Subjects
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult Details(int?id)
{
if (Session["UserId"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "UserView", new { area = "" }));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectInCourse subjectInCourse = db.SubjectInCourses.Find(id);
if (subjectInCourse == null)
{
return(HttpNotFound());
}
return(View(subjectInCourse));
}
/// <summary>
/// GET :-To Edit Subject In Course
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public ActionResult EditSubject(int?id)
{
if (Session["UserId"] == null && Session["UserName"] == null)
{
return(RedirectToAction("Login", "UserView", new { area = "" }));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SubjectInCourse subjectInCourse = db.SubjectInCourses.Find(id);
if (subjectInCourse == null)
{
return(HttpNotFound());
}
ViewBag.CourseId = new SelectList(db.Courses.Where(x => x.IsActive == true), "CourseId", "CourseName", subjectInCourse.CourseId);
ViewBag.SubjectId = new SelectList(db.Subjects.Where(x => x.IsActive == true), "Id", "Name", subjectInCourse.SubjectId);
return(View(subjectInCourse));
}
public ActionResult DeleteCourseAndSubject(int id, SubjectInCourse objSubjectInCourse)
{
if (Session["Login"] == null)
{
return(RedirectToAction("Login", "User"));
}
try
{
// TODO: Add delete logic here
var removeCourseAndSubject = obj.SubjectsInCourses.Single(x => x.SubjectInCourseId == id);
obj.SubjectsInCourses.Remove(removeCourseAndSubject);
obj.SaveChanges();
return(RedirectToAction("CourseAndSubjectList"));
}
catch
{
return(View());
}
}
public ActionResult AssignSubjectForCourse(SubjectInCourse objSubjectInCourse)
{
if (Session["Login"] == null)
{
return(RedirectToAction("Login", "User"));
}
List <Course> List = obj.Courses.ToList();
ViewBag.CourseList = new SelectList(List, "CourseId", "CourseName", objSubjectInCourse.CourseId);
List <Subject> Lists = obj.Subjects.ToList();
ViewBag.SubjectList = new SelectList(Lists, "SubjectId", "SubjectName", objSubjectInCourse.SubjectId);
obj.SubjectsInCourses.Add(objSubjectInCourse);
obj.SaveChanges();
//return View(objSubjectInCourse);
return(RedirectToAction("CourseAndSubjectList"));
}
