public ActionResult EditSbjctsTtlMrks(int id, int rid)
        {
            if (Session["Username"] == null && Session["Password"] == null)
            {
                return(RedirectToAction("Index", "Admin", new { area = "" }));
            }
            else
            {
                List <SubjectsTotalMarks> subjectsttlmrks = new Cateloge().SelectAllSubjectsTotalMarksWithIds(id, rid);
                AllClasses Data = new AllClasses();

                if (subjectsttlmrks == null)
                {
                    ViewBag.StatusMessage = " No Any Subject Founded ! ";
                }
                else
                {
                    Data.SubjectsTotalMark_s = new List <SubjectTotalMark>();
                    foreach (var gdfc in subjectsttlmrks)
                    {
                        SubjectTotalMark dbr = new SubjectTotalMark();
                        dbr.Id           = gdfc.Id;
                        dbr.R_id         = Convert.ToString(rid);
                        dbr.Subject_Name = gdfc.Subject_name.Name;
                        dbr.Total_marks  = gdfc.Total_marks;
                        Data.SubjectsTotalMark_s.Add(dbr);
                    }
                    Data.SubjectsTotalMark_s.TrimExcess();
                }
                return(PartialView("_EditSbjctsTtlMrks", Data));
            }
        }
        public ActionResult AddSbjctsTtlMrks(int id, int rid)
        {
            List <Subjects> subjects = new Cateloge().SelectSubjectsOfClassById(id);
            AllClasses      Data     = new AllClasses();

            if (subjects == null)
            {
                ViewBag.StatusMessage = " No Any Subject Founded ! ";
            }
            else
            {
                Data.SubjectsTotalMark_s = new List <SubjectTotalMark>();
                foreach (var gdfc in subjects)
                {
                    SubjectTotalMark dbr = new SubjectTotalMark();
                    dbr.Id           = gdfc.db_Id;
                    dbr.Subject_Name = gdfc.Name;
                    dbr.Subject_id   = gdfc.db_Id;
                    Data.SubjectsTotalMark_s.Add(dbr);
                }
                Data.SubjectsTotalMark_s.TrimExcess();

                Data.SubjectsTotalMarks_ = new SubjectTotalMark()
                {
                    R_id     = Convert.ToString(rid),
                    Class_id = Convert.ToString(id)
                };
            }
            return(PartialView("_AddSbjctsTtlMrks", Data));
        }
        public ActionResult AllSbjctsTtlMrks(int id)
        {
            if (Session["Username"] == null && Session["Password"] == null)
            {
                return(RedirectToAction("Index", "Admin", new { area = "" }));
            }
            else
            {
                Sub_Results               sub_result         = new Cateloge().SelectSubResult(id);
                List <ClassLevels>        ClassLevels        = new Cateloge().ClassLevels();
                List <SubjectsTotalMarks> subjectstotalmarks = new Cateloge().SelectAllSubjectsTotalMarks();
                AllClasses Data = new AllClasses();

                Data.Sub_Result = new Sub_Result()
                {
                    id   = sub_result.id,
                    name = sub_result.name
                };

                if (ClassLevels == null)
                {
                    ViewBag.StatusMessage = " No Any Data Found ! ";
                }
                else
                {
                    Data.ClassLevel_s = new List <ClassLevel>();
                    foreach (var gdfc in ClassLevels)
                    {
                        ClassLevel dbr = new ClassLevel();
                        dbr.Id   = gdfc.db_Id;
                        dbr.Name = gdfc.Name;
                        Data.ClassLevel_s.Add(dbr);
                    }
                    Data.ClassLevel_s.TrimExcess();
                    if (subjectstotalmarks == null)
                    {
                        ViewBag.StatusMessage = " No Any Data Found ! ";
                    }
                    else
                    {
                        Data.SubjectsTotalMark_s = new List <SubjectTotalMark>();
                        foreach (var gdfc in subjectstotalmarks)
                        {
                            SubjectTotalMark dbr = new SubjectTotalMark();
                            dbr.Class_id     = gdfc.Class_id;
                            dbr.R_id         = gdfc.R_id;
                            dbr.Subject_Name = gdfc.Subject_name.Name;
                            dbr.Total_marks  = gdfc.Total_marks;
                            Data.SubjectsTotalMark_s.Add(dbr);
                        }
                        Data.SubjectsTotalMark_s.TrimExcess();
                    }
                    return(View(Data));
                }
                return(View());
            }
        }
        public ActionResult ClsStdntsRslt(int id, int rid)
        {
            if (Session["Username"] == null && Session["Password"] == null)
            {
                return(RedirectToAction("Index", "Admin", new { area = "" }));
            }
            else
            {
                Sub_Results               sub_result      = new Cateloge().SelectSubResult(rid);
                ClassLevels               classLevel      = new Cateloge().SelectClassLevel(id);
                List <Students>           students        = new Cateloge().SelectStudentsForClassLevels(id);
                List <SubjectsTotalMarks> subjectsttlmrks = new Cateloge().SelectAllSubjectsTotalMarksWithIds(id, rid);
                AllClasses Data = new AllClasses();

                Data.Sub_Result = new Sub_Result()
                {
                    id   = sub_result.id,
                    name = sub_result.name
                };

                Data.ClassLevel_ = new ClassLevel()
                {
                    Name = classLevel.Name
                };

                if (students == null)
                {
                    ViewBag.StatusMessage = " No Any Data Found ! ";
                }
                else
                {
                    Data.Student_s = new List <Student>();
                    List <Student> StudentsList = new List <Student>();
                    foreach (var gdfc in students)
                    {
                        Student dbr = new Student();
                        dbr.db_Id        = gdfc.db_Id;
                        dbr.Aplicnt_Id   = gdfc.Aplicnt_Id;
                        dbr.Aplicnt_name = gdfc.Aplicnt_name;
                        dbr.ClassName    = (gdfc.ClassName != null) ? gdfc.ClassName.Name : null;
                        Data.Student_s.Add(dbr);
                    }
                    Data.Student_s.TrimExcess();
                }

                if (subjectsttlmrks == null)
                {
                    ViewBag.StatusMessage = " No Any Data Found ! ";
                }
                else
                {
                    Data.SubjectsTotalMark_s = new List <SubjectTotalMark>();
                    foreach (var gdfc in subjectsttlmrks)
                    {
                        SubjectTotalMark dbr = new SubjectTotalMark();
                        dbr.Subject_Name = gdfc.Subject_name.Name;
                        dbr.Total_marks  = gdfc.Total_marks;
                        Data.SubjectsTotalMark_s.Add(dbr);
                    }
                    Data.SubjectsTotalMark_s.TrimExcess();
                }
                return(View(Data));
            }
        }