/* * Lây thông tin ca thi từ sql server */ public TestExamInfo GetTestInfo(int casetestid) { try { conn.Open(); SqlCommand cmd = new SqlCommand("GET_TEST_EXAMS", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@INT_EXAM_ID", SqlDbType.Int); cmd.Parameters["@INT_EXAM_ID"].Value = casetestid; SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { string x = reader[1].ToString(); x = x.ToString(); var tei = new TestExamInfo( Convert.ToInt32(reader[0]), Convert.ToDateTime(reader[1]), Convert.ToInt32(reader[2]), Convert.ToInt32(reader[3]), Convert.ToInt32(reader[4]), (reader[5]).ToString(), reader[6].ToString() ); return(tei); } } catch (Exception ex) { return(null); } return(null); }
public IActionResult GetAllStudentInTestExam(string id) { TestExamInfo tei = tep.GetTestInfo(Convert.ToInt32(id)); tep.conn.Close(); List <Students> lsts = new List <Students>(); string out_mess = ""; lsts = tep.GetALlStudentOfTestExam(Convert.ToInt32(id), out out_mess); ViewBag.Message = out_mess; ViewData["ComputerCount"] = tei.ComputerCount; ViewData["CoumputerNumber"] = tei.ComputerNumber; ViewData["Date"] = tei.ExamDate.ToString("dd-MM-yyyy"); ViewData["SubjectName"] = tei.SubjectName; var order = "7h-9h"; var hour = tei.RoomOrder; if (hour == 1) { order = "7h-9h"; } if (hour == 2) { order = "9h-11h"; } if (hour == 3) { order = "11h-13h"; } if (hour == 4) { order = "13h-15h"; } if (hour == 5) { order = "15h-17h"; } if (hour == 6) { order = "17h-19h"; } ViewData["ExamOrder"] = order; ViewData["ClassOrder"] = tei.RoomOrder; ViewData["RoomLocation"] = tei.RoomLocation; return(View("StundetTestExam", lsts)); }