示例#1
0
        public List <ReportCardCBSEEntity> GetReportCardCBSEOakWod_Remarks(int studentId)
        {
            DBSite site = new DBSite();
            List <ReportCardCBSEEntity> ReportCardList = new List <ReportCardCBSEEntity>();

            //DataTable dt = site.ExecuteSelect(GetCBSEQry(studentId, "Discipline"));
            DataTable dt = site.ExecuteSelect(GetCBSEQry_OakWood(studentId
                                                                 , "Remarks"
                                                                 , "Unit Test 1"
                                                                 , "Unit Test 2"
                                                                 , "Note Book 1"
                                                                 , "Note Book 2"
                                                                 , "SEA 1"
                                                                 , "SEA 2"
                                                                 , "Half Yearly"
                                                                 , "Annual"
                                                                 , "Term I"
                                                                 , "Term II"
                                                                 ));
            ReportCardCBSEEntity reportCard;

            foreach (DataRow dr in dt.Rows)
            {
                reportCard = new ReportCardCBSEEntity();

                reportCard.StudentMasterId = studentId;
                reportCard.StudentName     = util.CheckNull(dr["StudentName"]);
                reportCard.Subject         = util.CheckNull(dr["SubjectName"]);
                reportCard.HalfYearly      = util.CheckNull(dr["HalfYearly"]);
                reportCard.Yearly          = util.CheckNull(dr["Yearly"]);

                ReportCardList.Add(reportCard);
            }
            return(ReportCardList);
        }
示例#2
0
        public List <ReportCardCBSEEntity> GetReportCardCBSE_Junior(int studentId)
        {
            DBSite site = new DBSite();
            List <ReportCardCBSEEntity> ReportCardList = new List <ReportCardCBSEEntity>();

            string qry = GetCBSEQry_OakWood(studentId
                                            , "Scholastic"
                                            , "UNIT TEST 1"
                                            , "UNIT TEST 1"
                                            , "UNIT TEST 2"
                                            , "UNIT TEST 2"
                                            , "SEA 1"
                                            , "SEA 2"
                                            , "Half Yearly"
                                            , "Annual"
                                            , "Term I"
                                            , "Term II"
                                            );


            DataTable            dt = site.ExecuteSelect(qry);
            ReportCardCBSEEntity reportCard;

            foreach (DataRow dr in dt.Rows)
            {
                reportCard = new ReportCardCBSEEntity();
                //777
                reportCard.StudentMasterId = studentId;
                reportCard.StudentName     = util.CheckNull(dr["StudentName"]);
                reportCard.DOB             = util.CheckNull(dr["dob"]);
                reportCard.Subject         = util.CheckNull(dr["SubjectName"]);
                reportCard.PerTest1        = util.CheckNull(dr["PerTest1"]);
                reportCard.NoteBook1       = util.CheckNull(dr["NoteBook1"]);
                reportCard.SEA1            = util.CheckNull(dr["SEA1"]);
                reportCard.HalfYearly      = util.CheckNull(dr["HalfYearly"]);
                reportCard.ClassName       = util.CheckNull(dr["ClassName"]);
                reportCard.SectionName     = util.CheckNull(dr["SectionName"]);
                reportCard.MotherName      = util.CheckNull(dr["MotherName"]);
                reportCard.FatherName      = util.CheckNull(dr["FatherName"]);
                reportCard.PerTest2        = util.CheckNull(dr["PerTest2"]);
                reportCard.NoteBook2       = util.CheckNull(dr["NoteBook2"]);
                reportCard.SEA2            = util.CheckNull(dr["SEA2"]);
                reportCard.Yearly          = util.CheckNull(dr["Yearly"]);



                ReportCardList.Add(reportCard);
            }
            return(ReportCardList);
        }