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