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); }