// Display Students dash Info
public void displayStudentDashInfo(int _type)
{
UserDetails _user = null;
if (_type == 0) // 0=loggedin user; 1=student chosen
{
_user = (UserDetails)HttpContext.Current.Session["User"];
}
else
{
_user = model.selectUserDetailsById(StudentView.studentToView);
}
Hashtable _data = new Hashtable();
string[] _titles = { "Messages", "Meetings", "Blogs" };
string[] _subs = { "Received", "Sent", "Requests", "Real", "Virtual", "Cancelled" };
_data.Add(0, _titles);
_data.Add(1, _subs);
int _numMessagesFromStudent = model.countMessages(_user.UserID, _user.SupervisorID);
int _numMessagesFromTutor = model.countMessages(_user.SupervisorID, _user.UserID);
int _numBlogPosts = model.countBlogPosts(_user.UserID);
List <MeetingDetails> meetings = MeetingDetails.getAllMeetingsByStudentID(_user.UserID);
int _numMeetings = meetings.Count;
int _numAccepted = 0;
int _numDeclined = 0;
int _numCancelled = 0;
foreach (MeetingDetails m in meetings)
{
if (m.TutorStatus == "Accepted")
{
_numAccepted++;
}
else if (m.TutorStatus == "Declined")
{
_numDeclined++;
}
else if (m.TutorStatus == "Cancelled")
{
_numCancelled++;
}
}
string[] _tempArray = { _numMessagesFromTutor.ToString(), _numMessagesFromStudent.ToString(), _numMeetings.ToString(), _numAccepted.ToString(), _numDeclined.ToString(), _numCancelled.ToString(), _numBlogPosts.ToString() };
_data.Add(2, _tempArray);
StudentView.setInfoTable(_data);
}
// Display Tutees
public void displayTutees(int _type, string firstName, string surname, int programmeID, int orderType)
{
UserDetails _user = null;
if (_type == 0) // 0=loggedin user; 1=student chosen
{
_user = (UserDetails)HttpContext.Current.Session["User"];
}
else
{
_user = model.selectUserDetailsById(TutorView.studentToView);
}
List <UserDetails> _tutees = new List <UserDetails>();
if (firstName != "" || surname != "" || programmeID > 0 || orderType > 0)
{
_tutees = model.selectTuteesBySearchCriteria(_user.UserID, firstName, surname, programmeID, orderType);
}
else
{
_tutees = model.selectTutees(_user.UserID);
}
int _numTutees = _tutees.Count;
if (_numTutees > 0)
{
int _counter = 2;
Hashtable _data = new Hashtable();
string[] _titles = { "Student", "Messages", "Meetings", "Uploads", "Blogs" };
string[] _subs = { " - ", "Firstname", "Surname", "Received", "Sent", "Last", "Requests", "Real", "Virtual", "Cancelled", "Last", "Number", "Comments", "Entries", "Last" };
_data.Add(0, _titles);
_data.Add(1, _subs);
foreach (UserDetails _tutee in _tutees)
{
int _numMessagesFromStudent = model.countMessages(_tutee.UserID, _user.UserID);
int _numMessagesFromTutor = model.countMessages(_user.UserID, _tutee.UserID);
DateTime _lastMessageDate = model.getDateOfLastMessageSent(_user.UserID, _tutee.UserID);
string _lastMessageStr = (_lastMessageDate.ToShortDateString().Equals("01/01/0001")) ? "n/a" : _lastMessageDate.ToShortDateString();
int _numFilesUploadedByStudent = model.countFilesUploadedByStudent(_tutee.UserID);
List <UserDocument> _documentList = model.selectUploadFiles(_tutee.UserID);
int _numberComments = 0;
int _blogPosts = model.countBlogPosts(_tutee.UserID);
DateTime _lastBlogDate = model.getDateOfLastBlogPost(_tutee.UserID);
string _lastBlogStr = (_lastBlogDate.ToShortDateString().Equals("01/01/0001")) ? "n/a" : _lastBlogDate.ToShortDateString();
foreach (UserDocument _doc in _documentList)
{
if (model.commentExists(_doc.DocumentID.ToString()) == true)
{
_numberComments++;
}
}
List <MeetingDetails> meetings = MeetingDetails.getAllMeetingsByStudentID(_tutee.UserID);
int _numMeetings = meetings.Count;
int _numAccepted = 0;
int _numDeclined = 0;
int _numCancelled = 0;
DateTime last = DateTime.Parse("01/01/0001");
string date = "";
foreach (MeetingDetails m in meetings)
{
if (m.StudentStatus == "Accepted")
{
_numAccepted++;
}
else if (m.StudentStatus == "Declined")
{
_numDeclined++;
}
else if (m.StudentStatus == "Cancelled")
{
_numCancelled++;
}
if (m.Date > last)
{
last = m.Date;
}
}
if (last == DateTime.Parse("01/01/0001"))
{
date = "n/a";
}
else
{
date = last.ToString();
}
string[] _tempArray = { _tutee.UserID, _tutee.FirstName, _tutee.Surname, _numMessagesFromStudent.ToString(), _numMessagesFromTutor.ToString(), _lastMessageStr, _numMeetings.ToString(), _numAccepted.ToString(), _numDeclined.ToString(), _numCancelled.ToString(), date, _numFilesUploadedByStudent.ToString(), _numberComments.ToString(), _blogPosts.ToString(), _lastBlogStr };
_data.Add(_counter, _tempArray);
_counter++;
}
TutorView.numTutees = "Number of Tutees: " + _numTutees;
TutorView.setTuteesTable(_data);
}
else
{
TutorView.noTutees = "No tutees found. This may be because your search criteria returned no results, or you have no students allocated to you.";
}
}
private void populateTable()
{
UserDetails _user = (UserDetails)Session["User"];
meetingHistoryTable.Rows.Clear();
List <MeetingDetails> allMeetingsByStudentID;
allMeetingsByStudentID = MeetingDetails.getAllMeetingsByStudentID(_user.UserID);
int i = 0;
foreach (MeetingDetails md in allMeetingsByStudentID)
{
TableRow row = new TableRow();
TableCell cell = new TableCell();
cell.Text = "" + md.MeetingID.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.TutorName.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.Date.ToString().Substring(0, 10);
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.Time;
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.Type.ToString().Trim();
cell.Width = new Unit(400);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.Location.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Text = "" + md.StudentStatus.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
if (md.StudentStatus.ToString().Trim() == "-")
{
cell = new TableCell();
cell.Text = "" + md.TutorStatus.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Controls.Add(createLinkButton(md.MeetingID.ToString(), "AcceptDecline"));
cell.Controls.Add(new Literal()
{
ID = md.MeetingID.ToString() + "br", Text = "<br/>"
});
cell.Controls.Add(createLinkButton(md.MeetingID.ToString(), "DeclineAccept"));
cell.Width = new Unit(50);
row.Cells.Add(cell);
}
else if (md.StudentStatus.ToString().Trim() == "Accepted")
{
cell = new TableCell();
cell.Text = "" + md.TutorStatus.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Controls.Add(createLinkButton(md.MeetingID.ToString(), "Decline"));
cell.Width = new Unit(50);
row.Cells.Add(cell);
}
else if (md.StudentStatus.ToString().Trim() == "Declined")
{
cell = new TableCell();
cell.Text = "" + md.TutorStatus.ToString().Trim();
cell.Width = new Unit(50);
row.Cells.Add(cell);
cell = new TableCell();
cell.Controls.Add(createLinkButton(md.MeetingID.ToString(), "Accept"));
cell.Width = new Unit(50);
row.Cells.Add(cell);
}
// Set Row colours
if (i % 2 == 0)
{
row.BackColor = Color.FromArgb(161, 178, 195);
}
else
{
row.BackColor = Color.WhiteSmoke;
}
i++;
meetingHistoryTable.Rows.Add(row);
}
meetingHistoryTable.GridLines = GridLines.Both;
Session["StudentMeetingDetailsLists"] = allMeetingsByStudentID;
}
