public static void AddCourseStatus(string CourseCode, string Session, Boolean Status)
        {
            ProjectDB db     = new ProjectDB();
            Course    Course = db.Courses.Where(dp => dp.Course_code == CourseCode).FirstOrDefault();

            if (Course == null)
            {
                return;
            }

            CourseStatus OldCourseStatus = db.CourseStatus.Where(dp => dp.Course_code == Course.Course_code && dp.UnderSession == Session).FirstOrDefault();

            if (OldCourseStatus != null)
            {
                return;
            }

            CourseStatus CourseStatus = new CourseStatus();

            CourseStatus.Course_code             = Course.Course_code;
            CourseStatus.Course_title            = Course.Course_title;
            CourseStatus.Credit_hour             = Course.Credit_hour;
            CourseStatus.Semester                = Course.Semester;
            CourseStatus.UnderFaculty            = Course.UnderFaculty;
            CourseStatus.UnderDepartment         = Course.UnderDepartment;
            CourseStatus.CourseTeacherID         = Course.CourseTeacherID;
            CourseStatus.CourseTeacherName       = Course.CourseTeacherName;
            CourseStatus.CourseTeacherDepartment = Course.CourseTeacherDepartment;
            CourseStatus.CourseTeacherFaculty    = Course.CourseTeacherFaculty;
            CourseStatus.UnderSession            = Session;
            CourseStatus.Status = Status;

            db.CourseStatus.Add(CourseStatus);
            db.SaveChanges();
        }
Exemple #2
0
        public static List <Result> GetResults(string Session, int Semester)
        {
            int batchId    = Convert.ToInt32(Session.Substring(2, 2)); //startIndex, Length
            int startRange = batchId * 100000;
            int endRange   = ((batchId + 1) * 100000) - 1;

            ProjectDB     db         = new ProjectDB();
            List <Result> AllResults = new List <Result>();

            AllResults = db.FinalResults.Where(fr => fr.StudentId >= startRange && fr.StudentId <= endRange && fr.Semester == Semester).ToList();

            return(AllResults);
        }
        public static Boolean UpdateCourseStatus(string CourseCode, string Session, Boolean Status)
        {
            ProjectDB    db           = new ProjectDB();
            CourseStatus CourseStatus = db.CourseStatus.Where(dp => dp.Course_code == CourseCode && dp.UnderSession == Session).FirstOrDefault();

            if (CourseStatus == null)
            {
                return(false);
            }

            CourseStatus.Status          = Status;
            db.Entry(CourseStatus).State = EntityState.Modified;
            db.SaveChanges();

            return(true);
        }
        public static Boolean IsMarkSubmitted(Course Course, string Session)
        {
            if (Course == null || Session == null)
            {
                return(false);
            }

            ProjectDB    db           = new ProjectDB();
            CourseStatus CourseStatus = db.CourseStatus.Where(cs => cs.Course_code == Course.Course_code && cs.UnderSession == Session).FirstOrDefault();

            if (CourseStatus == null || CourseStatus.Status == false)
            {
                return(false);
            }

            return(true);
        }
        public static List <Course> GetEnrollCourses(string Faculty, string Session, int Semester)
        {
            ProjectDB     db      = new ProjectDB();
            List <Course> Courses = new List <Course>();

            string        tableName = (Semester % 2 == 0) ? "JulEnrollment" : "JanEnrollment";
            SqlConnection myConn    = new SqlConnectionGenerator().FromFaculty(Faculty);
            string        SQLCmd    = "select column_name from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='" + tableName + "'";
            // * can be column_name, data_type, column_default, is_nullable
            SqlCommand myCommand = new SqlCommand(SQLCmd, myConn);

            try
            {
                myConn.Open();
                SqlDataReader oReader = myCommand.ExecuteReader();
                while (oReader.Read())
                {
                    string key = Convert.ToString(oReader.GetValue(0));
                    if (!(key.Equals("id") || key.Equals("Name") || key.Equals("StudentId") || key.Equals("RegNo") || key.Equals("Session") || key.Equals("Semester")))
                    {
                        Course Course = db.Courses.Where(c => c.Course_code == key).FirstOrDefault();
                        if (Course != null)
                        {
                            int ObSem = Course.GetSemesterFromCourse(Course.Course_code);
                            if (ObSem == Semester)
                            {
                                Courses.Add(Course);
                            }
                        }
                    }
                }
            }
            catch (System.Exception ex)
            {
            }
            finally
            {
                if (myConn.State == ConnectionState.Open)
                {
                    myConn.Close();
                }
            }

            return(Courses);
        }
