public List<RosterSearchResult> RosterUserSearch(RosterStudent studentSearch)
{
List<RosterSearchResult> students = new List<RosterSearchResult>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var cmd = new SqlCommand("RosterGetStudentsNotInCourse", cn);
cmd.CommandType = CommandType.StoredProcedure;
if (!string.IsNullOrEmpty(studentSearch.LastName))
cmd.Parameters.Add(new SqlParameter("@LastName", studentSearch.LastName));
if (studentSearch.GradeLevelID != null)
cmd.Parameters.Add(new SqlParameter("@GradeLevelID", studentSearch.GradeLevelID));
cmd.Parameters.AddWithValue("@CourseID", studentSearch.CourseID);
cn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var student = new RosterSearchResult();
student.UserID = (int)dr["UserID"];
student.FirstName = dr["FirstName"].ToString();
student.LastName = dr["LastName"].ToString();
student.GradeLevelName = dr["GradeLevelName"].ToString();
students.Add(student);
}
}
}
return students;
}
public List<RosterStudent> GetRosterStudents(int teacherID, int courseID)
{
List<RosterStudent> students = new List<RosterStudent>();
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var cmd = new SqlCommand("RosterGetStudentsInCourse", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@TeacherID", teacherID);
cmd.Parameters.AddWithValue("@CourseID", courseID);
cn.Open();
using (var dr = cmd.ExecuteReader())
{
while (dr.Read())
{
var student = new RosterStudent();
student.FirstName = dr["FirstName"].ToString();
student.LastName = dr["LastName"].ToString();
student.Email = dr["Email"].ToString();
student.IsDeleted = (bool)dr["IsDeleted"];
if (dr["GradeLevelID"] != DBNull.Value)
student.GradeLevelID = (byte)dr["GradeLevelID"];
student.RosterID = (int)dr["RosterID"];
student.CourseID = (int)dr["CourseID"];
students.Add(student);
}
}
}
return students;
}
public void AddStudent(RosterStudent student)
{
using (var cn = new SqlConnection(Settings.GetConnectionString()))
{
var cmd = new SqlCommand("RosterInsertStudent", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CourseID", student.CourseID);
cmd.Parameters.AddWithValue("@UserID", student.UserID);
cmd.Parameters.AddWithValue("@CurrentGrade", student.CurrentGrade);
cn.Open();
cmd.ExecuteNonQuery();
}
}
public ActionResult Roster(RosterStudent student)
{
student.CourseID = 2;
var studentSearch = _lmsRosterManager.RosterUserSearch(student);
var currentUser = IdentityHelper.GetLmsUserForCurrentUser(this);
var roster = _lmsRosterManager.GetRosterStudents(currentUser.UserID, 2);
RosterViewModel model = new RosterViewModel();
model.CreateGradeLevel(_lmsGradeLevelManager.GradeLevelGetAll());
model.StudentSearchResults = studentSearch.Data;
model.CourseRoster = roster.Data;
return View(model);
}
public DataResponse<List<RosterSearchResult>> RosterUserSearch(RosterStudent student)
{
var response = new DataResponse<List<RosterSearchResult>>();
try
{
response.Data = _lmsRosterRepository.RosterUserSearch(student);
response.Success = true;
}
catch (Exception ex)
{
response.Message = ex.Message;
}
return response;
}
public void AddStudent(RosterStudent student)
{
_lmsRosterRepository.AddStudent(student);
}