public List <StaffTakeCare> showListStudentNeedTakeCare() { List <StaffTakeCare> list = new List <StaffTakeCare>(); StaffTakeCare st = null; SqlConnection con = DbConnect.GetConnection(); con.Open(); string sql = " SELECT TOP 10 Student.studentID,Account.staffName ,Rank.rankName " + "FROM Student" + " LEFT JOIN Account" + " ON Account.accountID = Student.accountID" + " LEFT JOIN Rank ON Student.studentID = Rank.studentID" + " Where takecareStatus = 0 AND caution = 0 ORDER BY rankName DESC"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { st = new StaffTakeCare(); st.studentID = dr["studentID"].ToString(); list.Add(st); } return(list); }
public List <StaffTakeCare> showListTable() { List <StaffTakeCare> list = new List <StaffTakeCare>(); StaffTakeCare st = null; SqlConnection con = DbConnect.GetConnection(); con.Open(); string sql = "select studentID from Student"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { st = new StaffTakeCare(); st.studentID = dr["studentID"].ToString(); list.Add(st); } return(list); }
public DataTable myStudentForHead() { DataTable dt = new DataTable(); dt.Columns.Add("Mssv"); dt.Columns.Add("Tên"); dt.Columns.Add("GPA"); dt.Columns.Add("Hành vi"); dt.Columns.Add("Điểm danh"); dt.Columns.Add("Môn nợ"); dt.Columns.Add("Xếp loại"); ServiceReference1.WebService1SoapClient ws = new ServiceReference1.WebService1SoapClient(); ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient(); StaffTakeCare stc = null; RankDAL rdl = new RankDAL(); SqlConnection con = DbConnect.GetConnection(); con.Open(); string sql = "SELECT TOP 10 Student.studentID,Student.studentName FROM Student LEFT JOIN Rank ON Student.studentID=Rank.studentID WHERE takecareStatus=0 AND caution=0 ORDER BY rankName DESC"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader dr = cmd.ExecuteReader(); this.compareForHead = new List <Compare>(); while (dr.Read()) { Compare xx = null; stc = new StaffTakeCare(); stc.studentID = dr["studentID"].ToString(); stc.studentName = dr["studentName"].ToString(); string currentSemester = "Spring2018"; //FreedomeF.ServiceReference1.Failcourse[] flist = ws.getFailcourse(r.studentID, ws.getCurrentSemester(r.studentID)); List <Curricurlum> listFail = new List <Curricurlum>(); string fail = fap.getFailCourse(stc.studentID); string pass = fap.getPassCourse(stc.studentID); List <Curricurlum> listPass = new List <Curricurlum>(); listPass = JsonConvert.DeserializeObject <List <Curricurlum> >(pass); listFail = JsonConvert.DeserializeObject <List <Curricurlum> >(fail); List <Gpa> gpaList = new List <Gpa>(); string t2 = fap.getGPA(stc.studentID, currentSemester); gpaList = JsonConvert.DeserializeObject <List <Gpa> >(t2); int totalCredit = 0; double avg = 0; for (int j = 0; j < gpaList.Count; j++) { double temp = 0; if (gpaList[j].averageMark != null) { temp = gpaList[j].credits * (double)gpaList[j].averageMark; } if (temp > 0) { totalCredit += gpaList[j].credits; avg += temp; } } double gpa = Math.Round(((double)avg) / ((double)totalCredit), 2); int failcourse = listFail.Count; double behavior = ws.getBehaviorMark(stc.studentID, currentSemester).behaviorMark; List <Curricurlum> attenList = new List <Curricurlum>(); string t = fap.getAttendanceMark(stc.studentID, currentSemester); attenList = JsonConvert.DeserializeObject <List <Curricurlum> >(t); int totalAbsent = 0; for (int i = 0; i < attenList.Count; i++) { totalAbsent += attenList[i].absentTotal; } double atten = Math.Round(((double)(attenList.Count * 30) - totalAbsent) / ((double)attenList.Count * 30), 2) * 10; var ds = dt.NewRow(); ds["Mssv"] = stc.studentID; ds["Tên"] = stc.studentName; ds["GPA"] = gpa; ds["Hành vi"] = behavior; ds["Điểm danh"] = atten; ds["Môn nợ"] = failcourse; Rank rk = new Rank(); rk = rdl.loadRank(stc.studentID, currentSemester); ds["Xếp loại"] = rk.rank; //} dt.Rows.Add(ds); // compare previous semerter List <Gpa> gpaList2 = new List <Gpa>(); string getGpa2 = fap.getGPA(stc.studentID, previousTerm(currentSemester)); gpaList2 = JsonConvert.DeserializeObject <List <Gpa> >(getGpa2); int totalCredit2 = 0; double avg2 = 0; for (int k = 0; k < gpaList2.Count; k++) { double temp2 = 0; if (gpaList2[k].averageMark != null) { temp2 = gpaList2[k].credits * (double)gpaList2[k].averageMark; } if (temp2 > 0) { totalCredit2 += gpaList2[k].credits; avg2 += temp2; } } double gpa2 = ((double)avg2) / ((double)totalCredit2); double behavior2 = ws.getBehaviorMark(stc.studentID.ToString(), previousTerm(currentSemester)).behaviorMark; List <Curricurlum> attenList2 = new List <Curricurlum>(); string attent2 = fap.getAttendanceMark(stc.studentID, previousTerm(currentSemester)); attenList2 = JsonConvert.DeserializeObject <List <Curricurlum> >(attent2); int totalAbsent2 = 0; for (int f = 0; f < attenList2.Count; f++) { totalAbsent2 += attenList2[f].absentTotal; } double atten2 = (((double)(attenList2.Count * 30) - totalAbsent2) / ((double)attenList2.Count * 30)) * 10; xx = new Compare(); xx.gpa = gpa; xx.gpa2 = gpa2; xx.behavior = behavior; xx.behavior2 = behavior2; xx.atten = atten; xx.atten2 = atten2; xx.failcourse = failcourse; xx.failcourse2 = failcourse; this.compareForHead.Add(xx); } return(dt); }
public DataTable todayReportForHead(DateTime date) { //DateTime today = DateTime.Today; DateTime today = DateTime.ParseExact("10/06/2018", "dd/MM/yyyy", CultureInfo.InvariantCulture); //Convert.ToDateTime("10/06/2018"); DataTable dt = new DataTable(); dt.Columns.Add("Mssv"); dt.Columns.Add("Tên"); dt.Columns.Add("Vắng mặt ngày " + "" + date.ToString("dd/MM")); dt.Columns.Add("Báo cáo vắng mặt tuần này"); dt.Columns.Add("Trạng thái"); dt.Columns.Add("Nhận xét"); dt.Columns.Add("Giảng viên"); dt.Columns.Add("Xếp loại"); ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient(); StaffTakeCare stc = null; SqlConnection con = DbConnect.GetConnection(); con.Open(); string sql = " SELECT TOP 10 Student.studentID ,Student.studentName,Rank.rankName FROM Student LEFT JOIN Rank ON Student.studentID=Rank.studentID WHERE takecareStatus=0 AND caution=0 ORDER BY rankName DESC"; SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader dr = cmd.ExecuteReader(); Rank r = null; while (dr.Read()) { r = new Rank(); stc = new StaffTakeCare(); stc.studentID = dr["studentID"].ToString(); stc.studentName = dr["studentName"].ToString(); r.rank = dr["rankName"].ToString(); List <StudentProfile> profile = new List <StudentProfile>(); string info = fap.GetStudentById(stc.studentID); profile = JsonConvert.DeserializeObject <List <StudentProfile> >(info); var ds = dt.NewRow(); ds["Mssv"] = stc.studentID; ds["Tên"] = stc.studentName; List <Report> dayRp = new List <Report>(); List <Report> weekRp = new List <Report>(); string day = fap.getInfoToday(stc.studentID, DateTime.ParseExact(date.ToString("dd/MM/yyyy"), "dd/MM/yyyy", null)); string week = fap.getWeeklyReport(stc.studentID, date.AddDays(-7), date); if (day.ToLower().Equals("data not found") && !week.ToLower().Equals("data not found")) { weekRp = JsonConvert.DeserializeObject <List <Report> >(week); string temp = ""; for (int k = 0; k < weekRp.Count; k++) { temp += weekRp[k].subjectCode.ToString() + " " + " Slot " + weekRp[k].slot.ToString() + " " + "Ngày " + weekRp[k].date.ToString("dd/MM") + "</br>"; } ds["Báo cáo vắng mặt tuần này"] = temp; ds["Trạng thái"] = profile[0].statusCode; ds["Xếp loại"] = r.rank; dt.Rows.Add(ds); continue; } else if (!day.ToLower().Equals("data not found") && week.ToLower().Equals("data not found")) { dayRp = JsonConvert.DeserializeObject <List <Report> >(day); for (int j = 0; j < dayRp.Count; j++) { ds["Vắng mặt ngày " + "" + date.ToString("dd/MM")] += " " + dayRp[j].subjectCode.ToString() + " Slot " + dayRp[j].slot.ToString() + "</br>"; ds["Nhận xét"] += dayRp[j].comment.ToString() + "<br/>"; ds["Giảng viên"] += " " + dayRp[j].lecturer + "</br>"; ds["Trạng thái"] = profile[0].statusCode; ds["Xếp loại"] = r.rank; } dt.Rows.Add(ds); continue; } else if (day.ToLower().Equals("data not found") && week.ToLower().Equals("data not found")) { ds["Trạng thái"] = profile[0].statusCode; ds["Xếp loại"] = r.rank; dt.Rows.Add(ds); continue; } dayRp = JsonConvert.DeserializeObject <List <Report> >(day); weekRp = JsonConvert.DeserializeObject <List <Report> >(week); for (int j = 0; j < dayRp.Count; j++) { ds["Vắng mặt ngày " + "" + date.ToString("dd/MM")] += " " + dayRp[j].subjectCode.ToString() + " Slot " + dayRp[j].slot.ToString() + "</br>"; ds["Nhận xét"] += dayRp[j].comment.ToString() + "<br/>"; ds["Giảng viên"] += " " + dayRp[j].lecturer + "</br>"; } for (int k = 0; k < weekRp.Count; k++) { ds["Báo cáo vắng mặt tuần này"] += weekRp[k].subjectCode.ToString() + " " + " Slot " + weekRp[k].slot.ToString() + " " + "Ngày " + weekRp[k].date.ToString("dd/MM") + "</br>"; } ds["Trạng thái"] = profile[0].statusCode; ds["Xếp loại"] = r.rank; dt.Rows.Add(ds); } return(dt); }