// GET: AdminAcademicYear/Details/5
public ActionResult Details(int?id)
{
user loggedIn = (user)Session["loggedIn"];
//check logged in?
if (loggedIn == null)
{
return(Redirect("~/Home/LoginPage"));
}
if (loggedIn.role.role_id < 1 || loggedIn.role.role_id > 2)
{
return(Redirect("~/Home/DeniedAccess"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
academic_years academic_years = db.academic_years.Find(id);
if (academic_years == null)
{
return(HttpNotFound());
}
return(View(academic_years));
}
public ActionResult Create([Bind(Include = "academic_year_id,academic_year_name,started_at,ended_at,deadline_ideas,deadline_comments")] academic_years academic_years)
{
user loggedIn = (user)Session["loggedIn"];
//check logged in?
if (loggedIn == null)
{
return(Redirect("~/Home/LoginPage"));
}
if (loggedIn.role.role_id < 1 || loggedIn.role.role_id > 2)
{
return(Redirect("~/Home/DeniedAccess"));
}
if (ModelState.IsValid)
{
if (academic_years.ended_at <= academic_years.started_at)
{
ViewBag.error = "End date must be after start date";
return(View(academic_years));
}
db.academic_years.Add(academic_years);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(academic_years));
}
public ActionResult MyIdeas(int?page)
{
//check logged in?
if (Session["loggedIn"] == null)
{
return(Redirect("~/Home/LoginPage"));
}
user user = ((user)Session["loggedIn"]);
//store page to return to proper page when visited Details page
Session["previousPage"] = Url.Action("MyIdeas", "Idea");
current_year = dbData.academic_years.Where(item => item.started_at <= DateTime.Now).Where(item => item.ended_at >= DateTime.Now).Single();
var display_Ideas = getAllDisplayIdeas().Where(item => item.idea.user_id == user.user_id).OrderByDescending(item => item.idea.created_at);
List <display_idea> display_IdeasList = getAllDisplayIdeas().Where(item => item.idea.user_id == user.user_id).ToList();
foreach (display_idea di in display_IdeasList)
{
if (di.new_comments)
{
display_Ideas = getAllDisplayIdeas().Where(item => item.idea.user_id == user.user_id).OrderByDescending(item => item.new_comments == true);
}
}
int pageSize = 5;
int pageNumber = (page ?? 1);
return(View(display_Ideas.ToPagedList(pageNumber, pageSize)));
}
public ActionResult DeleteConfirmed(int id)
{
academic_years academic_years = db.academic_years.Find(id);
db.academic_years.Remove(academic_years);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create()
{
//check logged in?
if (Session["loggedIn"] == null)
{
return(Redirect("~/Home/LoginPage"));
}
current_year = dbData.academic_years.FirstOrDefault(item => item.started_at <= DateTime.Now && item.ended_at >= DateTime.Now);
initIdealCreateComp(Session["cateCbb"] == null);
if (current_year.deadline_ideas < DateTime.Now)
{
ViewBag.error = "1";
}
//here
return(View());
}
public ActionResult Edit([Bind(Include = "academic_year_id,academic_year_name,started_at,ended_at,deadline_ideas,deadline_comments")] academic_years academic_years)
{
user loggedIn = (user)Session["loggedIn"];
//check logged in?
if (loggedIn == null)
{
return(Redirect("~/Home/LoginPage"));
}
if (loggedIn.role.role_id < 1 || loggedIn.role.role_id > 2)
{
return(Redirect("~/Home/DeniedAccess"));
}
if (ModelState.IsValid)
{
db.Entry(academic_years).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(academic_years));
}
public ActionResult Index(int?page, string idea_title, string name, string categoryID, string departmentID, string ideaStatus, string time_order, string pubFrom, string pubTo)
{
//check logged in?
if (Session["loggedIn"] == null)
{
return(Redirect("~/Home/LoginPage"));
}
if (Session["deptCbb"] == null)
{
List <department> departments = dbData.departments.ToList();
SelectList listItems = new SelectList(departments, "department_id", "department_name");
Session["deptCbb"] = listItems;
}
if (Session["cateCbb"] == null)
{
List <category> categories = dbData.categories.ToList();
SelectList listItems = new SelectList(categories, "category_id", "category_name");
Session["cateCbb"] = listItems;
}
//store page to return to proper page when visited Details page
Session["previousPage"] = Url.Action("Index", "Idea");
current_year = dbData.academic_years.Where(item => item.started_at <= DateTime.Now).Where(item => item.ended_at >= DateTime.Now).Single();
List <display_idea> display_Ideas = getAllDisplayIdeas().Where(item => item.idea.isEnabled == 1).ToList();
//--------filtering-------
//filter with title
display_Ideas = TitleFilter(display_Ideas, idea_title);
// filter with published user name
display_Ideas = UsernameFilter(display_Ideas, name);
//filter with category
display_Ideas = CategoryFilter(display_Ideas, categoryID);
//filter with department
display_Ideas = DepartmentFilter(display_Ideas, departmentID);
// filter for status
display_Ideas = StatusFilter(display_Ideas, ideaStatus);
// filter publish from to
display_Ideas = PublishFromFilter(display_Ideas, pubFrom, pubTo);
// filter for order
display_Ideas = OrderFilter(display_Ideas, time_order);
//--------End filtering-------
user loggedIn = ((user)Session["loggedIn"]);
ViewBag.currentUser = loggedIn;
int pageSize = 5;
int pageNumber = (page ?? 1);
return(View(display_Ideas.ToPagedList(pageNumber, pageSize)));
}