Exemple #6
0
        public static List <GradeSheetDataModel> GetResultsGradeSheet(string Faculty, string Session, int Semester)
        {
            List <int> StudentList = new GetEnrollment(Faculty).GetCurrentStudentBySemester(Semester);

            ProjectDB     db         = new ProjectDB();
            List <Result> AllResults = new List <Result>();

            foreach (int StudentId in StudentList)
            {
                AllResults.Add(db.FinalResults.Where(fr => fr.StudentId == StudentId && fr.Semester == Semester).FirstOrDefault());
            }

            List <GradeSheetDataModel> gradeSheetData = new List <GradeSheetDataModel>();

            JavaScriptSerializer js = new JavaScriptSerializer();

            foreach (Result result in AllResults)
            {
                if (result != null)
                {
                    GradeSheetDataModel gradeSheetDataModel = new GradeSheetDataModel();
                    gradeSheetDataModel.Name          = result.Name;
                    gradeSheetDataModel.StudentId     = result.StudentId;
                    gradeSheetDataModel.RegNo         = result.RegNo;
                    gradeSheetDataModel.Faculty       = result.Faculty;
                    gradeSheetDataModel.Session       = result.Session;
                    gradeSheetDataModel.Semester      = result.Semester;
                    gradeSheetDataModel.Degree        = result.Degree;
                    gradeSheetDataModel.CourseResults = js.Deserialize <List <CourseResult> >(result.CourseResults);
                    gradeSheetDataModel.GPA           = result.GPA;
                    gradeSheetDataModel.PrevCGPA      = result.PrevCGPA;
                    gradeSheetDataModel.PrevCCH       = result.PrevCCH;
                    gradeSheetDataModel.CGPA          = result.CGPA;
                    gradeSheetDataModel.CCH           = result.CCH;
                    gradeSheetDataModel.Remarks       = result.Remarks.Replace("_", "-");

                    gradeSheetData.Add(gradeSheetDataModel);
                }
            }


            return(gradeSheetData);
        }
Exemple #7
0
        public static List <StudentInfo> GetStudentInfo(List <CurrentSemester> CurrentSemester)
        {
            if (CurrentSemester == null)
            {
                return(null);
            }

            List <StudentInfo> AllStudents = new List <StudentInfo>();

            ProjectDB db = new ProjectDB();

            foreach (CurrentSemester cs in CurrentSemester)
            {
                StudentInfo Student = db.StudentInfo.Where(si => si.StudentId == cs.StudentId).FirstOrDefault();
                if (Student != null)
                {
                    AllStudents.Add(Student);
                }
            }

            return(AllStudents);
        }
