public DataTable curriculum(string studentID)
{
DataTable dt = new DataTable();
dt.Columns.Add("Mã Môn");
dt.Columns.Add("Tên Môn");
dt.Columns.Add("Kì");
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
List <Curricurlum> cur = new List <Curricurlum>();
string fapcur = fap.getCurriculum(studentID);
if (!fapcur.Equals("Data not found"))
{
cur = JsonConvert.DeserializeObject <List <Curricurlum> >(fapcur);
}
for (int j = 0; j < cur.Count; j++)
{
var ds = dt.NewRow();
ds["Mã Môn"] = cur[j].subjectCode.ToString();
ds["Tên Môn"] = cur[j].subjectName.ToString();
ds["Kì"] = cur[j].termNo.ToString();
dt.Rows.Add(ds);
}
//}
return(dt);
}
protected void btnReUpdate_Click(object sender, EventArgs e)
{
ServiceReference1.WebService1SoapClient ws = new ServiceReference1.WebService1SoapClient();
Business.ScsBO sbo = new Business.ScsBO();
List <Student> stFAP = new List <Student>();
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
string stf = fap.GetStudenK10JS();
stFAP = JsonConvert.DeserializeObject <List <Student> >(stf);
List <StaffTakeCare> listfromDB = sbo.showListTable();
List <String> listStudentIdDub = new List <String>();
Business.RankDAL rdal = new Business.RankDAL();
Business.StudentDAL stdl = new Business.StudentDAL();
//Entity.Rank r = null;
var tasks = new Task[stFAP.Count];
for (int i = 0; i < stFAP.Count; i++)
{
string rollNumber = stFAP[i].rollNumber;
tasks[i] = Task.Factory.StartNew(() =>
{
List <StudentProfile> stp = new List <StudentProfile>();
string inf = fap.GetStudentById(rollNumber);
stp = JsonConvert.DeserializeObject <List <StudentProfile> >(inf);
bool flag = false;
for (int j = 0; j < listfromDB.Count; j++)
{
if (rollNumber.ToString().Equals(listfromDB[j].studentID.ToString()))
{
flag = true;
break;
}
}
if (!flag)
{
stdl.insertStudentToTakeCare(rollNumber.ToString(), stp[0].fullName);
}
});
}
Task.WaitAll(tasks);
rdal.rankking();
stdl.filterStudent();
string check = "";
Response.Redirect("~/UI/distribution.aspx?check=" + check);
}
public List <OldListTakecare> getOldStudent()
{
List <Student> listStudentAPI = new List <Student>();
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
string stf = fap.GetStudenK10JS();
listStudentAPI = JsonConvert.DeserializeObject <List <Student> >(stf);
List <OldListTakecare> list = new List <OldListTakecare>();
List <OldListTakecare> list2 = new List <OldListTakecare>();
SqlConnection con = DbConnect.GetConnection();
string sql = " SELECT Student.studentID,Account.staffName,Rank.rankName "
+ " FROM Student"
+ " LEFT JOIN Rank"
+ " ON Rank.studentID = Student.studentID LEFT JOIN Account"
+ " ON Account.accountID = Student.accountID"
+ " Where takecareStatus = 0 AND caution=0 ";
SqlCommand cmd = new SqlCommand(sql, con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
OldListTakecare ol = new OldListTakecare();
ol.studentID = dr["studentID"].ToString();
ol.staffName = dr["staffName"].ToString();
list.Add(ol);
}
list2 = list;
for (int j = 0; j < listStudentAPI.Count; j++)
{
for (int i = 0; i < list2.Count; i++)
{
if (listStudentAPI[j].rollNumber.Equals(list[i].studentID))
{
list2.Remove(list[i]);
}
}
}
con.Close();
return(list2);
}
public DataTable getTimetable(string studentID)
{
DataTable dt = new DataTable();
dt.Columns.Add("Mã môn");
dt.Columns.Add("Lớp");
dt.Columns.Add("Ngày");
dt.Columns.Add("Trạng thái");
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
DateTime tm;
DateTime today = DateTime.ParseExact("01/06/2018", "dd/MM/yyyy", CultureInfo.InvariantCulture);// Convert.ToDateTime("01/06/2018");
for (int td = 0; td < 6; td++)
{
tm = today.AddDays(+td);
}
string t = fap.getTimeTable(studentID, today, today.AddDays(+7));
if (t.Equals("Data not found"))
{
return(dt);
}
List <Timetable> ttable = new List <Timetable>();
ttable = JsonConvert.DeserializeObject <List <Timetable> >(t);
for (int i = 0; i < ttable.Count; i++)
{
var ds = dt.NewRow();
ds["Mã môn"] = ttable[i].subjectCode.ToString();
ds["Lớp"] = ttable[i].groupName.ToString();
ds["Ngày"] = ttable[i].date.ToString("dd/MM/yy");
ds["Trạng thái"] = ttable[i].status.ToString();
dt.Rows.Add(ds);
}
return(dt);
}
//public List<Comment> getAccountIDComment(string studentID)
//{
// List<Comment> list = new List<Comment>();
// SqlConnection con = DbConnect.GetConnection();
// con.Open();
// string sql = "select accountID from Comment Where studentID=@studentID ";
// SqlCommand cmd = new SqlCommand(sql, con);
// cmd.Parameters.Add("studentID", SqlDbType.NVarChar);
// cmd.Parameters["studentID"].Value = studentID;
// SqlDataReader dr = cmd.ExecuteReader();
// Comment cm = null;
// while (dr.Read())
// {
// cm = new Comment();
// cm.accountID = (Int32)dr["accountID"];
// list.Add(cm);
// }
// con.Close();
// return list;
//}
//*********************************************************
public DataTable scheduleExam(string studentID)
{
DataTable dt = new DataTable();
dt.Columns.Add("Mssv");
dt.Columns.Add("Ngày");
dt.Columns.Add("Phòng");
dt.Columns.Add("Môn thi");
dt.Columns.Add("Giờ thi");
dt.Columns.Add("Note");
dt.Columns.Add("Kì thi");
dt.Columns.Add("Công bố điểm");
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
List <Schedule> Sche = new List <Schedule>();
string exam = fap.getscheduleExam(studentID, DateTime.ParseExact("01/04/2018", "dd/MM/yyyy", CultureInfo.InvariantCulture));
if (exam.Equals("Data not found"))
{
return(dt);
}
Sche = JsonConvert.DeserializeObject <List <Schedule> >(exam);
for (int i = 0; i < Sche.Count; i++)
{
var ds = dt.NewRow();
ds["Mssv"] = Sche[i].rollNumber;
ds["Ngày"] = Sche[i].date;
ds["Phòng"] = Sche[i].roomNo;
ds["Môn thi"] = Sche[i].realSubject;
ds["Giờ thi"] = Sche[i].giothi;
ds["Note"] = Sche[i].note;
ds["Kì thi"] = Sche[i].kythi;
ds["Công bố điểm"] = Sche[i].dateMark;
dt.Rows.Add(ds);
}
return(dt);
}
public List <GpaTerm> listGpa(string studentID)
{
GpaTerm gpt = new GpaTerm();
List <GpaTerm> listGpa = new List <GpaTerm>();
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
string currentSemester = "Spring2018";
List <Gpa> gpaList = new List <Gpa>();
string t2 = fap.getGPA(studentID, currentSemester);
if (!t2.Equals("Data not found"))
{
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 = ((double)avg) / ((double)totalCredit);
List <Gpa> gpaList2 = new List <Gpa>();
string getGpa2 = fap.getGPA(studentID, previousTerm(currentSemester));
if (!getGpa2.Equals("Data not found"))
{
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);
//gpt.gpa = gpa;
//gpt.gpa2 = gpa2;
//gpt.semester = currentSemester;
//gpt.semester2 = previousTerm(currentSemester);
//listGpa.Add(gpt);
listGpa.Add(new GpaTerm(gpa2, previousTerm(currentSemester)));
listGpa.Add(new GpaTerm(gpa, currentSemester));
return(listGpa);
}
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);
}
public void calRank(string studentID, Entity.Rate rt)
{
ServiceReference1.WebService1SoapClient ws = new ServiceReference1.WebService1SoapClient();
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
Entity.Rank r = new Entity.Rank();
r.studentID = studentID;
string currentSemester = "Spring2018";
string fail = fap.getFailCourse(r.studentID);
string pass = fap.getPassCourse(r.studentID);
List <Curricurlum> listPass = new List <Curricurlum>();
List <Curricurlum> listFail = new List <Curricurlum>();
if (!pass.Equals("Data not found"))
{
listPass = JsonConvert.DeserializeObject <List <Curricurlum> >(pass);
}
if (!fail.Equals("Data not found"))
{
listFail = JsonConvert.DeserializeObject <List <Curricurlum> >(fail);
}
List <Gpa> gpaList = new List <Gpa>();
string t2 = fap.getGPA(r.studentID, currentSemester);
if (!t2.Equals("Data not found"))
{
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 = ((double)avg) / ((double)totalCredit);
double failcourse;
if (listFail.Count != 0 && listPass.Count != 0)
{
failcourse = ((1 - ((double)listFail.Count) / ((double)listPass.Count + (double)listFail.Count))) * 10;
}
failcourse = 0;
double behavior = ws.getBehaviorMark(r.studentID, currentSemester).behaviorMark;
List <Curricurlum> attenList = new List <Curricurlum>();
string t = fap.getAttendanceMark(r.studentID, currentSemester);
if (!t.Equals("Data not found"))
{
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;
r.rank = Caculate(gpa, behavior, failcourse, atten, rt.markRate, rt.behRate, rt.failCout, rt.attentRate);
if (checkExistRank(r.studentID, currentSemester))
{
isInsertRank(r.studentID, r.rank, currentSemester);
}
else
{
isUpdateRank2(r.studentID, r.rank, currentSemester);
}
}
public Entity.Rank changeRankByCoefficient()
{
ServiceReference1.WebService1SoapClient ws = new ServiceReference1.WebService1SoapClient();
//FreedomeF.ServiceReference1.ListStudentID[] list = ws.getStudentID();
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
Entity.Rank r = null;
SqlConnection con = DbConnect.GetConnection();
con.Open();
string sql = "SELECT studentID FROM Student WHERE takecareStatus=0";
SqlCommand cmd = new SqlCommand(sql, con);
RankDAL rdl = new RankDAL();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
r = new Entity.Rank();
r.studentID = dr["studentID"].ToString();
string currentSemester = "Spring2018";
List <Curricurlum> listFail = new List <Curricurlum>();
string fail = fap.getFailCourse(r.studentID);
string pass = fap.getPassCourse(r.studentID);
List <Curricurlum> listPass = new List <Curricurlum>();
if (!pass.Equals("Data not found"))
{
listPass = JsonConvert.DeserializeObject <List <Curricurlum> >(pass);
}
if (!fail.Equals("Data not found"))
{
listFail = JsonConvert.DeserializeObject <List <Curricurlum> >(fail);
}
List <Gpa> gpaList = new List <Gpa>();
string t2 = fap.getGPA(r.studentID, currentSemester);
if (!t2.Equals("Data not found"))
{
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 = ((double)avg) / ((double)totalCredit);
double failcourse = ((1 - ((double)listFail.Count) / ((double)listPass.Count + (double)listFail.Count))) * 10;
double behavior = ws.getBehaviorMark(r.studentID, currentSemester).behaviorMark;
List <Curricurlum> attenList = new List <Curricurlum>();
string t = fap.getAttendanceMark(r.studentID, currentSemester);
if (!t.Equals("Data not found"))
{
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;
Entity.Rate rt = new Entity.Rate();
rt = getRate();
r.rank = Caculate(gpa, behavior, failcourse, atten, rt.markRate, rt.behRate, rt.failCout, rt.attentRate);
r = new Entity.Rank();
r.studymark = gpa;
r.failcourseNumb = failcourse;
r.behaviorMark = behavior;
r.attendance = atten;
r.rank = Caculate(gpa, behavior, failcourse, atten, rt.markRate, rt.behRate, rt.failCout, rt.attentRate);
isUpdateRank2(r.studentID.ToString(), r.rank, currentSemester);
}
return(r);
}
public void Page_Load(object sender, EventArgs e)
{
Label10.Text = "";
lbNoitice.Text = "";
Label1.Text = "";
Label11.Text = "";
lbResult.Text = "";
upLabel.Text = "";
try
{
if ((Session["account"]) == null || (Session["role"]) == null || (Session["accountID"]) == null)
{
Response.Redirect("~/UI/Login.aspx");
}
string selected = Request.QueryString["studentID"];
string checkrole = (string)(Session["role"]);
string account = (string)(Session["account"]);
int staffID = (int)(Session["accountID"]);
lbUserName.Text = account;
if (checkrole == "HeadStaff")
{
divide.Visible = true;
logCare.Visible = true;
control.Visible = true;
btnUpdateStaff.Visible = true;
lbGuide.Visible = true;
drpStaff.Visible = true;
}
else
{
divide.Visible = false;
logCare.Visible = false;
control.Visible = false;
btnUpdateStaff.Visible = false;
lbGuide.Visible = false;
drpStaff.Visible = false;
}
Business.ScsBO sbo = new Business.ScsBO();
//int staffID = (int)(Session["accountID"]);
//ServiceReference1.WebService1SoapClient ws = new ServiceReference1.WebService1SoapClient();
//ServiceReference1.Student s = ws.getStudentInf(selected);
ServiceReference2.SAPISoapClient fap = new ServiceReference2.SAPISoapClient();
List <StudentProfile> stp = new List <StudentProfile>();
string inf = fap.GetStudentById(selected);
stp = JsonConvert.DeserializeObject <List <StudentProfile> >(inf);
decimal t = fap.CheckBlance(selected);
stImage.ImageUrl = "data:image/png;base64," + Convert.ToBase64String(fap.RetriveImage(selected));
currrentTerm.Text = stp[0].currentTermNo;
finance.Text = t.ToString("00.##" + "VND");
dob.Text = stp[0].dateOfBirth.ToString("dd/MM/yyyy");
addr.Text = stp[0].address;
name.Text = stp[0].fullName;
rollnumb.Text = stp[0].rollNumber;
phonenumb.Text = stp[0].phone;
mail.Text = stp[0].email;
curr.Text = stp[0].batch;
member.Text = stp[0].membercode;
ktx.Text = stp[0].termPaid;
dateofissue.Text = stp[0].dateOfIsue.ToString("dd/MM/yyyy");
major.Text = stp[0].major;
mode.Text = stp[0].chuuyenNganh;
status.Text = stp[0].statusCode;
limit7year.Text = stp[0].HanBayNam;
dropout.Text = stp[0].QD_ThoiHoc;
changeCampus.Text = stp[0].QD_BaoLuu_Exchange;
changeMajor.Text = stp[0].qd_chuyennganh;
getDiscipline.Text = stp[0].qD_kyluat;
gruadation.Text = stp[0].qD_Tn;
svcq.Text = stp[0].QD_SV_ChinhQuy;
rejoin.Text = stp[0].qD_rejoin;
contact.Text = stp[0].parentPhone;
parent.Text = stp[0].parentName;
if (!Page.IsPostBack)
{
string currentSemester = "Spring2018";
RankDAL rdal = new RankDAL();
//Comment cm = sbo.getComment(selected);
StatusCheck stk = sbo.loadTickCheckProfile(selected);
Rank r = rdal.loadRank(selected, currentSemester);
Student st = sbo.loadTakecareStaff(selected);
if (!string.IsNullOrEmpty(st.StaffName))
{
drpStaff.SelectedValue = st.StaffName;
}
else
{
Label24.Text = "Chưa có người chăm sóc , vui lòng chọn NV";
}
//TextArea1.Value = cm.content+" bởi "+cm.staffName;
drpChangeRank.SelectedValue = r.rank;
cbAttent.Checked = stk.attention;
}
Series series = Chart1.Series["Series1"];
List <GpaTerm> list = sbo.listGpa(selected);
Chart1.ChartAreas[0].AxisY.Title = "Điểm trung bình (GPA)";
for (int i = 0; i < list.Count; i++)
{
series.Points.AddXY(list[i].semester.ToString(), Math.Round(list[i].gpa, 2));
series.ToolTip = " #VALX #VALY";
}
List <BehaviorTerm> beList = sbo.beList(selected);
Series series2 = Chart2.Series["Series2"];
Chart2.ChartAreas[0].AxisY.Title = "Điểm hành vi (Behavior)";
for (int b = 0; b < beList.Count; b++)
{
series2.Points.AddXY(beList[b].semester.ToString(), Math.Round(beList[b].behavior, 2));
series2.ToolTip = " #VALX #VALY";
}
List <Curricurlum> listFail = new List <Curricurlum>();
string failcourse = fap.getFailCourse(selected);
if (!failcourse.Equals("Data not found"))
{
listFail = JsonConvert.DeserializeObject <List <Curricurlum> >(failcourse);
}
for (int f = 0; f < listFail.Count; f++)
{
pnStudy.Controls.Add(new LiteralControl(listFail[f].subjectCode + "</br>"));
}
this.lbFailnumb.Text = listFail.Count.ToString();
//**********************
//string currentSemester = "Spring2018";
ServiceReference1.WebService1SoapClient ws = new ServiceReference1.WebService1SoapClient();
ServiceReference1.ArrayOfGetTeacherComment flist = ws.getCommentBehavior(selected);
for (int be = 0; be < flist.Count; be++)
{
Panel3.Controls.Add(new LiteralControl(flist[be].contentComment + " " + flist[be].teacherID + "</br>"));
}
//*****************
DataTable dt = sbo.curriculum(selected);
//Building an HTML string.
StringBuilder html = new StringBuilder();
//Table start.
html.Append("<table id='curi' class='table table-hover'>");
html.Append("<thead>");
//Building the Header row.
html.Append("<tr class='info'>");
foreach (DataColumn column in dt.Columns)
{
html.Append("<th>");
html.Append(column.ColumnName);
html.Append("</th>");
}
html.Append("</tr>");
html.Append("</thead>");
html.Append("<tbody>");
//Building the Data rows.
foreach (DataRow row in dt.Rows)
{
html.Append("<tr>");
foreach (DataColumn column in dt.Columns)
{
html.Append("<td>");
html.Append(row[column.ColumnName]);
html.Append("</td>");
}
html.Append("</tr>");
}
//Table end.
html.Append("</table>");
html.Append("</tbody>");
//Append the HTML string to Placeholder.
Panel1.Controls.Add(new Literal {
Text = html.ToString()
});
//***************************************
DataTable dt2 = sbo.getTimetable(selected);
//Building an HTML string.
StringBuilder html2 = new StringBuilder();
//Table start.
html2.Append("<table id='time' class='table table-hover'>");
html2.Append("<thead>");
//Building the Header row.
html2.Append("<tr class='info'>");
foreach (DataColumn column2 in dt2.Columns)
{
html2.Append("<th>");
html2.Append(column2.ColumnName);
html2.Append("</th>");
}
html2.Append("</tr>");
html2.Append("</thead>");
html2.Append("<tbody>");
//Building the Data rows.
foreach (DataRow row2 in dt2.Rows)
{
html2.Append("<tr>");
foreach (DataColumn column2 in dt2.Columns)
{
html2.Append("<td>");
html2.Append(row2[column2.ColumnName]);
html2.Append("</td>");
}
html2.Append("</tr>");
}
//Table end.
html2.Append("</table>");
html2.Append("</tbody>");
//Append the HTML string to Placeholder.
scheduleStudy.Controls.Add(new Literal {
Text = html2.ToString()
});
//********************************************************
DataTable dt3 = sbo.scheduleExam(selected);
//Building an HTML string.
StringBuilder html3 = new StringBuilder();
//Table start.
html3.Append("<table id='exam' class='table table-hover'>");
html3.Append("<thead>");
//Building the Header row.
html3.Append("<tr class='info'>");
foreach (DataColumn column3 in dt3.Columns)
{
html3.Append("<th>");
html3.Append(column3.ColumnName);
html3.Append("</th>");
}
html3.Append("</tr>");
html3.Append("</thead>");
html3.Append("<tbody>");
//Building the Data rows.
foreach (DataRow row3 in dt3.Rows)
{
html3.Append("<tr>");
foreach (DataColumn column3 in dt3.Columns)
{
html3.Append("<td>");
html3.Append(row3[column3.ColumnName]);
html3.Append("</td>");
}
html3.Append("</tr>");
}
//Table end.
html3.Append("</table>");
html3.Append("</tbody>");
//Append the HTML string to Placeholder.
scheduleExam.Controls.Add(new Literal {
Text = html3.ToString()
});
//grOtherComment.DataBind();
}
catch (Exception ee)
{
Response.Redirect("~/UI/Error.aspx");
}
}
