public void getColumn() { DepartmentService ds = new DepartmentService(); IList professionList = new ArrayList(); string ProfessionID = context.Request.Form.Get("ProfessionID"); string YearNo = context.Request.Form.Get("YearNo"); string LevelNo = context.Request.Form.Get("LevelNo"); if (!string.IsNullOrEmpty(ProfessionID)) { Profession profession = ds.getProfessionByID(ProfessionID); professionList.Add(profession); } PlanService ps = new PlanService(); object[] planObjArr = ps.searchPlan(professionList, YearNo, LevelNo, int.MaxValue, 1); if (planObjArr[1] != null) { IList<ExamPlan> examPlanList = (IList<ExamPlan>)planObjArr[1]; if (examPlanList == null) return; ExamPlan ep = examPlanList.ElementAt(0); ArrayList newArrayList = new ArrayList(); if (examPlanList.ElementAt(0).CouresSet == null) return; foreach (Coures c in examPlanList.ElementAt(0).CouresSet) { newArrayList.Add(c.Name); } newArrayList.Sort(); IList<Hashtable> columnList = new List<Hashtable>(); foreach (string s in newArrayList) { Hashtable ht = new Hashtable(); ht.Add("columnName",s); columnList.Add(ht); } String json = JsonConvert.SerializeObject(columnList); context.Response.Write(json); } }
private void searchExamResult() { DepartmentService ds = new DepartmentService(); IList professionList = new ArrayList(); string ProfessionID = context.Request.Form.Get("ProfessionID"); string YearNo = context.Request.Form.Get("YearNo"); string LevelNo = context.Request.Form.Get("LevelNo"); if (!string.IsNullOrEmpty(ProfessionID)) { Profession profession = ds.getProfessionByID(ProfessionID); professionList.Add(profession); } PlanService ps = new PlanService(); object[] planObjArr = ps.searchPlan(professionList, YearNo, LevelNo, int.MaxValue, 1); if (planObjArr[1] != null) { IList<ExamPlan> examPlanList = (IList<ExamPlan>)planObjArr[1]; if (examPlanList == null || examPlanList.Count == 0) return; ExamResultService ers = new ExamResultService(); IList<ExamPlan> planList = new List<ExamPlan>(); planList.Add(examPlanList[0]); object[] examResultObjArr = ers.searchExamResult(planList, int.MaxValue, 1); if (examResultObjArr[1] != null) { IList<ExamResult> examResultList = (IList<ExamResult>)examResultObjArr[1]; IList<Hashtable> examRsultMapList = new List<Hashtable>(); foreach (ExamResult er in examResultList) { Hashtable cht = new Hashtable(); cht.Add("Id", er.Id); cht.Add("StudentSN", er.StudentSN); cht.Add("StudentName", er.StudentName); cht.Add("ExamPlanName", er.ExamPlanName); if (er.CouresScoreMap != null) { ArrayList newArrayList = new ArrayList(); foreach (Coures c in planList.ElementAt(0).CouresSet) { newArrayList.Add(c.Name); } newArrayList.Sort(); foreach (string key in newArrayList) { if (er.CouresScoreMap.ContainsKey(key)) { cht.Add(key, er.CouresScoreMap[key]); } } } examRsultMapList.Add(cht); } Hashtable ht = new Hashtable(); ht.Add("total", examResultObjArr[0]); ht.Add("rows", examRsultMapList); String json = JsonConvert.SerializeObject(ht); context.Response.Write(json); } } }
private void searchPlan() { try { PlanService planService = new PlanService(); DepartmentService ds = new DepartmentService(); IList professionList = new ArrayList(); string ProfessionID = context.Request.Form.Get("ProfessionID"); string YearNo = context.Request.Form.Get("YearNo"); string LevelNo = context.Request.Form.Get("LevelNo"); if (!string.IsNullOrEmpty(ProfessionID)) { Profession profession = ds.getProfessionByID(ProfessionID); professionList.Add(profession); } int rows = Convert.ToInt32(context.Request.Form["rows"]); int page = Convert.ToInt32(context.Request.Form["page"]); object[] data = planService.searchPlan(professionList, YearNo, LevelNo, rows, page); Hashtable ht = new Hashtable(); ht.Add("total", data[0]); ht.Add("rows", data[1]); String json = JsonConvert.SerializeObject(ht); context.Response.Write(json); } catch (Exception e) { context.Response.Write("0"); } }
private void saveCoures() { try { string ProfessionID = context.Request.Form.Get("Profession"); string FacultyID = context.Request.Form.Get("Faculty"); DepartmentService ds = new DepartmentService(); Profession profession = ds.getProfessionByID(ProfessionID); Faculty faculty = ds.getFacultyByID(FacultyID); if (profession != null && faculty != null) { ISet<Coures> couresSet = new HashedSet<Coures>(); string[] couresArr = context.Request.Form.GetValues("Coures"); CouresService cs = new CouresService(); foreach (string c in couresArr) { Coures coures = cs.getCouresByID(c); if (coures != null) couresSet.Add(coures); } ExamPlan p = new ExamPlan(); setValue(p, context); p.Profession = profession; p.Faculty = faculty; p.CouresSet = couresSet; PlanService ps = new PlanService(); ps.save(p); context.Response.Write("1"); } } catch (Exception e) { context.Response.Write("0"); } }
private void initStudentResult() { try { string ExamPlanID = context.Request.Form.Get("ExamPlanID"); PlanService planService = new PlanService(); ExamPlan examPlan = planService.getExamPlanByID(ExamPlanID); IList<ExamPlan> examPlanList = new List<ExamPlan>(); examPlanList.Add(examPlan); ExamResultService ers = new ExamResultService(); object[] obj = ers.searchExamResult(examPlanList, int.MaxValue, 1); if (obj[1] != null) { IList<ExamResult> examResultList = (IList<ExamResult>)obj[1]; foreach (ExamResult er in examResultList) { ers.del(er); } } Student student = new Student(); IList<Profession> professionList = new List<Profession>(); professionList.Add(examPlan.Profession); student.ProfessionList = professionList; StudentService ss = new StudentService(); object[] studentObjArr = ss.getStudentList(student, int.MaxValue, 1); if (studentObjArr[1] != null) { IList<Student> studentList = (IList<Student>)studentObjArr[1]; foreach (Student s in studentList) { ExamResult examResult = new ExamResult(); examResult.ExamPlan = examPlan; examResult.Student = s; ers.save(examPlan); IDictionary<string,string> map = new Dictionary<string,string>(); foreach (Coures c in examPlan.CouresSet) { map.Add(c.Name, "0"); } examResult.CouresScoreMap = map; ers.save(examResult); } } context.Response.Write("1"); } catch (Exception e) { context.Response.Write("0"); } }
private void getPlanByID() { try { string ExamPlanID = context.Request.Form.Get("ExamPlanID"); PlanService planService = new PlanService(); ExamPlan examPlan = planService.getExamPlanByID(ExamPlanID); String json = JsonConvert.SerializeObject(examPlan); context.Response.Write(json); } catch (Exception e) { context.Response.Write("0"); } }
private void deleteExamPlan() { try { string ExamPlanID = context.Request.Form.Get("ExamPlanID"); PlanService planService = new PlanService(); ExamPlan examPlan = planService.getExamPlanByID(ExamPlanID); examPlan.CouresSet = null; planService.save(examPlan); planService.del(examPlan); context.Response.Write("1"); } catch (Exception e) { context.Response.Write("0"); } }