public StudentHomeworkDetails GetStudentHomeworkDetails(int studentID, int homeworkID) { using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("spGetStudentHomeworkDetails", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@studentID", studentID); cmd.Parameters.AddWithValue("@homeworkID", homeworkID); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { StudentHomeworkDetails model = new StudentHomeworkDetails() { HomeworkId = (int)rdr["HomeworkId"], HomeWorkName = (string)rdr["HomeWorkName"], StudentGrade = (int)rdr["StudentGrade"], Description = (string)rdr["Description"], Status = (string)rdr["Status"], TeacherId = (int)rdr["TeacherID"], TeacherName = (string)rdr["TeacherName"], Deadline = Convert.ToDateTime(rdr["Deadline"]), Comment = Convert.IsDBNull(rdr["Comment"]) ? "" : (string)rdr["Comment"] }; return(model); } return(new StudentHomeworkDetails()); } }
public List <StudentHomeworkDetails> GetStudentCompletedHomework(string userName) { try { using (SqlConnection con = new SqlConnection(cs)) { List <StudentHomeworkDetails> studentCompletedHomeworkList = new List <StudentHomeworkDetails>(); SqlCommand cmd = new SqlCommand("spStudentHomeworkCompleted", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@username", userName); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { StudentHomeworkDetails studentCompletedHomework = new StudentHomeworkDetails(); studentCompletedHomework.TeacherId = Convert.ToInt32(rdr["TeacherUserId"]); studentCompletedHomework.HomeworkId = Convert.ToInt32(rdr["HomeworkId"]); studentCompletedHomework.HomeWorkName = rdr["HomeWorkName"].ToString(); studentCompletedHomework.Description = rdr["Description"].ToString(); studentCompletedHomework.Deadline = Convert.ToDateTime(rdr["Deadline"]); studentCompletedHomework.Comment = rdr["Comment"].ToString(); studentCompletedHomework.Status = rdr["Status"].ToString(); studentCompletedHomework.StudentGrade = Convert.ToInt32(rdr["Grade"]); studentCompletedHomeworkList.Add(studentCompletedHomework); } return(studentCompletedHomeworkList); } } catch (SqlException) { return(null); } catch (Exception) { return(null); } }
public List <StudentHomeworkDetails> GetCompletedHomeworkUpload(string userName, int homeworkID) { using (SqlConnection con = new SqlConnection(cs)) { List <StudentHomeworkDetails> studentCompletedHomeworkUploadsList = new List <StudentHomeworkDetails>(); SqlCommand cmd = new SqlCommand("spGetCompletedHomeworkUpload", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@username", userName); cmd.Parameters.AddWithValue("@homeworkID", homeworkID); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { StudentHomeworkDetails studentCompletedHomeworkUploads = new StudentHomeworkDetails(); studentCompletedHomeworkUploads.TeacherName = rdr["TeacherName"].ToString(); studentCompletedHomeworkUploads.TeacherId = Convert.ToInt32(rdr["TeacherUserId"]); studentCompletedHomeworkUploads.HomeworkId = Convert.ToInt32(rdr["HomeworkId"]); studentCompletedHomeworkUploads.HomeWorkName = rdr["HomeWorkName"].ToString(); studentCompletedHomeworkUploads.Description = rdr["Description"].ToString(); studentCompletedHomeworkUploads.Deadline = Convert.ToDateTime(rdr["Deadline"]); studentCompletedHomeworkUploads.Comment = rdr["Comment"].ToString(); studentCompletedHomeworkUploads.Status = rdr["Status"].ToString(); studentCompletedHomeworkUploads.UploadDate = Convert.ToDateTime(rdr["UploadDate"]); studentCompletedHomeworkUploads.StudentGrade = Convert.ToInt32(rdr["UploadID"]); studentCompletedHomeworkUploads.UploadId = Convert.ToInt32(rdr["UploadId"]); studentCompletedHomeworkUploadsList.Add(studentCompletedHomeworkUploads); } return(studentCompletedHomeworkUploadsList); } }