public ActionResult LikeIdea(int idea_id)
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
int userId = Convert.ToInt32(Session["UserID"]);
if (context.Likes.Where(x => x.User_id == userId && x.Idea_id == idea_id).Any()) //checks if user has any inactive likes already stored in DB
{
context.Likes.Where(x => x.User_id == userId && x.Idea_id == idea_id).First().Active = true;
}
else
{
Like newLike = new Like();
newLike.Idea_id = idea_id;
newLike.User_id = userId;
newLike.Active = true;
context.Likes.Add(newLike);
}
context.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
return(View());
}
}
public ActionResult ApproverDashboard()
{
using (var context = new ENSE496Entities())
{
int teamId = Convert.ToInt32(Session["TeamID"]);
List <DataPoint> dataPoints = new List <DataPoint>();
List <DataPoint> ideasPerTeam = new List <DataPoint>();
var approvedIdeas = context.Ideas.Where(x => x.Status == "Approved").ToList();
foreach (Team team in context.Teams)
{
int num = 0 + approvedIdeas.Where(x => x.User.Team.Id == team.Id).Count();
dataPoints.Add(new DataPoint(team.Name.ToString(), num));
ideasPerTeam.Add(new DataPoint(team.Name.ToString(), context.Ideas.Where(x => x.User.Team.Id == team.Id).Count()));
}
List <DataPoint> teamStatusList = new List <DataPoint>();
teamStatusList.Add(new DataPoint("Pending", context.Ideas.Where(x => x.User.Team.Id == teamId && x.Status == "Pending").Count()));
teamStatusList.Add(new DataPoint("Parked", context.Ideas.Where(x => x.User.Team.Id == teamId && x.Status == "Parked").Count()));
teamStatusList.Add(new DataPoint("Approved", context.Ideas.Where(x => x.User.Team.Id == teamId && x.Status == "Approved").Count()));
teamStatusList.Add(new DataPoint("Declined", context.Ideas.Where(x => x.User.Team.Id == teamId && x.Status == "Declined").Count()));
List <DataPoint> teamContributionList = new List <DataPoint>();
var myTeam = context.Users.Where(x => x.Team_id == teamId).ToList();
foreach (User user in myTeam)
{
teamContributionList.Add(new DataPoint(user.Username.ToString(), context.Ideas.Where(x => x.User_id == user.Id).Count()));
}
ViewBag.DataPoints1 = JsonConvert.SerializeObject(dataPoints);
ViewBag.DataPoints2 = JsonConvert.SerializeObject(ideasPerTeam);
ViewBag.DataPoints3 = JsonConvert.SerializeObject(teamStatusList);
ViewBag.DataPoints4 = JsonConvert.SerializeObject(teamContributionList);
return(View());
}
}
public ActionResult Login(User userParam)
{
using (var context = new ENSE496Entities())
{
if (!string.IsNullOrEmpty(userParam.Username) && !string.IsNullOrEmpty(userParam.Hashed_password))
{
var user = context.Users.Where(u => u.Username == userParam.Username).FirstOrDefault();
if (user != null)
{
if (user.Hashed_password == userParam.Hashed_password)
{
Session["UserID"] = user.Id.ToString();
Session["Username"] = user.Username.ToString();
Session["UserType"] = user.Type.ToString();
if (user.Team_id.HasValue)
{
Session["TeamID"] = user.Team_id.Value;
}
else
{
Session["TeamID"] = 0;
}
return(RedirectToAction("Index"));
}
}
}
TempData["UserMessage"] = new MessageViewModel()
{
CssClassName = "alert-danger", Message = "You have entered an invalid username or password. Please try again"
};
return(RedirectToAction("Login"));
}
}
public ActionResult GeneralDashboard()
{
using (var context = new ENSE496Entities())
{
int userId = Convert.ToInt32(Session["UserID"]);
List <DataPoint> statusSummary = new List <DataPoint>();
statusSummary.Add(new DataPoint("Pending", context.Ideas.Where(x => x.Status == "Pending" && x.User_id == userId).Count()));
statusSummary.Add(new DataPoint("Parked", context.Ideas.Where(x => x.Status == "Parked" && x.User_id == userId).Count()));
statusSummary.Add(new DataPoint("Approved", context.Ideas.Where(x => x.Status == "Approved" && x.User_id == userId).Count()));
statusSummary.Add(new DataPoint("Declined", context.Ideas.Where(x => x.Status == "Declined" && x.User_id == userId).Count()));
List <DataPoint> myMostLikedIdeas = new List <DataPoint>();
var myIdeas = context.Ideas.Where(x => x.User_id == userId).ToList().OrderByDescending(x => x.Likes.Count).Take(5);
foreach (Idea idea in myIdeas)
{
myMostLikedIdeas.Add(new DataPoint("IDEA# " + idea.Id.ToString(), idea.Likes.Count()));
}
List <DataPoint> mostLikedIdeas = new List <DataPoint>();
var topIdeas = context.Ideas.ToList().OrderByDescending(x => x.Likes.Count).Take(10);
foreach (Idea idea in topIdeas)
{
mostLikedIdeas.Add(new DataPoint("IDEA# " + idea.Id.ToString(), idea.Likes.Count()));
}
ViewBag.DataPoints1 = JsonConvert.SerializeObject(statusSummary);
ViewBag.DataPoints2 = JsonConvert.SerializeObject(myMostLikedIdeas);
ViewBag.DataPoints3 = JsonConvert.SerializeObject(mostLikedIdeas);
return(View());
}
}
public ActionResult Notifications()
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
int userId = Convert.ToInt32(Session["UserID"]);
var notifictaions = context.Notifications.Where(x => x.Recipient_id == userId).ToList();
//if (ideas.Count > 0)
//{
// foreach (Idea idea in ideas)
// {
// idea.User.Username.First();
// if (idea.User.Team_id.HasValue)
// {
// idea.User.Team_id.GetValueOrDefault();
// }
// else
// {
// idea.User.Team_id = 0;
// }
// //idea.Subscriptions.Where(x => x.User_id == Convert.ToInt32(Session["UserID"]) && x.Idea_id == idea.Id).FirstOrDefault();
// idea.Subscriptions.ToList();
// }
//}
return(View(notifictaions));
}
else
{
return(RedirectToAction("Login"));
}
}
}
public ActionResult Subscribe(int idea_id)
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
int userId = Convert.ToInt32(Session["UserID"]);
//if (context.Subscriptions.Where(x => x.User_id == userId && x.Idea_id == idea_id).Any()) //checks if user has any inactive likes already stored in DB
//{
// context.Subscriptions.Where(x => x.User_id == userId && x.Idea_id == idea_id).First().Active = true;
//}
//else
//{
Subscription subscription = new Subscription();
subscription.Idea_id = idea_id;
subscription.User_id = userId;
subscription.Active = true;
context.Subscriptions.Add(subscription);
//}
context.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
return(RedirectToAction("Index"));
}
}
public ActionResult EditIdea(int id)
{
using (var context = new ENSE496Entities())
{
return(View(context.Ideas.Where(x => x.Id == id).First()));
}
}
public ActionResult SuccessStories()
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
string type = Session["UserType"].ToString();
int userId = Convert.ToInt32(Session["UserID"]);
var successIdeas = context.Ideas.Where(x => x.Status == "Approved").ToList();
if (type != "superapprover")
{
successIdeas = null;
successIdeas = context.Ideas.Where(x => x.OnSuccessStories == true).ToList();
}
if (successIdeas != null && successIdeas.Count > 0)
{
foreach (Idea idea in successIdeas)
{
idea.User.Username.First();
if (idea.User.Team_id.HasValue)
{
idea.User.Team_id.GetValueOrDefault();
}
else
{
idea.User.Team_id = 0;
}
idea.Subscriptions.ToList();
idea.Comments = context.Comments.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Comments.Count > 0)
{
foreach (Comment comment in idea.Comments)
{
comment.User.Username.First();
}
}
idea.Likes = context.Likes.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Likes.Count > 0)
{
foreach (Like like in idea.Likes)
{
like.User.Username.First();
}
}
}
}
//}
return(View(successIdeas));
}
else
{
return(RedirectToAction("Login"));
}
}
}
public ActionResult GetNotificationCount()
{
using (var context = new ENSE496Entities())
{
int userId = Convert.ToInt32(Session["UserID"]);
var count = context.Notifications.Where(x => x.Recipient_id == userId).Count();
return(PartialView(count));
}
}
public ActionResult DeleteIdea(int id)
{
using (var context = new ENSE496Entities()) {
context.Ideas.Remove(context.Ideas.Where(x => x.Id == id).FirstOrDefault());
context.Status_log.Remove(context.Status_log.Where(x => x.Idea_id == id).FirstOrDefault());
context.SaveChanges();
return(RedirectToAction("MyIdeas"));
}
}
public ActionResult ApproveIdea(int id)
{
using (var context = new ENSE496Entities())
{
Idea idea = context.Ideas.Where(x => x.Id == id).FirstOrDefault();
Status_log statusLog = new Status_log();
statusLog.Idea_id = id;
return(View(statusLog));
}
}
public ActionResult EditIdea(Idea ideaParam)
{
using (var context = new ENSE496Entities()) {
/****Need the Id to change the correct record in the db*/
//context.Ideas.Where(x => x.Id == ideaParam.Id).FirstOrDefault().Status = "Pending";
//context.Ideas.Where(x => x.Id == ideaParam.Id).FirstOrDefault().Title = ideaParam.Title;
//context.Ideas.Where(x => x.Id == ideaParam.Id).FirstOrDefault().Description = ideaParam.Description;
//****
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult CreateComment(Comment commentParam)
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
if (String.IsNullOrEmpty(commentParam.Comment1))
{
TempData["UserMessage"] = new MessageViewModel()
{
CssClassName = "alert-danger", Message = "You cannot leave the comment field empty..."
};
return(RedirectToAction("ViewIdea", new { id = commentParam.Idea_id }));
}
else
{
Idea idea = context.Ideas.Where(x => x.Id == commentParam.Idea_id).FirstOrDefault();
Comment newComment = new Comment();
newComment.Idea_id = commentParam.Idea_id;
newComment.Comment1 = commentParam.Comment1;
newComment.User_id = Convert.ToInt32(Session["UserID"]);
newComment.Submitted_on = DateTime.Now;
newComment.Active = true;
context.Comments.Add(newComment);
if (newComment.User_id != idea.User_id) //checks to see if status change was made by someone other than who submitted the idea
{
Notification notification = new Notification();
notification.Recipient_id = idea.User_id;
notification.Message = Session["Username"].ToString() + " has commented on your idea. (Idea #" + newComment.Idea_id.ToString() + ")";
notification.Active = true;
context.Notifications.Add(notification);
}
if (context.Subscriptions.Where(x => x.Idea_id == commentParam.Idea_id).Any())
{
var subs = context.Subscriptions.Where(x => x.Idea_id == commentParam.Idea_id).ToList();
foreach (Subscription sub in subs)
{
Notification notification = new Notification();
notification.Recipient_id = sub.User_id;
notification.Message = Session["Username"].ToString() + " has commented on an idea you are subscribed to. (Idea #" + commentParam.Idea_id.ToString() + ")";
notification.Active = true;
context.Notifications.Add(notification);
}
}
context.SaveChanges();
return(RedirectToAction("ViewIdea", new { id = commentParam.Idea_id }));
}
//}
}
return(View());
}
}
public ActionResult DismissNotification(int id)
{
using (var context = new ENSE496Entities())
{
var notification = context.Notifications.Where(x => x.Id == id).FirstOrDefault();
if (notification != null)
{
context.Notifications.Remove(notification);
context.SaveChanges();
}
return(RedirectToAction("Notifications"));
}
}
public ActionResult DeleteIdea(int id)
{
using (var context = new ENSE496Entities()) {
context.Status_log.RemoveRange(context.Status_log.Where(x => x.Idea_id == id).ToList());
context.Likes.RemoveRange(context.Likes.Where(x => x.Idea_id == id).ToList());
context.Comments.RemoveRange(context.Comments.Where(x => x.Idea_id == id).ToList());
context.Subscriptions.RemoveRange(context.Subscriptions.Where(x => x.Idea_id == id).ToList());
context.Ideas.Remove(context.Ideas.Where(x => x.Id == id).FirstOrDefault());
//context.Status_log.Remove(context.Status_log.Where(x => x.Idea_id == id).FirstOrDefault());
//context.Ideas.Where(x => x.Id == id).FirstOrDefault().Active = false;
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult SubscribedIdeas()
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
//var subbedIdeas = context.Subscriptions.Where(x => x.User_id == Convert.ToInt32(Session["UserID"])).ToList();
int userId = Convert.ToInt32(Session["UserID"]);
var ideas = context.Ideas.Where(x => x.Subscriptions.Any(y => y.User_id == userId)).ToList();
//var ideas = context.Ideas.Where(x => true).ToList();
//if (ideas.Count > 0)
//{
foreach (Idea idea in ideas)
{
idea.User.Username.First();
if (idea.User.Team_id.HasValue)
{
idea.User.Team_id.GetValueOrDefault();
}
else
{
idea.User.Team_id = 0;
}
idea.Subscriptions.ToList();
idea.Comments = context.Comments.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Comments.Count > 0)
{
foreach (Comment comment in idea.Comments)
{
comment.User.Username.First();
}
}
idea.Likes = context.Likes.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Likes.Count > 0)
{
foreach (Like like in idea.Likes)
{
like.User.Username.First();
}
}
}
//}
return(View(ideas));
}
else
{
return(RedirectToAction("Login"));
}
}
}
public ActionResult UnlikeIdea(int idea_id)
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
int userId = Convert.ToInt32(Session["UserID"]);
context.Likes.Where(x => x.User_id == userId && x.Idea_id == idea_id).First().Active = false;
context.Likes.RemoveRange(context.Likes.Where(x => x.User_id == userId && x.Idea_id == idea_id).ToList());
context.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
return(View());
}
}
public ActionResult Unsubscribe(int idea_id)
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
int userId = Convert.ToInt32(Session["UserID"]);
//var subs = context.Subscriptions.Where(x => x.User_id == userId && x.Idea_id == idea_id).ToList();
//context.Subscriptions.Where(x => x.User_id == userId && x.Idea_id == idea_id);
context.Subscriptions.RemoveRange(context.Subscriptions.Where(x => x.User_id == userId && x.Idea_id == idea_id).ToList());
context.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
return(RedirectToAction("Index"));
}
}
public ActionResult ApproveIdea(Status_log statusLogParam)
{
using (var context = new ENSE496Entities())
{
Idea idea = context.Ideas.Where(x => x.Id == statusLogParam.Idea_id).FirstOrDefault();
Status_log statusLog = new Status_log();
statusLog.Current_status = "Approved";
statusLog.Previous_status = idea.Status;
statusLog.Idea_id = statusLogParam.Idea_id;
statusLog.User_id = Convert.ToInt32(Session["UserID"]);
statusLog.Description = statusLogParam.Description;
context.Ideas.Where(x => x.Id == statusLogParam.Idea_id).FirstOrDefault().Status = "Approved";
context.Status_log.Add(statusLog);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
public ActionResult RemoveSuccessStories(int idea_id)
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
Idea idea = context.Ideas.Where(x => x.Id == idea_id).FirstOrDefault();
idea.OnSuccessStories = false;
context.SaveChanges();
return(Redirect(Request.UrlReferrer.ToString()));
}
else
{
return(RedirectToAction("Login"));
}
}
}
public ActionResult ViewIdea(int id)
{
using (var context = new ENSE496Entities())
{
var ideaViewModel = new IdeaViewModel();
ideaViewModel.Idea = context.Ideas.Where(x => x.Id == id).FirstOrDefault();
ideaViewModel.Comments = context.Comments.Where(x => x.Idea_id == id && x.Active == true).ToList();
if (ideaViewModel.Comments.Count > 0)
{
foreach (Comment comment in ideaViewModel.Comments)
{
comment.User.Username.First();
}
}
ideaViewModel.Likes = context.Likes.Where(x => x.Idea_id == id && x.Active == true).ToList();
return(View(ideaViewModel));
}
}
public ActionResult PlanIdea(Status_log statusLogParam)
{
using (var context = new ENSE496Entities())
{
if (ModelState.IsValid)
{
Idea idea = context.Ideas.Where(x => x.Id == statusLogParam.Idea_id).FirstOrDefault();
Status_log statusLog = new Status_log();
statusLog.Current_status = "Planned";
statusLog.Previous_status = idea.Status;
statusLog.Idea_id = statusLogParam.Idea_id;
statusLog.User_id = Convert.ToInt32(Session["UserID"]);
statusLog.Description = statusLogParam.Description;
context.Ideas.Where(x => x.Id == statusLogParam.Idea_id).FirstOrDefault().Status = "Planned";
context.Status_log.Add(statusLog);
if (idea.User_id != statusLog.User_id) //checks to see if status change was made by someone other than who submitted the idea
{
Notification notification = new Notification();
notification.Recipient_id = idea.User_id;
notification.Message = Session["Username"].ToString() + " has planned your idea. (Idea #" + statusLog.Idea_id.ToString() + ")";
notification.Active = true;
context.Notifications.Add(notification);
}
if (context.Subscriptions.Where(x => x.Idea_id == statusLog.Idea_id).Any())
{
var subs = context.Subscriptions.Where(x => x.Idea_id == statusLog.Idea_id).ToList();
foreach (Subscription sub in subs)
{
Notification notification = new Notification();
notification.Recipient_id = sub.User_id;
notification.Message = Session["Username"].ToString() + " has planned an idea you are subscribed to. (Idea #" + statusLog.Idea_id.ToString() + ")";
notification.Active = true;
context.Notifications.Add(notification);
}
}
context.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
}
public ActionResult CreateIdea(Idea ideaParam)
{
using (var context = new ENSE496Entities()) {
if (Session["UserID"] != null)
{
if (ModelState.IsValid)
{
Idea newIdea = new Idea();
newIdea.Title = ideaParam.Title;
newIdea.Description = ideaParam.Description;
newIdea.User_id = Convert.ToInt32(Session["UserID"]);
newIdea.Status = "Pending";
context.Ideas.Add(newIdea);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View());
}
}
public ActionResult EditIdea(Idea ideaParam)
{
using (var context = new ENSE496Entities()) {
if (ModelState.IsValid)
{
context.Ideas.Where(x => x.Id == ideaParam.Id).First().Title = ideaParam.Title;
context.Ideas.Where(x => x.Id == ideaParam.Id).First().Description = ideaParam.Description;
//if (ideaParam.User_id != Convert.ToInt32(Session["UserID"])) //checks to see if edit was made by someone other than who submitted the idea
//{
// Notification notification = new Notification();
// notification.Recipient_id = ideaParam.User_id;
// notification.Message = Session["Username"].ToString() + " has edited your idea. (Idea #" + ideaParam.Id.ToString() + ")";
// notification.Active = true;
// context.Notifications.Add(notification);
//}
//if (context.Subscriptions.Where(x => x.Idea_id == ideaParam.Id).Any())
//{
// var subs = context.Subscriptions.Where(x => x.Idea_id == ideaParam.Id).ToList();
// foreach (Subscription sub in subs)
// {
// Notification notification = new Notification();
// notification.Recipient_id = sub.User_id;
// notification.Message = Session["Username"].ToString() + " has edited an idea you are subscribed to. (Idea #" + ideaParam.Id.ToString() + ")";
// notification.Active = true;
// context.Notifications.Add(notification);
// }
//}
context.SaveChanges();
//if (ideaParam.User_id != statusLog.User_id) //checks to see if edit was made by someone other than who submitted the idea
//{
// Notification notification = new Notification();
// notification.Recipient_id = idea.User_id;
// notification.Message = Session["Username"].ToString() + " has parked your idea. (Idea #" + statusLog.Idea_id.ToString() + ")";
// notification.Active = true;
// context.Notifications.Add(notification);
//}
return(RedirectToAction("Index"));
}
return(View());
}
}
// GET: User
public ActionResult Index()
{
using (var context = new ENSE496Entities()) {
if (Session["UserID"] != null)
{
var ideas = context.Ideas.Where(x => true).ToList();
if (ideas.Count > 0)
{
foreach (Idea idea in ideas)
{
idea.User.Username.First();
}
}
return(View(ideas));
}
else
{
return(RedirectToAction("Login"));
}
}
}
public ActionResult MyIdeas()
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
int UserID = Convert.ToInt32(Session["UserID"]);
var ideas = context.Ideas.Where(x => x.User_id == UserID).ToList();
if (ideas.Count > 0)
{
foreach (Idea idea in ideas)
{
idea.User.Username.First();
idea.Subscriptions.ToList();
idea.Comments = context.Comments.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Comments.Count > 0)
{
foreach (Comment comment in idea.Comments)
{
comment.User.Username.First();
}
}
idea.Likes = context.Likes.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Likes.Count > 0)
{
foreach (Like like in idea.Likes)
{
like.User.Username.First();
}
}
}
}
return(View(ideas));
}
else
{
return(RedirectToAction("Login"));
}
}
}
public ActionResult MyIdeas()
{
using (var context = new ENSE496Entities())
{
if (Session["UserID"] != null)
{
int UserID = Convert.ToInt32(Session["UserID"]);
var ideas = context.Ideas.Where(x => x.User_id == UserID).ToList();
if (ideas.Count > 0)
{
foreach (Idea idea in ideas)
{
idea.User.Username.First();
}
}
return(View(ideas));
}
else
{
return(RedirectToAction("Login"));
}
}
}
//jin's code
public ActionResult PendingIdeas()
{
using (var context = new ENSE496Entities())
{
string type = Session["UserType"].ToString();
if ((Session["UserID"] != null) && (type == "approver"))
{
var ideas = context.Ideas.Where(x => true).ToList();
if (ideas.Count > 0)
{
foreach (Idea idea in ideas)
{
idea.User.Username.First();
}
}
return(View(ideas));
}
else
{
return(RedirectToAction("Index"));
}
}
}
public ActionResult CreateIdea(Idea ideaParam)
{
using (var context = new ENSE496Entities()) {
if (Session["UserID"] != null)
{
if ((String.IsNullOrEmpty(ideaParam.Title)) || (String.IsNullOrEmpty(ideaParam.Description)))
{
TempData["UserMessage"] = new MessageViewModel()
{
CssClassName = "alert-danger", Message = "You have left either the title or description empty"
};
return(RedirectToAction("CreateIdea"));
}
else if (ideaParam.Title.Length > 255)
{
TempData["UserMessage"] = new MessageViewModel()
{
CssClassName = "alert-danger", Message = "The title must be less than 256 characters"
};
return(RedirectToAction("CreateIdea"));
}
else
{
Idea newIdea = new Idea();
newIdea.Title = ideaParam.Title;
newIdea.Description = ideaParam.Title;
newIdea.User_id = Convert.ToInt32(Session["UserID"]);
newIdea.Status = "Pending";
context.Ideas.Add(newIdea);
context.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View());
}
}
public ActionResult PendingIdeas()
{
using (var context = new ENSE496Entities())
{
string type = Session["UserType"].ToString();
if ((Session["UserID"] != null))
{
int userId = Convert.ToInt32(Session["UserID"]);
int myTeamId;
if (context.Users.Where(x => x.Id == userId).First().Team_id.HasValue)
{
myTeamId = context.Users.Where(x => x.Id == userId).First().Team_id.Value;
}
else
{
myTeamId = 0; //if user does not have team id assigned
}
if (type == "superapprover")
{
var ideas = context.Ideas.Where(x => x.Status == "Pending").ToList();
if (ideas.Count > 0)
{
foreach (Idea idea in ideas)
{
idea.User.Username.First();
idea.Subscriptions.ToList();
idea.Comments = context.Comments.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Comments.Count > 0)
{
foreach (Comment comment in idea.Comments)
{
comment.User.Username.First();
}
}
idea.Likes = context.Likes.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Likes.Count > 0)
{
foreach (Like like in idea.Likes)
{
like.User.Username.First();
}
}
}
}
return(View(ideas));
}
else if (type == "approver")
{
var ideas = context.Ideas.Where(x => x.Status == "Pending" && x.User.Team.Id == myTeamId).ToList();
if (ideas.Count > 0)
{
foreach (Idea idea in ideas)
{
idea.User.Username.First();
idea.Subscriptions.ToList();
idea.Comments = context.Comments.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Comments.Count > 0)
{
foreach (Comment comment in idea.Comments)
{
comment.User.Username.First();
}
}
idea.Likes = context.Likes.Where(x => x.Idea_id == idea.Id && x.Active == true).ToList();
if (idea.Likes.Count > 0)
{
foreach (Like like in idea.Likes)
{
like.User.Username.First();
}
}
}
}
return(View(ideas));
}
else
{
RedirectToAction("Index");
}
}
else
{
return(RedirectToAction("Login"));
}
}
return(RedirectToAction("Login"));
}
