public ActionResult Edit(Guid id)
{
using (JournalContext db = new JournalContext())
{
var StudentRole = Guid.Parse(Roles.Pupil);
ClassViewModels model = new ClassViewModels();
Class newClass = db.Classes.Find(id);
model.ID = newClass.ID;
model.Name = newClass.Name;
model.Year = newClass.Year;
model.SchoolID = newClass.SchoolID;
model.SelectedSchool = db.Schools.Where(c => c.ID == newClass.SchoolID).Select(x => x.ShortName).FirstOrDefault();
model.Users = db.Users.Where(c => c.UserRollID == StudentRole && c.SchoolID == model.SchoolID && c.ClassID == model.ID).Select(x => new SelectListItem()
{
Value = x.ID.ToString(), Text = x.FirstName + " " + x.LastName
}).ToList();
model.NewUsersList = db.Users.Where(c => c.UserRollID == StudentRole && c.SchoolID == model.SchoolID && c.ClassID == null).Select(c => new SelectListItem()
{
Value = c.ID.ToString(), Text = c.FirstName + " " + c.LastName
}).ToList();
if (model == null)
{
return(HttpNotFound());
}
return(View(model));
}
}
public ActionResult Create()
{
using (JournalContext db = new JournalContext())
{
ClassViewModels model = new ClassViewModels();
model.Schools = db.Schools.Select(school => new SelectListItem()
{
Value = school.ID.ToString(), Text = school.ShortName
}).ToList();
return(View(model));
}
}
public void DeleteClass(ClassViewModel delete)
{
for (int i = 0; i < LineaViewModels.Count; i++)
{
if (LineaViewModels[i].FirstClass == delete || LineaViewModels[i].SecondClass == delete)
{
LineaViewModels.RemoveAt(i);
i--;
}
}
ClassViewModels.Remove(delete);
}
public ActionResult Edit(ClassViewModels model)
{
using (JournalContext db = new JournalContext())
{
if (ModelState.IsValid)
{
Class newmodel = db.Classes.Find(model.ID);
newmodel.Name = model.Name;
newmodel.Year = model.Year;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
}
public ActionResult Create(ClassViewModels model)
{
using (JournalContext db = new JournalContext())
{
model.Schools = db.Schools.Select(school => new SelectListItem()
{
Value = school.ID.ToString(), Text = school.ShortName
}).ToList();
model.SchoolID = Guid.Parse(model.SelectedSchool);
if (ModelState.IsValid)
{
Class classes = (Class)model;
classes.ID = Guid.NewGuid();
db.Classes.Add(classes);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
}
public ActionResult Create(ClassViewModels model)
{
try
{
SE_ProjectEntities db = new SE_ProjectEntities();
if (DLSInterface.loggedEmail == null)
{
ViewBag.Warn = "Please Login First";
}
else if (db.TeacherTbls.Any(t => t.Email.Equals(DLSInterface.loggedEmail)))
{
ClassTbl c = new ClassTbl();
c.Name = model.name;
c.School_Id = db.SchoolTbls.Where(s => s.Name.Equals(model.schoolName)).FirstOrDefault().Id;
c.Code = model.classCode;
bool isexist = false;
foreach (ClassTbl cls in db.ClassTbls)
{
if (cls.Name == model.name && cls.School_Id == c.School_Id)
{
isexist = true;
}
}
if (!isexist)
{
db.ClassTbls.Add(c);
db.SaveChanges();
}
int teacherId = db.TeacherTbls.Where(t => t.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().Id;
int classId = db.ClassTbls.Where(C => C.Name.Equals(model.name)).FirstOrDefault().Id;
bool isExist = false;
foreach (TeacherClassOTM tc in db.TeacherClassOTMs)
{
if (tc.Teacher_Id == teacherId && tc.Class_Id == classId)
{
isExist = true;
}
}
if (isExist)
{
ViewBag.Warn = "Already Exists";
}
else
{
TeacherClassOTM tc = new TeacherClassOTM();
tc.Teacher_Id = teacherId;
tc.Class_Id = classId;
db.TeacherClassOTMs.Add(tc);
db.SaveChanges();
ViewBag.Warn = "Success";
}
}
else
{
ViewBag.Warn = "You Must Be Teacher To Register Class";
}
return(View("Create"));
}
catch
{
return(View());
}
}
