public ActionResult Edit(int id = 0) { var instuteID = Convert.ToInt32(Membership.GetUser().PasswordQuestion); ClassSubject subject = rep.GetById(id); if (subject == null || subject.Deleted == true || subject.InstituteID != instuteID) { return(HttpNotFound()); } var data = db.Class.Where(x => x.Deleted == false).Where(x => x.InstituteID == instuteID); ViewBag.ClassId = new SelectList(data, "Id", "Name", subject.ClassId); var classSubject = new ClassSubjectVM() { ClassId = subject.ClassId, Id = subject.Id, SubjectNames = subject.SubjectNames }; classSubject.SubjectBooks = subject.SubjectBook.ToList(); return(View(classSubject)); }
public ActionResult Create(ClassSubjectVM ClassSubject) { if (ModelState.IsValid) { rep.Add(ClassSubject); return(RedirectToAction("Index")); } var instuteID = Convert.ToInt32(Membership.GetUser().PasswordQuestion); var data = db.Class.Where(x => x.Deleted == false).Where(x => x.InstituteID == instuteID); ViewBag.ClassId = new SelectList(data, "Id", "Name"); return(View(ClassSubject)); }
public ActionResult Create() { var instuteID = Convert.ToInt32(Membership.GetUser().PasswordQuestion); var data = db.Class.Where(x => x.Deleted == false).Where(x => x.InstituteID == instuteID); ViewBag.ClassId = new SelectList(data, "Id", "Name"); var ClassSubject = new ClassSubjectVM() { SubjectBooks = new List <SubjectBook>() }; return(View(ClassSubject)); }
public ActionResult Edit(ClassSubjectVM ClassSubject) { var instuteID = Convert.ToInt32(Membership.GetUser().PasswordQuestion); ClassSubject subject = rep.GetById(ClassSubject.Id); if (subject == null || subject.Deleted == true || subject.InstituteID != instuteID) { return(HttpNotFound()); } if (ModelState.IsValid) { rep.Update(ClassSubject); return(RedirectToAction("Index")); } var data = db.Class.Where(x => x.Deleted == false).Where(x => x.InstituteID == instuteID); ViewBag.ClassId = new SelectList(data, "Id", "Name"); return(View(ClassSubject)); }
public ClassSubject Add(ClassSubjectVM entity) { var instuteID = Convert.ToInt32(Membership.GetUser().PasswordQuestion); var classsubject = new ClassSubject() { InstituteID = instuteID, ClassId = entity.ClassId, SubjectNames = entity.SubjectNames }; using (var Transaction = db.Database.BeginTransaction()) { try { db.ClassSubject.Add(classsubject); db.SaveChanges(); if (entity.SubjectBooks != null) { foreach (var item in entity.SubjectBooks) { if (!string.IsNullOrWhiteSpace(item.Name)) { item.ClassSubjectID = classsubject.Id; db.SubjectBook.Add(item); } } db.SaveChanges(); } Transaction.Commit(); } catch (Exception ex) { Transaction.Rollback(); } } return(classsubject); }
public ClassSubject Update(ClassSubjectVM entity) { var instuteID = Convert.ToInt32(Membership.GetUser().PasswordQuestion); var classsubject = db.ClassSubject.Find(entity.Id); classsubject.SubjectNames = entity.SubjectNames; db.Entry(classsubject).Property(x => x.SubjectNames).IsModified = true; using (var Transaction = db.Database.BeginTransaction()) { try { db.SaveChanges(); db.Database.ExecuteSqlCommand("DELETE FROM SubjectBook WHERE ClassSubjectID = " + classsubject.Id); if (entity.SubjectBooks != null) { foreach (var item in entity.SubjectBooks) { if (!string.IsNullOrWhiteSpace(item.Name)) { item.ClassSubjectID = classsubject.Id; db.SubjectBook.Add(item); } } db.SaveChanges(); } db.SaveChanges(); Transaction.Commit(); } catch (Exception ex) { Transaction.Rollback(); } } return(classsubject); }