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());
}
}
public ActionResult AddClass(ViewClassViewModels model)
{
try
{
SE_ProjectEntities db = new SE_ProjectEntities();
List <SchoolTbl> SchoolList = db.SchoolTbls.ToList();
ViewBag.SchoolList = new SelectList(SchoolList, "Id", "Name");
if (DLSInterface.loggedEmail == null)
{
ViewBag.Warn = "Login First";
return(View());
}
else if (db.TeacherTbls.Any(t => t.Email.Equals(DLSInterface.loggedEmail)))
{
int teacherId = db.TeacherTbls.Where(t => t.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().Id;
int classId = db.ClassTbls.Where(c => c.Name.Equals(model.className)).FirstOrDefault().Id;
string classCode = db.ClassTbls.Where(c => c.Name.Equals(model.className)).FirstOrDefault().Code;
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 Registered in Class";
return(View());
}
else
{
TeacherClassOTM tc = new TeacherClassOTM();
tc.Teacher_Id = teacherId;
tc.Class_Id = classId;
if (classCode.Equals(model.classCode))
{
db.TeacherClassOTMs.Add(tc);
db.SaveChanges();
ViewBag.Warn = "Success!";
return(View());
}
else
{
ViewBag.Warn = "Invalid code!";
return(View());
}
}
}
else if (db.StudentTbls.Any(t => t.Email.Equals(DLSInterface.loggedEmail)))
{
int studentId = db.StudentTbls.Where(s => s.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().Id;
int classId = db.ClassTbls.Where(c => c.Name.Equals(model.className)).FirstOrDefault().Id;
string classCode = db.ClassTbls.Where(c => c.Name.Equals(model.className)).FirstOrDefault().Code;
bool isExist = false;
foreach (StudentClassOTM sc in db.StudentClassOTMs)
{
if (sc.Student_Id == studentId && sc.Class_Id == classId)
{
isExist = true;
break;
}
}
if (isExist)
{
ViewBag.Warn = "Already Registered in Class";
return(View());
}
else
{
StudentClassOTM sc = new StudentClassOTM();
sc.Student_Id = studentId;
sc.Class_Id = classId;
if (classCode.Equals(model.classCode))
{
db.StudentClassOTMs.Add(sc);
db.SaveChanges();
ViewBag.Warn = "Success!";
return(View());
}
else
{
ViewBag.Warn = "Invalid code!";
return(View());
}
}
}
return(View());
}
catch
{
return(View());
}
}
