public List <ViewResultGOM> GetStudentDetailsInThisGateway(int studentId)
{
Query = "SELECT * FROM Student AS s,Department as d WHERE s.StudentId='" + studentId + "' AND d.DepartmentId=s.DepartmentId";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <ViewResultGOM> StudentListAndResult = new List <ViewResultGOM>();
while (Reader.Read())
{
ViewResultGOM studentInfo = new ViewResultGOM();
//studentInfo.StudentId = Convert.ToInt32(Reader["StudentId"]);
studentInfo.StudentRegNo = Reader["RegNo"].ToString();
studentInfo.StudentName = Reader["StudentName"].ToString();
studentInfo.StudentEmail = Reader["StudentEmail"].ToString();
//studentInfo.StudentDeptId = Convert.ToInt32(Reader["DepartmentId"]);
studentInfo.StudentDeptName = Reader["DepartmentName"].ToString();
//studentInfo.StudentDeptCode = Reader["DepartmentCode"].ToString();
//studentInfo.CourseCode = Reader["CourseCode"].ToString();
//studentInfo.CourseName = Reader["CourseName"].ToString();
//studentInfo.Grade = Reader["Grade"].ToString();
//student.StudentdeptName = Reader["DepartmentId"];
StudentListAndResult.Add(studentInfo);
}
Connection.Close();
Reader.Close();
return(StudentListAndResult);
}
public ActionResult PrintResultSheet(ViewResultGOM result)
{
List <ViewResultGOM> studentResult = ShowStudentDetailsById(result.StudentId);
ViewBag.studentResult = studentResult;
return(View());
}
public List <ViewResultGOM> ShowStudentDetailsById(int studentId)
{
Query = "SELECT * FROM StudentResultVw WHERE StudentId='" + studentId + "'";
//Query = "Select s.StudentId,s.StudentName,s.RegNo,s.StudentEmail,d.DepartmentName,c.CourseCode,c.CourseName,sr.Grade FROM StudentResult AS sr,Student AS s,Course As c,Department AS d WHERE s.StudentId=sr.StudentId AND c.CourseId=sr.CourseId AND c.DepartmentId=d.DepartmentId AND s.StudentId='"+studentId+"'";
//Query = "SELECT * FROM Student AS s,Department AS d,StudentResult AS sr,Course AS c WHERE s.DepartmentId=d.DepartmentId AND s.StudentId=sr.StudentId AND c.CourseId=sr.CourseId AND s.StudentId='"+studentId+"' ORDER BY s.RegNo";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <ViewResultGOM> StudentListAndResult = new List <ViewResultGOM>();
string msg = "";
DateTime d = DateTime.Now;
while (Reader.Read())
{
ViewResultGOM studentInfo = new ViewResultGOM();
studentInfo.StudentId = Convert.ToInt32(Reader["StudentId"]);
studentInfo.StudentRegNo = Reader["RegNo"].ToString();
studentInfo.StudentName = Reader["StudentName"].ToString();
studentInfo.StudentEmail = Reader["StudentEmail"].ToString();
//studentInfo.StudentDeptId = Convert.ToInt32(Reader["DepartmentId"]);
studentInfo.StudentDeptName = Reader["DepartmentName"].ToString();
//studentInfo.StudentDeptCode = Reader["DepartmentCode"].ToString();
studentInfo.CourseCode = Reader["CourseCode"].ToString();
studentInfo.CourseName = Reader["CourseName"].ToString();
studentInfo.Grade = Reader["Result"].ToString();
studentInfo.PresentDate = d;
//student.StudentdeptName = Reader["DepartmentId"];
msg = studentInfo.Grade;
StudentListAndResult.Add(studentInfo);
}
Connection.Close();
Reader.Close();
if (msg == "")
{
StudentListAndResult = GetStudentDetailsInThisGateway(studentId);
}
return(StudentListAndResult);
}
public List <ViewResultGOM> ShowStudentDetails()
{
//Query = "SELECT distinct s.RegNo,s.StudentId FROM Student AS s,Department AS d,StudentResult AS sr,Course AS c WHERE s.DepartmentId=d.DepartmentId AND s.StudentId=sr.StudentId AND c.CourseId=sr.CourseId ORDER BY s.RegNo";
Query = "SELECT * FROM Student";
Command = new SqlCommand(Query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List <ViewResultGOM> StudentListAndResult = new List <ViewResultGOM>();
while (Reader.Read())
{
ViewResultGOM studentInfo = new ViewResultGOM();
studentInfo.StudentId = Convert.ToInt32(Reader["StudentId"]);
studentInfo.StudentRegNo = Reader["RegNo"].ToString();
//studentInfo.StudentName = Reader["StudentName"].ToString();
//studentInfo.StudentEmail = Reader["StudentEmail"].ToString();
//studentInfo.StudentDeptId = Convert.ToInt32(Reader["DepartmentId"]);
//studentInfo.StudentDeptName = Reader["DepartmentName"].ToString();
//studentInfo.StudentDeptCode = Reader["DepartmentCode"].ToString();
//studentInfo.CourseCode = Reader["CourseCode"].ToString();
//studentInfo.CourseName = Reader["CourseName"].ToString();
//studentInfo.Grade = Reader["Grade"].ToString();
//student.StudentdeptName = Reader["DepartmentId"];
StudentListAndResult.Add(studentInfo);
}
Connection.Close();
Reader.Close();
return(StudentListAndResult);
}
