public bool GetAnotherInforOfStudentPrepareToPrint(InformationOfStudentResultPrepareForPrint input, string studentID) { bool success = Connect(); if (!success) { return(false); } try { using (SqlCommand cmd = new SqlCommand()) { string strQuery = "SELECT Surname,Firstname,CLASS.ClassID,ConductSE01,ConductSE02,YearConduct,AverageScore " + "FROM STUDENT INNER JOIN LEARNRESULT ON STUDENT.StudentID = LEARNRESULT.StudentID " + "INNER JOIN CLASS ON CLASS.ClassID = STUDENT.ClassID " + "WHERE STUDENT.StudentID = @studentID"; cmd.Parameters.AddWithValue("studentID", studentID); cmd.CommandText = strQuery; cmd.CommandType = CommandType.Text; cmd.Connection = connection; using (SqlDataReader reader = cmd.ExecuteReader()) if (reader.Read()) { input.nameOfStudent = reader.GetString(0) + " " + reader.GetString(1); input.classOfStudent = reader.GetString(2); if (!reader.IsDBNull(3)) { input.conductS1 = reader.GetString(3); } if (!reader.IsDBNull(4)) { input.conductS2 = reader.GetString(4); } if (!reader.IsDBNull(5)) { input.conductS3 = reader.GetString(5); } if (!reader.IsDBNull(6)) { input.averageResult = reader.GetDouble(6); } } }; } catch (Exception ex) { MessageBox.Show(ex.Message); return(false); } finally { Disconnect(); } return(true); }
public bool GetAllInfoAndResultOfStudentPrepareToPrint(InformationOfStudentResultPrepareForPrint input, string studentID) { input.scoreBoards = new DataSet(); if (!GetDataStudentResultPrepareToPrint(input.scoreBoards, studentID)) { return(false); } if (!GetAnotherInforOfStudentPrepareToPrint(input, studentID)) { return(false); } return(true); }
public bool GetAllInfoAndResultOfStudentPrepareToPrint(InformationOfStudentResultPrepareForPrint input, string studentID) { return(studentDA.GetAllInfoAndResultOfStudentPrepareToPrint(input, studentID)); }