public List <TeacherClassRoster> Get([FromUri] TeacherClassRoster request)
{
var repo = new RosterRepository();
var students = repo.Search(request);
return(students);
}
public static void LoadRosters()
{
DBConnection.DatabaseName = "CANE";
if (DBConnection.IsConnected())
{
string query = "SELECT * FROM Roster";
SqlCommand cmd = new SqlCommand(query, DBConnection.Connection);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
int rosterID = (int)reader["RosterID"];
DateTime startDate = (DateTime)reader["StartDate"];
DateTime endDate = (DateTime)reader["EndDate"];
string shop = reader["Shop"].ToString();
Shop newShop;
if (shop == "kongensgade")
{
newShop = Shop.kongensgade;
}
else
{
newShop = Shop.skibhusvej;
}
Roster addRoster = new Roster(rosterID, startDate, endDate, newShop);
RosterRepository.AddRoster(addRoster);
}
}
DBConnection.Close();
}
}
public List <TeacherClassRoster> Get(int id)//gets class id
{
var repo = new RosterRepository();
var roster = repo.GetClassRoster(id);
return(roster);
}
public ActionResult CourseRosterTable(int id)
{
RosterRepository rosters = new RosterRepository();
var vm = rosters.GetCourseStudents(id);
return(View(vm));
}
public HttpStatusCode Delete(RosterDeleteRequest request)//need to get student id and class id
{
var repo = new RosterRepository();
repo.DeleteStudentFromClass(request);
return(HttpStatusCode.OK);
}
public HttpStatusCode Post(RosterAddRequest request)
{
var repo = new RosterRepository();
repo.AddToRoster(request);
return(HttpStatusCode.OK);
}
public ActionResult AddStudentToCourse(Roster addStudent)
{
var database = new RosterRepository();
database.Insert(addStudent);
return(RedirectToAction("Roster", new { id = addStudent.CourseId }));
}
public ActionResult DeleteStudentFromClass()
{
int studentId = int.Parse(Request.Form["RosterId"]);
var database = new RosterRepository();
database.Delete(studentId);
int rosterCourseDeleteId = int.Parse(Request.Form["CourseId"]);
return(RedirectToAction("Roster", new { id = rosterCourseDeleteId }));
}
public GradeBook Get(int id) //classId
{
var gradeBook = new GradeBook();
var _gradeBookRepository = new GradeBookRepository();
var _teacherRepository = new TeacherRepository();
var _rosterRepository = new RosterRepository();
gradeBook.StudentsEnrolled = _rosterRepository.GetStudentsEnrolledIn(id);
gradeBook.Course = _teacherRepository.GetCourseById(id);
gradeBook.AssignmentList = _gradeBookRepository.GetListOfAssignmentsById(id);
gradeBook.StudentPerformances = _gradeBookRepository.GetListOfStudentPerformanceById(gradeBook.StudentsEnrolled);
return(gradeBook);
}
private void CreateRosterBtn_Click(object sender, RoutedEventArgs e)
{
try
{
RosterRepository.CreateRoster(DatePickerStart.SelectedDate.Value, DatePickerEnd.SelectedDate.Value, comboBoxShop.Text.ToString().ToLower());
MessageBox.Show("Vagtplan i " + comboBoxShop.Text + " oprettet. Du kan nu indsætte vagter", "Success");
}
catch (Exception r)
{
MessageBox.Show($"{r.Message}\nDu skal udfylde alle felter");
}
this.Close();
}
private void ComboBoxShop_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string shop = (comboBoxShop.SelectedItem as ComboBoxItem).Content.ToString().ToLower();
DateTime startDate;
if (RosterRepository.CurrentRosterExist(shop) == false)
{
startDate = DateTime.Now;
}
else
{
startDate = RosterRepository.GetEndDate(shop);
}
DatePickerStart.SelectedDate = startDate;
DatePickerEnd.SelectedDate = DatePickerStart.SelectedDate;
}
public static void CreateRoster(Roster roster)
{
DBConnection.DatabaseName = "CANE";
string query = "Create_Roster";
if (!RosterRepository.RosterExist(roster))
{
if (DBConnection.IsConnected())
{
var cmd = new SqlCommand(query, DBConnection.Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@StartDate_IN", roster.StartDate));
cmd.Parameters.Add(new SqlParameter("@EndDate_IN", roster.EndDate));
cmd.Parameters.Add(new SqlParameter("@Shop_IN", roster.Shop.ToString()));
cmd.ExecuteReader();
DBConnection.Close();
}
RosterRepository.AddRoster(roster);
}
}
private void CreateRosterBtn_Click(object sender, RoutedEventArgs e)
{
RosterRepository.CreateRoster(DatePickerStart.SelectedDate.Value, DatePickerEnd.SelectedDate.Value, comboBoxShop.Text.ToString().ToLower());
MessageBox.Show("Vagtplan med " + " i " + comboBoxShop.Text + " oprettet. Du kan nu indsætte vagter", "Success");
this.Close();
}
protected override void Seed(ApplicationDbContext context)
{
// Don't want to redo this multiple times, only if we drop the database and need to re-seed
if (new UserProfileRepo().GetAll().Any())
{
return;
}
CreateRole(context, "Admin");
CreateRole(context, "Parent");
CreateRole(context, "Student");
CreateRole(context, "Teacher");
string fakeTeacherId = CreateUser(context, "*****@*****.**", "password123", "Test", "Teacher", "Teacher", null);
string fakeStudentId = CreateUser(context, "*****@*****.**", "password123", "Test", "Student", "Student", null);
string fakeParentId = CreateUser(context, "*****@*****.**", "password123", "Test", "Parent", "Parent", null);
ParentStudentRepository psRepo = new ParentStudentRepository();
psRepo.Add(fakeParentId, fakeStudentId);
var algebra = new Course()
{
TeacherId = fakeTeacherId,
Name = "Algebra 1",
Department = "Math",
CourseDescription = "Math and math related stuff",
StartDate = DateTime.Today,
EndDate = DateTime.Today.AddDays(90)
};
var history = new Course()
{
TeacherId = fakeTeacherId,
Name = "America",
Department = "Social Studies",
CourseDescription = "lots of old people",
StartDate = DateTime.Today,
EndDate = DateTime.Today.AddDays(90)
};
CourseRepository cRepo = new CourseRepository();
RosterRepository rRepo = new RosterRepository();
AssignmentRepository aRepo = new AssignmentRepository();
AssignmentTrackerRepo atRepo = new AssignmentTrackerRepo();
cRepo.Insert(algebra);
cRepo.Insert(history);
List <string> moreStudentsIds = new List <string>();
for (int i = 0; i < 50; i++)
{
string newStudentId = CreateUser(context, "fakestudent." + i + "@test.com", "password123", "Fake", "Student" + i, "Student", i % 13);
moreStudentsIds.Add(newStudentId);
if (i % 10 == 0)
{
rRepo.Insert(new Roster()
{
CourseId = history.CourseId, IsActive = true, UserId = newStudentId
});
}
if (i % 8 == 0)
{
rRepo.Insert(new Roster()
{
CourseId = algebra.CourseId, IsActive = true, UserId = newStudentId
});
}
}
var rosterInfo = new Roster
{
CourseId = algebra.CourseId,
UserId = fakeStudentId,
IsActive = true
};
rRepo.Insert(rosterInfo);
var assignment = new Assignment
{
AssignmentDescription = "First Assignment Description",
CourseId = algebra.CourseId,
DueDate = DateTime.Now.AddDays(90),
Name = "First Assignment",
PointsPossible = 45
};
aRepo.Insert(assignment);
var assignment2 = new Assignment
{
AssignmentDescription = "Second Assignment Description",
CourseId = algebra.CourseId,
DueDate = DateTime.Now.AddDays(90),
Name = "Second Assignment",
PointsPossible = 50
};
aRepo.Insert(assignment2);
var grade = new AssignmentTracker
{
AssignmentId = assignment.AssignmentId,
EarnedPoints = 40,
RosterId = rosterInfo.RosterId
};
atRepo.Insert(grade);
var grade2 = new AssignmentTracker
{
AssignmentId = assignment2.AssignmentId,
EarnedPoints = 47,
RosterId = rosterInfo.RosterId
};
atRepo.Insert(grade2);
}
