public ActionResult Edit(int id, EditViewModels e, HttpPostedFileBase file)
 {
     try
     {
         if (file != null)
         {
             var bs = new byte[file.ContentLength];
             using (var fs = file.InputStream)
             {
                 var offset = 0;
                 do
                 {
                     offset += fs.Read(bs, offset, bs.Length - offset);
                 } while (offset < bs.Length);
             }
             DLSInterface.image = bs;
             return(View());
         }
         else
         {
             SE_ProjectEntities db = new SE_ProjectEntities();
             db.Posts.Find(id).Summary = e.summary;
             db.Posts.Find(id).Details = e.details;
             db.Posts.Find(id).Picture = DLSInterface.image;
             db.SaveChanges();
             DLSInterface.image = null;
             return(RedirectToAction("Index"));
         }
     }
     catch
     {
         return(View());
     }
 }
        // GET: Profile/Edit/5
        public ActionResult Edit()
        {
            try
            {
                if (DLSInterface.loggedEmail == null)
                {
                    return(RedirectToAction("Login", "Person"));
                }
                int idx = DLSInterface.Profileid;

                ProfileEditViewModels p  = new ProfileEditViewModels();
                SE_ProjectEntities    db = new SE_ProjectEntities();
                Profile myprofile        = db.Profiles.Find(idx);
                p.id                 = myprofile.id;
                p.Name               = myprofile.Name;
                p.PersonalInfo       = myprofile.PersonalInfo;
                p.ProfilePicture     = myprofile.ProfilePicture;
                DLSInterface.image   = myprofile.ProfilePicture;
                p.RelationshipStatus = myprofile.RelationshipStatus;
                p.PhoneNumber        = myprofile.PhoneNumber;
                p.Email              = myprofile.Email;
                p.Designation        = myprofile.Designation;
                p.DateOfBirth        = myprofile.DateOfBirth;
                p.Gender             = myprofile.Gender;
                return(View(p));
            }
            catch
            {
                return(View());
            }
        }
