public List <ReportCardCBSEEntity_Hashmi> GetReportCardCBSE_Hashmi(int studentId)
{
DBSite site = new DBSite();
List <ReportCardCBSEEntity_Hashmi> ReportCardList = new List <ReportCardCBSEEntity_Hashmi>();
string qry = GetCBSEQry_Hashmi(studentId
, "Scholastic"
, "Unit Test 1"
, "Unit Test 2"
, "SA 1"
, "SA 2"
, "SEA 1"
, "SEA 2"
, "Half Yearly"
, "Annual"
, "Term 1"
, "Term 2"
);
DataTable dt = site.ExecuteSelect(qry);
ReportCardCBSEEntity_Hashmi reportCard;
foreach (DataRow dr in dt.Rows)
{
reportCard = new ReportCardCBSEEntity_Hashmi();
reportCard.StudentMasterId = studentId;
reportCard.StudentName = util.CheckNull(dr["StudentName"]);
reportCard.Subject = util.CheckNull(dr["SubjectName"]);
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.DOB = util.CheckNull(dr["dob"]);
reportCard.UnitTest1 = util.CheckNull(dr["PerTest1"]);
reportCard.UnitTest1MaxMarks = util.CheckNull(dr["UnitTest1MaxMarks"]);
reportCard.SA1 = util.CheckNull(dr["NoteBook1"]);
reportCard.SA1MaxMarks = util.CheckNull(dr["SA1MaxMarks"]);
reportCard.UnitTest2 = util.CheckNull(dr["PerTest2"]);
reportCard.UnitTest2MaxMarks = util.CheckNull(dr["UnitTest2MaxMarks"]);
reportCard.SA2 = util.CheckNull(dr["NoteBook2"]);
reportCard.SA2MaxMarks = util.CheckNull(dr["SA2MaxMarks"]);
ReportCardList.Add(reportCard);
}
return(ReportCardList);
}
public List <ReportCardCBSEEntity_Hashmi> GetReportCardCBSE_Remarks_Hashmi(int studentId)
{
DBSite site = new DBSite();
List <ReportCardCBSEEntity_Hashmi> ReportCardList = new List <ReportCardCBSEEntity_Hashmi>();
//DataTable dt = site.ExecuteSelect(GetCBSEQry(studentId, "CoScholastic"));
DataTable dt = site.ExecuteSelect(GetCBSEQry_Hashmi(studentId
, "Remarks"
, "Unit Test 1"
, "Unit Test 2"
, "SA 1"
, "SA 2"
, "SEA 1"
, "SEA 2"
, "Half Yearly"
, "Annual"
, "Term 1"
, "Term 2"
));
ReportCardCBSEEntity_Hashmi reportCard;
foreach (DataRow dr in dt.Rows)
{
reportCard = new ReportCardCBSEEntity_Hashmi();
reportCard.StudentMasterId = studentId;
reportCard.StudentName = util.CheckNull(dr["StudentName"]);
reportCard.Subject = util.CheckNull(dr["SubjectName"]);
reportCard.SA1 = util.CheckNull(dr["NoteBook1"]);
reportCard.SA2 = util.CheckNull(dr["NoteBook2"]);
ReportCardList.Add(reportCard);
}
return(ReportCardList);
}
