private void UpdateClassProfile() { SessionCl = StartYearCl.ToString() + "-" + EndYearCl; SelClass = SchoolClass[SchoolClassIndex]; SchoolProfileDb db = new SchoolProfileDb(); var tpl = db.GetProfile(StartYearCl, EndYearCl, SchoolClass[SchoolClassIndex]); CountCls = tpl.Item1; CountClA = tpl.Item2; CountClB = tpl.Item3; CountClC = tpl.Item4; CountClD = tpl.Item5; CountClE = tpl.Item6; CountClNullSec = tpl.Item7; CountClMale = tpl.Item8; CountClFemale = tpl.Item9; CountClGenNull = tpl.Item10; CountClGen = tpl.Item11; CountClSC = tpl.Item12; CountClST = tpl.Item13; CountClOBC = tpl.Item14; CountClOBC_A = tpl.Item15; CountClOBC_B = tpl.Item16; CountClSocCatNull = tpl.Item17; CountClApl = tpl.Item18; CountClBpl = tpl.Item19; }
private void UpdateStreamProfile() { SessionStream = StartYearStrm.ToString() + "-" + EndYearStrm.ToString(); SelClassStream = SchoolClassStrm[SchoolClassStrmIndex]; if (StartYearStrm < 2017 || EndYearStrm < 2017 || SchoolClassStrmIndex == -1) { CountArts = CountScience = 0; CountArb = CountEco = CountEdu = CountGeo = CountHis = CountPhi = CountPhi = CountPol = CountSoc = 0; CountPhy = CountChm = CountMth = CountBio = 0; } else { SchoolProfileDb db = new SchoolProfileDb(); var tpl = db.GetProfileOfStream(StartYearStrm, EndYearStrm, SchoolClassStrm[SchoolClassStrmIndex]); SelClassStream = SchoolClassStrm[SchoolClassStrmIndex]; CountClsStream = tpl.Item1; CountArts = tpl.Item2; CountScience = tpl.Item3; CountStreamNull = tpl.Item4; CountArb = tpl.Item5; CountEco = tpl.Item6; CountEdu = tpl.Item7; CountGeo = tpl.Item8; CountHis = tpl.Item9; CountPhi = tpl.Item10; CountPol = tpl.Item11; CountSoc = tpl.Item12; CountPhy = tpl.Item13; CountChm = tpl.Item14; CountMth = tpl.Item15; CountBio = tpl.Item16; } }
private void UpdateSchoolProfile() { SessionSch = StartYear.ToString() + "-" + EndYear.ToString(); SchoolProfileDb db = new SchoolProfileDb(); var tpl = db.GetProfile(StartYear, EndYear); GrandTotal = tpl.Item1; Count5 = tpl.Item2; Count6 = tpl.Item3; Count7 = tpl.Item4; Count8 = tpl.Item5; Count9 = tpl.Item6; Count10 = tpl.Item7; Count11 = tpl.Item8; Count12 = tpl.Item9; CountMale = tpl.Item10; CountFemale = tpl.Item11; CountGenNull = tpl.Item12; CountGen = tpl.Item13; CountSC = tpl.Item14; CountST = tpl.Item15; CountOBC = tpl.Item16; CountOBC_A = tpl.Item17; CountOBC_B = tpl.Item18; CountSocCatNull = tpl.Item19; CountApl = tpl.Item20; CountBpl = tpl.Item21; }