예제 #3
0
 // GET: Resources/Details/5
 public ActionResult Details(int id)
 {
     try
     {
         MaterialResource   s  = new MaterialResource();
         SE_ProjectEntities db = new SE_ProjectEntities();
         foreach (MaterialResource b in db.MaterialResources)
         {
             if (b.id == id)
             {
                 s.Name    = b.Name;
                 s.Length  = b.Length;
                 s.Content = b.Content;
                 s.id      = b.id;
                 s.Type    = b.Type;
                 break;
             }
         }
         MemoryStream ms = new MemoryStream(s.Content, 0, 0, true, true);
         Response.ContentType = s.Type;
         Response.AddHeader("content-disposition", "attachment;filename=" + s.Name);
         Response.Buffer = true;
         Response.Clear();
         Response.OutputStream.Write(ms.GetBuffer(), 0, ms.GetBuffer().Length);
         Response.OutputStream.Flush();
         Response.End();
         return(new FileStreamResult(Response.OutputStream, s.Type));
     }
     catch
     {
         return(View());
     }
 }
        public ActionResult Create(PersonViewModels model)
        {
            try
            {
                SE_ProjectEntities db = new SE_ProjectEntities();

                if (db.TeacherTbls.Any(t => t.Email.Equals(model.email)) || db.StudentTbls.Any(t => t.Email.Equals(model.email)))
                {
                    ViewBag.Message = "Email Already Taken!";
                }
                else
                {
                    if (model.isTeacher)
                    {
                        TeacherTbl t = new TeacherTbl();
                        t.Name     = model.name;
                        t.Email    = model.email;
                        t.Password = model.password;
                        DLSInterface.loggedEmail = t.Email;
                        db.TeacherTbls.Add(t);
                        db.SaveChanges();
                        ViewBag.Message = "Success!";
                    }
                    else
                    {
                        StudentTbl s = new StudentTbl();
                        s.Name     = model.name;
                        s.Email    = model.email;
                        s.Password = model.password;
                        DLSInterface.loggedEmail = s.Email;
                        db.StudentTbls.Add(s);
                        db.SaveChanges();
                        ViewBag.Message = "Success!";
                    }
                }
                if (DLSInterface.loggedEmail != null)
                {
                    Profile first = new Profile();
                    first.Email                   = DLSInterface.loggedEmail;
                    first.Name                    = null;
                    first.ProfilePicture          = null;
                    first.PhoneNumber             = null;
                    first.DateOfBirth             = null;
                    first.RelationshipStatus      = null;
                    first.Designation             = null;
                    first.NumberOfClassesEnrolled = DLSInterface.getNumberofClassesEnrolled(first.Email);
                    first.PersonalInfo            = null;
                    first.Gender                  = null;
                    db.Profiles.Add(first);
                    db.SaveChanges();
                    return(RedirectToAction("ViewClass", "Class"));
                }
                return(View());
            }
            catch
            {
                return(View());
            }
        }
        // GET: Announcement/Delete/5
        public ActionResult Delete(int id)
        {
            SE_ProjectEntities db = new SE_ProjectEntities();

            db.Announcements.Remove(db.Announcements.Find(id));
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public ActionResult AddClass()
        {
            SE_ProjectEntities db         = new SE_ProjectEntities();
            List <SchoolTbl>   SchoolList = db.SchoolTbls.ToList();

            ViewBag.SchoolList = new SelectList(SchoolList, "Id", "Name");

            ViewBag.Warn = "";
            return(View());
        }
        public ActionResult ViewClass()
        {
            DLSInterface.ClassEntered = -1;
            SE_ProjectEntities db         = new SE_ProjectEntities();
            List <SchoolTbl>   SchoolList = db.SchoolTbls.ToList();

            ViewBag.SchoolList = new SelectList(SchoolList, "Id", "Name");

            ViewBag.Warn = "";
            return(View());
        }
        // GET: Post/Edit/5
        public ActionResult Edit(int id)
        {
            EditViewModels     l  = new EditViewModels();
            SE_ProjectEntities db = new SE_ProjectEntities();
            Post p = db.Posts.Find(id);

            DLSInterface.image = p.Picture;
            l.summary          = p.Summary;
            l.details          = p.Details;


            return(View(l));
        }
 // GET: Post/Delete/5
 public ActionResult Delete(int id)
 {
     try
     {
         SE_ProjectEntities db = new SE_ProjectEntities();
         Post p = db.Posts.Find(id);
         db.Posts.Remove(p);
         db.SaveChanges();
         return(RedirectToAction("Index", "Post"));
     }
     catch
     {
         return(RedirectToAction("Index"));
     }
 }
        // GET: Profile/Delete/5
        public ActionResult Delete()
        {
            int id = DLSInterface.GetIdByEmail(DLSInterface.loggedEmail);
            SE_ProjectEntities db = new SE_ProjectEntities();

            foreach (Post p in db.Posts)
            {
                if (p.email == DLSInterface.loggedEmail)
                {
                    db.Posts.Remove(p);
                }
            }
            foreach (Profile my in db.Profiles)
            {
                if (my.Email == DLSInterface.loggedEmail)
                {
                    db.Profiles.Remove(my);
                    break;
                }
            }

            if (db.TeacherTbls.Find(id) != null && db.TeacherTbls.Find(id).Email == DLSInterface.loggedEmail)
            {
                db.TeacherTbls.Remove(db.TeacherTbls.Find(id));

                foreach (TeacherClassOTM totm in db.TeacherClassOTMs)
                {
                    if (totm.Teacher_Id == id)
                    {
                        db.TeacherClassOTMs.Remove(totm);
                    }
                }
            }
            else
            {
                foreach (StudentClassOTM t in db.StudentClassOTMs)
                {
                    if (t.Student_Id == id)
                    {
                        db.StudentClassOTMs.Remove(t);
                    }
                }
                db.StudentTbls.Remove(db.StudentTbls.Find(id));
            }
            db.SaveChanges();
            DLSInterface.logout();
            return(RedirectToAction("Create", "Person"));
        }
예제 #11
0
        // GET: Resources
        public ActionResult Index()
        {
            SE_ProjectEntities        db    = new SE_ProjectEntities();
            List <ResourceViewModels> model = new List <ResourceViewModels>();

            foreach (MaterialResource m in db.MaterialResources)
            {
                if (m.Classid == DLSInterface.ClassEntered)
                {
                    ResourceViewModels s = new ResourceViewModels();
                    s.name = m.Name;
                    s.id   = m.id;
                    model.Add(s);
                }
            }
            return(View(model));
        }
        // GET: Profile
        public ActionResult Index()
        {
            int id = DLSInterface.GetIdByEmail(DLSInterface.loggedEmail);

            if (DLSInterface.loggedEmail == null)
            {
                RedirectToAction("Login", "Person");
            }
            SE_ProjectEntities db = new SE_ProjectEntities();
            Profile            p  = new Profile();

            foreach (Profile k in db.Profiles)
            {
                if (k.Email == DLSInterface.loggedEmail)
                {
                    p.Email = k.Email;
                    p.Name  = k.Name;
                    p.id    = k.id;
                    p.NumberOfClassesEnrolled = k.NumberOfClassesEnrolled;
                    p.ProfilePicture          = k.ProfilePicture;
                    p.PhoneNumber             = k.PhoneNumber;
                    p.DateOfBirth             = k.DateOfBirth;
                    p.RelationshipStatus      = k.RelationshipStatus;
                    p.Designation             = k.Designation;
                    p.PersonalInfo            = k.PersonalInfo;
                    p.Gender = k.Gender;
                    break;
                }
            }
            ProfileEditViewModels display = new ProfileEditViewModels();

            display.id                      = p.id;
            display.Email                   = p.Email;
            display.ProfilePicture          = p.ProfilePicture;
            display.PhoneNumber             = p.PhoneNumber;
            display.DateOfBirth             = p.DateOfBirth;
            display.RelationshipStatus      = p.RelationshipStatus;
            display.NumberOfClassesEnrolled = DLSInterface.getNumberofClassesEnrolled(DLSInterface.loggedEmail);
            display.Designation             = p.Designation;
            display.PersonalInfo            = p.PersonalInfo;
            display.Gender                  = p.Gender;
            display.Name                    = p.Name;
            DLSInterface.Profileid          = display.id;
            return(View(display));
        }
        // GET: Announcement
        public ActionResult Index()
        {
            SE_ProjectEntities            db  = new SE_ProjectEntities();
            List <AnnouncementViewModels> ann = new List <AnnouncementViewModels>();

            foreach (Announcement a in db.Announcements)
            {
                if (a.ClassId == DLSInterface.ClassEntered)
                {
                    AnnouncementViewModels b = new AnnouncementViewModels();
                    b.ClassId   = a.ClassId;
                    b.id        = a.id;
                    b.TeacherId = a.TeacherId;
                    b.Text      = a.Text;
                    ann.Add(b);
                }
            }
            return(View(ann));
        }
예제 #14
0
        public ActionResult Create(HttpPostedFileBase uploadFile)
        {
            byte[] tempFile = new byte[uploadFile.ContentLength];
            uploadFile.InputStream.Read(tempFile, 0, uploadFile.ContentLength);
            SE_ProjectEntities db = new SE_ProjectEntities();
            MaterialResource   s  = new MaterialResource();

            s.Content   = tempFile;
            s.Name      = uploadFile.FileName;
            s.Length    = uploadFile.ContentLength;
            s.Type      = uploadFile.ContentType;
            s.TeacherId = DLSInterface.GetIdByEmail(DLSInterface.loggedEmail);
            s.Classid   = DLSInterface.ClassEntered;
            db.MaterialResources.Add(s);
            db.SaveChanges();


            return(RedirectToAction("Index"));
        }
 public ActionResult Create(AnnouncementViewModels collection)
 {
     try
     {
         // TODO: Add insert logic here
         Announcement a = new Announcement();
         a.ClassId   = DLSInterface.ClassEntered;
         a.TeacherId = DLSInterface.GetIdByEmail(DLSInterface.loggedEmail);
         a.Text      = collection.Text;
         SE_ProjectEntities db = new SE_ProjectEntities();
         db.Announcements.Add(a);
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     catch
     {
         return(View());
     }
 }
        public ActionResult Create(HttpPostedFileBase file, string Summary, string Details)
        {
            try
            {
                if (DLSInterface.loggedEmail == null)
                {
                    RedirectToAction("Login", "Person");
                }

                SE_ProjectEntities db = new SE_ProjectEntities();
                Post p = new Post();
                p.class_id = DLSInterface.ClassEntered;
                p.email    = DLSInterface.loggedEmail;
                p.Summary  = Summary;
                p.Details  = Details;
                if (file != null)
                {
                    var bs = new byte[file.ContentLength];
                    using (var fs = file.InputStream)
                    {
                        var offset = 0;
                        do
                        {
                            offset += fs.Read(bs, offset, bs.Length - offset);
                        } while (offset < bs.Length);
                    }
                    p.Picture = bs;
                }
                else
                {
                    p.Picture = null;
                }

                db.Posts.Add(p);
                db.SaveChanges();
                return(RedirectToAction("Create", "Post"));
            }
            catch
            {
                return(View());
            }
        }
        public ActionResult Create(SchoolViewModels 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)))
                {
                    SchoolTbl s = new SchoolTbl();
                    s.Name = model.name;

                    if (db.SchoolTbls.Any(S => S.Name.Equals(model.name)))
                    {
                        ViewBag.Warn = "School Already Exists";
                    }
                    else
                    {
                        db.SchoolTbls.Add(s);
                        db.SaveChanges();
                    }
                }
                else
                {
                    ViewBag.Warn = "You Must Be Teacher To Register School";
                }
                if (ViewBag.Warn == null)
                {
                    return(RedirectToAction("Create", "Class"));
                }

                return(View("Create"));
            }
            catch
            {
                return(View());
            }
        }
        public ActionResult Edit(ProfileEditViewModels collection, HttpPostedFileBase file)
        {
            try
            {
                // TODO: Add update logic here
                if (file != null)
                {
                    var bs = new byte[file.ContentLength];
                    using (var fs = file.InputStream)
                    {
                        var offset = 0;
                        do
                        {
                            offset += fs.Read(bs, offset, bs.Length - offset);
                        } while (offset < bs.Length);
                    }
                    DLSInterface.image = bs;
                    return(View());
                }
                else
                {
                    SE_ProjectEntities db = new SE_ProjectEntities();

                    db.Profiles.Where(p => p.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().Name               = collection.Name;
                    db.Profiles.Where(p => p.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().Gender             = collection.Gender;
                    db.Profiles.Where(p => p.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().Designation        = collection.Designation;
                    db.Profiles.Where(p => p.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().RelationshipStatus = collection.RelationshipStatus;
                    db.Profiles.Where(p => p.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().DateOfBirth        = collection.DateOfBirth;
                    db.Profiles.Where(p => p.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().PhoneNumber        = collection.PhoneNumber;
                    db.Profiles.Where(p => p.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().PersonalInfo       = collection.PersonalInfo;
                    db.Profiles.Where(p => p.Email.Equals(DLSInterface.loggedEmail)).FirstOrDefault().ProfilePicture     = DLSInterface.image;

                    db.SaveChanges();
                    return(RedirectToAction("Index", "Profile"));
                }
            }
            catch
            {
                return(View());
            }
        }
        public ActionResult Index()
        {
            if (DLSInterface.loggedEmail == null)
            {
                return(RedirectToAction("Login", "Person"));
            }
            SE_ProjectEntities    db    = new SE_ProjectEntities();
            List <PostViewModels> Posts = new List <PostViewModels>();

            foreach (Post p in db.Posts)
            {
                if (p.class_id == DLSInterface.ClassEntered)
                {
                    PostViewModels each_post = new PostViewModels();
                    each_post.Email   = p.email;
                    each_post.id      = p.id;
                    each_post.Summary = p.Summary;
                    each_post.details = p.Details;
                    each_post.image   = p.Picture;
                    Posts.Add(each_post);
                }
            }
            return(View(Posts));
        }
        public ActionResult Login(LoginViewModels model)
        {
            SE_ProjectEntities db = new SE_ProjectEntities();

            if (db.TeacherTbls.Any(t => t.Email.Equals(model.email)))
            {
                if (db.TeacherTbls.Where(t => t.Email.Equals(model.email)).FirstOrDefault().Password.Equals(model.password))
                {
                    DLSInterface.loggedEmail = db.TeacherTbls.Where(t => t.Email.Equals(model.email)).FirstOrDefault().Email;
                }
                else
                {
                    ViewBag.Message = "Email or Password Doesn't match";
                }
            }
            else if (db.StudentTbls.Any(t => t.Email.Equals(model.email)))
            {
                if (db.StudentTbls.Where(t => t.Email.Equals(model.email)).FirstOrDefault().Password.Equals(model.password))
                {
                    DLSInterface.loggedEmail = db.StudentTbls.Where(t => t.Email.Equals(model.email)).FirstOrDefault().Email;
                }
                else
                {
                    ViewBag.Message = "Email or Password Doesn't match";
                }
            }
            else
            {
                ViewBag.Message = "Email not Registered";
            }
            if (DLSInterface.loggedEmail != null)
            {
                return(RedirectToAction("ViewClass", "Class"));
            }
            return(View());
        }
        public JsonResult GetClassList(string schoolName)
        {
            SE_ProjectEntities db = new SE_ProjectEntities();

            if (!db.SchoolTbls.Any(s => s.Name.Equals(schoolName)))
            {
                List <string> classListEmpty = new List <string>();
                return(Json(classListEmpty, JsonRequestBehavior.AllowGet));
            }
            int schoolId = db.SchoolTbls.Where(s => s.Name.Equals(schoolName)).FirstOrDefault().Id;

            db.Configuration.ProxyCreationEnabled = false;
            //List<ClassTbl> ClassList = db.ClassTbls.Where(x => x.School_Id == schoolId).ToList();
            List <string> classList = new List <string>();

            foreach (ClassTbl c in db.ClassTbls)
            {
                if (c.School_Id == schoolId)
                {
                    classList.Add(c.Name);
                }
            }
            return(Json(classList, JsonRequestBehavior.AllowGet));
        }
        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());
            }
        }
        public ActionResult ViewClass(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;

                    bool isExist = false;
                    foreach (TeacherClassOTM tc in db.TeacherClassOTMs)
                    {
                        if (tc.Teacher_Id == teacherId && tc.Class_Id == classId)
                        {
                            isExist = true;
                        }
                    }

                    if (!isExist)
                    {
                        ViewBag.Warn = "Not Registered in Class";
                        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;

                    bool isExist = false;
                    foreach (StudentClassOTM sc in db.StudentClassOTMs)
                    {
                        if (sc.Student_Id == studentId && sc.Class_Id == classId)
                        {
                            isExist = true;
                        }
                    }
                    if (!isExist)
                    {
                        ViewBag.Warn = "Not Registered in Class";
                        return(View());
                    }
                }
                else
                {
                    int schoolId = db.SchoolTbls.Where(s => s.Name.Equals(model.schoolName)).FirstOrDefault().Id;

                    bool isexist = false;
                    foreach (ClassTbl cl in db.ClassTbls)
                    {
                        if (cl.School_Id == schoolId && cl.Name == model.className)
                        {
                            isexist = true;
                        }
                    }
                    if (!isexist)
                    {
                        ViewBag.Warn = "Class Not Found";
                        return(View());
                    }
                }

                int actualClassId = -1;
                foreach (ClassTbl c in db.ClassTbls)
                {
                    if (c.School_Id.ToString().Equals(model.schoolName) && c.Name.Equals(model.className))
                    {
                        actualClassId = c.Id;
                    }
                }
                DLSInterface.ClassEntered = actualClassId;
                return(RedirectToAction("Index", "Post"));
            }
            catch
            {
                return(View());
            }
        }
        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());
            }
        }