public List<SaveResultViewModel> GetCourseByStudentId(int studentid)
{
string query = "select c.CourseName as CourseName, c.Id as CourseId from EnrollACourse as e " +
"inner join Course as c on e.CourseId= c.Id " +
"where e.StudentId= '" + studentid + "'";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List<SaveResultViewModel> courses = new List<SaveResultViewModel>();
while (Reader.Read())
{
SaveResultViewModel course = new SaveResultViewModel();
course.CourseName = Reader["CourseName"].ToString();
course.CourseId = Convert.ToInt32(Reader["CourseId"]);
courses.Add(course);
}
Reader.Close();
Connection.Close();
return courses;
}
public List<SaveResultViewModel> GetStudentByRegNo(string regNo)
{
string query = "select r.Id as StudentId ,r.Name as StudentName, " +
"r.Email as StudentEmail, d.DepartmentName as DepartmentName " +
"from RegisterStudent as r inner join Department as d on r.DeptId= d.Id where" +
" r.RegNo = '"+regNo+"'";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List<SaveResultViewModel> students = new List<SaveResultViewModel>();
while (Reader.Read())
{
SaveResultViewModel student = new SaveResultViewModel();
student.StudentName = Reader["StudentName"].ToString();
student.StudentEmail = Reader["StudentEmail"].ToString();
student.DepartmentName = Reader["DepartmentName"].ToString();
student.StudentId = Convert.ToInt32(Reader["StudentId"]);
students.Add(student);
}
Reader.Close();
Connection.Close();
return students;
}
public List <SaveResultViewModel> GetAllRegNo()
{
SqlConnection connection = new SqlConnection(connectionDB);
string query = "SELECT StudentId,StudentRegId FROM [Student.Register]";
SqlCommand command = new SqlCommand(query, connection);
List <SaveResultViewModel> RegNoList = new List <SaveResultViewModel>();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
// if (reader.HasRows)
//{
while (reader.Read())
{
SaveResultViewModel registerStudent = new SaveResultViewModel();
registerStudent.StudentId = int.Parse(reader["StudentId"].ToString());
//registerStudent.GradeLaterId = Convert.ToInt32(reader["GradeLaterId"]);
registerStudent.StudentRegId = reader["StudentRegId"].ToString();
RegNoList.Add(registerStudent);
}
reader.Close();
// }
connection.Close();
return(RegNoList);
}
public List <SaveResultViewModel> GetAllCoursesByRegNo(string StudentRegId)
{
SqlConnection connection = new SqlConnection(connectionDB);
string query = "SELECT *FROM SaveResultViewModel WHERE StudentRegId='" + StudentRegId + "'";
SqlCommand command = new SqlCommand(query, connection);
List <SaveResultViewModel> courseList = new List <SaveResultViewModel>();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
SaveResultViewModel courseModel = new SaveResultViewModel();
courseModel.CourseId = Convert.ToInt32(reader["CourseId"]);
courseModel.CourseName = reader["CourseName"].ToString();
courseList.Add(courseModel);
}
reader.Close();
}
connection.Close();
return(courseList);
}
public List<SaveResultViewModel> GetGrade()
{
string query = "select * from Grade";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
List<SaveResultViewModel> students = new List<SaveResultViewModel>();
while (Reader.Read())
{
SaveResultViewModel student = new SaveResultViewModel();
student.Grade = Reader["Grade"].ToString();
student.GradeId = Convert.ToInt32(Reader["Id"]);
students.Add(student);
}
Reader.Close();
Connection.Close();
return students;
}
public SaveResultViewModel GetstudentRegNo(int studentId)
{
SqlConnection connection = new SqlConnection(connectionDB);
string query = @"SELECT StudentRegId FROM [Student.Register] where StudentId= '" + studentId + "'";
SqlCommand command = new SqlCommand(query, connection);
SaveResultViewModel registerStudent = new SaveResultViewModel();
connection.Open();
SqlDataReader reader = command.ExecuteReader();
// if (reader.HasRows)
//{
while (reader.Read())
{
//registerStudent.StudentId = int.Parse(reader["StudentId"].ToString());
//registerStudent.GradeLaterId = Convert.ToInt32(reader["GradeLaterId"]);
registerStudent.StudentRegId = reader["StudentRegId"].ToString();
}
reader.Close();
// }
connection.Close();
return(registerStudent);
}
