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