private void setGrid() { vReportExamsRepository vr = new vReportExamsRepository(); gvClasses.DataSource = vr.topClassesByGradeID(id.ToInt()); gvClasses.DataBind(); }
private void setGrid() { vReportExamsRepository v = new vReportExamsRepository(); gvStudents.DataSource = v.getRizNomaratOfstudentOfLessonGroup(stuID, lgid); gvStudents.DataBind(); foreach (GridViewRow row in gvStudents.Rows) { switch (row.Cells[4].Text) { case "0": row.Cells[4].Text = "کتبی"; break; case "1": row.Cells[4].Text = "شفاهی"; break; } string s = row.Cells[2].Text; s = s.Substring(0, 4) + '/' + s.Substring(4, 2) + '/' + s.Substring(6, 2); row.Cells[2].Text = s; } }
private void setGridView() { vReportExamsRepository rep = new vReportExamsRepository(); gvStudents.DataSource = rep.fieldsAverage(fid, gid); gvStudents.DataBind(); }
private void setGridView() { vReportExamsRepository vre = new vReportExamsRepository(); gvStudents.DataSource = vre.topStudentsAverageByLGID(id.ToInt()); gvStudents.DataBind(); }
private void setGridView() { string id = Request.QueryString["LGID"]; vReportExamsRepository vre = new vReportExamsRepository(); gvStudents.DataSource = vre.topStudentsAverageByLGID(id.ToInt()); gvStudents.DataBind(); }
private void setLabels() { GradesRepository gr = new GradesRepository(); lblMaghta.InnerText = gr.getGradeTitleByID(id.ToInt()); StudentRepository s = new StudentRepository(); lblStudentCount.InnerText = s.studentCountbyGradeID(id.ToInt()).ToString(); vReportExamsRepository vre = new vReportExamsRepository(); lblmianginkatbi.InnerText = Convert.ToDouble(vre.getAverageGrade(id.ToInt(), 0)).ToString(); lblmianginshafahi.InnerText = Convert.ToDouble(vre.getAverageGrade(id.ToInt(), 1)).ToString(); }
private void setLabels() { vReportExamsRepository r = new vReportExamsRepository(); lblMiabginKatbi.InnerText = r.getStudentAverageOfLessonGorup(stuID, lgid, 0).ToString(); lblMianginShafahi.InnerText = r.getStudentAverageOfLessonGorup(stuID, lgid, 1).ToString(); TamrinRepository t = new TamrinRepository(); lblTamrinCount.InnerText = t.countTamrinByid(lgid).ToString(); vJavabeTamrinRepository v = new vJavabeTamrinRepository(); lblAnswer.InnerText = v.countJavabeTamrinByStuCode_Lgid(stuID, lgid).ToString(); }
public void setLabel() { GradesRepository gr = new GradesRepository(); lblMaghta.InnerText = gr.getGradeTitleByID(gid); FieldsRepository fr = new FieldsRepository(); lblReshte.InnerText = fr.getFieldTitleByID(fid); StudentRepository sr = new StudentRepository(); lblStudentsCount.InnerText = sr.countStudentsByFieldID_GradeID(fid, gid).ToString(); vReportExamsRepository rep = new vReportExamsRepository(); lblmianginkatbi.InnerText = rep.getAverageOfFieldOfgrade(fid, gid, 0).ToString(); lblmianginshafahi.InnerText = rep.getAverageOfFieldOfgrade(fid, gid, 1).ToString(); }
public void setLabel() { vReportExamsRepository v = new vReportExamsRepository(); string id = Request.QueryString["LGID"]; lblmianginkatbi.InnerText = Convert.ToDouble(v.getAverageLessonGroup(id.ToInt(), 0)).ToString(); lblmianginshafahi.InnerText = Convert.ToDouble(v.getAverageLessonGroup(id.ToInt(), 1)).ToString(); lblKatbiExamCount.InnerText = v.ExamCountByLGID(id.ToInt(), 0).ToString(); lblShafahiExamCount.InnerText = v.ExamCountByLGID(id.ToInt(), 1).ToString(); TamrinRepository tr = new TamrinRepository(); int cnt = tr.countTamrinByid(id.ToInt()); lbltamrincount.InnerText = cnt.ToString(); vJavabeTamrinRepository jt = new vJavabeTamrinRepository(); OzviatRepository or = new OzviatRepository(); int stucnt = or.countStudentsOfLessonGroupByid(id.ToInt()); int tjt = jt.TedadejavabeTamrin(id.ToInt()); if (cnt == 0 || stucnt == 0) { lblanswer.InnerText = "0"; } else { lblanswer.InnerText = (((Convert.ToDouble(tjt) / (stucnt * cnt) * 100))).ToString(); } vLessonGroupRepository lg = new vLessonGroupRepository(); List <string> St = or.FindStudentCodeByLGID(id.ToInt()); lblStuCount.InnerText = St.Count.ToString(); vLessonGroup lgg = lg.FindByLGID(id.ToInt()); lblTeacharName.InnerText = lgg.FirstName + " " + lgg.LastName; lblClassNum.InnerText = lgg.Class; lblLessonTitle.InnerText = lgg.LessonTitle; SessionRepository sr = new SessionRepository(); lblSessionCount.InnerText = sr.countSessionsByLGID(id.ToInt()).ToString(); }
protected void Page_Load(object sender, EventArgs e) { vReportExamsRepository rep = new vReportExamsRepository(); vLessonGroupRepository lgr = new vLessonGroupRepository(); List <List <decimal?> > datalist = new List <List <decimal?> >(); List <decimal?> ll; List <string> studentsList = new List <string>(); List <string> studentsNames = new List <string>(); // string year = lgr.GetLastestYear(); studentsList = lgr.GetStudentCodeOfLessonGroup(lgid); studentsNames = lgr.GetStudentNameOfLessonGroup(lgid); int studentCount = studentsList.Count; List <string> s = new List <string>() { "مهر", "آبان", "آذر", "دی", "بهمن", "اسفند", "فروردین", "اردیبهشت", "خرداد" }; //.ConvertAll(new Converter<decimal?, decimal>()) for (int i = 0; i < studentCount; i++) { ll = new List <decimal?>(); ll = rep.GetAvgOfStudentPerMonth(studentsList[i]); datalist.Add(ll); } List <decimal?> l; List <List <LineSeriesData> > liststudentdata = new List <List <LineSeriesData> >(); List <LineSeriesData> studentData; for (int i = 0; i < datalist.Count; i++) { l = new List <decimal?>(); l = datalist[i]; studentData = new List <LineSeriesData>(); l.ForEach(p => studentData.Add(new LineSeriesData { Y = (double)p })); liststudentdata.Add(studentData); } LineSeries ss; List <Series> ser = new List <Series>(); for (int i = 0; i < datalist.Count; i++) { ss = new LineSeries(); ss.Name = studentsNames[i]; ss.Data = liststudentdata[i]; ser.Add(ss); } Highcharts higcharts = new Highcharts { Title = new Title { Text = "نمودار پیشرفت", X = -20 }, Subtitle = new Subtitle { Text = "میانگین نمرات ماهانه کلاس", X = -20 }, XAxis = new List <XAxis> { new XAxis { Categories = s } }, YAxis = new List <YAxis> { new YAxis { Title = new YAxisTitle { Text = "نمره" }, PlotLines = new List <YAxisPlotLines> { new YAxisPlotLines { Value = 0, Width = 1, Color = "#808080" } } } }, Tooltip = new Tooltip { ValueSuffix = "" }, Legend = new Legend { Layout = LegendLayout.Vertical, Align = LegendAlign.Right, VerticalAlign = LegendVerticalAlign.Middle, BorderWidth = 0 }, Series = ser }; //Title t = new Title(); //t.Text = "Monthly Average Temperature"; //t.X = -20; //higcharts.Title = t; //Subtitle sub = new Subtitle(); //sub.Text = "Source: WorldClimate.com"; //sub.X = -20; HighsoftNamespace Highsoft = new HighsoftNamespace(); //string result = Highsoft.Highcharts(higcharts, "chart").ToHtmlString(); //For version 5.0.6326 or older string result = Highsoft.GetHighcharts(higcharts, "chart").ToHtmlString(); //For version 5.0.6327 or newer Response.Write(result); }