public IActionResult GetMailMentors(String id)
{
List <Message> mess = new List <Message>();
// Make an instance to get info about this student (use stud2 for reference)
MentorDbContext mentorDbContext = new MentorDbContext();
Mentor ment2 = mentorDbContext.Mentors.Single(ment => ment.MentorId == currentUserID);
// Another wierd Query
var message = db.Messages.Where(mess2 => mess2.Receiver.ToLower() == ment2.Name.ToLower());
// Iteratate through the query
foreach (var row in message)
{
// Make a new object to add to the list
Message message2 = new Message()
{
MessageId = row.MessageId,
Receiver = row.Receiver,
Sender = row.Sender,
Text = row.Text,
Topic = row.Topic
};
mess.Add(message2);
}
// Set the viewbag variable to the temp list we just created
ViewBag.messagesPrint = mess;
return(View());
}
public IActionResult SendMailStudent()
{
// Make an instance to get info about this student (use stud2 for reference)
MentorDbContext mentorDbContext = new MentorDbContext();
Student stud2 = mentorDbContext.Students.Single(stud => stud.StudentId == currentUserID);
ViewBag.UserName = stud2.Name;
return(View());
}
public IActionResult SendMailMentor()
{
// Make an instance to get info about this student (use stud2 for reference)
MentorDbContext mentorDbContext = new MentorDbContext();
Mentor ment2 = mentorDbContext.Mentors.Single(ment => ment.MentorId == currentUserID);
ViewBag.UserName = ment2.Name;
return(View());
}
public IActionResult Mentor(int id)
{
// Make an instance to get info about this student (use stud2 for reference)
MentorDbContext mentorDbContext = new MentorDbContext();
Mentor ment2 = mentorDbContext.Mentors.Single(ment => ment.MentorId == currentUserID);
ViewBag.UserName = ment2.Name;
ViewBag.number = currentUserID;
ViewBag.ment = db.Mentors.ToList();
// ViewBag.online = "";
return(View());
}
public IActionResult ChangeSubscribedOn()
{
// Make an instance to get info about this student (use stud2 for reference)
MentorDbContext mentorDbContext = new MentorDbContext();
Student stud2 = mentorDbContext.Students.Single(stud => stud.StudentId == currentUserID);
ViewBag.UserName = stud2.Name;
ViewBag.number = currentUserID;
ViewBag.stud = db.Students.ToList();
ViewBag.ment = db.Mentors.ToList();
Student stud3 = db.Students
.Where(b => b.StudentId == currentUserID)
.FirstOrDefault();
if (stud3 != null)
{
stud3.Subscribed = 1;
db.SaveChanges();
}
return(View("~/Views/Home/StudentPage.cshtml"));
}
public IActionResult ChangeOff()
{
// Make an instance to get info about this student (use stud2 for reference)
MentorDbContext mentorDbContext = new MentorDbContext();
Mentor ment2 = mentorDbContext.Mentors.Single(ment => ment.MentorId == currentUserID);
ViewBag.UserName = ment2.Name;
ViewBag.number = currentUserID;
ViewBag.ment = db.Mentors.ToList();
Mentor ment3 = db.Mentors
.Where(b => b.MentorId == currentUserID)
.FirstOrDefault();
if (ment3 != null)
{
ment3.Online = 0;
db.SaveChanges();
}
return(View("~/Views/Home/Mentor.cshtml"));
}
public IActionResult StudentPage(string id)
{
// Make an instance to get info about this student (use stud2 for reference)
MentorDbContext mentorDbContext = new MentorDbContext();
Student stud2 = mentorDbContext.Students.Single(stud => stud.StudentId == currentUserID);
ViewBag.UserName = stud2.Name;
ViewBag.number = currentUserID;
ViewBag.stud = db.Students.ToList();
// New list to temporary store variables when iterating through query
List <Mentor> mentorList = new List <Mentor>();
// If nothing is typed yet in the search bar just display all mentors
if (id == null)
{
ViewBag.ment = db.Mentors.ToList();
}
// When a subject is typed in searchbar
else
{
// Assuming that id is a subject
// Wierd IQueryable variable where the mentors subject equals the subject passed as param
// var mentor = db.Mentors.Where(ment2 => id.ToLower().Contains(ment2.Subjects.ToLower()));
var mentor = db.Mentors.Where(ment2 => id.ToLower().Contains(ment2.Subjects.ToLower()));
// Iteratate through the query
foreach (var row in mentor)
{
// Make a new object to add to the list
Mentor mentor2 = new Mentor()
{
MentorId = row.MentorId,
Name = row.Name,
Password = row.Password,
Email = row.Email,
Subjects = row.Subjects,
Role = row.Role,
Online = row.Online,
Imgurl = row.Imgurl
};
mentorList.Add(mentor2);
}
// ------- Compare with tag -----
var mentorTag = db.Mentors.Where(ment3 => ment3.Subjects.ToLower().Equals(CheckDictonary(id).ToLower()));
Console.Write(id);
Console.Write(CheckDictonary(id).ToLower());
// Iteratate through the query
foreach (var row in mentorTag)
{
// Make a new object to add to the list
Mentor mentor3 = new Mentor()
{
MentorId = row.MentorId,
Name = row.Name,
Password = row.Password,
Email = row.Email,
Subjects = row.Subjects,
Role = row.Role,
Online = row.Online,
Imgurl = row.Imgurl
};
mentorList.Add(mentor3);
}
// Set the viewbag variable to the temp list we just created
ViewBag.ment = mentorList;
}
return(View());
}