Exemple #8
0
        public static Boolean CalculateResult(List <StudentInfo> Students, int Semester, List <Course> Courses)
        {
            if (Students == null || Semester == 0 || Courses == null)
            {
                return(false);
            }

            ProjectDB            db = new ProjectDB();
            JavaScriptSerializer js = new JavaScriptSerializer();

            foreach (StudentInfo Student in Students)
            {
                Result Result = new Result();
                Result.Name      = Student.Name;
                Result.StudentId = Student.StudentId;
                Result.RegNo     = Student.Reg;
                Result.Faculty   = Student.Faculty;
                Result.Session   = Student.Session;
                Result.Semester  = Semester;
                Result.Degree    = "";

                float  TotalCHGP = 0, TotalCH = 0;
                string Remarks = "";
                List <CourseResult> CourseResults = new List <CourseResult>();
                foreach (Course Course in Courses)
                {
                    Marks mark = new Marks().GetMark(Course.UnderFaculty, Course.Course_code, Student.StudentId);
                    if (mark != null)
                    {
                        float TotalMark = 0;

                        if (mark.Mid != -1)
                        {
                            TotalMark += mark.Mid;
                        }
                        if (mark.Assignment != -1)
                        {
                            TotalMark += mark.Assignment;
                        }
                        if (mark.Attendence != -1)
                        {
                            TotalMark += mark.Attendence;
                        }
                        if (mark.Final != -1)
                        {
                            TotalMark += mark.Final;
                        }

                        CourseResult CourseResult = new CourseResult();
                        CourseResult.CourseCode  = Course.Course_code;
                        CourseResult.CourseTitle = Course.Course_title;
                        CourseResult.CreditHours = Course.Credit_hour;
                        CourseResult.TotalMark   = TotalMark;
                        CourseResult.LetterGrade = Marks.CalculateLetterGrade(TotalMark);
                        float GP = Marks.WrapToFloatPoint3(Marks.CalculateGP(TotalMark));
                        CourseResult.GP = GP;
                        Boolean IsPassed = Marks.IsPassed(TotalMark);
                        CourseResult.IsPassed = IsPassed;

                        CourseResults.Add(CourseResult);

                        if (IsPassed)
                        {
                            TotalCHGP += (Course.Credit_hour * GP);
                            TotalCH   += Course.Credit_hour;
                        }
                        else
                        {
                            Remarks += Course.Course_code + ",";
                        }
                    }
                }
                float GPA = 0;
                if (CourseResults != null)
                {
                    Result.CourseResults = js.Serialize(CourseResults);
                }
                if (TotalCHGP != 0 && TotalCH != 0)
                {
                    GPA = Marks.WrapToFloatPoint3(TotalCHGP / TotalCH);
                }
                Result.GPA = GPA;
                if (Remarks != "")
                {
                    Remarks = Remarks.Substring(0, Remarks.Length - 1);
                }
                if (Semester == 1)
                {
                    Result.PrevCGPA = 0;
                    Result.PrevCCH  = 0;
                    Result.CGPA     = GPA;
                    Result.CCH      = TotalCH;
                    Result.Remarks  = Remarks;
                    if (Remarks == "")
                    {
                        Result.IsMeritListed = true;
                    }
                    else
                    {
                        Result.IsMeritListed = false;
                    }
                }
                else
                {
                    int    PrevSem = Semester - 1;
                    Result PrevRes = db.FinalResults.Where(fr => fr.StudentId == Result.StudentId && fr.Semester == PrevSem).FirstOrDefault();
                    if (PrevRes != null)
                    {
                        Result.PrevCGPA = PrevRes.CGPA;
                        Result.PrevCCH  = PrevRes.CCH;
                        Result.CGPA     = Marks.WrapToFloatPoint3(Marks.CalculateCGPA(GPA, TotalCH, PrevRes.CGPA, PrevRes.CCH));
                        Result.CCH      = TotalCH + PrevRes.CCH;
                        if (PrevRes.Remarks == "")
                        {
                            Result.Remarks = Remarks;
                        }
                        else
                        {
                            string PrevRemarks = Course.CheckRemarks(Student.Faculty, Student.StudentId, PrevRes.Remarks);
                            if (Remarks != "")
                            {
                                if (PrevRemarks != "" || PrevRemarks != null)
                                {
                                    Result.Remarks = PrevRes.Remarks + "," + Remarks;
                                }
                                else
                                {
                                    Result.Remarks = Remarks;
                                }
                            }
                            else
                            {
                                Result.Remarks = PrevRes.Remarks;
                            }
                        }

                        if (!PrevRes.IsMeritListed)
                        {
                            Result.IsMeritListed = false;
                        }
                        else
                        {
                            if (Remarks == "")
                            {
                                Result.IsMeritListed = true;
                            }
                            else
                            {
                                Result.IsMeritListed = false;
                            }
                        }
                    }
                }

                Result OldRes = db.FinalResults.Where(fr => fr.StudentId == Result.StudentId && fr.Semester == Semester).FirstOrDefault();
                if (OldRes != null)
                {
                    db.FinalResults.Remove(OldRes);
                }
                db.FinalResults.Add(Result);
                db.SaveChanges();
            }

            return(true);
        }
Exemple #9
0
        public static Result GetResult(int StudentId, int Semester)
        {
            Result Result = new ProjectDB().FinalResults.Where(fr => fr.StudentId == StudentId && fr.Semester == Semester).FirstOrDefault();

            return(Result);
        }