public ActionResult ManageMeetings()
{
HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
var username = ticket.UserData;
cdashEntities1 _db = new cdashEntities1();
var model = from users in _db.users
join comlist in _db.committee_Memberlist on users.email equals username
join _meeting in _db.meetings on comlist.name_ofCommittee equals _meeting.committee_name
select new viewmeeting
{
committee_name = _meeting.committee_name,
Message_Agenda = _meeting.Message_Agenda,
meetingid = _meeting.ID,
meeting_date = _meeting.end_date,
created_date = _meeting.creation_date,
active = _meeting.active
};
return(View(model));
}
public ActionResult AgendaAccess(String committeeName, int id)
{
meetingId = id;
commName = committeeName;
//var model = GetDetailsById(id);
//return View(model);
HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
var username = ticket.UserData;
cdashEntities1 _db = new cdashEntities1();
var model = from meeting in _db.meetings
join agenda in _db.agendanotes on meeting.ID equals agenda.meetingId
where agenda.Poster == username
where agenda.meetingId == meetingId
select new agendaviewmodel
{
notes = agenda.Post,
agendaNote = meeting.Message_Agenda,
postdate = agenda.Post_date,
meetingId = agenda.meetingId
};
return(View(model));
}
public ActionResult Loadproffessors()
{
var committeename = Request.QueryString["committeeName"];
commName = committeename;
System.Diagnostics.Debug.WriteLine(committeename);
cdashEntities1 _db = new cdashEntities1();
var role = "proffessor";
var peoplealreadyincomm = (from memberlist in _db.committee_Memberlist
where memberlist.name_ofCommittee == committeename
select memberlist);
//var model2 = (from ppl in peoplealreadyincomm
// where !(from memberlist in _db.committee_Memberlist select memberlist.Uname_ofMember). Contains(ppl.Uname_ofMember)
// join users in _db.users on memberlist.Uname_ofMember equals users.email
var allprofs = (from memberlist in _db.committee_Memberlist
join users in _db.users on memberlist.Uname_ofMember equals users.email
select new Loadprofessors()
{
Name = users.FIRSTName,
Lname = users.LASTName,
email = users.email,
Role = users.role
}).Distinct().ToList();
return(PartialView(allprofs));
}
public ActionResult ManageCourses()
{
cdashEntities1 _db = new cdashEntities1();
var model = from courses in _db.courseslists
select new viewcourses()
{
courseName = courses.courseName,
courseNumber = courses.courseNumber
};
return(View(model));
}
public ActionResult LoadCommitteeproffessors()
{
var committeename = Request.QueryString["committeeName"];
commName = committeename;
cdashEntities1 _db = new cdashEntities1();
HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
System.Diagnostics.Debug.WriteLine(committeename + "from loadcommittee");
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
var username = ticket.UserData;
var role = "proffessor";
var model2 = from users in _db.users
select new loadcourseprofessors
{
Name = users.FIRSTName,
Lname = users.LASTName,
email = users.email,
Role = users.role,
Assigned = (from profs in _db.committee_Memberlist
where profs.Uname_ofMember == users.email
where profs.name_ofCommittee == committeename
select profs.Uname_ofMember).Any() ? true :false
};
var model3 = (from users in model2
orderby users.Assigned
select users).ToList();
var model = (from memberlist in _db.committee_Memberlist
where memberlist.name_ofCommittee == committeename
join users in _db.users on memberlist.Uname_ofMember equals users.email
select new Loadprofessors()
{
Name = users.FIRSTName,
Lname = users.LASTName,
email = users.email,
Role = users.role
}).Distinct().ToList();
return(PartialView(model3));
}
public ActionResult viewAgenda()
{
HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
var username = ticket.UserData;
cdashEntities1 _db = new cdashEntities1();
var messageModel = from meetings in _db.meetings
where meetings.committee_name == commName
select new ViewAgendaMessageModel
{
Message_Agenda = meetings.Message_Agenda,
Post_date = meetings.creation_date
};
return(PartialView(messageModel));
}
public ActionResult Addmeetings()
{
HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
string uname = ticket.UserData;
cdashEntities1 _db = new cdashEntities1();
addMeetingViewModel m = new addMeetingViewModel();
//m.committee = (IEnumerable<SelectListItem>)(from c in _db.committee_Memberlist
// where c.Uname_ofMember == uname
// select c.name_ofCommittee).Distinct().ToList();
return(View());
}
public ActionResult TeamsBoard()
{
HttpCookie authCookie = Request.Cookies[FormsAuthentication.FormsCookieName];
FormsAuthenticationTicket ticket = FormsAuthentication.Decrypt(authCookie.Value);
Committee_Details commdetails = new Committee_Details();
cdashEntities1 _db = new cdashEntities1();
_db.Database.Connection.Open();
var username = ticket.UserData;
var model = (from mem in _db.committee_Memberlist
where mem.Uname_ofMember == username
select new Committee_Details()
{
Committee_Name = mem.name_ofCommittee,
Committee_Startdate = mem.member_joindate,
Committee_Enddate = mem.memeber_endate,
Committee_Active = "yes",
numberofpeople = (from com in _db.Committees where
mem.name_ofCommittee == com.Committee_Name
select com.numberofpeople).FirstOrDefault() ?? 0,
committee_Memberlist = (from com in _db.Committees
join com_members in _db.committee_Memberlist on
mem.name_ofCommittee equals com_members.name_ofCommittee
select com_members.Uname_ofMember).Distinct().ToList()
});
System.Diagnostics.Debug.WriteLine(model);
return(View(model));
}
