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);
}
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);
}