public List <CourseMustafa> GetCourseDetails(int deptId) { Query = "SELECT * FROM Course Where DepartmentId=@departmentId"; Command = new SqlCommand(Query, Connection); Connection.Open(); Command.Parameters.Clear(); Command.Parameters.Add("departmentId", SqlDbType.Int); Command.Parameters["departmentId"].Value = deptId; Reader = Command.ExecuteReader(); CourseMustafa courseMustafa = null; List <CourseMustafa> courseList = new List <CourseMustafa>(); while (Reader.Read()) { courseMustafa = new CourseMustafa() { Code = Reader["Code"].ToString(), }; courseList.Add(courseMustafa); } Reader.Close(); Connection.Close(); return(courseList); }
public JsonResult GetCourseDetails(int courseId) { CourseMustafa courseMustafa = aCourseAssignManager.GetCourseDetails(courseId); return(Json(courseMustafa)); }
public List <CourseMustafa> GetAllCoursesByDeptId(int departmentId) { Query = "SELECT * FROM Course Where DepartmentId = @id"; Command = new SqlCommand(Query, Connection); Connection.Open(); Command.Parameters.Clear(); Command.Parameters.Add("id", SqlDbType.Int); Command.Parameters["id"].Value = departmentId; Reader = Command.ExecuteReader(); List <CourseMustafa> courses = new List <CourseMustafa>(); while (Reader.Read()) { CourseMustafa courseMustafa = new CourseMustafa() { Id = (int)Reader["id"], Name = Reader["Name"].ToString() }; courses.Add(courseMustafa); } Reader.Close(); Connection.Close(); return(courses); }
//public List<CourseMustafa> GetAllCourses() //{ // Query = "SELECT * FROM Course"; // Command = new SqlCommand(Query, Connection); // Connection.Open(); // Reader = Command.ExecuteReader(); // List<CourseMustafa> courses = new List<CourseMustafa>(); // while (Reader.Read()) // { // CourseMustafa aCourse = new CourseMustafa(); // aCourse.Id = (int)Reader["id"]; // aCourse.Name = Reader["Code"].ToString(); // courses.Add(aCourse); // } // Reader.Close(); // Connection.Close(); // return courses; //} public CourseMustafa GetCourseDetails(int courseId) { //Query = "SELECT * FROM Course"; //Command = new SqlCommand(Query, Connection); //Connection.Open(); //Reader = Command.ExecuteReader(); //CourseMustafa aCourse = new CourseMustafa(); //if (Reader.Read()) //{ // aCourse.CourseId =courseId; // aCourse.CourseName = Reader["Name"].ToString(); // aCourse.Credit = (decimal)Reader["Credit"]; //} //Reader.Close(); //Connection.Close(); //return aCourse; Query = "SELECT * FROM Course Where id = @courseId"; Command = new SqlCommand(Query, Connection); Connection.Open(); Command.Parameters.Clear(); Command.Parameters.Add("courseId", SqlDbType.Int); Command.Parameters["courseId"].Value = courseId; Reader = Command.ExecuteReader(); CourseMustafa courseMustafa = null; while (Reader.Read()) { courseMustafa = new CourseMustafa() { Name = Reader["Name"].ToString(), Credit = (decimal)Reader["Credit"] }; } Reader.Close(); Connection.Close(); return(courseMustafa); }